LNCLFN_PLN_SCTY

(SQL View)
 Index Back

Orig Update Plan Scrty

This view is used to impose plan-level security on specific Financial Aid components. (See Security View setup under Secure Student Administration.) This view selects students from both the admission and program stack. It is a clone of LN_CL_FUND_SRCH.

SELECT C.OPRCLASS , A.EMPLID , A.INSTITUTION , A.AID_YEAR , B.DESCR , A.ITEM_TYPE , A.ACAD_CAREER , H.STRM , H.DESCR , A.DISBURSEMENT_ID , G.DESCR , A.LN_APPL_SEQ , J.OPRID , C.NAME , C.NATIONAL_ID , C.NATIONAL_ID_MSK , C.LAST_NAME_SRCH , C.FIRST_NAME_SRCH , J.ACCESS_CD FROM PS_LOAN_STDNT_AWD A , PS_LN_TYPE_TBL B , PS_PEOPLE_SRCH C , PS_STDNT_AWRD_DISB E , PS_STDNT_AWARDS F , PS_DISB_ID_TBL G , PS_TERM_TBL H , PS_ADM_PROG_PLN_VW I , PS_SCRTY_TBL_PLAN J WHERE C.EMPLID = A.EMPLID AND B.INSTITUTION = A.INSTITUTION AND B.AID_YEAR = A.AID_YEAR AND B.LOAN_TYPE = A.LOAN_TYPE AND B.LOAN_PROGRAM IN ('F','A') AND A.EMPLID = E.EMPLID AND A.INSTITUTION = E.INSTITUTION AND A.AID_YEAR = E.AID_YEAR AND A.ITEM_TYPE = E.ITEM_TYPE AND A.ACAD_CAREER = E.ACAD_CAREER AND A.DISBURSEMENT_ID = E.DISBURSEMENT_ID AND E.EMPLID = F.EMPLID AND E.INSTITUTION = F.INSTITUTION AND E.AID_YEAR = F.AID_YEAR AND E.ITEM_TYPE = F.ITEM_TYPE AND E.ACAD_CAREER = F.ACAD_CAREER AND G.INSTITUTION = A.INSTITUTION AND G.AID_YEAR = A.AID_YEAR AND G.ACAD_CAREER = A.ACAD_CAREER AND G.DISBURSEMENT_PLAN = F.DISBURSEMENT_PLAN AND G.DISBURSEMENT_ID = A.DISBURSEMENT_ID AND A.INSTITUTION = H.INSTITUTION AND A.ACAD_CAREER = H.ACAD_CAREER AND G.STRM = H.STRM AND A.EMPLID = I.EMPLID AND A.INSTITUTION = J.INSTITUTION AND A.ACAD_CAREER = I.ACAD_CAREER AND (J.ACAD_PLAN = I.ACAD_PLAN OR J.ACAD_PLAN = 'ALL') AND J.ACCESS_CD = 'Y' AND NOT EXISTS ( SELECT 'X' FROM PS_SCRTY_TBL_PLAN J1 WHERE J1.ACCESS_CD = 'N' AND J1.OPRID = J.OPRID AND J1.INSTITUTION = A.INSTITUTION AND J1.ACAD_PLAN = I.ACAD_PLAN)

  • Related Language Record: LNCLFNPLNCTYLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    6 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: ITEM_TYPE_FA

    7 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
    8 STRM Character(4) VARCHAR2(4) NOT NULL Term
    9 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
    10 DISBURSEMENT_ID Character(2) VARCHAR2(2) NOT NULL Disbursement ID
    11 DESCR2 Character(30) VARCHAR2(30) NOT NULL Descr2
    12 LN_APPL_SEQ Number(2,0) SMALLINT NOT NULL Loan Application Seq Num
    13 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    14 NAME Character(50) VARCHAR2(50) NOT NULL Name
    15 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    16 NATIONAL_ID_MSK Character(20) VARCHAR2(20) NOT NULL National ID
    17 LAST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL Last Name
    18 FIRST_NAME_SRCH Character(30) VARCHAR2(30) NOT NULL First Name
    19 ACCESS_CD Character(1) VARCHAR2(1) NOT NULL Access Code
    N=No Access
    Y=Read/Write Access