X_STATUS_TYPE is a fixed lexicon with the following values:
| Saved Value | Displayed Value | Usages |
|---|---|---|
| A | Active | Business 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 | Cobra | Not referenced in code. (Java or SQL) |
| I | Inactive | Default 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 | Leave | Not referenced in code. ( Java or SQL) |
| P | Pending | Not referenced in code. ( Java or SQL ) |
| R | Retired | Business Objects: Employee Hierarchy - used across the system when working with lists of employees and managers. |
| S | Survivor | Not referenced in code. ( Java or SQL ) |
| T | Terminated | Business Objects Employee Hierarchy - Used across the system when working with lists of employees and managers. |
| U | Unpaid Leave | Not referenced in code. ( Java or SQL ) |
