HR_TBH_TXTID_VW (SQL View)	Index Back
User Configurable Text Template-based Hire User Configurable Text.

HR_TBH_TXTID_VW

(SQL View)

User Configurable Text

Template-based Hire User Configurable Text.

SELECT HR_SSTEXT_KEY1 , HR_SSTEXT_KEY2 , TEXT_ID , EFFDT , %Sql(HR_LONG_TO_CHAR254, HR_SSTEXT_TEXT) , HR_SSTEXT_TEXT FROM PS_HR_SSTEXT_TEXT WHERE OBJECTOWNERID = 'HHR' AND HR_SSTEXT_SUB_ID = 'TBH'

Related Language Record: HR_TBH_TXTIDVWL

# 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.

2 HR_SSTEXT_KEY2 Character(30) VARCHAR2(30) NOT NULL 2nd Level generic Self-Service text key.

3 TEXT_ID Character(18) VARCHAR2(18) NOT NULL Text ID

4 EFFDT Date(10) DATE NOT NULL Effective Date
Default Value: %date

5 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.

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.

#	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.
2	HR_SSTEXT_KEY2	Character(30)	VARCHAR2(30) NOT NULL	2nd Level generic Self-Service text key.
3	TEXT_ID	Character(18)	VARCHAR2(18) NOT NULL	Text ID
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date Default Value: %date
5	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.
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.