9.2 Daily SF Fund Balancing to the GL

Purpose:  Use this document as a reference to the automated job process in ctcLink which stages financial transactions from SF, fund balances those entries, and then delivers that data to Finance. 

Audience:  Bursar, Student Financials staff, Accounting staff.

You must have at least one of these local college managed security roles:

  • ZD_DS_QUERY_VIEWER

If you need assistance with the above security roles, please contact your local college supervisor or IT Admin to request role access.

This automated job consists of running several processes and is managed by the SBCTC.

Daily SF Fund Balancing to the GL

Non-Student Related Nightly Fund Balancing Transactions (E-215)

Job # C9990006 (E-215) 

  1. This job takes the non-student related transactions, sums those transactions by accounting line (called fund balancing,) and then batch publishes the data to the finance pillar. The job process runs nightly at 10:00pm.

Use the below queries to confirm each step has been processed.

For the cashiering entries, use:

QCS_SF_E215_ACCTG_LN

QCS_SF_E215_ACCTG_LN_JGEN

QCS_SF_E215_FUND_BAL

Student Related Nightly Fund Balancing Transactions (E-214)

Job #C9990007 (E-214)

  1. This job takes the student related transactions, sums those transactions by accounting line (called fund balancing,) and then batch publishes the data to the finance pillar. The job process runs Monday - Friday at 10:30pm.

Use the below queries to confirm each step has been processed.

For the accounting entries, use:

QCS_SF_E214_ACCTG_LN

QCS_SF_E214_ACCTG_LN_JGEN

QCS_SF_E214_FUND_BAL

What happens if Fund Balancing (E215 & E214) fails?  If a journal has been created, delete it and allow it to be recreated via the following nightly job run.

  1. Process complete.

0 Comments

Add your comment

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.