SSR_SSTEXTID_V2

(SQL View)
Index Back

Text Catalog

View of Configured Text Ids

SELECT A.OBJECTOWNERID , A.HR_SSTEXT_SUB_ID , A.TEXT_ID , B.EFFDT , A.DESCR254_MIXED , B.HR_SSTEXT_TEXT FROM PS_HR_SSTEXT_MSGID A , PS_HR_SSTEXT_TEXT B WHERE B.OBJECTOWNERID = A.OBJECTOWNERID AND B.HR_SSTEXT_SUB_ID = A.HR_SSTEXT_SUB_ID AND B.TEXT_ID = A.TEXT_ID

  • Related Language Record: SSR_SSTEXTID_L2
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SSR_GR_OBJOWNR_ID2 Character(4) VARCHAR2(4) NOT NULL Object Owner ID
    2 SSR_GR_TXTSUB_ID2 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.
    3 SSR_GR_PGTEXTIDIN2 Character(18) VARCHAR2(18) NOT NULL Text ID
    4 EFFDT Date(10) DATE Effective Date

    Default Value: %date

    5 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
    6 HR_SSTEXT_TEXT Long Character(8095) CLOB Long Text field for HR Self-Service Text Catalog. This is the text that is displayed on a page from the Text Catalog.