Starting Position
Ending Position
N/A*
Requested Data Field
FDIC Field #
GOLDPoint Systems Mnemonics

1

45

 

Borrower Name

4

MNLAST, MNFRST, MNMIDD

46

68

 

Borrower Short Name

5

MNLAST, MNFRST, MNMIDD

69

78

 

Loan Number

**

LN4NBR

 

 

X

Borrower ID Number

2

 

 

 

X

CIF Number

9

 

79

89

 

Social Security Number

19

MNSS#

79

89

 

Tax ID Number

20

MNSS#

90

104

 

Current Balance

28

LNPBAL

105

112

 

Original Date

55

LNOPND

113

114

 

Borrower State

6

MNSTAT

115

134

 

Borrower  City

1

MNCITY

135

179

 

Borrower Street Address

7

MNADD1

180

184

 

Borrower ZIP

8

MNZIPC

185

199

 

Borrower Income

3

NDSALR * 1000

200

259

 

Group ID or Relationship Number (10 fields–length of 6 each)

11

MALNAM

260

409

 

Group or Relationship Name (10 fields–length of 15 each)

12

MAFNAM,MAMNAM

410

529

 

Co_Maker/Joint Maker (8 fields–length of 15 each)

26

NDLNAM, NDFNAM, NDMNAM

530

537

 

Insider

13

Hold Code 69="officer" &
Hold Code 70 = "employee"

538

541

 

SIC Code

18

Zeroes

542

545

 

Branch ID

23

LN4NBR (first 4 digits)

546

549

 

Loan Officer

16

LNOFCR

550

551

 

Loan Type

47

LNTYPE

552

555

 

Purpose of Loan

59

LNAPCD

556

556

 

Loan to Facilitate (Y/N)

**

LNGENL = 30 = "Y"

557

557

 

Revolving Line of Credit (Y/N)

60

LNGENL = 7 = "Y"

558

572

 

Accrued Interest

21

Calculated like Accrued Interest on the Loan Classification and Payment Fields screen (function 1/2).

573

586

 

Amortizing/Non_amortizing status

22

If LNPMTH = 0, then "Amortizing";
If LNPMTH = 7 and
LNDEOM = "Y" or LNDFIM = "Y", then "Negative Amortizing",
else "Amortizing";
All other payment methods = blank.

587

590

 

Dealer Code

30

If LNRLLI = "Y", then use LNIMST

591

595

 

Guarantor/Endorser Code

34

LNPMIC (PMI Code on the Loan Miscellaneous Fields screen (function 9/10))

596

610

 

Total Commitment

68

LNPBAL or LNAMMX or LNRLCL

611

625

 

Unfunded/Undisbursed Balance

70

LNLBAL for LIP; calculated for PM5: (Revolving) LNRLCL - LNPBAL
(Non-Revolving) LNRLCL-LNRLCU

626

640

 

Escrow Balance

32

LNR1BL + LNR2BL

641

648

 

Maturity Date

46

LNMATD

649

651

 

Number of Payments

52

LNTERM / LNFREQ

652

666

 

Original Balance

54

LNOBAL

667

681

 

Payment Amount

56

Calculated like Next Payment Due on the Loan Classification and Payment Fields screen (function 1/2).

682

683

 

Payment Frequency

57

LNFREQ

684

691

 

Interest Rate

36

LNRATE, LNAMRT, or LNLRAT

692

693

 

Variable Rate Code

71

LNAMOR

694

701

 

Interest Paid to Date

37

LNPDTO

702

709

 

Periodic Interest Rate Cap

58

LNAMRU

710

712

 

Index

35

LNRPTR

713

715

 

Interest Rate Reset Interval

38

LNAMFQ

716

723

 

Lifetime Interest Rate Cap

45

LNAMHI

724

727

 

Collateral Code

73

LNCOLL

728

742

 

Collateral Value

75

LNAPAM

743

750

 

Collateral Valuation/Appraisal Date

76

LNAPRS

751

752

 

Insurance Code/Flag

77

RDTYPES 20-26, 28

753

760

 

Insurance Expiration Date

78

RDSEXP

761

768

 

Security Perfection Date

61

Action date of action code 45

769

776

 

Last Financial Statement Date

15

Action date of action code 61

777

784

 

Loan to Value Ratio

**

Calculated like curr ltv on the Loan Miscellaneous Fields screen (function 9/10)

785

787

 

Lien Status

79

LNGENL1 = 1st
or LNGENL2 = 2nd

788

802

 

Prior Lien Balance

81

LNBAL2

803

804

 

County Code

10

MNCCOD

805

810

 

MSA Code

80

LTMSAC

811

816

 

Block Numbering Area or Census Tract

72

LTCENS

817

819

X

CRA Code

27

Zeroes

820

823

 

Internal Rating

39

LNRSK1 (1st risk score on the Additional Miscellaneous Fields screen (function 45/46))

824

831

 

Last Payment Date

41

LNDTLP

832

843

 

Charged-Off Amount

25

LNCOBL

844

851

 

Last Renewal Date

42

LNRSDT (date restructured on the Loan Miscellaneous Fields screen (function 9/10))

852

866

 

Late Charges

43

LNLATE

867

869

 

Number of Days Past Due

29

Calculated as
TODAY - LNDUDT

870

877

 

Next Payment Date

48

LNDUDT

878

889

 

Specific Valuation Allowance

**

LNVALL

890

892

 

Times Past Due 30_59 Days

65

LNLT30

893

895

 

Times Past Due 60_89 Days

66

LNLT60

896

898

 

Times Past Due 90+ Days

67

LNLT90

899

899

 

Troubled Debt Restructured Code

69

LNTRBL=Y on function 9/10

900

914

 

Current REO Balance

**

If LNGENL = 85, then
LNPBAL

915

915

 

Firm Commitment to Sell

33

LNPLDG = Y

916

919

 

Participating Institution Code

82

LNIMST

920

934

 

Participation Amount

83

Calculated: BALANCE * % SOLD (LNISLD)

935

949

 

Participation Sold Original Amount

85

LNSLBL

950

957

 

Interest Rate on Participation

**

LNIGRT

958

969

 

Premium

**

LNPREM

970

981

 

Discount

**

LNDREM

982

982

 

Nonaccrual

49

LNACST = 1

983

990

 

Offset Margin

 

LNROFF

 

 

X

Last Corporate/Borrower Resolution

14

 

 

 

X

Out_of_Territory/Country Code

17

 

 

 

X

Capitalized Interest

24

 

 

 

X

Dealer Reserve Balance

31

 

 

 

X

Internal Rating Date

40

 

 

 

X

Lending Division

44

 

 

 

X

Note/Credit Facility Number

50

 

 

 

X

Note/Credit Facility Type

51

 

 

 

X

Number of Renewals/Extensions

53

 

 

 

X

Shared National Credit Indicator

62

 

 

 

X

Source of Repayment

63

 

 

 

X

Specific Reserve

64

 

 

 

X

Collateral Description

74

 

 

 

X

Participation Code

84

 

*Fields with an "X" in the N/A column are not available in the GOLDPoint Systems system.

**These fields are not requested by FDIC.