EVNT_CK_CMP_VW (SQL View)	Index Back
Comm Key Joint Fields This view captures the current, active Joint Rules for the Comm Key chosen on a Event Definition.

EVNT_CK_CMP_VW

(SQL View)

Comm Key Joint Fields

This view captures the current, active Joint Rules for the Comm Key chosen on a Event Definition.

SELECT B.INSTITUTION , B.EVENT_3CS_ID ,B.COMM_KEY , B.COMPARE_FLD FROM PS_EVNT_COMM_TBL A ,PS_EVNT_JRULES_CK B WHERE A.INSTITUTION = B.INSTITUTION AND A.EVENT_3CS_ID = B.EVENT_3CS_ID AND A.EFFDT = B.EFFDT AND A.COMM_KEY = B.COMM_KEY AND A.EFFDT = ( SELECT MAX(A1.EFFDT) FROM PS_EVNT_3CS_TBL A1 WHERE A1.INSTITUTION = A.INSTITUTION AND A1.EVENT_3CS_ID = A.EVENT_3CS_ID AND A1.EFF_STATUS = 'A')

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

2 EVENT_3CS_ID Character(10) VARCHAR2(10) NOT NULL 3Cs event ID

3 COMM_KEY Character(8) VARCHAR2(8) NOT NULL Communication Speed Key

4 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	INSTITUTION	Character(5)	VARCHAR2(5) NOT NULL	Academic Institution
2	EVENT_3CS_ID	Character(10)	VARCHAR2(10) NOT NULL	3Cs event ID
3	COMM_KEY	Character(8)	VARCHAR2(8) NOT NULL	Communication Speed Key
4	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.