HCSC_RTG_FLD0VW (SQL View)	Index Back
Prompt for Fieldsnames This view selects the fieldnames on the Ratings Definition table. Use this view to prompt fieldnames when header or row details on the Ratings Framework.

HCSC_RTG_FLD0VW

(SQL View)

Prompt for Fieldsnames

This view selects the fieldnames on the Ratings Definition table. Use this view to prompt fieldnames when header or row details on the Ratings Framework.

SELECT RECNAME , FIELDNAME FROM PSRECFIELDALL

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HCSC_RTG_REC_XREF Character(15) VARCHAR2(15) NOT NULL Cross Reference Table

2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HCSC_RTG_REC_XREF	Character(15)	VARCHAR2(15) NOT NULL	Cross Reference Table
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).