1 / 15

DSS Datagroup Maintenance Documentation

DSS Datagroup Maintenance Documentation. Prepared by Sara Chamber March 7, 1997 last updated August 16, 2000. Process for Accounts Receivable Datagroups. es49 DSS1PRD (ODS_FIS). es05 FIS1PRD. 1. Build Datagroups. dss_ar_build_dg.sh from #1

tarak
Download Presentation

DSS Datagroup Maintenance Documentation

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. DSS Datagroup Maintenance Documentation Prepared by Sara Chamber March 7, 1997 last updated August 16, 2000

  2. Process for Accounts Receivable Datagroups es49 DSS1PRD (ODS_FIS) es05 FIS1PRD 1. Build Datagroups dss_ar_build_dg.sh from #1 ar_cust_inv_gt ar_cust_pmt_gt ar_cust_gt ar_inv_itm_gt ar_pmt_itm_gt also depends on: fs_universal_usr_t ca_account_t ca_org_t Oracle Replication es49 ODS1PRD (FIS) Database Link

  3. Process for Capital Asset Management Datagroups 1. Build Datagroups es49 DSS1PRD (ODS_FIS) es05 FIS1PRD dss_cm_create_cm_asset_gt.sh dss_cm_create_cm_borrower_gt.sh dss_cm_create_cm_payment_gt.sh dss_cm_create_cm_retire_gt.sh dss_cm_create_cm_warranty_gt.sh dss_cm_create_cm_pretag_gt.sh dss_cm_create_cb_pnd_inv_itm_gt.sh Oracle Replication 2. Custom Reconciliation (wkly) dss_cm_cust01_rec.sh from #1 cm_retire_gt cm_borrower_gt cm_warranty_gt cb_pnd_inv_itm_gt es49 ODS1PRD (FIS) Database Link 3. Datagroup Reconciliation (wkly) dss_cm_base_rec.sh from #1 cm_asset_gt cm_payment_gt

  4. Process for Bursar/Cashiering Datagroups es49 DSS1PRD (ODS_FIS) es05 FIS1PRD 1. Build Datagroups dss_bcr_build_dg.sh fp_b_itm_inproc_gt fp_bursar_ctrl_gt fp_cash_rcpt_gt fp_csh_rcpt_dtl_gt fp_deposit_gt fp_dpst_crcpt_gt Oracle Replication es49 ODS1PRD (FIS) Database Link

  5. Process for Purchasing System Datagroup es05 FIS1PRD 2. Daily Datagroup Builds dss_ps_build_dg.sh from #1 builds ps_po_gt Oracle Replication es49 ODS1PRD (FIS) es49 DSS1PRD (ODS_FIS, DSS) Database Link IUIS DB2 database 1. Daily FTP DE8001ps (runs on IUIS) ps_po_gt.dat

  6. Process for Chart of Accounts Datagroups es05 FIS1PRD 3. Daily Sparky Build 2. Daily Load Tables dss_ca_sparky_build_dg.sh loads ca_iuf_acct_gt dss_load_fs_universal_usr_t.sh builds fs_universal_usr_t Oracle Replication 4. Daily Datagroup Builds dss_ca_build_dg.sh builds ca_org_hier_gt fp_rpt_cd_hier_gt es49 ODS1PRD (FIS) es49 DSS1PRD (ODS_FIS, DSS) Database Link 5. Wkly Datagroup Build dss_ca_build_dg_wkly.sh builds ca_dss_project_gt ca_acct_dlgt_gt 6. Wkly Datagroup Reconciliation IUIS DB2 database 1. Daily FTP for fs dss_ca_base_rec.sh from #5 for ca_acct_dlgt_gt dss_ca_cust01_rec.sh from #5 for ca_dss_project_gt dss_ca_sparky_rec.sh from #3 for ca_iuf_acct_gt de8001ui (runs on IUIS) ftp fs_universal_usr_t.dat

  7. Process for Contract & Grants Datagroups es05 FIS1PRD 2. Build Datagroups 3. Build Datagroups 2 dss_cg_build_dg.sh cg_awd_acct_gt cg_awd_org_gt cg_awd_prjdr_gt cg_awd_subcn_gt cg_agency_hier_gt cg_prpsl_org_gt cg_prpsl_prjdr_gt cg_prpsl_subcn_gt dss_cg_build_dg2.sh cg_sum_agncytyp_gt cg_sum_by_org_gt cg_prpsl_gt cg_award_gt Oracle Replication es49 ODS1PRD (FIS) es49 DSS1PRD (ODS_FIS) Database Link 4. Datagroups Reconciliation (wkly) dg_reconcile.pl from #2,3: cg_award_gt cg_awd_acct_gt cg_awd_org_gt cg_awd_prjdr_gt cg_awd_subcn_gt cg_prpsl_gt cg_prpsl_org_gt cg_prpsl_prjdr_gt cg_prpsl_subcn_gt IUIS DB2 database 1. Daily FTP to IUIS dss_cg_put_ops_tables.sh ftps data to IUIS

  8. Process for General Ledger Datagroups 2. Incremental Updates dss_process_gl_entry_temp_t.sh from #1 applies ri changes from ca appends gl_entry new rows to update gl_detail_gt dss_gbl_build_dg_incr.sh from #1 updates daily changes to gl_balance_t dss_gl_build_dg_incr.sh from #1 updates changes to gl_acct_obj_bal_gt dss_load_gl_ccrd_dtl_gt_incr.sh from #1 updates changes to gl_ccrd_dtl_gt dss_load_id_bill_gt.sh from #1 updates changes to gl_id_bill_gt es49 ODS1PRD (FIS) es05 FIS1PRD Oracle Replication 1. Daily Incremental FTP’s Database Link de8002gl - gl_entry_temp_t.dat de8003gl - gl_balance_t.dat de8001id - gl_id_bill_gt.dat ds8001cv - gl_ccrd_dtl_gt.dat de8001gl - gl_acct_obj_bal_gt.dat es49 DSS1PRD (ODS_FIS, DSS) 4. Build Datagroups-CA Each built by it’s own script from #3 dss_load_ca_acctorg_gt.sh dss_load_ca_object_gt.sh dss_load_ca_subacct_gt dss_load_ca_subobj.gt 3. Daily Full FTP’s -gl/ca de8001ca - ca_acctorg_gt.dat de8002ca - ca_object_gt.dat de8003ca - ca_subacct_gt.dat de8004ca - ca_subobj_gt.dat 6. Daily Customized Reconciliation dss_gl_cust01_rec.sh from #5 ca_acctorg_gt ca_object_gt gl_detail_gt gl_balance_t gl_acct_obj_bal_gt ca_subacct_gt ca_subobj_gt fs_universal_usr_t IUIS DB2 database 5. Daily Reconciliation Extracts -gl/ca de8001dr - ca_account_t_rec.dat, ca_object_code_t_rec.dat ca_sub_acct_t_rec.dat, ca_sub_object_t_rec.dat de8002dr - fs_universal_usr_t_rec.dat de8003dr - gl_balance_t_rec.dat de8004dr - gl_entry_t_rec.dat, fis_iuis_rr.done

  9. Process for GL & CA Data Reconciliation Back to IUIS Sources 1. Daily Incr FTP (gl_detail) es49 DSS1PRD (DSS) de8002gl - gl_entry_temp_t.dat 2. Daily Incr FTP (gl_balance) de8003gl - gl_balance_t.dat 3. Daily Incr GL FTP to es49 de8001gl - gl_acct_obj_bal_gt.dat 5. Daily FTP to es49 (ca dgs) de8001ca - ca_accctorg_gt.dat de8002ca - ca_object_gt.dat de8003ca - ca_subacct_gt.dat de8004ca - ca_subobj_gt.dat 4. Daily FS FTP to es49 7. Load Table - fs de8001ui -fs_universal_usr_t.dat dss_load_fs_universal_usr_t.sh from #4 fs_universal_usr_t 8. Build Datagroups - gl/ca 9. Dtgrp Reconciliation Extracts (daily) dss_gl_build_dg_incr.sh from #3 gl_acct_obj_bal_gt From #5: dss_load_ca_acctorg_gt.sh dss_load_ca_object_gt.sh dss_load_ca_subacct_gt.sh dss_load_ ca_subobj_gt de8001dr - ca_account_t_rec.dat ca_object_code_t_rec.dat ca_sub_acct_t_rec.dat ca_sub_object_t_rec.dat de8002dr - fs_universal_usr_t_rec.dat de8003dr - gl_acct_obj_bal_gt_rec.dat de8004dr - gl_entry_t_rec.dat de8005dr - gl_balance_t_rec.dat de8006dr - fis_iuis_rr.done IUIS DB2/VSAM 10. Dtgrp Reconc - gl/ca (daily) dss_gl_cust_rec.sh from #9 ca_acctorg_gt ca_object_gt ca_subacct_gt ca_subobj_gt gl_detail_gt gl_balance_t gl_acct_obj_bal_gt fs_universal_usr_t 6. Daily Incremental Updates - gl process_gl_entry_temp_t.sh gl_detail_gt (from #1) gbl_build_dg.sh gl_balance_t (from #2)

  10. Process for Human Resources Database IUIS DB2/vsam 2. Frozen Interim Personnel hu2300ip cobol extract from vsam manual ftp hu_build_1978_85.sh built hu_1978_85_emp_gt hu_78_85_stfapt_gt hu_78_85_acdapt_gt hu_78_85_acadtl_gt 1b. Extract & FTP to IUDSS de8001hu de8002hu de8003hu de8004hu de8005hu de8006hu de8007hu 1a. Fall/Spring DOF Site Submit & 1c. Build DOF Datagroups iudss syb_dss_prod (hu_dss_d) hu_build_dg.sh site submit of de8001hu (#1b) to IUIS then (1c) from 1b builds: hu_xxf_acadtl_gt hu_xxf_bene_gt hu_xxf_dept_gt hu_xxf_emp_gt hu_xxf_emp_paf_gt hu_xxf_emp_sof_gt where xx = year

  11. Process for Labor Distribution Datagroups es49 DSS1PRD (ODS_FIS) es05 FIS1PRD 1. Build Datagroups dss_ld_build_dg.sh ld_job_gt ld_pos_gt ld_pos_hist_gt dss_ld_build_dg2.sh ld_pos_prsn_gt ld_pos_histprsn_gt ld_csf_tracker_gt. Oracle Replication 2. Incr. Build Datagroups es49 ODS1PRD (FIS) dss_ld_ldgr_build_dg_incr.sh ld_ldgr_bal_t Database Link 3. Custom Reconciliation (daily) dss_ld_cust01_rec.sh ld_ldgr_bal_t

  12. Process for Student Advising Database 4. Weekly BCP Updates Lincoln syb_prod rs/ltm ad_get_op_tables.sh for ad_advs_sesn_t ad_sesn_2nd_prps_t ad_advsr_hr_t ad_cntct_t ad_sesn_prps_cd_t ad_pgm_plan_t ad_stu_cntct_cd_t ad_rfrl_t ad_stu_rfrl_cd_t ad_wthd_t ad_wthd_ctgry_cd_t ad_wthd_plan_cd_t ad_wthd_reas_cd_t ad_wthd_reas_t 2. Daily BCP Updates ad_get_op_tables.sh for ad_advs_sesn_t iudss syb_dss_prod (ad_dss_d) ad_advr_grp_t ad_advsr_res_hl_t ad_advsr_t ad_grp_cd_t ad_res_hl_cd_t ad_stu_advsr_t ad_stu_int_cd_t ad_stu_int_t ad_stu_pgm_cd_t ad_stu_pgm_t ad_stu_pre_pro_t ad_stu_prepro_cd_t ad_stu_t 3a. FTP ,Site Submit & 3c. Build Datagroups ad_build_dg.sh -- from #1 & #2 ftp’s stuid stat_cd & semyr to IUIS site submit of de8001ad (#3b) then builds: ad_udiv_extrt_gt ad_advsr_asgn_gt ad_stu_pgm_gt ad_advsr_grp_gt ad_stu_prepro_gt ad_stu_int_gt 1. Rep Server Updates 5. Build Weekly Datagroups IUIS VSAM files 3b. Extract & FTP to iudss ad_build_dg_wkly.sh -- from #4 builds: ad_advsr_hr_ gt ad_advsr_cntct_gt ad_stu_advs_cnt_gt ad_advsr_actn_gt ad_advsr_rfrl_gt ad_stu_wthd_gt ad_wthd_reason_gt de8001ad - ad_udiv_extrt_gt.dat 4. Daily Mailer FTP to IUIS ad_build_stu_mail_gt.sh builds ad_stu_adv_mail_gt then ftp’s ad_stu_adv_mail_gt ad_stu_pgm_gt from #3 6. Weekly Datagroup Purge/Copy ad_purge_wkly.sh -- from #3c builds: ad_old_prepro_gt ad_old_stu_int_gt

  13. Process for Student Coursework & Shared Student DB2 Databases (GradPact) IUIS DB2/vsam 1. Extract Current GradPact de9300gp (extract from gradpact and stud files) 2. Build Current GradPact sc2010ce - from #1 GP_CUR_PACT_ENR_GT 3. Extract Historical GradPact 5. Wkly Extract Current Enrollment Period de9101gp (extract from pacthist and stud files) de9300ss (extract from ddd tbl) 4. Build Historical Datagroups 6. Wkly Build Current Enrollment Period sc2010he - from #3 GP_HST_PACT_ENR_GT sc2010pc - from #3 GP_PGM_CHG_GT sc2010gn - from #3 GP_PACT_NOTE_GT sc2010ep - from #5 SS_CUR_ENRL_PRD_GT

  14. Lincoln syb_prod rs/ltm Process for Student Orientation Database iudss syb_dss_prod (so_dss_d) 3c. FTP Extract to Lincoln de8001so - so_ornt_extrt_gt.dat 1. Rep Server Updates so_fee_pay_cd_t so_stu_pgm_t so_pgm_cd_t so_stu_t 2a. FTP Adms Updates to Lincoln wm8001xd - orntadms.dat/.done 3a. FTP, Site Submit & 3d. Build Datagroups so_build_dg.sh from #1&2a ftp’s stuid & semyr data to IUIS site submit of de8001so (#3b/3c) (3d) then builds: so_ornt_extrt_gt so_stu_ornt_cnts_gt so_stu_ornt_pgm_gt so_ornt_mail_gt IUIS VSAM files 3b. Extract & FTP to iudss de8001so - so_ornt_extrt_gt.dat 2b. FTP .done to iudss wm8001xd - orntadms.done

  15. Process for Tax-Relief Lincoln syb_ss_prod (tr_tra_d) 5. Yearly FTP Credit-Ready (Lincoln) 3. Daily Datagroup Build (IUDSS) 1. Daily bcp (Lincoln to IUDSS) load_tr_cr_1098t.sh ftp: tr_credit_dwnld_rdy.done * This has yet to be implemented. For now the .done file is “touched” manually when the yearly job is to run. dss_tr_build_dg.sh: tr_cr_w9s_stat_gt (se_enrld_student_mt) dss_tr_get_op_tables.sh: tr_tax_yr_stat_t tr_non_cr_grp_t tr_fee_pmt_t tr_fee_cd_t tr_evnt_cd_t tr_cr_sidn_chg_t tr_host_cd_t tr_tra_cr_grp_t tr_cr_1098t_dtl_t tr_cr_1098t_sum_t tr_appl_sec_t 6. Control Wkly/Yrly jobs (run daily on IUDSS) dss_tr_cntrl_wkly_yrly.sh 4. Wkly “touch” (crontab / IUDSS) #1 tr_noncredit_weekly_rdy.done es49 DSS1PRD (DSS) 8. Yrly Datagroup Build 7. Wkly Datagroup Build dss_tr_build_dg_yrly.sh: tr_all1098t_sum_gt tr_all1098t_dtl_gt tr_noncr_evnt_gt tr_cr_sidn_chg_gt tr_tax_yr_stat_gt (current tax-yr credit data, AND, non-credit rows of unfrozen tax-yrs, ) dss_tr_build_dg_wkly.sh: tr_all1098t_sum_gt tr_all1098t_dtl_gt tr_noncr_evnt_gt tr_cr_sidn_chg_gt tr_tax_yr_stat_gt (non-credit rows of unfrozen tax-yrs only) 2. Daily FTP Student File (IUIS / CA7) IUIS DB2/vsam StudSect / HICRSE DE8001TR ftp: tr_student.dat tr_student.done #1 - If tr_credit_dwnld_rdy.done exists then run tr_build_dg_yrly.sh else if tr_noncredit_weekly_rdy.done exits then run tr_build_dg_wkly.sh

More Related