PG_DISB_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	PG_DISB_REF_NBR	Character(2)	VARCHAR2(2) NOT NULL	Disbursement Reference Nbr
6	PELL_ORIG_SEQ_NBR	Number(2,0)	SMALLINT NOT NULL	Pell Origination Sequence Nbr
7	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
8	PG_ACTION_CODE	Character(1)	VARCHAR2(1) NOT NULL	Action Code
9	PG_DEBIT_CREDIT	Character(1)	VARCHAR2(1) NOT NULL	Debit/Credit Indicator
10	PG_DISB_AMOUNT	Character(7)	VARCHAR2(7) NOT NULL	Disbursement Amount
11	PG_DISB_DT	Character(8)	VARCHAR2(8) NOT NULL	Disbursement Date
12	PG_PAYPER_START_DT	Character(8)	VARCHAR2(8) NOT NULL	Pay Period Start Dt
13	PG_COD_PELL_AMOUNT	Character(7)	VARCHAR2(7) NOT NULL	Pell COD Disbursement Amount
14	PG_COD_DISB_NUM	Character(2)	VARCHAR2(2) NOT NULL	Pell COD Disbursement Number
15	PG_COD_DISB_SEQ	Character(2)	VARCHAR2(2) NOT NULL	Pell COD Disbursement Sequence