PG_ORGACK_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
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_SCHEDULED_PELL	Character(5)	VARCHAR2(5) NOT NULL	Scheduled Pell Grant
44	PG_PREV_ISIR_TXN	Character(2)	VARCHAR2(2) NOT NULL	Previous Accepted ISIR Txn Nbr
45	PG_PREV_EFC	Character(5)	VARCHAR2(5) NOT NULL	Previous Accepted EFC
46	PG_PREV_SEC_EFC_CD	Character(1)	VARCHAR2(1) NOT NULL	Previous Secondary EFC Code
47	PG_PREV_COA	Character(7)	VARCHAR2(7) NOT NULL	Previous Accepted COA
48	PG_MSG_CODE_1	Character(3)	VARCHAR2(3) NOT NULL	Message Code 1
49	PG_MSG_CODE_2	Character(3)	VARCHAR2(3) NOT NULL	Message Code 2
50	PG_MSG_CODE_3	Character(3)	VARCHAR2(3) NOT NULL	Message Code 3
51	PG_MSG_CODE_4	Character(3)	VARCHAR2(3) NOT NULL	Message Code 4
52	PG_MSG_CODE_5	Character(3)	VARCHAR2(3) NOT NULL	Message Code 5
53	PG_MSG_CODE_6	Character(3)	VARCHAR2(3) NOT NULL	Message Code 6
54	PG_MSG_CODE_7	Character(3)	VARCHAR2(3) NOT NULL	Message Code 7
55	PG_MSG_CODE_8	Character(3)	VARCHAR2(3) NOT NULL	Message Code 8
56	PG_MSG_CODE_9	Character(3)	VARCHAR2(3) NOT NULL	Message Code 9
57	PG_MSG_CODE_10	Character(3)	VARCHAR2(3) NOT NULL	Message Code 10
58	PG_MSG_CODE_11	Character(3)	VARCHAR2(3) NOT NULL	Message Code 11
59	PG_MSG_CODE_12	Character(3)	VARCHAR2(3) NOT NULL	Message Code 12
60	PG_MSG_CODE_13	Character(3)	VARCHAR2(3) NOT NULL	Message Code 13
61	PG_MSG_CODE_14	Character(3)	VARCHAR2(3) NOT NULL	Message Code 14
62	PG_MSG_CODE_15	Character(3)	VARCHAR2(3) NOT NULL	Message Code 15
63	PG_MSG_CODE_16	Character(3)	VARCHAR2(3) NOT NULL	Message Code 16
64	PG_MSG_CODE_17	Character(3)	VARCHAR2(3) NOT NULL	Message Code 17
65	PG_MSG_CODE_18	Character(3)	VARCHAR2(3) NOT NULL	Message Code 18
66	PG_MSG_CODE_19	Character(3)	VARCHAR2(3) NOT NULL	Message Code 19
67	PG_MSG_CODE_20	Character(3)	VARCHAR2(3) NOT NULL	Message Code 20
68	PG_MSG_CODE_21	Character(3)	VARCHAR2(3) NOT NULL	Message Code 21
69	PG_MSG_CODE_22	Character(3)	VARCHAR2(3) NOT NULL	Message Code 22
70	PG_MSG_CODE_23	Character(3)	VARCHAR2(3) NOT NULL	Message Code 23
71	PG_MSG_CODE_24	Character(3)	VARCHAR2(3) NOT NULL	Message Code 24
72	PG_MSG_CODE_25	Character(3)	VARCHAR2(3) NOT NULL	Message Code 25
73	PG_ED_USE_FLAG_1	Character(1)	VARCHAR2(1) NOT NULL	Ed Use Flag 1 1=Shared SAR ID
74	PG_ED_USE_FLAG_2	Character(1)	VARCHAR2(1) NOT NULL	Ed Use Flag 2 1=Verification W Status
75	PG_ED_USE_FLAG_3	Character(1)	VARCHAR2(1) NOT NULL	Ed Use Flag 3 1=Concurrent Enrollment
76	PG_ED_USE_FLAG_4	Character(1)	VARCHAR2(1) NOT NULL	Ed Use Flag 4 1=POP
77	PG_ED_USE_FLAG_5	Character(1)	VARCHAR2(1) NOT NULL	Ed Use Flag 5
78	PG_ED_USE_FLAG_6	Character(1)	VARCHAR2(1) NOT NULL	Ed Use Flag 6
79	PG_ED_USE_FLAG_7	Character(1)	VARCHAR2(1) NOT NULL	Ed Use Flag 7
80	PG_ED_USE_FLAG_8	Character(1)	VARCHAR2(1) NOT NULL	Ed Use Flag 8
81	PG_ED_USE_FLAG_9	Character(1)	VARCHAR2(1) NOT NULL	Ed Use Flag 9
82	PG_ED_USE_FLAG_10	Character(1)	VARCHAR2(1) NOT NULL	Ed Use Flag 10
83	PG_NEG_PEND_AMT	Character(7)	VARCHAR2(7) NOT NULL	Pell Negative Pending Amount
84	PG_SEC_EFC	Character(5)	VARCHAR2(5) NOT NULL	Pell Secondary EFC
85	PG_CURRENT_SSN	Character(9)	VARCHAR2(9) NOT NULL	Student Current SSN
86	PG_DATE_OF_BIRTH	Character(8)	VARCHAR2(8) NOT NULL	Pell Student Date of Birth
87	PG_LAST_NAME	Character(35)	VARCHAR2(35) NOT NULL	PG Last Name
88	PG_FIRST_NAME	Character(35)	VARCHAR2(35) NOT NULL	PG First Name
89	PG_MIDLE_INITIAL	Character(35)	VARCHAR2(35) NOT NULL	PG Middle Inital
90	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance
91	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
92	PELL_TRANS_DTTM	DateTime(26)	TIMESTAMP	Pell Trans Date/Time
93	PG_DISB_SEQ_NBR	Character(3)	VARCHAR2(3) NOT NULL	Disbursement Seq Nbr