SS_FA_LN_DTL_VW

(SQL View)
 Index Back

FA Self-Service Loan details

Provides details of loans for FA Self-Service.

SELECT D.SETID ,A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.ACAD_CAREER ,A.LN_APPL_SEQ ,A.ITEM_TYPE ,A.LN_BORRQSTD_DTL ,A.LN_ANTIC_FEE_TOT ,A.LN_ANTIC_REBATE ,A.LN_ANTIC_NET_TOT ,C.LOAN_PROGRAM ,A.LOAN_PROC_STAT ,A.LN_ORIG_TRANS ,B.LN_ACTION_DT ,E.LN_DEST_NBR ,E.LN_VERSION ,E.LEND_UNQ_ID FROM PS_LOAN_ORIG_DTL A ,PS_LOAN_ORIG_ACTN B ,PS_ITM_TP_FA_AWRDS C ,PS_STDNT_AWARDS D ,PS_LOAN_ORIGNATN E 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.ITEM_TYPE = B.ITEM_TYPE AND A.EMPLID = E.EMPLID AND A.INSTITUTION = E.INSTITUTION AND A.AID_YEAR = E.AID_YEAR AND A.ACAD_CAREER = E.ACAD_CAREER AND A.LOAN_TYPE = E.LOAN_TYPE AND A.LN_APPL_SEQ = E.LN_APPL_SEQ AND B.LN_ORIG_ACTN_SEQ = ( SELECT MAX(B2.LN_ORIG_ACTN_SEQ) FROM PS_LOAN_ORIG_ACTN B2 WHERE B.EMPLID = B2.EMPLID AND B.INSTITUTION = B2.INSTITUTION AND B.AID_YEAR = B2.AID_YEAR AND B.ACAD_CAREER = B2.ACAD_CAREER AND B.LOAN_TYPE = B2.LOAN_TYPE AND B.LN_APPL_SEQ = B2.LN_APPL_SEQ AND B.ITEM_TYPE = B2.ITEM_TYPE) AND C.AID_YEAR = A.AID_YEAR AND C.ITEM_TYPE = A.ITEM_TYPE AND D.EMPLID = A.EMPLID AND D.INSTITUTION = A.INSTITUTION AND D.AID_YEAR = A.AID_YEAR AND D.ACAD_CAREER = A.ACAD_CAREER AND D.ITEM_TYPE = A.ITEM_TYPE AND D.SETID = C.SETID

  • Parent record: LOAN_ORIGNATN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_CS.SETID

    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    4 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

    5 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

    Prompt Table: STDNT_CR_TRM_VW

    6 LN_APPL_SEQ Number(2,0) SMALLINT NOT NULL Loan Application Seq Num

    Default Value: LOAN_ORIGNATN.LN_APPL_SEQ

    Prompt Table: LOAN_ORIGNATN

    7 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: LN_ITEM_TBL

    8 LN_BORRQSTD_DTL Number(12,2) DECIMAL(11,2) NOT NULL Borrower Requested Amt
    9 LN_ANTIC_FEE_TOT Number(12,2) DECIMAL(11,2) NOT NULL Anticipated Loan Fee Total
    10 LN_ANTIC_REBATE Number(7,2) DECIMAL(6,2) NOT NULL Anticipated Ln Rebate
    11 LN_ANTIC_NET_TOT Number(12,2) DECIMAL(11,2) NOT NULL Anticipated Loan Net Total
    12 LOAN_PROGRAM Character(1) VARCHAR2(1) NOT NULL Loan Program
    A=Alternative
    D=Direct Lending
    F=FFELP
    H=Health Professions
    P=Perkins
    S=State
    U=University
    13 LOAN_PROC_STAT Character(1) VARCHAR2(1) NOT NULL Loan Process Status
    C=Canceled
    H=Hold
    N=Offered And Not Accepted
    O=Origination Pending
    S=In Service
    X=Terminated
    14 LN_ORIG_TRANS Character(1) VARCHAR2(1) NOT NULL Loan Orig Trans Stat
    A=Accepted
    C=Change Pending Transmission
    E=Error
    O=Orig Pending Transmission
    T=Transmitted
    15 LN_ACTION_DT DateTime(26) TIMESTAMP Loan Action Dttm
    16 LN_DEST_NBR Number(3,0) SMALLINT NOT NULL Loan Destination Num
    17 LN_VERSION Character(10) VARCHAR2(10) NOT NULL CommonLine Loan Version
    18 LEND_UNQ_ID Number(3,0) SMALLINT NOT NULL Lender ID