SFA_ASG_YTDO_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	SFA_CR_AWARD_ID	Character(21)	VARCHAR2(21) NOT NULL	Award ID
5	SFA_COD_STDNT_LVL	Character(1)	VARCHAR2(1) NOT NULL	Student Level 0=1st year ugrd never attend 1=1st year ugrd prev attended 2=2nd year ugrd 3=3rd year ugrd 4=4th year ugrd 5=5th year ugrd
6	PG_ORIG_SSN	Character(9)	VARCHAR2(9) NOT NULL	Original SSN
7	PG_NAME_CODE	Character(2)	VARCHAR2(2) NOT NULL	Original Name Code
8	PG_ATTEND_ID	Character(6)	VARCHAR2(6) NOT NULL	Pell Attending Campus ID
9	PELL_ORIG_SEQ_NBR	Number(2,0)	SMALLINT NOT NULL	Pell Origination Sequence Nbr
10	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
11	PG_ACTION_CODE	Character(1)	VARCHAR2(1) NOT NULL	Action Code
12	PELL_AWARD_AMT	Number(8,2)	DECIMAL(7,2) NOT NULL	Total Pell Award Amount
13	PG_EST_DSB_DT_1_O	Date(10)	DATE	Estimated Dsibursement Date 1
14	PG_EST_DSB_DT_2_O	Date(10)	DATE	Estimated Dsibursement Date 2
15	PG_EST_DSB_DT_3_O	Date(10)	DATE	Estimated Dsibursement Date 3
16	PG_EST_DSB_DT_4_O	Date(10)	DATE	Estimated Dsibursement Date 4
17	PG_EST_DSB_DT_5_O	Date(10)	DATE	Estimated Dsibursement Date 5
18	PG_EST_DSB_DT_6_O	Date(10)	DATE	Estimated Dsibursement Date 6
19	PG_EST_DSB_DT_7_O	Date(10)	DATE	Estimated Dsibursement Date 7
20	PG_EST_DSB_DT_8_O	Date(10)	DATE	Estimated Dsibursement Date 8
21	PG_EST_DSB_DT_9_O	Date(10)	DATE	Estimated Dsibursement Date 9
22	PG_EST_DSB_DT_10_O	Date(10)	DATE	Estimated Dsibursement Date 10
23	PG_EST_DSB_DT_11_O	Date(10)	DATE	Estimated Dsibursement Date 11
24	PG_EST_DSB_DT_12_O	Date(10)	DATE	Estimated Dsibursement Date 12
25	PG_EST_DSB_DT_13_O	Date(10)	DATE	Estimated Dsibursement Date 13
26	PG_EST_DSB_DT_14_O	Date(10)	DATE	Estimated Dsibursement Date 14
27	PG_EST_DSB_DT_15_O	Date(10)	DATE	Estimated Dsibursement Date 15
28	PELL_ENRLMNT_DT	Date(10)	DATE	Pell Enrollment Date
29	ISIR_TXN_NBR	Number(2,0)	SMALLINT NOT NULL	Transaction Num
30	PG_DISB_SEQ_NBR	Character(3)	VARCHAR2(3) NOT NULL	Disbursement Seq Nbr
31	SFA_COD_ELIGRSN_CD	Character(2)	VARCHAR2(2) NOT NULL	ACG Eligibility Reason 01=High School Program 02=AP/International Bac Course 03=Coursework
32	SFA_COD_HS_PROG_CD	Character(6)	VARCHAR2(6) NOT NULL	Rigorous High School Program
33	SFA_COD_PROGCIP_CD	Character(7)	VARCHAR2(7) NOT NULL	SMART Eligible CIP Code
34	PG_LAST_NAME	Character(35)	VARCHAR2(35) NOT NULL	PG Last Name
35	PG_FIRST_NAME	Character(35)	VARCHAR2(35) NOT NULL	PG First Name
36	PG_MIDLE_INITIAL	Character(35)	VARCHAR2(35) NOT NULL	PG Middle Inital
37	PG_CURRENT_SSN	Character(9)	VARCHAR2(9) NOT NULL	Student Current SSN
38	PG_DATE_OF_BIRTH_O	Date(10)	DATE	Pell Student Date of Birth
39	PG_YTD_DISB_AMOUNT	Character(7)	VARCHAR2(7) NOT NULL	YTD Disbursed Amount
40	PG_RFMS_PROC_DT_O	Date(10)	DATE	Pell RFMS Process Dt
41	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
42	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
43	PELL_TRANS_DTTM	DateTime(26)	TIMESTAMP	Pell Trans Date/Time