PCMP_DVCRSVWLNG

(SQL View)
 Index Back

Prof Comp Dev Courses

Used in the Professional Compliance module. Relared language view of Training Courses used in the professional compliance process.

SELECT A.SETID ,A.COURSE ,B.LANGUAGE_CD ,B.DESCR FROM PS_PCMP_DEV_CRSE A ,PS_COURSE_TBL_LANG B WHERE B.COURSE=A.COURSE

  • Related Language Record for PCMP_DEVCRSE_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SETID_TBL

    2 COURSE Character(6) VARCHAR2(6) NOT NULL Course Code

    Prompt Table: COURSE_TBL

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 PCMP_DEV_DESCR Character(30) VARCHAR2(30) NOT NULL Used in the Professional Compliance module. Development description.