Borrower and Loan Data Inbound File Format

Record Processing

Borrower and Loan Data is provided using from 1 to 5 data records. Depending on the information provided, it is possible to accomplish any of the following actions using this record set:

·         Originate a new loan for a new borrower

·         Originate a new loan for an existing borrower

·         Provide a subsequent disbursement (increase the loan amount) for an existing loan

·         Change borrower-related information (name, address, phone number, date of birth, driver's license number, sex) for an existing borrower

Each record is comprised of a record identifier in column 1, and a record termination character in the last column. Record 1 and 2 are mandatory. Record 3 and 4 are optional and used if updating/adding a mailing address. If a Record 3 exists, then a Record 4 is mandatory. If Record 3 is omitted but a new Borrower is created, the Enroll End Date will be substituted for the Estimated Grad Date.

It is possible to originate a new loan for a new borrower by only providing Records 1 and 2. However this will result in the user being prompted to provide certain mandatory fields when viewing the borrower and loan records through the Borrower Services and/or Office Management functions. For example, assume that a new borrower and loan are originated by supplying just records 1 and 2. When the new borrower is viewed through the Borrower Services/Personal Information function, you will be prompted to supply a Date of Birth for the borrower before you are able to save the data on the screen.

New Borrower

A new borrower will be created if the following is true:

·         The Social Security Number provided in Record 1 does not exist for the school identified by the School Code value in Record 1.

New Loan

A new loan will be created for the borrower if either of the following is true:

·         The Social Security Number provided in Record 1 does not exist for the school identified by the School Code value in Record 1

·         The FAO Loan Name provided in Record 1 does not match an existing loan for the borrower identified by the Social Security Number, School Code, and Campus Code values in Record 1.

Loan Update

The loan amount will be increased (i.e. the data will be treated as a subsequent disbursement) for an existing loan if the following is true:

·         There is a match on the FAO Loan Name, Social Security Number and School Code and Campus Code values from Record 1

The "Amount of Loan" value from Record 1 will be added to the Loan Amount of the matching Loan record.

Borrower Update

Existing borrower information will be updated if the following are true:

·         There is a match on Social Security Number and School Code from Record 1

·         Record 2, 3, 4 or 5 are provided.

·         If records 4 or 5 are provided, the address will be utilized as the new mailing address for the borrower.

Record Format

All fields are left justified unless specified otherwise.

Field Name

Length

Columns

 Value Req'd ?

Format/Comments

Record 1

 

 

 

Mandatory Record

Record Identifier

1

1-1

Y

Value = "1"< /P >

Social Security Number

9

2-10

Y

999999999

Filler

1

11-11

N

Leave blank.

FAO Loan Name

12

12-23

Y

Up to 12 alphanumeric characters.

This is one of the keys used to determine if this record represents a new loan or a subsequent disbursement for an existing loan.

Amount of Loan

9

24-32

Y

9 decimal characters with 2 characters to the right of the implied decimal point (positions 31 and 32 *); right justified. Ex: $2450.50 would be entered as 245050

School Code

6

33-38

Y

6 alphanumeric characters.

Campus

2

39-40

Y

2 alphanumeric characters.

Enrollment From Date

8

41-48

Y

The first day of the term for the current disbursement. Format is "CCYYMMDD".

Enrollment End Date

8

49-56

Y

The last day of the term for the current disbursement. Format is "CCYYMMDD".

Term

6

57-62

Y

Format is "CCYYMM".

Transaction Date

8

63-70

Y

Format is "CCYYMMDD".

Bursar Loan Number

12

71-82

 

 

SID Number

12

83-94

 

 

Promissory Note Number

6

95-100

 

6 alphanumeric characters.

Record Delimiter

1

101-101

Y

";" in position 101.

Record 2

 

 

 

Mandatory Record

Record Identifier

1

1-1

Y

Value = "2"< /P >

Social Security Number

9

2-10

Y

9 numeric characters.

Filler

1

11-11

Y

Leave blank.

Borrower Last Name

20

12-31

N

20 alphanumeric characters;

If present, then this value will be used to update the value currently in Borrower record.

Filler

1

32-32

Y

Leave blank.

Borrower First Name

20

33-52

N

20 alphanumeric characters;

If present, then this value will be used to update the value currently in Borrower record.

Borrower Middle Name

15

53-67

N

15 alphanumeric characters;

If present, then this value will be used to update the value currently in Borrower record.

Borrower Name Suffix

3

68-70

N

3 alphanumeric characters;

If present, then this value will be used to update the value currently in Borrower record.

Filler

2

71-72

N

Leave blank.

Transaction Date

8

73-80

Y

Format is "CCYYMMDD".

Record Delimiter

1

81-81

Y

Value = ";"

Record 3

 

 

 

 Optional

Record Identifier

1

1-1

Y

Value = "3"< /P >

Maiden Name

20

2-21

N

20 alphanumeric characters.

If present, then this value will be used to update the value currently in Borrower record.

Date of Birth

8

22-29

N

Format is "CCYYMMDD".

Driver's License Number

25

30-54

N

25 alphanumeric characters.

If present, then this value will be used to update the value currently in Borrower record.

Sex

1

55-55

N

Value must be "M" (male) or "F" (female).

Driver's License State

2

56-57

N

Any Valid 2 character State code

Estimated Graduation Date

8

58-65

N

CCYYMMDD

Filler

15

66-80

N

Leave blank.

Record Delimiter

1

81-81

Y

Value = ";" in position 81.

Record 4

 

 

 

Mandatory only if Record 3 is used.

Record Identifier

1

1-1

Y

Value = "4"< /P >

Address 1

30

2-31

N

If both Address 1 and Address 2 are omitted, then records 4 and 5 will be skipped during origination.

Address 2

30

32-61

N

If both Address 1 and Address 2 are omitted, then records 4 and 5 will be skipped during origination.

City

18

62-79

N

Value will be ignored if both Address 1 & 2 are omitted.

Filler

1

80-80

N

Leave blank.

Record Delimiter

1

81-81

Y

Value = ";" in position 81.

Record 5

 

 

 

Optional

Record Identifier

1

1-1

Y

Value = "5"< /P >

Country

30

2-31

N

30 alphanumeric characters.

State

2

32-33

N

2 alpha characters.

Zip Code

10

34-43

N

10 alphanumeric characters; Format is "nnnnn-nnnn".

Daytime Phone

10

44-53

N

10 numeric characters

Daytime Extension

4

54-57

N

4 numeric characters

Evening Phone

10

58-67

N

10 numeric characters

Evening Extension

4

68-71

N

4 numeric characters

Filler

9

72-80

N

Leave blank.

Record Delimiter

1

81-81

Y

Value = ";" in position 81.

Key: 9=unsigned numeric, bold field names are required

*The amount should be right justified in the provided positions.