CL_APR_DTL4_EC(SQL Table) |
Index Back |
---|---|
CL 4 App Export Header EC RecEC 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 |