RUN_GLS7019

(SQL Table)
 Index Back

FACTS Trial Bal run control

FACTS 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
Set Control Field: BUSINESS_UNIT

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
Set Control Field: BUSINESS_UNIT

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
Set Control Field: BUSINESS_UNIT

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
Set Control Field: BUSINESS_UNIT

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
Set Control Field: BUSINESS_UNIT

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
Set Control Field: BUSINESS_UNIT

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
Set Control Field: BUSINESS_UNIT

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
Set Control Field: BUSINESS_UNIT

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
Set Control Field: BUSINESS_UNIT

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