EOCF_EVTACT_VW (SQL View)	Index Back
Valid trigger types Valid trigger types for an action type

EOCF_EVTACT_VW

(SQL View)

Valid trigger types

Valid trigger types for an action type

SELECT A.EOCF_EVENT_TYPE_ID , A.EOCF_ACTION_TYP_ID , B.EOCF_ACT_TYP_NAME FROM PS_EOCF_ACT_EV_TYP A , PS_EOCF_ACTN_TYPE B WHERE A.EOCF_ACTION_TYP_ID = B.EOCF_ACTION_TYP_ID

Parent record: EOCF_ACTN_TYPE

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOCF_EVENT_TYPE_ID Number(31,0) DECIMAL(31) NOT NULL what kind of event is this

2 EOCF_ACTION_TYP_ID Number(31,0) DECIMAL(31) NOT NULL the unique identifier pointing to a discreet action type configuration
Prompt Table: EOCF_ACTN_TYPE

3 EOCF_ACT_TYP_NAME Character(30) VARCHAR2(30) NOT NULL user-defined name to identify the characteristics of a particular action

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EOCF_EVENT_TYPE_ID	Number(31,0)	DECIMAL(31) NOT NULL	what kind of event is this
2	EOCF_ACTION_TYP_ID	Number(31,0)	DECIMAL(31) NOT NULL	the unique identifier pointing to a discreet action type configuration Prompt Table: EOCF_ACTN_TYPE
3	EOCF_ACT_TYP_NAME	Character(30)	VARCHAR2(30) NOT NULL	user-defined name to identify the characteristics of a particular action