EOCF_RULE_DEFN(SQL Table) |
Index Back |
---|---|
rule definitionrule definition |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | EOCF_RULE_ID | Number(31,0) | DECIMAL(31) NOT NULL | Active Analytics Framework unique identifier for a policy |
2 | EOCF_RULE_NAME | Character(80) | VARCHAR2(80) NOT NULL | the name of a policy if the policy is named |
3 | EOCF_RULE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
data library term status, possible values are Active, Inactive, Under Construction
A=Active U=In Design Default Value: U |
4 | EOCF_OWNER | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID
Prompt Table: EOCF_OPRID_VW |
5 | EOCF_START_DATE | Date(10) | DATE | start date |
6 | EOCF_END_DATE | Date(10) | DATE | start date |
7 | EOCF_CODE_PTR | Number(31,0) | DECIMAL(31) NOT NULL | unique id value pointing to compiled form of expression code |
8 | EOCF_PHRASE_ID | Number(31,0) | DECIMAL(31) NOT NULL | the unique identifier for a phrase definition (ignoring versioning) |
9 | EOCF_ACTION_SET_ID | Number(31,0) | DECIMAL(31) NOT NULL | set of actions to be run from an event |
10 | EOCF_IACATEGORY_ID | Number(31,0) | DECIMAL(31) NOT NULL |
Action Id
Prompt Table: EOCF_IACAT_VW |
11 | DESCRLONG | Long Character | CLOB | Long Description |
12 | 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 |
13 | EOCF_IS_SYSTEM | Character(1) | VARCHAR2(1) NOT NULL | data library - is system data |
14 | EOCF_CREATEDTTM | DateTime(26) | TIMESTAMP | CLAF - Created DateTime |
15 | EOCF_CREATEOPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
16 | EOCF_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
17 | EOCF_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |