CL_EXP_ALT_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: O
4	CL_BATCH_ID	Character(12)	VARCHAR2(12) NOT NULL	CommonLine Batch ID
5	CL_UNIQUE_ID	Character(21)	VARCHAR2(21) NOT NULL	Loan ID
6	CL_TYPE_CODE	Character(2)	VARCHAR2(2) NOT NULL	CL Loan Type Code
7	LN_DEST_NBR	Number(3,0)	SMALLINT NOT NULL	Loan Destination Num
8	CL_ALT_LAY_OWN_CD	Character(4)	VARCHAR2(4) NOT NULL	Alt Loan Owner Layout Code
9	CL_ALT_LAY_ID_CD	Character(2)	VARCHAR2(2) NOT NULL	Alt Loan Layout ID Code
10	CL_STAF_DEBT_AMT_O	Number(5,0)	INTEGER NOT NULL	Federal Stafford Loan Debt
11	CL_SLS_DEBT_AMT_O	Number(5,0)	INTEGER NOT NULL	Federal SLS Debt
12	CL_HEAL_DEBT_AMT_O	Number(6,0)	INTEGER NOT NULL	Heal Loan Debt
13	CL_PERK_DEBT_AMT_O	Number(5,0)	INTEGER NOT NULL	Perkins Loan Debt
14	CL_OTHER_DBT_AMT_O	Number(6,0)	INTEGER NOT NULL	Other Loan Debt
15	CL_OTHR_LN_IN_PR_O	Number(7,0)	INTEGER NOT NULL	Other Loans in this Period
16	CL_DIFF_NAME_CD	Character(1)	VARCHAR2(1) NOT NULL	Credit Under Different Name Cd
17	CL_COS1_LAST_NAME	Character(35)	VARCHAR2(35) NOT NULL	Cosigner 1 Last Name
18	CL_COS1_FIRST_NAME	Character(12)	VARCHAR2(12) NOT NULL	Cosigner 1 First Name
19	CL_COS1_MID_INIT	Character(1)	VARCHAR2(1) NOT NULL	Cosigner 1 Middle Initial
20	CL_COS1_SSN	Character(9)	VARCHAR2(9) NOT NULL	Cosigner 1 SSN
21	CL_COS1_CIT_CD	Character(1)	VARCHAR2(1) NOT NULL	Cosigner 1 U.S. Citizenship Cd
22	CL_COS1_ADDR1	Character(30)	VARCHAR2(30) NOT NULL	Cosigner 1 Address Line 1
23	CL_COS1_ADDR2	Character(30)	VARCHAR2(30) NOT NULL	Cosigner 1 Address Line 2
24	CL_COS1_CITY	Character(30)	VARCHAR2(30) NOT NULL	Cosigner 1 City
25	CL_COS1_STATE_CD	Character(6)	VARCHAR2(6) NOT NULL	Cosigner 1 State Code
26	CL_COS1_ZIP	Character(12)	VARCHAR2(12) NOT NULL	Cosigner 1 Zip+4 Default Value: 00000
27	CL_COS1_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Cosigner 1 Telephone
28	CL_COS1_SIG_CD	Character(1)	VARCHAR2(1) NOT NULL	Cosigner 1 Signature Code
29	CL_COS2_LAST_NAME	Character(35)	VARCHAR2(35) NOT NULL	Cosigner 2 Last Name
30	CL_COS2_FIRST_NAME	Character(12)	VARCHAR2(12) NOT NULL	Cosigner 2 First Name
31	CL_COS2_MID_INIT	Character(1)	VARCHAR2(1) NOT NULL	Cosigner 2 Middle Initial
32	CL_COS2_SSN	Character(9)	VARCHAR2(9) NOT NULL	Cosigner 2 SSN
33	CL_COS2_CIT_CD	Character(1)	VARCHAR2(1) NOT NULL	Cosigner 2 U.S. Citizenship Cd
34	CL_COS2_ADDR1	Character(30)	VARCHAR2(30) NOT NULL	Cosigner 2 Address Line 1
35	CL_COS2_ADDR2	Character(30)	VARCHAR2(30) NOT NULL	Cosigner 2 Address Line 2
36	CL_COS2_CITY	Character(30)	VARCHAR2(30) NOT NULL	Cosigner 2 City
37	CL_COS2_STATE_CD	Character(6)	VARCHAR2(6) NOT NULL	Cosigner 2 State Code
38	CL_COS2_ZIP	Character(12)	VARCHAR2(12) NOT NULL	Cosigner 2 Zip+4 Default Value: 00000
39	CL_COS2_PHONE	Character(24)	VARCHAR2(24) NOT NULL	Cosigner 2 Telephone
40	CL_COS2_SIG_CD	Character(1)	VARCHAR2(1) NOT NULL	Cosigner 2 Signature Code