SSR_HE_ENRL_VW

(SQL View)
 Index Back

Student HE Prg Enrl VW NLD

Enrollment view for Higher Education Inquiry Page Netherlands

SELECT A.EMPLID , A.ACAD_CAREER , A.STDNT_CAR_NBR , A.EFFDT , A.ACAD_YEAR , A.SSR_PRG_ACTION_NLD , A.SSR_FORM_STUDY_NLD ,A.SSR_ACAD_LEVEL_NLD ,A.SSR_FUNDING_CD_NLD ,A.SCC_STDY_PRGRS_NLD ,A.SSR_PRG_UNITS_NLD FROM PS_SSR_STD_PRG_NLD A WHERE A.SSR_PRG_ACTION_NLD IN ('MATR', 'ENRL','CENR', 'RENR')

  • Parent record: STDNT_CAREER

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: HCR_PERSON_I

    2 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_CAREER

    3 STDNT_CAR_NBR Number(3,0) SMALLINT NOT NULL Student Career Nbr
    4 EFFDT Date(10) DATE NOT NULL Effective Date
    5 ACAD_YEAR Character(4) VARCHAR2(4) NOT NULL Academic Year
    6 SSR_PRG_ACTION_NLD Character(4) VARCHAR2(4) NOT NULL Progr Action Higher Education
    CENR=Change Enrollment
    DATA=Data Change
    DSAC=Departure Accepted
    DSNA=Departure Not Accepted
    ENRL=Enrollment
    EXAM=Examination
    MATR=Matriculation
    NRNR=No Re-Enrollment
    PAYM=Payment
    RENR=Re-Enrollment
    SLCN=Studielink Conversion
    7 SSR_FORM_STUDY_NLD Character(4) VARCHAR2(4) NOT NULL Form of Study Higher Education
    A=Auditor
    D=Participant
    E=Extraneus
    S=Student
    T=Coop/Dual
    8 SSR_ACAD_LEVEL_NLD Character(4) VARCHAR2(4) NOT NULL Academ. Level Higher Education
    A=Associate Degree
    B=Bachelor
    D=Propaedeutic Bachelor
    H=Main
    I=Initial Phase
    K=Candidate
    L=University teacher education
    M=Master
    P=Propaedeutic Phase
    Q=Post-Initial
    T=Interim Doctoral Exam
    V=Continuation Phase
    W=Continuing study
    9 SSR_FUNDING_CD_NLD Character(1) VARCHAR2(1) NOT NULL Funding Applies

    Y/N Table Edit

    Default Value: N

    10 SCC_STDY_PRGRS_NLD Character(1) VARCHAR2(1) NOT NULL Study Progress

    Y/N Table Edit

    11 SSR_PRG_UNITS_NLD Number(3,0) SMALLINT NOT NULL Program Units Apply