PCMP_DVACPVWLNG

(SQL View)
 Index Back

Prof Comp Dev Accomplishments

Used in the Professional Compliance module. Related language view of Accomplishments used in the professional compliance process.

SELECT A.SETID ,A.ACCOMPLISHMENT ,B.LANGUAGE_CD ,B.DESCR FROM PS_PCMP_DEV_ACPS A ,PS_ACCOMP_TBL_LANG B WHERE B.ACCOMPLISHMENT=A.ACCOMPLISHMENT

  • Related Language Record for PCMP_DEVACPS_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 ACCOMPLISHMENT Character(8) VARCHAR2(8) NOT NULL Accomplishment

    Prompt Table: ACCOMP_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.