SSR_ACDSTND_LVW

(SQL View)
 Index Back

Academic Standing Language

Academic Standing language record view

SELECT B.LANGUAGE_CD , A.EMPLID , A.INSTITUTION , A.ACAD_CAREER , A.STRM , A.ACAD_STNDNG_ACTN , B.DESCRFORMAL FROM PS_ACAD_STDNG_ACTN A , PS_ACAD_STACTN_LNG B WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_ACAD_STDNG_ACTN A1 WHERE A1.EMPLID = A.EMPLID AND A1.ACAD_CAREER = A.ACAD_CAREER AND A1.INSTITUTION = A.INSTITUTION AND A1.STRM = A.STRM AND A1.EFFDT <= %CurrentDateIn) AND A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ) FROM PS_ACAD_STDNG_ACTN A2 WHERE A2.EMPLID = A.EMPLID AND A2.ACAD_CAREER = A.ACAD_CAREER AND A2.INSTITUTION = A.INSTITUTION AND A2.STRM = A.STRM AND A2.EFFDT = A.EFFDT) AND B.INSTITUTION = A.INSTITUTION AND B.ACAD_CAREER = A.ACAD_CAREER AND B.ACAD_STNDNG_ACTN = A.ACAD_STNDNG_ACTN AND B.EFFDT = ( SELECT MAX(B1.EFFDT) FROM PS_ACAD_STACTN_TBL B1 WHERE B1.INSTITUTION = B.INSTITUTION AND B1.ACAD_CAREER = B.ACAD_CAREER AND B1.EFFDT <= %CurrentDateIn)

  • Related Language Record for SSR_ACD_STND_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    2 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    4 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
    5 STRM Character(4) VARCHAR2(4) NOT NULL Term
    6 ACAD_STNDNG_ACTN Character(4) VARCHAR2(4) NOT NULL Academic Standing Action
    7 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description field