ACAD_SUBPLN_TBL

(SQL Table)
Index Back

Academic Sub Plan Table

An Academic Sub Plan is a focus within an academic plan. An example of a subplan might be an American history concentration within the history major (plan).

  • Related Language Record: ACAD_SUBPLN_LNG
  • Parent Record Of ACAD_SUBPLN_CAF ACD_SBPLNCAF_LN
  • # 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_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan

    Default Value: OPR_DEF_TBL_CS.ACAD_PLAN

    Prompt Table: ACAD_PLAN_T2_VW

    3 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Sub-Plan
    4 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

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

    Default Value: A

    6 ACAD_SUBPLAN_TYPE Character(3) VARCHAR2(3) NOT NULL Academic Sub-Plan Type
    CON=Concentration
    EMP=Emphasis
    MIN=Minor
    OPT=Option
    SPC=Specialization
    TRK=Track
    7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    8 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description

    Default Value: ACAD_SUBPLN_TBL.DESCR

    9 SUBPLN_REQTRM_DFLT Character(1) VARCHAR2(1) NOT NULL Sub-Plan Req Term Default
    A=Program's Admit Term
    D=SubPlan's Declare Date
    L=Plan's Requirement Term
    P=Program's Requirement Term

    Default Value: ACAD_PLAN_TBL.PLN_REQTRM_DFLT

    10 DIPLOMA_DESCR Character(100) VARCHAR2(100) NOT NULL Diploma Description
    11 DIPLOMA_PRINT_FL Character(1) VARCHAR2(1) NOT NULL Print on Diploma

    Y/N Table Edit

    Default Value: Y

    12 DIPLOMA_INDENT Number(2,0) SMALLINT NOT NULL Number of Characters to Indent
    13 TRNSCR_DESCR Character(100) VARCHAR2(100) NOT NULL Transcript Description
    14 TRNSCR_PRINT_FL Character(1) VARCHAR2(1) NOT NULL Print on Transcript

    Y/N Table Edit

    Default Value: Y

    15 TRNSCR_INDENT Number(2,0) SMALLINT NOT NULL Nbr of Chars Indnt on Transcr
    16 FIRST_TERM_VALID Character(4) VARCHAR2(4) NOT NULL First Term Valid

    Prompt Table: TERM_VAL_TBL

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

    Default Value: ACAD_PLAN_TBL.CIP_CODE

    Prompt Table: CIP_CODE_TBL

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

    Default Value: ACAD_PLAN_TBL.HEGIS_CODE

    Prompt Table: HEGIS_CODE_TBL

    19 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

    20 EVALUATE_SUBPLAN Character(1) VARCHAR2(1) NOT NULL Evaluate SubPlan Before Plan?

    Y/N Table Edit

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

    Prompt Table: TERM_VAL_TBL

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N

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

    Y/N Table Edit

    Default Value: N