SF1219_RPT_TBL (SQL Table)	Index Back
SF1219 Report Staging Table Use as a staging table when creating a SF1219/1220 report in flatfile. Holds all the String ID # except '4.10' (see SF1220_RPT_TBL for '4.10').

SF1219_RPT_TBL

(SQL Table)

SF1219 Report Staging Table

Use as a staging table when creating a SF1219/1220 report in flatfile. Holds all the String ID # except '4.10' (see SF1220_RPT_TBL for '4.10').

# 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 ALC Character(8) VARCHAR2(8) NOT NULL Agency Location Code

4 ISSUE_DT_MM_YY Character(5) VARCHAR2(5) NOT NULL Issue Date string format of MM/YY

5 DTL_ACTION_STATUS Character(1) VARCHAR2(1) NOT NULL Link to ChartField Header Inquiry

#	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	ALC	Character(8)	VARCHAR2(8) NOT NULL	Agency Location Code
4	ISSUE_DT_MM_YY	Character(5)	VARCHAR2(5) NOT NULL	Issue Date string format of MM/YY
5	DTL_ACTION_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Link to ChartField Header Inquiry