HR_MSS_CT_SRCH

(SQL View)
Index Back

Guided Self Service Setup

Configuration for guided self service.

SELECT DISTINCT HR_MSS_CT_NAME , EFFDT , STATUS , DESCR50 FROM PS_HR_MSS_CT_CFG

  • Related Language Record: HR_MSS_CT_LSRCH
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HR_MSS_CT_NAME Character(25) VARCHAR2(25) NOT NULL Compound Transaction Name
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 STATUS Character(1) VARCHAR2(1) NOT NULL Status Indicator
    A=Active
    I=Inactive

    Default Value: A

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