F2_STAGING_HDR(SQL Table) |
Index Back |
---|---|
FACTS II 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 | TSYMBOL_ATTRIB | Character(16) | VARCHAR2(16) NOT NULL | Treasury Symbol Attribute |
3 | REPORT_ID | 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 |