FACTS_TREE_GRP (SQL Table)	Index Back
FACTSTree Group FACTS Tree Group. Represents groups of trees that can be used by the FACTS I and FACTS II processes/reports

FACTS_TREE_GRP

(SQL Table)

FACTSTree Group

FACTS Tree Group. Represents groups of trees that can be used by the FACTS I and FACTS II processes/reports

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL SetID
Default Value: OPR_DEF_TBL_FS.SETID
Prompt Table: SP_SETID_NONVW

2 TREE_GRP Character(10) VARCHAR2(10) NOT NULL FACTS Tree Group

3 TREE_NAME_BUREAU Character(18) VARCHAR2(18) NOT NULL Bureau Tree for FACTS I reporting
Prompt Table: FACTSI_TREENAME

4 TREE_LEVEL_BUREAU Character(10) VARCHAR2(10) NOT NULL Bureau Tree Level for FACTS I reporting
Prompt Table: FACTSI_BUR_LVL

5 TREE_NAME_FG Character(18) VARCHAR2(18) NOT NULL Fund Group Tree for FACTS I reporting
Prompt Table: FACTSI_TREENAME

6 TREE_LEVEL_FG Character(10) VARCHAR2(10) NOT NULL Fund Group Tree Level for FACTS I reporting
Prompt Table: FACTSI_FG_LVL

7 TREE_NAME_ACCT Character(18) VARCHAR2(18) NOT NULL Account Tree for FACTS I reporting
Prompt Table: FACTSI_TREENAME

8 TREE_LEVEL_ACCT Character(10) VARCHAR2(10) NOT NULL Account Tree Level for FACTS I reporting
Prompt Table: FACTSI_ACCT_LVL

9 F1TRANPRTNR_TREE Character(18) VARCHAR2(18) NOT NULL FACTS I Transaction Partner Tree.
Prompt Table: TREE_NAMES

10 F1TRANPRTNR_TRLVL Character(10) VARCHAR2(10) NOT NULL FACTS I Transaction Partner Tree Level.
Prompt Table: F1TRPRTNR_TRLVL

11 F2_XFER_AGEN_TREE Character(18) VARCHAR2(18) NOT NULL Transfer Agency Tree. Used by the FACTS feature.
Prompt Table: TREE_NAMES

12 F2_XFER_AGEN_LEVEL Character(10) VARCHAR2(10) NOT NULL Transfer Agency Tree level. Used by the FACTS feature.
Prompt Table: TRFAG_TREELVL

13 F2_XFER_ACCT_TREE Character(18) VARCHAR2(18) NOT NULL Transfer Account Tree. Used by the federal FACTS features
Prompt Table: TREE_NAMES

14 F2_XFER_ACCT_LEVEL Character(10) VARCHAR2(10) NOT NULL Transfer Account Tree Level. Used by the federal FACTS features
Prompt Table: F2_TREE_LVL_VW5

15 TRAN_PRTNR_TREE Character(18) VARCHAR2(18) NOT NULL Transaction Partner Tree. Used by FACTS feature
Prompt Table: FACTSI_TREENAME

16 TRAN_PRTNR_TREELVL Character(10) VARCHAR2(10) NOT NULL Transaction Partner Tree Level. Used by the FACTS feature
Prompt Table: TRN_PRTNR_LVL

17 TRNPRTNR_ACCT_TREE Character(18) VARCHAR2(18) NOT NULL Transaction Partner Account Tree. Used by the FACTS I feature
Prompt Table: FACTSI_TREENAME

18 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

19 EXCHNG_ACCT_TREE Character(18) VARCHAR2(18) NOT NULL Exchange Attribute/Account Tree. Used by the FACTS I feature
Prompt Table: FACTSI_TREENAME

20 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

21 CSTODIAL_ACCT_TREE Character(18) VARCHAR2(18) NOT NULL Custodial /Account Tree. Used by the FACTS I feature
Prompt Table: FACTSI_TREENAME

22 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

23 BUDG_SUBFUNC_TREE Character(18) VARCHAR2(18) NOT NULL Budget Subfunction attribute / Account Tree. Used by the FACTS I feature.
Prompt Table: FACTSI_TREENAME

24 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

25 F2_ACRL_TREE Character(18) VARCHAR2(18) NOT NULL FACTS II Acct Rollup Tree
Prompt Table: TREE_NAMES

26 F2_ACRL_LEVEL Character(10) VARCHAR2(10) NOT NULL Acct Rollup Tree Level
Prompt Table: F2_TREE_LVL_VW1

27 F2_COYR_TREE Character(18) VARCHAR2(18) NOT NULL FACTS II Cohort Year Tree
Prompt Table: TREE_NAMES

28 F2_COYR_LEVEL Character(10) VARCHAR2(10) NOT NULL Cohort Year Tree Level
Prompt Table: F2_TREE_LVL_VW2

29 F2_CATB_TREE Character(18) VARCHAR2(18) NOT NULL FACTS II Category B Tree
Prompt Table: TREE_NAMES

30 F2_CATB_LEVEL Character(10) VARCHAR2(10) NOT NULL Category B Tree Level
Prompt Table: F2_TREE_LVL_VW3

31 F2_FNAC_TREE Character(18) VARCHAR2(18) NOT NULL Accts req Attributes Tree
Prompt Table: TREE_NAMES

32 F2_FNAC_LEVEL Character(10) VARCHAR2(10) NOT NULL Accts req Attr Tree Level
Prompt Table: F2_TREE_LVL_VW4

33 F1_ATTRB_TREE Character(18) VARCHAR2(18) NOT NULL Accts Req Attributes Tree
Prompt Table: TREE_NAMES

34 F1_ATTRB_LEVEL Character(10) VARCHAR2(10) NOT NULL Accts Req Attrib Tree Level
Prompt Table: F1_TREE_LVL_VW1

35 TREE_NAME_DEPT Character(18) VARCHAR2(18) NOT NULL Department Tree for FACTS I reporting
Prompt Table: TREE_NAMES

36 TREE_LEVEL_DEPT Character(10) VARCHAR2(10) NOT NULL Department Tree Level for FACTS I reporting
Prompt Table: F1_DEPT_LVL_VW

37 F2_CATA_TREE Character(18) VARCHAR2(18) NOT NULL FACTS II Category A Tree
Prompt Table: FACTSI_TREENAME

38 F2_CATA_LEVEL Character(10) VARCHAR2(10) NOT NULL Category A Tree Level
Prompt Table: F2_TREE_LVL_VW6

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID Default Value: OPR_DEF_TBL_FS.SETID Prompt Table: SP_SETID_NONVW
2	TREE_GRP	Character(10)	VARCHAR2(10) NOT NULL	FACTS Tree Group
3	TREE_NAME_BUREAU	Character(18)	VARCHAR2(18) NOT NULL	Bureau Tree for FACTS I reporting Prompt Table: FACTSI_TREENAME
4	TREE_LEVEL_BUREAU	Character(10)	VARCHAR2(10) NOT NULL	Bureau Tree Level for FACTS I reporting Prompt Table: FACTSI_BUR_LVL
5	TREE_NAME_FG	Character(18)	VARCHAR2(18) NOT NULL	Fund Group Tree for FACTS I reporting Prompt Table: FACTSI_TREENAME
6	TREE_LEVEL_FG	Character(10)	VARCHAR2(10) NOT NULL	Fund Group Tree Level for FACTS I reporting Prompt Table: FACTSI_FG_LVL
7	TREE_NAME_ACCT	Character(18)	VARCHAR2(18) NOT NULL	Account Tree for FACTS I reporting Prompt Table: FACTSI_TREENAME
8	TREE_LEVEL_ACCT	Character(10)	VARCHAR2(10) NOT NULL	Account Tree Level for FACTS I reporting Prompt Table: FACTSI_ACCT_LVL
9	F1TRANPRTNR_TREE	Character(18)	VARCHAR2(18) NOT NULL	FACTS I Transaction Partner Tree. Prompt Table: TREE_NAMES
10	F1TRANPRTNR_TRLVL	Character(10)	VARCHAR2(10) NOT NULL	FACTS I Transaction Partner Tree Level. Prompt Table: F1TRPRTNR_TRLVL
11	F2_XFER_AGEN_TREE	Character(18)	VARCHAR2(18) NOT NULL	Transfer Agency Tree. Used by the FACTS feature. Prompt Table: TREE_NAMES
12	F2_XFER_AGEN_LEVEL	Character(10)	VARCHAR2(10) NOT NULL	Transfer Agency Tree level. Used by the FACTS feature. Prompt Table: TRFAG_TREELVL
13	F2_XFER_ACCT_TREE	Character(18)	VARCHAR2(18) NOT NULL	Transfer Account Tree. Used by the federal FACTS features Prompt Table: TREE_NAMES
14	F2_XFER_ACCT_LEVEL	Character(10)	VARCHAR2(10) NOT NULL	Transfer Account Tree Level. Used by the federal FACTS features Prompt Table: F2_TREE_LVL_VW5
15	TRAN_PRTNR_TREE	Character(18)	VARCHAR2(18) NOT NULL	Transaction Partner Tree. Used by FACTS feature Prompt Table: FACTSI_TREENAME
16	TRAN_PRTNR_TREELVL	Character(10)	VARCHAR2(10) NOT NULL	Transaction Partner Tree Level. Used by the FACTS feature Prompt Table: TRN_PRTNR_LVL
17	TRNPRTNR_ACCT_TREE	Character(18)	VARCHAR2(18) NOT NULL	Transaction Partner Account Tree. Used by the FACTS I feature Prompt Table: FACTSI_TREENAME
18	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
19	EXCHNG_ACCT_TREE	Character(18)	VARCHAR2(18) NOT NULL	Exchange Attribute/Account Tree. Used by the FACTS I feature Prompt Table: FACTSI_TREENAME
20	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
21	CSTODIAL_ACCT_TREE	Character(18)	VARCHAR2(18) NOT NULL	Custodial /Account Tree. Used by the FACTS I feature Prompt Table: FACTSI_TREENAME
22	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
23	BUDG_SUBFUNC_TREE	Character(18)	VARCHAR2(18) NOT NULL	Budget Subfunction attribute / Account Tree. Used by the FACTS I feature. Prompt Table: FACTSI_TREENAME
24	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
25	F2_ACRL_TREE	Character(18)	VARCHAR2(18) NOT NULL	FACTS II Acct Rollup Tree Prompt Table: TREE_NAMES
26	F2_ACRL_LEVEL	Character(10)	VARCHAR2(10) NOT NULL	Acct Rollup Tree Level Prompt Table: F2_TREE_LVL_VW1
27	F2_COYR_TREE	Character(18)	VARCHAR2(18) NOT NULL	FACTS II Cohort Year Tree Prompt Table: TREE_NAMES
28	F2_COYR_LEVEL	Character(10)	VARCHAR2(10) NOT NULL	Cohort Year Tree Level Prompt Table: F2_TREE_LVL_VW2
29	F2_CATB_TREE	Character(18)	VARCHAR2(18) NOT NULL	FACTS II Category B Tree Prompt Table: TREE_NAMES
30	F2_CATB_LEVEL	Character(10)	VARCHAR2(10) NOT NULL	Category B Tree Level Prompt Table: F2_TREE_LVL_VW3
31	F2_FNAC_TREE	Character(18)	VARCHAR2(18) NOT NULL	Accts req Attributes Tree Prompt Table: TREE_NAMES
32	F2_FNAC_LEVEL	Character(10)	VARCHAR2(10) NOT NULL	Accts req Attr Tree Level Prompt Table: F2_TREE_LVL_VW4
33	F1_ATTRB_TREE	Character(18)	VARCHAR2(18) NOT NULL	Accts Req Attributes Tree Prompt Table: TREE_NAMES
34	F1_ATTRB_LEVEL	Character(10)	VARCHAR2(10) NOT NULL	Accts Req Attrib Tree Level Prompt Table: F1_TREE_LVL_VW1
35	TREE_NAME_DEPT	Character(18)	VARCHAR2(18) NOT NULL	Department Tree for FACTS I reporting Prompt Table: TREE_NAMES
36	TREE_LEVEL_DEPT	Character(10)	VARCHAR2(10) NOT NULL	Department Tree Level for FACTS I reporting Prompt Table: F1_DEPT_LVL_VW
37	F2_CATA_TREE	Character(18)	VARCHAR2(18) NOT NULL	FACTS II Category A Tree Prompt Table: FACTSI_TREENAME
38	F2_CATA_LEVEL	Character(10)	VARCHAR2(10) NOT NULL	Category A Tree Level Prompt Table: F2_TREE_LVL_VW6