PTAFAW_PRCS

index back

Approval Process Definition

This table holds the Approval Process definition properties

  • Related language record: PTAFAW_PRCS_LNG
  • PeopleSoft Field Name Field Type Column Type Description
    PTAFPRCS_ID Character(30) VARCHAR2(30) NOT NULL Approval Process ID

    Prompt Table: PTAFAW_TXN

    PTAFDEFN_ID Character(30) VARCHAR2(30) NOT NULL Definition ID
    EFFDT Date(10) DATE NOT NULL Effective Date

    Default: %date

    EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
    A=Active
    I=Inactive

    Default: A

    DESCR Character(30) VARCHAR2(30) NOT NULL Description
    PTAFADMIN_ROLENAME Character(30) VARCHAR2(30) NOT NULL Rolename of Approval Workflow Administrator

    Prompt Table: PSROLEDEFN_VW

    PTAFACT_LINE_LEVEL Character(1) VARCHAR2(1) NOT NULL Take Final Action at Line Level
    N=No
    Y=Yes

    Default: Y

    PTAFAUTO_APPROVE Character(1) VARCHAR2(1) NOT NULL Automatically Approve

    Default: N

    PTAFFIELD_LIST_ID Character(30) VARCHAR2(30) NOT NULL Field List ID

    Prompt Table: PTAFFIELD_LIST

    PTAFCRTA_ID Character(100) VARCHAR2(100) NOT NULL Criteria ID
    PTAFDEFN_CRTA_ID Character(100) VARCHAR2(100) NOT NULL Defintion Criteria
    PTAFAW_REQSTR_SW Character(1) VARCHAR2(1) NOT NULL Route to Requestor switch.

    Y/N Table Edit

    Default: N

    PTAFDEFN_DEFAULT Character(1) VARCHAR2(1) NOT NULL Default Process Definition

    Y/N Table Edit

    Default: N

    PTAFDEFN_PRIORITY Number(3,0) SMALLINT NOT NULL Priority

    Default: 1

    index back (c)David Kurtz 2020, www.go-faster.co.uk PeopleTools 8.58
    PTRef generated on 21-DEC-20