HSC_SRKEYFLD_VW (SQL View)	Index Back
Prompt table source key field SQL view is used as a Prompt table is used to list all key fields of source record on Map Key secondary page . This secondary page is accesed by Map Key hyperlink present on Define Process Record page when data set selected is of type join source .This view is used by Encryption Configuration Framework.

HSC_SRKEYFLD_VW

(SQL View)

Prompt table source key field

SQL view is used as a Prompt table is used to list all key fields of source record on Map Key secondary page . This secondary page is accesed by Map Key hyperlink present on Define Process Record page when data set selected is of type join source .This view is used by Encryption Configuration Framework.

SELECT RECNAME , KEYPOSN , FIELDNAME FROM PSKEYDEFN WHERE INDEXID = '_'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFNPVW

2 KEYPOSN Number(3,0) SMALLINT NOT NULL Key Position

3 HSC_SRCKEY Character(18) VARCHAR2(18) NOT NULL Source Record Key

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN). Prompt Table: PSRECDEFNPVW
2	KEYPOSN	Number(3,0)	SMALLINT NOT NULL	Key Position
3	HSC_SRCKEY	Character(18)	VARCHAR2(18) NOT NULL	Source Record Key