GTAS_TREE_GRP

(SQL Table)
 Index Back

GTAS Tree Group

GTAS Tree Group. Represents groups of trees that can be used by the GTAS 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_ACCT Character(18) VARCHAR2(18) NOT NULL Account Tree for FACTS I reporting

Prompt Table: GTAS_TREENAME

4 TREE_LEVEL_ACCT Character(10) VARCHAR2(10) NOT NULL Account Tree Level for FACTS I reporting

Prompt Table: GTAS_ACCTLVL_VW

5 GTAS_ATTRB_TREE Character(18) VARCHAR2(18) NOT NULL Accts Req Attributes Tree

Prompt Table: GTAS_TREENAME

6 GTAS_ATTRB_LEVEL Character(10) VARCHAR2(10) NOT NULL Accts Req Attrib Tree Level

Prompt Table: GTAS_ATTRLVL_VW

7 FED_NONFED_TREE Character(18) VARCHAR2(18) NOT NULL Fed Non Fed Code Tree

Prompt Table: GTAS_TREENAME

8 FED_NONFED_LVL Character(10) VARCHAR2(10) NOT NULL Federal NonFed Level

Prompt Table: GTAS_FEDLVL_VW

9 TR_PARTNER_TREE Character(18) VARCHAR2(18) NOT NULL Trading Partner Tree

Prompt Table: GTAS_TREENAME

10 TR_PARTNER_LVL Character(10) VARCHAR2(10) NOT NULL Trading Partner Level

Prompt Table: GTAS_TPRTLVL_VW

11 TR_PARTACT_TREE Character(18) VARCHAR2(18) NOT NULL Main Account Tree

Prompt Table: GTAS_TREENAME

12 TR_PARTACT_LVL Character(10) VARCHAR2(10) NOT NULL Main Account Tree Level

Prompt Table: GTAS_PACTLVL_VW

13 CATB_TREE Character(18) VARCHAR2(18) NOT NULL Category B Prog Tree

Prompt Table: GTAS_TREENAME

14 CATB_LVL Character(10) VARCHAR2(10) NOT NULL Category B Level

Prompt Table: GTAS_CATBLVL_VW

15 COHYR_TREE Character(18) VARCHAR2(18) NOT NULL Credit Cohort Year Tree

Prompt Table: GTAS_TREENAME

16 COHYR_LVL Character(10) VARCHAR2(10) NOT NULL Credit Cohort Year Level

Prompt Table: GTAS_CYRLVL_VW

17 RPTCAT_TREE Character(18) VARCHAR2(18) NOT NULL Program Rptg Cat Tree

Prompt Table: GTAS_TREENAME

18 RPTCAT_LVL Character(10) VARCHAR2(10) NOT NULL Reporting Category Level

Prompt Table: GTAS_RPTCLVL_VW

19 DEFC_FUND_TREE Character(18) VARCHAR2(18) NOT NULL Disaster Emergency FundCode Tr

Prompt Table: GTAS_TREENAME

20 DEFC_FUND_LEVEL Character(10) VARCHAR2(10) NOT NULL DisasterEmergencyFundCodeLevel

Prompt Table: GTAS_DEFC_ATLVL

21 BOC_CLASS_TREE Character(18) VARCHAR2(18) NOT NULL Budget Object Class Tree

Prompt Table: GTAS_TREENAME

22 BOC_CLASS_LEVEL Character(10) VARCHAR2(10) NOT NULL Business Object Class Level

Prompt Table: GTAS_BOCLVL_VW