RUN_GLS7019(SQL Table) |
Index Back |
---|---|
FACTS Trial Bal run controlFACTS Trial Bal run control record. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
2 | RUN_CNTL_ID | Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
3 | LANGUAGE_CD | Character(3) | VARCHAR2(3) NOT NULL | Language Code |
4 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
5 | LEDGER | Character(10) | VARCHAR2(10) NOT NULL | Ledger |
6 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
7 | PERIOD_FROM | Number(3,0) | SMALLINT NOT NULL | From Period |
8 | PERIOD_TO | Number(3,0) | SMALLINT NOT NULL | To Period |
9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
10 | TSYMBOL_FROM | Character(10) | VARCHAR2(10) NOT NULL |
From TSYMBOL
Prompt Table: F2_TSYMB_ATT_VW |
11 | TSYMBOL_TO | Character(10) | VARCHAR2(10) NOT NULL |
To TSYMBOL
Prompt Table: F2_TSYMB_ATT_VW |
12 | DISPLAY_26_DIGITS | Character(1) | VARCHAR2(1) NOT NULL |
Display Full Numeric Field
N=No Y=Yes Y/N Table Edit |
13 | INCLUDE_ADJ_PER | Character(1) | VARCHAR2(1) NOT NULL |
Include Adjustment Period(s)
Y/N Table Edit |
14 | INCLUDE_CLOSE_PER | Character(1) | VARCHAR2(1) NOT NULL |
Include Closing Adjustments
N=No Adjustment Period S=Specify Adjustment Period Y=Adjustment Period 998 Y/N Table Edit |
15 | TREE_NAME_ACCT | Character(18) | VARCHAR2(18) NOT NULL |
Account Tree for FACTS I reporting
Prompt Table:
FACTSI_TREENAME
|
16 | TREE_LEVEL_ACCT | Character(10) | VARCHAR2(10) NOT NULL |
Account Tree Level for FACTS I reporting
Prompt Table: FACTSI_ACCT_LVL |
17 | F2_COYR_TREE | Character(18) | VARCHAR2(18) NOT NULL |
FACTS II Cohort Year Tree
Prompt Table:
FACTSI_TREENAME
|
18 | F2_COYR_LEVEL | Character(10) | VARCHAR2(10) NOT NULL |
Cohort Year Tree Level
Prompt Table: F2_TREE_LVL_VW2 |
19 | F2_FNAC_TREE | Character(18) | VARCHAR2(18) NOT NULL |
Accts req Attributes Tree
Prompt Table:
FACTSI_TREENAME
|
20 | F2_FNAC_LEVEL | Character(10) | VARCHAR2(10) NOT NULL |
Accts req Attr Tree Level
Prompt Table: F2_TREE_LVL_VW4 |
21 | TRF_AGENCY_TREE | Character(18) | VARCHAR2(18) NOT NULL |
Transfer Agency Tree. Used by the FACTS feature.
Prompt Table:
FACTSI_TREENAME
|
22 | TRF_AGNCY_TREELVL | Character(10) | VARCHAR2(10) NOT NULL |
Transfer Agency Tree level. Used by the FACTS feature.
Prompt Table: TRFAG_TREELVL |
23 | TRAN_PRTNR_TREE | Character(18) | VARCHAR2(18) NOT NULL |
Transaction Partner Tree. Used by FACTS feature
Prompt Table:
FACTSI_TREENAME
|
24 | TRAN_PRTNR_TREELVL | Character(10) | VARCHAR2(10) NOT NULL |
Transaction Partner Tree Level. Used by the FACTS feature
Prompt Table: TRN_PRTNR_LVL |
25 | TRNPRTNR_ACCT_TREE | Character(18) | VARCHAR2(18) NOT NULL |
Transaction Partner Account Tree. Used by the FACTS I feature
Prompt Table:
FACTSI_TREENAME
|
26 | TRNPRTNR_ACCT_LVL | Character(10) | VARCHAR2(10) NOT NULL |
Transaction Partner Acct Tree Level. Used by the FACTS I feature
Prompt Table: TRNPRTR_ACC_LVL |
27 | EXCHNG_ACCT_TREE | Character(18) | VARCHAR2(18) NOT NULL |
Exchange Attribute/Account Tree. Used by the FACTS I feature
Prompt Table:
FACTSI_TREENAME
|
28 | EXCHNG_ACCT_LVL | Character(10) | VARCHAR2(10) NOT NULL |
Exchange Attribute / Account Tree Level. Used by the FACTS I feature
Prompt Table: EXCHNG_ACCT_LVL |
29 | CSTODIAL_ACCT_TREE | Character(18) | VARCHAR2(18) NOT NULL |
Custodial /Account Tree. Used by the FACTS I feature
Prompt Table:
FACTSI_TREENAME
|
30 | CUSTODIAL_ACCT_LVL | Character(10) | VARCHAR2(10) NOT NULL |
Custodial Attribute/ Account Tree Level. Used by the FACTS I feature
Prompt Table: CSTDIAL_ACC_LVL |
31 | BUDG_SUBFUNC_TREE | Character(18) | VARCHAR2(18) NOT NULL |
Budget Subfunction attribute / Account Tree. Used by the FACTS I feature.
Prompt Table:
FACTSI_TREENAME
|
32 | BUDG_SUBFUNC_LVL | Character(10) | VARCHAR2(10) NOT NULL |
Budget Subfunction attribute/ Account Tree Level.
Used by the FACTS I feature
Prompt Table: BUDG_SBFUNC_LVL |