SAA_PROG_CARVW

(SQL View)
 Index Back

Academic Program Career View

The Academic Program Table View lists academic programs for an institution by academic career. This view is used as a prompt/edit table to restrict Academic Program within Institution, Academic Career. This view is also used to retrieve the Academic Level Rule to use in term statistics calculations.

SELECT INSTITUTION ,ACAD_CAREER ,ACAD_PROG ,EFFDT ,EFF_STATUS ,DESCR ,LEVEL_LOAD_RULE ,RESIDENCY_REQ ,GRADING_SCHEME ,CAMPUS ,FA_ELIGIBILITY ,ACAD_GROUP ,FIRST_TERM_VALID ,SSR_LAST_ADM_TERM ,SAA_WHIF_DISP_ADVR ,SAA_WHIF_DISP_PREM ,SAA_WHIF_DISP_STD FROM PS_ACAD_PROG_TBL

  • Related Language Record: ACADPROGCARVLNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic 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
    3 ACAD_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program

    Prompt Table: ACAD_PROG_TBL

    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    7 LEVEL_LOAD_RULE Character(5) VARCHAR2(5) NOT NULL Academic Level Rule
    8 RESIDENCY_REQ Character(1) VARCHAR2(1) NOT NULL Requires Residency Coding
    N=Not Required
    Y=Required
    9 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme
    10 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus
    11 FA_ELIGIBILITY Character(1) VARCHAR2(1) NOT NULL Program Eligibility Flag
    12 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group
    13 FIRST_TERM_VALID Character(4) VARCHAR2(4) NOT NULL First Term Valid
    14 SSR_LAST_ADM_TERM Character(4) VARCHAR2(4) NOT NULL Last Admit Term
    15 SAA_WHIF_DISP_ADVR Character(1) VARCHAR2(1) NOT NULL Show In What-If Advisor
    16 SAA_WHIF_DISP_PREM Character(1) VARCHAR2(1) NOT NULL Show in What-If Prematric Std
    17 SAA_WHIF_DISP_STD Character(1) VARCHAR2(1) NOT NULL Show in What-If Student