APPR_RULE_HDR

index back

Approval Rule Defn Hdr


  • Related language record: APPR_HDR_LNG
  • PeopleSoft Field Name Field Type Column Type Description
    APPR_RULE_SET Character(30) VARCHAR2(30) NOT NULL Approval Rule Set
    EFFDT Date(10) DATE Effective Date
    BUSPROCNAME Character(30) VARCHAR2(30) NOT NULL Business Process Name (see PSBUSPROCDEFN).

    Prompt Table: BUSPROCNAME_VW

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

    Prompt Table: CURRENCY_CD_TBL

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

    Y/N Table Edit

    Default: Y

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

    Prompt Table: RECDEFN_VW

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

    Prompt Table: RECFIELD_CUR_VW

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

    Prompt Table: WF_BP_ACT_VW

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

    Prompt Table: WF_ACT_EVT_VW

    VERSION Number(10,0) DECIMAL(10) NOT NULL Version. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    FONT Character(80) VARCHAR2(80) NOT NULL Font Name
    DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
    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.
    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.
    DESCRLONG Long Character CLOB Long Description
    SELF_APPROVAL Number(3,0) SMALLINT NOT NULL Can Self Approve
    OBJECTOWNERID Character(4) VARCHAR2(4) NOT NULL Object owner identifier translate values
    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19