EXT_ACAD_SUBJ

(SQL Table)
Index Back

External Academic Subject

EXT_ACAD_SUBJ is used to record academic information by school and subject area for a person. There can be multiple EXT_ACAD_SUBJ records for every EXT_ACAD_SUM record.

  • Parent record: EXT_ACAD_DATA
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Default Value: SCC_PERS_SA_VW.EMPLID

    Prompt Table: PEOPLE_SRCH

    2 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Default Value: ACAD_HISTORY.EXT_ORG_ID

    Prompt Table: EXT_ORG_TBL

    3 EXT_CAREER Character(4) VARCHAR2(4) NOT NULL External Career
    GRAD=Graduate
    HS=High School
    LAW=Law
    MED=Medical
    UGRD=Undergraduate

    Default Value: EXT_ORG_TBL_ADM.EXT_CAREER

    4 EXT_DATA_NBR Number(3,0) SMALLINT NOT NULL External Data Nbr

    Default Value: EXT_ACAD_DATA.EXT_DATA_NBR

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

    Prompt Table: EXT_SUBJECT_TBL

    6 COURSE_LEVEL Character(2) VARCHAR2(2) NOT NULL Course Level
    11=Grade 11
    12=Grade 12
    AP=Advanced Placement
    DR=Graduate/Doctoral
    FR=Freshman
    GR=Graduate
    HN=Honors
    IB=International Baccalaureate
    JR=Junior
    LD=Lower Division
    MS=Graduate/Master
    RG=Regular
    SO=Sophomore
    SR=Senior
    UD=Upper Division
    7 UNT_ATMP_TOTAL Number(8,2) DECIMAL(7,2) NOT NULL Total Units Attempted
    8 UNT_COMP_TOTAL Number(8,2) DECIMAL(7,2) NOT NULL Total Completed Units
    9 TOTAL_CRSE_COMP Number(2,0) SMALLINT NOT NULL Total Courses Completed
    10 TOTAL_CRSE_ATMP Number(2,0) SMALLINT NOT NULL Total Courses Attempted
    11 GPA_TYPE Character(4) VARCHAR2(4) NOT NULL GPA Type

    Default Value: ORG_INST_TBL.GPA_TYPE

    Prompt Table: GPA_TYPE_TBL

    12 EXT_GPA Number(7,3) DECIMAL(6,3) NOT NULL External GPA

    Prompt Table: GPA_VALUE_TBL

    13 CONVERT_GPA Number(7,3) DECIMAL(6,3) NOT NULL Converted GPA

    Prompt Table: GPA_RULES_TBL

    14 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    15 UNT_TYPE Character(3) VARCHAR2(3) NOT NULL Unit Type
    ADU=Adult
    CAR=Carnegie Units
    CEU=Continuing Education Unit
    NCR=No Credit
    OTH=Non-Standard units
    QTR=Quarter Units
    SEM=Semester Units
    UKN=Unknown
    UNT=Units
    VOC=Vocational

    Default Value: EXT_ORG_TBL_ADM.UNT_TYPE