General Ledger Parameters

Functionality	Parameter Name	Purpose	Sample Values	Allow or Deny
Balances By Consolidation Lookup	BASIC_ACCOUNTING _CATEGORY_REPRESENTING _EXPENSES	The basic accounting category type which will represent expenses in Account Balance by Consolidation look ups.	EX	A
Beginning Balance Roll Forward	BALANCE_TYPES _TO_ROLL_FORWARD _FOR_BALANCE_SHEET	The balance type(s) that will be considered when bringing assets, liabilities, and fund balance forward to the new fiscal year.	AC;NB	A
Beginning Balance Roll Forward	BALANCE_TYPES _TO_ROLL_FORWARD _FOR_INCOME_EXPENSE	The balance type(s) that will be considered when bringing income and expenses forward to the new fiscal year for inception to date reporting.	AC;CB	A
Beginning Balance Roll Forward	FUND_GROUPS _FOR_INCEPTION _TO_DATE_REPORTING	The fund group(s) that are eligible for inception to date reporting as part of the balance forward process.	CG	A
Beginning Balance Roll Forward	SUB_FUND_GROUPS _FOR_INCEPTION _TO_DATE_REPORTING	The sub fund group(s) that are eligible for inception to date reporting as part of the balance forward process.	SDCI;PFCMR	A
Scrubber Job Capitalization	CHARTS_EXCLUDED	Excludes transactions associated with certain chart(s) from consideration for capitalization in the scrubber process.	HO	D
Scrubber Job Capitalization	DOCUMENT_TYPES_EXCLUDED	Excludes transactions associated with certain document type(s) from consideration for capitalization in the scrubber process.	TF;YETF;AV;AVAC; AVAE;AVRC;ACLO	D
Scrubber Job Capitalization	FISCAL_PERIODS_EXCLUDED	Excludes transactions associated with certain fiscal period(s) from consideration for capitalization in the scrubber process.	BB;CB	D
Scrubber Job Capitalization	CAPITALIZATION_IND	Turns on (Y) or off (N) the capitalization process in the scrubber.	Y	A
Scrubber Job Capitalization	CAPITAL_OBJECT_CODES	The object codes where capitalization will post when generated by the scrubberJob. The object code is assigned based on the object sub-type(s) of the original transaction. Format: object sub type 1=object 1;object sub type 2=object 2.	AF=8616;AM=8615; BD=8601;BF=8605; CM=8610	A
Scrubber Job Capitalization	OBJECT_SUB_TYPES	The object sub-type(s) associated with transactions that will be considered as part of the generated capitalization in the scrubber process.	AM;AF;BD;BF;BI; BR;BX;BY;CM;CF; C1;C2;C3;ES;IF; LA;LE;LF;LI;LR; UC;UF	A
Scrubber Job Capitalization	FUND_BALANCE_OBJECT_CODE	Specifies a fund balance object to use. When left blank, the fund balance object code associated with the Chart will be used.		A
Scrubber Job Capitalization	SUB_FUNDS_EXCLUDED	Restricts transactions associated with certain sub fund group(s) from consideration in the capitalization scrubber process.	EXTAGY	D
Scrubber Job Capitalization	CAMPUS_SUB_TYPES	The object sub-type(s) associated with non-movable assets that are associated with a campus. Determines to which account the capitalization entry will post. Campus and Organization Plant Accounts are attributes of Organization.	AM;AF;BD;BF;BI; BR;BX;BY;IF;LA; LE;LF;LI;LR	A
Scrubber Job Capitalization	ORGANIZATION_SUB_TYPES	The object sub-type(s) associated with movable assets that are associated with an organization. Used by the capitalization process in the scrubber. Determines to which account the capitalization entry will post. Campus and Organization Plant Accounts are attributes of Organization.	CL;CM;CF;C1; C2;C3;ES;UC;UF	A
Continuation Account	CG_ACCOUNT_EXPIRATION _EXTENSION_DAYS	The number of days added to the expiration date of C&G accounts to allow for necessary adjusting entries.	30	A
Continuation Account	CONTINUATION_ACCOUNT _BYPASS_DOCUMENT_TYPES	The document type(s) that are allowed to post to expired accounts.	PREQ;ACHC;ACHD; ACHR;CHKC;CHKD; CHKR;GLT	A
Continuation Account	CONTINUATION_ACCOUNT _BYPASS_ORIGINATIONS	The origination code(s) that are allowed to post to expired accounts. This relates to system feeds.	01;02;EU;PL	A
Scrubber Job Cost Share	ENCUMBRANCE_BALANCE_TYPES	Balances types for which cost share encumbrances will be created by the scrubberJob.	IE;EX	A
Scrubber Job Cost Share	FISCAL_PERIODS	Fiscal periods excluded from cost share by the scrubberJob.	BB;CB	D
Scrubber Job Cost Share	TRANSFER_IN_OBJECT_CODE	Object code used to record cost share transfer in. The account used will be the contract & grant account associated with the cost share sub-account.	9915	A
Scrubber Job Cost Share	TRANSFER_OUT_OBJECT_CODES	The object codes used on the cost share entries created by the scrubberJob based on the object level of the original transaction. The cost share transfer out entries will post to the cost share account associated with the contracts & grants account and cost share sub-account. Format is: Object Level 1=Object Code 1; Object Level 2=Object Code 2; etc. NOTE: The parameter should also include: DEFAULT=ObjectCode to catch those entries not specified in the parameter.	ACSA=9920;BASE=9959; BENF=9957;BISA=9925; CAP=9970; DEFAULT=9940	A
Scrubber Job Cost Share	OBJECT_TYPES	Object types for which cost share will be created by the scrubberJob.	EE;EX;ES;TE	A
Current Account Balance Lookup	CASH_BUDGET _RECORD_LEVEL	Identifies accounts that will have Cash Expenditure Authority and Fund Balance calculated for it on the Current Account Balance Screen. All other Budget Record Level codes will calculate Budget Balance Available.	N	A
Current Account Balance Lookup	CURRENT_ASSET _OBJECT_CODE	Cash and other cash object codes.	8000;8100	A
Current Account Balance Lookup	CURRENT_LIABILITY _OBJECT_CODE	Current liability object codes.	9041	A
Current Account Balance Lookup	ENCUMBRANCE _BALANCE_TYPE	Encumbrance balance types.	EX;IE;PE;CE	A
Current Account Balance Lookup	EXPENSE_OBJECT_ TYPE	Expense object type codes.	EE;ES;EX;TE	A
Current Account Balance Lookup	FUND_BALANCE _OBJECT_CODE	Fund Balance Object codes	9899	A
Current Account Balance Lookup	INCOME_OBJECT_ TYPE	Income object type codes.	CH;IC;IN;TI	A
Email	FROM_EMAIL_ADDRESS	From email address used for messages sent by the system.		A
Encumbrance Roll Forward	BEGINNING_FUND _BALANCE_TRANSACTION _LEDGER_ENTRY_DESCRIPTION	Default Transaction Ledger Entry Description to use for generated beginning fund balance offsets created by the encumbrance closing process.	BEGINNING FUND BALANCE OFFSET	A
Encumbrance Roll Forward	FORWARD_ENCUMBRANCE _BALANCE_TYPE_AND _ORIGIN_CODE	Either includes or excludes all encumbrances from forward	IE=LD	D
Encumbrance Roll Forward	FORWARDING_ENCUMBRANCE _BALANCE_TYPES	Used to narrow down the set of encumbrance balance types (obtained from the balance type table) that will be used to identify the encumbrances that should be carried forward to the next fiscal year.	CE	D
Encumbrance Roll Forward	GENERATED_TRANSACTION _LEDGER_ENTRY_DESCRIPTION	Default Transaction Ledger Entry Description to use for generated offset created by the encumbrance closing process.	GENERATED OFFSET	A
Encumbrance Roll Forward	OFFSET_OBJECT_CODE _FOR_EXTERNAL _ENCUMBRANCE	The object code used to balance external encumbrance entries from the encumbrance closing process.	9892	A
Encumbrance Roll Forward	OFFSET_OBJECT _CODE_FOR_INTERNAL _ENCUMBRANCE	The offset object code used to balance internal encumbrance entries from encumbrance closing process.	9891	A
Encumbrance Roll Forward	OFFSET_OBJECT _CODE_FOR_PRE _ENCUMBRANCE	The offset object code used to balance pre-encumbrance entries from the encumbrance closing process.	9890	A
Encumbrances	ENCUMBRANCE_OPEN _AMOUNT_OVERRIDING _DOCUMENT_TYPES	Encumbrance transactions with these document types will always update the Open Amount field on the GL Open Encumbrance table. As with other encumbrance transactions, the GL poster will use the document information, when the encumbrance update code = D, or the reference document information, when the encumbrance update code = R, when determining the key values needed to insert into or update the Open Encumbrance table.	PO;POA;POC;POPH; PORH;POR;PORT; POSP;POV;TA; TAA;TAC	A
External File Feeds	TO_EMAIL	E-mail address(es) where notification will be sent in the event of a reconciliation or parse error.		A
External File Feeds	EQUAL_DEBIT_CREDIT _TOTAL_DOCUMENT_TYPES	Document types that trigger a balance of credits, debits and total as part of the Collector Step process.	ID*;EB*	A
External File Feeds	ERROR_EMAIL _SUBJECT_LINE	This is the subject line used when the collector sends out email notifying the user that the collector has excluded origin entries from processing (i.e. demerged).	Collector Input - INVALID DOCUMENT	A
External File Feeds	PERFORM_DUPLICATE _HEADER_CHECK_IND	Flag for turning the duplicate file check on or off.	N	A
External File Feeds	VALIDATION_EMAIL _SUBJECT_LINE	This is the subject line used when the collector sends out email relating to the validation status of a particular file.	File Upload Successful	A
External File Feeds	VALIDATION_ERROR _EMAIL_SUBJECT_LINE	This is the subject line used when the collector sends out email relating to a file that failed validation.	File Uploaded Not Processed	A
General Ledger Correction Process	MAX_FILE_SIZE _ORIGIN_ENTRY_IMPORT	Maximum upload size for origin entry files within the General Ledger Correction Process. Must be an integer, optionally followed by "K", "M", or "G". (Used by General Ledger Correction Process.)	25M	A
General Ledger Correction Process	RECORD_COUNT _FUNCTIONALITY_LIMIT	If the selected origin entry group contains more rows than the value of this parameter, document functionality will be restricted.  Refer to the article on General Ledger Correction Process for details.	1000	A
General Ledger Correction Process	RECORDS_PER_PAGE	The maximum number of origin entry that will be displayed per the General Ledger Correction Process search results page.	10	A
Indirect Cost Recovery	INDIRECT_COST_TYPES	Excludes transactions associated with certain indirect cost type(s) from consideration for posting of indirect cost entries (actuals and encumbrance).	10	A
Indirect Cost Recovery	ICR_EXCLUSIONS _AT_TRANSACTION_AND _TOP_LEVEL_ONLY_IND	Determines, when the Poster walks up the object code reports-to hierarchy to check if an Indirect Cost Recovery Exclusion by Type or Indirect Cost Recovery Exclusion by Account exists for the given transaction, if only the transaction's object code and the top level object code of the hierarchy should be consulted, as opposed to seeking exclusions at every step of the object code reports-to hierarchy	Y	A
Indirect Cost Recovery	INDIRECT_COST _FISCAL_PERIODS	Excludes transactions (actuals and encumbrances) associated with certain fiscal period(s) from consideration for posting of indirect cost entries.	AB;CB;BB	D
Indirect Cost Recovery	INDIRECT_COST _RECOVERY_DOCUMENT _TYPE	Document type used for indirect cost recovery general ledger entries (actual and encumbrance) generated by the poster.	ICR	A
Indirect Cost Recovery Encumbrance	USE_ICR _ENCUMBRANCE_IND	Indirect Cost Recovery Encumbrance Enabled Flag (Y/N).	Y	A
Indirect Cost Recovery Encumbrance	INDIRECT_COST _RECOVERY_ENCUMBRANCE _BALANCE_TYPES	Identifies Encumbrance Balance Type codes that should be included when determining on which balances to calculate encumbrances.	IE;EX;PE	A
Indirect Cost Recovery Encumbrance	INDIRECT_COST _RECOVERY_ENCUMBRANCE _ORIGINATION	Identifies Origination Code to be used when creating ICR Transactions and transactions that should be excluded when calculating ICR encumbrances.	IR	A
Module Lockout	MODULE_LOCKED_IND	Y/N indicator showing if the general ledger module is currently unavailable for Online Transaction Processing (OLTP). Y means the module is currently locked and cannot be used. N means the module is unlocked and available for use.	N	A
Monitoring	ENTRY_GENERATING _DOCUMENT_TYPES	Document types, which - once documents of these types achieve "processed" workflow status - are expected to generate general ledger entries.	CTRL;CINV;LCR;CRM; INV;INVW;APP;MPAY; AT;AD;AV;BA;CR;CCR; DV;DI;YEBA;YEDI; YEGE;YETF;GEC; ICA;IB;IAA;JV;ND; PE;PCDO;SB;TF; CM;PO;POSP;POV; LLJV;YEBT;YEST;ST	A
Monitoring	LOOK_BACK_DAYS	Number of days back to look for documents that have not generated ledger entries.	7	A
Monitoring	NOTIFICATION_EMAIL _ADDRESSES	The e-mail address to send notifications to when documents missing ledger entries are found.  If left blank, the job will simply log the document information.		A
Nominal Activity Closing	NET_EXPENSE _OBJECT_CODE	Nominal balances remaining in expense object codes, after other year-end processes are run, are closed to this object code.	5000	A
Nominal Activity Closing	NET_REVENUE _OBJECT_CODE	Nominal balances remaining in revenue object codes, after other year-end processes are run, are closed to this object code.	1800	A
Poster Balancing Report	COMPARISON_FAILURES	Number of failures to print on the report for each category of balancing failures identified by the posterBalancingJob.	10	A
Poster Balancing Report	PAST_FISCAL_YEARS	Number of fiscal years to subtract from the current fiscal year to represent the start range that will be used by posterBalancingJob.	1	A
Poster Report	CURRENT_AND _LAST_YEAR	The month and day marking the end of normal document processing (not Year-End documents) for the fiscal year. This date is needed to help the accounting cycle know which versions of the GL Summary Report to run.	0630	A
Poster Report	CURRENT_YEAR_LOWER	The month and day near the end of a fiscal year when the accounting cycle will begin producing a GL Summary Report for the next fiscal year.	0615	A
Poster Report	CURRENT_YEAR_UPPER	The month and day near the beginning of a fiscal year when the accounting cycle will stop producing a GL Summary Report for last fiscal year.	0807	A
Purge Process	PRIOR_TO_YEAR	Purge data from GL_ACCT_BALANCES_T before this year	2001	A
Purge Process	PRIOR_TO_YEAR	Purge data from GL_BALANCE_T before this year	2001	A
Purge Process	PRIOR_TO_YEAR	Purge data from GL_ID_BILL_T before this year	2004	A
Purge Process	PRIOR_TO_YEAR	Purge data from GL_ENCUMBRANCE_T before this year	2004	A
Purge Process	PRIOR_TO_YEAR	Purge data from GL_ENTRY_T before this year	2004	A
Purge Process	PRIOR_TO_YEAR	Purge data from GL_SF_BALANCES_T before this year	2001	A
Offset Generation	DOCUMENT_TYPES _REQUIRING_FLEXIBLE _OFFSET_BALANCING_ENTRIES	Determines if the Scrubber should generate offsets for entries of the given document type		A
Offset Generation	DOCUMENT_TYPES_EXCLUDED	Document types excluded from capitalization, liability, plant indebtedness and offset entries created by the scrubberJob.	JV;ACLO	D
Offset Generation	FISCAL_PERIODS_EXCLUDED	Fiscal periods excluded from capitalization, liability, plant indebtedness, and offset entries created by the scrubberJob.	BB;CB	D
Scrubber Job Plant Fund Indebtedness	PLANT_FUND_LIABILITY_IND	Turns on (Y) or off (N) the plant indebtedness process in the scrubber.	Y	A
Scrubber Job Plant Fund Indebtedness	OBJECT_SUB_TYPES	Object sub type codes for which the scrubberJob will generate plant fund indebtedness entries.	PI	A
Scrubber Job Plant Fund Indebtedness	FUND_BALANCE_OBJECT_CODE	Fund balance offset object code to use when the scrubberJob will generate plant fund indebtedness entries. If this parameter is blank, the fund balance object code assigned to the chart will be used.		A
Scrubber Job Plant Fund Indebtedness	SUB_FUNDS	The sub-fund group(s) that must be associated with transactions to generate a bond and note liability in the plant-indebtedness scrubber process.	PFCMR;PFRI	A
Scrubber	CUTOFF_TIME	Cutoff time for scrubber process, represented in 24 hour time format. Leave blank if no cutoff time desired (i.e. the scrubber run date is considered to be the date it is run). If the cutoff time is set and if the scrubber is run before the time indicated in this parameter, then the run date is considered to be 11:59:59.000 PM of the previous day. If it is run on or after the run date, then the run date of scrubber is the date and time of when the scrubber is actually executed, according to the DateTimeService. Examples: 00:35:00 is 12:35 midnight, and 13:24:56 is 1:24:56 PM.	10:00:00	A
Scrubber	OBJECT_TYPE_OVERRIDE	Origination Codes where the object type will not be updated to match the object type assigned to the object code.	1	D
Scrubber	TRANSACTION_DATE_OVERRIDE	Origination codes where the offset entry will have the same transaction date as the original transaction. Used primarily for transactions coming in from external systems, such as Payroll.	02	A
Scrubber Plant Fund Liability	CHARTS_EXCLUDED	Excludes transactions associated with certain chart(s) from consideration as a generated plant fund liability (leasehold equities) in the scrubber process.	HO	D
Scrubber Plant Fund Liability	DOCUMENT_TYPES_EXCLUDED	Excludes transactions associated with certain document type(s) from consideration as a generated plant fund liability (leasehold equities) in the scrubber process.	ACLO;TF;YETF;AV; AVAC;AVAE;AVRC; IAA	D
Scrubber Plant Fund Liability	FISCAL_PERIODS_EXCLUDED	Fiscal periods excluded by the scrubberJob when creating plant fund liability entries.	BB;CB	D
Scrubber Plant Fund Liability	LIABILITY_IND	Turns on (Y) or off (N) the generated plant liability (leasehold equities) process in the scrubber.	Y	A
Scrubber Plant Fund Liability	OBJECT_CODE	The object code to which the generated plant fund liability (leasehold equities) will be assigned in the scrubber process.	9603	A
Scrubber Plant Fund Liability	OFFSET_OBJECT_CODE	When this parameter is left blank, the chart fund balance object code will be used as the offset. When completed the offset will post to the fund balance object code specified here.		A
Scrubber Plant Fund Liability	SUB_FUNDS_EXCLUDED	Excludes transactions associated with certain sub fund group(s) from consideration as a generated plant fund liability (leasehold equities) in the scrubber process.	EXTAGY	D
Scrubber Plant Fund Liability	SUB_TYPES	The allowable object sub-type(s) associated with transactions that will be considered as part of the generated plant fund liability (leasehold equities) in the scrubber process.	CL	A
Sufficient Funds Checking	FISCAL_YEAR	Fiscal Year used by the sufficient funds rebuilder job to populate the Sufficient Funds table.	2018	A
Year End	ANNUAL_CLOSING_CHARTS	Charts that will be processed when year-end batch jobs Nominal Activity Closing, Balance Forward, and Encumbrance Forward are run. If no charts are specified, all charts will be processed.		A
Year End	MANUAL_FEED _ORIGINATION	Default origin code for entries created in the accounting cycle and during year-end closing processes.	MF	A
Year End	ANNUAL_CLOSING _DOCUMENT_TYPE	The document type of the accounting entries generated by the year-end closing process. This document type overrides certain scrubber logic (continuation accounts, inactive sub accounts, offset generation, etc...) so entries can post in the same accounting string where the balances originated.	ACLO	A
Year End	ANNUAL_CLOSING _FISCAL_YEAR	Fiscal year to select from when determining GL balance for the year-end process.	2018	A
Year End	ANNUAL_CLOSING _FUND_BALANCE _OBJECT_CODE	Object Code for remaining fund balances in the year-end closing process.	9989
Year End	ANNUAL_CLOSING _FUND_BALANCE _OBJECT_TYPE	Object Type for remaining fund balances in the year-end closing process.	FB	A
Year End	ANNUAL_CLOSING _TRANSACTION_DATE	Date used on all transactions related to year-end closing process.	06/30/2019	A