Help: Agency Data Layout

ECSI provides the data most useful to an agency in an electronic format suitable for importing into their own application or database. This "raw data" can be found in the Agency.exe file available on your agency's page. Below is a description of the data elements, their type and size.

ECSI Agency Layout Description

Field NameSizeDescription
SCHL-NOX(02)Unique school number assigned by ECSI
AGENCY-COX(02)Collector Code defined by ECSI
SCHL-CAMPUSX(02)ID number of the campus owning the loan
BOR-ACT-NOX(09)Borrowers Social Security Number
BOR-SIDX(09)Student Identification Number
BOR-FUND-TYPEX(06)Type of Loan
LN-DISCX(20)Description of loan type
BOR-LASTX(20)Borrower Last Name
BOR-FIRSTX(12)Borrower First Name
BOR-MIDDLEX(01)Borrower Middle initial
BOR-MAIDENX(20)Borrower Maiden Name
BOR-ADD1X(30)Borrower address line 1
BOR-ADD2X(30)Borrower address line 2
BOR-CITYX(15)Borrower city
BOR-STATEX(02)Borrower state
BOR-ZIPX(09)Borrower zip code
BOR-ADD-STATUSX(02)Status of the address (Good, Bad, etc.)
BOR-PHONEX(10)Borrower phone number
BOR-PHONE-STATUSX(01)Status of the phone # (Good, Bad, etc.)
BOR-BIRTH-DATE9(08)Borrower birth date
CO-NAMEX(33)Cosigner Name
CO-ADD1X(23)Cosigner address line 1
CO-ADD2X(23)Cosigner address line2
CO-CITYX(15)Cosigner city
CO-STATEX(02)Cosigner state
CO-ZIPX(09)Cosigner zip code
CO-ADD-STATUSX(02)Cosigner address status
CO-PHONEX(10)Cosigner phone #
CO-PHONE-STATUSX(01)Cosigner phone status
CO-SS-NOX(09)Cosigner Social Security Number
LN-AMTS9(05)v99Amount of all disbursements to this loan (total loan amt)
PR-PDS9(05)v99Principal paid
PR-CANCS9(05)v99Principal canceled
LN-BALS9(05)v99Balance of loan
LN-PAYOFFS9(05)v99Payoff of loan
TOT-DUES9(05)v99Total amt due
PAY-AMTS9(05)v99Fixed payment amount
FREQUENCYX(01)Frequency of payment (Monthly, Quarterly, Annual, Semi-Annual)
INT-RATEV9(05)Interest Rate of the loan
AG-PRIN-DUES9(05)v99Amount of principal due
AG-INT-DUES9(05)v99Amount of interest due
AG-PEN-LATE-DUES9(05)v99Amount of penalty/late fees due
AG-COLL-DUES9(05)v99Amount of collection fees due
AG-LEGAL-DUES9(05)v99Amount of legal fees due
AG-NSF-DUES9(05)v99Amount of NSF fees due
AG-LETTER-DUES9(05)v99Amount of letter fees due
AG-CREDIT-B-DUES9(05)v99Amount of credit-bureau fees due
AG-OTHER-1-DUES9(05)v99Amount of other-1 fees due (Miscellaneous fees)
AG-OTHER-2-DUES9(05)v99Amount of other-2 fees due (Miscellaneous fees)
INHOUSE-DUES9(05)v99Amount of in-house collection fees due
AG-COMMIS-RATE9(03)v999Percentage rate agency charges borrower
FEE-ON-FEEX(01)If field = "Y" the Ag-Commis-Rate is computed based on Fee-on-Fee routine
AG-FUND-CAPEDX(01)If field = "Y" the fund has a maximum commission rate limitation
AG-MAX-RATEV9(05)Maximum commission rate
AG-LAST-PAYMENTS9(05)v99Last payment amount
AG-LAST-PAYMENT-DATE9(08)Last payment date
SEPARATION-DATE9(08)Date borrower exited from the school
FIRST-PAY-DATE9(08)Date first payment was due
COHORT-YRX(09)Cohort year from to dates
MONTH-DEL9(03)Months Delinquent
LIC-STATEX(02)Driver's license state
LIC-NUMBER9(17)Driver's license number

Key:
X = alpha-numeric
9 = numeric
v = implied decimal point
Number in parenthesis is number of positions

Close Window