DD Table Name | DD Column Name | DataType | TImeZone Information |
|---|
AnticipatedWorkorder | CreatedDate | datetime | No time Information. Has only Date |
AnticipatedWorkorder | ScheduledDate | datetime | No time Information. Has only Date |
AnticipatedWorkorder | ExpirationDate | datetime | Location Timezone |
AnticipatedWorkorder | CreatedDateInDataDirect | datetime | ET |
AnticipatedWorkorder | UpdatedDateInDataDirect | datetime | ET |
AnticipatedWorkorder_Frequency | StartOn | datetime | No time Information. Has only Date |
AnticipatedWorkorder_Frequency | StopOn | datetime | No time Information. Has only Date |
AnticipatedWorkorder_Frequency | CreatedDateInDataDirect | datetime | ET |
AnticipatedWorkorder_Frequency | UpdatedDateInDataDirect | datetime | ET |
Asset | EffectiveStartDate | datetime | ET |
Asset | EffectiveEndDate | datetime | ET |
Asset | InstallDate | datetime | No time Information. Has only Date |
Asset | PurchaseDate | datetime | No time Information. Has only Date |
Asset | WarrantyExpirationDate | datetime | No time Information. Has only Date |
Asset | DeactivatedDate | datetime | ET |
Asset | AssetCreatedDate | datetime | ET |
Asset | AssetModifiedDate | datetime | ET |
Asset | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
Asset | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
Asset | CreatedDateInDataDirect | datetime | ET |
Asset | UpdatedDateInDataDirect | datetime | ET |
AssetCustomAttributes | CreatedDateInDataDirect | datetime | ET |
AssetCustomAttributes | UpdatedDateInDataDirect | datetime | ET |
AssetInfo | EffectiveStartDate | datetime | ET |
AssetInfo | EffectiveEndDate | datetime | ET |
AssetInfo | AssetTypeAddedAt | datetime | ET |
AssetInfo | AssetTypeLastModifiedDate | datetime | ET |
AssetInfo | RetiredDate | datetime | ET |
AssetInfo | ManufacturedDate | datetime | ET |
AssetInfo | LeaseDate | datetime | No time Information. Has only Date |
AssetInfo | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
AssetInfo | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
AssetInfo | CreatedDateInDataDirect | datetime | ET |
AssetInfo | UpdatedDateInDataDirect | datetime | ET |
AssetLeakInspections | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
AssetLeakInspections | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
AssetLeakInspections | CreatedDateInDataDirect | datetime | ET |
AssetLeakInspections | UpdatedDateInDataDirect | datetime | ET |
AssetMeterReadings | MeasureDate | datetimeoffset(7) | Date & Time With offset to UTC |
AssetMeterReadings | CreatedDateInDataDirect | datetime | ET |
AssetMeterReadings | UpdatedDateInDataDirect | datetime | ET |
AssetRefrigerantCharge | ChargeEffectiveDate | datetime | No time Information. Has only Date |
AssetRefrigerantCharge | ChargeModifiedDate | datetimeoffset | Date & Time With offset to UTC |
AssetRefrigerantCharge | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
AssetRefrigerantCharge | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
AssetRefrigerantCharge | CreatedDateInDataDirect | datetime | ET |
AssetRefrigerantCharge | UpdatedDateInDataDirect | datetime | ET |
AssetRefrigerantLeak | TriggerDate | datetime | No time Information. Has only Date |
AssetRefrigerantLeak | RepairDate | datetime | ET |
AssetRefrigerantLeak | InitialVerificationDate | datetime | ET |
AssetRefrigerantLeak | FollowupDate | datetime | ET |
AssetRefrigerantLeak | GeneratedDate | datetime | ET |
AssetRefrigerantLeak | LeakRecordModifiedDate | datetimeoffset | Date & Time With offset to UTC |
AssetRefrigerantLeak | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
AssetRefrigerantLeak | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
AssetRefrigerantLeak | CreatedDateInDataDirect | datetime | ET |
AssetRefrigerantLeak | UpdatedDateInDataDirect | datetime | ET |
AssetRefrigerantLeakImmeasurable | RepairDate | datetime | ET |
AssetRefrigerantLeakImmeasurable | InitialVerificationDate | datetime | ET |
AssetRefrigerantLeakImmeasurable | FollowupVerificationDate | datetime | ET |
AssetRefrigerantLeakImmeasurable | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
AssetRefrigerantLeakImmeasurable | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
AssetRefrigerantLeakImmeasurable | CreatedDateInDataDirect | datetime | ET |
AssetRefrigerantLeakImmeasurable | UpdatedDateInDataDirect | datetime | ET |
AssetRefrigerantLeakImmeasurableNotes | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
AssetRefrigerantLeakImmeasurableNotes | CreatedDateInDataDirect | datetime | ET |
AssetRefrigerantLeakImmeasurableNotes | UpdatedDateInDataDirect | datetime | ET |
AssetRefrigerantLeakImmeasurableWOs | GeneratedDate | datetimeoffset | Date & Time With offset to UTC |
AssetRefrigerantLeakImmeasurableWOs | CreatedDateInDataDirect | datetime | ET |
AssetRefrigerantLeakImmeasurableWOs | UpdatedDateInDataDirect | datetime | ET |
AssetRefrigerantLeakNotes | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
AssetRefrigerantLeakNotes | CreatedDateInDataDirect | datetime | ET |
AssetRefrigerantLeakNotes | UpdatedDateInDataDirect | datetime | ET |
AssetRefrigerantLeakWOs | CreatedDateInDataDirect | datetime | ET |
AssetRefrigerantLeakWOs | UpdatedDateInDataDirect | datetime | ET |
assets | InstallDate | datetime | No time Information. Has only Date |
assets | PurchaseDate | datetime | No time Information. Has only Date |
assets | WarrantyExpirationDate | datetime | No time Information. Has only Date |
assets | DeactivatedDate | datetime | ET |
assets | CreatedDateInDataDirect | datetime | ET |
assets | UpdatedDateInDataDirect | datetime | ET |
AssetsInWorkorders | DateAdded | datetimeoffset | Date & Time With offset to UTC |
AssetsInWorkorders | CreatedDateInDataDirect | datetimeoffset | ET |
AssetsInWorkorders | UpdatedDateInDataDirect | datetimeoffset | ET |
AssetTypeCustomAttributes | CreatedDateInDataDirect | datetime | ET |
AssetTypeCustomAttributes | UpdatedDateInDataDirect | datetime | ET |
AssetValidationInfo | ValidatedDate | datetimeoffset | Date & Time With offset to UTC |
AssetValidationInfo | CreatedDateInDataDirect | datetimeoffset | ET |
AssetValidationInfo | UpdatedDateInDataDirect | datetimeoffset | ET |
audit | CreatedDateInDataDirect | datetime | ET |
audit | UpdatedDateInDataDirect | datetime | ET |
audit | StartDate_DTO | datetimeoffset | Date & Time With offset to UTC |
audit | FinishDate_DTO | datetimeoffset | Date & Time With offset to UTC |
audit_check_list_item | CreatedDateInDataDirect | datetime | ET |
audit_check_list_item | UpdatedDateInDataDirect | datetime | ET |
audit_issue_attachment | CreatedDateInDataDirect | datetime | ET |
audit_issue_attachment | UpdatedDateInDataDirect | datetime | ET |
audit_workorder | CreatedDateInDataDirect | datetime | ET |
audit_workorder | UpdatedDateInDataDirect | datetime | ET |
budget | UpdatedDate | datetime | ET |
budget | CreatedDateInDataDirect | datetime | ET |
budget | UpdatedDateInDataDirect | datetime | ET |
categories | CreatedDateInDataDirect | datetime | ET |
categories | UpdatedDateInDataDirect | datetime | ET |
CheckListAssetTaskResponses | StartTime | datetimeoffset | Date & Time With offset to UTC |
CheckListAssetTaskResponses | EndTime | datetimeoffset | Date & Time With offset to UTC |
CheckListAssetTaskResponses | CreatedDateInDataDirect | datetime | ET |
CheckListAssetTaskResponses | UpdatedDateInDataDirect | datetime | ET |
checklists | CreatedDate | datetime | ET |
checklists | UpdatedDate | datetime | ET |
checklists | ChecklistResponseUpdatedDate | datetime | ET |
checklists | ChecklistUpdatedDate | datetime | ET |
checklists | CreatedDateInDataDirect | datetime | ET |
checklists | UpdatedDateInDataDirect | datetime | ET |
CheckListTasks | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
CheckListTasks | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
CheckListTasks | CreatedDateInDataDirect | datetime | ET |
CheckListTasks | UpdatedDateInDataDirect | datetime | ET |
custom_asset_attributes | valueDate | datetime | No time Information. Has only Date |
custom_asset_attributes | UpdatedDate | datetime | ET |
custom_asset_attributes | CreatedDateInDataDirect | datetime | ET |
custom_asset_attributes | UpdatedDateInDataDirect | datetime | ET |
ftm | checkInDateTime | datetime | Location Timezone |
ftm | checkOutDateTime | datetime | Location Timezone |
ftm | checkInTime_dto | datetimeoffset | Date & Time With offset to UTC |
ftm | checkOutTime_dto | datetimeoffset | Date & Time With offset to UTC |
ftm | CreatedDateInDataDirect | datetime | ET |
ftm | UpdatedDateInDataDirect | datetime | ET |
InvalidInvoices | CreatedDateInDataDirect | datetime | ET |
InvalidInvoices | UpdatedDateInDataDirect | datetime | ET |
InvalidProposals | proposalDate | datetime | ET |
InvalidProposals | CreatedDateInDataDirect | datetime | ET |
InvalidProposals | UpdatedDateInDataDirect | datetime | ET |
InvalidRelationships | CreatedDateInDataDirect | datetime | ET |
InvalidRelationships | UpdatedDateInDataDirect | datetime | ET |
InvalidWorkorders | calldate | datetime | Location Timezone |
InvalidWorkorders | CreatedDateInDataDirect | datetime | ET |
InvalidWorkorders | UpdatedDateInDataDirect | datetime | ET |
invoiceinventory_laborcatalog | CreatedDateInDataDirectValidDate | datetime | ET |
invoice_labor | UpdatedDateInDataDirect | datetime | ET |
invoice_materials | CreatedDateInDataDirect | datetime | ET |
invoicedatetimeoffset | Date & Time With offset to UTC |
inventory_catalog | ExpireDate | datetimeoffset | Date & Time With offset to UTC |
inventory_catalog | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_catalog | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_catalog | CreatedDateInDataDirect | datetime | ET |
inventory_catalog | UpdatedDateInDataDirect | datetime | ET |
inventory_cyclecount_location_records | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_cyclecount_location_records | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_cyclecount_location_records | CreatedDateInDataDirect | datetime | ET |
inventory_cyclecount_location_records | UpdatedDateInDataDirect | datetime | ET |
inventory_cyclecount_schedule_parts | CreatedDateInDataDirect | datetime | ET |
inventory_cyclecount_schedule_parts | UpdatedDateInDataDirect | datetime | ET |
inventory_cyclecount_schedule_parttypes | CreatedDateInDataDirect | datetime | ET |
inventory_cyclecount_schedule_parttypes | UpdatedDateInDataDirect | datetime | ET |
inventory_cyclecount_schedules | DueDate | datetimeoffset | Date & Time With offset to UTC |
inventory_cyclecount_schedules | CompletionDate | datetimeoffset | Date & Time With offset to UTC |
inventory_cyclecount_schedules | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_cyclecount_schedules | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_cyclecount_schedules | CreatedDateInDataDirect | datetime | ET |
inventory_cyclecount_schedules | UpdatedDateInDataDirect | datetime | ET |
inventory_cyclecounts | CountDate | datetimeoffset | Date & Time With offset to UTC |
inventory_cyclecounts | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_cyclecounts | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_cyclecounts | CreatedDateInDataDirect | datetime | ET |
inventory_cyclecounts | UpdatedDateInDataDirect | datetime | ET |
inventory_locations | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_locations | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_locations | CreatedDateInDataDirect | datetime | ET |
inventory_locations | UpdatedDateInDataDirect | datetime | ET |
inventory_part_purchase | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_part_purchase | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_part_purchase | IssuedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_part_purchase | ReceivedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_part_purchase | CreatedDateInDataDirect | datetime | ET |
inventory_part_purchase | UpdatedDateInDataDirect | datetime | ET |
inventory_part_purchase_items | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_part_purchase_items | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_part_purchase_items | ReceivedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_part_purchase_items | CreatedDateInDataDirect | datetime | ET |
inventory_part_purchase_items | UpdatedDateInDataDirect | datetime | ET |
inventory_part_transit | TransferDate | datetimeoffset | Date & Time With offset to UTC |
inventory_part_transit | ShipDate | datetimeoffset | Date & Time With offset to UTC |
inventory_part_transit | DateModified | datetimeoffset | Date & Time With offset to UTC |
inventory_part_transit | CreatedDateInDataDirect | datetime | ET |
inventory_part_transit | UpdatedDateInDataDirect | datetime | ET |
inventory_part_transit_items | DateReceived | datetimeoffset | Date & Time With offset to UTC |
inventory_part_transit_items | CreatedDateInDataDirect | datetime | ET |
inventory_part_transit_items | UpdatedDateInDataDirect | datetime | ET |
inventory_part_usage | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_part_usage | ModifiedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_part_usage | CreatedDateInDataDirect | datetime | ET |
inventory_part_usage | UpdatedDateInDataDirect | datetime | ET |
inventory_part_usage_items | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_part_usage_items | ModifiedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_part_usage_items | UseDate | datetimeoffset | Date & Time With offset to UTC |
inventory_part_usage_items | CreatedDateInDataDirect | datetime | ET |
inventory_part_usage_items | UpdatedDateInDataDirect | datetime | ET |
inventory_parts | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_parts | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_parts | CreatedDateInDataDirect | datetime | ET |
inventory_parts | UpdatedDateInDataDirect | datetime | ET |
inventory_stock | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_stock | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_stock | CreatedDateInDataDirect | datetime | ET |
inventory_stock | UpdatedDateInDataDirect | datetime | ET |
inventory_stock_manual_change | ChangedDate | datetimeoffset | Date & Time With offset to UTC |
inventory_stock_manual_change | CreatedDateInDataDirect | datetime | ET |
inventory_stock_manual_change | UpdatedDateInDataDirect | datetime | ET |
invoice_labor | CreatedDateInDataDirect | datetime | ET |
invoice_labor | UpdatedDateInDataDirect | datetime | ET |
invoice_materials | CreatedDateInDataDirect | datetime | ET |
invoice_materials | UpdatedDateInDataDirect | datetime | ET |
invoice_statuses | CreatedDateInDataDirect | datetime | ET |
invoice_statuses | UpdatedDateInDataDirect | datetime | ET |
invoices | invoiceDate | datetime | Location Timezone |
invoices | postedDate | datetime | Location Timezone |
invoices | TransferDate | datetime | Location Timezone |
invoices | lastModifiedDate | datetime | ET |
invoices | createdDate | datetime | ET |
invoices | approvedDate | datetime | ET |
invoices | approvedDateDto | datetimeoffset | Date & Time With offset to UTC |
invoices | lastPaymentDateDto | datetimeoffset | Date & Time With offset to UTC |
invoices | postedDateDto | datetimeoffset | Date & Time With offset to UTC |
invoices | createdDateDto | datetimeoffset | Date & Time With offset to UTC |
invoices | transferredDateDto | datetimeoffset | Date & Time With offset to UTC |
invoices | CreatedDateInDataDirect | datetime | ET |
invoices | UpdatedDateInDataDirect | datetime | ET |
label_history | UpdatedDateDto | datetimeoffset | Date & Time With offset to UTC |
label_history | CreatedDateInDataDirect | datetime | ET |
label_history | UpdatedDateInDataDirect | datetime | ET |
labels | CreatedDateInDataDirect | datetime | ET |
labels | UpdatedDateInDataDirect | datetime | ET |
LeakInspectionComplianceAcknowledgement | DateAccepted | datetimeoffset | Date & Time With offset to UTC |
LeakInspectionComplianceAcknowledgement | CreatedDateInDataDirect | datetime | ET |
LeakInspectionComplianceAcknowledgement | UpdatedDateInDataDirect | datetime | ET |
locations | openedDate | datetime | No time Information. Has only Date |
locations | closedDate | datetime | No time Information. Has only Date |
locations | CreatedDateInDataDirect | datetime | ET |
locations | UpdatedDateInDataDirect | datetime | ET |
locations_notes | CreatedDateInDataDirect | datetime | ET |
locations_notes | UpdatedDateInDataDirect | datetime | ET |
locations_notes_headers | CreatedDateInDataDirect | datetime | ET |
locations_notes_headers | UpdatedDateInDataDirect | datetime | ET |
Materials | UseDate | datetimeoffset | Date & Time With offset to UTC |
Materials | ScMatCreatedDate | datetimeoffset | Date & Time With offset to UTC |
Materials | ScMatUpdatedDate | datetimeoffset | Date & Time With offset to UTC |
Materials | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
Materials | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
Materials | WoCallDate | datetime | Location Timezone |
Materials | WoCallDate_dto | datetimeoffset | Date & Time With offset to UTC |
Materials | CreatedDateInDataDirect | datetime | ET |
Materials | UpdatedDateInDataDirect | datetime | ET |
notes_statistics | noteDate | datetime | No time Information. Has only Date |
notes_statistics | firstNoteDateTime | datetime | ET |
notes_statistics | lastNoteDatetime | datetime | ET |
notes_statistics | CreatedDateInDataDirect | datetime | ET |
notes_statistics | UpdatedDateInDataDirect | datetime | ET |
PartUsageAudit | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
PartUsageAudit | CreatedDateInDataDirect | datetime | ET |
PartUsageAudit | UpdatedDateInDataDirect | datetime | ET |
priorities | CreatedDateInDataDirect | datetime | ET |
priorities | UpdatedDateInDataDirect | datetime | ET |
Program | StartDate | datetimeoffset | Date & Time With offset to UTC |
Program | EndDate | datetimeoffset | Date & Time With offset to UTC |
Program | CreatedOn | datetimeoffset | Date & Time With offset to UTC |
Program | LastUpdatedOn | datetimeoffset | Date & Time With offset to UTC |
Program | CreatedDateInDataDirect | datetime | ET |
Program | UpdatedDateInDataDirect | datetime | ET |
Project | CreatedOn | datetimeoffset | Date & Time With offset to UTC |
Project | LastUpdatedOn | datetimeoffset | Date & Time With offset to UTC |
Project | CreatedDateInDataDirect | datetime | ET |
Project | UpdatedDateInDataDirect | datetime | ET |
project_tasks_rfps | StartDate | datetimeoffset | Date & Time With offset to UTC |
project_tasks_rfps | DueDate | datetimeoffset | Date & Time With offset to UTC |
project_tasks_rfps | AssignedOn | datetimeoffset | Date & Time With offset to UTC |
project_tasks_rfps | CreatedOn | datetimeoffset | Date & Time With offset to UTC |
project_tasks_rfps | LastUpdatedOn | datetimeoffset | Date & Time With offset to UTC |
project_tasks_rfps | IssuedOn | datetimeoffset | Date & Time With offset to UTC |
project_tasks_rfps | CreatedDateInDataDirect | datetime | ET |
project_tasks_rfps | UpdatedDateInDataDirect | datetime | ET |
project_tasks_workorders | CallDate | datetimeoffset | Date & Time With offset to UTC |
project_tasks_workorders | CreatedOn | datetimeoffset | Date & Time With offset to UTC |
project_tasks_workorders | LastUpdatedOn | datetimeoffset | Date & Time With offset to UTC |
project_tasks_workorders | IssuedOn | datetimeoffset | Date & Time With offset to UTC |
project_tasks_workorders | CreatedDateInDataDirect | datetime | ET |
project_tasks_workorders | UpdatedDateInDataDirect | datetime | ET |
proposal_line_items | CreatedDateInDataDirect | datetime | ET |
proposal_line_items | UpdatedDateInDataDirect | datetime | ET |
proposal_status_history | createdDate | datetime | Location Timezone |
proposal_status_history | ApprovedDate | datetime | Location Timezone |
proposal_status_history | OnHoldDate | datetime | Location Timezone |
proposal_status_history | RejectedDate | datetime | Location Timezone |
proposal_status_history | VoidDate | datetime | Location Timezone |
proposal_status_history | OpenDate | datetime | Location Timezone |
proposal_status_history | AssignedDate | datetime | Location Timezone |
proposal_status_history | ScheduledDate | datetime | Location Timezone |
proposal_status_history | CreatedDateInDataDirect | datetime | ET |
proposal_status_history | UpdatedDateInDataDirect | datetime | ET |
proposal_statuses | CreatedDateInDataDirect | datetime | ET |
proposal_statuses | UpdatedDateInDataDirect | datetime | ET |
proposals | proposalDate | datetime | ET |
proposals | approvedDate | datetime | UTC |
proposals | lastModifiedDate | datetime | UTC |
proposals | rejectedDate | datetime | UTC |
proposals | onHoldDate | datetime | UTC |
proposals | requestedDate | datetime | Location Timezone |
proposals | createdDate | datetime | ET |
proposals | CreatedDateInDataDirect | datetime | ET |
proposals | UpdatedDateInDataDirect | datetime | ET |
provider_communications | CreatedDateInDataDirect | datetime | ET |
provider_communications | UpdatedDateInDataDirect | datetime | ET |
provider_users | createdDate | datetime | ET |
provider_users | updatedDate | datetime | ET |
provider_users | CreatedDateInDataDirect | datetime | ET |
provider_users | UpdatedDateInDataDirect | datetime | ET |
providers | CreatedDateInDataDirect | datetime | ET |
providers | UpdatedDateInDataDirect | datetime | ET |
raw_proposals | proposalDate | datetime | ET |
raw_proposals | approvedDate | datetime | UTC |
raw_proposals | lastModifiedDate | datetime | UTC |
raw_proposals | rejectedDate | datetime | UTC |
raw_proposals | onHoldDate | datetime | UTC |
raw_proposals | createdDate | datetime | ET |
raw_workorders | calldate | datetime | Location Timezone |
raw_workorders | completiondate | datetime | Location Timezone |
raw_workorders | scheduledDate | datetime | Location Timezone |
raw_workorders | reassigneddate | datetime | Location Timezone |
raw_workorders | assignedDate | datetime | ET |
raw_workorders | ProjectedCompletionDate | datetimeoffset | Location Timezone |
raw_workorders | lastModifiedDate | datetime | ET |
raw_workorders | createdDate | datetime | ET |
real_estate | CallDate | datetime | Location Timezone |
real_estate | WorkDate | datetime | Location Timezone |
real_estate | InvoiceDate | datetime | Location Timezone |
real_estate | InvoiceApprovedDate | datetime | ET |
real_estate | SpendDate | datetime | Location Timezone |
real_estate | UpdatedDate | datetime | ET |
real_estate | CreatedDateInDataDirect | datetime | ET |
real_estate | UpdatedDateInDataDirect | datetime | ET |
RefreshStatus | CompletedDate | datetime | ET |
RefrigerantCertificationActionLogs | CreatedDateDto | datetimeoffset | Date & Time With offset to UTC |
RefrigerantCertificationActionLogs | UpdatedDateDto | datetimeoffset | Date & Time With offset to UTC |
RefrigerantCertificationActionLogs | CreatedDateInDataDirect | datetime | ET |
RefrigerantCertificationActionLogs | UpdatedDateInDataDirect | datetime | ET |
RefrigerantCertificationActionTypes | CreatedDateDto | datetimeoffset | Date & Time With offset to UTC |
RefrigerantCertificationActionTypes | UpdatedDateDto | datetimeoffset | Date & Time With offset to UTC |
RefrigerantCertificationActionTypes | CreatedDateInDataDirect | datetime | ET |
RefrigerantCertificationActionTypes | UpdatedDateInDataDirect | datetime | ET |
RefrigerantTypes | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
RefrigerantTypes | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
RefrigerantTypes | CreatedDateInDataDirect | datetime | ET |
RefrigerantTypes | UpdatedDateInDataDirect | datetime | ET |
relationships | createdDate | datetime | ET |
relationships | updatedDate | datetime | ET |
relationships | CreatedDateInDataDirect | datetime | ET |
relationships | UpdatedDateInDataDirect | datetime | ET |
resolution_codes | createdDateDto | datetimeoffset | Date & Time With offset to UTC |
resolution_codes | CreatedDateInDataDirect | datetime | ET |
resolution_codes | UpdatedDateInDataDirect | datetime | ET |
resolutions | lastModifiedDate | datetime | ET |
resolutions | CreatedDateInDataDirect | datetime | ET |
resolutions | UpdatedDateInDataDirect | datetime | ET |
rfp | rfpDate | datetime | Location Timezone |
rfp | created | datetime | ET |
rfp | dueDate | datetime | Location Timezone |
rfp | responseDate | datetime | Location Timezone |
rfp | lastModifiedDate | datetime | ET |
rfp | deletedDate | datetime | ET |
rfp | CreatedDateInDataDirect | datetime | ET |
rfp | UpdatedDateInDataDirect | datetime | ET |
root_causes | CreatedDateInDataDirect | datetime | ET |
root_causes | UpdatedDateInDataDirect | datetime | ET |
spend | CallDate | datetime | Location Timezone |
spend | WorkDate | datetime | Location Timezone |
spend | ScheduledDate | datetime | Location Timezone |
spend | SpendDate | datetime | Location Timezone |
spend | UpdatedDate | datetime | ET |
spend | CreatedDateInDataDirect | datetime | ET |
spend | UpdatedDateInDataDirect | datetime | ET |
StarRatings | CreatedDate | datetimeoffset | Date & Time With offset to UTC |
StarRatings | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
StarRatings | CreatedDateInDataDirect | datetimeoffset | ET |
StarRatings | UpdatedDateInDataDirect | datetimeoffset | ET |
statuses | CreatedDateInDataDirect | datetime | ET |
statuses | UpdatedDateInDataDirect | datetime | ET |
technician_assigned_accepted | UpdatedTechnicianDateUtc | datetime | ET |
technician_assigned_accepted | UpdatedTechnicianDateDto | datetimeoffset | Date & Time With offset to UTC |
technician_assigned_accepted | CreatedDateInDataDirect | datetime | ET |
technician_assigned_accepted | UpdatedDateInDataDirect | datetime | ET |
technician_assigned_accepted | WOAssignmentDateDto | datetimeoffset | Date & Time With offset to UTC |
technician_availability_log | unavailableUntilDate | datetime | ET |
technician_availability_log | createdDate | datetime | ET |
technician_availability_log | unavailableUntilDateDto | datetimeoffset | Date & Time With offset to UTC |
technician_availability_log | createdDateDto | datetimeoffset | Date & Time With offset to UTC |
technician_availability_log | CreatedDateInDataDirect | datetime | ET |
technician_availability_log | UpdatedDateInDataDirect | datetime | ET |
technician_time_tracking | startDate | datetime | Location Timezone |
technician_time_tracking | endDate | datetime | Location Timezone |
technician_time_tracking | startDateTime_dto | datetimeoffset | Date & Time With offset to UTC |
technician_time_tracking | endDateTime_dto | datetimeoffset | Date & Time With offset to UTC |
technician_time_tracking | CreatedDateInDataDirect | datetime | ET |
technician_time_tracking | UpdatedDateInDataDirect | datetime | ET |
technician_time_tracking_combined | startDateTime | datetime | Location Timezone |
technician_time_tracking_combined | endDateTime | datetime | Location Timezone |
technician_time_tracking_combined | startDateTime_dto | datetimeoffset | Date & Time With offset to UTC |
technician_time_tracking_combined | endDateTime_dto | datetimeoffset | Date & Time With offset to UTC |
technician_time_tracking_combined | CreatedDateInDataDirect | datetime | ET |
technician_time_tracking_combined | UpdatedDateInDataDirect | datetime | ET |
technician_time_tracking_history | OriginalStartTimeUtc | datetime | UTC |
technician_time_tracking_history | OriginalEndTimeUtc | datetime | UTC |
technician_time_tracking_history | NewStartTimeUtc | datetime | UTC |
technician_time_tracking_history | NewEndTimeUtc | datetime | UTC |
technician_time_tracking_history | LogTimeUtc | datetime | UTC |
technician_time_tracking_history | OriginalStartTimeDto | datetimeoffset | Date & Time With offset to UTC |
technician_time_tracking_history | OriginalEndTimeDto | datetimeoffset | Date & Time With offset to UTC |
technician_time_tracking_history | NewStartTimeDto | datetimeoffset | Date & Time With offset to UTC |
technician_time_tracking_history | NewEndTimeDto | datetimeoffset | Date & Time With offset to UTC |
technician_time_tracking_history | LogTimeDto | datetimeoffset | Date & Time With offset to UTC |
technician_time_tracking_history | CreatedDateInDataDirect | datetime | ET |
technician_time_tracking_history | UpdatedDateInDataDirect | datetime | ET |
TechnicianRefrigerantCertificationFiles | CreatedDateInDataDirect | datetimeoffset | ET |
TechnicianRefrigerantCertificationFiles | UpdatedDateInDataDirect | datetimeoffset | ET |
TechnicianRefrigerantCertifications | CertificationExpirationDate | datetimeoffset | Date & Time With offset to UTC |
TechnicianRefrigerantCertifications | CreatedDateInDataDirect | datetimeoffset | ET |
TechnicianRefrigerantCertifications | UpdatedDateInDataDirect | datetimeoffset | ET |
time_zone_info | CreatedDateInDataDirect | datetime | ET |
time_zone_info | UpdatedDateInDataDirect | datetime | ET |
trades | CreatedDateInDataDirect | datetime | ET |
trades | UpdatedDateInDataDirect | datetime | ET |
users | createdDate | datetime | ET |
users | updatedDate | datetime | ET |
users | CreatedDateInDataDirect | datetime | ET |
users | UpdatedDateInDataDirect | datetime | ET |
vendors | CreatedDateInDataDirect | datetime | ET |
vendors | UpdatedDateInDataDirect | datetime | ET |
wo_amount_breakdown | lastModifiedDate | datetime | ET |
wo_amount_breakdown | CreatedDateInDataDirect | datetime | ET |
wo_amount_breakdownUpdatedDateInDataDirect | UpdatedDateInDataDirect | datetime | ET |
wo_history_amount_change | datecreated | datetime | ET |
wo_history_amount_change | CreatedDateInDataDirect | datetime | ET |
wo_history_amount_change | UpdatedDateInDataDirect | datetime | ET |
wo_history_change_category | CreatedDate | datetime | ET |
wo_history_change_category | CreatedDateInDataDirect | datetime | ET |
wo_history_amountchange_changecategory | datecreatedUpdatedDateInDataDirect | datetime | ET |
wo_history_change_estimated_amountcompletion_changedate | CreatedDateInDataDirectOldEstimatedCompletionDate | datetime | ETdatetimeoffset | Date & Time With offset to UTC |
wo_history_amount_change | UpdatedDateInDataDirect | datetime | ETchange_estimated_completion_date | NewEstimatedCompletionDate | datetimeoffset | Date & Time With offset to UTC |
wo_history_change_estimated_categorycompletion_date | CreatedDateUpdatedDate | datetime | ETdatetimeoffset | Date & Time With offset to UTC |
wo_history_change_categoryestimated_completion_date | CreatedDateInDataDirect | datetime | ET |
wo_history_change_categoryestimated_completion_date | UpdatedDateInDataDirect | datetime | ET |
wo_history_change_nte | createdDate | datetime | ET |
wo_history_change_nte | CreatedDateInDataDirect | datetime | ET |
wo_history_change_nte | UpdatedDateInDataDirect | datetime | ET |
wo_history_change_priority | UpdatedDate | datetime | ET |
wo_history_change_priority | CreatedDateInDataDirect | datetime | ET |
wo_history_change_priority | UpdatedDateInDataDirect | datetime | ET |
wo_history_change_problem | UpdatedDate | datetime | ET |
wo_history_change_problem | CreatedDateInDataDirect | datetime | ET |
wo_history_change_problem | UpdatedDateInDataDirect | datetime | ET |
wo_history_change_provider | CreatedDate | datetime | ET |
wo_history_change_provider | CreatedDate_dto | datetimeoffset | Date & Time With offset to UTC |
wo_history_change_provider | CreatedDateInDataDirect | datetime | ET |
wo_history_change_provider | UpdatedDateInDataDirect | datetime | ET |
wo_history_change_scheduled_date | oldScheduledDate | datetime | Location Timezone |
wo_history_change_scheduled_date | newScheduledDate | datetime | Location Timezone |
wo_history_change_scheduled_date | updatedDate | datetime | ET |
wo_history_change_scheduled_date | CreatedDateInDataDirect | datetime | ET |
wo_history_change_scheduled_date | UpdatedDateInDataDirect | datetime | ET |
wo_history_change_status | updatedDate | datetime | ET |
wo_history_change_status | updatedDateDto | datetimeoffset | Date & Time With offset to UTC |
wo_history_change_status | CreatedDateInDataDirect | datetime | ET |
wo_history_change_status | UpdatedDateInDataDirect | datetime | ET |
wo_history_change_trade | UpdatedDate | datetime | ET |
wo_history_change_trade | CreatedDateInDataDirect | datetime | ET |
wo_history_change_trade | UpdatedDateInDataDirect | datetime | ET |
workorder_additional_approval_codes | SrcCreatedDate | datetime | ET |
workorder_additional_approval_codes | CreatedDateInDataDirect | datetime | ET |
workorder_additional_approval_codes | UpdatedDateInDataDirect | datetime | ET |
workorder_attachment_info | UploadDate | datetimeoffset | Date & Time With offset to UTC |
workorder_attachment_info | CreatedDateInDataDirect | datetime | ET |
workorder_attachment_info | UpdatedDateInDataDirect | datetime | ET |
workorder_ivr | ivrTime | datetime | Location Timezone |
workorder_ivr | lastModifiedDate | datetime | ET |
workorder_ivr | CreatedDateInDataDirect | datetime | ET |
workorder_ivr | UpdatedDateInDataDirect | datetime | ET |
workorder_labor_performed | WorkDate | datetime | No time Information. Has only Date |
workorder_labor_performed | checkInTime | datetime | Location Timezone |
workorder_labor_performed | checkOutTime | datetime | Location Timezone |
workorder_labor_performed | CreatedDate | datetime | ET |
workorder_labor_performed | UpdatedDate | datetime | ET |
workorder_labor_performed | checkInTime_dto | datetimeoffset | Date & Time With offset to UTC |
workorder_labor_performed | checkOutTime_dto | datetimeoffset | Date & Time With offset to UTC |
workorder_labor_performed | CreatedDate_dto | datetimeoffset | Date & Time With offset to UTC |
workorder_labor_performed | UpdatedDate_dto | datetimeoffset | Date & Time With offset to UTC |
workorder_labor_performed | CreatedDateInDataDirect | datetime | ET |
workorder_labor_performed | UpdatedDateInDataDirect | datetime | ET |
workorder_mechanic | ivrTime | datetime | Location Timezone |
workorder_mechanic | lastModifiedDate | datetime | ET |
workorder_mechanic | CreatedDateInDataDirect | datetime | ET |
workorder_mechanic | UpdatedDateInDataDirect | datetime | ET |
workorder_notes | CreatedDate | datetime | ET |
workorder_notes | Date_Created_dto | datetimeoffset | Date & Time With offset to UTC |
workorder_notes | CreatedDateInDataDirect | datetime | ET |
workorder_notes | UpdatedDateInDataDirect | datetime | ET |
workorder_notes | ActionRequiredResolvedDate | datetimeoffset | Date & Time With offset to UTC |
workorder_notes_new | CreatedDate | datetime | ET |
workorder_notes_new | Date_Created_dto | datetimeoffset | Date & Time With offset to UTC |
workorder_notes_new | CreatedDateInDataDirect | datetime | ET |
workorder_notes_new | UpdatedDateInDataDirect | datetime | ET |
workorder_notes_new | ActionRequiredResolvedDate | datetimeoffset | Date & Time With offset to UTC |
workorder_quality_survey | createdDate | datetime | ET |
workorder_quality_survey | CreatedDateInDataDirect | datetime | ET |
workorder_quality_survey | UpdatedDateInDataDirect | datetime | ET |
workorder_reassignment_reasons | actionTimeStamp | datetime | ET |
workorder_reassignment_reasons | actionTimeStamp_dto | datetimeoffset | Date & Time With offset to UTC |
workorder_reassignment_reasons | CreatedDateInDataDirect | datetime | ET |
workorder_reassignment_reasons | UpdatedDateInDataDirect | datetime | ET |
workorders | calldate | datetime | Location Timezone |
workorders | completiondate | datetime | Location Timezone |
workorders | scheduledDate | datetime | Location Timezone |
workorders | reassigneddate | datetime | Location Timezone |
workorders | assignedDate | datetime | ET |
workorders | ProjectedCompletionDate | datetimeoffset | Location Timezone |
workorders | lastModifiedDate | datetime | ET |
workorders | createdDate | datetime | ET |
workorders | CreatedDateInDataDirect | datetime | ET |
workorders | UpdatedDateInDataDirect | datetime | ET |
workorders_ext | eta | datetime | Location Timezone |
workorders_ext | originalEta | datetime | Location Timezone |
workorders_ext | postedDate | datetime | Location Timezone |
workorders_ext | poLoadFlagDate | datetime | Location Timezone |
workorders_ext | CreatedDateInDataDirect | datetime | ET |
workorders_ext | UpdatedDateInDataDirect | datetime | ET |
workorders_linked | dateCreated | datetime | ET |
workorders_linked | CreatedDateInDataDirect | datetime | ET |
workorders_linked | UpdatedDateInDataDirect | datetime | ET |
workorders_pm_compliance | ValidFromDate | datetimeoffset | Date & Time With offset to UTC |
workorders_pm_compliance | ValidToDate | datetimeoffset | Date & Time With offset to UTC |
workorders_pm_compliance | UpdatedDate | datetimeoffset | Date & Time With offset to UTC |
workorders_pm_compliance | CreatedDateInDataDirect | datetime | ET |
workorders_pm_compliance | UpdatedDateInDataDirect | datetime | ET |
