HR_MSS_CT_DS

(SQL Table)
Index Back

Guided Self Service DS

  • Parent record: HR_MSS_CT_CFG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 HR_MSS_CT_NAME Character(25) VARCHAR2(25) NOT NULL Compound Transaction Name

    Default Value: HR_MSS_CT_CFG.HR_MSS_CT_NAME

    2 REG_REGION Character(5) VARCHAR2(5) NOT NULL Regulatory Region

    Default Value: HR_MSS_CT_CFG.REG_REGION

    Prompt Table: REG_STANDARD_VW

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: HR_MSS_CT_CFG.EFFDT

    4 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

    Prompt Table: PSMSGSETDEFN

    5 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

    Prompt Table: PSMSGCATDEFN

    6 SEQUENCE Number(2,0) SMALLINT NOT NULL Chartfield Sequence
    7 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL This Y/ N field is used to identify which rows in a table are considered SYSTEM DATA.

    Default Value: N