SSR_ACADSTDNGVW

(SQL View)
 Index Back

Academic Standing Action View

This view shows Academic Standing Actions values within an Institution, Academic Career and Effective Date that have an Active effective status.

SELECT A.INSTITUTION , A.ACAD_CAREER , A.EFFDT , A.ACAD_STNDNG_ACTN , B.EFF_STATUS , A.DESCR , A.DESCRSHORT , A.TRANSCRIPT_LEVEL , A.ACAD_STNDNG_STAT , A.DESCRFORMAL , A.DESCRINTERNAL FROM PS_ACAD_STACTN_TBL A , PS_ACAD_STDNG_TBL B WHERE A.INSTITUTION = B.INSTITUTION AND A.ACAD_CAREER = B.ACAD_CAREER AND A.EFFDT = B.EFFDT AND B.EFF_STATUS = 'A'

  • Related Language Record: ACAD_STACTN_LNG

  • Parent record: ACAD_STDNG_TBL

    • # 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 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 ACAD_STNDNG_ACTN Character(4) VARCHAR2(4) NOT NULL Academic Standing Action
    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 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: ACAD_STACTN_TBL.DESCR

    8 TRANSCRIPT_LEVEL Character(2) VARCHAR2(2) NOT NULL Transcript level
    00=Never Print
    20=Print on Official
    40=Print on Unofficial
    60=Print on Student Life
    80=Print on Degree Progress
    9 ACAD_STNDNG_STAT Character(4) VARCHAR2(4) NOT NULL Academic Standing Status
    DIS=Dismissed
    GST=Good Standing
    PRO=Probation
    SUB=Subject to Dismissal
    10 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description field
    11 DESCRINTERNAL Character(50) VARCHAR2(50) NOT NULL Internal Description