LNCLFNPLNCTYLNG

(SQL View)
 Index Back

Rel lang-Orig Upd Pln Scrty

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

SELECT C.OPRCLASS , A.EMPLID , A.INSTITUTION , A.AID_YEAR , K.LANGUAGE_CD , K.DESCR , A.ITEM_TYPE , A.ACAD_CAREER , M.DESCR , A.DISBURSEMENT_ID , N.DESCR , A.LN_APPL_SEQ , J.OPRID 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 ,PS_LN_TYPE_LANG K ,PS_DISB_ID_LNG M ,PS_TERM_TBL_LANG N WHERE C.EMPLID = A.EMPLID AND B.INSTITUTION = K.INSTITUTION AND B.AID_YEAR = K.AID_YEAR AND B.LOAN_TYPE = K.LOAN_TYPE 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 = M.INSTITUTION AND G.AID_YEAR = M.AID_YEAR AND G.ACAD_CAREER = M.ACAD_CAREER AND G.DISBURSEMENT_PLAN = M.DISBURSEMENT_PLAN AND G.DISBURSEMENT_ID = M.DISBURSEMENT_ID 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 = N.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 for LNCLFN_PLN_SCTY

    • # 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 ITEM_TYPE Character(12) VARCHAR2(12) NOT NULL Item Type

    Prompt Table: ITEM_TYPE_FA

    8 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
    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).