EOCF_ACTN_TYPE(SQL Table) | 
Index Back | 
|---|---|
action type specaction type specification (mean implementation too) | 
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description | 
|---|---|---|---|---|
| 1 | Number(31,0) | DECIMAL(31) NOT NULL | the unique identifier pointing to a discreet action type configuration | |
| 2 | EOCF_ACT_TYP_NAME | Character(30) | VARCHAR2(30) NOT NULL | user-defined name to identify the characteristics of a particular action | 
| 3 | EOCF_DT_APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL | 
Run Time App Class ID
 Prompt Table: EOCF_DT_CLAS_VW  | 
| 4 | EOCF_DT_APPCLSPATH | Character(167) | VARCHAR2(167) NOT NULL | 
Run Time App Class Path
 Prompt Table: EOCF_DT_PATH_VW  | 
| 5 | EOCF_RT_APPCLASSID | Character(30) | VARCHAR2(30) NOT NULL | 
Run Time App Class ID
 Prompt Table: EOCF_RT_CLAS_VW  | 
| 6 | EOCF_RT_APPCLSPATH | Character(167) | VARCHAR2(167) NOT NULL | 
Run Time App Class Path
 Prompt Table: EOCF_RT_PATH_VW  | 
| 7 | EOCF_TXT_APPCLASID | Character(30) | VARCHAR2(30) NOT NULL | 
Run Time App Class ID
 Prompt Table: EOCF_TXT_CLS_VW  | 
| 8 | EOCF_TXT_APCLSPATH | Character(167) | VARCHAR2(167) NOT NULL | 
Run Time App Class Path
 Prompt Table: EOCF_TXT_PATHVW  | 
| 9 | EOCF_IS_TERMINAL | Character(1) | VARCHAR2(1) NOT NULL | 
determines if an action execution can occur after this acton type fires
 Y/N Table Edit  | 
| 10 | EOCF_IS_CFG_FLAG | Character(1) | VARCHAR2(1) NOT NULL | 
Do Actions of this Action Type need to be configured
 Y/N Table Edit Default Value: Y  | 
| 11 | EOCF_IS_CMBIN_FLAG | Character(1) | VARCHAR2(1) NOT NULL | 
Flag to indicate if Actions of an Action Type can be Combined
 Y/N Table Edit  | 
| 12 | EOCF_AE_TRIGGERED | Character(1) | VARCHAR2(1) NOT NULL | 
Flag that indicates if this can be triggered from AE
 Y/N Table Edit Default Value: N  | 
| 13 | EOCF_APPMSG_TRIGGR | Character(1) | VARCHAR2(1) NOT NULL | 
Flag that indicates if Actions of an Action Type can be triggered by App Message
 Y/N Table Edit Default Value: N  | 
| 14 | EOCF_CI_TRIGGERED | Character(1) | VARCHAR2(1) NOT NULL | 
Flag that indicates if Actions of an Action type can be triggered from Component Interfaces
 Y/N Table Edit Default Value: Y  | 
| 15 | EOCF_PIA_TRIGGERED | Character(1) | VARCHAR2(1) NOT NULL | 
Flag that indicates if Actions of an Action type can be Triggered from a PIA page
 Y/N Table Edit Default Value: Y  | 
| 16 | EOCF_COMMIT_FLAG | Character(1) | VARCHAR2(1) NOT NULL | 
Flag that indicates if a  commit should be issued.
 Y/N Table Edit  | 
| 17 | EOCF_DT_COMMIT | Character(1) | VARCHAR2(1) NOT NULL | 
Flag that indicates if a  commit should be issued by Rule builder, at Design Time,  before configuring action.
 Y/N Table Edit  | 
| 18 | STATUS | Character(1) | VARCHAR2(1) NOT NULL | 
Status Indicator
 A=Active I=Inactive  | 
| 19 | DESCRLONG | Long Character | CLOB | Long Description | 
| 20 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description | 
| 21 | EOCF_CREATEDTTM | DateTime(26) | TIMESTAMP | CLAF - Created DateTime | 
| 22 | EOCF_CREATEOPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID | 
| 23 | EOCF_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. | 
| 24 | EOCF_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. | 
| 25 | EOCF_MAINT_OWNER | Character(1) | VARCHAR2(1) NOT NULL | 
data library - Maint Owner, possible values are Peoplesoft, Customer, Modified
 0=PeopleSoft 1=PeopleSoft / Customer Modified 2=Customer Default Value: 2  | 
| 26 | EOCF_IS_SYSTEM | Character(1) | VARCHAR2(1) NOT NULL | data library - is system data |