STATUS_TYPE provides pre-defined generic statuses allowing users to categorize the employment status into a specified type.

X_STATUS_TYPE is a fixed lexicon with the following values:
Saved
Value
Displayed ValueUsages
A ActiveBusiness Classes
P2K_CM_DEPARTMENTS - Used to find active employees in a department for derived column DRV_ACTIVE_EE_IN_DEPARTMENT (This column is available but not currently used.)

P2K_PR_DISBURSEMENTS - Used in selecting the active assignment details records for populating the derived columns listed:
DRV_EE_WAGE_RATE
DRV_EE_RATE_BASIS
DRV_EE_WAGE_RATE_2
DRV_EE_RATE_BASIS_2
DRV_EE_WAGE_RATE_3
DRV_EE_RATE_BASIS_3
DRV_EE_WAGE_RATE_4
DRV_EE_RATE_BASIS_4
DRV_EE_WAGE_RATE_5
DRV_EE_RATE_BASIS_5
DRV_EE_WAGE_RATE_6
DRV_EE_RATE_BASIS_6
(These columns are available but not currently used)
Default
Status type when inserting a new employment status.
Business Objects
Positions - Used to find the first active employee in a specific position.

Workers - Used to find qualified assignments for a given scheduled shift.(This business object is used throughout TMSS modules and Personality) AutoFillers.

Employee Hierarchy - Used across the system when working with lists of employees and managers.

Assignments - Used across the system to identify if an assignment is currently active.
Where Clauses
SHOW_ALL_MODE shows all active if toggled to show all. Included in
WECCL
IPSN
IPGS
IALA
DTSWA
WSTSWA
DTSH
WSTSH
ALL_OR_ACTIVE used in IDGF
Time Clock Punch Processing
Used to find an active assignment for the employment associated to a stored clock punch.
Reports/Update Processes
UTBWO - Used to help identify employees who have had a status change when maintaining worker availability.
Approval Engine
Used to ensure that defined approvers have an active assignment.
Server Code
Used in various procedures, functions and spec and bodies for finding active employees.
C CobraNot referenced in code. (Java or SQL)
I InactiveDefault Status for the beginning of time records before an employee's hire date.

Business Objects: Employee Hierarchy - Used across the system when working with lists of employees and managers.
L LeaveNot referenced in code. ( Java or SQL)
P PendingNot referenced in code. ( Java or SQL )
R RetiredBusiness Objects: Employee Hierarchy - used across the system when working with lists of employees and managers.
S SurvivorNot referenced in code. ( Java or SQL )
T TerminatedBusiness Objects
Employee Hierarchy - Used across the system when working with lists of employees and managers.
U Unpaid LeaveNot referenced in code. ( Java or SQL )

Notes#

Click to create a new notes page
p2k_cm_d