LNDISBACTVW_LNG

(SQL View)
 Index Back

Loan Disbursement Detail Vw

LNDISBACTVW_LNG is the language record view related to LN_DISB_ACT_VW. A related language record enables text fields on a table to be translated into various languages for use in other countries.

SELECT a.emplid , a.institution , a.aid_year , a.ln_appl_seq , a.loan_type , a.item_type , a.disbursement_id , a.ln_disb_seq_nbr ,c.language_cd , c.descr FROM PS_LOAN_DISB_ACTN a , ps_loan_disbmnt b , PS_LN_ACTNCD_LANG 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 for LN_DISB_ACT_VW

  • 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 LN_APPL_SEQ Number(2,0) SMALLINT NOT NULL Loan Application Seq Num
    5 LOAN_TYPE Character(4) VARCHAR2(4) NOT NULL Loan Type Cd
    6 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: LN_ITEM_TBL

    7 DISBURSEMENT_ID Character(2) VARCHAR2(2) NOT NULL Disbursement ID
    8 LN_DISB_SEQ_NBR Number(2,0) SMALLINT NOT NULL Loan Disb Sequence Nbr
    9 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description