ADM_T189_CRS_EC

(SQL Table)
 Index Back

Adm Applicant Crs EC

Admissions Application Electronic Commerce EDI Staging Table. Course record for TS189 Applicant transactions. Use ADM_T189_CRS_EC to store external courses a student has taken, and the data source (Application).

  • Parent record: ADM_T189_SES_EC

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ECTRANSID Character(15) VARCHAR2(15) NOT NULL Electronic Commerce Transaction ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. ECTRANSID in EDI Manager identifies a transaction type(like "PO" for Purchase Orders)
    2 ECQUEUEINSTANCE Number(9,0) DECIMAL(9) NOT NULL Electronic Commerce Queue Instance ID. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables.
    3 ECTRANSINOUTSW Character(1) VARCHAR2(1) NOT NULL Electronic Commerce Inbound/Outbound Switch. Used in EDI Manager. One of three(3) Key Fields(ECTRANSID, ECTRANSINOUTSW, ECQUEUEINSTANCE) used in Electronic Commerce(EC) Staging Tables. The field value is "I" for Inbound Transactions, and "O" for Outbound.
    I=Inbound
    O=Outbound

    Default Value: I

    4 TRANS_CNTRL_NBR Character(9) VARCHAR2(9) NOT NULL Transaction Set Control Number
    5 SEQNUM Number(3,0) SMALLINT NOT NULL Sequence Number
    6 SES_NUMBER Number(3,0) SMALLINT NOT NULL Session Number
    7 EXT_COURSE_NBR Number(3,0) SMALLINT NOT NULL External Course Number
    8 SCHOOL_SUBJECT Character(8) VARCHAR2(8) NOT NULL School Subject

    Prompt Table: SCHOOL_SUBJ_TBL

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

    Prompt Table: SCHOOL_CRSE_TBL

    10 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    11 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
    12 BEGIN_DT Date(10) DATE Begin Date
    13 END_DT Date(10) DATE end date
    14 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
    15 EDI_UNT_TAKEN Character(6) VARCHAR2(6) NOT NULL Units Taken
    16 GRADING_SCHEME Character(3) VARCHAR2(3) NOT NULL Grading Scheme

    Prompt Table: GRADESCHEME_TBL

    17 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

    18 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
    19 CRSE_GRADE_INPUT Character(3) VARCHAR2(3) NOT NULL Grade Input
    A=A
    20 EXT_SUBJECT_AREA Character(4) VARCHAR2(4) NOT NULL External Subject Area

    Prompt Table: EXT_SUBJECT_TBL

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

    Prompt Table: EXT_TERM_TBL

    23 TERM_YEAR Number(4,0) SMALLINT NOT NULL Term Year
    24 EDI_CRSE_NBR Character(10) VARCHAR2(10) NOT NULL Inbound Course Number
    25 EDI_DESCR Character(30) VARCHAR2(30) NOT NULL EDI Description Field
    26 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
    27 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    28 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

    29 COURSE_ERROR Character(1) VARCHAR2(1) NOT NULL Course Error

    Y/N Table Edit

    Default Value: N

    30 COURSE_PST Character(1) VARCHAR2(1) NOT NULL Course Post

    Y/N Table Edit

    Default Value: N

    31 EDI_UNT Character(6) VARCHAR2(6) NOT NULL Course Units
    32 REPEAT_CD_IND Character(1) VARCHAR2(1) NOT NULL Repeat Code Indicator
    N=Repeated, Not Counted
    R=Repeated, Counted
    X=Other, not counted
    33 GPA_QUAL_PTS Character(6) VARCHAR2(6) NOT NULL Quality Points
    34 TRANS_ROW_ID Character(3) VARCHAR2(3) NOT NULL Transaction Row ID