Leave Case
The Leave Case entity provides all of the detailed information related to each leave case that has been opened by employees. This is the primary entity for leave. It allows users to look at the cases related to the employees in their organization. It provides all of the information that is relevant to each leave case, such as the type of leave, the start and end dates of the leave case, the current status of the leave case, and the reason for the leave case.
The data columns available in the Leave Case entity can be used with other leave-related entities to generate Dataviews and reports. For example, you can use the Leave Case data columns with columns from the Leave Case Document entity to see the documents that are associated with a leave case and their status.
Supported Dataview types
| Employee Dataview | Business Structure Dataview |
|---|---|
| X |
Data granularity
Provides one row per employee per leave case.
Columns
| Label | Key |
|---|---|
|
Certification Episode Duration (Days) |
LEAVE_CERTIFICATION_EPISODE_DURATION_DAYS |
|
Certification Episode Duration (Hours) |
LEAVE_CERTIFICATION_EPISODE_DURATION_HOURS |
|
Certification Frequency Amount |
LEAVE_CERTIFICATION_FREQUENCY_AMOUNT |
|
Certification Frequency Amount Per Period |
LEAVE_CERTIFICATION_FREQUENCY_AMOUNT_PER_PERIOD |
|
Certification Frequency Per |
LEAVE_CERTIFICATION_FREQUENCY_PER |
|
Certification Frequency Period |
LEAVE_CERTIFICATION_FREQUENCY_PERIOD |
|
Certification Note |
LEAVE_CERTIFICATION_NOTE |
|
Certification Total Time (Hours) |
LEAVE_CERTIFICATION_TOTAL_TIME_AMOUNT_HOURS |
|
Certification Total Time Amount Per Period |
LEAVE_CERTIFICATION_TOTAL_TIME_AMOUNT_PER_PERIOD |
|
Certification Total Time Period |
LEAVE_CERTIFICATION_TOTAL_TIME_PERIOD |
|
Certification Tracking End Date |
LEAVE_CERTIFICATION_TRACKING_END_DATE |
|
Certification Tracking Start Date |
LEAVE_CERTIFICATION_TRACKING_START_DATE |
|
Leave Case Approval Status |
LEAVE_CASE_APPROVAL_STATUS |
|
Leave Case Category |
LEAVE_CASE_CATEGORY |
|
Leave Case Code |
LEAVE_CASE_CODE |
|
Leave Case Committed Continuous Paid Hours |
LEAVE_CASE_PAID_CONTINUOUS_EDITS_TOTALS |
|
Leave Case Committed Continuous Tracking Hours |
LEAVE_CASE_TRACKING_CONTINUOUS_EDITS_TOTALS |
|
Leave Case Committed Intermittent Paid Hours |
LEAVE_CASE_PAID_INTERMITTENT_EDITS_TOTALS |
|
Leave Case Committed Intermittent Tracking Hours |
LEAVE_CASE_TRACKING_INTERMITTENT_EDITS_TOTALS |
|
Leave Case Committed Paid Hours |
LEAVE_CASE_PAID_EDITS_TOTALS |
|
Leave Case Committed Paid Takings |
LEAVE_CASE_PAID_TAKINGS_TOTALS |
|
Leave Case Committed Tracking Hours |
LEAVE_CASE_TRACKING_EDITS_TOTALS |
|
Leave Case Committed Tracking Takings |
LEAVE_CASE_TRACKING_TAKINGS_TOTALS |
|
Leave Case Custom Amount of Time |
LEAVE_CASE_CUSTOM_FIELD_AMOUNT_OF_TIME |
|
Leave Case Custom Date |
LEAVE_CASE_CUSTOM_FIELD_DATE |
|
Leave Case Custom Number |
LEAVE_CASE_CUSTOM_FIELD_NUMBER |
|
Leave Case Custom Text |
LEAVE_CASE_CUSTOM_FIELD_TEXT |
|
Leave Case Default Days Of Week |
LEAVE_CASE_DATE_DEFAULTS |
|
Leave Case Default Destination |
LEAVE_CASE_DEFAULT_DESTINATION |
|
Leave Case Default Paid Amount |
LEAVE_CASE_DEFAULT_PAID_AMOUNT |
|
Leave Case Default Start Time |
LEAVE_CASE_DEFAULT_START_TIME |
|
Leave Case Default Tracking Amount |
LEAVE_CASE_DEFAULT_TRACKING_AMOUNT |
|
Leave Case Default Transfer |
LEAVE_CASE_DEFAULT_TRANSFER |
|
Leave Case End Date |
LEAVE_CASE_END_DATE |
|
Leave Case External Code |
LEAVE_CASE_EXTERNAL_CODE |
|
Leave Case Frequency |
LEAVE_CASE_FREQUENCY |
| Leave Case Frequency ID | LEAVE_CASE_FREQUENCY_ID |
|
Leave Case ID |
LEAVE_CASE_ID |
|
Leave Case Latest Committed Paid Date |
LEAVE_CASE_LATEST_COMMITTED_PAID_DATE |
|
Leave Case Latest Committed Tracking Date |
LEAVE_CASE_LATEST_COMMITTED_TRACKING_DATE |
|
Leave Case Long Case Code |
LEAVE_CASE_LONG_CASE_CODE |
|
Leave Case Reason |
LEAVE_CASE_REASON |
|
Leave Case Request Date |
LEAVE_CASE_REQUEST_DATE |
|
Leave Case Start Date |
LEAVE_CASE_START_DATE |
|
Leave Case Status |
LEAVE_CASE_STATUS |
|
Leave Rule Effective Date |
LEAVE_RULE_EFFECTIVE_DATE |
|
Leave Rule Name |
LEAVE_RULE_NAME |
|
Leave Type Total (Case Range) |
LEAVE_TYPE_TAKINGS_TOTALS_BY_CASE_RANGE |
|
Leave Type Total (Date Range) |
LEAVE_TYPE_TAKINGS_TOTALS_BY_DATE_RANGE |
Related entities
- Actual Paycode Totals Corrections Only
- Actual Paycode Totals Exclude Corrections
- Actual Paycode Totals Include Corrections
- Average Worked Hours
- Employee Details
- Leave Profile
- Pay Period
- Projected Paycode Totals Corrections Only
- Projected Paycode Totals Exclude Corrections
- Projected Paycode Totals Include Corrections
- Actual Totals Include Corrections
- Schedule Availability
- Schedule Group Assignment
- Schedule Group Totals
- Scheduled Paycode Totals
- Sign Off
- Totalization Status
Core entity
| Employee | Organization | Day | Organizational Job | Paycode | Labor Category |
|---|---|---|---|---|---|
| X |
Relationship
| One-to-One | One-to-Many |
|---|---|
| X |