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
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Institution field to store institution information in campus solution system.
    2 ACAD_PLAN Character(10) VARCHAR2(10) NOT NULL Academic Plan field coming from campus solution system
    3 ACAD_SUB_PLAN Character(10) VARCHAR2(10) NOT NULL Academic sub plan, a field together with program, plan, and sub plan to store student program information.
    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 Subplan Type
    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 Subplan Required Term Default

    Default Value: ACAD_PLAN_TBL.PLN_REQTRM_DFLT

    10 DIPLOMA_DESCR Character(100) VARCHAR2(100) NOT NULL This field stores the 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 This field is used to indicate number of characters to indent
    13 TRNSCR_DESCR Character(100) VARCHAR2(100) NOT NULL This field is used to store the Transcript Description.
    14 TRNSCR_PRINT_FL Character(1) VARCHAR2(1) NOT NULL Print on Transcipt value.

    Y/N Table Edit

    Default Value: Y

    15 TRNSCR_INDENT Number(2,0) SMALLINT NOT NULL Number of Characters Indent on Transcription
    16 FIRST_TERM_VALID Character(4) VARCHAR2(4) NOT NULL This field is used to indicate first valid term.
    17 CIP_CODE Character(13) VARCHAR2(13) NOT NULL CIP code
    18 HEGIS_CODE Character(8) VARCHAR2(8) NOT NULL This field is used for mentioning HEGIS code
    19 TRANSCRIPT_LEVEL Character(2) VARCHAR2(2) NOT NULL Transcript level

    Default Value: 20

    20 EVALUATE_SUBPLAN Character(1) VARCHAR2(1) NOT NULL Evalute Subplan Before Plan?

    Y/N Table Edit

    21 SSR_LAST_PRS_DT Date(10) DATE Field used to store the Last Prospect Date values.
    22 SSR_LAST_ADM_TERM Character(4) VARCHAR2(4) NOT NULL This field stores the Last Admitted Term.
    23 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.
    24 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.
    25 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.
    26 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.
    27 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
    28 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time