LN_DL_CASH_DTL(SQL Table) |
Index Back |
|---|---|
Direct Loan Cash DetailStores Direct Loan Cash Detail Information. Used by DL Reconciliation. |
| # | 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 | DL_SCHOOL_CD |
Character(6) | VARCHAR2(6) NOT NULL | School Code |
| 4 | DL_TRANS_DATE_0 |
Date(10) | DATE NOT NULL | Transaction Date |
| 5 | DL_TRANS_TYPE_CASH |
Character(1) | VARCHAR2(1) NOT NULL |
Transaction Type - Cash
R=Cash Receipt X=Return of Excess Cash |
| 6 | DL_CHECK_NUMBER |
Character(12) | VARCHAR2(12) NOT NULL | Check Number |
| 7 | DL_TRANS_AMOUNT_0 |
Signed Number(12,0) | DECIMAL(11) NOT NULL | Transaction Amount |
| 8 | DL_GAPS_CNTRL_NBR |
Character(13) | VARCHAR2(13) NOT NULL | GAPS Control Number |
| 9 | DL_GAPS_TRACK_NBR | Character(13) | VARCHAR2(13) NOT NULL | GAPS Tracking Number |