COURSE_E_VW

(SQL View)
 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.

SELECT COURSE , DESCR , DESCRSHORT , COURSE_STATUS , CREATION_DT , REVISION_DT , COURSE_TYPE , CRSE_MULTILNG_SW , PRIMARY_DEL_METHOD , INSTR_CMPS_ACP_SW , INTERNAL_EXTERNAL , DURATION_TIME , DURATION_CONVERTED , COST_UNIT_CD , SCHOOL_CODE , SCHOOL , SESSN_ADMINISTRATN , MIN_STUDENTS , MAX_STUDENTS , CURRENCY_CD , EDUCATION_UNITS , NON_CATALOGUED , COURSE_OFFERING , TRN_IMPUTABLE_FLG , TRN_EDDF_FLG , TRN_TIME_REQ_FRA , TRN_DIF_FRA_FLG FROM PS_COURSE_TBL

  • Related Language Record: COURSE_TBL_ELNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COURSE Character(6) VARCHAR2(6) NOT NULL Catalog Item
    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 Catalog Item 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 Reqd

    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