TN_COURCOMP_LNG

(SQL View)
 Index Back

Training Course Completed Vw

CRSE_SESSN_TBL contains one record for each session of an in-house administered course. Sessions are automatically assigned a sequence number within course. This record is part of the Training Administration module.

SELECT DISTINCT A.BUDGET_PERIOD , B.COURSE , C.LANGUAGE_CD , C.DESCR FROM PS_BUDGET_PERIOD A , PS_CRSE_SESSN_TBL B , PS_COURSE_TBL_LANG C WHERE B.SESSION_STATUS = 'C' AND A.EFFDT <= B.COURSE_START_DT AND A.EFFDT <= B.COURSE_END_DT AND A.THRU_DATE >= B.COURSE_START_DT AND A.THRU_DATE >= B.COURSE_END_DT AND B.COURSE = C.COURSE

  • Related Language Record for TRN_COURS_COMPL

  • Parent record: COURSE_TBL

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

    Prompt Table: CRSE_SESSN_SRCH

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description