CL_APR_DTL4_EC

(SQL Table)
Index Back

CL 4 App Export Header EC Rec

EC Record 4/23/99 Created for 7.5 CommonLine 4.

# 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_LOAD_STATUS Character(1) VARCHAR2(1) NOT NULL CommonLine Load Status
E=Error
S=Record Skipped
U=Unprocessed
Y=Processed

Default Value: U

7 CL_REC_STAT_CD Character(1) VARCHAR2(1) NOT NULL CommonLine Record Status Code
A=Initial Proc Successful
B=Guaranteed, Disb Approved
C=School Cert request
D=Denied/Rejected
G=Guaranteed
I=Pending Approval
M=Loan Modification
N=Reprint Response
P=Pending Processing
R=Change Response
T=Termination Record
8 CL_REC_STAT_DT Character(8) VARCHAR2(8) NOT NULL CommonLine Record Status Date
9 CL_BORR_LNAME_O Character(35) VARCHAR2(35) NOT NULL Borrower Last Name
10 CL_BORR_FNAME_O Character(12) VARCHAR2(12) NOT NULL Borrower First Name
11 CL_BORR_MID_INIT_O Character(1) VARCHAR2(1) NOT NULL Borrower Middle Initial
12 CL_BORR_SSN Character(9) VARCHAR2(9) NOT NULL Borrower SSN
13 CL_BORR_PERM_AD1_O Character(30) VARCHAR2(30) NOT NULL Address
14 CL_BORR_PERM_AD2_O Character(30) VARCHAR2(30) NOT NULL Borrower Permanent Addr Line 2
15 CL_BORR_PERM_CITY3 Character(24) VARCHAR2(24) NOT NULL CommonLine Borrower Perm City
16 CL_BORR_PERM_ST2 Character(2) VARCHAR2(2) NOT NULL Borrower Perm State
17 CL_BORR_PERM_ZIP_O Character(5) VARCHAR2(5) NOT NULL Borrower Permanent Zip
18 CL_BORR_PERM_ZP4_O Character(4) VARCHAR2(4) NOT NULL Borrower Permanent Zip Suffix
19 CL_BORR_PHONE10 Character(10) VARCHAR2(10) NOT NULL Borrower Phone10
20 CL_BORR_BIRTHDATE Character(8) VARCHAR2(8) NOT NULL Borrower Date of Birth
21 CL_TYPE_CODE Character(2) VARCHAR2(2) NOT NULL CL Loan Type Code
22 CL_AMT_REQUESTED Character(6) VARCHAR2(6) NOT NULL Loan Amount Requested
23 CL_DEFER_RQST Character(1) VARCHAR2(1) NOT NULL Deferment Request
24 CL_BORR_INT_IND Character(1) VARCHAR2(1) NOT NULL Borrower Interest Indicator
25 CL_EFT_AUTHRZTN Character(1) VARCHAR2(1) NOT NULL Loan EFT Authorization
26 CL_BORR_SIG_CD Character(1) VARCHAR2(1) NOT NULL Borrower Signature Cd
27 CL_BORR_SIG_DATE Character(8) VARCHAR2(8) NOT NULL Borrower Signature Date
28 CL_SEQ_NUM Character(2) VARCHAR2(2) NOT NULL Loan Sequence Nbr
29 CL_BORR_CIT_CD Character(1) VARCHAR2(1) NOT NULL Borrower Citizenship Status Cd
30 CL_BORR_STATE_CD2 Character(2) VARCHAR2(2) NOT NULL Borrower State Residence Cd
31 CL_BORR_RES_DATE Character(6) VARCHAR2(6) NOT NULL Borrower State Resident Date
32 CL_BORR_DEF_REF_CD Character(1) VARCHAR2(1) NOT NULL Borrower Default/Refund Cd
33 CL_BORR_OUT_LOANS Character(1) VARCHAR2(1) NOT NULL Borrower Outstanding Loans Cd
34 CL_STU_BORR_IND Character(1) VARCHAR2(1) NOT NULL Student Borrower Indicator
35 CL_STU_LNAME_O Character(35) VARCHAR2(35) NOT NULL P/A Student Last Name
36 CL_STU_FNAME_O Character(12) VARCHAR2(12) NOT NULL P/A Student First Name
37 CL_STU_MID_INIT_O Character(1) VARCHAR2(1) NOT NULL P/A Student Middle Initial
38 CL_STU_SSN Character(9) VARCHAR2(9) NOT NULL Student SSN
39 CL_STU_BIRTHDATE Character(8) VARCHAR2(8) NOT NULL Student Birthdate
40 CL_STU_CIT_CD Character(1) VARCHAR2(1) NOT NULL Student Citizenship Stat Cd
41 CL_STU_DEF_REF_CD Character(1) VARCHAR2(1) NOT NULL Student Default Refund Stat CD
42 CL_STU_SIG_CD Character(1) VARCHAR2(1) NOT NULL Student Signature Cd
43 CL_SERVICER_CODE Character(8) VARCHAR2(8) NOT NULL Servicer Code
44 CL_SCHOOL_ID3 Character(8) VARCHAR2(8) NOT NULL CommonLine School ID V3
45 CL_PERIOD_BEGIN_DT Character(8) VARCHAR2(8) NOT NULL Loan Period Begin Date
46 CL_PERIOD_END_DT Character(8) VARCHAR2(8) NOT NULL Loan Period End Date
47 CL_GRADE_LEVEL Character(1) VARCHAR2(1) NOT NULL Loan Grade Level Cd
48 CL_ENROLL_STAT Character(1) VARCHAR2(1) NOT NULL Enrollment Status Cd
49 CL_EXPT_GRAD_DT Character(8) VARCHAR2(8) NOT NULL Loan Expected Graduation Date
50 CL_COST_OF_ATTEN Character(5) VARCHAR2(5) NOT NULL Cost of Attendance
51 CL_FM_EFC Character(5) VARCHAR2(5) NOT NULL FM EFC
52 CL_EST_FIN_AID Character(5) VARCHAR2(5) NOT NULL Estimated Financial Aid
53 CL_SUB_STAF_CERT Character(5) VARCHAR2(5) NOT NULL Certified Subsidized Stafford
54 CL_USUB_STAF_CERT Character(5) VARCHAR2(5) NOT NULL Unsub Stafford Certified Amt
55 CL_PLUS_CERT Character(5) VARCHAR2(5) NOT NULL PLUS Certified Amount
56 CL_SCHL_CERT_DT Character(8) VARCHAR2(8) NOT NULL School Certification Date
57 CL_ADJ_CUT_DT Character(8) VARCHAR2(8) NOT NULL Adjustment Cutoff Date
58 CL_ANTCPT_PUT_DT Character(8) VARCHAR2(8) NOT NULL Anticipated PUT Date
59 CL_ALT_CERT_AMT Character(5) VARCHAR2(5) NOT NULL Alternative Loan Certified Amt
60 CL_ALT_APP_VER Character(4) VARCHAR2(4) NOT NULL Alt Loan Application Version
61 CL_SCH_DES_BRCH_CD Character(2) VARCHAR2(2) NOT NULL School Designated Branch Code
62 CL_DUNS_SCHOOL_ID Character(9) VARCHAR2(9) NOT NULL DUNS School ID
63 CL_LNDR_CD Character(6) VARCHAR2(6) NOT NULL Lender ID
64 CL_STAF_APRV_AMT Character(5) VARCHAR2(5) NOT NULL Sub Stafford Approved Amt
65 CL_USTAF_APRV_AMT Character(5) VARCHAR2(5) NOT NULL Usub Stafford Aprv Amt
66 CL_PLUS_APRV_AMT Character(5) VARCHAR2(5) NOT NULL PLUS Approved Amount
67 CL_LNDR_APDY_DT Character(8) VARCHAR2(8) NOT NULL Lender Approval/DenialDT
68 CL_LNDR_APDY_CD Character(1) VARCHAR2(1) NOT NULL Lender Approval/Denial Code
69 CL_ALT_APRV_AMT Character(5) VARCHAR2(5) NOT NULL Alt Loan Approved Amount
70 CL_DUNS_LENDER_ID Character(9) VARCHAR2(9) NOT NULL DUNS Lender ID
71 CL_GNTR_CD Character(3) VARCHAR2(3) NOT NULL Guarantor ID
72 CL_FED_APP_FRM_CD Character(1) VARCHAR2(1) NOT NULL Federal App Form Cd
B=Stafford Version 1/3/94
G=Graduate PLUS MPN
M=Stafford MPN
P=PLUS Version 4/25/94
Q=PLUS MPN
73 CL_DUNS_GUAR_ID Character(9) VARCHAR2(9) NOT NULL DUNS Guarantor ID
74 CL_GNTR_ADJ_IND_CD Character(1) VARCHAR2(1) NOT NULL Guarantor Adjust Ind Code
75 CL_DSBR_DT_1 Character(8) VARCHAR2(8) NOT NULL Disbursement Date 1
76 CL_DSBR_AMT_1 Character(7) VARCHAR2(7) NOT NULL Disbursement Amount 1
77 CL_ORIG_FEE_1 Character(7) VARCHAR2(7) NOT NULL Origination Fee 1
78 CL_GUAR_FEE_1 Character(7) VARCHAR2(7) NOT NULL Guarantee Fee 1
79 CL_DSBR_NET_1 Character(7) VARCHAR2(7) NOT NULL Net Disbursement Amt 1
80 CL_DSBR_DT_2 Character(8) VARCHAR2(8) NOT NULL Disbursement Date 2
81 CL_DSBR_AMT_2 Character(7) VARCHAR2(7) NOT NULL Disbursement Amount 2
82 CL_ORIG_FEE_2 Character(7) VARCHAR2(7) NOT NULL Origination Fee 2
83 CL_GUAR_FEE_2 Character(7) VARCHAR2(7) NOT NULL Guarantee Fee 2
84 CL_DSBR_NET_2 Character(7) VARCHAR2(7) NOT NULL Net Disbursement Amount 2
85 CL_DSBR_DT_3 Character(8) VARCHAR2(8) NOT NULL Disbursement Date 3
86 CL_DSBR_AMT_3 Character(7) VARCHAR2(7) NOT NULL Disbursement Amount 3
87 CL_ORIG_FEE_3 Character(7) VARCHAR2(7) NOT NULL Origination Fee 3
88 CL_GUAR_FEE_3 Character(7) VARCHAR2(7) NOT NULL Guarantee Fee 3
89 CL_DSBR_NET_3 Character(7) VARCHAR2(7) NOT NULL Net Disbursement Amount 3
90 CL_DSBR_DT_4 Character(8) VARCHAR2(8) NOT NULL Disbursement Date 4
91 CL_DSBR_AMT_4 Character(7) VARCHAR2(7) NOT NULL Disbursement Amount 4
92 CL_ORIG_FEE_4 Character(7) VARCHAR2(7) NOT NULL Origination Fee 4
93 CL_GUAR_FEE_4 Character(7) VARCHAR2(7) NOT NULL Guarantee Fee 4
94 CL_DSBR_NET_4 Character(7) VARCHAR2(7) NOT NULL Net Disbursement Amount 4
95 CL_GUAR_DT Character(8) VARCHAR2(8) NOT NULL Guarantee Date
96 CL_GUAR_AMT Character(5) VARCHAR2(5) NOT NULL Guarantee Amount
97 CL_SERIAL_LN_CD Character(1) VARCHAR2(1) NOT NULL Code that indicates how the school will use the MPN. This is transmitted i the App Send file.
N=Use new MPN
S=Serial, Renew existing MPN
98 CL_MPN_CONFIRM_CD Character(1) VARCHAR2(1) NOT NULL Response file value that indicates whether a valid serial MPN was confirmed by the service provider.
N=No valid MPN exists
U=Unknown MPN status
Y=Yes, a valid MPN exists
99 CL_BORR_CONFIRM_IN Character(1) VARCHAR2(1) NOT NULL A code indicating if the service provider has received borrower confirmation of the MPN loan request.
N=No borr confirm received
Y=Yes, SP received borr confirm
100 CL_BORR_DL_STATE2 Character(2) VARCHAR2(2) NOT NULL Borrower DL State
101 CL_BORR_DL_NBR Character(20) VARCHAR2(20) NOT NULL Borrower Drivers License Nbr
102 CL_BORR_REF_CD Character(1) VARCHAR2(1) NOT NULL Borrower References Cd
N=No, references incomplete
Y=Yes, references complete
103 CL_SCHOOL_USE Character(23) VARCHAR2(23) NOT NULL CL School Use Field
104 CL_DISB_HR_1 Character(1) VARCHAR2(1) NOT NULL Disb 1 Hold/Release Indicator
105 CL_DISB_HR_2 Character(1) VARCHAR2(1) NOT NULL Disb 2 Hold/Release Indicator
106 CL_DISB_HR_3 Character(1) VARCHAR2(1) NOT NULL Disb 3 Hold/Release Indicator
107 CL_DISB_HR_4 Character(1) VARCHAR2(1) NOT NULL Disb 4 Hold/Release Indicator
108 CL_PNOTE_DELIVR_CD Character(1) VARCHAR2(1) NOT NULL Prom Note Delivery Code
109 CL_FOREIGN_POSTAL Character(14) VARCHAR2(14) NOT NULL Foreign Postal Code
110 CL_LNDR_BRCH_ID Character(4) VARCHAR2(4) NOT NULL Lender Branch ID
111 CL_LNDR_USE Character(20) VARCHAR2(20) NOT NULL Lender Use Only
112 CL_LNDR_LAST_RST Character(1) VARCHAR2(1) NOT NULL Lender of Last Resort Cd
113 CL_DISB_ACTN_1 Character(3) VARCHAR2(3) NOT NULL Disb Action Stat Cd 1
114 CL_DISB_ACTN_2 Character(3) VARCHAR2(3) NOT NULL Disb Action Stat Cd 2
115 CL_DISB_ACTN_3 Character(3) VARCHAR2(3) NOT NULL Disb Action Stat Cd 3
116 CL_DISB_ACTN_4 Character(3) VARCHAR2(3) NOT NULL Disb Action Stat Cd 4
117 CL_RESP_TO_ORIG_CD Character(1) VARCHAR2(1) NOT NULL CL Response to Originator Code
118 CL_ERR_MSG_CD_1 Character(3) VARCHAR2(3) NOT NULL Error Message Code 1
119 CL_ERR_MSG_CD_2 Character(3) VARCHAR2(3) NOT NULL Error Message Code 2
120 CL_ERR_MSG_CD_3 Character(3) VARCHAR2(3) NOT NULL Error Message Code 3
121 CL_ERR_MSG_CD_4 Character(3) VARCHAR2(3) NOT NULL Error Message Code 4
122 CL_ERR_MSG_CD_5 Character(3) VARCHAR2(3) NOT NULL Error Message Code 5
123 CL_GNTR_RED_CD Character(2) VARCHAR2(2) NOT NULL Guarantor Amount Reduction Cd
124 CL_TOT_OUT_STAF Character(8) VARCHAR2(8) NOT NULL Total Outstanding Stafford/SLS
125 CL_TOT_OUT_PLUS Character(8) VARCHAR2(8) NOT NULL Total Outstanding PLUS Amt
126 CL_PHASE_CD Character(4) VARCHAR2(4) NOT NULL Application/Loan Phase Code
127 CL_PHASE_CD_DT Character(8) VARCHAR2(8) NOT NULL Phase Code Last Updated
128 CL_GUAR_USE Character(23) VARCHAR2(23) NOT NULL Guarantor Use
129 CL_PERM_ADDR_DT Character(8) VARCHAR2(8) NOT NULL Permanent Address Update Date
130 CL_ALT_LN_TYPE_CD Character(3) VARCHAR2(3) NOT NULL Alternative Loan Type Cd
131 CL_TOT_STDT_DEBT Character(7) VARCHAR2(7) NOT NULL Total Student Loan Debt
132 CL_FEES_PAID_1 Character(7) VARCHAR2(7) NOT NULL Fees Paid 1
133 CL_FEES_PAID_2 Character(7) VARCHAR2(7) NOT NULL Fees Paid 2
134 CL_FEES_PAID_3 Character(7) VARCHAR2(7) NOT NULL Fees Paid 3
135 CL_FEES_PAID_4 Character(7) VARCHAR2(7) NOT NULL Fees Paid 4
136 CL_ACT_INT_RATE Character(5) VARCHAR2(5) NOT NULL Actual Interest Rate
137 CL_PROC_TYPE_CD Character(2) VARCHAR2(2) NOT NULL Loan Processing Type Cd
138 CL_SERV_TYPE_CD Character(2) VARCHAR2(2) NOT NULL CommonLine Code that describes disbursement funds will be handled and whether reference information will be included.
01=Lndr fund to school (no @5)
02=Lndr to disb agent (no @5)
03=Lndr fund to school (w/@5)
04=Lndr to disb agent (w/@5)
05=File creator won't disb -no @5
06=File creator to disb - no @5
07=File creator won't disb -w/@5
08=File creator to disb w/@5
139 CL_REV_NOG_CD Character(1) VARCHAR2(1) NOT NULL Revised NOG Indicator Code
N=No revised NOG will be sent
U=Unknown
Y=Yes a revised NOG will be sent
140 CL_SCHL_REFUND_AMT Character(7) VARCHAR2(7) NOT NULL School Refund Amt
141 CL_REFUND_DATE Character(8) VARCHAR2(8) NOT NULL School Refund Date
142 CL_UNQ_LAY_VEN_CD Character(4) VARCHAR2(4) NOT NULL Unique Layout Vendor Cd
143 CL_UNQ_LAY_ID_CD Character(2) VARCHAR2(2) NOT NULL Unique Layout ID Cd
144 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
145 LN_CL_ERROR_RSN_CD Character(1) VARCHAR2(1) NOT NULL CL Error Reason Code
A=Award Disbursement Discrepancy
C=Loan Certification Rqst
D=Destination Not Found
E=Processing Error
F=Disbursement not found
G=Invalid Award Id
H=Loan On Hold
I=Invalid Loan Type Code
J=Not Participating CR Destn
K=Invalid School Code
L=Loan Not Found
M=Loan Common Module Error
N=No Errors
P=Process Not Supported
S=Source Data Corruption
T=Loan Tolerance Amt Exceeded
U=Unknown or Invalid Loan Type
X=Uninitiated Change
Z=CL4 Conversion Error
146 SFA_CL_DIR_DSB1 Character(1) VARCHAR2(1) NOT NULL Direct Disb to Borrower 1
147 SFA_CL_DIR_DSB2 Character(1) VARCHAR2(1) NOT NULL Direct Disb to Borrower 2
148 SFA_CL_DIR_DSB3 Character(1) VARCHAR2(1) NOT NULL Direct Disb to Borrower 3
149 SFA_CL_DIR_DSB4 Character(1) VARCHAR2(1) NOT NULL Direct Disb to Borrower 4
150 SFA_CL_GUAR_FEEPD1 Character(5) VARCHAR2(5) NOT NULL Guarantee Fees Paid 1
151 SFA_CL_GUAR_FEEPD2 Character(5) VARCHAR2(5) NOT NULL Guarantee Fees Paid 2
152 SFA_CL_GUAR_FEEPD3 Character(5) VARCHAR2(5) NOT NULL Guarantee Fees Paid 3
153 SFA_CL_GUAR_FEEPD4 Character(5) VARCHAR2(5) NOT NULL Guarantee Fees Paid 4
154 SFA_CL_ORIG_FEEPD1 Character(5) VARCHAR2(5) NOT NULL Origination Fees Paid 1
155 SFA_CL_ORIG_FEEPD2 Character(5) VARCHAR2(5) NOT NULL Origination Fees Paid 2
156 SFA_CL_ORIG_FEEPD3 Character(5) VARCHAR2(5) NOT NULL Origination Fees Paid 3
157 SFA_CL_ORIG_FEEPD4 Character(5) VARCHAR2(5) NOT NULL Origination Fees Paid 4
158 SFA_CL_ESIGN_TYPE Character(9) VARCHAR2(9) NOT NULL E-Signature Source Type Code