PTAFAW_STEP

index back

Approval Step

Approval Step

  • Related language record: PTAFAW_STEP_LNG
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTAFPRCS_IDCharacter(30)VARCHAR2(30) NOT NULLApproval Process ID
    PTAFDEFN_IDCharacter(30)VARCHAR2(30) NOT NULLDefinition ID
    EFFDTDate(10)DATE NOT NULLEffective Date
    PTAFSTAGE_NBRNumber(3,0)SMALLINT NOT NULLStage Number
    PTAFPATH_IDCharacter(30)VARCHAR2(30) NOT NULLApproval Path ID
    PTAFSTEP_NBRNumber(6,2)DECIMAL(5,2) NOT NULLSequence number of step in its path

    Default: 1

    SEQ_NBRNumber(15,0)DECIMAL(15) NOT NULLSequence Number

    Default: 1

    PTAFAPPROVER_LISTCharacter(30)VARCHAR2(30) NOT NULLList of Approvers

    Prompt Table: PTAFUSER_LIST

    PTAFAPPROVER_SWCharacter(1)VARCHAR2(1) NOT NULLAll vs. Some Specified Number of Approvers Needed
    N=Some Approvers Required
    Y=All Approvers Required

    Default: N

    PTAFMIN_APPROVERSNumber(2,0)SMALLINT NOT NULLMinimum Approvers

    Default: 1

    PTAFROLENAMECharacter(30)VARCHAR2(30) NOT NULLRecipients have to be in this role in order to act as approvers

    Prompt Table: PSROLEDEFN_VW

    PTAFSELF_APPROVALCharacter(1)VARCHAR2(1) NOT NULLSelf Approval Option
    N=No
    Y=Yes
    PTAFSELF_CRTA_IDCharacter(100)VARCHAR2(100) NOT NULLSelf-approval Criteria Id
    PTAFREVIEWER_LISTCharacter(30)VARCHAR2(30) NOT NULLList of Reviewers

    Prompt Table: PTAFUSER_LIST

    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    PTAFCRTA_IDCharacter(100)VARCHAR2(100) NOT NULLCriteria ID
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19