FMS Job Scheduling
BAxxxxJ BMxxxxJ FMxxxxJ GAxxxxJ MMxxxxJ PMxxxxJ FGxxxx Other

FG077R
General Ledger Extract Rpts

This job group extracts account detail information for on request reporting. This group allows the data to be selected by campus, appropriation index, AND/OR program/ organization index.
Special Instructions All FMS Daily Processing must be completed before this job group begins. The parameters that appear will depend on the jobs that are selected.
Operator Instructions GA1301J : N


Job Group Definition

Req/
Opt
Seq # Prior
Seq #
Job
Number
Description/Reports
R 01 GA1301J
GL Detail Report Extract
R 02 01 GA1395J
GL Detail Subset Extract
O 03 02 GA1330J
Monthly Transaction Register
  Monthly Transaction Register (GA1330)
O 04 03 FG079R
Subset Monthly Oper Report
    GA3237J
Encumbrance Extract For Monthly Operations
    GA3238J
Encumbrance Subset Extract
    GA3230J
Monthly Operations Expenditure Report
  Monthly Operations Expenditure Report (GA3230)
O 05 04 GA2103J
Detail Revenue Report
  Detail Revenue Report (GA2103)
O 06 05 GA1333J
Monthly Reconciliation by Batch of Cash Ledgers
  Monthly Reconciliation by Batch of Cash Ledgers (GA1333)
R 07 06 GA1397J
Accounting Extract Purge


Parameters

APPR-INDX-SEL An array of up to 15 APPR-INDX's to be selected. The format is XXX,XXX,...
CAMPUS-SEL The campus code to be selected for reporting
GA1330-CMP-SRT Y = Yes, sort by campus
N = No, do not sort by campus
GA2103-ALPHA-SRT Y = Yes, sort on trns-desc within subsource
N = No, do not sort on trns-desc within subsource
GA2103-CMP-SRT Y = Yes, sort by campus
N = No, do not sort by campus
. ALPHA CMP SORT SORT
. N Y Campus, Program, Organization Appropriation, General Ledger Source Revenue, Sub Source, Transaction Code, Trans Reversal Code, Batch Number, Document Number Transaction Description
. Y N Campus, Program, Organization Appropriation, General Ledger Source Revenue, Sub Source Revenue, Transaction Description
. N N Program, Organization, General Ledger, Source Revenue, Sub-source Revenue, Transaction Code, Trans Reversal Code, Batch Number, Document Number, Transaction Description
. Y Y Program, Organization, Appropriation, General Ledger Source Revenue, Sub-source Reveneue, Transaction Description
GA3230-CMP-SRT Y = Yes, sort by campus
N = No, do not sort by campus
GA3230-GRP-OPT Y = Yes, sort by program/organization group
N = No, do not sort by program/organization group
GA3230-RPT-OPT Y = Yes, summarize transactions through REF-DOC-NUM (Order Num)
N = No, do not summarize transactions through REF-DOC-NUM; summarize through DOC-NUM
MO13-RPT-IND 0 = Normal month end reporting
1 = 13th/25th month. Exclude 12th month.
PRG-ORG-SEL The program/organization to be selected for reporting. If ORG-INDX is left blank, then selection will be on the PRG-INDX only.
YR-MO The year-month to be processed (YYMM).

Distribution: FMS
Created: FRI, JUL 31, 2015, 03:08 PM