FOMB_TREE_GRP(SQL Table) |
Index Back |
|---|---|
FOMB Tree GroupFOMB Tree Group. Represents groups of trees that can be used by the Federal OMB reporting |
| # | 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: FOMB_TREE_VW |
| 4 | TREE_LEVEL_ACCT | Character(10) | VARCHAR2(10) NOT NULL |
Account Tree Level for FACTS I reporting
Prompt Table: FOMB_ACCTLVL |
| 5 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL |
Field Name (see PSDBFIELD).
Prompt Table: CF_ACTIVE_VW |
| 6 | OBJ_ATTRB_TREE | Character(18) | VARCHAR2(18) NOT NULL |
Object Class Tree
Prompt Table: FOMB_TREE_VW |
| 7 | OBJ_ATTRB_LEVEL | Character(10) | VARCHAR2(10) NOT NULL |
Object Class Attrib Tree Level
Prompt Table: FOMB_ATTRLVL |
| 8 | DEFC_FUND_CHARTFLD | Character(18) | VARCHAR2(18) NOT NULL |
DEFC Fund Code Chartfield
Prompt Table: CF_ACTIVE_VW |
| 9 | DEFC_FUND_TREE | Character(18) | VARCHAR2(18) NOT NULL |
Disaster Emergency FundCode Tr
Prompt Table: FOMB_TREE_VW |
| 10 | DEFC_FUND_LEVEL | Character(10) | VARCHAR2(10) NOT NULL |
DisasterEmergencyFundCodeLevel
Prompt Table: DEFC_ATTRLVL |