PTAFAW_PATH

index back

Approval Path Definition

Approval Path Definition

  • Related language record: PTAFAW_PATH_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_SOURCECharacter(1)VARCHAR2(1) NOT NULLStep Source - Static or Dynamic
    D=Dynamic
    S=Static

    Default: S

    PTAFNUMBER_HOURSNumber(2,0)SMALLINT NOT NULLNumber of Hours
    PTAFNUMBER_DAYSNumber(3,0)SMALLINT NOT NULLNumber of Days
    PTAFESCALATN_OPTNCharacter(1)VARCHAR2(1) NOT NULL1-Notify Approver 2-Notify Supervisor 3-Notify Approver & Supervisor 4-Skip to Next Step 5-Skip to Next Step & Notify Appover 6-Skip to Next Step & Notify Appover 7-Skip to Next Step & Notify Appover & Supervisor
    A=Advance Approval
    N=Notify Participant
    R=Reassign Approval
    DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
    PTAFCRTA_IDCharacter(100)VARCHAR2(100) NOT NULLCriteria ID
    PTAFSKIP_PRIORCharacter(1)VARCHAR2(1) NOT NULLSkip Prior Steps For Requester
    N=Do Not Skip Prior Steps
    Y=Skip Prior Steps

    Default: N

    PTAFAUTH_SWCharacter(1)VARCHAR2(1) NOT NULLCheck Authorization

    Default: N

    PTAFFIRST_STEP_SWCharacter(1)VARCHAR2(1) NOT NULLRequire at least one approver

    Default: N

    PTAFREQUIREFIRSTCharacter(1)VARCHAR2(1) NOT NULLUsed as the require at least one approver in Approvls.

    Default: N

    PTAFSKIP_UNAUTHEDCharacter(1)VARCHAR2(1) NOT NULLSkip users that are not authorized to approve the req.

    Y/N Table Edit

    DESCRLONGLong CharacterCLOBLong Description
    PTAFNOTIFY_ADMINCharacter(1)VARCHAR2(1) NOT NULLNotify Admin on No Approvers

    Y/N Table Edit

    Default: N

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