PG_ORIG_00_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: O
4	PG_ORIGINATION_ID	Character(23)	VARCHAR2(23) NOT NULL	Pell Origination ID
5	PELL_ORIG_SEQ_NBR	Number(2,0)	SMALLINT NOT NULL	Pell Origination Sequence Nbr
6	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
7	PG_ORIG_SSN	Character(9)	VARCHAR2(9) NOT NULL	Original SSN
8	PG_NAME_CODE	Character(2)	VARCHAR2(2) NOT NULL	Original Name Code
9	PG_ATTEND_ID	Character(6)	VARCHAR2(6) NOT NULL	Pell Attending Campus ID
10	PG_ACTION_CODE	Character(1)	VARCHAR2(1) NOT NULL	Action Code
11	PG_NBR_PAY_PERIODS	Character(1)	VARCHAR2(1) NOT NULL	Number of Payment Periods
12	PG_PELL_AWARD_AMT	Character(7)	VARCHAR2(7) NOT NULL	School Year Award Amount
13	PG_EST_DISB_DT_1	Character(8)	VARCHAR2(8) NOT NULL	Estimated Disbursement Date 1
14	PG_EST_DISB_DT_2	Character(8)	VARCHAR2(8) NOT NULL	Estimated Disbursement Date 2
15	PG_EST_DISB_DT_3	Character(8)	VARCHAR2(8) NOT NULL	Estimated Disbursement Date 3
16	PG_EST_DISB_DT_4	Character(8)	VARCHAR2(8) NOT NULL	Estimated Disbursement Date 4
17	PG_EST_DISB_DT_5	Character(8)	VARCHAR2(8) NOT NULL	Estimated Disbursement Date 5
18	PG_EST_DISB_DT_6	Character(8)	VARCHAR2(8) NOT NULL	Estimated Disbursement Date 6
19	PG_EST_DISB_DT_7	Character(8)	VARCHAR2(8) NOT NULL	Estimated Disbursement Date 7
20	PG_EST_DISB_DT_8	Character(8)	VARCHAR2(8) NOT NULL	Estimated Disbursement Date 8
21	PG_EST_DISB_DT_9	Character(8)	VARCHAR2(8) NOT NULL	Estimated Disbursement Date 9
22	PG_EST_DISB_DT_10	Character(8)	VARCHAR2(8) NOT NULL	Estimated Disbursement Date 10
23	PG_EST_DISB_DT_11	Character(8)	VARCHAR2(8) NOT NULL	Estimated Disbursement Date 11
24	PG_EST_DISB_DT_12	Character(8)	VARCHAR2(8) NOT NULL	Estimated Disbursement Date 12
25	PG_EST_DISB_DT_13	Character(8)	VARCHAR2(8) NOT NULL	Estimated Disbursement Date 13
26	PG_EST_DISB_DT_14	Character(8)	VARCHAR2(8) NOT NULL	Estimated Disbursement Date 14
27	PG_EST_DISB_DT_15	Character(8)	VARCHAR2(8) NOT NULL	Estimated Disbursement Date 15
28	PG_ENROLLMNT_DT	Character(8)	VARCHAR2(8) NOT NULL	Enrollment Date
29	PG_LOW_TUITION_CD	Character(1)	VARCHAR2(1) NOT NULL	Low Tuition and Fees Code
30	PG_VERIF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Verification Status Code
31	PG_INCARCERATED_CD	Character(1)	VARCHAR2(1) NOT NULL	Incarcerated Code
32	PG_ISIR_TXN_NBR	Character(2)	VARCHAR2(2) NOT NULL	ISIR Transaction Number
33	PG_PELL_EFC	Character(5)	VARCHAR2(5) NOT NULL	Expected Family Contribution
34	PG_SECNDRY_EFC_CD	Character(1)	VARCHAR2(1) NOT NULL	Secondary EFC Code
35	PG_ACAD_CALENDAR	Character(1)	VARCHAR2(1) NOT NULL	Academic Calendar
36	PG_PAYMENT_METHOD	Character(1)	VARCHAR2(1) NOT NULL	Payment Methodology
37	PG_PELL_COA	Character(7)	VARCHAR2(7) NOT NULL	Cost of Attendeance
38	PG_ENROLLMENT_STAT	Character(1)	VARCHAR2(1) NOT NULL	Enrollment Status
39	PG_WEEKS_USED_CALC	Character(2)	VARCHAR2(2) NOT NULL	Weeks Used in Calculation
40	PG_WEEKS_ACAD_YEAR	Character(2)	VARCHAR2(2) NOT NULL	Weeks in Prgm Acad Year
41	PG_HOURS_PAY_PER	Character(4)	VARCHAR2(4) NOT NULL	Hours used in Payment Period
42	PG_HOURS_ACAD_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Hours in Academic Year
43	PG_CURRENT_SSN	Character(9)	VARCHAR2(9) NOT NULL	Student Current SSN
44	PG_DATE_OF_BIRTH	Character(8)	VARCHAR2(8) NOT NULL	Pell Student Date of Birth
45	PG_LAST_NAME	Character(35)	VARCHAR2(35) NOT NULL	PG Last Name
46	PG_FIRST_NAME	Character(35)	VARCHAR2(35) NOT NULL	PG First Name
47	PG_MIDLE_INITIAL	Character(35)	VARCHAR2(35) NOT NULL	PG Middle Inital