...
All SQL scripts developed to support KFS batch processes must be stored in Subversion as well as copied to the KFS Batch nodes (PRD & UAT). The svn version represents the master copy of the script and will always be checked out and in when changes are made. In addition, the developer making the change to the script is responsible for creating a JIRA for the CM or Server Admin to transfer the updated script to the batch nodes. The transfer should made to UAT first for User Acceptance Testing and then transferred to PRD Batch at scheduled deployment based on User Acceptance.
Path Names:
UAT - /srv/uconn_configs/kfs-config/work/dev/kfs/sql
Prod - /srv/uconn_configs/kfs-config/work/prd/kfs/sql
Script | Job | Schedule |
077-KFS-1525-BalanceForward-p.sql | PRD-KFS-SQLBalanceForward | Year End |
078-KFS-1525-Nominal-p.sql | PRD-KFS-SQLNominal | Year End |
079-RICE-130-UpdMFParm-NF.sql | PRD-KR-SQLUpdateMFParm-NF | Year End |
080-RICE-130-UpdMFParm-PF.sql | PRD-KR-SQLUpdateMFParm-PF | Year End |
081-RICE-130-UpdMFParm-MF.sql | PRD-KR-SQLUpdateMFParm-MF | Year End |
084-KFS-1538-DVFiscalDataRollforward.sql | PRD-KFS-SQLDVRollForwardJob | Daily, Friday, Month-end |
095-KFS-1584-LetterOfCreditPRJEUpdate.sql | PRD-KFS-LetterOfCreditPRJEUpdateJob | Friday, Month-end |
096-KFS-1584-RevenueRecognitionPRJEUpdate.sql | PRD-KFS-RevenueRecognitionPRJEUpdateJob | Month-end |
097-RICE-1584-LetterOfCreditPARMUpdate.sql | PRD-KR-LetterOfCreditPARMUpdateJob | Friday, Month-end |
098-RICE-1584-PRJEProcessOrderParmNullUpdate.sql | PRD-KR-PRJEProcessOrderParmNullUpdateJob | Friday, Month-end |
099-RICE-1584-RevenueRecognitionParmUpdate.sql | PRD-KR-RevenueRecognitionParmUpdateJob | Month-end |
100-KFS-1584-FiscalPeriodUpdate.sql | PRD-KFS-FiscalPeriodUpdateJob | Month-end |
| 172-RICE-Auto-Acknowledge-aged-eDocs.sql | PRD-KFS-Auto-Acknowledge-Aged-eDocs | ??? |
| 175-RICE-Auto-FYI-aged-eDocs.sql | PRD-KFS-Auto-FYI-Aged-eDocs | ??? |
...