LOAN_CASH_SUM(SQL Table) |
Index Back |
|---|---|
Loan Cash SummaryMaintains Cash and Disbursement Summary Data, by Reconciliation Period, used to reconcile Direct Loan with the Servicer. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
| 2 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: AID_YEAR_TBL |
| 3 | RECON_SEQ_NBR |
Number(3,0) | SMALLINT NOT NULL | Reconciliation Sequence Nbr |
| 4 | RECON_BATCH_ID | Character(23) | VARCHAR2(23) NOT NULL | Recon Batch ID |
| 5 | RECON_BATCH_DT | Date(10) | DATE | Recon Batch Date |
| 6 | RECON_STATUS_OVRAL | Character(1) | VARCHAR2(1) NOT NULL |
Overall Reconciliation Status
A=Accepted R=Rejected |
| 7 | RECON_END_DT | Date(10) | DATE | Reconciliation End Date |
| 8 | RECON_START_DT | Date(10) | DATE | Reconciliation Start Dt |
| 9 | UNREC_TOT_PRIOR | Character(11) | VARCHAR2(11) NOT NULL | Prior Month Unrecncld Total |
| 10 | NET_UNBKD_TRANS | Number(11,0) | DECIMAL(11) NOT NULL | Net Unbooked Txns |
| 11 | END_BALANCE | Number(14,2) | DECIMAL(13,2) NOT NULL | Ending Balance |
| 12 | END_BALANCE_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Ending Cash Balance Status
Prompt Table: LN_RECNCD_VW |
| 13 | END_BALANCE_SVCR | Signed Number(12,0) | DECIMAL(11) NOT NULL | Servicer Ending Cash Balance |
| 14 | TOT_CASH_RCPTS | Number(11,0) | DECIMAL(11) NOT NULL | Total Cash Receipts |
| 15 | TOT_CASH_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Total Cash Receipts Status
Prompt Table: LN_RECNCD_VW |
| 16 | TOT_CASH_SVCR | Character(11) | VARCHAR2(11) NOT NULL | Svcr Total Cash Receipts |
| 17 | TOT_ACT_DISB | Number(11,0) | DECIMAL(11) NOT NULL | Total Actual Disbursements |
| 18 | TOT_ACT_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Total Actual Disbmnt Status
Prompt Table: LN_RECNCD_VW |
| 19 | TOT_ACT_SVCR | Character(11) | VARCHAR2(11) NOT NULL | Svcr Total Actual Dsbsmnts |
| 20 | TOT_CAN_DISB | Number(11,0) | DECIMAL(11) NOT NULL | Total Cancelled Dsbsmnts |
| 21 | TOT_CAN_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Total Cancel Dsbsmnts Status
Prompt Table: LN_RECNCD_VW |
| 22 | TOT_CAN_SVCR | Character(11) | VARCHAR2(11) NOT NULL | Svcr Total Cancelled Disb |
| 23 | TOT_ADJ_DISB | Number(11,0) | DECIMAL(11) NOT NULL | Total Adjusted Dsbsmnts |
| 24 | TOT_ADJ_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Total Adjstd Dsbsmnts Status
Prompt Table: LN_RECNCD_VW |
| 25 | TOT_ADJ_SVCR | Character(11) | VARCHAR2(11) NOT NULL | Svcr Total Adjstd Dsbsmnts |
| 26 | TOT_RET_CASH | Number(11,0) | DECIMAL(11) NOT NULL | Total Returned Cash |
| 27 | TOT_RET_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Total Return Cash Status
Prompt Table: LN_RECNCD_VW |
| 28 | TOT_RET_SVCR | Character(11) | VARCHAR2(11) NOT NULL | Svcr Total Return Cash |
| 29 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: INSTALLATION.EXCHNG_TO_CURRENCY Prompt Table: CURRENCY_CD_TBL |