SSR_STDNT_ML_PL

(SQL View)
 Index Back

Milestone Student Program View

This view is used to select students in the milestone batch processing based on academic program.

SELECT C.OPRCLASS , A.INSTITUTION , A.ACAD_CAREER , A.ACAD_PROG , B.ACAD_PLAN , C.EMPLID , C.NAME , C.SEX , C.BIRTHDATE , C.BIRTHDATE_MSK , C.CAMPUS_ID , C.NATIONAL_ID , C.NATIONAL_ID_MSK , C.NID_COUNTRY , C.NATIONAL_ID_TYPE , C.NID_DESCRSHORT , C.LAST_NAME_SRCH , C.FIRST_NAME_SRCH , C.NAME_DISPLAY FROM PS_ACAD_PROG A , PS_ACAD_PLAN B , PS_PEOPLE_SRCH C WHERE A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_ACAD_PROG A1 WHERE A.EMPLID = A1.EMPLID AND A.ACAD_CAREER = A1.ACAD_CAREER AND A.STDNT_CAR_NBR = A1.STDNT_CAR_NBR) AND A.EFFSEQ = ( SELECT MAX(A2.EFFSEQ) FROM PS_ACAD_PROG A2 WHERE A.EMPLID = A2.EMPLID AND A.ACAD_CAREER = A2.ACAD_CAREER AND A.STDNT_CAR_NBR = A2.STDNT_CAR_NBR AND A.EFFDT = A2.EFFDT) AND A.PROG_STATUS = 'AC' AND A.EMPLID = B.EMPLID AND A.ACAD_CAREER = B.ACAD_CAREER AND A.STDNT_CAR_NBR = B.STDNT_CAR_NBR AND A.EFFDT = B.EFFDT AND A.EFFSEQ = B.EFFSEQ AND A.EMPLID = C.EMPLID

  • Related Language Record: SSR_STDNTMLPLLN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRCLASS Character(30) VARCHAR2(30) NOT NULL Operator Class
    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution
    3 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
    4 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    5 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan
    6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    7 NAME Character(50) VARCHAR2(50) NOT NULL Name
    8 SEX Character(1) VARCHAR2(1) NOT NULL Gender
    F=Female
    M=Male
    U=Unknown
    X=Indeterminate/Intersex/Unspec
    9 BIRTHDATE Date(10) DATE Date of Birth
    10 BIRTHDATE_MSK Character(10) VARCHAR2(10) NOT NULL Date of Birth
    11 CAMPUS_ID Character(16) VARCHAR2(16) NOT NULL Campus ID
    12 NATIONAL_ID Character(20) VARCHAR2(20) NOT NULL National ID
    13 NATIONAL_ID_MSK Character(20) VARCHAR2(20) NOT NULL National ID
    14 NID_COUNTRY Character(3) VARCHAR2(3) NOT NULL National ID Country
    15 NATIONAL_ID_TYPE Character(6) VARCHAR2(6) NOT NULL National ID Type
    16 NID_DESCRSHORT Character(10) VARCHAR2(10) NOT NULL NID Short Description
    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 NAME_DISPLAY Character(50) VARCHAR2(50) NOT NULL Display Name - name formatted for Display based on the Country