F2_STAGING_HDR(SQL Table) |
Index Back |
|---|---|
FACTS II Staging Header |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_GL_NONVW |
|
| 2 | Character(16) | VARCHAR2(16) NOT NULL | Treasury Symbol Attribute | |
| 3 | Character(8) | VARCHAR2(8) NOT NULL | Report Identifier | |
| 4 | PREPARER_ID | Character(8) | VARCHAR2(8) NOT NULL |
Preparer Identification
Prompt Table: F2_CONTACT_INFO |
| 5 | CERTIFIER_ID | Character(8) | VARCHAR2(8) NOT NULL |
Certifier Identification
Prompt Table: F2_CONTACT_INFO |
| 6 | RPT_FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Reporting Year |
| 7 | RPT_FISCAL_MONTH | Number(2,0) | SMALLINT NOT NULL | Reporting Month |
| 8 | FISCAL_YEAR | Number(4,0) | SMALLINT NOT NULL | Fiscal Year |
| 9 | PERIOD_FROM | Number(3,0) | SMALLINT NOT NULL | From Period |
| 10 | PERIOD_TO | Number(3,0) | SMALLINT NOT NULL | To Period |
| 11 | CREATE_DATE | Date(10) | DATE | Creation Date |
| 12 | EDIT_EFFDT | Date(10) | DATE | Edit Effective Date |
| 13 | MAF_SEQ_NUM | Number(3,0) | SMALLINT NOT NULL | MAF Sequence Number |
| 14 | RELEASE_DATE | Date(10) | DATE | Release Date |