|
PublicationDate: 5/1/2000 BulletinID: DLB - 00 - 28
May 2000
DLB 00-28
Subject: Status of the 1999-2000 732 Reports
Dear Partner:
This bulletin notifies you of the status of the 1999-2000 732 reports. You should expect to receive the 732-LOS from the Loan Origination Center (LOC) in your TIV WAN mailbox no later than Tuesday, May 16, 2000.
As in past program years, the 732-LOS will be sent as two text files: a Summary file and a Detail file at the loan level (not disbursement level). The message class for the 732-LOS Summary file is ED1300OP. The message class for the 732-LOS Detail file is ED1200OP. If you need assistance importing these message classes and/or assistance in preparing a report from these files, please contact your LOC Customer Service Representative at 1/800/848-0978, or your regional Direct Loan Client Account Manager.
The file layouts for the 732-LOS Summary and Detail files are attached to this bulletin. The report will be run and provided to you on a monthly basis.
You should reconcile the 732-LOS loan and cash data to your schoolÂ’s internal records. Loan data is provided at the loan level in order to reduce the size of the file and to make the comparison process easier for schools. If, in comparing at the loan level, you find discrepancies with total loan amounts, contact your LOC Customer Service Representative at 1/800/848-0978 for detailed disbursement information.
Thank you for your ongoing partnership in the Direct Loan Program.
Sincerely,
Margaret E. White Acting Lead, Title IV Delivery Schools Channel
File Layouts
Drawdowns
Field NoPositionLengthTypeField nameDescription | 11-11CharDelimiterA character used as delimiter (,) | 22-1110DateProcess datemm/dd/ccyy The date when ran on LOC | 312-121CharDelimiterA character used as delimiter (,) | 413-131CharRecord TypeR=Cash Receipts | 514-141CharDelimiterA character used as delimiter (,) | 615-2410DateGAPS Datemm/dd/ccyy GAPS Date for Drawdown | 725-251TypeDelimiterA character used as delimiter (,) | 826-3611NumAmount-9999999999 to 09999999999 Normally Positive for Drawdowns | 937-371CharDelimiterA character used as delimiter (,) | 1038-4710DateLOC posting datemm/dd/ccyy Date on which the transaction was received | 1148-481CharDelimiterA character used as delimiter (,) | 1249-6113CharGAPS Control NumberGAPS Control Number received from GAPS. | 1362-621CharDelimiterA character used as delimiter (,) | 1463-7715CharCheck NumberWill be blank for drawdowns | 1578-781CharDelimiterA character used as delimiter (,) |
Excess Cash
Field NoPositionLengthTypeField nameDescription | 11-11CharDelimiterA character used as delimiter (,) | 22-1110DateProcess datemm/dd/ccyy The date when ran on LOC | 312-121CharDelimiterA character used as delimiter (,) | 413-131CharRecord TypeX=Excess Cash | 514-141CharDelimiterA character used as delimiter (,) | 615-2410DateApplied Datemm/dd/ccyy Applied Date for Excess Cash | 725-251TypeDelimiterA character used as delimiter (,) | 826-3611NumAmount-9999999999 to 09999999999 Normally Negative for Excess Cash | 937-371CharDelimiterA character used as delimiter (,) | 1038-4710DateLOC posting datemm/dd/ccyy Date on which the transaction was received | 1148-481CharDelimiterA character used as delimiter (,) | 1249-6113CharGAPS Control NumberWill be blank for Excess Cash. | 1362-621CharDelimiterA character used as delimiter (,) | 1463-7715CharCheck NumberCheck Number of the Excess Cash Record. Blank when not available. | 1578-781CharDelimiterA character used as delimiter (,) |
Loan Detail
Field NoPositionLengthTypeField nameDescription | 11-11CharDelimiterA character used as delimiter (,) | 22-1110DateProcess datemm/dd/ccyy The date when rc72 ran on LOC | 312-121CharDelimiterA character used as delimiter (,) | 413-131CharRecord TypeB=Booked Loan/ Loan Detail U=Unbooked Loan/ Loan Detail | 514-141CharDelimiterA character used as delimiter (,) | 615-3521CharLoan IdentifierPreassigned Loan Identifier | 736-361TypeDelimiterA character used as delimiter (,) | 837-371CharDisbursement numberBlank | 938-381CharDelimiterA character used as delimiter (,) | 1039-391CharAction TakenBlank | 1140-401CharDelimiterA character used as delimiter (,) | 1241-422CharSequence NumberBlank | 1343-431CharDelimiterA character used as delimiter (,) | 1444-5310DateSchool Disbursement DateBlank | 1554-541CharDelimiterA character used as delimiter (,) | 1655-617NumGross Amount-999999 to 0999999 Normally positive Total Gross Amount of Loan | 1762-621CharDelimiterA character used as delimiter (,) | 1863-697NumFee Amount-999999 to 0999999 Normally positive Total Fee Amount of Loan | 1970-701TypeDelimiterA character used as delimiter (,) | 2071-777NumNet Amount-999999 to 0999999 Normally Positive Total Net Amount of Loan | 2178-781CharDelimiterA character used as delimiter (,) | 2279-857NumNet Adjustment AmountBlank | 2386-861CharDelimiterA character used as delimiter (,) Note: An upward adjustment increases the amount disbursed. |
A downward adjustment decreases the amount disbursed.
Cash Summary Record (for schools as well as Department)
Field NoPositionLengthTypeField nameDescription | 11-11CharDelimiterA character used as delimiter (,) | 22-1110DateProcess datemm/dd/ccyy The date when rc762 ran on LOC | 312-121CharDelimiterA character used as delimiter (,) | 413-142CharRecord TypeT1=Cash summary | 515-151CharDelimiterA character used as delimiter (,) | 616-161CharSchool Code TypeThe school code type | 717-21CharSchool No5-digit school number | 822-221CharDelimiterA character used as delimiter (,) | 923-242CharRegion Code2-digit region code of the school. | 1025-251CharDelimiterA character used as delimiter (,) | 1126-3813NumBeginning Balance-999999999999 to 0999999999999 | 1239-391TypeDelimiterA character used as delimiter (,) | 1340-5415NumTotal Cash Receipt-99999999999.99 to 099999999999.99 Normally Positive | 1455-551CharDelimiterA character used as delimiter (,) | 1556-7015NumTotal Returns of Excess Cash-99999999999.99 to 099999999999.99 Normally negative | 1671-711CharDelimiterA character used as delimiter (,) | 1772-8615NumCash on Hand-99999999999.99 to 099999999999.99 | 1887-871TypeDelimiterA character used as delimiter (,) | 1988-10215NumTotal Actual Disbursements-99999999999.99 to 099999999999.99 Normally positive | 20103-1031CharDelimiterA character used as delimiter (,) | 21104-11815NumTotal Canceled disbursements-99999999999.99 to 099999999999.99 Normally positive | 22119-1191CharDelimiterA character used as delimiter (,) | 23120-13415NumTotal Adjusted Disbursements-99999999999.99 to 099999999999.99 Positive for upward adjustments and negative for downward adjustments | 24135-1351TypeDelimiterA character used as delimiter (,) | 25136-15015NumNet Loan Detail-99999999999.99 to 099999999999.99 | 26151-1511CharDelimiterA character used as delimiter (,) | 27152-16615NumEnding Cash Balance-99999999999.99 to 099999999999.99 | 28167-1671CharDelimiterA character used as delimiter (,) | 29168-18215NumNet Unbooked-99999999999.99 to 099999999999.99 | 30183-1831CharDelimiterA character used as delimiter (,) | 31184-19815NumAdjust Ending Cash Balance-99999999999.99 to 099999999999.99 | 32199-1991CharDelimiterA character used as delimiter (,) | 33200-21718CharShort NameShort name of school | 34218-2181CharDelimiterA character used as delimiter (,) |
|
|