EOCF_EVTACTPLVW (SQL View)	Index Back
Valid action types/ trig type Valid action types for a trigger type

EOCF_EVTACTPLVW

(SQL View)

Valid action types/ trig type

Valid action types for a trigger type

SELECT DISTINCT A.EOCF_EVENT_TYPE_ID , A.EOCF_ACTION_TYP_ID , B.LANGUAGE_CD , B.EOCF_ACT_TYP_NAME FROM PS_EOCF_ACT_EV_TYP A , PS_EOCF_ACTTYP_LNG B WHERE A.EOCF_ACTION_TYP_ID = B.EOCF_ACTION_TYP_ID

Related Language Record for EOCF_EVTACT_PVW

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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

4 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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
4	EOCF_ACT_TYP_NAME	Character(30)	VARCHAR2(30) NOT NULL	user-defined name to identify the characteristics of a particular action