DL_ENTCNS_07_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	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	SFA_LN_FILE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Loan Couseling File Type
8	AID_YEAR	Character(4)	VARCHAR2(4) NOT NULL	Aid Year
9	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
10	SFA_LN_LOAD_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Load Status L=Loaded N=Not Loaded
11	DL_BORR_SSN	Character(9)	VARCHAR2(9) NOT NULL	Borrower SSN
12	DL_BORR_DOB	Character(8)	VARCHAR2(8) NOT NULL	Borrower Dt of Birth
13	DL_BORR_LAST_NAME	Character(35)	VARCHAR2(35) NOT NULL	Borrower's Last Name
14	DL_BORR_FRST_NM_02	Character(35)	VARCHAR2(35) NOT NULL	Borrower's First Name
15	DL_BORR_MI	Character(35)	VARCHAR2(35) NOT NULL	Borrower's Middle Initial
16	SFA_LN_CNSL_CMP_DT	Date(10)	DATE	Date Completed
17	SFA_ENTRANCE_CMPTM	Character(6)	VARCHAR2(6) NOT NULL	Entrance Completion Time
18	SFA_ENTRANCE_R_ACK	Character(1)	VARCHAR2(1) NOT NULL	Rights Acknowledgement