HR_SSTEXT_KEY1Prompt Table: %EDITTABLE
HR_SSTEXT_KEY2Prompt Table: %EDITTABLE2
TEXT_IDLANGUAGE_CDEFFDTDefault Value: %date
HR_TBH_TXTIDVWL(SQL View) |
Index Back |
|---|---|
User Configurable TextRelated-language record for the Template-based Hire User Configurable Text view. |
| SELECT HR_SSTEXT_KEY1 , HR_SSTEXT_KEY2 , TEXT_ID , LANGUAGE_CD , EFFDT , %Sql(HR_LONG_TO_CHAR254, HR_SSTEXT_TEXT) , HR_SSTEXT_TEXT FROM PS_HR_SSTEXT_LANG WHERE OBJECTOWNERID = 'HHR' AND HR_SSTEXT_SUB_ID = 'TBH' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | HR_SSTEXT_KEY1 |
Character(30) | VARCHAR2(30) NOT NULL |
1st level generic key for Self-Service Text Catalog.
Prompt Table: %EDITTABLE |
| 2 | HR_SSTEXT_KEY2 |
Character(30) | VARCHAR2(30) NOT NULL |
2nd Level generic Self-Service text key.
Prompt Table: %EDITTABLE2 |
| 3 | TEXT_ID |
Character(18) | VARCHAR2(18) NOT NULL | Text ID |
| 4 | LANGUAGE_CD |
Character(3) | VARCHAR2(3) NOT NULL | Language Code |
| 5 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 6 | TBH_DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Used to store the first 254 characters of the text catalog text value to be used in a search view. |
| 7 | 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. |