ALL_CRS_SRCH_VW

(SQL View)
 Index Back

Active Course Search Vw

This record is a search view that selects all courses from COURSE_TBL .

SELECT COURSE ,DESCR ,INTERNAL_EXTERNAL ,COURSE_TYPE ,CREATION_DT FROM PS_COURSE_TBL

  • Related Language Record: ALL_CRS_S_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code

    Prompt Table: TRN_CAT_PRMP_VW

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 INTERNAL_EXTERNAL Character(1) VARCHAR2(1) NOT NULL Internal/External
    E=External
    I=Internal

    Default Value: I

    4 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

    5 CREATION_DT Date(10) DATE Creation Date