ENUM
| 1 | Assign to Supervisor, their supervisor on stale |
| 2 | Assign to Supervisor, HR on stale |
| 3 | Assign to HR |
LeaveType
| CompanyID | Company Identifier | SmallID | 12 | ||||||||
| LeaveTypeId | Unique Identifier for LeaveTyp | BigID | 12 | ||||||||
| LeaveTypeName | Varchar | 80 | |||||||||
| EssAltName | Alternate name shown in ESS | Varchar | 80 | ||||||||
| EssEnable | Field is allowed in ESS (Y/N) | Varchar | 1 | ||||||||
| LvRqEnabled | Leave Request feature is enabled for this leave type (Y/N) | Varchar | 1 | ||||||||
| EssTakenEnable | Taken section is enabled for ESS (Y/N). | Varchar | 1 | ||||||||
| LvRqCnclFuture | Employee can cancel Leave that's scheduled in the future (Y/N) | Varchar | 1 | ||||||||
| RqSndApprAsgn | Y/N Send an email to approver upon assignment. | Varchar | 1 | ||||||||
| RqSndEmpCncl | Y/N Send an email to employee upon cancel. | Varchar | 1 | ||||||||
| RqSndEmpAppr | Y/N Send an email to employee upon approval. | Varchar | 1 | ||||||||
| RqSndAppLvRqCncl | Y/N Send an email to approver upon leave request cancel. | Varchar | 1 | ||||||||
| RqSndAppLvCncl | Y/N Send an email to approver upon leave cancel. | Varchar | 1 | ||||||||
| LvAutoAppFuture | Leave requests scheduled later than today are automatically approved. (Y/N) | Varchar | 1 | ||||||||
| LvAutoAppPast | Leave requests for today or in the past are automatically approved. (Y/N) | Varchar | 1 | ||||||||
| LvRqStale | Number of days after which a leave request becomes "stale." | Long | 12 | ||||||||
| LvRqAssignSchm | Scheme for assigning new leave requests. | Enum | 1 | ENUM
|
|||||||
| LvReqInstruct | Instructions for ESS Leave Request | Text | 16000 | ||||||||
| LvCnclInstruct | Instructions for ESS Leave Cancellation | Text | 16000 | ||||||||
| LvChgInstruct | Instructions for ESS Leave Cancellation | Text | 16000 | ||||||||
| LockSeqNbr | *SYSTEM* Row Sequence Nbr | Long | 12 |