SCC_STG_EXACDSM

(SQL Table)
 Index Back

External Academic Summary

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

  • Parent record: SCC_STG_EXACDDT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_TEMP_ID Number(16,0) DECIMAL(16) NOT NULL Temp Constituent ID
    2 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
    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_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Default Value: SCC_STG_ACADHST.EXT_ORG_ID

    Prompt Table: EXT_ORG_TBL

    7 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

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

    Default Value: EXT_ACAD_DATA.TERM_YEAR

    9 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

    10 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

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

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    12 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

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

    Default Value: ORG_INST_TBL.GPA_TYPE

    Prompt Table: GPA_TYPE_TBL

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

    Prompt Table: GPA_VALUE_TBL

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

    Prompt Table: GPA_RULES_TBL

    20 PERCENTILE Number(3,0) SMALLINT NOT NULL Percentile
    21 RANK_TYPE Character(3) VARCHAR2(3) NOT NULL Rank Type
    UNW=Unweighted
    WGT=Weighted
    22 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    23 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    24 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    25 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time