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