CL_APR_ALT4_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
4	LN_DTL_NBR	Number(5,0)	INTEGER NOT NULL	Loan Detail Line Number
5	CL_UNIQUE_ID4	Character(17)	VARCHAR2(17) NOT NULL	CL Loan Unique Identifier
6	CL_ALT_LAY_OWN_CD	Character(4)	VARCHAR2(4) NOT NULL	Alt Loan Owner Layout Code
7	CL_ALT_LAY_ID_CD	Character(2)	VARCHAR2(2) NOT NULL	Alt Loan Layout ID Code
8	CL_STAF_DEBT_AMT	Character(5)	VARCHAR2(5) NOT NULL	Federal Stafford Loan Debt
9	CL_SLS_DEBT_AMT	Character(5)	VARCHAR2(5) NOT NULL	Federal SLS Debt
10	CL_HEAL_DEBT_AMT	Character(6)	VARCHAR2(6) NOT NULL	Heal Loan Debt
11	CL_PERK_DEBT_AMT	Character(5)	VARCHAR2(5) NOT NULL	Perkins Loan Debt
12	CL_OTHER_DEBT_AMT	Character(6)	VARCHAR2(6) NOT NULL	Other Loan Debt
13	CL_OTHR_LN_IN_PER	Character(7)	VARCHAR2(7) NOT NULL	Other Loans in This Period
14	CL_DIFF_NAME_CD	Character(1)	VARCHAR2(1) NOT NULL	Credit Under Different Name Cd
15	CL_COS1_LAST_NAME	Character(35)	VARCHAR2(35) NOT NULL	Cosigner 1 Last Name
16	CL_COS1_FIRST_NAME	Character(12)	VARCHAR2(12) NOT NULL	Cosigner 1 First Name
17	CL_COS1_MID_INIT	Character(1)	VARCHAR2(1) NOT NULL	Cosigner 1 Middle Initial
18	CL_COS1_SSN	Character(9)	VARCHAR2(9) NOT NULL	Cosigner 1 SSN
19	CL_COS1_CIT_CD	Character(1)	VARCHAR2(1) NOT NULL	Cosigner 1 U.S. Citizenship Cd
20	CL_COS1_ADDR1	Character(30)	VARCHAR2(30) NOT NULL	Cosigner 1 Address Line 1
21	CL_COS1_ADDR2	Character(30)	VARCHAR2(30) NOT NULL	Cosigner 1 Address Line 2
22	CL_COS1_CITY3	Character(24)	VARCHAR2(24) NOT NULL	CommonLine Cosigner 1 Perm Cty
23	CL_COS1_STATE_CD2	Character(2)	VARCHAR2(2) NOT NULL	Cosigner 1 State Code
24	CL_COS1_ZIP_O	Character(5)	VARCHAR2(5) NOT NULL	Cosigner 1 Zip
25	CL_COS1_ZIP_SFX	Character(4)	VARCHAR2(4) NOT NULL	Cosigner 1 Zip Code Suffix
26	CL_COS1_PHONE10	Character(10)	VARCHAR2(10) NOT NULL	Cosigner 1 Phone10
27	CL_COS1_SIG_CD	Character(1)	VARCHAR2(1) NOT NULL	Cosigner 1 Signature Code
28	CL_COS2_LAST_NAME	Character(35)	VARCHAR2(35) NOT NULL	Cosigner 2 Last Name
29	CL_COS2_FIRST_NAME	Character(12)	VARCHAR2(12) NOT NULL	Cosigner 2 First Name
30	CL_COS2_MID_INIT	Character(1)	VARCHAR2(1) NOT NULL	Cosigner 2 Middle Initial
31	CL_COS2_SSN	Character(9)	VARCHAR2(9) NOT NULL	Cosigner 2 SSN
32	CL_COS2_CIT_CD	Character(1)	VARCHAR2(1) NOT NULL	Cosigner 2 U.S. Citizenship Cd
33	CL_COS2_ADDR1	Character(30)	VARCHAR2(30) NOT NULL	Cosigner 2 Address Line 1
34	CL_COS2_ADDR2	Character(30)	VARCHAR2(30) NOT NULL	Cosigner 2 Address Line 2
35	CL_COS2_CITY3	Character(24)	VARCHAR2(24) NOT NULL	CommonLine Cosigner 2 Perm Cty
36	CL_COS2_STATE_CD2	Character(2)	VARCHAR2(2) NOT NULL	Cosigner 2 State Code
37	CL_COS2_ZIP_O	Character(5)	VARCHAR2(5) NOT NULL	Cosigner 2 Zip Code
38	CL_COS2_ZIP_SFX	Character(4)	VARCHAR2(4) NOT NULL	Cosigner 2 Zip Code Suffix
39	CL_COS2_PHONE10	Character(10)	VARCHAR2(10) NOT NULL	Cosigner 2 Phone10
40	CL_COS2_SIG_CD	Character(1)	VARCHAR2(1) NOT NULL	Cosigner 2 Signature Code
41	CL_BORR_SALARY	Character(7)	VARCHAR2(7) NOT NULL	Borrower Gross Annual Salary
42	CL_BORR_OTH_INC	Character(7)	VARCHAR2(7) NOT NULL	Borrower Other Income
43	CL_COS1_SALARY	Character(7)	VARCHAR2(7) NOT NULL	Cosigner 1 Gross Annual Salary
44	CL_COS1_OTH_INC	Character(7)	VARCHAR2(7) NOT NULL	Cosigner 1 Other Income
45	CL_COS2_SALARY	Character(7)	VARCHAR2(7) NOT NULL	Cosigner 2 Gross Annual Salary
46	CL_COS2_OTH_INC	Character(7)	VARCHAR2(7) NOT NULL	Cosigner 2 Other Income
47	CL_FOREIGN_POST_C1	Character(14)	VARCHAR2(14) NOT NULL	Foreign Postal Code Cos 1
48	CL_FOREIGN_POST_C2	Character(14)	VARCHAR2(14) NOT NULL	Foreign Postal Code Cos 2
49	CL_STUDENT_MAJOR	Character(15)	VARCHAR2(15) NOT NULL	Student's Major
50	CL_COS1_BIRTHDT	Character(8)	VARCHAR2(8) NOT NULL	Cosigner 1 Birthdate
51	CL_COS1_DL_STATE	Character(2)	VARCHAR2(2) NOT NULL	Cos 1 Drivers Lic State
52	CL_COS1_DL_NUM	Character(20)	VARCHAR2(20) NOT NULL	Cosigner 1 Drivers Lic Number
53	CL_COS2_BIRTHDT	Character(8)	VARCHAR2(8) NOT NULL	Cosigner 2 Birthdate
54	CL_COS2_DL_STATE	Character(2)	VARCHAR2(2) NOT NULL	Cos 2 Drivers Lic State
55	CL_COS2_DL_NUM	Character(20)	VARCHAR2(20) NOT NULL	Cosigner 2 Drivers Lic Number
56	CL_STU_SCHL_PHONE	Character(10)	VARCHAR2(10) NOT NULL	Student's School Phone
57	CL_COS1_RELATE_STU	Character(1)	VARCHAR2(1) NOT NULL	Cosigner 1 Relationship to Stu
58	CL_COS1_SUFFIX	Character(3)	VARCHAR2(3) NOT NULL	Cosigner 1 suffix
59	CL_COS1_YRS_ADDR	Character(2)	VARCHAR2(2) NOT NULL	Cosigner 1 Years at Address
60	CL_COS2_RELATE_STU	Character(1)	VARCHAR2(1) NOT NULL	Cosigner 2 Relationship to Stu
61	CL_COS2_SUFFIX	Character(3)	VARCHAR2(3) NOT NULL	Cosigner 1 suffix
62	CL_COS2_YRS_ADDR	Character(2)	VARCHAR2(2) NOT NULL	Cosigner 2 Years at Address
63	CL_INT_RATE_OPT	Character(1)	VARCHAR2(1) NOT NULL	Interest Rate Option
64	CL_REPAY_OPT_CD	Character(1)	VARCHAR2(1) NOT NULL	Repayment Option Code