EXT_ACAD_SUM

(SQL Table)
 Index Back

External Academic Summary

EXT_ACAD_SUM is used to record academic information for a person by school.

  • 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_SUMM_TYPE Character(4) VARCHAR2(4) NOT NULL Summary Type

    Prompt Table: EXT_SUMM_TP_TBL

    6 EXT_ACAD_LEVEL Character(4) VARCHAR2(4) NOT NULL External Academic Level
    0=Unknown
    01=Pre-Eighth Grade
    1=Eighth Grade
    2=Ninth Grade
    3=Tenth Grade
    4=Eleventh Grade
    5=Twelfth Grade
    6=Postsecondary First Year
    7=Postsecondary Sophomore
    8=Postsecondary Junior
    9=Postsecondary Senior
    90=Post-Secondary
    91=Postsecondary Professional
    92=Postsecondary Master
    93=Postsecondary Doctoral
    94=Postdoctoral
    A1=Basic User/Breakthrough (NLD)
    A2=Basic User/Waystage (NLD)
    B1=Independ. User/Threshold (NLD)
    B2=Independ. User/Vantage (NLD)
    C1=Prof. User/Effective (NLD)
    C2=Proficient User/Master (NLD)

    Default Value: EXT_ACAD_DATA.EXT_ACAD_LEVEL

    7 TERM_YEAR Number(4,0) SMALLINT NOT NULL Term Year

    Default Value: EXT_ACAD_DATA.TERM_YEAR

    8 EXT_TERM_TYPE Character(4) VARCHAR2(4) NOT NULL External Term Type
    1YR=Full Year
    MINI=Miniterm
    OTHR=Other
    QTR=Quarter
    QUIN=Quinmester
    SEM=Semester
    TRIM=Trimester
    UNKN=Unknown

    Default Value: EXT_ACAD_DATA.EXT_TERM_TYPE

    9 EXT_TERM Character(4) VARCHAR2(4) NOT NULL External Term
    FALL=Fall
    SPR=Spring
    SUMR=Summer
    WINT=Winter

    Default Value: EXT_ACAD_DATA.EXT_TERM

    Prompt Table: EXT_TERM_TBL

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    11 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

    12 UNT_ATMP_TOTAL Number(8,2) DECIMAL(7,2) NOT NULL Total Units Attempted
    13 UNT_COMP_TOTAL Number(8,2) DECIMAL(7,2) NOT NULL Total Completed Units
    14 CLASS_RANK Number(5,0) INTEGER NOT NULL Class Rank
    15 CLASS_SIZE Number(5,0) INTEGER NOT NULL Class Size
    16 GPA_TYPE Character(4) VARCHAR2(4) NOT NULL GPA Type

    Default Value: ORG_INST_TBL.GPA_TYPE

    Prompt Table: GPA_TYPE_TBL

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

    Prompt Table: GPA_VALUE_TBL

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

    Prompt Table: GPA_RULES_TBL

    19 PERCENTILE Number(3,0) SMALLINT NOT NULL Percentile
    20 RANK_TYPE Character(3) VARCHAR2(3) NOT NULL Rank Type
    UNW=Unweighted
    WGT=Weighted