SF1220_RPT_TBL

(SQL Table)
Index Back

SF1220 Report Staging Tbl

Use as a staging table for SF1219/1220 report flatfile creation. Holds the '4.10' String ID of the flatfile.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 STRING_ID Character(18) VARCHAR2(18) NOT NULL String ID
2 SUM_AMOUNT1 Signed Number(16,0) DECIMAL(15) NOT NULL Signed number with no decimal.
3 SUM_AMOUNT2 Signed Number(16,0) DECIMAL(15) NOT NULL Signed number with no decimals
4 CF_ATTRIB_VALUE Character(20) VARCHAR2(20) NOT NULL ChartField Attribute Value
5 SEQ_NUM_CHAR Character(3) VARCHAR2(3) NOT NULL An internal work field utilized in nVision position reporting.