WF_MGR_LOC_VW

(SQL View)
 Index Back

Stage Record for Retire SS

Used for 8.3 Workflow Enhancements. Located on Page.HR_RETIRE_EE.

SELECT %Sql(SCRTY_SEL_PKEY,SEC,SEC) , %Sql(SCRTY_SEL_FLDSBR,SEC) , A.ACTION_DT_SS , A.EFFSEQ , SEC.NAME , A.SS_STAT_INDICATOR , A.LOCATION , A.JOB_DESCR_SS , A.POSITION_FLAG FROM PS_HR_LOC_TRANS A , PS_EMPLMT_SRCH_GBL SEC WHERE A.EMPLID = SEC.EMPLID AND A.EMPL_RCD = SEC.EMPL_RCD

  • Related Language Record: PERSON_NAME_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 ROWSECCLASS Character(30) VARCHAR2(30) NOT NULL The class used to determine row level security
    3 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    4 EMPL_RCD Number(3,0) SMALLINT NOT NULL Empl Record
    5 APPT_TYPE Character(1) VARCHAR2(1) NOT NULL This field tracks whether a row is a Main Appointment (which all rows outside Japan are), or an Additional Appointment, which is a feature only used by Japanese customers.
    0=Core Appointment
    1=Japan Kenmu Appointment
    2=French Public Sector Appt
    3=Staffing
    6 EMPL_STATUS Character(1) VARCHAR2(1) NOT NULL Payroll Status
    A=Active
    D=Deceased
    L=Leave of Absence
    P=Leave With Pay
    Q=Retired With Pay
    R=Retired
    S=Suspended
    T=Terminated
    U=Terminated With Pay
    V=Terminated Pension Pay Out
    W=Short Work Break
    X=Retired-Pension Administration
    7 OTHER_ID_JPN Character(11) VARCHAR2(11) NOT NULL Other Identifier
    8 FUTURE_FLG Character(1) VARCHAR2(1) NOT NULL Flag for the SJT_*** record that indicates whether this is a future dated row or not. Y = Future N = Current
    9 REPORTS_TO Character(8) VARCHAR2(8) NOT NULL Reports To Position Number
    10 SUPERVISOR_ID Character(11) VARCHAR2(11) NOT NULL Supervisor ID
    11 SETID_JOBCODE Character(5) VARCHAR2(5) NOT NULL Job Code Set ID
    12 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
    13 ACTION_DT_SS Date(10) DATE *Effective Date
    14 EFFSEQ Number(3,0) SMALLINT NOT NULL Effective Sequence
    15 NAME Character(50) VARCHAR2(50) NOT NULL Name
    16 SS_STAT_INDICATOR Character(1) VARCHAR2(1) NOT NULL Used on "_DAT" records for 8.3 Workflow Enhancements
    A=Approved
    B=CI failed - Errors & Warnings
    C=Cancelled
    D=Denied
    E=Errors Encountered
    I=In Approval Process
    M=Administrator Action Required
    S=Success
    W=Warnings Encountered
    17 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

    Prompt Table: LOCATION_TBL
    Set Control Field: SETID_LOCATION

    18 JOB_DESCR_SS Character(30) VARCHAR2(30) NOT NULL Job Title
    19 POSITION_FLAG Character(1) VARCHAR2(1) NOT NULL Position Flag
    N=No
    Y=Yes