SUBJECT_TBL

(SQL Table)
 Index Back

Subject Table

The Subject Table contains information about each academic subject an institution can offer courses in.

  • Related Language Record: SUBJECT_TBL_LNG

  • Parent Record Of SUBJ_COMPONENT SUBJ_OWNER_TBL SUBJ_WORKLD_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 SUBJECT Character(8) VARCHAR2(8) NOT NULL Subject Area
    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: SUBJECT_TBL.DESCR

    7 ACAD_ORG Character(10) VARCHAR2(10) NOT NULL Academic Organization

    Prompt Table: ACAD_ORG_TBL_VW

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

    Y/N Table Edit

    Default Value: N

    9 EXT_SUBJECT_AREA Character(4) VARCHAR2(4) NOT NULL External Subject Area

    Prompt Table: EXT_SUBJECT_TBL

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

    Prompt Table: CIP_CODE_TBL

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

    Prompt Table: HEGIS_CODE_TBL

    12 DESCRFORMAL Character(50) VARCHAR2(50) NOT NULL Formal Description field

    Default Value: SUBJECT_TBL.DESCR

    13 USE_BLIND_GRADING Character(1) VARCHAR2(1) NOT NULL Use Blind Grading

    Y/N Table Edit

    Default Value: N

    14 STUDY_FIELD Character(10) VARCHAR2(10) NOT NULL Field of Study

    Prompt Table: STUDY_FIELD_TBL