DL_EXTCNS_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_EXIT_CMP_TIME	Character(8)	VARCHAR2(8) NOT NULL	Exit Counseling Completion Tim
18	SFA_EXIT_R_ACK	Character(3)	VARCHAR2(3) NOT NULL	Rights Acknowledgement
19	SFA_LN_CURR_ADDR1	Character(25)	VARCHAR2(25) NOT NULL	Current Address Line1
20	SFA_LN_CURR_ADDR2	Character(25)	VARCHAR2(25) NOT NULL	Current Address Line2
21	SFA_LN_CURR_CITY	Character(16)	VARCHAR2(16) NOT NULL	Borrower Curr Address City
22	SFA_LN_CURR_STATE	Character(2)	VARCHAR2(2) NOT NULL	Borrower Curr Address State
23	SFA_LN_CURR_ZIP	Character(9)	VARCHAR2(9) NOT NULL	Borrower Curr Address Zip
24	SFA_LN_CURR_PHONE	Character(10)	VARCHAR2(10) NOT NULL	Borrower Current Home Phone
25	DL_BORR_DRV_LC_ST	Character(2)	VARCHAR2(2) NOT NULL	Borrower Drv Lic State
26	DL_BORR_DRIV_LIC	Character(20)	VARCHAR2(20) NOT NULL	Borrower Driver's License Nbr
27	SFA_LN_EMPLR_NAME	Character(25)	VARCHAR2(25) NOT NULL	Employer Name
28	SFA_LN_EMPLR_ADDR1	Character(25)	VARCHAR2(25) NOT NULL	Employer's Address Line1
29	SFA_LN_EMPLR_ADDR2	Character(25)	VARCHAR2(25) NOT NULL	Employer Address Line2
30	SFA_LN_EMPLR_CITY	Character(16)	VARCHAR2(16) NOT NULL	Employer City
31	SFA_LN_EMPLR_STATE	Character(2)	VARCHAR2(2) NOT NULL	Employer State Code
32	SFA_LN_EMPLR_ZIP	Character(9)	VARCHAR2(9) NOT NULL	Employers Zip Code
33	SFA_LN_EMPLR_PHONE	Character(10)	VARCHAR2(10) NOT NULL	Employer Phone Number
34	SFA_LN_REF1_NAME	Character(25)	VARCHAR2(25) NOT NULL	Reference1 Name
35	SFA_LN_REF1_ADDR1	Character(25)	VARCHAR2(25) NOT NULL	Reference1 Address1
36	SFA_LN_REF1_ADDR2	Character(25)	VARCHAR2(25) NOT NULL	Reference1 Address2
37	SFA_LN_REF1_CITY	Character(16)	VARCHAR2(16) NOT NULL	Reference1 City
38	SFA_LN_REF1_STATE	Character(2)	VARCHAR2(2) NOT NULL	Reference1 State Code
39	SFA_LN_REF1_ZIP	Character(9)	VARCHAR2(9) NOT NULL	Reference1 Zip Code
40	SFA_LN_REF1_PHONE	Character(10)	VARCHAR2(10) NOT NULL	Reference1 Phone Number
41	SFA_LN_REF2_NAME	Character(25)	VARCHAR2(25) NOT NULL	Reference2 Name
42	SFA_LN_REF2_ADDR1	Character(25)	VARCHAR2(25) NOT NULL	Reference2 Address1
43	SFA_LN_REF2_ADDR2	Character(25)	VARCHAR2(25) NOT NULL	Reference2 Address2
44	SFA_LN_REF2_CITY	Character(16)	VARCHAR2(16) NOT NULL	Reference2 City
45	SFA_LN_REF2_STATE	Character(2)	VARCHAR2(2) NOT NULL	Reference2 State Code
46	SFA_LN_REF2_ZIP	Character(9)	VARCHAR2(9) NOT NULL	Reference2 Zip Code
47	SFA_LN_REF2_PHONE	Character(10)	VARCHAR2(10) NOT NULL	Reference2 Phone Number
48	SFA_LN_NOK_NAME	Character(25)	VARCHAR2(25) NOT NULL	Next of Kin Name
49	SFA_LN_NOK_ADDR1	Character(25)	VARCHAR2(25) NOT NULL	Next of Kin Address1
50	SFA_LN_NOK_ADDR2	Character(25)	VARCHAR2(25) NOT NULL	Next of Kin Address2
51	SFA_LN_NOK_CITY	Character(16)	VARCHAR2(16) NOT NULL	Next of Kin City
52	SFA_LN_NOK_STATE	Character(2)	VARCHAR2(2) NOT NULL	Next of Kin State Code
53	SFA_LN_NOK_ZIP	Character(9)	VARCHAR2(9) NOT NULL	Next of Kin Zip Code
54	SFA_LN_NOK_PHONE	Character(10)	VARCHAR2(10) NOT NULL	Next of Kin Phone Number
55	SFA_LN_PERM_ADDR1	Character(25)	VARCHAR2(25) NOT NULL	Borrower Permanent Address1
56	SFA_LN_PERM_ADDR2	Character(25)	VARCHAR2(25) NOT NULL	Borrower Permanent Address2
57	DL_BORR_PERM_CITY	Character(16)	VARCHAR2(16) NOT NULL	Borrower Perm Addr City
58	DL_BORR_PERM_STATE	Character(2)	VARCHAR2(2) NOT NULL	Borrower Perm Addr State
59	DL_BORR_PERM_ZIPCD	Character(9)	VARCHAR2(9) NOT NULL	Borrower Perm Addr Zip
60	DL_BORR_PHONE_NBR	Character(10)	VARCHAR2(10) NOT NULL	Borrower Phone Number
61	SFA_LN_MEDIA_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Borr Rights & Resp Media Type