F2_MAF_TSYMBOLPROG_RPT_CATEGORY0=MAF Download
1=User Defined
Default Value: 1
F2_PROG_RPT_CAT(SQL Table) |
Index Back |
|---|---|
FACTS II MAF PRC Data |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | F2_MAF_TSYMBOL |
Character(18) | VARCHAR2(18) NOT NULL | MAF Treasury Symbol |
| 2 | PROG_RPT_CATEGORY |
Character(3) | VARCHAR2(3) NOT NULL | FACTS II - Program Reporting Category for Apportionment Category Code A. |
| 3 | PROG_RPT_CAT_TEXT | Character(50) | VARCHAR2(50) NOT NULL | FACTS II - Text description for the Program Reporting Category for Apportionment Category Code A. |
| 4 | PROG_RPT_CAT_SRCE | Character(1) | VARCHAR2(1) NOT NULL |
Identifies the origin of a FACTS II Program Reporting Category for Apportionment Category Code A. Distinguish between user defined values and values loaded from the MAF download file.
0=MAF Download 1=User Defined Default Value: 1 |
| 5 | LAST_MAINT_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Last Maintained By Operator ID |