EVNT_AF_CMP_VW (SQL View)	Index Back
Admin Function Joint Fields This view captures the current, active Joint Rules for the Admin Function chosen on a Event Definition.

EVNT_AF_CMP_VW

(SQL View)

Admin Function Joint Fields

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

SELECT B.INSTITUTION , B.EVENT_3CS_ID ,B.ADMIN_FUNCTION , B.COMPARE_FLD FROM PS_EVNT_3CS_TBL A ,PS_EVNT_JRULES_AF B WHERE A.INSTITUTION = B.INSTITUTION AND A.EVENT_3CS_ID = B.EVENT_3CS_ID AND A.EFFDT = B.EFFDT AND A.ADMIN_FUNCTION = B.ADMIN_FUNCTION 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 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function

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	ADMIN_FUNCTION	Character(4)	VARCHAR2(4) NOT NULL	Administrative Function
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.