SSR_SSTEXTID_V2(SQL View) |
Index Back |
---|---|
Text CatalogView 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 |
# | 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. |