Collections
Referral File Format
Below is the format of the Collections Referral extract file.
|
No. |
Name |
Length |
Type |
Description |
|
|
1 |
Group |
6 |
0 |
A |
Group name, constant value of "CLM" |
|
2 |
Sub Group |
10 |
0 |
A |
Sub group, not used, always blank |
|
3 |
Client Number |
8 |
0 |
N |
Client ID number, assign by collector |
|
4 |
Fund/Campus |
10 |
0 |
A |
Not used, always blank |
|
5 |
Claim Date |
6 |
0 |
N |
Not used, enter a value of zero |
|
6 |
Client Number |
8 |
0 |
N |
Client ID number, duplicate of above |
|
7 |
Client Acct # |
15 |
0 |
A |
Debtor’s Social security number |
|
8 |
Lastname |
20 |
0 |
A |
Debtor’s Last name |
|
9 |
Firstname |
12 |
0 |
A |
Debtor’s First name |
|
10 |
Address1 |
25 |
0 |
A |
Debtor’s address: street line 1 |
|
11 |
Address2 |
25 |
0 |
A |
Debtor’s address: street line 2 |
|
12 |
City |
18 |
0 |
A |
Debtor’s address: city |
|
13 |
State |
2 |
0 |
A |
Debtor’s address: state |
|
14 |
Zip Code |
9 |
0 |
N |
Debtor’s address: zip+four |
|
15 |
Mail Title |
1 |
0 |
N |
Not used, always blank |
|
16 |
Address Stat |
1 |
0 |
A |
Not used, always blank |
|
17 |
Home Phone |
10 |
0 |
N |
Debtor’s Home phone |
|
18 |
Work Phone |
10 |
0 |
N |
Debtor’s Work phone |
|
19 |
SSN |
9 |
0 |
N |
Debtor’s Social security number |
|
20 |
Birthday |
6 |
0 |
N |
Not used, enter a value of zero |
|
21 |
Spouse Last |
20 |
0 |
A |
Not used, always blank |
|
22 |
Spouse First |
12 |
0 |
A |
Not used, always blank |
|
23 |
Spouse SSN |
9 |
0 |
A |
Not used, always blank |
|
24 |
Prin Past Due |
7 |
2 |
N |
Principal past due |
|
25 |
Array1 |
10 |
0 |
A |
Not used, always blank |
|
26 |
Pnlty/Late Fee |
7 |
2 |
N |
Penalty and / or late charges |
|
27 |
Int Coll Cost |
7 |
2 |
N |
Internal collection cost, always 0000000 |
|
28 |
Array2 |
7 |
2 |
N |
Not used, always blank |
|
29 |
Non-Due Prin |
7 |
2 |
N |
Principal not due |
|
30 |
Coll Cost |
7 |
2 |
N |
Collection cost referred |
|
31 |
Int Amt |
9 |
4 |
N |
Interest referred |
|
32 |
Claim Amt |
7 |
2 |
N |
Total claim, referral amount |
|
33 |
Coll Cost% |
5 |
4 |
N |
Collection cost percentage (ie 33.33% = 03333) |
|
34 |
APR |
5 |
3 |
N |
Annual percentage rate (i.e. 5% = 05000) |
|
35 |
Interest c/s |
1 |
0 |
A |
Not used, always blank |
|
36 |
Commission |
5 |
4 |
N |
Not used, enter a value of zero |
|
37 |
Org Balance |
7 |
2 |
N |
Original amount loaned |
|
38 |
Min Pymt Amt |
7 |
2 |
N |
Minimum payment amount |
|
39 |
Pay Freq |
1 |
0 |
A |
Payment frequency (M=Monthly Q=Quarterly) |
|
40 |
Acct Type |
20 |
0 |
A |
Not used, always blank |
|
41 |
Sep Date |
6 |
0 |
N |
Separation/Last attended date |
|
42 |
Last Paid |
6 |
0 |
N |
Last paid date |
|
43 |
Guarantee |
6 |
0 |
N |
Not used, enter a value of zero |
|
44 |
First Due |
6 |
0 |
N |
First payment due date / cohort date |
|
45 |
Debt Type |
3 |
0 |
N |
101=NDSL/Perkins 102=Nursing 103=Heath Prof |
|
46 |
Referral |
1 |
0 |
A |
Constant value of "1" |
|
47 |
Ga Paid Claim |
6 |
0 |
N |
Not used, enter a value of zero |
|
48 |
Loan Program |
2 |
0 |
N |
Not used, enter a value of zero |
|
49 |
POE |
25 |
0 |
A |
Place of employment |
|
50 |
POE Address |
25 |
0 |
A |
Place of employment address |
|
51 |
POE City |
18 |
0 |
A |
Place of employment city |
|
52 |
POE State |
2 |
0 |
A |
Place of employment state |
|
53 |
POE Zipcode |
5 |
0 |
N |
Place of employment zipcode |
|
54 |
POE Ext |
4 |
0 |
A |
Place of employment phone extension always blank |
|
55 |
POE Verify |
4 |
0 |
N |
Verify Place of employment |
|
56 |
Poe Title |
12 |
0 |
A |
Title |
|
57 |
Poe T-on-Job |
4 |
0 |
A |
Not used, always blank |
|
58 |
Poe Salary |
7 |
0 |
N |
Not used, enter a value of zero |
|
59 |
Bank #1 |
25 |
0 |
A |
Bank #1 name |
|
60 |
Bank #1 Chk |
1 |
0 |
A |
Not used, always blank |
|
61 |
Bank #1 Savings |
1 |
0 |
A |
Not used, always blank |
|
62 |
Bank #1 Acct # |
18 |
0 |
A |
Bank #1 account number |
|
63 |
Bank #1 Verify |
4 |
0 |
N |
Not used, enter a value of zero |
|
64 |
Bank #2 |
25 |
0 |
A |
Not used, always blank |
|
65 |
Bank #2 Chk |
1 |
0 |
A |
Not used, always blank |
|
66 |
Bank #2 Savings |
1 |
0 |
A |
Not used, always blank |
|
67 |
Bank #2 Acct # |
18 |
0 |
A |
Not used, always blank |
|
68 |
Bank #2 Verify |
4 |
0 |
N |
Not used, enter a value of zero |
|
69 |
CoLastname |
20 |
0 |
A |
Co-Maker’s Last name |
|
70 |
CoFirstname |
12 |
0 |
A |
Co-Maker’s First name |
|
71 |
CoAddress |
25 |
0 |
A |
Co-Maker’s address: street line 1 |
|
72 |
CoCity |
18 |
0 |
A |
Co-Maker’s address: city |
|
73 |
CoState |
2 |
0 |
A |
Co-Maker’s address: state |
|
74 |
CoZipcode |
5 |
0 |
N |
Co-Maker’s address: zip |
|
75 |
CoSSN |
9 |
0 |
N |
Co-Maker’s Social security number |
|
76 |
CoPOE |
25 |
0 |
A |
Not used, always blank |
|
77 |
CoPOE Address |
25 |
0 |
A |
Not used, always blank |
|
78 |
CoPOE City |
18 |
0 |
A |
Not used, always blank |
|
79 |
CoPOE State |
2 |
0 |
A |
Not used, always blank |
|
80 |
CoPOE Zipcode |
5 |
0 |
N |
Not used, always blank |
|
81 |
CoPOE Title |
12 |
0 |
A |
Not used, always blank |
|
82 |
CoPOE Verify |
4 |
0 |
N |
Not used, always blank |
|
83 |
CoHomephone |
10 |
0 |
N |
Co-Maker’s Home phone |
|
84 |
CoWorkphone |
10 |
0 |
N |
Co-Maker’s Work phone |
|
85 |
CoPOE Ext |
4 |
0 |
A |
Not used, always blank |
|
86 |
CoPOE T-on-Job |
4 |
0 |
A |
Not used, always blank |
|
87 |
CoPOE Salary |
7 |
0 |
N |
Not used, enter a value of zero |
|
88 |
CoBank #1 |
25 |
0 |
A |
Not used, always blank |
|
89 |
CoBank #1 Chk |
1 |
0 |
A |
Not used, always blank |
|
90 |
CoBank #1 Save |
1 |
0 |
A |
Not used, always blank |
|
91 |
CoBank #1 Acct |
18 |
0 |
A |
Not used, always blank |
|
92 |
Parents |
30 |
0 |
A |
Not used, always blank |
|
93 |
Pparents Phone |
10 |
0 |
N |
Not used, always blank |
|
94 |
Batch Number |
20 |
0 |
A |
Not used, always blank |
|
95 |
8/10 Note Flag |
1 |
0 |
A |
Not used, always blank |
|
96 |
Term for %1 |
3 |
0 |
N |
Not used, enter a value of zero |
|
97 |
Percent 1 |
5 |
3 |
N |
Not used, enter a value of zero |
|
98 |
Perm for %2 |
3 |
0 |
N |
Not used, enter a value of zero |
|
99 |
Percent 2 |
5 |
3 |
N |
Not used, enter a value of zero |
|
100 |
Due Date |
6 |
0 |
N |
Last payment due date |
|
101 |
Last Pay Amt |
7 |
2 |
N |
Last payment amount |
|
102 |
Prin Date |
6 |
0 |
N |
Not used, enter a value of zero |
|
103 |
Lender Code |
10 |
0 |
A |
Not used, always blank |
|
104 |
Lender Name |
25 |
0 |
A |
Not used, always blank |
|
105 |
Lender Addr1 |
25 |
0 |
A |
Not used, always blank |
|
106 |
Lender Addr2 |
25 |
0 |
A |
Not used, always blank |
|
107 |
Lender City |
18 |
0 |
A |
Not used, always blank |
|
108 |
Lender State |
2 |
0 |
A |
Not used, always blank |
|
109 |
Lender Zip |
9 |
0 |
N |
Not used, enter a value of zero |
|
110 |
Lender Phone |
10 |
0 |
N |
Not used, enter a value of zero |
|
111 |
Orig Lend Code |
10 |
0 |
A |
Not used, always blank |
|
112 |
Orig Lend Name |
25 |
0 |
A |
Not used, always blank |
|
113 |
Orig Lend Add1 |
25 |
0 |
A |
Not used, always blank |
|
114 |
Orig Lend Add2 |
25 |
0 |
A |
Not used, always blank |
|
115 |
Orig Lend City |
18 |
0 |
A |
Not used, always blank |
|
116 |
Orig Lend St |
2 |
0 |
A |
Not used, always blank |
|
117 |
Orig Lend Zip |
9 |
0 |
N |
Not used, enter a value of zero |
|
118 |
Orig Lend Ph |
10 |
0 |
N |
Not used, enter a value of zero |