This view selects the fields that belong to the COMM_SPDKEY_TBL for use in prompting correct values on the Event Definition Setup - Comm Key Joint Rules page

EVNT_JR_CK_VW

(SQL View)

Index Back

SELECT RECNAME ,FIELDNAME FROM PSRECFIELD WHERE RECNAME = 'COMM_SPDKEY_TBL' AND FIELDNAME IN ('COMM_CATEGORY', 'COMM_CONTEXT', 'COMM_METHOD', 'COMM_DIRECTION', 'SCC_LETTER_CD')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 COMPARE_FLD Character(18) VARCHAR2(18) NOT NULL Used to capture the Variable Data table(s) field names and the Comm Key table(s) field names.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	COMPARE_FLD	Character(18)	VARCHAR2(18) NOT NULL	Used to capture the Variable Data table(s) field names and the Comm Key table(s) field names.