RCHCM_TYPE

(SQL View)
 Index Back

HR HD Contact Method Type

This view is used to retrieve HR HelpDesk Contact Method Types.

SELECT CM_TYPE_ID , DESCR , DESCRSHORT FROM PS_CM_TYPE WHERE CM_TYPE_ID IN (1, 2, 4)

  • Related Language Record: RCHCM_TYPE_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 CM_TYPE_ID Number(6,0) INTEGER NOT NULL Contact Method Type ID

    Default Value: 999999

    2 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description