HR_SSTEXT_K6_VW (SQL View)	Index Back
Text Catalog Key6 View Used as a prompt table for Key 6. Displays all fields in record identified "Key 6 Prompt Table".

HR_SSTEXT_K6_VW

(SQL View)

Text Catalog Key6 View

Used as a prompt table for Key 6. Displays all fields in record identified "Key 6 Prompt Table".

SELECT RECNAME , FIELDNAME FROM PSRECFIELDALL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HR_SSTEXT_KEY6_REC Character(15) VARCHAR2(15) NOT NULL HR Self-Service Text Catalog - stores the prompt table for Key 6

2 HR_SSTEXT_KEY6_FLD Character(18) VARCHAR2(18) NOT NULL HR Self-Service Text Catalog - stores the prompt field name for Key 6.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HR_SSTEXT_KEY6_REC	Character(15)	VARCHAR2(15) NOT NULL	HR Self-Service Text Catalog - stores the prompt table for Key 6
2	HR_SSTEXT_KEY6_FLD	Character(18)	VARCHAR2(18) NOT NULL	HR Self-Service Text Catalog - stores the prompt field name for Key 6.