DATA_C_STG_HDR(SQL Table) |
Index Back |
---|---|
FOMB C Staging Header |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_GL_NONVW |
2 | TAS_GWA | Character(26) | VARCHAR2(26) NOT NULL | TAS GWA |
3 | REPORT_ID | Character(8) | VARCHAR2(8) NOT NULL | Report Identifier |
4 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
5 | CREATE_DATE | Date(10) | DATE | Creation Date |
6 | PERIOD_FROM | Number(3,0) | SMALLINT NOT NULL | From Period |
7 | PERIOD_TO | Number(3,0) | SMALLINT NOT NULL | To Period |