Every field within a Point file has an associated ID.  This ID is required when you export data from a file or generate report data.

How to load all Field IDs at once 

1. In Point, open a Prospect or Borrower file.
2. From the Menu bar, select Utilities > Load Field ID > Prospect or Utilities > Load Field ID > Borrower. 

Field IDs (numbers in each field) should appear. Screen navigation is the same as in regular Prospect and Borrower files. (Write down or print all the Field IDs that you need. You can then include them in a Report or Export template)

How to find Field IDs in Microsoft Excel

1. Open Microsoft Excel.
2. From the Menu bar, select File > Open.
3. From the Look In dropdown list, select My Computer > Local Disk C: > Winpoint.
4. Double-click the fieldid.xls file.
5. Search for keywords by going to the Menu bar and selecting Edit > Find.
6. Enter keywords for the field and click Find.

Miscellaneous Field IDs

The following miscellaneous Field IDs can be used in Point.

Note: The miscellaneous Field IDs for Company Name, Company Address, Company City, Company State, Company ZIP, Company Fax, and Company Phone do not work in reports.

Field Id	Name	Description
APR	Apr	Displays the APR for all files on the report
ATYPE	Amortization Type	Pulls from Page 1 of the Loan Application. The Amortization Types are Fixed, ARM, or GPM
CN	Conditions	Pulls lines of text that appear in Track > Conditions.
CNDFS	Condition - Status	Pulls from the right column of the Track > Conditions screen.
EQUIT	Equity	Pulls from Marketing > Prequalification.
FOLDER	Folder Name	Data folder name.
FS	First or Second	First or Second Lien Position from the Prospect or Borrower Information screen.
HBETH	Borrower Ethnicity	Pulls from the Government Monitoring Section on Page 4 of the Loan Application.
HBRACE	HMDA	Borrower's race.
HBSEX	HMDA	Borrower's sex.
HCBETH	Co-borrower Ethnicity	Pulls from the Government Monitoring Section on Page 4 of the Loan Application.
HCBRACES	HMDA	Co-borrower's race.
HCSEX2004	HMDA	Co-borrower's sex.
HHOEPA	Home Ownership and Equity Protection Act Status	Pulls from Track > HMDA Reporting.
HINC	HMDA Income	Based on amount shows on Page 2 of the Loan Application.
HLNA	HMDA Loan Amount	Loan Amount.
HOCC	HMDA Occupancy	Refers to the type of property from the Prospect or Borrower Information screen: Primary, Secondary, or Investment.
HPURCH	HMDA Purchase	Refers to the type of purchaser from Track > HMDA Reporting.
HPURP	HMDA Purpose	Purpose of loan: Purchase or Refinance
HREASON	HMDA Reason	Refers to the Reason for Denial from Track > HMDA Reporting.
HREASON2	HMDA Reason 2	Refers to the Reason for Denial from Track > HMDA Reporting.
HREASON3	HMDA Reason 3	Refers to the Reason for Denial from Track > HMDA Reporting
HSTAT	HMDA Status	Pulls from Track > HMDA Reporting.
HSTATE	HMDA State	State of property from Prospect or Borrower Information screen.
HTYPE	HMDA Type	Type (Conventional, FHA, VA)
LATEBAS	Late Basic Docs	Basic Documents from Track > General.
LATEMISC	Late Miscellaneous	Late entries from Track > Miscellaneous.
LATEVOD	Late VODs	Late Verifications of Deposit..
LATEVOE	Late VOEs	Late Verificiations of Employment.
LATEVOL	Late VOLs	Late Verifications of Loans
LATEVOM	Late VOMs	Late Verifications of Mortgage or Rent
NAME	Full Name	Borrowers first and last name: Last Name, First Name.
PDAY	Days Processed	The number of days the loan has been opened since the Opened date in Track > General.
PTYPE	Property Type	Pulls from the Transmittal Summary.
PURP	Purpose of loan	Pulls from Page 1 of the Loan Application: Purchase, Refinance, or Construction.
RES	Residency	Indicates Primary, Secondary, or Investment from the Prospect or Borrower Information screen.
SDATE	Status Date	Dates in the Status section of Track > General.
STAT	Status of loan	Reflects the current status of the loan from Track > General.
TRAMPT	Trust Report Amount Paid	Amount Paid from Track >Trust Account.
TRAMTR	Trust Report Amount Received	Amount received from Track > Trust Account.
TRBAL	Trust Report Balance	Report Balance
TRCHKP	Trust Report Check Number - Paid	Check number for paid item from Track > Trust Account.
TRCHKR	Trust Report Check Number - Received	Check number for received item from Track > Trust Account.
TRDATE	Trust Report Date	Date of item from Track > Trust Account.
TRDESC	Trust Report Description	Description of item from Track > Trust Account.
TRREM	Trust Report Remarks	Remarks for each item from Track > Trust Account.
TYPE	Loan Type	Pulls from Prospect or Borrower Information screen: Conventional, FHA, VA, or Other.