COURSE_TBL_VW

(SQL View)
 Index Back

Training Courses

Use COURSE_TBL_VW to view 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.

SELECT COURSE , DESCR , DESCRSHORT , COURSE_STATUS , CREATION_DT , COURSE_TYPE , CRSE_MULTILNG_SW , INTERNAL_EXTERNAL , SCHOOL_CODE , SESSN_ADMINISTRATN FROM PS_COURSE_TBL WHERE COURSE_STATUS ='A'

  • Related Language Record: COURSE_TBL_LNG1

    • # 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 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

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

    Y/N Table Edit

    Default Value: N

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

    Default Value: I

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

    Prompt Table: SCHOOL_TBL_VW3

    10 SESSN_ADMINISTRATN Character(1) VARCHAR2(1) NOT NULL Session Administration

    Y/N Table Edit

    Default Value: N