LN_DISB_ACT_VW

(SQL View)
Index Back

Loan Disbursement Detail Vw

Tracks, 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

  • Related Language Record: LNDISBACTVW_LNG
  • Parent record: LOAN_ORIGNATN
  • # 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