| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 FISCAL_YEAR |
Number(4,0) |
SMALLINT NOT NULL |
Fiscal Year
|
| 2 |
GL_FACTSI_DEPT |
Character(2) |
VARCHAR2(2) NOT NULL |
FACTS I Department Code - needed for FACTS I flat-file submission
|
| 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 |
GL_FACTSI_ACCT |
Character(4) |
VARCHAR2(4) NOT NULL |
FACTS I Account
|
| 6 |
TSYMBOL_ATTRIB |
Character(16) |
VARCHAR2(16) NOT NULL |
Treasury Symbol Attribute
|
| 7 |
SECTOR_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
FACTS I Sector Type
|
| 8 |
INTDEPT_CD |
Character(2) |
VARCHAR2(2) NOT NULL |
FACTS I Interdepartment Code
|
| 9 |
EX |
Character(1) |
VARCHAR2(1) NOT NULL |
Expenses
|
| 10 |
OMB_FUNCTION |
Character(3) |
VARCHAR2(3) NOT NULL |
Function
|
| 11 |
CUST_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Customer Option
|
| 12 |
F1_ERROR_TYPE |
Character(2) |
VARCHAR2(2) NOT NULL |
F1_ERROR_TYPE
FACTS I Error type resulting from FACTS I validation edits
|