SFA_ASG_SAR_EC

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ECTRANSID	Character(15)	VARCHAR2(15) NOT NULL	Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
2	ECQUEUEINSTANCE	Number(9,0)	DECIMAL(9) NOT NULL	Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
3	ECTRANSINOUTSW	Character(1)	VARCHAR2(1) NOT NULL	Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound. I=Inbound O=Outbound Default Value: I
4	PG_SOA_SEQ	Number(3,0)	SMALLINT NOT NULL	Pell SOA Sequence Number
5	PG_RECORD_INDIC	Character(1)	VARCHAR2(1) NOT NULL	Record Indicator
6	TIV_SCHOOL_CODE	Character(6)	VARCHAR2(6) NOT NULL	Pell ID Reporting
7	GRANTEE_DUNS_NBR	Character(11)	VARCHAR2(11) NOT NULL	Grantee DUNS Number
8	SFA_COMMON_SCHL_ID	Character(8)	VARCHAR2(8) NOT NULL	Common School ID for use with the Department of Education financial aid.
9	PG_GAPS_AWARD_NBR	Character(16)	VARCHAR2(16) NOT NULL	GAPS Award Number
10	PG_ACCT_SCHD_DT	Date(10)	DATE	Accounting Schedule Date
11	PG_PRE_OBLG_AMT	Number(12,2)	DECIMAL(11,2) NOT NULL	Previous Obligation Amount
12	PG_TOT_OBG_ADJAMT	Number(12,2)	DECIMAL(11,2) NOT NULL	Total Obligation Adj Amount
13	PG_CUR_OBG_AMT	Number(12,2)	DECIMAL(11,2) NOT NULL	Current Obligation Amount
14	PG_PRE_PAY_AMT	Number(12,2)	DECIMAL(11,2) NOT NULL	Previous Payment Amount
15	PG_TOT_PAY_ADJAMT	Number(12,2)	DECIMAL(11,2) NOT NULL	Total Payment Adj Amount
16	PG_CUR_PAYAMT	Number(12,2)	DECIMAL(11,2) NOT NULL	Current Payment Amount
17	PG_YTD_TOT_UNDRCP	Number(7,0)	INTEGER NOT NULL	YTD Total Unduplicated Receipt
18	PG_YTD_ACPT_DBAMT	Number(12,2)	DECIMAL(11,2) NOT NULL	YTD Accepted Disbursement Amt
19	PG_YTD_ADM_CSTALW	Number(12,2)	DECIMAL(11,2) NOT NULL	YTD Admin Cost Allowance
20	PG_GAPS_EXPAMT	Number(14,2)	DECIMAL(13,2) NOT NULL	GAPS Expenditure Amount
21	PG_GAPS_LST_ACTDT	Date(10)	DATE	Date of Last Activity in GAPS
22	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
23	PG_STG_PROC_STAT	Character(1)	VARCHAR2(1) NOT NULL	Pell Staging Rec Proc Status E=Error N=Not Processed P=Processed Default Value: N
24	PELL_TRANS_DTTM	DateTime(26)	TIMESTAMP	Pell Trans Date/Time