APPR_RULE_HDR

(SQL Table)
Index Back

Approval Rule Defn Hdr

  • Related Language Record: APPR_HDR_LNG
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 APPR_RULE_SET Character(30) VARCHAR2(30) NOT NULL Approval Rule Set
    2 EFFDT Date(10) DATE Effective Date
    3 BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).

    Prompt Table: BUSPROCNAME_VW

    4 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Prompt Table: CURRENCY_CD_TBL

    5 CUR_RT_TYPE Character(5) VARCHAR2(5) NOT NULL Currency Rate Type
    6 APPR_ACTIVE_SW Character(1) VARCHAR2(1) NOT NULL Approval Check Active

    Y/N Table Edit

    Default Value: Y

    7 RECNAME_CUR Character(15) VARCHAR2(15) NOT NULL Currency Record

    Prompt Table: RECDEFN_VW

    8 FIELDNAME_CUR Character(18) VARCHAR2(18) NOT NULL Currency Field

    Prompt Table: RECFIELD_CUR_VW

    9 ACTIVITYNAME Character(30) VARCHAR2(30) NOT NULL Name of a Business Process Activity (see PSACTIVITYDEFN).

    Prompt Table: WF_BP_ACT_VW

    10 EVENTNAME Character(30) VARCHAR2(30) NOT NULL Defines a routing event for PS Workflow

    Prompt Table: WF_ACT_EVT_VW

    11 VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    12 FONT Character(80) VARCHAR2(80) NOT NULL Font Name
    13 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    14 LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    15 LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
    16 DESCRLONG Long Character CLOB Long Description
    17 SELF_APPROVAL Number(3,0) SMALLINT NOT NULL Can Self Approve
    18 OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier