Export File Formats
· Accounting Feed Extract File Format – CRC
· Accounting Feed Extract File Format - Banner
· Accounting Feed Extract File Format - Plus
· Credit Report Extract File Format – Metro I
· Credit Report Extract File Format – Metro 2
· Collections Referral File Format
· Invoice (Bills/Due Diligence) Extract File Format
|
Field Name |
Columns |
Length |
Description/Format |
|
Header Record |
|
|
|
|
Fiscal Year |
1-4 |
4 |
Fiscal year value, formatted as YYYY |
|
Chart of Accounts Code |
5-6 |
2 |
Administration, System Configuration, Import/Export Parameters, AFE BannerBank/CRCCOA Code |
|
Organization Code |
7-10 |
4 |
Administration, System Configuration, Import/Export Parameters, AFE ORG Code |
|
Filler |
11-15 |
5 |
Blank |
|
Date |
16-25 |
10 |
Current date, formatted as YYYY-MM-DD |
|
Balance Transaction Code |
26-27 |
2 |
Value is HD |
|
Batch Number |
28 |
1 |
Value is 0, unless more than one feed extracted that day. |
|
Contact Email |
29-68 |
40 |
Email of school contact person. Administration, Coded Data Value, AFEED code type, CONTACTEMAIL. |
|
Contact Name |
69-98 |
30 |
Name of school contact person. Administration, Coded Data Value, AFEED code type, CONTACTNAME. |
|
Contact Department |
99-128 |
30 |
Department of school contact person. Administration, Coded Data Value, AFEED code type, CONTACTDEPT. |
|
Contact Address |
129-158 |
30 |
Address of school contact person. Administration, Coded Data Value, AFEED code type, CONTACTADDR. |
|
Chart of Accounts Code |
159-160 |
2 |
Administration, System Configuration, Import/Export Parameters, AFE BannerBank/CRCCOA Code |
|
Contact Phone Number |
162-170 |
10 |
Phone number of school contact person. Administration, Coded Data Value, AFEED code type, CONTACTPHONE. |
|
Filler |
171-172 |
2 |
Blank |
|
Detail Record |
|
|
|
|
Fiscal Year |
1-4 |
4 |
Fiscal year, formatted as YYYY |
|
Filler |
5-6 |
2 |
Not used; blank |
|
Campus Account Number |
7-18 |
12 |
Value of Administration, General Ledger Table Maintenance, Campus Account Number linked to Ledger via GLTABLE_ID. |
|
Object Code |
19-24 |
6 |
Value of Administration, General Ledger Table Maintenance, Object Code linked to Ledger via GLTABLE_ID. |
|
Filler |
25-25 |
1 |
Not used; blank |
|
Balance Transaction Code |
26-27 |
2 |
Value is AC |
|
Filler |
28-31 |
4 |
Not used; Blank |
|
Document Type Code |
32-35 |
4 |
Value is STLN |
|
System Origination Code |
36-37 |
2 |
Value is EU |
|
Account Name |
38-42 |
5 |
First 5 characters of Account name. |
|
Posting Date Month |
43-44 |
2 |
Month value of posting date. |
|
Posting Date Year |
45-46 |
2 |
Last 2 digits of year value of posting date. |
|
Filler |
47-51 |
5 |
Not used; Blank |
|
Description |
52-91 |
40 |
Value of Administration, General Ledger Table Maintenance, Description linked to Ledger via GLTABLE_ID. |
|
Filler |
92-92 |
1 |
Not used; Blank |
|
Transaction Amount |
93-107 |
15 |
Transaction Amount |
|
Debit/Credit Indicator |
108-108 |
1 |
Value is D or C |
|
Posting Date |
120-129 |
19 |
The date entered as the posting date. If left blank, system defaults to current date. Formatted as YYYY-MM-DD. |
|
Filler |
130-149 |
20 |
Not used; Blank |
|
Chart of Accounts Code |
150-151 |
2 |
Administration, System Configuration, Import/Export Parameters, AFE BannerBank/CRCCOA Code |
|
Organization Code |
152-155 |
4 |
Administration, System Configuration, Import/Export Parameters, AFE ORG Code |
|
Filler |
156-200 |
45 |
Not used; Blank |
|
Trailer Record |
|
|
|
|
Filler |
1-25 |
25 |
Blank |
|
Balance Transaction Code |
26-27 |
2 |
Value is TL |
|
Filler |
28-46 |
19 |
Blank |
|
Detail Record Count |
47-51 |
5 |
Number of Detail Records written |
|
Filler |
52-92 |
41 |
Blank |
|
Total Debit Amount |
93-107 |
15 |
Sum of all Debit transaction amounts |
|
Filler |
108-172 |
65 |
Blank |
|
Field Name |
Columns |
Length |
Description/Format |
|
Batch Header Record |
|||
|
Record Type |
001-001 |
1 |
Value is “1” |
|
Batch Reference |
002-004 |
3 |
A reference to this collection of transactions-- 3 bytes-- "CRC" |
|
Batch Number |
005-007 |
3 |
A 3 character field--usually a number making the batch ref + num unique |
|
Batch Date |
008-015 |
8 |
Date from the collection of transactions--else today formatted as CCYYMMDD |
|
Batch Description |
016-030 |
15 |
A description from the CRC collection of transactions |
|
Batch Transaction Amount |
031-042 |
12 |
Sum of TRANSACTION AMOUNT contained on JE records within this batch; Right justify, zero fill, decimal point is implied, no sign |
|
Batch Transaction Count |
043-047 |
5 |
# Of JE records in this batch; Right justify, zero fill |
|
Batch Origin |
048-055 |
8 |
A CRC reference to the process creating this feed |
|
Batch Bank |
056-057 |
2 |
Blank |
|
Filler |
058-103 |
46 |
Blank |
|
Journal Entry Record |
|||
|
Record Type |
001-001 |
1 |
Values is “2” |
|
Rule Code |
002-005 |
4 |
Value is ‘LMJE’ |
|
Document Reference Number |
006-012 |
7 |
Sequential number within this batch; right justify, zero fill |
|
Transaction Date |
013-020 |
8 |
LEDGER.TRANSDATE or posting date formatted as CCYYMMD |
|
Transaction Description |
021-040 |
20 |
Same as description on batch record |
|
Trans Amount |
041-052 |
12 |
LEDGER.TRANSAMT; right justify, zero fill, decimal point is implied, no sign |
|
Sign |
053-053 |
1 |
Value is “+” or “-“; If LEDGER.TRANSAMT < 0 THEN ‘-‘ ELSE ‘+’ |
|
Debit/Credit Indicator |
054-054 |
1 |
Value is “D” or “C”; LEDGER.DEBITCREDIT |
|
Transaction Reference |
055-061 |
7 |
Blank |
|
Transaction Code Id |
062-072 |
11 |
Blank |
|
General Ledger Account Number |
073-103 |
31 |
Campus's account number that is tied to this CRC ledger transaction; Left justify, fill with spaces |
|
Field Name |
Columns |
Length |
Description/Format |
|
Batch Header Record |
|||
|
Transaction Code |
001-003 |
03 |
Value is "$$$" |
|
Batch Reference Number |
004-009 |
03 |
A unique number identifying the batch |
|
Batch Date |
010-017 |
08 |
Same date we’d use when creating the standard accounting feed formatted as MMDDCCYY |
|
Batch Description |
018-032 |
15 |
Not used; Blank. |
|
Batch List Opt |
033-033 |
01 |
Not used; Blank. |
|
Batch User Code |
034-035 |
02 |
Not used; Blank. |
|
Batch Trans Count |
036-040 |
05 |
# Of JE records in this batch; right justified, zero filled |
|
Batch Trans Amount |
041-051 |
11 |
Gross sum of JE dollar AMOUNT; Right justify, zero fill, decimal point is implied, no sign |
|
Batch Suspense Id |
052-054 |
03 |
Not used; Blank. |
|
Batch Originator |
055-062 |
08 |
Name of program originating this batch |
|
Batch Bank No |
063-064 |
02 |
Not used; Blank. |
|
ZSS Filler |
065-081 |
17 |
Not used; Blank. |
|
AP Filler |
082-087 |
06 |
Not used; Blank. |
|
Special Process field |
088-090 |
03 |
Value is “CJE” |
|
Batch Fiscal Year |
091-092 |
02 |
Fiscal year |
|
Batch Campus Code |
093-094 |
02 |
Blank |
|
Filler |
095-128 |
34 |
Blank |
|
Journal Entry Record |
|||
|
Transaction Code |
001-003 |
03 |
Value is "069" |
|
Debit Account |
004-013 |
10 |
Campus's DEBIT account number that is tied to this CRC ledger transaction; Left justify, fill with spaces |
|
Reference # |
014-020 |
07 |
Sequential number within this batch; Right justify, zero fill |
|
Trans Date |
021-024 |
04 |
Month & Day from Batch Date in Batch Header formatted as MMDD |
|
Description |
025-044 |
20 |
Account description |
|
Transaction Amount |
045-055 |
11 |
LEDGER.TRANSAMT; right justified, zero filled, no sign |
|
Part/Full Indic |
056-056 |
01 |
Blank |
|
Second Reference |
057-063 |
07 |
Batch Reference Number contained in header record |
|
Credit Account |
064-073 |
10 |
Campus's CREDIT account number that is tied to this CRC ledger transaction; Left justify, fill with spaces |
|
Student Id |
074-084 |
11 |
First 11 characters of Customer ID |
|
Debit Campus |
085-086 |
02 |
Campus tied to account being debited |
|
Credit Campus |
087-088 |
02 |
Campus tied to account being credited |
|
Ledger Account Code |
089-095 |
07 |
CRC ledger account code |
|
Reserved |
096-113 |
18 |
Blank |
|
Filler |
114-128 |
15 |
Blank |
|
Field Name |
Columns |
Length |
Description/Format |
|
File Header Record |
|||
|
Record Type Code |
1 |
1 |
Value is 1 |
|
Priority code |
2-3 |
2 |
Value is 01 |
|
Destination Bank ID |
4-13 |
10 |
Value comes from Administration/System Configuration Parameters/ACH Parameters/ACH Bank ID. |
|
Sending School ID |
14-23 |
10 |
Value comes from Administration/System Configuration Parameters/ACH Parameters/ACH School ID. |
|
Transmission date |
24-29 |
6 |
YYMMDD (current date) |
|
Transmission time |
30-33 |
4 |
HHMM (current time hours and minutes) |
|
File ID Modifier |
34-34 |
1 |
Value is A |
|
Record Size |
35-37 |
3 |
Value is 094 |
|
Format Code |
38-38 |
1 |
Value is 1 |
|
Bank Name |
39-61 |
23 |
Value comes from Administration/System Configuration Parameters/ACH Parameters/ACH Bank Name. |
|
School Name |
62-84 |
23 |
Value comes from Administration/System Configuration Parameters/ACH Parameters/Company ID. If that value is blank, then value comes from Administration/System Configuration Parameters/School Parameters/School Name. |
|
Filler |
85-92 |
8 |
Not Used; Blank |
|
Company Batch Header Record |
|||
|
Record Type Code |
1 |
1 |
Value is 5 |
|
Service class code |
2-4 |
3 |
Value is 200 |
|
School Name |
5-20 |
16 |
Value comes from Administration/System Configuration Parameters/ACH Parameters/ACH Company ID. If that value is blank, then value comes from Administration/System Configuration Parameters/School Parameters/School Name. |
|
Discretionary data |
21-40 |
20 |
Not Used; Blank |
|
Company ID |
41-50 |
10 |
Value comes from Administration/System Configuration Parameters/ACH Parameters/ACH School ID. |
|
Standard entry class |
51-53 |
3 |
Value is PPD |
|
Company entry description |
54-63 |
10 |
Value comes from Administration/System Configuration Parameters/ACH Parameters/ACH Company Entry Description. If that value is blank, then value is STUDLOANS. |
|
Company descriptive date |
64-69 |
6 |
YYMMDD (transaction date entered by user at run-time) |
|
Effective entry date |
70-75 |
6 |
YYMMDD (transaction date entered by user at run-time) |
|
Filler (reserved) |
76-78 |
3 |
Not Used; Blank |
|
Originator status code |
79 |
1 |
Value is 1 |
|
Destination bank ID |
80-87 |
8 |
Value comes from Administration/System Configuration Parameters/ACH Parameters/ACH Bank ID. |
|
Batch number |
88-94 |
7 |
0000001 |
|
Detail Record |
|||
|
Record type code |
1 |
1 |
Value is 6 |
|
Transaction code |
2-3 |
2 |
Value is one of 27 – direct debit checking 28 – pre-note direct debit checking 37 – direct debit savings 38 – pre-note direct debit savings |
|
Customer’s Bank FRD/ABA# (routing #) |
4-12 |
9 |
Value comes from Customer Services/ACH Accounts/FRD/ABA#. (if the length of this value is less than 9 then a MOD 10 check-digit will calculated and appended to the end) |
|
Customer’s Bank account # |
13-29 |
17 |
Value comes from Customer Services/ACH Accounts/Account Number. |
|
Amount of transaction |
30-39 |
10 |
Value comes from Customer Services/ACH Override Amount. If this value is blank or zero, value is the sum of Customer Services/Payment Plan/Amount for all Account’s due. |
|
Customer SSN or Customer ID |
40-54 |
15 |
Value comes from Administration, Customer Maintenance, SSN or Customer ID depending on value set for Administration, Import/Export Parameters, Customer ID is Primary ID. |
|
Customer Name |
55-76 |
22 |
Value comes from Administration, Customer Maintenance, Last Name, First Name Middle Name |
|
Discretionary data |
77-78 |
2 |
Not Used; Blank |
|
Addenda record indicator |
79 |
1 |
Value is 0 (zero) |
|
Trace number |
80-87 |
8 |
Value comes from Administration/System Configuration Parameters/ACH Parameters/ACH Bank ID. |
|
Sequence # |
88 |
1 |
Value is 0 (zero) |
|
Ascending record sequence # |
89-94 |
6 |
Record # within this batch. Only count type 6 records |
|
Company Batch Trailer Record/Record type 8 (one per file) |
|||
|
Record type |
1 |
1 |
Value is 8 |
|
Service class |
2-4 |
3 |
Value is 200 |
|
Total # detail records |
5-10 |
6 |
Total # of type 6 detail records |
|
Hash count |
11-20 |
10 |
Sum of Customer’s Bank FRD/ABA# (routing #) on detail (type 6) record. |
|
Total debit amount |
21-32 |
12 |
Sum of Transaction Amount on detail (type 6) record. |
|
Total credit amount |
33-44 |
12 |
000000000000 |
|
Company ID |
45-54 |
10 |
Value comes from Administration/System Configuration Parameters/ACH Parameters/ACH School ID. |
|
Filler (reserved) |
55-79 |
25 |
Not Used; Blank |
|
Bank ID # |
80-87 |
8 |
Value comes from Administration/System Configuration Parameters/ACH Parameters/ Bank ID. |
|
Batch number |
88-94 |
7 |
Value is 0000001 |
|
File Trailer Record/Record type 9 (one per file) |
|||
|
Record type code |
1 |
1 |
Value is 9 |
|
Batch count |
2-7 |
6 |
Value is 000001 |
|
Block count |
8-13 |
6 |
How many blocks of 10 records based on total # of records in the file; i.e., 9 records = 1 block; 13 records = 2 blocks. Right justified; zero filled |
|
# of detail records |
14-21 |
8 |
Total # of detail records; right justified; zero filled |
|
Hash count |
22-31 |
10 |
Sum of Customer’s Bank FRD/ABA# (routing #) on detail (type 6) record. |
|
Total debit amount |
32-43 |
12 |
Sum of Transaction Amount on detail (type 6) record. |
|
Total credit amount |
44-55 |
12 |
Value is 000000000000 |
|
Filler |
56-94 |
39 |
Not Used; Blank |
|
Field Name |
Columns |
Length |
Description/Format |
|
Header Record |
|
|
|
|
Record Type |
1-2 |
2 |
Value is A1 |
|
Member OE # |
3-8 |
6 |
First 6 characters of OPEID from Administration, System Configuration Parameters, School Parameters. |
|
Member Name |
9-48 |
40 |
School Name from Administration, System Configuration Parameters, School Parameters. |
|
Submission Date |
49-56 |
8 |
Today’s Date MMDDYYYY |
|
Submission Type |
57-57 |
1 |
Value is O (overlay) |
|
Submission Format |
58-58 |
1 |
Value is A |
|
Filler |
59-140 |
82 |
Blank |
|
Detail Record |
|
|
|
|
Record Type |
1-2 |
2 |
Value is D1 |
|
Student SSN |
3-11 |
9 |
Value comes from Administration, Customer Maintenance. |
|
First Name |
12-31 |
20 |
Value comes from Administration, Customer Maintenance. |
|
Middle Initial |
32-32 |
1 |
Value comes from Administration, Customer Maintenance. |
|
Last Name |
33-52 |
20 |
Value comes from Administration, Customer Maintenance. |
|
Name Suffix |
53-57 |
5 |
Value comes from Administration, Customer Maintenance. |
|
Enrollment Flag |
58-58 |
1 |
Value is Y if enrolled, N if not enrolled. |
|
School Code |
59-64 |
6 |
First 6 characters of OPEID from Administration, System Configuration Parameters, School Parameters. |
|
School Branch |
65-66 |
2 |
Last 2 characters of OPEID from Administration, System Configuration Parameters, School Parameters. |
|
Birth Date |
67-74 |
8 |
Value comes from Administration, Customer Maintenance. |
|
Previous SSN |
75-83 |
9 |
Blank. |
|
Former Surname |
84-103 |
20 |
Blank. |
|
Filler |
104-140 |
37 |
Blank. |
|
Trailer Record |
|
|
|
|
Record Type |
1-2 |
2 |
Value is T1 |
|
Number of “Y” |
3-9 |
7 |
Number of records with enrollment flag of “Y” |
|
Number of “N” |
10-16 |
7 |
Number of records with enrollment flag of “N” |
|
Total Records |
17-24 |
8 |
Total number of records in file including header and trailer records. |
|
Filler |
25-140 |
116 |
Blank |
|
Field Name |
Columns |
Length |
Description/Format |
|
Record Type |
1-1 |
1 |
Value is 1 |
|
Filler |
2-4 |
3 |
Blank |
|
Customer Name |
5-34 |
30 |
Value comes from Administration, Customer Maintenance. |
|
Customer Address1 |
35-64 |
30 |
Value comes from Administration, Customer Maintenance. |
|
Customer SSN |
65-77 |
13 |
Value comes from Administration, Customer Maintenance. |
|
First Coupon Date |
78-83 |
6 |
MMDDYY |
|
Filler |
84-84 |
1 |
Blank |
|
Customer Address2 |
85-114 |
30 |
Value comes from Administration, Customer Maintenance. |
|
Customer Address3 |
115-144 |
30 |
Value comes from Administration, Customer Maintenance. |
|
Number of Coupons at Payment Amount 1 |
145-147 |
3 |
Calculated |
|
Payment Amount 1 |
148-155 |
8 |
Calculated |
|
Late Amount 1 |
156-163 |
8 |
Calculated |
|
Filler |
164-164 |
1 |
Blank |
|
Customer Address4 |
165-194 |
30 |
Blank; Not used. |
|
Number of Coupons at Payment Amount 2 |
195-197 |
3 |
Calculated |
|
Payment Amount 2 |
198-205 |
8 |
Calculated |
|
Late Amount 2 |
206-213 |
8 |
Calculated |
|
Number of Coupons at Payment Amount 3 |
214-216 |
3 |
Calculated |
|
Payment Amount 3 |
217-224 |
8 |
Calculated |
|
Late Amount 3 |
225-232 |
8 |
Calculated |
|
Filler |
233-244 |
12 |
Blank |
|
Scan Line |
245-277 |
33 |
Concatenation of "01009” + Last 6 characters of OPEID + "0 " + SSN (9) + "0 " + Payment Amount (9) |
|
Filler |
278-310 |
33 |
Blank |
|
Number of Coupons at Payment Amount 4 |
311-313 |
3 |
Calculated |
|
Payment Amount 4 |
314-321 |
8 |
Calculated |
|
Late Amount 4 |
322-329 |
8 |
Calculated |
|
Filler |
330-2005 |
1676 |
Blank |
|
Field Name |
Columns |
Length |
Description/Format |
|
Header Record |
|
|
|
|
Record Descriptor |
1-4 |
4 |
Value is 0272 |
|
Record Identifier |
5-10 |
6 |
Value is HEADER |
|
Credit Bureau Institution ID |
11-15 |
5 |
Value comes from Administration, System Configuration Parameters, Credit Bureau Parameters, Internal ID#. |
|
Filler |
16-23 |
8 |
Blank |
|
"As Of" Date |
24-29 |
6 |
Today's date; format is MMDDYY |
|
Filler |
30-31 |
2 |
Value is 00 |
|
Filler |
32-35 |
4 |
Value 0000 |
|
Version |
36-39 |
4 |
Value 8105 |
|
Filler |
40-43 |
4 |
Value is 0000 |
|
Credit Bureau Federal ID |
44-53 |
10 |
Value comes from Administration, System Configuration Parameters, Credit Bureau Parameters, Agency ID#. |
|
Filler |
54-59 |
6 |
Blank |
|
Today's Date |
60-65 |
6 |
Today's date; format is MMDDYY |
|
Filler |
66-114 |
49 |
Blank |
|
Credit Bureau Reporting Organization |
115-147 |
33 |
Value comes from Administration, System Configuration Parameters, Credit Bureau Parameters, Reporter name. |
|
Credit Bureau Organization Address |
148-243 |
96 |
Value comes from Administration, System Configuration Parameters, Credit Bureau Parameters, Reporter Address line 1 + “ “ + Address line 2 + “ “ + City + “,” + State + “ “ + Zip. |
|
Filler |
244-272 |
29 |
Blank |
|
Detail Record |
|
|
|
|
Record Descriptor |
1-4 |
4 |
Value is 0272 |
|
School Abbreviation |
5-11 |
7 |
Value comes from Administration, System Configuration Parameters, Credit Bureau Parameters, Internal ID#. |
|
Account Number |
12-28 |
17 |
Concatenation of: Customer SSN (9) + Account Name (4) + MMYY of Open Date (4) |
|
Account Type |
29-30 |
2 |
Value is 12 |
|
Account Status |
31-32 |
2 |
Calculated value based on current Account information. |
|
Update Indicator |
33 |
1 |
Value is 0 (zero) |
|
Filler (reserved) |
34-42 |
9 |
Value is 000000000 |
|
Terms Frequency |
43 |
1 |
Set to the Account Payment Frequency. |
|
Term in Months |
44-46 |
3 |
The number of months between the Accounts’s Repayment Begins Date and the Scheduled End Date. |
|
Transaction Type |
47 |
1 |
The value is 1 if this is the first report for this Account; otherwise, the value is 4. |
|
Date Opened |
48-53 |
6 |
The Account's Open Date formatted as MMDDYY. |
|
Date of Occurrence |
54-59 |
6 |
This is valued as follows: - Today's Date if status = 11 - Account Closed Date if status = 03, 04, 05, 10, or 13 - All other statuses, a variety of dates. - Format is MMDDYY. |
|
Date Last Paid |
60-65 |
6 |
Account's Last Paid date; format is MMDDYY. |
|
Highest Credit Amount |
66-72 |
7 |
Account's Principal Amount. |
|
Current Balance |
73-79 |
7 |
Sum of Account's principal, interest, late charge, and collection cost balance. |
|
Amount Past Due |
80-86 |
7 |
Sum of Account's principal, interest, late charge, and collection cost past due amounts. |
|
Payment Amount |
87-93 |
7 |
Account's regular payment amount. |
|
SSN |
94-102 |
9 |
Customer's Social Security Number. |
|
Special Comment Code |
103-104 |
2 |
Calculated value based on Account status or TRA. |
|
Filler (reserved) |
105 |
1 |
Blank |
|
Zip Code |
106-111 |
6 |
First 6 characters of 10-digit Zip. If 10-digit zip is 01234-5689 then value would be 012345, stripping out the dash. |
|
Association Code |
112 |
1 |
Value is 1 |
|
Cycle Identifier |
113-114 |
2 |
Blank |
|
Customer Name |
115-146 |
32 |
Concatenation of Customer’s last name, first name and middle initial separated by space. |
|
Generation Code |
147 |
1 |
Value based on Customer's Name Suffix (if any). |
|
Address Line 1 |
148-179 |
32 |
Customer's Address Line 1. |
|
Address Line 2 |
180-211 |
32 |
Customer's Address Line 2 or the City + “ “ + State value if the Customer has no Address Line 2. |
|
Address Line 3 |
212-241 |
30 |
Comprised of City + “ “ + State; blank if this value appears in Address Line 2. |
|
Country Code |
242-243 |
2 |
Country of residence |
|
Residence Code |
244 |
1 |
Blank |
|
Credit Limit |
245-251 |
7 |
Value is 0000000 |
|
Type of Account |
252 |
1 |
Value is I. |
|
Filler (reserved) |
253 |
1 |
Blank |
|
Date Closed |
254-259 |
6 |
Value is 000000 |
|
Zip Code - Last 4 |
260-263 |
4 |
Last 4 characters of 10-digit Zip Code |
|
Interest Type |
264 |
1 |
Value is F |
|
Address Indicator |
265 |
1 |
Blank |
|
Filler (reserved) |
266-272 |
7 |
Blank |
|
Trailer Record |
|
|
|
|
Record Descriptor |
1-4 |
4 |
Value is 0272 |
|
Record Identifier |
5-11 |
7 |
Value is TRAILER |
|
Current Balance Sum |
12-22 |
11 |
Sum of the Current Balance fields from the Detail records. |
|
Past Due Sum |
23-33 |
11 |
Sum of the Amount Past Due values from the Detail records. |
|
Detail Record Count |
34-42 |
9 |
Number of Detail Records |
|
Filler |
43-51 |
9 |
Value is 000000000 |
|
Today's Date |
52-57 |
6 |
Format MMDDYY |
|
Filler |
58-272 |
215 |
Blank |
|
Field Name |
Columns |
Length |
Description/Format |
|
Header Record |
|
|
|
|
Record Descriptor Word (RDW) |
1-4 |
4 |
|
|
Record Identifier |
5-10 |
6 |
|
|
Cycle Number |
11-12 |
2 |
|
|
Innovis Program Identifier |
13-22 |
10 |
|
|
Equifax Program Identifier |
23-32 |
10 |
|
|
Experian Program Identifier |
33-37 |
5 |
|
|
TransUnion Program Identifier |
38-47 |
10 |
|
|
Activity Date |
48-55 |
8 |
|
|
Date Created |
56-63 |
8 |
|
|
Program Date |
64-71 |
8 |
|
|
Program Revision Date |
72-79 |
8 |
|
|
Reporter Name |
80-119 |
40 |
|
|
Reporter Address |
120-215 |
96 |
|
|
Reporter Telephone Number |
216-225 |
10 |
|
|
Software Vendor Name |
226-265 |
40 |
|
|
Software Version Number |
266-270 |
5 |
|
|
Base Segment |
|
|
|
|
Record Descriptor Word (RDW) |
1-4 |
4 |
|
|
Processing Indicator |
5 |
1 |
|
|
Time Stamp |
6-19 |
14 |
|
|
Correction Indicator |
20 |
1 |
|
|
Identification Number |
21-40 |
20 |
|
|
Cycle Identifier |
41-42 |
2 |
|
|
Consumer Account Number |
43-72 |
30 |
|
|
Portfolio Type |
73 |
1 |
|
|
Account Type |
74-75 |
2 |
|
|
Date Opened |
76-83 |
8 |
|
|
Credit Limit |
84-92 |
9 |
|
|
Highest Credit or Original Account Amount |
93-101 |
9 |
|
|
Terms Duration |
102-104 |
3 |
|
|
Terms Frequency |
105 |
1 |
|
|
Scheduled Monthly Payment Amount |
106-114 |
9 |
|
|
Actual Payment Amount |
115-123 |
9 |
|
|
Account Status |
124-125 |
2 |
|
|
Payment Rating |
126 |
1 |
|
|
Payment History Profile |
127-150 |
24 |
|
|
Special Comment |
151-152 |
2 |
|
|
Compliance Condition Code |
153-154 |
2 |
|
|
Current Balance |
155-163 |
9 |
|
|
Amount Past Due |
164-172 |
9 |
|
|
Original Charge-off Amount |
173-181 |
9 |
|
|
Date of Account Information |
182-189 |
8 |
|
|
Date of First Delinquency |
190-197 |
8 |
|
|
Date Closed |
198-205 |
8 |
|
|
Date of Last Payment |
206-213 |
8 |
|
|
Reserved |
214-230 |
17 |
|
|
Consumer Transaction Type |
231 |
1 |
|
|
Surname |
232-256 |
25 |
|
|
First Name |
257-276 |
20 |
|
|
Middle Name |
277-296 |
20 |
|
|
Generation Code |
297 |
1 |
|
|
Social Security Number |
298-306 |
9 |
|
|
Date of Birth |
307-314 |
8 |
|
|
Telephone Number |
315-324 |
10 |
|
|
ECOA Code |
325 |
1 |
|
|
Consumer Information Indicator |
326-327 |
2 |
|
|
Country Code |
328-329 |
2 |
|
|
First Line of Address |
330-361 |
32 |
|
|
Second Line of Address |
362-393 |
32 |
|
|
City |
394-413 |
20 |
|
|
State |
414-415 |
2 |
|
|
Postal/Zip Code |
416-424 |
9 |
|
|
Address Indicator |
425 |
1 |
|
|
Residence Code |
426 |
1 |
|
|
J2 Segment – Associated Consumer Different Address
|
|||
|
Segment Identifier |
1-2 |
2 |
|
|
Consumer Transaction Type |
3 |
1 |
|
|
Surname |
4-28 |
25 |
|
|
First Name |
29-48 |
20 |
|
|
Middle Name |
49-68 |
20 |
|
|
Generation Code |
69 |
1 |
|
|
Social Security Number |
70-78 |
9 |
|
|
Date of Birth |
79-86 |
8 |
|
|
Telephone Number |
87-96 |
10 |
|
|
ECOA Code |
97 |
1 |
|
|
Consumer Information Indicator |
98-99 |
2 |
|
|
Country Code |
100-101 |
2 |
|
|
First Line of Address |
102-133 |
32 |
|
|
Second Line of Address |
134-165 |
32 |
|
|
City |
166-185 |
20 |
|
|
State |
186-187 |
2 |
|
|
Postal/Zip Code |
188-196 |
9 |
|
|
Address Indicator |
197 |
1 |
|
|
Residence Code |
198 |
1 |
|
|
Reserved |
199-200 |
2 |
|
|
K4 Segment – Specialized Payment Information
|
|||
|
Segment Identifier |
1-2 |
2 |
|
|
Specialized Payment Indicator |
3-4 |
2 |
|
|
Deferred Payment Start Date |
5-12 |
8 |
|
|
Payment Due Date |
13-20 |
8 |
|
|
Payment Amount |
21-29 |
9 |
|
|
Reserved |
30 |
1 |
|
|
L1 Segment – Account Number Change
|
|||
|
Segment Identifier |
1-2 |
2 |
|
|
Change Indicator |
3 |
1 |
|
|
New Consumer Account Number |
4-33 |
30 |
|
|
New Identification Number |
34-53 |
20 |
|
|
Reserved |
54 |
1 |
|
|
Trailer Record |
|
|
|
|
Record Descriptor Word (RDW) |
1-4 |
4 |
|
|
Record Identifier |
5-11 |
7 |
|
|
Total Base Records |
12-20 |
9 |
|
|
Reserved |
21-29 |
9 |
|
|
Total of Status Code DF |
30-38 |
9 |
|
|
Total Associated Consumer Segments (J1) |
39-47 |
9 |
|
|
Total Associated Consumer Segments (J2) |
48-56 |
9 |
|
|
Block Count |
57-65 |
9 |
|
|
Total of Status Code DA |
66-74 |
9 |
|
|
Total of Status Code 05 |
75-83 |
9 |
|
|
Total of Status Code 11 |
84-92 |
9 |
|
|
Total of Status Code 13 |
93-101 |
9 |
|
|
Total of Status Code 61 |
102-110 |
9 |
|
|
Total of Status Code 62 |
111-119 |
9 |
|
|
Total of Status Code 63 |
120-128 |
9 |
|
|
Total of Status Code 64 |
129-137 |
9 |
|
|
Total of Status Code 65 |
138-146 |
9 |
|
|
Total of Status Code 71 |
147-155 |
9 |
|
|
Total of Status Code 78 |
156-164 |
9 |
|
|
Total of Status Code 80 |
165-173 |
9 |
|
|
Total of Status Code 82 |
174-182 |
9 |
|
|
Total of Status Code 83 |
183-191 |
9 |
|
|
Total of Status Code 84 |
192-200 |
9 |
|
|
Total of Status Code 88 |
201-209 |
9 |
|
|
Total of Status Code 89 |
210-218 |
9 |
|
|
Total of Status Code 93 |
219-227 |
9 |
|
|
Total of Status Code 94 |
228-236 |
9 |
|
|
Total of Status Code 95 |
237-245 |
9 |
|
|
Total of Status Code 96 |
246-254 |
9 |
|
|
Total of Status Code 97 |
255-263 |
9 |
|
|
Total of ECOA Code Z |
264-272 |
9 |
|
|
Total Employment Segments |
273-281 |
9 |
|
|
Total Original Creditor Segments |
282-290 |
9 |
|
|
Total Purchased Portfolio/Sold To Segments |
291-299 |
9 |
|
|
Total Mortgage Information Segments |
300-308 |
9 |
|
|
Total Specialized Payment Information Segments |
309-317 |
9 |
|
|
Total Change Segments |
318-326 |
9 |
|
|
Total Social Security Numbers (All Segments) |
327-335 |
9 |
|
|
Total Social Security Numbers (Base Segments) |
336-344 |
9 |
|
|
Total Social Security Numbers (J1 Segments) |
345-353 |
9 |
|
|
Total Social Security Numbers (J2 Segments) |
354-362 |
9 |
|
|
Total Dates of Birth (All Segments) |
363-371 |
9 |
|
|
Total Dates of Birth (Base Segments) |
372-380 |
9 |
|
|
Total Dates of Birth (J1 Segments) |
381-389 |
9 |
|
|
Total Dates of Birth (J2 Segments) |
390-398 |
9 |
|
|
Total Telephone Numbers (All Segments) |
399-407 |
9 |
|
|
Reserved |
408-426 |
19 |
|
|
Column
Number |
Column Name |
Length |
Type |
Description |
Database Source |
CRC Source |
|
1 |
Group |
6 |
A |
Group name, value is CRC |
|
|
|
2 |
Sub Group |
10 |
A |
Sub-group, Not used; pad with spaces. |
|
|
|
3 |
Client Number |
8 |
N |
Client ID number, assigned by collection agency. |
COLLECTION_QUEUE.CLIENT_NUMBER |
Administration > System Tables > Collections Queues > Edit > Client Number (COLLECTION_QUEUE.CLIENT_NUMBER) |
|
4 |
Account Name |
8 |
A |
Customer’s Account name. |
LOANMAIN.LOAN_NAME |
Administration > Customer Accounts > Loan/Receivable Details > Main |
|
5 |
Campus |
2 |
A |
Account’s campus code. |
LOANMAIN.CAMPUS |
Administration > Customer Accounts > Loan/Receivable Details > Main |
|
6 |
Claim Date |
6 |
N |
Not used; zero-fill. |
|
|
|
7 |
Client Number |
8 |
N |
Client ID number, assigned by collection agency. (same as Client Number above) |
COLLECTION_QUEUE.CLIENT_NUMBER |
Administration > System Tables > Collections Queues > Edit > Client Number |
|
8 |
Client Acct # |
15 |
A |
Customer’s Student ID |
CUSTMAIN.STUDENT_ID |
Administration > Customer Accounts > Add/Edit Customer |
|
9 |
Last name |
20 |
A |
Customer’s Last name |
CUSTMAIN.LASTNAME |
Administration > Customer Accounts > Add/Edit Customer |
|
10 |
First name |
12 |
A |
Customer’s First name |
CUSTMAIN.FIRSTNAME |
Administration > Customer Accounts > Add/Edit Customer |
|
11 |
Address1 |
25 |
A |
Customer’s address: street line 1 |
ADDRESS.ADDR1 |
Administration > Customer Accounts > Add/Edit Customer > Add/Update Addresses |
|
12 |
Address2 |
25 |
A |
Customer’s address: street line 2 |
ADDRESS.ADDR2 |
Administration > Customer Accounts > Add/Edit Customer > Add/Update Addresses |
|
13 |
City |
18 |
A |
Customer’s address: city |
ADDRESS.CITY |
Administration > Customer Accounts > Add/Edit Customer > Add/Update Addresses |
|
14 |
State |
2 |
A |
Customer’s address: state |
ADDRESS.STATE |
Administration > Customer Accounts > Add/Edit Customer > Add/Update Addresses |
|
15 |
Zip Code |
9 |
N |
Customer’s address: zip |
ADDRESS.ZIP |
Administration > Customer Accounts > Add/Edit Customer > Add/Update Addresses |
|
16 |
Mail Title |
1 |
N |
Not used; pad with spaces. |
|
|
|
17 |
Address Stat |
1 |
A |
Not used; pad with spaces. |
|
|
|
18 |
Home Phone |
10 |
N |
Customer’s Home phone |
ADDRESS.EVEPHONE |
Administration > Customer Accounts > Add/Edit Customer > Add/Update Addresses |
|
19 |
Work Phone |
10 |
N |
Customer’s Work phone |
ADDRESS.DAYPHONE |
Administration > Customer Accounts > Add/Edit Customer > Add/Update Addresses |
|
20 |
SSN |
9 |
N |
Customer’s Social security number |
CUSTMAIN.SSN |
Administration > Customer Accounts > Add/Edit Customer |
|
21 |
Birthday |
6 |
N |
Not used; zero-fill. |
CUSTMAIN.BIRTHDATE |
Administration > Customer Accounts > Add/Edit Customer |
|
22 |
Spouse Last |
20 |
A |
Not used; pad with spaces. |
|
|
|
23 |
Spouse First |
12 |
A |
Not used; pad with spaces. |
|
|
|
24 |
Spouse SSN |
9 |
A |
Not used; pad with spaces. |
|
|
|
Prin Past Due |
7 |
N |
Principal past due. Format is 99999v99. |
LOANFINC.PRINBALANCE |
Administration > Customer Accounts > Loan/Receivable Details > Financial |
|
|
26 |
Array1 |
10 |
A |
Not used; pad with spaces. |
|
|
|
27 |
Pnlty/Late Fee |
7 |
N |
Penalty and/or late charges. Format is 99999v99. |
LOANFINC.LCBALANCE |
Administration > Customer Accounts > Loan/Receivable Details > Financial |
|
28 |
Int Coll Cost |
7 |
N |
Internal collection cost, always 0000000. Format is 99999v99. |
000000 |
as of referral date |
|
29 |
Array2 |
7 |
N |
Not used; blank. Format is 99999v99. |
|
|
|
30 |
Non-Due Prin |
7 |
N |
Principal not due. Format is 99999v99. |
000000 |
as of referral date |
|
31 |
Coll Cost |
7 |
N |
Collection cost referred. Format is 99999v99. |
LOANFINC.CCBALANCE + calculated fees |
Administration > Customer Accounts > Loan/Receivable Details > Financial |
|
32 |
Int Amt |
9 |
N |
Interest referred. Format is 99999v9999. |
LOANFINC.INTBALANCE + calculated interest |
Administration > Customer Accounts > Loan/Receivable Details > Financial |
|
33 |
Claim Amt |
7 |
N |
Total claim, referral amount. Format is 99999v99. |
Prin Past Due + Pnlty/Late Fee + Coll Cost + Int Amt (25 + 27 + 31 + 32) |
Total referred to collection agency; as of referral date |
|
34 |
Coll Cost% |
5 |
N |
Collection cost percentage (i.e. 33.33% = 03333). Format is 9v9999. |
LOANFINC.CCPCTAGE |
Administration > Customer Accounts > Loan/Receivable Details > Financial |
|
35 |
APR |
5 |
N |
Annual percentage rate (i.e. 5% = 05000). Format is 99v999. |
LOANFINC.INTPCTAGE |
Administration > Customer Accounts > Loan/Receivable Details > Financial |
|
36 |
Interest c/s |
1 |
A |
Not used; blank |
|
|
|
37 |
Commission |
5 |
N |
Not used, zero fill. Format is 9v9999. |
|
|
|
38 |
Org Balance |
7 |
N |
Original amount loaned. Format is 99999v99. |
LOANFINC.PRINCIPAL |
Administration > Customer Accounts > Loan/Receivable Details > Financial |
|
39 |
Min Pymt. Amt |
7 |
N |
Minimum payment amount. Format is 99999v99. |
LOANFINC.PAYAMT |
Administration > Customer Accounts > Loan/Receivable Details > Financial |
|
40 |
Pay Freq |
1 |
A |
Payment frequency (M=Monthly Q=Quarterly) |
LOANFINC.PAYFREQ |
Administration > Customer Accounts > Loan/Receivable Details > Financial |
|
41 |
Acct Type |
20 |
A |
Not used; pad with spaces |
|
|
|
42 |
Sep Date |
6 |
N |
Separation/Last attended date |
LOANEXIT.SEPARATION_DATE |
Administration > Customer Accounts > Loan/Receivable Details > Exit |
|
43 |
Last Paid |
6 |
N |
Last paid date |
select max(transdate) from ledger where loan_link_id=@loanlinkid and transtype='pymt' and transubtype not in ('nsf','rev') |
Administration > Customer Accounts > Accounting Transaction Details |
|
44 |
Guarantee |
6 |
N |
Not used; zero-fill. |
|
|
|
45 |
First Due |
6 |
N |
First payment due date/cohort date |
LOANEXIT.REPYMT_BEINGS |
Administration > Customer Accounts > Loan/Receivable Details > Exit |
|
46 |
Debt Type |
3 |
N |
101 = NDSL/Perkins |
|
|
|
47 |
Referral |
1 |
A |
Constant value of 1 |
|
|
|
48 |
GA Paid Claim |
6 |
N |
Not used; zero-fill. |
|
|
|
49 |
Account Program |
2 |
N |
Not used; zero-fill. |
|
|
|
50 |
POE |
25 |
A |
Place of employment |
CUSTEMP.EMPLOYER_NAME |
Customer Accounts > Personal > Employment |
|
51 |
POE Address |
25 |
A |
Place of employment address |
ADDRESS.ADDR1 |
Customer Accounts > Personal > Employment |
|
52 |
POE City |
18 |
A |
Place of employment city |
ADDRESS.CITY |
Customer Accounts > Personal > Employment |
|
53 |
POE State |
2 |
A |
Place of employment state |
ADDRESS.STATE |
Customer Accounts > Personal > Employment |
|
54 |
POE Zip |
5 |
N |
Place of employment zip code |
ADDRESS.ZIP |
Customer Accounts > Personal > Employment |
|
55 |
POE Ext |
4 |
A |
Not used; blank |
|
|
|
56 |
POE Verify |
4 |
N |
Not used; blank |
|
|
|
57 |
Poe Title |
12 |
A |
Title |
CUSTEMP.EMP_POSITION |
Customer Accounts > Personal > Employment |
|
58 |
Poe T-on-Job |
4 |
A |
Not used; pad with spaces. |
|
|
|
59 |
Poe Salary |
7 |
N |
Not used; zero-fill. |
|
|
|
60 |
Bank #1 |
25 |
A |
Bank #1 name |
ACH.BANK |
Customer Accounts > Personal > ACH Accounts |
|
61 |
Bank #1 Chk |
1 |
A |
Not used; pad with spaces. |
|
|
|
62 |
Bank #1 Savings |
1 |
A |
Not used; pad with spaces. |
|
|
|
63 |
Bank #1 Acct # |
18 |
A |
Bank #1 account number |
ACH.BANK_ACCOUNT |
Customer Accounts > Personal > ACH Accounts |
|
64 |
Bank #1 Verify |
4 |
N |
Not used; zero-fill. |
|
|
|
65 |
Bank #2 |
25 |
A |
Not used; pad with spaces. |
|
|
|
66 |
Bank #2 Chk |
1 |
A |
Not used; pad with spaces. |
|
|
|
67 |
Bank #2 Savings |
1 |
A |
Not used; pad with spaces. |
|
|
|
68 |
Bank #2 Acct # |
18 |
A |
Not used; zero-fill. |
|
|
|
69 |
Bank #2 Verify |
4 |
N |
Not used; zero-fill. |
|
|
|
70 |
CoLastname |
20 |
A |
Co-Maker’s Last name |
not used |
|
|
71 |
CoFirstname |
12 |
A |
Co-Maker’s First name |
not used |
|
|
72 |
CoAddress |
25 |
A |
Co-Maker’s address: street |
not used |
|
|
73 |
CoCity |
18 |
A |
Co-Maker’s address: city |
not used |
|
|
74 |
CoState |
2 |
A |
Co-Maker’s address: state |
not used |
|
|
75 |
CoZipcode |
5 |
N |
Co-Maker’s address: zip code |
not used |
|
|
76 |
CoSSN |
9 |
N |
Co-Maker’s Social security number |
not used |
|
|
77 |
CoPOE |
25 |
A |
Not used; pad with spaces. |
|
|
|
78 |
CoPOE Address |
25 |
A |
Not used; pad with spaces. |
|
|
|
79 |
CoPOE City |
18 |
A |
Not used; pad with spaces. |
|
|
|
80 |
CoPOE State |
2 |
A |
Not used; pad with spaces. |
|
|
|
81 |
CoPOE Zipcode |
5 |
N |
Not used; pad with spaces. |
|
|
|
82 |
CoPOE Title |
12 |
A |
Not used; pad with spaces. |
|
|
|
83 |
CoPOE Verify |
4 |
N |
Not used; pad with spaces. |
|
|
|
84 |
CoHomephone |
10 |
N |
Co-Maker’s Home phone |
not used |
|
|
85 |
CoWorkphone |
10 |
N |
Co-Maker’s Work phone |
not used |
|
|
86 |
CoPOE Ext |
4 |
A |
Not used; pad with spaces. |
|
|
|
87 |
CoPOE T-on-Job |
4 |
A |
Not used; pad with spaces. |
|
|
|
88 |
CoPOE Salary |
7 |
N |
Not used; zero-fill. |
|
|
|
89 |
CoBank #1 |
25 |
A |
Not used; pad with spaces. |
|
|
|
90 |
CoBank #1 Chk |
1 |
A |
Not used; pad with spaces. |
|
|
|
91 |
CoBank #1 Save |
1 |
A |
Not used; pad with spaces. |
|
|
|
92 |
CoBank #1 Acct |
18 |
A |
Not used; pad with spaces. |
|
|
|
93 |
Parents |
30 |
A |
Not used; pad with spaces. |
|
|
|
94 |
Pparents Phone |
10 |
N |
Not used; pad with spaces. |
|
|
|
95 |
Batch Number |
20 |
A |
Not used; pad with spaces. |
|
|
|
96 |
8/10 Note Flag |
1 |
A |
Not used; pad with spaces. |
|
|
|
97 |
Term for %1 |
3 |
N |
Not used, zero-fill. |
|
|
|
98 |
Percent 1 |
5 |
N |
Not used, zero-fill. Format is 99v999. |
|
|
|
99 |
Perm for %2 |
3 |
N |
Not used, zero-fill. |
|
|
|
100 |
Percent 2 |
5 |
N |
Not used, zero-fill. Format is 99v999. |
|
|
|
101 |
Due Date |
6 |
N |
Last payment due date |
LOANFINC.DUEDATE - LOANFINC.PAST_DUE_INSTALLMENTS |
Administration > Customer Accounts > Loan/Receivable Details > Financial |
|
102 |
Last Pay Amt |
7 |
N |
Last payment amount. Format is 99999v99. |
LOANMAIN.LAST_PAYAMT |
Administration > Customer Accounts > Loan/Receivable Details > Main |
|
103 |
Prin Date |
6 |
N |
Not used, zero-fill. |
|
|
|
104 |
Cell Phone |
10 |
N |
Customer's Cell Phone |
ADDRESS.MOBILE_PHONE |
Administration > Customer Accounts > Add/Edit Customer > Add/Update Addresses |
|
105 |
E-Mail Address |
128 |
A |
Customer's E-Mail Address |
ADDRESS.INTERNET |
Administration > Customer Accounts > Add/Edit Customer > Add/Update Addresses |
|
106 |
Past Due Inst. |
5 |
N |
Past Due Installments |
LOANFINC.PAST_DUE_INSTALLMENTS |
Administration > Customer Accounts > Loan/Receivable Details > Financial |
|
107 |
Last Statement Date |
6 |
N |
Last Statement Date YYMMDD |
select max(invoice_date) from invoice i inner join invoice_detail d on i.INVOICE_ID = d.INVOICE_ID |
Customer Accounts > Correspondence > Invoices |
|
108 |
Itemization Date Used to Calculate Accruals |
4 |
A |
PAID when last paid date used; STMT when last statement date used |
"PAID" when last paid date not null else "STMT" date when last paid date is null and last statement date is not null else NULL |
|
|
109 |
Interest Since Itemization Date |
7 |
N |
Interest accrued since itemization date; Format is 99999v99. |
SPLoanAmountDue calculates difference between interest_due today and interest due as of last paid or statement date |
|
|
110 |
Fees Since Itemization Date |
7 |
N |
Fees accrued since itemization date; Format is 99999v99. |
SPLoanAmountDue calculates difference between late_fee_due + coll_fee_due today and late_fee_due + coll_fee_due as of last paid or statement date |
|
|
111 |
Adjustments Since Itemization Date |
7 |
N |
Adjustments accrued since itemization date; Format is 99999v99. |
SPLoanAmountDue calculates difference between principal_due today and principal due as of last paid or statement date |
|
|
112 |
Balance as of Itemization Date |
8 |
N |
Balance as of itemization date. Format is 999999v99. |
Calculated as claim amount - interest since - fees since +/- adjustments since |
|
|
113 |
Unused Space |
66 |
A |
Not used; pad with spaces. |
|
|
|
Field |
Field Name |
Required? |
Start |
Length |
Data Type |
Justify |
Padding |
|
Header Record (HR) |
|||||||
|
1 |
Record-Type-Code |
Yes |
1 |
2 |
PIC X(02) |
- |
N/A |
|
2 |
Sender-ID-Number |
Yes |
3 |
9 |
PIC X(09) |
- |
N/A |
|
3 |
Recipient-ID-Number |
Yes |
12 |
9 |
PIC X(09) |
- |
N/A |
|
4 |
School-ID |
Yes |
21 |
9 |
PIC X(09) |
- |
N/A |
|
5 |
File-Creation-Date |
Yes |
30 |
8 |
PIC 9(08) |
- |
N/A |
|
6 |
File-Creation-Time |
Yes |
38 |
6 |
PIC 9(06) |
- |
N/A |
|
7 |
File-Identifier-Code |
Yes |
44 |
1 |
PIC X(01) |
- |
N/A |
|
8 |
Data-Type-Code |
Yes |
45 |
2 |
PIC X(02) |
- |
N/A |
|
9 |
Number-Inserts |
C |
47 |
1 |
PIC 9(01) |
- |
N/A |
|
10 |
Print-Service |
C |
48 |
2 |
PIC X(02) |
- |
N/A |
|
11 |
Filler - Reserved |
Yes |
50 |
28 |
PIC X(28) |
- |
N/A |
|
12 |
School-Name |
No |
78 |
30 |
PIC X(30) |
- |
N/A |
|
13 |
School-Inquiry-Contact |
No |
108 |
30 |
PIC X(30) |
- |
N/A |
|
14 |
Filler1 |
Yes |
138 |
183 |
PIC X(183) |
- |
- |
|
Student Record (01) |
|||||||
|
15 |
Record-Type Code |
Yes |
1 |
2 |
PIC X(02) |
- |
N/A |
|
16 |
Payment-Type |
Yes |
3 |
2 |
PIC X(02) |
- |
N/A |
|
17 |
Notice-Type |
Yes |
5 |
40 |
PIC X(40) |
Left |
Spaces |
|
18 |
Student-Account-Number |
Yes |
45 |
16 |
PIC X(16) |
Left |
Spaces |
|
19 |
Student-Last-Name |
Yes |
61 |
35 |
PIC X(35) |
Left |
Spaces |
|
20 |
Student-First-Name |
Yes |
96 |
25 |
PIC X(25) |
Left |
Spaces |
|
21 |
Student-Middle-Initial |
No |
121 |
1 |
PIC X(01) |
Left |
Spaces |
|
22 |
Student-Address1 |
Yes |
122 |
40 |
PIC X(40) |
Left |
Spaces |
|
23 |
Student-Address2 |
No |
162 |
40 |
PIC X(40) |
Left |
Spaces |
|
24 |
Student-City |
Yes |
202 |
25 |
PIC X(25) |
Left |
Spaces |
|
25 |
Student-State |
Yes |
227 |
2 |
PIC X(02) |
- |
N/A |
|
26 |
Student-Zip |
Yes |
229 |
5 |
PIC X(04) |
- |
N/A |
|
27 |
Student-Zip+4 |
No |
234 |
4 |
PIC X(05) |
Left |
Spaces |
|
28 |
Student-Country |
C |
238 |
25 |
PIC X(25) |
Left |
Spaces |
|
29 |
Student-Care-Of |
No |
263 |
50 |
PIC X(50) |
Left |
Spaces |
|
30 |
Student-DOB |
C |
313 |
8 |
PIC X(08) |
Left |
Spaces |
|
Billing Record (02) |
|||||||
|
31 |
Record-Type-Code |
Yes |
1 |
2 |
PIC X(02) |
- |
N/A |
|
32 |
Billing-Date |
Yes |
3 |
15 |
PIC X(15) |
Left |
Spaces |
|
33 |
Billing-Amount-Due |
Yes |
18 |
8 |
PIC 9(06)v99 |
Right |
Zeros |
|
34 |
Billing-Due-Date |
Yes |
26 |
15 |
PIC X(15) |
Left |
Spaces |
|
|
Billing-Due-Buckets |
|
|
|
|
|
|
|
35 |
Billing-Due-Buckets-Current |
No |
41 |
8 |
PIC 9(06)v99 |
Right |
Zeros |
|
36 |
Billing-Due-Buckets- Pastdue-31-60 |
No |
49 |
8 |
PIC 9(06)v99 |
Right |
Zeros |
|
37 |
Billing-Due-Buckets- Pastdue-61-90 |
No |
57 |
8 |
PIC 9(06)v99 |
Right |
Zeros |
|
38 |
Billing-Due-Buckets- Pastdue-91-150 |
No |
65 |
8 |
PIC 9(06)v99 |
Right |
Zeros |
|
39 |
Billing-Due-Buckets- Pastdue-over-150 |
No |
73 |
8 |
PIC 9(06)v99 |
Right |
Zeros |
|
40 |
Billing-Previous-Balance |
No |
81 |
8 |
PIC S9(06)v99 |
Right |
Zeros |
|
41 |
Billing-Current-Balance |
No |
89 |
8 |
PIC S9(06)v99 |
Right |
Zeros |
|
42 |
Billing-School-Specific-Amt1 |
No |
97 |
8 |
PIC S9(06)v99 |
Right |
Zeros |
|
43 |
Billing-School-Specific-Amt2 |
No |
105 |
8 |
PIC S9(06)v99 |
Right |
Zeros |
|
44 |
Billing-School-Specific-Amt3 |
No |
113 |
8 |
PIC S9(06)v99 |
Right |
Zeros |
|
45 |
Billing-School-Specific-data1 |
No |
121 |
10 |
PIC X(10) |
Left |
Spaces |
|
46 |
Billing-School-Specific-data2 |
No |
131 |
10 |
PIC X(10) |
Left |
Spaces |
|
47 |
Billing-School-Specific-data3 |
No |
141 |
10 |
PIC X(10) |
Left |
Spaces |
|
48 |
Eligibility-Indicator |
No |
151 |
01 |
PIC X(01) |
Left |
Spaces |
|
49 |
Student-Phone1 |
No |
152 |
10 |
PIC X(10) |
Left |
Spaces |
|
50 |
Student-Phone2 |
No |
162 |
10 |
PIC X(10) |
Left |
Spaces |
|
51 |
Student-Email |
No |
172 |
50 |
PIC X(50) |
Left |
Spaces |
|
52 |
Filler- - Reserved |
Yes |
222 |
99 |
PIC X(99) |
- |
- |
|
Detail Record (03) |
|||||||
|
53 |
Record-Type-Code |
Yes |
1 |
2 |
PIC X(02) |
- |
N/A |
|
54 |
Semester-Term |
No |
3 |
15 |
PIC X(15) |
Left |
Spaces |
|
55 |
Detail-Date |
No |
18 |
10 |
PIC X(10) |
Left |
Spaces |
|
56 |
Detail-Description |
No |
28 |
35 |
PIC X(35) |
Left |
Spaces |
|
57 |
Detail-Charges |
No |
63 |
8 |
PIC S9(06)v99 |
Right |
Zeros |
|
58 |
Detail-Credit |
No |
71 |
8 |
PIC S9(06)v99 |
Right |
Zeros |
|
59 |
Detail-Notes |
No |
79 |
15 |
PIC X(15) |
Left |
Spaces |
|
60 |
Detail-Type |
No |
94 |
2 |
PIC X(02) |
- |
N/A |
|
61 |
Detail Balance |
No |
96 |
8 |
PIC S9(06)v99 |
Right |
Zeros |
|
62 |
Detail-Min-Due |
No |
104 |
8 |
PIC S9(06)v99 |
Right |
Zeros |
|
63 |
Detail-Additional-Description |
No |
112 |
45 |
PIC X(45) |
Left |
Spaces |
|
64 |
Filler- - Reserved |
Yes |
157 |
164 |
PIC X(164) |
- |
- |
|
Notice-Record (04) |
|||||||
|
65 |
Record-Type-Code |
Yes |
1 |
2 |
PIC X(02) |
- |
N/A |
|
66 |
Notice-Text |
No |
3 |
90 |
PIC X(90) |
Left |
Spaces |
|
67 |
Filler- - Reserved |
Yes |
93 |
228 |
PIC X(228) |
- |
- |
|
Comment Record (05) |
|||||||
|
68 |
Record-Type-Code |
Yes |
1 |
2 |
PIC X(02) |
- |
N/A |
|
69 |
Comment-Text |
No |
3 |
90 |
PIC X(90) |
Left |
Spaces |
|
70 |
Comment-Type |
Yes |
93 |
2 |
PIC X(02) |
??? |
??? |
|
71 |
Filler- - Reserved |
|
95 |
226 |
PIC X(226) |
- |
- |
|
Alternate-Address-Record (06) |
|||||||
|
72 |
Record-Type-Code |
Yes |
1 |
2 |
PIC X(02) |
- |
N/A |
|
73 |
Student-Account-Number |
C |
3 |
16 |
PIC X(16) |
Left |
Spaces |
|
74 |
Alt-Last-Name |
C |
19 |
35 |
PIC X(35) |
Left |
Spaces |
|
75 |
Alt-First-Name |
C |
54 |
25 |
PIC X(25) |
Left |
Spaces |
|
76 |
Alt-Middle-Name |
No |
79 |
1 |
PIC X(01) |
Left |
Spaces |
|
77 |
Alt-Address1 |
C |
80 |
40 |
PIC X(40) |
Left |
Spaces |
|
78 |
Alt-Address2 |
No |
120 |
40 |
PIC X(40) |
Left |
Spaces |
|
79 |
Alt-City |
C |
160 |
25 |
PIC X(25) |
Left |
Spaces |
|
80 |
Alt-State |
C |
185 |
2 |
PIC X(02) |
- |
N/A |
|
81 |
Alt-Zip |
C |
187 |
5 |
PIC 9(05) |
- |
N/A |
|
82 |
Alt-Zip+4 |
No |
192 |
4 |
PIC 9(04) |
Right |
Zeros |
|
83 |
Country |
No |
196 |
25 |
PIC X(25) |
Left |
Spaces |
|
84 |
Alt-Care-Of |
No |
221 |
50 |
PIC X(25) |
Left |
Spaces |
|
85 |
Alt-Name-Prefix |
No |
271 |
15 |
PIC X(15) |
Left |
Spaces |
|
86 |
Alt-Name-Suffix |
No |
286 |
05 |
PIC X(05) |
Left |
Spaces |
|
87 |
Filler- - Reserved |
Yes |
291 |
30 |
PIC X(30) |
- |
- |
|
Trailer Record (TR) |
|||||||
|
88 |
Record-Type-Code |
Yes |
1 |
2 |
PIC X(02) |
- |
N/A |
|
89 |
Student-Record-Count |
Yes |
3 |
5 |
PIC 9(05) |
Right |
Zeros |
|
90 |
Bill-Record-Count |
Yes |
8 |
5 |
PIC 9(05)8 |
Right |
Zeros |
|
91 |
05 File-Creation-Date |
Yes |
13 |
8 |
PIC 9(08) |
- |
- |
|
92 |
05 File-Creation-Time |
Yes |
21 |
6 |
PIC 9(06) |
- |
- |
|
93 |
05 Filler- - Reserved |
Yes |
27 |
294 |
PIC X(294) |
- |
- |
|
Note: C = The field may be required if certain business conditions exist, as outlined in the field descriptions [???where?], at the time of file submission. |
|||||||
|
A single carriage return must be placed at the end of each record contained in the file. |
|||||||
|
"T" Header |
|
|
T = Transmitter’s info |
|
Field |
Position |
Length |
Value |
|
Record ID |
1 |
1 |
T |
|
Rpt year |
2-5 |
4 |
The year for which interest is being reported, formatted yyyy. |
|
Filler |
6 |
1 |
|
|
EIN |
7-15 |
9 |
Transmitter’s Employer ID #. Value comes from Administration/System Configuration Parameters/IRS 1098-E Parameters. |
|
TCC |
16-20 |
5 |
Transmitter’s control code. Value comes from Administration/System Configuration Parameters/IRS 1098-E Parameters. |
|
Filler |
21-27 |
7 |
Blank |
|
Test File Indicator |
28 |
1 |
T for Test submission file, blank for Real report file. |
|
Foreign Entity Indicator |
29 |
1 |
1 if transmitter is foreign, otherwise blank |
|
Name |
30-69 |
40 |
Transmitter’s name. Value comes from Administration/System Configuration Parameters/IRS 1098-E Parameters. |
|
Filler |
70-109 |
40 |
|
|
Name |
110-149 |
40 |
Transmitter’s name (duplicate). Value comes from Administration/System Configuration Parameters/IRS 1098-E Parameters. |
|
Filler |
150-189 |
40 |
|
|
Address |
190-229 |
40 |
Transmitter’s address. Value comes from Administration/System Configuration Parameters/IRS 1098-E Parameters. |
|
City |
230-269 |
40 |
This is part of the Transmitter’s address. Value comes from Administration/System Configuration Parameters/IRS 1098-E Parameters. |
|
State |
270-271 |
2 |
This is part of the Transmitter’s address. Value comes from Administration/System Configuration Parameters/IRS 1098-E Parameters. |
|
Zip |
272-280 |
9 |
This is part of the Transmitter’s address. Value comes from Administration/System Configuration Parameters/IRS 1098-E Parameters. Zip is 5 +4, no dash Leave +4 blank if unknown. |
|
Filler |
281-295 |
15 |
|
|
Payee rec count |
296-303 |
8 |
Number of Payee records (B records) in file. |
|
Contact name |
304-343 |
40 |
Transmitter contact. Value comes from Administration/System Configuration Parameters/IRS 1098-E Parameters. |
|
Contact phone |
344-358 |
15 |
Transmitter contact phone. Value comes from Administration/System Configuration Parameters/IRS 1098-E Parameters. |
|
Contact email |
359-408 |
40 |
Transmitter contact email. |
|
Cartridge Tape Indicator |
409-410 |
2 |
Not used; blank. (Required for tape cartridge filers only.) |
|
Transmitter’s Media Number |
411-416 |
6 |
Not used; blank. (Required for tape cartridge filers only.) |
|
Filler |
417-499 |
83 |
Blank |
|
Record Sequence # |
500-507 |
8 |
Value is 00000001. T record is always record # 1. |
|
Filler |
508-517 |
10 |
Blank |
|
Vendor Indicator |
518 |
1 |
Value is V. (Software purchased from a Vendor) |
|
Vendor Name |
519-558 |
40 |
|
|
Vendor Mailing Address |
559-598 |
40 |
|
|
Vendor City |
599-638 |
40 |
|
|
Vendor State |
639-640 |
2 |
|
|
Vendor Zip Code |
641-649 |
9 |
|
|
Vendor Contact Name |
650-689 |
40 |
|
|
Vendor Contact Phone # |
690-704 |
15 |
|
|
Filler |
705-739 |
35 |
Blank |
|
Vendor Foreign Entity Indicator |
740 |
1 |
1 if vendor is a foreign entity otherwise blank. |
|
Filler |
741-748 |
8 |
Blank |
|
End of line |
749-750 |
2 |
Carriage return/line feed. |
|
"A" Header |
|
|
A = Lender info |
|
Field |
Pos |
Length |
Value |
|
Record id |
1 |
1 |
A |
|
Reporting year |
2-5 |
4 |
The year for which interest is being reported, formatted yyyy. |
|
Filler |
6-11 |
6 |
Blank |
|
EIN |
12-20 |
9 |
Lender’s Employer ID #. Value comes from Administration/System Configuration Parameters/IRS 1098-E Parameters. |
|
Lender name control |
21-24 |
4 |
Not used; always blank. |
|
Filler |
25-26 |
2 |
|
|
Type of Return |
27 |
1 |
Always a value of 2 (1098-E) |
|
Amount code |
28-41 |
14 |
Always a value of 1 (Student Account interest) |
|
Filler |
42-47 |
6 |
Blank |
|
Original file indicator |
48 |
1 |
1 if this is an original report file; blank if not. |
|
Replacement file indicator |
49 |
1 |
1 if this is a replacement report file; blank if not. |
|
Correction file indicator |
50 |
1 |
1 if this is a correction file; blank if not. |
|
Filler |
51 |
1 |
Blank |
|
Foreign entity indicator |
52 |
1 |
1 if payer is foreign; blank if not |
|
Lender name |
53-92 |
40 |
Value comes from Administration/System Configuration Parameters/IRS 1098-E Parameters. |
|
Second lender name |
93-132 |
40 |
Not used; blank. |
|
Transfer agent indicator |
133 |
1 |
Always 0. (not the transfer agent) |
|
Lender Address |
134-173 |
40 |
Value comes from Administration/System Configuration Parameters/IRS 1098-E Parameters. |
|
Lender City |
174-213 |
40 |
Value comes from Administration/System Configuration Parameters/IRS 1098-E Parameters. |
|
Lender State |
214-215 |
2 |
Value comes from Administration/System Configuration Parameters/IRS 1098-E Parameters. |
|
Lender Zip |
216-224 |
9 |
Value comes from Administration/System Configuration Parameters/IRS 1098-E Parameters. |
|
Lender contact phone |
225-239 |
15 |
Value comes from Administration/System Configuration Parameters/IRS 1098-E Parameters. |
|
Filler |
240-499 |
260 |
Blank |
|
Record Sequence # |
500-507 |
8 |
Number of the record as it appears with the file. |
|
Filler |
508-748 |
241 |
Blank |
|
End of line |
749-750 |
|
Carriage return/line feed |
|
"B" Detail |
|
|
B = Customer interest detail |
|
Field |
Pos |
Length |
Value |
|
Record type |
1 |
1 |
B |
|
Reporting year |
2-5 |
4 |
The year for which interest is being reported; formatted yyyy. |
|
Corrected return indicator |
6 |
1 |
Always blank. |
|
Name control |
7-10 |
4 |
First 4 characters of last name. Do not use apostrophe (‘) or hyphen (-). |
|
TIN type |
11 |
1 |
Always 2 – indicating we are reporting SSN. |
|
SS# |
12-20 |
9 |
No dashes |
|
Filler |
21-40 |
20 |
Blank |
|
Filler |
41-44 |
4 |
Blank |
|
Filler |
45-54 |
10 |
Blank |
|
Interest reported |
55-66 |
12 |
Right-justified, fill with zeros, no decimals. Example: $500.50 would be entered as 000000050050 |
|
Filler |
67-222 |
156 |
Enter all zeros. |
|
Filler |
223-246 |
24 |
Blank |
|
Foreign country indicator |
247 |
1 |
Enter 1 if address is non-USA otherwise blank. |
|
Customer name |
248-287 |
40 |
First and last name, space separated; i.e., John Smith |
|
Filler |
288-327 |
40 |
Blank |
|
Filler |
328-367 |
40 |
Blank |
|
Customer address |
368-407 |
40 |
Address (lines 1 and 2 if applicable). Value comes from Customer’s address record. |
|
Filler |
408-447 |
40 |
Blank |
|
Customer city |
448-487 |
40 |
From the Customer’s address record. |
|
Customer state |
488-489 |
2 |
From the Customer’s address record. |
|
Customer zip |
490-498 |
9 |
From the Customer’s address record. No dashes, zip +4. Leave +4 blank if unknown. |
|
Filler |
499 |
1 |
Blank |
|
Record Sequence # |
500-507 |
8 |
Number of record within file. |
|
Filler |
508-546 |
39 |
Blank |
| Orig Indicator | 547 | 1 | 1 if amount in pay amount field one does not contain origination fees or capitalized interest, otherwise blank |
|
Filler |
548-748 |
201 |
Blank |
|
End of line |
749-750 |
2 |
Carriage return/line feed |
|
"C" Trailer |
|
|
C = Trailer |
|
Field |
Pos |
Length |
Value |
|
Record type |
1 |
1 |
C |
|
Payee record count |
2-9 |
8 |
Number of Payee records (B records) in file. |
|
Filler |
10-15 |
6 |
|
|
Total interest reported |
16-33 |
18 |
Total amount of interest reported in B payee records. Right-justified, fill with zeros, no decimals; i.e., $500.50 would be reported as 000000050050 |
|
Filler |
34-267 |
234 |
Zero-fill |
|
Filler |
268-499 |
232 |
Blank |
|
Record Sequence # |
500-507 |
8 |
Number of record within file. |
|
Filler |
508-748 |
241 |
Blank |
|
End of line |
749-750 |
2 |
Carriage return/line feed |
|
"F" Trailer |
|
|
F = Trailer |
|
Field |
Pos |
Length |
Value |
|
Record type |
1 |
1 |
F |
|
# of "A" records |
2-9 |
8 |
Number of A records in file. Should always be 1. |
|
Filler |
10-30 |
21 |
Zero-fill |
|
Filler |
31-49 |
19 |
Blank |
|
# of “B” records |
50-57 |
8 |
Number of B records in file. |
|
Filler |
58-499 |
442 |
Blank |
|
Record Sequence # |
500-507 |
8 |
Number of record within file. |
|
Filler |
508-748 |
241 |
Blank |
|
End of line |
749-750 |
2 |
Carriage return/line feed |