DL_LNLVL_12_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) Default Value: DSLF12OP
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	LN_HEADER_NBR	Number(3,0)	SMALLINT NOT NULL	Loan Header Nbr
5	DL_BATCH_ID_00	Character(23)	VARCHAR2(23) NOT NULL	DL Batch ID
6	DL_DTL_SEQNBR	Number(9,0)	DECIMAL(9) NOT NULL	Detail Sequence Number
7	DL_REC_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Statement Record Type Default Value: L
8	CPS_SCHOOL_CODE	Character(6)	VARCHAR2(6) NOT NULL	CPS School Code. Also known as Title IV School Code
9	DL_REGION_CD	Character(2)	VARCHAR2(2) NOT NULL	Region Code
10	DL_STATE_CD	Character(2)	VARCHAR2(2) NOT NULL	State Code
11	DL_END_DATE_0	Date(10)	DATE	DL End Date
12	DL_PROCESS_DATE_0	Date(10)	DATE	DL Process Date
13	DL_LOAN_ID	Character(21)	VARCHAR2(21) NOT NULL	DL Loan ID
14	DL_LOAN_BKDT_SVCRO	Date(10)	DATE	Loan Booked Date at Servicer
15	DL_ACTL_GRS_SVCR_O	Number(6,0)	INTEGER NOT NULL	DL Actual Servicer Gross
16	DL_ACTL_FEE_SVCR_O	Number(5,0)	INTEGER NOT NULL	DL Actual Servicer Fee
17	DL_ACTL_REB_SVCR_O	Number(5,0)	INTEGER NOT NULL	DL Actual Servicer Rebate
18	DL_ACTL_NET_SVCR_O	Number(6,0)	INTEGER NOT NULL	DL Actual Servicer Net
19	DL_BORR_FRST_NM_02	Character(35)	VARCHAR2(35) NOT NULL	Borrower's First Name
20	DL_BORR_LAST_NAME	Character(35)	VARCHAR2(35) NOT NULL	Borrower's Last Name
21	DL_BORR_MI	Character(35)	VARCHAR2(35) NOT NULL	Borrower's Middle Initial
22	DL_STU_FRST_NM_02	Character(35)	VARCHAR2(35) NOT NULL	Student's First Name
23	DL_STU_LAST_NAME	Character(35)	VARCHAR2(35) NOT NULL	Student's Last Name
24	DL_STU_MI	Character(35)	VARCHAR2(35) NOT NULL	Student's Middle Initial
25	DL_REC_CNTSEQ_NBR0	Number(6,0)	INTEGER NOT NULL	Record Count Sequence #
26	SFA_DL_SERVICER	Character(30)	VARCHAR2(30) NOT NULL	Servicer Name