EMPLIDINSTITUTIONAID_YEARLOAN_TYPELN_APPL_SEQITEM_TYPEDISBURSEMENT_IDLN_DISB_RPT_VW(SQL View) |
Index Back |
|---|---|
LnDisb Vw - Loan Doc print SQRDisbursement View for Loan Document Printing |
| SELECT A.EMPLID, A.INSTITUTION, A.AID_YEAR, A.LOAN_TYPE, A.LN_APPL_SEQ, A.ITEM_TYPE, A.DISBURSEMENT_ID, A.LN_ANTIC_GROSS, A.LN_ANTIC_NET, A.LN_ANTIC_FEES, A.LOAN_DISB_DATE, A.LN_DISB_AMT, A.LN_DISB_AMT_NET, A.LN_FEE_AMT, A.PERCENT_OF_AWARD, B.LOAN_FEE_RT FROM PS_LOAN_DISBMNT A, PS_LN_TYPE_TBL B where A.AID_YEAR=B.AID_YEAR and A.LOAN_TYPE=B.LOAN_TYPE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL | Academic Institution |
| 3 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL | Aid Year |
| 4 | LOAN_TYPE |
Character(4) | VARCHAR2(4) NOT NULL | Loan Type Cd |
| 5 | LN_APPL_SEQ |
Number(2,0) | SMALLINT NOT NULL | Loan Application Seq Num |
| 6 | ITEM_TYPE |
Character(12) | VARCHAR2(12) NOT NULL | Item Type |
| 7 | DISBURSEMENT_ID |
Character(2) | VARCHAR2(2) NOT NULL | Disbursement ID |
| 8 | LN_ANTIC_GROSS | Number(12,2) | DECIMAL(11,2) NOT NULL | Anticipated Gross Disbursement |
| 9 | LN_ANTIC_NET | Number(12,2) | DECIMAL(11,2) NOT NULL | Anticipated Net Disbursement |
| 10 | LN_ANTIC_FEES | Number(12,2) | DECIMAL(11,2) NOT NULL | Anticipated Disbursement Fees |
| 11 | LOAN_DISB_DATE | Date(10) | DATE | Loan Request Dt |
| 12 | LN_DISB_AMT | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Loan Disbursement Amt |
| 13 | LN_DISB_AMT_NET | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Net Loan Disbursement |
| 14 | LN_FEE_AMT | Number(7,2) | DECIMAL(6,2) NOT NULL | Loan Fee Amount |
| 15 | PERCENT_OF_AWARD | Number(6,2) | DECIMAL(5,2) NOT NULL | Percent of Award |
| 16 | LOAN_FEE_RT | Number(6,3) | DECIMAL(5,3) NOT NULL | Loan Fee Rate |