General Information
Email/Listserv
SQL Scripts for Batch
All SQL scripts developed to support KFS batch processes must be stored in Git as well as copied to the KFS Batch nodes (PRD & UAT). The git 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.
GIT directory path:
kfs5/uconn/db/batch
Batch Nodes 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 | On Request |
| 175-RICE-Auto-FYI-aged-eDocs.sql | PRD-KFS-Auto-FYI-Aged-eDocs | On Request |
Nightly
Discusses the business process supported by the nightlybatch and provides a high level overview (flow) of the process. The detailed jobs and their functions should be documented in the section "NightlySchedule"
<add link to page on which weekly process document is stored or insert in line>
To Be Added:
<description of batch process and tools>
- batch schedules
- batch contacts (monthly on call schedule)
Nightly Schedule
List of Jobs & run times
Weekly
Discusses the business process supported by the weekly batch and provides a high level overview (flow) of the process. The detailed jobs and their functions should be documented in the section "Weekly Schedule"
<add link to page on which weekly process document is stored or insert in line>
To Be Added:
<description of batch process and tools>
batch schedules
batch contacts (monthly on call schedule)
Weekly Schedule
<To be added>
Bi-Weekly (paycheck week)
Month End
The KFS month end process supports functionality needed by OSP ....<Brett to complete>