ATB_CODE0=No change requested
A=New Added MAF record
C=Change Request
D=Delete Request
1=1 - In Process
2=2 - Submitted
3=3 - Review
4=4 - Disapproved
FACTSI_MAF_TBL(SQL Table) |
Index Back |
|---|---|
FACTS I MAF tableFACTS I MAF table |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ATB_CODE |
Character(8) | VARCHAR2(8) NOT NULL | US Treasury ATB Code. Used by the FACTS I feature. 1st 2 digits - Dept 2nd 2 digits - Bureau Last 4 digits - Fund Group |
| 2 | F1_DEPT | Character(2) | VARCHAR2(2) NOT NULL | FACTS I Department |
| 3 | BUREAU | Character(2) | VARCHAR2(2) NOT NULL | FACTS I Bureau |
| 4 | FUND_GROUP | Character(4) | VARCHAR2(4) NOT NULL | FACTS I Fund Group |
| 5 | FUND_TITLE | Character(40) | VARCHAR2(40) NOT NULL | Fund Group Title. Used by the FACTS I feature. |
| 6 | BUDG_SUB_FUNC | Character(3) | VARCHAR2(3) NOT NULL | Budget Subfunction. Used by the FACTS I feature. |
| 7 | MAF_CHG_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
MAF Change Status
0=No change requested A=New Added MAF record C=Change Request D=Delete Request |
| 8 | MAF_REVIEW_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
MAF Review Status. Used by the FACTS I feature.
1=1 - In Process 2=2 - Submitted 3=3 - Review 4=4 - Disapproved |