APPR_RULE_HDR

index back

Approval Rule Defn Hdr


  • Related language record: APPR_HDR_LNG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    APPR_RULE_SETCharacter(30)VARCHAR2(30) NOT NULLApproval Rule Set
    EFFDTDate(10)DATEEffective Date
    BUSPROCNAMECharacter(30)VARCHAR2(30) NOT NULLBusiness Process Name (see PSBUSPROCDEFN).

    Prompt Table: BUSPROCNAME_VW

    CURRENCY_CDCharacter(3)VARCHAR2(3) NOT NULLCurrency Code

    Prompt Table: CURRENCY_CD_TBL

    CUR_RT_TYPECharacter(5)VARCHAR2(5) NOT NULLCurrency Rate Type
    APPR_ACTIVE_SWCharacter(1)VARCHAR2(1) NOT NULLApproval Check Active

    Y/N Table Edit

    Default: Y

    RECNAME_CURCharacter(15)VARCHAR2(15) NOT NULLCurrency Record

    Prompt Table: RECDEFN_VW

    FIELDNAME_CURCharacter(18)VARCHAR2(18) NOT NULLCurrency Field

    Prompt Table: RECFIELD_CUR_VW

    ACTIVITYNAMECharacter(30)VARCHAR2(30) NOT NULLName of a Business Process Activity (see PSACTIVITYDEFN).

    Prompt Table: WF_BP_ACT_VW

    EVENTNAMECharacter(30)VARCHAR2(30) NOT NULLDefines a routing event for PS Workflow

    Prompt Table: WF_ACT_EVT_VW

    VERSIONNumber(10,0)DECIMAL(10) NOT NULLVersion. Internal PeopleTools version for controlling caching of object. - Version/Table reference
    FONTCharacter(80)VARCHAR2(80) NOT NULLFont Name
    DESCR60Character(60)VARCHAR2(60) NOT NULLDescription
    LASTUPDDTTMDateTime(26)TIMESTAMPSpecifies 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.
    LASTUPDOPRIDCharacter(30)VARCHAR2(30) NOT NULLSpecifies 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.
    DESCRLONGLong CharacterCLOBLong Description
    SELF_APPROVALNumber(3,0)SMALLINT NOT NULLCan Self Approve
    OBJECTOWNERIDCharacter(4)VARCHAR2(4) NOT NULLObject owner identifier translate values
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19