PTAFAW_PRCS

index back

Approval Process Definition

This table holds the Approval Process definition properties

  • Related language record: PTAFAW_PRCS_LNG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTAFPRCS_IDCharacter(30)VARCHAR2(30) NOT NULLApproval Process ID

    Prompt Table: PTAFAW_TXN

    PTAFDEFN_IDCharacter(30)VARCHAR2(30) NOT NULLDefinition ID
    EFFDTDate(10)DATE NOT NULLEffective Date

    Default: %date

    EFF_STATUSCharacter(1)VARCHAR2(1) NOT NULLEffective Status
    A=Active
    I=Inactive

    Default: A

    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    PTAFADMIN_ROLENAMECharacter(30)VARCHAR2(30) NOT NULLRolename of Approval Workflow Administrator

    Prompt Table: PSROLEDEFN_VW

    PTAFACT_LINE_LEVELCharacter(1)VARCHAR2(1) NOT NULLTake Final Action at Line Level
    N=No
    Y=Yes

    Default: Y

    PTAFAUTO_APPROVECharacter(1)VARCHAR2(1) NOT NULLAutomatically Approve

    Default: N

    PTAFFIELD_LIST_IDCharacter(30)VARCHAR2(30) NOT NULLField List ID

    Prompt Table: PTAFFIELD_LIST

    PTAFCRTA_IDCharacter(100)VARCHAR2(100) NOT NULLCriteria ID
    PTAFDEFN_CRTA_IDCharacter(100)VARCHAR2(100) NOT NULLDefintion Criteria
    PTAFAW_REQSTR_SWCharacter(1)VARCHAR2(1) NOT NULLRoute to Requestor switch.

    Y/N Table Edit

    Default: N

    PTAFDEFN_DEFAULTCharacter(1)VARCHAR2(1) NOT NULLDefault Process Definition

    Y/N Table Edit

    Default: N

    PTAFDEFN_PRIORITYNumber(3,0)SMALLINT NOT NULLPriority

    Default: 1

    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19