Field #

Field Name

Details

Mnemonic

Type

Width

Format

Position

Borrower ID

The social security number of the account owner.

MNSSN#

A/N

34

1-34

02

Short Name

IRS owner’s last name with first and middle initials.

MNLAST,
MNFRST,
MNMIDD

A/N

30

35-64

03

Long Name

IRS owner’s last name, first name, and middle name.

MNLAST,
MNFRST,
MNMIDD

A/N

40

65-104

04

Address Line 1

First address line.

MNADD1

A/N

40

105-144

05

Address Line 2

Second address line.

MNADD2

A/N

40

145-184

06

Address Line 3

Not Available.

A/N

40

185-224

07

City

City.

MNCITY

A/N

40

225-264

08

State

State.

MNSTAT

A/N

2

265-266

09

ZIP Code

ZIP code.

MNZIPC

A/N

9

267-275

10

Taxpayer ID

The social security number of the account owner.

MNSSN#

A/N

9

276-284

11

Business Type

The NAICS code (commercial loans only).

MLSIC3

A/N

6

285-290

12

Relationship Name

Not available.

A/N

40

291-330

13

Relationship ID

Not available.

A/N

34

331-364

14

Credit Score

Credit score or risk field 1.

LNRSK1

N

3

###

365-367

15

Stock Symbol

Not available.

A/N

8

368-375

16

Out-of-Territory

Not available.

Logic

1

Y/N

376-376

17

Insiders and Employees

Hold code 69 = officer.
Hold code 70 = employee.

LNHLD1
LNHLD2

A/N

1

O, E, or blank

377-377

18

Lending Division

Not available.

A/N

10

378-387

19

Lending Officer

Loan officer number.

LNOFCR

A/N

20

388-407

20

Branch ID

Loan office.

LN4NBR

A/N

10

408-417

21

Note Number

Loan account number and office.

LN4NBR

A/N

34

418-451

22

Balance Outstanding

Loan principal balance (for LIP loans: LNPBAL - LNLBAL).

LNPBAL
LNLBAL

N

15

#(12).##

452-466

23

Undisbursed Commitment Availability

For LIP loans (LNLBAL).
For line-of-credit (payment method 5, 9, or 10) loans: revolving (LNRLCL - LNPBAL), non-revolving (LNRLCL-LNRLCU).

LNLBAL
LNPBAL
LNRLCL
LNRLCU

N

15

#(12).##

467-481

24

Original Amount

Original loan amount.

LNOBAL

N

15

#(12).##

482-496

25

Origination Date

Date Opened.

LNOPND

D

8

YYYYMMDD

497-504

26

Last Renewal Date

LNMATD on non-commercial loans.
REFILD on commercial loans.

LNMATD
REFILD

D

8

YYYYMMDD

505-512

27

Maturity Date

Loan maturity date.

LNMATD

D

8

YYYYMMDD

513-520

28

Last Extension Date

Commercial loans only.

EXFILD

D

8

YYYYMMDD

521-528

29

Number of Renewals

Commercial loans only.

MLRNWD

N

3

###

529-531

30

Number of Extensions

Commercial loans only.

MLEXTD

N

3

###

532-534

31

Note Purpose

Loan collateral code.

LNCOLL

A/N

40

535-574

32

Collateral Code

Loan collateral code.

LNCOLL

A/N

10

575-584

33

Interest Rate

LNAMRT on all payment method 7 and rate-sensitive payment method 6 loans.
LNLRAT on LIP loans.
LNRATE on all other loans.

LNRATE
LNAMRT
LNLRAT

N

7

.#######

585-591

34

Interest Rate Index

The rate index pointer is LNAMPT on all payment method 7 and rate-sensitive payment method 6 loans.
LNLPTR on LIP loans.
LNRPTR on all other loans.

LNRPTR
LNAMPT
LNLPTR

A/N

20

592-611

35

Interest Rate Spread

Interest rate offset/margin.
LNAMOF on all payment method 7 and rate-sensitive payment method 6 loans. LNLOFF on LIP loans. LNROFF on all other loans.

LNAMOF
LNROFF
LNLOFF

N

7

#.######

612-618

36

Interest Earned Not Collected

Accrued interest. For payment method 5 loans that are not LIP loans, add in prior finance charge and current finance charge.

LNRLPC
LNRLCC

N

15

#(12).##

619-633

37

Borrower’s Internal Rating

Credit score or risk field 1.

LNRSK1

A/N

5

634-638

38

Borrower’s Rating Date

Not available.

D

8

YYYYMMDD

639-646

39

Note Risk Rating

Credit score or risk field 1.

A/N

20

647-666

40

Note Balance Rated Pass

Not available.

N

15

#(12).##

667-681

41

Note Balance Rated Special Mention

Same as Balance Outstanding (field 22) on loans with a "2" in the classification.

LNACLS

N

15

#(12).##

682-696

42

Note Balance Rated Substandard

Same as Balance Outstanding (field 22) on loans with a "3" in the classification.

LNACLS

N

15

#(12).##

697-711

43

Note Balance Rated Doubtful

Same as Balance Outstanding (field 22) on loans with a "4" in the classification.

LNACLS

N

15

#(12).##

712-726

44

Charge Off Amount

Partial charge-off amount.

LNCOBL

N

15

#(12).##

727-741

45

Specific Reserve

Valuation reserve.

LNVALL

N

15

#(12).##

742-756

46

Shared National Credit

Not available.

Logic

1

Y/N

757-757

47

Guarantor

Private Mortgage Insurer Code.

LNPMIC

A/N

40

758-797

48

Days Past Due

Days different between run date and LNDUDT.

LNDUDT

N

5

#####

798-802

49

Interest Paid-to-Date

Date interest is paid to.

LNPDTO

D

8

YYYYMMDD

803-810

50

Nonaccrual

Non-Accrual field (Y/N).

LNACST

Logic

1

Y/N

811-811

51

Times Past Due 30-59

LNLT30

N

3

###

812-814

52

Times Past Due 60-89

LNLT60

N

3

###

815-817

53

Times Past Due 90+

LNLT90

N

3

###

818-820

54

Type

Loan type and description, pulled from the Loan Type Descriptions screen (function 43, then 31/32).

LYDESC

A/N

20

821-840

55

FFIEC Code

The report line number on FPSRP115, Section RC-C.

A/N

10

841-850

56

Participation Indicator

For loans with an investor master number, sold.
For loans that originated outside this bank, purchased.
Else, this field is blank.

LNORGN
LNIMST

A/N

1

P, S, or Blank

851-851

57

Amount Sold

Balance Outstanding (field 22) * percent sold.

LNISLD

N

15

#(12).##

852-866

58

Participation Sold Original Amount

Sold balance.

LNSLBL

N

15

#(12).##

867-881

59

Collateral Description

LNCLDS

A/N

50

882-931

60

Loan For Sale

Loan pledged.

LNPLDG

Logic

1

Y/N

932-932

61

Next Due Date

LNDUDT

D

8

YYYYMMDD

933-940

62

Payment Frequency

LNFREQ

A/N

10

941-950

63

Variable Rate

Yes on amortization codes 2, 3, 5, 12, and 15. No on all others.

LNAMOR

Logic

1

Y/N

951-951

64

Periodic Interest Rate Cap

Maximum points/period upward (on all payment method 7 and rate-sensitive payment method 6 loans).

LNAMRU

N

7

.#######

952-958

65

Interest Rate Reset Interval

Rate change frequency * 30 on all payment method 7 and rate-sensitive payment method 6 loans.

LNAMFQ

N

4

####

959-962

66

Lifetime Interest Rate Cap

Lifetime maximum rate.

LNAMHI

N

7

.#######

963-969

67

Troubled Debt Restructured

LNTRBL

Logic

1

Y/N

970-970

68

Amortizing/
Non-Amortizing Status

Yes on payment method 7 and 0.
Blank on all others.

LNPMTH

Logic

1

Y/N

971-971

69

Payment Amount

Calculated.

Calculated

N

15

#(12).##

972-986

70

Last Payment

Date of last payment.

LNDTLP

D

8

YYYYMMDD

987-994

71

Capitalized Interest

Not available.

N

15

#(12).##

995-1009

72

Number of Payments In Contract

For all loans except frequency 26:
LNTERM / LNFREQ.
For frequency 26:
LNTERM X LNFREQ / 12

N

3

###

1010-1012

73

Collateral Value

Appraisal amount.

LNAPAM

N

15

#(12).##

1013-1027

74

Collateral Valuation/
Appraisal Date

Appraisal date.

LNAPRS

D

8

YYYYMMDD

1028-1035

75

Lien Status

A/N

20

1036-1055

76

Block Numbering Area of Census Tract

A/N

6

1056-1061

77

MSA Code

A/N

6

1062-1067

78

Dealer Code

Investor master number on all sub-limit loans.

LNIMST

A/N

20

1068-1087

79

Dealer Reserve Balance

N

15

#(12).##

1088-1102

80

Escrow Balance

If option LNSKR2 is set, reserve balance 2 will be skipped.

LNR1BL
LNR2BL

N

15

#(12).##

1103-1117

81

Co-maker/ Joint-maker

A/N

40

1118-1157

82

Late Charges

Amount of unpaid charges.

LNLATE

N

15

#(12).##

1158-1172

83

Loan Grade

The grade of the loan

M1LGRD

DC

2

1173-1174

84

Loan Grade Date 1

Date of loan grade

M1GRD1

DC

8

1175-1182

85

Loan Grade 2

The grade of the loan

M1LGR2

DC

2

1183-1184

86

Loan Grade Date 2

Date of loan grade

M1GRD2

DC

8

1185-1192

87

Loan Grade 3

The grade of the loan

M1LGR3

DC

2

1193-1194

88

Loan Grade Date 3

Date of loan grade

M1GRD3

DC

8

1195-1202

89

Non-accrual Book Balance

Non-accrual book balance

LNNABB

CL

13

1203-1215

90

Carriage Return and Line Feed

Carriage return and line feed

REGRCED

DS

2

1216-1217