COURSE_SRCH_EVW

(SQL View)
 Index Back

Active Course Search Vw

COURSE_SRCH_VW belongs to the Training Administration application. This record is a search view that selects only those course sessions from COURSE_TBL that are active (session status = 'A') and that are being administered in-house (rather than by an outside agency such as a university).

SELECT COURSE ,DESCR ,INTERNAL_EXTERNAL ,COURSE_TYPE ,CREATION_DT FROM PS_COURSE_TBL WHERE SESSN_ADMINISTRATN = 'Y' AND COURSE_STATUS = 'A'

  • Related Language Record: COURSE_SRCH_LNG

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

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

    5 CREATION_DT Date(10) DATE Creation Date