HCSC_RTG_KEY_VW (SQL View)	Index Back
Keys for Ratings Fieldnames Use this view to select all the key fields that the Ratings corss-reference table defines.

HCSC_RTG_KEY_VW

(SQL View)

Keys for Ratings Fieldnames

Use this view to select all the key fields that the Ratings corss-reference table defines.

SELECT D.RECNAME , D.FIELDNAME , D.FIELDNUM , K.INDEXID , D.SUBRECORD FROM PSRECFIELD D , PSRECFIELD F LEFT OUTER JOIN PSKEYDEFN K ON F.RECNAME = K.RECNAME AND K.FIELDNAME = F.FIELDNAME WHERE D.RECNAME = F.RECNAME AND D.FIELDNAME = F.FIELDNAME

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

3 FIELDNUM Number(4,0) SMALLINT NOT NULL Field Number

4 INDEXID Character(1) VARCHAR2(1) NOT NULL Index Identifier

5 SUBRECORD Character(1) VARCHAR2(1) NOT NULL Sub Record

#	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).
3	FIELDNUM	Number(4,0)	SMALLINT NOT NULL	Field Number
4	INDEXID	Character(1)	VARCHAR2(1) NOT NULL	Index Identifier
5	SUBRECORD	Character(1)	VARCHAR2(1) NOT NULL	Sub Record