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 |
Capitalization |
CAPITALIZATION _CHARTS |
Excludes transactions associated with certain chart(s) from consideration for capitalization in the scrubber process. | HO | D |
Capitalization |
CAPITALIZATION _DOCUMENT_TYPES |
Excludes transactions associated with certain document type(s) from consideration for capitalization in the scrubber process. |
TF;YETF;AV;AVAC; AVAE;AVRC;ACLO |
D |
Capitalization |
CAPITALIZATION _FISCAL_PERIODS |
Excludes transactions associated with certain fiscal period(s) from consideration for capitalization in the scrubber process. | BB;CB | D |
Capitalization | CAPITALIZATION_IND | Turns on (Y) or off (N) the capitalization process in the scrubber. | Y | A |
Capitalization |
CAPITALIZATION_OBJECT _CODE_BY_OBJECT _SUB_TYPE |
The plant fund object code(s) to which the generated capitalization will be assigned, by object sub-type(s) of the original transaction, in the scrubber process. Format of list is object sub type 1=object 1;object sub type 2=object 2. |
AF=8616;AM=8615; BD=8601;BF=8605; CM=8610 |
A |
Capitalization |
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 |
Capitalization |
CAPITALIZATION _OFFSET_CODE |
Specifies a fund balance object to use. When left blank, the fund balance object code associated with the Chart will be used. | A | |
Capitalization |
CAPITALIZATION_SUB _FUND_GROUPS |
Restricts transactions associated with certain sub fund group(s) from consideration in the capitalization scrubber process. | EXTAGY | D |
Capitalization |
PLANT_FUND _CAMPUS_OBJECT _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 |
Capitalization |
PLANT_FUND _ORGANIZATION _OBJECT_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 |
Cost Share |
FISCAL_PERIODS |
Fiscal periods excluded from cost share by the scrubberJob. | BB;CB | D |
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 |
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 |
Cost Share |
OBJECT_TYPES |
Object types for which cost share will be created by the scrubberJob. | EE;EX;ES;TE | A |
Cost Share Encumbrances |
DOCUMENT_TYPES |
Document types excluded from cost share by the scrubberJob. | JV;AA;IAA | D |
Cost Share Encumbrances |
ENCUMBRANCE_BALANCE_TYPES |
Balances types for which cost share encumbrances will be created by the scrubberJob. | EX;IE;PE | 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 |
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 |
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 |
Plant Indebtedness | PLANT_INDEBTEDNESS_IND | Turns on (Y) or off (N) the plant indebtedness process in the scrubber. | Y | A |
Plant Indebtedness |
PLANT_INDEBTEDNESS _OBJECT_SUB_TYPES |
The object sub-type(s) that must be associated with transactions to generate a bond and note liability in the plant-indebtedness scrubber process. | PI | A |
Plant Indebtedness |
PLANT_INDEBTEDNESS _OFFSET_CODE |
This overrides the Chart Fund Balance object code for Plant Indebtedness. | A | |
Plant Indebtedness |
PLANT_INDEBTEDNESS _SUB_FUND_GROUPS |
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 |
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 |
Comments
0 comments
Please sign in to leave a comment.