Planning and Paying for College Banner
Google Logo
News Center Institution, Program and Degree Search Coordinating Board for Higher Education Publications Links & Resources
Planning and Paying for College Tab MDHE Central Tab Academic Affairs Tab
    Print Friendly

ATOM Promissory Note Feed

  1. Overview

  2. Layout/Mapping

II. Overview
In a processing flow, where the lender rather than the guarantor, maintains the promissory notes and the guarantor disburses, it is necessary for the lender to indicate to the guarantor's system that the promissory note has been received. The Promissory Note Verification File allows the lender to send a promissory note indicator to the guarantor. This file format was originally created by GuaranTec for the Missouri Department of Higher Education.

Layout/Mapping
PNV-1 Each Promissory Note Verification File will contain one header record, one or more detail records, and one trailer record, with the data positioned as shown in the following tables.

PNV-2 Each record in the Promissory Note Verification File will be followed by a carriage return character.

Table Column Definitions
Columns in the tables are defined as follows:

FieldThe ordinal number of the field.
NameThe name of the field.
PositionThe position of the first character in the field.
SizeThe size and data type of the field. An X indicates a single alphanumeric character, while a 9 indicates a single numeric character. A number enclosed in parentheses immediately following the symbol X or 9 specifies the number of consecutive occurrences of that symbol. For example, X(005), indicates an alphanumeric field with five characters. A V indicates the location of an assumed decimal point. The V is not counted in the size of the field. The number of 9s that follow the V indicates how many digits follow the assumed decimal point. Thus, 9(005)V99 indicates a numeric field with five digits plus an assumed decimal point followed by two digits.
Enterprise TableThe Enterprise table(s) that corresponds to the data in the file.
Enterprise ColumnThe Enterprise column(s) that corresponds to the data in the file.
MappingIndicates the expected constant value or list of values with their mapping to Enterprise valid values.

Unless otherwise noted, alphanumeric fields are left justified and padded with spaces and numeric fields are right justified and padded with zeros.

Header Record

FieldNamePositionsizeEnterprise TableEnterprise ColumnExpected Value
1Record Identifier1X(001) H
2File Identifier2X(005) PNOTE
3Source ID79(006)ORG_OrganizationOE_code
4Create Date
(MMDDCCYY)
139(008)  
5Filler21X(060)  

Detail Record

FieldNamePositionsizeEnterprise TableEnterprise
Column
Mapping or
Expected Value
1Record Identifier19(002)N/AN/A16
2Effective Date3X(006)N/AN/AN/A
3State9X(002)N/AN/AN/A
4Lender ID119(006)ORG_OrganizationOE_codeWhere organization_cd = LOA_Application.
Lender_cd
5SSN179(009)PER_PersonSSNWhere person_cd = LOA_Application.
Borrower_cd
6Insurance Number26X(010)N/AN/AN/A
7Lender Branch369(002)ORG_OrganizationBR_codeWhere organization_cd = LOA_Application.
Lender_cd
8Loan Type38X(001)LOA_Loan
or
LOA_SchoolCertRequest
Loan_Type_cd

Loan_Group_cd

G or U = Stafford
P = PLUS
9Insurance No. Flag39X(001)N/AN/AN/A
10Filler40X(012)N/AN/AN/A
11Prom Note Verification Flag52X(001)LOA_MasterPromissory
or
LOA_Application

Paper_Copy_Code

App_Copy_Code

Y = A
12Borrower Authorization Statement Flag53X(001)N/AN/AN/A
13LOAN ID54X(016)LOA_LoanLoan_cd(Must match Enterprise system. During normal app processing, the lender would
typically receive this in the Guarantor Use Only field of a CL4 Response File record.)
14Borrower Signature Date (MMDDCCYY)709(008)LOA_MasterPromissoryBorrower_Signature_Dt 
15Filler78X(003)N/AN/AN/A

Trailer Record

FieldNamePositionsizeEnterprise TableEnterprise ColumnExpected Value
1Record Identifier1X(001) T
2Detail Record Count29(010)
3Filler12X(069)  


     

about uscontact usemploymentprivacy policysite mapfaqsfeedback
state homepage mdhe outlook mail

planning and paying for collegemdhe centralacademic affairs
news centerinstitution, program and degree searchcoordinating boardpublication order formlinks/resources


Missouri Department of Higher Education, 3515 Amazonas Dr., Jefferson City, MO 65109-5717
Phone: 573-751-2361 Fax: 573-751-6635 Information Center: (800) 473-6757
This site and all its contents copyright © 2007, Missouri Department of Higher Education