HRS_SSTEXT_VW3

(SQL View)
 Index Back

User Configurable Text - Effdt

Effective Dated view of Text Ids in the Text Catalog

SELECT A.HR_SSTEXT_SUB_ID , A.TEXT_ID , A.EFFDT , A.DESCR254_MIXED FROM PS_HR_SSTEXT_VW A WHERE A.OBJECTOWNERID = 'HRAM'

  • Related Language Record: HRS_SSTEXT3_LVW

  • Parent record: HR_SSTEXT_TEXT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 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.
    2 TEXT_ID Character(18) VARCHAR2(18) NOT NULL Text ID
    3 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    4 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description