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.

Data Granularity

Provides one row per employee per leave case.

Supported Dataview/RDO Type

Employee Business Structure Employee - Time Series Business Structure - Time Series Work Unit Work Unit - Time Series

Columns
Certification Episode Duration (Days) LEAVE_CERTIFICATION_EPISODE_DURATION_DAYS Number No
Certification Episode Duration (Hours) LEAVE_CERTIFICATION_EPISODE_DURATION_HOURS Number No
Certification Frequency Amount LEAVE_CERTIFICATION_FREQUENCY_AMOUNT Number No
Certification Frequency Amount Per Period LEAVE_CERTIFICATION_FREQUENCY_AMOUNT_PER_PERIOD Number No
Certification Frequency Per LEAVE_CERTIFICATION_FREQUENCY_PER String No
Certification Frequency Period LEAVE_CERTIFICATION_FREQUENCY_PERIOD String No
Certification Note LEAVE_CERTIFICATION_NOTE String No
Certification Total Time (Hours) LEAVE_CERTIFICATION_TOTAL_TIME_AMOUNT_HOURS Number No
Certification Total Time Amount Per Period LEAVE_CERTIFICATION_TOTAL_TIME_AMOUNT_PER_PERIOD Number No
Certification Total Time Period LEAVE_CERTIFICATION_TOTAL_TIME_PERIOD String No
Certification Tracking End Date LEAVE_CERTIFICATION_TRACKING_END_DATE Date No
Certification Tracking Start Date LEAVE_CERTIFICATION_TRACKING_START_DATE Date No
Leave Case Approval Status LEAVE_CASE_APPROVAL_STATUS String No
Leave Case Category LEAVE_CASE_CATEGORY String No
Leave Case Code LEAVE_CASE_CODE String No
Leave Case Committed Continuous Paid Hours LEAVE_CASE_PAID_CONTINUOUS_EDITS_TOTALS Number No
Leave Case Committed Continuous Tracking Hours LEAVE_CASE_TRACKING_CONTINUOUS_EDITS_TOTALS Number No
Leave Case Committed Intermittent Paid Hours LEAVE_CASE_PAID_INTERMITTENT_EDITS_TOTALS Number No
Leave Case Committed Intermittent Tracking Hours LEAVE_CASE_TRACKING_INTERMITTENT_EDITS_TOTALS Number No
Leave Case Committed Paid Hours LEAVE_CASE_PAID_EDITS_TOTALS Number No
Leave Case Committed Paid Takings LEAVE_CASE_PAID_TAKINGS_TOTALS Number No
Leave Case Committed Tracking Hours LEAVE_CASE_TRACKING_EDITS_TOTALS Number No
Leave Case Committed Tracking Takings LEAVE_CASE_TRACKING_TAKINGS_TOTALS Number No
Leave Case Custom Amount of Time LEAVE_CASE_CUSTOM_FIELD_AMOUNT_OF_TIME Number No
Leave Case Custom Date LEAVE_CASE_CUSTOM_FIELD_DATE Date No
Leave Case Custom Number LEAVE_CASE_CUSTOM_FIELD_NUMBER Number No
Leave Case Custom Text LEAVE_CASE_CUSTOM_FIELD_TEXT String No
Leave Case Default Days Of Week LEAVE_CASE_DATE_DEFAULTS String No
Leave Case Default Destination LEAVE_CASE_DEFAULT_DESTINATION String No
Leave Case Default Paid Amount LEAVE_CASE_DEFAULT_PAID_AMOUNT Number No
Leave Case Default Start Time LEAVE_CASE_DEFAULT_START_TIME String No
Leave Case Default Tracking Amount LEAVE_CASE_DEFAULT_TRACKING_AMOUNT Number No
Leave Case Default Transfer LEAVE_CASE_DEFAULT_TRANSFER String No
Leave Case End Date LEAVE_CASE_END_DATE Date No
Leave Case External Code LEAVE_CASE_EXTERNAL_CODE String No
Leave Case Frequency LEAVE_CASE_FREQUENCY String No
Leave Case Frequency ID LEAVE_CASE_FREQUENCY_ID String No
Leave Case ID LEAVE_CASE_ID String No
Leave Case Latest Committed Paid Date LEAVE_CASE_LATEST_COMMITTED_PAID_DATE Date No
Leave Case Latest Committed Tracking Date LEAVE_CASE_LATEST_COMMITTED_TRACKING_DATE Date No
Leave Case Long Case Code LEAVE_CASE_LONG_CASE_CODE String No
Leave Case Reason LEAVE_CASE_REASON String No
Leave Case Request Date LEAVE_CASE_REQUEST_DATE Date No
Leave Case Start Date LEAVE_CASE_START_DATE Date No
Leave Case Status LEAVE_CASE_STATUS String No
Leave Rule Effective Date LEAVE_RULE_EFFECTIVE_DATE Date No
Leave Rule Name LEAVE_RULE_NAME String No
Leave Type Total (Case Range) LEAVE_TYPE_TAKINGS_TOTALS_BY_CASE_RANGE Number No
Leave Type Total (Date Range) LEAVE_TYPE_TAKINGS_TOTALS_BY_DATE_RANGE Number No

Related Entities

Core Entity

EmployeeOrganizationDayOrganizational JobPaycodeLabor CategoryActivityWork UnitWork GroupProcedure Code

Relationship

One-to-One One-to-Many