EOCF_RULE_DEFN

(SQL Table)
Index Back

rule definition

rule definition

  • Related Language Record: EOCF_RULE_LNG
  • # 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.