IT_RULE_ACTN

(SQL Table)
 Index Back

Rule Action Definition

  • Related Language Record: IT_RULE_ACTN_LG

  • Parent record: IT_RULE_DEFN

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 RULE_ID Character(20) VARCHAR2(20) NOT NULL Rule ID
    2 RULE_ACTION_OPTN Character(3) VARCHAR2(3) NOT NULL Rule Option
    01=Update ARM
    02=Add Asset
    03=Retire Asset
    05=Move to Inventory
    10=Email Custodian
    11=Email Manager
    12=Email Primary User
    13=Email Primary User Manager
    14=Email Group Owner
    20=Route to Role
    3 ACTN_APPLY Character(1) VARCHAR2(1) NOT NULL IT Business Rule Apply Action To 'Financial', 'Non-Financial' or 'Both' types of Asset.
    A=N/A
    B=Both
    F=Financial
    N=Non-Fin
    4 EXECUTE_SW Character(1) VARCHAR2(1) NOT NULL Automatically execute switch

    Y/N Table Edit

    Default Value: N

    5 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).

    Prompt Table: IT_ROLENAME

    6 MESSAGE_SET_NBR Number(5,0) INTEGER NOT NULL Message Set Number. This field refers to the Message Set Number in the Message Catalog.

    Prompt Table: PSMSGSETDEFN

    7 MESSAGE_NBR Number(5,0) INTEGER NOT NULL Message Number. This field refers to the Message Number in the Message Catalog.

    Prompt Table: PSMSGCATDEFN

    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description