SCC_STG_EXTCRS

(SQL Table)
 Index Back

External Courses

EXT_COURSE staging record

  • Parent record: SCC_STG_ACADHST

    • # 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_COURSE_NBR Number(3,0) SMALLINT NOT NULL External Course Number
    4 EXT_ORG_ID Character(11) VARCHAR2(11) NOT NULL External Org ID

    Default Value: SCC_STG_ACADHST.EXT_ORG_ID

    5 EXT_CRSE_TYPE Character(3) VARCHAR2(3) NOT NULL External Course Type
    C=Challenge
    CRS=Course
    E=Equivalency
    EVT=Event or Summary
    N/A=Course - Not Applicable
    REP=Course - Repeated
    WTH=Course - Withdrawn
    6 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
    7 EXT_DATA_NBR Number(3,0) SMALLINT NOT NULL External Data Nbr
    8 BEGIN_DT Date(10) DATE Begin Date
    9 END_DT Date(10) DATE end date
    10 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
    11 UNT_TAKEN Number(6,2) DECIMAL(5,2) NOT NULL Units Taken
    12 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme

    Prompt Table: GRADESCHEME_TBL

    13 GRADING_BASIS Character(3) VARCHAR2(3) NOT NULL Grading Basis
    ANC=ABC/NC Grading
    AUD=Audit
    BMT=Multi-Term Course: Not Graded
    CNC=Credit / No Credit
    EQV=Equivalent
    GRD=Graded
    HSC=Hundred Point Scale (NLD)
    LAW=Law
    MED=Medical School Grades
    NOG=No Grade Associated
    NON=Non-Graded Component
    NQF=NQF Scale
    OPT=Student Option
    PNP=Pass/Not Pass
    SUS=Satisfactory/Unsatisfactory
    TRN=Transfer Grading Basis
    TSC=Ten Point Scale (NLD)

    Prompt Table: GRADE_BASIS_TBL

    14 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
    15 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
    A=A

    Prompt Table: %EDITTABLE5

    16 CRSE_GRADE_OFF Character(3) VARCHAR2(3) NOT NULL Official Grade

    Prompt Table: %EDITTABLE6

    17 SCHOOL_SUBJECT Character(8) VARCHAR2(8) NOT NULL School Subject

    Prompt Table: %EDITTABLE7

    18 SCHOOL_CRSE_NBR Character(10) VARCHAR2(10) NOT NULL School Course Nbr

    Prompt Table: %EDITTABLE8

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

    Default Value: SCHOOL_CRSE_TBL.EXT_SUBJECT_AREA

    Prompt Table: EXT_SUBJECT_TBL

    20 EXT_CAREER Character(4) VARCHAR2(4) NOT NULL External Career
    GRAD=Graduate
    HS=High School
    LAW=Law
    MED=Medical
    UGRD=Undergraduate
    21 EXT_TERM Character(4) VARCHAR2(4) NOT NULL External Term
    FALL=Fall
    SPR=Spring
    SUMR=Summer
    WINT=Winter

    Prompt Table: EXT_TERM_TBLV2

    22 TERM_YEAR Number(4,0) SMALLINT NOT NULL Term Year
    23 DESCR Character(30) VARCHAR2(30) NOT NULL Description

    Default Value: SCHOOL_CRSE_TBL.DESCR

    24 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
    25 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

    26 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)
    27 TRANS_CREDIT_FLAG Character(1) VARCHAR2(1) NOT NULL Transfer Credit

    Y/N Table Edit

    Default Value: Y

    28 CAN_TRNS_TYPE Character(2) VARCHAR2(2) NOT NULL Transfer Credit Type Sac-r75-19990831
    01=Other Inst w/o Permission
    02=Other Inst W/Permission
    10=Domestic Exchange Program
    11=Foreign Exchange Program
    20=PLA/Skill Rating assessment
    80=More Than One of The Above
    96=Other
    99=Unknown Type of Transfer Credt
    29 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

    Default Value: %datetime

    30 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    31 SCC_ROW_ADD_OPRID Character(30) VARCHAR2(30) NOT NULL Created By
    32 SCC_ROW_ADD_DTTM DateTime(26) TIMESTAMP Created
    33 SCC_ROW_UPD_OPRID Character(30) VARCHAR2(30) NOT NULL Updated By
    34 SCC_ROW_UPD_DTTM DateTime(26) TIMESTAMP Last Update Date/Time