HCR_WC_DCSG_LNI

(SQL View)
Index Back

Works Council Decision Group

Works Council Decision Group Related language Interface View

SELECT A.WC_DECISIONGRP_ID , A.LANGUAGE_CD , A.EFFDT , A.DESCR , A.DESCR50 FROM PS_WC_DECISGRP_LNG A

  • Related Language Record for HCR_WC_DCSGRP_I
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 WC_DECISIONGRP_ID Character(3) VARCHAR2(3) NOT NULL Decision ID. Used by the functionnality Works Council Notification (Recruit Workforce).
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR50 Character(50) VARCHAR2(50) NOT NULL Description of length 50