ELIM_CF_SEL1(SQL Table) |
Index Back |
|---|---|
Elimination Set CF SelectorWork table used by the Consolidation process to store the flatened Elimination Set Chartfield values, and to be joined with the ledger table for set processing. This table should always be identical with ELIM_CF_SEL2. Both tables need to be modified if consolidation is to be run against summary ledger and one or more Chartfields in summary ledger are not Chartfields in the detail ledger. Chartfields in Elimination Sets for identifying inter-company balances MUST be in this record. Fields from ACCOUNT to GL_ADJUST_TYPE can be removed or replaced. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | ELIMINATION_SET |
Character(10) | VARCHAR2(10) NOT NULL | Elimination Set |
| 3 | TREE_NODE_NUM |
Number(10,0) | DECIMAL(10) NOT NULL | Internal beginning node range number |
| 4 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 5 | LEDGER |
Character(10) | VARCHAR2(10) NOT NULL | Ledger |
| 6 | ACCOUNT |
Character(10) | VARCHAR2(10) NOT NULL | Account |
| 7 | ALTACCT |
Character(10) | VARCHAR2(10) NOT NULL | Alternate Account |
| 8 | DEPTID |
Character(10) | VARCHAR2(10) NOT NULL | Department |
| 9 | OPERATING_UNIT |
Character(8) | VARCHAR2(8) NOT NULL | Operating Unit ChartField |
| 10 | PRODUCT |
Character(6) | VARCHAR2(6) NOT NULL | Product ChartField |
| 11 | FUND_CODE |
Character(5) | VARCHAR2(5) NOT NULL | Fund Code |
| 12 | CLASS_FLD |
Character(5) | VARCHAR2(5) NOT NULL | Class Field |
| 13 | PROGRAM_CODE |
Character(5) | VARCHAR2(5) NOT NULL | Program Code ChartField |
| 14 | BUDGET_REF |
Character(8) | VARCHAR2(8) NOT NULL | Budget Reference |
| 15 | AFFILIATE |
Character(5) | VARCHAR2(5) NOT NULL | Affiliate |
| 16 | AFFILIATE_INTRA1 |
Character(10) | VARCHAR2(10) NOT NULL | IntraUnit Affiliate1 |
| 17 | AFFILIATE_INTRA2 |
Character(10) | VARCHAR2(10) NOT NULL | Operating Unit Affiliate |
| 18 | CHARTFIELD1 |
Character(10) | VARCHAR2(10) NOT NULL | Expansion chartfield 1 |
| 19 | CHARTFIELD2 |
Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 2 |
| 20 | CHARTFIELD3 |
Character(10) | VARCHAR2(10) NOT NULL | Expansion Chartfield 3 |
| 21 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 22 | SCENARIO |
Character(10) | VARCHAR2(10) NOT NULL | A unique key identifier that allows a treasury to classify distinct revaluation events as varying and divergent ca |
| 23 | BOOK_CODE |
Character(4) | VARCHAR2(4) NOT NULL | Book Code |
| 24 | GL_ADJUST_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Adjustment Type |
| 25 | BALANCE_FWD_SW | Character(1) | VARCHAR2(1) NOT NULL |
A flag that indicates (Y or N) whether or not the YTD balance for an account type or for a statistical account will be rolled forward to Period 0 of the next year.
N=Not Carry Forward O=Other Y=Carry Forward |