HSC_RECFLD_VW (SQL View)	Index Back
Prompt tbl Process mask field SQL view is used as a Prompt table is used to list all fields of the process record for mapping mask fields on Define Process Record page .This view is used by Encryption Configuration Framework.

HSC_RECFLD_VW

(SQL View)

Prompt tbl Process mask field

SQL view is used as a Prompt table is used to list all fields of the process record for mapping mask fields on Define Process Record page .This view is used by Encryption Configuration Framework.

SELECT RECNAME , FIELDNAME , USEEDIT FROM PSRECFIELDDB

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 HSC_MASKREC Character(15) VARCHAR2(15) NOT NULL Application Process Record

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

3 USEEDIT Number(10,0) DECIMAL(10) NOT NULL Field Use and Edit Flags- USEEDIT reference

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	HSC_MASKREC	Character(15)	VARCHAR2(15) NOT NULL	Application Process Record
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
3	USEEDIT	Number(10,0)	DECIMAL(10) NOT NULL	Field Use and Edit Flags- USEEDIT reference