COURSE_TBL

(SQL Table)
 Index Back

Training Courses

Use COURSE_TBL to record data about training courses you want to track in your database. This record contains high-level information about a course; specific information about course 'sessions' is found in other records such as CRSE_SESSN_TBL, CRSE_SESSN_COST, and CRSE_SESS_INSTR. These records belong to the Training Administration application. You can create only one COURSE_TBL record per course code.

  • Related Language Record: COURSE_TBL_LANG

  • Parent Record Of COURSE_COMPS COURSE_COMPS_VW COURSE_EQUIP COURSE_INS_ACPS COURSE_INS_CMPS COURSE_LANGUAGE COURSE_LICENSE CRSE_DESCR_TYPE CRSE_LICENSE_VW CRSE_SESSN_E_VW CRSE_SESSN_TBL CRSE_SESS_PROVD TN_COURCOMP_LNG TRN_COURS_COMPL TRN_PREREQ_CRSE TRN_PREREQ_VW TRN_SESSN_COMPL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code
    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
    4 COURSE_STATUS Character(1) VARCHAR2(1) NOT NULL Course Status
    A=Active
    I=Inactive
    P=Proposed

    Default Value: A

    5 CREATION_DT Date(10) DATE Creation Date

    Default Value: %date

    6 REVISION_DT Date(10) DATE Revision Date
    7 COURSE_TYPE Character(1) VARCHAR2(1) NOT NULL Course Type
    C=Continuing Education
    D=Skill Development
    E=Experience Validation
    F=Functional
    M=Management Development
    O=Competency check
    S=Supervisory Skills
    T=Technical

    Default Value: C

    8 CRSE_MULTILNG_SW Character(1) VARCHAR2(1) NOT NULL Multilingual Course

    Y/N Table Edit

    Default Value: N

    9 PRIMARY_DEL_METHOD Character(1) VARCHAR2(1) NOT NULL Primary Delivery Method
    A=Audio
    C=Computer Assisted
    I=Instructor Led
    O=On-the-Job Training
    V=Video
    W=Workbook

    Default Value: I

    10 INSTR_CMPS_ACP_SW Character(1) VARCHAR2(1) NOT NULL Instructor Comps/Accomps Req

    Y/N Table Edit

    Default Value: N

    11 INTERNAL_EXTERNAL Character(1) VARCHAR2(1) NOT NULL Internal/External
    E=External
    I=Internal

    Default Value: I

    12 DURATION_TIME Number(6,1) DECIMAL(5,1) NOT NULL Duration Time
    13 DURATION_CONVERTED Number(6,1) DECIMAL(5,1) NOT NULL Converted Duration
    14 COST_UNIT_CD Character(10) VARCHAR2(10) NOT NULL Cost Unit

    Default Value: H

    Prompt Table: DT_COST_UNIT_VW

    15 SCHOOL_CODE Character(10) VARCHAR2(10) NOT NULL School Code

    Prompt Table: SCHOOL_TBL_VW3

    16 SCHOOL Character(30) VARCHAR2(30) NOT NULL School Name
    17 SESSN_ADMINISTRATN Character(1) VARCHAR2(1) NOT NULL Session Administration

    Y/N Table Edit

    Default Value: N

    18 MIN_STUDENTS Number(3,0) SMALLINT NOT NULL Minimum Nbr of Students
    19 MAX_STUDENTS Number(3,0) SMALLINT NOT NULL Maximum Nbr of Students
    20 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: OPR_DEF_TBL_HR.EXCHNG_TO_CURRENCY

    Prompt Table: CURRENCY_CD_TBL

    21 EDUCATION_UNITS Number(5,1) DECIMAL(4,1) NOT NULL Course Units
    22 NON_CATALOGUED Character(1) VARCHAR2(1) NOT NULL Not in Catalog

    Y/N Table Edit

    Default Value: N

    23 COURSE_OFFERING Character(1) VARCHAR2(1) NOT NULL Course Offering
    A=Annually
    H=Half-Yearly
    M=Monthly
    Q=Quarterly
    R=As Required
    S=Semester
    T=Trimester

    Default Value: Q

    24 TRN_IMPUTABLE_FLG Character(1) VARCHAR2(1) NOT NULL Chargeable

    Y/N Table Edit

    Default Value: N

    25 TRN_EDDF_FLG Character(1) VARCHAR2(1) NOT NULL French Report 2483 : EDDF Course

    Y/N Table Edit

    Default Value: N

    26 TRN_TIME_REQ_FRA Number(2,0) SMALLINT NOT NULL Time Required to be Chargeable
    27 TRN_DIF_FRA_FLG Character(1) VARCHAR2(1) NOT NULL Field for Training DIF

    Y/N Table Edit

    Default Value: N