HR_SALCHBGT_STA

(SQL Table)
 Index Back

Workflow for Sal Chg for Grp

This record is a child of HR_SALCHBGT_DAT and is used to store data about each step of the workflow approval process for a Request Salary Change for Group with Allocated Budget.

  • Parent record: HR_SALCHGRP_DAT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 GB_GROUP_ID Character(15) VARCHAR2(15) NOT NULL Group Build ID.
    2 BUDGET_START_DT Date(10) DATE Budget Start Date
    3 BUDGET_ID Character(10) VARCHAR2(10) NOT NULL Budget ID
    4 EFFDT Date(10) DATE Effective Date
    5 APPR_STEP Character(3) VARCHAR2(3) NOT NULL Approval Step
    1=Approval Step 1
    2=Approval Step 2
    3=Approval Step 3
    4=Approval Step 4
    5=Approval Step 5
    6=Approval Step 6
    7=Approval Step 7
    8=Approval Step 8
    9=Approval Step 9
    6 APPR_PATH Character(3) VARCHAR2(3) NOT NULL Approval Path
    A=Approval Path A
    B=Approval Path B
    C=Approval Path C
    D=Approval Path D
    E=Approval Path E
    7 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
    8 ROLENAME Character(30) VARCHAR2(30) NOT NULL The name of a Role in the Role Definition Table (see PSROLEDEFN).
    9 EMPLID_TO Character(11) VARCHAR2(11) NOT NULL Empl ID To
    10 ROLEUSER Character(30) VARCHAR2(30) NOT NULL Role User
    11 HR_WF_ACTION Character(3) VARCHAR2(3) NOT NULL Workflow Action
    APV=Approved
    CAN=Cancelled by Originator
    DNY=Denied
    PND=Pending
    PSH=Push back for rework
    RAS=Reassign
    SAV=Saved For Later-Not Submitted
    SUB=Submitted
    12 TRANS_DT Date(10) DATE Transaction Date
    13 CURRENT_STEP Number(3,0) SMALLINT NOT NULL Current Step Number
    14 COMMENTS Long Character CLOB Comment