ACAD_PROG_TB_VW

(SQL View)
 Index Back

Academic Program Table View

The Academic Program Table defines all academic programs that an institution offers. Students are admitted to Academic Programs.

SELECT A.INSTITUTION ,A.ACAD_PROG ,A.DESCR ,A.DESCRSHORT ,A.ACAD_CAREER ,A.ACAD_CALENDAR_ID ,A.ADVISOR_EDIT ,A.LEVEL_LOAD_RULE ,A.ACAD_GROUP ,A.ACAD_PLAN ,A.CAMPUS ,A.FIRST_TERM_VALID ,A.CAR_PTR_EXC_RULE ,A.CAR_PTR_EXC_FG ,A.FA_PRIMACY_NBR ,A.FA_ELIGIBILITY ,A.PROG_NORM_COMPLTN ,A.RESIDENCY_REQ ,A.CIP_CODE ,A.HEGIS_CODE ,A.CRSE_COUNT_ENRL ,A.CRSE_COUNT_MIN ,A.ACAD_ORG ,A.SPLIT_OWNER ,A.ACAD_PROG_DUAL ,A.GRADING_SCHEME ,A.GRADING_BASIS ,A.GRADE_TRANSFER ,A.TRANSCRIPT_LEVEL ,A.ACAD_STDNG_RULE ,A.ASSOC_PROG_AS ,A.CALC_AS_BATCH_ONLY ,A.OBEY_FULLY_GRD_AS ,A.EXCL_TRM_CAT_AS_1 ,A.EXCL_TRM_CAT_AS_2 ,A.EXCL_TRM_CAT_AS_3 ,A.HONOR_AWARD_RULE ,A.ASSOC_PROG_HA ,A.CALC_HA_BATCH_ONLY ,A.OBEY_FULLY_GRD_HA ,A.EXCL_TRM_CAT_HA_1 ,A.EXCL_TRM_CAT_HA_2 ,A.EXCL_TRM_CAT_HA_3 ,A.HONOR_DT_FG ,A.INCOMPLETE_GRADE ,A.LAPSE_GRADE ,A.LAPSE_TO_GRADE ,A.LAPSE_DAYS ,A.LAPSE_NOTE_ID ,A.PRINT_LAPSE_DATE ,A.CMPLTD_NOTE_ID ,A.PRINT_CMPLTD_DATE ,A.REPEAT_RULE ,A.REPEAT_GRD_CK ,A.CANCEL_REASON ,A.WD_WO_PEN_REASON ,A.WD_W_PEN_GRD_BAS ,A.WD_W_PEN_GRADE ,A.WD_W_PEN2_GRADE ,A.WD_W_PEN2_GRD_BAS ,A.DROP_RET_RSN ,A.DROP_PEN_GRADE ,A.DROP_PEN_GRADE_2 ,A.DROP_PEN_GRD_BAS ,A.DROP_PEN_GRD_BAS_2 ,A.OEE_IND ,A.REPEAT_ENRL_CTL ,A.REPEAT_ENRL_SUSP ,A.REPEAT_GRD_SUSP ,A.REPEAT_CRSE_ERROR FROM PS_ACAD_PROG_TBL A WHERE A.EFF_STATUS = 'A' AND A.EFFDT = ( SELECT MAX(A2.EFFDT) FROM PS_ACAD_PROG_TBL A2 WHERE A2.INSTITUTION = A.INSTITUTION AND A2.ACAD_PROG = A.ACAD_PROG AND A2.EFFDT <= %CurrentDateIn )

  • Related Language Record: ACAD_PRGTBLN_VW

    • # 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_PROG Character(5) VARCHAR2(5) NOT NULL Academic Program
    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: ACAD_PROG_TBL.DESCR

    5 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

    6 ACAD_CALENDAR_ID Character(4) VARCHAR2(4) NOT NULL Academic Calendar

    Prompt Table: ACAD_CAL_TABLE

    7 ADVISOR_EDIT Character(1) VARCHAR2(1) NOT NULL Advisor Edit
    A=Advisor Role
    I=Instructor Advisor
    P=Personal Data

    Default Value: P

    8 LEVEL_LOAD_RULE Character(5) VARCHAR2(5) NOT NULL Academic Level Rule

    Prompt Table: LVL_LD_RULE_TBL

    9 ACAD_GROUP Character(5) VARCHAR2(5) NOT NULL Academic Group

    Prompt Table: ACAD_GROUP_TBL

    10 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

    Prompt Table: ACAD_PLAN_TBLVW

    11 CAMPUS Character(5) VARCHAR2(5) NOT NULL Campus

    Prompt Table: HOME_CAMPUS_VW

    12 FIRST_TERM_VALID Character(4) VARCHAR2(4) NOT NULL First Term Valid

    Prompt Table: TERM_VAL_TBL

    13 CAR_PTR_EXC_RULE Character(10) VARCHAR2(10) NOT NULL Career Pointer Exception Rule

    Prompt Table: CAR_PTR_EXC

    14 CAR_PTR_EXC_FG Character(1) VARCHAR2(1) NOT NULL Only if Outside Career

    Y/N Table Edit

    Default Value: Y

    15 FA_PRIMACY_NBR Number(3,0) SMALLINT NOT NULL Primacy Nbr
    16 FA_ELIGIBILITY Character(1) VARCHAR2(1) NOT NULL Program Eligibility Flag

    Y/N Table Edit

    Default Value: Y

    17 PROG_NORM_COMPLTN Number(3,0) SMALLINT NOT NULL IPEDS Normal Completion (yrs)
    18 RESIDENCY_REQ Character(1) VARCHAR2(1) NOT NULL Requires Residency Coding
    N=Not Required
    Y=Required

    Default Value: INSTITUTION_TBL.RESIDENCY_REQ

    19 CIP_CODE Character(13) VARCHAR2(13) NOT NULL CIP code

    Prompt Table: CIP_CODE_TBL

    20 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL HEGIS Code

    Prompt Table: HEGIS_CODE_TBL

    21 CRSE_COUNT_ENRL Character(1) VARCHAR2(1) NOT NULL Course Count Enrollment

    Y/N Table Edit

    Default Value: N

    22 CRSE_COUNT_MIN Number(5,2) DECIMAL(4,2) NOT NULL Min Course Count to Count
    23 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization

    Prompt Table: ACAD_ORG_TBL_VW

    24 SPLIT_OWNER Character(1) VARCHAR2(1) NOT NULL Split Ownership

    Y/N Table Edit

    Default Value: N

    25 ACAD_PROG_DUAL Character(5) VARCHAR2(5) NOT NULL Dual Academic Program

    Prompt Table: ACAD_PROG_TBLV2

    26 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme

    Prompt Table: GRADESCHEME_TBL

    27 GRADING_BASIS Character(3) VARCHAR2(3) NOT NULL Grading Basis
    ANC=ABC/NC Grading
    AUD=Audit
    BMT=Multi-Term Course: Not Graded
    CNC=Credit / No Credit
    EQV=Equivalent
    GRD=Graded
    HSC=Hundred Point Scale (NLD)
    LAW=Law
    MED=Medical School Grades
    NOG=No Grade Associated
    NON=Non-Graded Component
    NQF=NQF Scale
    OPT=Student Option
    PNP=Pass/Not Pass
    SUS=Satisfactory/Unsatisfactory
    TRN=Transfer Grading Basis
    TSC=Ten Point Scale (NLD)

    Prompt Table: GRADE_BASIS_TBL

    28 GRADE_TRANSFER Character(3) VARCHAR2(3) NOT NULL Default Grade- Transfer Credit

    Prompt Table: GRADE_TBL

    29 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

    Default Value: 20

    30 ACAD_STDNG_RULE Character(10) VARCHAR2(10) NOT NULL Academic Standing Rule

    Prompt Table: ACAD_STDG_RL_VW

    31 ASSOC_PROG_AS Character(1) VARCHAR2(1) NOT NULL Associate with Academic Prog

    Y/N Table Edit

    Default Value: N

    32 CALC_AS_BATCH_ONLY Character(1) VARCHAR2(1) NOT NULL Calculate in Batch Only

    Y/N Table Edit

    Default Value: N

    33 OBEY_FULLY_GRD_AS Character(1) VARCHAR2(1) NOT NULL Obey Fully Graded Date

    Y/N Table Edit

    Default Value: Y

    34 EXCL_TRM_CAT_AS_1 Character(1) VARCHAR2(1) NOT NULL Exclude Term Category 1

    Prompt Table: LS_XLAT_MC_VW

    35 EXCL_TRM_CAT_AS_2 Character(1) VARCHAR2(1) NOT NULL Exclude Term Category 2

    Prompt Table: LS_XLAT_MC_VW

    36 EXCL_TRM_CAT_AS_3 Character(1) VARCHAR2(1) NOT NULL Exclude Term Category 3

    Prompt Table: LS_XLAT_MC_VW

    37 HONOR_AWARD_RULE Character(10) VARCHAR2(10) NOT NULL Honor Award Rule

    Prompt Table: HONOR_AWD_RL_VW

    38 ASSOC_PROG_HA Character(1) VARCHAR2(1) NOT NULL Associate with Academic Prog

    Y/N Table Edit

    Default Value: N

    39 CALC_HA_BATCH_ONLY Character(1) VARCHAR2(1) NOT NULL Calculate in Batch Only

    Y/N Table Edit

    Default Value: N

    40 OBEY_FULLY_GRD_HA Character(1) VARCHAR2(1) NOT NULL Obey Fully Graded Date

    Y/N Table Edit

    Default Value: Y

    41 EXCL_TRM_CAT_HA_1 Character(1) VARCHAR2(1) NOT NULL Exclude Term Category 1

    Prompt Table: LS_XLAT_MC_VW

    42 EXCL_TRM_CAT_HA_2 Character(1) VARCHAR2(1) NOT NULL Exclude Term Category 2

    Prompt Table: LS_XLAT_MC_VW

    43 EXCL_TRM_CAT_HA_3 Character(1) VARCHAR2(1) NOT NULL Exclude Term Category 3

    Prompt Table: LS_XLAT_MC_VW

    44 HONOR_DT_FG Character(4) VARCHAR2(4) NOT NULL Honor and Award Date Flag
    FGRD=Fully Graded Date
    SYSD=System Date

    Default Value: FGRD

    45 INCOMPLETE_GRADE Character(3) VARCHAR2(3) NOT NULL Incomplete Grade

    Prompt Table: GRADE_INCOMP_VW

    46 LAPSE_GRADE Character(1) VARCHAR2(1) NOT NULL Lapse Grade

    Y/N Table Edit

    Default Value: N

    47 LAPSE_TO_GRADE Character(3) VARCHAR2(3) NOT NULL Lapse To Grade

    Prompt Table: GRADE_LAPSE_VW

    48 LAPSE_DAYS Number(4,0) SMALLINT NOT NULL Lapse Days
    49 LAPSE_NOTE_ID Character(4) VARCHAR2(4) NOT NULL Lapse Transcript Note ID

    Prompt Table: TSCRPT_NOTE_TBL

    50 PRINT_LAPSE_DATE Character(1) VARCHAR2(1) NOT NULL Print Lapse Date

    Y/N Table Edit

    Default Value: N

    51 CMPLTD_NOTE_ID Character(4) VARCHAR2(4) NOT NULL Completed Transcript Note ID

    Prompt Table: TSCRPT_NOTE_TBL

    52 PRINT_CMPLTD_DATE Character(1) VARCHAR2(1) NOT NULL Print Completed Date

    Y/N Table Edit

    Default Value: N

    53 REPEAT_RULE Character(10) VARCHAR2(10) NOT NULL Repeat Rule

    Prompt Table: REPEAT_RULE_VW

    54 REPEAT_GRD_CK Character(1) VARCHAR2(1) NOT NULL Repeat Grade Check
    A=All Courses
    N=Never
    O=Only Repeat Candidates
    55 CANCEL_REASON Character(4) VARCHAR2(4) NOT NULL Cancel Drop Reason

    Prompt Table: ENRL_RSN_TBL

    56 WD_WO_PEN_REASON Character(4) VARCHAR2(4) NOT NULL Withdraw Drop Rsn No Penalty

    Prompt Table: ENRL_RSN_TBL

    57 WD_W_PEN_GRD_BAS Character(3) VARCHAR2(3) NOT NULL Withdraw w/ Pen Grading Basis

    Prompt Table: GRADE_BASE_E_VW

    58 WD_W_PEN_GRADE Character(3) VARCHAR2(3) NOT NULL Withdraw with Penalty Grade

    Prompt Table: WD_W_PEN_GRD_VW

    59 WD_W_PEN2_GRADE Character(3) VARCHAR2(3) NOT NULL Withdraw with Penalty 2 Grade

    Prompt Table: WD_W_PEN2_GD_VW

    60 WD_W_PEN2_GRD_BAS Character(3) VARCHAR2(3) NOT NULL Withdraw w/ Pen2 Grading Basis

    Prompt Table: GRADE_BASE_E_VW

    61 DROP_RET_RSN Character(4) VARCHAR2(4) NOT NULL Drop Reasn for Retained Record

    Prompt Table: ENRL_RSN_TBL

    62 DROP_PEN_GRADE Character(3) VARCHAR2(3) NOT NULL Drop with Penalty Grade

    Prompt Table: DROP_PEN_GRD_VW

    63 DROP_PEN_GRADE_2 Character(3) VARCHAR2(3) NOT NULL Drop with Penalty Grade

    Prompt Table: DRP_PEN_GRD2_VW

    64 DROP_PEN_GRD_BAS Character(3) VARCHAR2(3) NOT NULL Drop with Penalty Grade Basis

    Prompt Table: GRADE_BASE_E_VW

    65 DROP_PEN_GRD_BAS_2 Character(3) VARCHAR2(3) NOT NULL Drop with Penalty Grade Basis2

    Prompt Table: GRADE_BASE_E_VW

    66 OEE_IND Character(1) VARCHAR2(1) NOT NULL Allow OEE Enrollment

    Y/N Table Edit

    Default Value: Y

    67 REPEAT_ENRL_CTL Character(1) VARCHAR2(1) NOT NULL Process on Enrollment
    N=No
    Y=Yes
    68 REPEAT_ENRL_SUSP Character(1) VARCHAR2(1) NOT NULL Temp Susp Rpt Ck on Enrl

    Y/N Table Edit

    69 REPEAT_GRD_SUSP Character(1) VARCHAR2(1) NOT NULL Temp Susp Rpt Ck on Grading

    Y/N Table Edit

    70 REPEAT_CRSE_ERROR Character(1) VARCHAR2(1) NOT NULL Course Catalog Repeat Message
    E=Error
    N=None
    W=Warning

    Default Value: W