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.TRANSACTION_NBR , SEC.NAME , B.ACTION_DT_SS , A.SS_STAT_INDICATOR , B.LOCATION , A.JOB_DESCR_SS , A.POSITION_FLAG FROM PS_HR_LOC_TRANS A , PS_HR_MGR_LOC_DAT B , PS_EMPLMT_SRCH_GBL SEC WHERE A.TRANSACTION_NBR = B.TRANSACTION_NBR AND A.EMPLID = SEC.EMPLID AND A.EMPL_RCD = SEC.EMPL_RCD

# 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 Rcd Nbr
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 SetID
12 JOBCODE Character(6) VARCHAR2(6) NOT NULL Job Code
13 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
14 NAME Character(50) VARCHAR2(50) NOT NULL Name
15 ACTION_DT_SS Date(10) DATE * Effective Date
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
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