Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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"

...

  • batch schedules

  • batch contacts (monthly on call schedule)

Weekly Schedule 

KFS.vsd

<To be added> 

Bi-Weekly (paycheck week)

...

KFS - Month End Processing 


Prorated Journal Entry / Automated Journal Voucher (PRJE / AJV)

...