ACAD_PROG_TBL

(SQL Table)
 Index Back

Academic Program Table

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

  • Related Language Record: ACAD_PROG_LANG

  • Parent Record Of ACAD_PROG_CAF ACAD_PROG_LN_CA ACAD_PROG_OWNER BUS_UNIT_FA_VW ENRL_LIMITS_TBL HOME_CAMPUS_TBL SSR_ACD_PRG_NZL SSR_PE_PRG_MAP SSR_PE_PRMAP_LN SSR_PRG_NRM_LNG SSR_PRG_NRM_NLD

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

    Default Value: %date

    4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default Value: A

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

    Default Value: ACAD_PROG_TBL.DESCR

    7 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

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

    Prompt Table: ACAD_CAL_TABLE

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

    Default Value: P

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

    Prompt Table: LVL_LD_RULE_TBL

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

    Prompt Table: ACAD_GROUP_TBL

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

    Prompt Table: ACAD_PLAN_TBLVW

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

    Prompt Table: HOME_CAMPUS_VW

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

    Prompt Table: TERM_VAL_TBL

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

    Prompt Table: CAR_PTR_EXC

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

    Default Value: Y

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

    Default Value: INSTITUTION_TBL.RESIDENCY_REQ

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

    Prompt Table: CIP_CODE_TBL

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

    Prompt Table: HEGIS_CODE_TBL

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: ACAD_ORG_TBL_VW

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: ACAD_PROG_TBLV2

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

    Prompt Table: GRADESCHEME_TBL

    29 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

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

    Prompt Table: GRADE_TBL

    31 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

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

    Prompt Table: ACAD_STDG_RL_VW

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: Y

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

    Prompt Table: LS_XLAT_MC_VW

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

    Prompt Table: LS_XLAT_MC_VW

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

    Prompt Table: LS_XLAT_MC_VW

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

    Prompt Table: HONOR_AWD_RL_VW

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: Y

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

    Prompt Table: LS_XLAT_MC_VW

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

    Prompt Table: LS_XLAT_MC_VW

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

    Prompt Table: LS_XLAT_MC_VW

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

    Default Value: FGRD

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

    Prompt Table: GRADE_INCOMP_VW

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: GRADE_LAPSE_VW

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

    Prompt Table: TSCRPT_NOTE_TBL

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: TSCRPT_NOTE_TBL

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

    Y/N Table Edit

    Default Value: N

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

    Prompt Table: REPEAT_RULE_VW

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

    Prompt Table: ENRL_RSN_TBL

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

    Prompt Table: ENRL_RSN_TBL

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

    Prompt Table: GRADE_BASE_E_VW

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

    Prompt Table: WD_W_PEN_GRD_VW

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

    Prompt Table: WD_W_PEN2_GD_VW

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

    Prompt Table: GRADE_BASE_E_VW

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

    Prompt Table: ENRL_RSN_TBL

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

    Prompt Table: DROP_PEN_GRD_VW

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

    Prompt Table: DRP_PEN_GRD2_VW

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

    Prompt Table: GRADE_BASE_E_VW

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

    Prompt Table: GRADE_BASE_E_VW

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

    Y/N Table Edit

    Default Value: Y

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

    Y/N Table Edit

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

    Y/N Table Edit

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

    Default Value: W

    73 SSR_LAST_PRS_DT Date(10) DATE Last Prospect Date
    74 SSR_LAST_ADM_TERM Character(4) VARCHAR2(4) NOT NULL Last Admit Term

    Prompt Table: TERM_VAL_TBL

    75 SSR_GRAD_SETP_OVRD Character(1) VARCHAR2(1) NOT NULL Override Institution Setup

    Y/N Table Edit

    76 SSR_GRAD_CHRG_FEE Character(1) VARCHAR2(1) NOT NULL Charge a Graduation Fee

    Y/N Table Edit

    77 SSR_GRAD_PAY_REQ Character(1) VARCHAR2(1) NOT NULL Self Service Payment Required

    Y/N Table Edit

    78 FEE_CODE Character(6) VARCHAR2(6) NOT NULL Fee Code

    Prompt Table: TERM_FE_CD_TBL

    79 PROG_REASON Character(4) VARCHAR2(4) NOT NULL Action Reason

    Prompt Table: SSR_PROGRSN_VW

    80 SSR_USE_GRAD_TRACK Character(1) VARCHAR2(1) NOT NULL Use Graduation Tracking

    Y/N Table Edit

    81 SSR_GRAD_STATUS Character(4) VARCHAR2(4) NOT NULL eLearning Status which is used to derive the INTERNET field on SDR Course Register File

    Prompt Table: SSR_GRADSTATTBL

    82 SAA_WHIF_DISP_ADVR Character(1) VARCHAR2(1) NOT NULL Show In What-If Advisor

    Y/N Table Edit

    Default Value: N

    83 SAA_WHIF_DISP_PREM Character(1) VARCHAR2(1) NOT NULL Show in What-If Prematric Std

    Y/N Table Edit

    Default Value: N

    84 SAA_WHIF_DISP_STD Character(1) VARCHAR2(1) NOT NULL Show in What-If Student

    Y/N Table Edit

    Default Value: N

    85 SCC_SFP_PROG_UNIT Character(4) VARCHAR2(4) NOT NULL Program Measurement Unit
    CLCK=Clock
    CRED=Credit

    Default Value: CRED

    86 SCC_SFP_REQ_UNTS Number(9,3) DECIMAL(8,3) NOT NULL Total Required Units
    87 SCC_SFP_OPEID Character(8) VARCHAR2(8) NOT NULL OPEID
    88 SCC_SFP_AY_UNIT Character(4) VARCHAR2(4) NOT NULL Program Measurement Unit
    CLCK=Clock
    CRED=Credit

    Default Value: CRED

    89 SCC_SFP_AY_I_UNTS Number(9,3) DECIMAL(8,3) NOT NULL Total Required Units
    90 SCC_SFP_AY_UNTS Number(9,3) DECIMAL(8,3) NOT NULL Total Required Units
    91 REQUIRED_GPA Number(9,3) DECIMAL(8,3) NOT NULL Required GPA.
    92 SSR_SFP_BBAY_IND Character(1) VARCHAR2(1) NOT NULL Borrower Based Term Indicator

    Y/N Table Edit

    Default Value: N

    93 SSR_SFP_BBY_TRM_AY Number(3,0) SMALLINT NOT NULL Borrower Based Terms Per Year
    94 SSR_SFP_PROJ_CRSE Character(50) VARCHAR2(50) NOT NULL Projected Course Label
    95 SSR_SFP_PLAN_IND Character(1) VARCHAR2(1) NOT NULL Borrower Based Term Indicator

    Y/N Table Edit

    Default Value: N