PCMP_DEV_ACT_VW

(SQL View)
Index Back

Prof Comp Dev Activity View

Used in the Professional Compliance module. View of the General Activities used in the professional compliance process.

SELECT A.SETID ,A.PCMP_DEV_ACT ,A.PCMP_DEV_DESCR FROM PS_PCMP_DEV_ACT A

  • Related Language Record: PCMP_DVACTVWLNG
  • # 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

    2 PCMP_DEV_ACT Character(8) VARCHAR2(8) NOT NULL Used in the Professional Compliance module. Geberal Activity code used in development plans.
    3 PCMP_DEV_DESCR Character(30) VARCHAR2(30) NOT NULL Used in the Professional Compliance module. Development description.