LN_DISB_ACT_VW(SQL View) |
Index Back |
---|---|
Loan Disbursement Detail VwTracks, maintains and updates the Loan Disbursement Actions for a given Loan Application/Promissory Note. Disbursement Actions are generally exchanged between the School and external processing entities. |
SELECT a.emplid , a.institution , a.aid_year , a.acad_career , a.ln_appl_seq , a.loan_type , a.item_type , a.disbursement_id , a.ln_disb_seq_nbr , b.ln_disb_amt , a.ln_action_cd , a.ln_action_type , c.descr , a.trnsfr_batch , a.ln_action_dt , a.ln_disbactn_amt , a.ln_disbactn_net , a.ln_action_status , a.sfa_cr_document_id FROM PS_LOAN_DISB_ACTN a , ps_loan_disbmnt b , ps_ln_actncd_tbl c , ps_ln_type_tbl d WHERE a.emplid = b.emplid AND a.institution = b.institution AND a.aid_year = b.aid_year AND a.ln_appl_seq = b.ln_appl_seq AND a.loan_type = b.loan_type AND a.item_type = b.item_type AND a.aid_year = c.aid_year AND a.disbursement_id = b.disbursement_id AND a.ln_action_type = c.ln_action_type AND a.ln_action_cd = c.ln_action_cd AND c.loan_program = d.loan_program AND a.institution = d.institution AND a.aid_year = d.aid_year AND a.loan_type = d.loan_type |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PEOPLE_SRCH |
2 | INSTITUTION | Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Default Value: OPR_DEF_TBL_CS.INSTITUTION Prompt Table: INSTITUTION_TBL |
3 | AID_YEAR | Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Default Value: OPR_DEF_TBL_CS.AID_YEAR Prompt Table: STUDENT_AID |
4 | ACAD_CAREER | Character(4) | VARCHAR2(4) NOT NULL |
Academic Career
BAC=Bachelor (NLD) BBL=Vocational Coaching (NLD) BOL=Vocational Training (NLD) BUSN=Graduate Business CNED=Continuing Education CRED=Semester Credit EDU=Education (NLD) EXED=Extended Education GRAD=Graduate LAW=Law MEDS=Medical School NONA=Non Award PGRD=Postgraduate RSCH=Research TECH=Technical UENG=Undergraduate Engineering UGRD=Undergraduate VAVO=Advanced General Educ. (NLD) VETM=Veterinary Medicine |
5 | LN_APPL_SEQ | Number(2,0) | SMALLINT NOT NULL | Loan Application Seq Num |
6 | LOAN_TYPE | Character(4) | VARCHAR2(4) NOT NULL | Loan Type Cd |
7 | ITEM_TYPE | Character(12) | VARCHAR2(12) NOT NULL |
Item Type
Prompt Table: LN_ITEM_TBL |
8 | DISBURSEMENT_ID | Character(2) | VARCHAR2(2) NOT NULL | Disbursement ID |
9 | LN_DISB_SEQ_NBR | Number(2,0) | SMALLINT NOT NULL | Loan Disb Sequence Nbr |
10 | LN_DISB_AMT | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Loan Disbursement Amt |
11 | LN_ACTION_CD | Character(4) | VARCHAR2(4) NOT NULL | Loan Action Cd |
12 | LN_ACTION_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Loan Action Type
Default Value: D |
13 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
14 | TRNSFR_BATCH | Character(23) | VARCHAR2(23) NOT NULL | Transfer Batch |
15 | LN_ACTION_DT | DateTime(26) | TIMESTAMP | Loan Action Dttm |
16 | LN_DISBACTN_AMT | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Loan Disb Action Amt |
17 | LN_DISBACTN_NET | Signed Number(13,2) | DECIMAL(11,2) NOT NULL | Loan Disb Action Net |
18 | LN_ACTION_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Loan Action Status
A=Accptd-Not Applied B=Accepted F=Failed Rule I=Invalid L=Lower Endorser Amount accepted O=Authorized for Transfer P=Pending R=Rejected T=Transmitted U=Received W=Accepted with Corrected Award |
19 | SFA_CR_DOCUMENT_ID | Character(34) | VARCHAR2(34) NOT NULL | Document ID |