TS_SSTEXT_VW (SQL View)	Index Back
Text Catalog View View to fetch text catalog entries configured for transaction summary set up.

TS_SSTEXT_VW

(SQL View)

Text Catalog View

View to fetch text catalog entries configured for transaction summary set up.

SELECT TEXT_ID , EFFDT , %Substring(%Cast(HR_SSTEXT_TEXT, LONG, CHARACTER), 1, 80) , HR_SSTEXT_TEXT FROM PS_HR_SSTEXT_TEXT WHERE OBJECTOWNERID = 'HFG' AND HR_SSTEXT_SUB_ID = 'TS'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 EFFDT Date(10) DATE Effective Date
Default Value: %date

3 TS_SS_TEXT Character(80) VARCHAR2(80) NOT NULL Text Catalog text

4 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	TEXT_ID	Character(18)	VARCHAR2(18) NOT NULL	Text ID
2	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
3	TS_SS_TEXT	Character(80)	VARCHAR2(80) NOT NULL	Text Catalog text
4	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.