EXT_ACAD_DATA

(SQL Table)
 Index Back

External Academic Data

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

  • Parent record: ACAD_HISTORY

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

    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
    5 LS_DATA_SOURCE Character(3) VARCHAR2(3) NOT NULL Data Source
    A8=TEAS Degree Information
    AAD=AADSAS
    ACT=American College Testing
    AE=Ad-Hoc Employee
    AMC=AMCAS
    AO=Ad-Hoc Organizational
    E=Extract
    ETS=Educational Testing Service
    GH=OLSAS Last Secondary-G2
    LSD=LSDAS
    PI=Prev/Post Secondary Info
    RS=OLSAS Postsecondary Info
    SCH=School
    SLF=Self-Reported Information
    WWW=World Wide Web

    Default Value: OPR_DEF_TBL_CS.DATA_SOURCE_RCVD

    6 TRANSCRIPT_FLAG Character(1) VARCHAR2(1) NOT NULL Transcript Action
    D=Desired
    R=Received

    Default Value: D

    7 TRANSCRIPT_TYPE Character(3) VARCHAR2(3) NOT NULL Transcript Type
    OFF=Official
    UNO=Unofficial

    Default Value: OPR_DEF_TBL_CS.TRANSCRIPT_TYPE

    8 TRNSCRPT_STATUS Character(1) VARCHAR2(1) NOT NULL Transcript Status
    F=Final
    I=Incomplete
    M=Mid-Year Report
    W=Work in Progress
    9 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: 0

    10 TRANSCRIPT_DT Date(10) DATE Transcript Date

    Default Value: %date

    11 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_ORG_TBL_ADM.EXT_TERM_TYPE

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

    Prompt Table: EXT_TERM_TBL

    13 TERM_YEAR Number(4,0) SMALLINT NOT NULL Term Year
    14 RECEIVED_DT Date(10) DATE Certificate Received Date
    15 DATA_MEDIUM Character(1) VARCHAR2(1) NOT NULL Data Medium
    E=EDI
    H=Hard Copy

    Default Value: OPR_DEF_TBL_CS.DATA_MEDIUM_RCVD

    16 FROM_DT Date(10) DATE From Date
    17 TO_DT Date(10) DATE To Date
    18 ACAD_LOAD_APPR Character(1) VARCHAR2(1) NOT NULL Approved Academic Load
    B=Vocational Coaching (NLD)
    D=Dual (NLD)
    E=Part-time Vocational Tr (NLD)
    F=Full-Time
    O=Vocational Training (NLD)
    P=Part-Time
    19 SAD_DISMISSED Character(1) VARCHAR2(1) NOT NULL Dismissed from School

    Y/N Table Edit

    20 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    21 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    22 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    23 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time