HR_SSTEXT_EFFDT

(SQL Table)
Index Back

User Configurable Text - Effdt

  • Parent record: HR_SSTEXT_TEXT
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier

    Prompt Table: HR_TC_OO_VW

    2 HR_SSTEXT_SUB_ID Character(4) VARCHAR2(4) NOT NULL The Sub ID is field that is optionally used to further partition Text Catalog entries within an Object Owner ID. For example, we might want to create a Sub ID to keep Text Catalog entries for Enrollment separate from the Text Catalog entries for the inquiry pages within the eBenefits ObjectOwnerId.

    Prompt Table: HR_SSTEXT_OS_VW

    3 TEXT_ID Character(18) VARCHAR2(18) NOT NULL Text ID
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 SYSTEM_DATA_FLG Character(1) VARCHAR2(1) NOT NULL System Data

    Y/N Table Edit

    Default Value: N