EOCF_ACTION_SET_IDEOCF_ACTION_IDA=Active
I=Inactive
Default Value: A
Prompt Table: EOCF_ACTN_TYPE
Prompt Table: EOCF_ACTION_OBJ
EOCF_ACTNDEF_VW(SQL View) |
Index Back |
|---|---|
action definition Viewaction definition View |
| SELECT A.EOCF_ACTION_SET_ID , B.EOCF_ACTION_ID , A.EOCF_ORDERNUM , B.EOCF_ACTION_NAME , A.STATUS , B.EOCF_ACTION_TYP_ID , B.EOCF_ACTION_OBJ_ID , %subrec(EOCF_AUDIT_SBR,B) FROM PS_EOCF_ACTION_SET A , PS_EOCF_ACTION_DEF B WHERE A.EOCF_ACTION_ID = B.EOCF_ACTION_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EOCF_ACTION_SET_ID |
Number(31,0) | DECIMAL(31) NOT NULL | set of actions to be run from an event |
| 2 | EOCF_ACTION_ID |
Number(31,0) | DECIMAL(31) NOT NULL | Active Analytics Framework Action ID field |
| 3 | EOCF_ORDERNUM | Number(3,0) | SMALLINT NOT NULL | sequence number for line item rows |
| 4 | EOCF_ACTION_NAME | Character(80) | VARCHAR2(80) NOT NULL | user-defined name to identify the characteristics of a particular action |
| 5 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive Default Value: A |
| 6 | 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 |
| 7 | EOCF_ACTION_OBJ_ID | Number(31,0) | DECIMAL(31) NOT NULL |
Action Id
Prompt Table: EOCF_ACTION_OBJ |
| 8 | EOCF_CREATEDTTM | DateTime(26) | TIMESTAMP | CLAF - Created DateTime |
| 9 | EOCF_CREATEOPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 10 | EOCF_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
| 11 | EOCF_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |