ADMT_TPE_VW_LNG

(SQL View)
 Index Back

Admit Type View

This view shows the Admit Types that are valid for the specific Career being processed and that are shared across Careers.

SELECT DISTINCT a.institution , b.acad_career , a.admit_type , a.language_cd , a.effdt , a.descr , a.descrshort FROM ps_admit_type_lng a , PS_ACAD_CAR_TBL b , ps_admit_type_tbl c WHERE a.institution = b.institution AND (c.acad_career = b.acad_career OR c.acad_career = ' ') AND c.admit_type = a.admit_type AND c.institution = a.institution AND c.effdt = a.effdt

  • Related Language Record for ADMIT_TYPE_VW ADMIT_TYPE_VW2

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    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: ACAD_CAR_TBL

    3 ADMIT_TYPE Character(3) VARCHAR2(3) NOT NULL Admit Type

    Prompt Table: ADMIT_TYPE_TBL

    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: ADMIT_TYPE_TBL.DESCR