DL_DSBACK_02_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	DL_LOAN_ID	Character(21)	VARCHAR2(21) NOT NULL	DL Loan ID
5	DL_DISB_01_NBR	Character(2)	VARCHAR2(2) NOT NULL	Direct Lending Disbursement Number for for aid year 2000-2001. This field has increased to 2 digits from aid year 1999-2000 (field DL_DISB_NBR)
6	DL_DISB_ACTION	Character(1)	VARCHAR2(1) NOT NULL	Disbursement Action
7	DL_DISBURS_ACTN_DT	Character(8)	VARCHAR2(8) NOT NULL	Disbursement Action Dt
8	DL_DISB_SEQ_NBR	Character(2)	VARCHAR2(2) NOT NULL	Disbursement Seq Nbr
9	DL_DISB_ACT_GROSS	Character(5)	VARCHAR2(5) NOT NULL	Actual Gross Amt
10	DL_DISB_ACT_FEE	Character(5)	VARCHAR2(5) NOT NULL	Actual Fee Amt
11	DL_DISB_ACT_NET	Character(5)	VARCHAR2(5) NOT NULL	Actual Net Amount
12	DL_DISB_ACT_REBATE	Character(5)	VARCHAR2(5) NOT NULL	Actual Rebate Amt
13	DL_USERID_CREATE	Character(8)	VARCHAR2(8) NOT NULL	User ID Create
14	DL_BATCH_ID_00	Character(23)	VARCHAR2(23) NOT NULL	DL Batch ID
15	DL_SCHOOL_CD	Character(6)	VARCHAR2(6) NOT NULL	School Code
16	DL_SCHL_CD_STAT	Character(1)	VARCHAR2(1) NOT NULL	School Code Status
17	DL_LOAN_ID_STAT	Character(1)	VARCHAR2(1) NOT NULL	Loan ID Status
18	DL_DISB_NBR_STAT	Character(1)	VARCHAR2(1) NOT NULL	Disbursement Nbr Status
19	DL_DISB_RJCT_1	Character(2)	VARCHAR2(2) NOT NULL	DL Disb Reject 1
20	DL_DISB_RJCT_2	Character(2)	VARCHAR2(2) NOT NULL	DL Disb Reject 2
21	DL_DISB_RJCT_3	Character(2)	VARCHAR2(2) NOT NULL	DL Disb Reject 3
22	DL_DISB_RJCT_4	Character(2)	VARCHAR2(2) NOT NULL	DL Disb Reject 4
23	DL_DISB_RJCT_5	Character(2)	VARCHAR2(2) NOT NULL	DL Disb Reject 5
24	DL_ACTNDT_STAT	Character(1)	VARCHAR2(1) NOT NULL	DL Action Dt Status
25	DL_DISB_SEQ_STAT	Character(1)	VARCHAR2(1) NOT NULL	Disbursement Seq Status
26	DL_DISB_GROSS_SVCR	Character(5)	VARCHAR2(5) NOT NULL	Svcr Actual Gross
27	DL_DISB_FEE_SVCR	Character(5)	VARCHAR2(5) NOT NULL	Svcr Actual Fee
28	DL_DISB_NET_SVCR	Character(5)	VARCHAR2(5) NOT NULL	Svcr Actual Net
29	DL_DISB_ADJ_SVCR	Character(6)	VARCHAR2(6) NOT NULL	Svcr Actual Adjustment
30	DL_FRST_DISB_FLG	Character(1)	VARCHAR2(1) NOT NULL	First Disb Flag
31	DL_DISB_REB_SVCR	Character(5)	VARCHAR2(5) NOT NULL	Svcr Actual Rebate
32	DL_SRVCR_TOT_NET	Character(5)	VARCHAR2(5) NOT NULL	Srvc Total Booked Net
33	DL_DISB_ACK_DT	Character(8)	VARCHAR2(8) NOT NULL	Acknowledgement Date
34	DL_DSB_AFFIRM_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Affirmation Flag
35	LNTRANS_PROC_DTTM	DateTime(26)	TIMESTAMP	Loan Proc Dt/Tm
36	LN_STG_PROC_STAT	Character(1)	VARCHAR2(1) NOT NULL	Loan Staging Record Proc Stat E=Error K=Skipped L=Loaded N=Not Processed S=Skip U=Unprocessed X=Suspended Y=Processed Default Value: N
37	PROCESS_INSTANCE	Number(10,0)	DECIMAL(10) NOT NULL	Process Instance