LOAN_ORIG_VW

(SQL View)
 Index Back

Loan Orig Action View

Shows the latest Loan Origination Actions for a given Loan Application/Promissory Note. Origination Actions are generally exchanged between the School and external processing entities.

select a.emplid, a.institution, a.aid_year, a.loan_type, a.ln_appl_seq, a.item_type, a.ln_orig_actn_seq, a.ln_action_dt, a.ln_action_type, a.ln_action_cd, a.ln_action_status, a.ln_actnstat_dt, a.trnsfr_batch, b.ln_book_stat from ps_loan_orig_actn a, PS_LOAN_ORIGNATN b where a.emplid = b.emplid and a.institution = b.institution and a.aid_year = b.aid_year and a.acad_career = b.acad_career and a.loan_type = b.loan_type and a.ln_appl_seq = b.ln_appl_seq and a.ln_orig_actn_seq = (select max(c.ln_orig_actn_seq) from ps_loan_orig_actn c where a.emplid = c.emplid and a.institution = c.institution and a.aid_year = c.aid_year and a.loan_type = c.loan_type and a.ln_appl_seq = c.ln_appl_seq and a.item_type = c.item_type)

  • Parent record: LOAN_ORIG_DTL

    • # 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: AID_YEAR_TBL

    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

    Prompt Table: LN_ITEM_TBL

    7 LN_ORIG_ACTN_SEQ Number(2,0) SMALLINT NOT NULL Loan Orig Action Seq
    8 LN_ACTION_DT DateTime(26) TIMESTAMP Loan Action Dttm
    9 LN_ACTION_TYPE Character(1) VARCHAR2(1) NOT NULL Loan Action Type

    Default Value: O

    Prompt Table: LN_ACTNTYPE_TBL

    10 LN_ACTION_CD Character(4) VARCHAR2(4) NOT NULL Loan Action Cd

    Prompt Table: LN_ORIGCD_VW

    11 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
    12 LN_ACTNSTAT_DT Date(10) DATE Loan Action Status Dt
    13 TRNSFR_BATCH Character(23) VARCHAR2(23) NOT NULL Transfer Batch
    14 LN_BOOK_STAT Character(1) VARCHAR2(1) NOT NULL Direct Lending Booked Status
    A=Booked
    R=Unbooked