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

HSC_SRCFLD_VW

(SQL View)

Prompt tbl source mask field

SQL view is used as a Prompt table is used to list all fields of the source 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 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

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	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
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