EOCF_EVACT_PVW (SQL View)	Index Back
Action types for Trigger Point Valid action types for Trigger Point

EOCF_EVACT_PVW

(SQL View)

Action types for Trigger Point

Valid action types for Trigger Point

SELECT A.EOCF_EVENT_ID ,A.EOCF_ACTION_TYP_ID , B.EOCF_ACT_TYP_NAME FROM PS_EOCF_ACT_VALEVT A , PS_EOCF_ACTN_TYPE B WHERE A.EOCF_ACTION_TYP_ID = B.EOCF_ACTION_TYP_ID

Related Language Record: EOCF_EVACT_LVW

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EOCF_EVENT_ID Number(31,0) DECIMAL(31) NOT NULL unique identifier for an event definition

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_EVTACT_VW

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_ID	Number(31,0)	DECIMAL(31) NOT NULL	unique identifier for an event definition
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_EVTACT_VW
3	EOCF_ACT_TYP_NAME	Character(30)	VARCHAR2(30) NOT NULL	user-defined name to identify the characteristics of a particular action