RB_TD_CATFLD_VW (SQL View)	Index Back
Record Field View Record Field View to get the fields in the record identified by the field ACTION_CAT_REC.

RB_TD_CATFLD_VW

(SQL View)

Record Field View

Record Field View to get the fields in the record identified by the field ACTION_CAT_REC.

SELECT A.RECNAME ,A.FIELDNAME FROM PSRECFIELDALL A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 ACTION_CAT_REC Character(18) VARCHAR2(18) NOT NULL This field stores the category record value in the Action Category Definition.

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

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	ACTION_CAT_REC	Character(18)	VARCHAR2(18) NOT NULL	This field stores the category record value in the Action Category Definition.
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).