EP
EPTimeLog
Represents the clock-in and clock-out time log.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | Created At | - | |
Description:No description available | ||||
CreatedDateTime | datetime | Created On | - | |
Description:No description available | ||||
DocumentNbr | nvarchar(255) | Record ID | - | |
Description:The document number of the time log record. The value of this field corresponds to the unique key values of the entity specified in RelatedEntityID. | ||||
EmployeeID | int | Employee | - | |
Description:The identifier of the employee who uses the time logging. Corresponds to the BAccount.BAccountID field. | ||||
EndDate | datetime | End Date | - | |
Description:The end date and time of the time log record. | ||||
EndDateReported | datetime | End Date | - | |
Description:The end date and time, which are displayed and modified depending on the time zone in ReportedInTimeZoneID. | ||||
IsLocked | bit | - | ||
Description:The field is equal to True if at least one CR.PMTimeActivity has been created from this record. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | Last Modified At | - | |
Description:No description available | ||||
LastModifiedDateTime | datetime | Last Modified On | - | |
Description:No description available | ||||
RelatedEntityID | uniqueidentifier | - | ||
Description:Contains the INotable.NoteID value of the time log-related entity. | ||||
RelatedEntityType | nvarchar(255) | Record Type | - | |
Description:Contains the type of the related entity that is specified in EPTimeLog.RelatedEntityID. | ||||
ReportedInTimeZoneID | nvarchar(32) | Reported in Time Zone | - | |
Description:The timezone of the time log record. | ||||
StartDate | datetime | Start Date | - | |
Description:The start date and time of the time log record. | ||||
StartDateReported | datetime | Start Date | - | |
Description:The start date and time, which are displayed and modified depending on the time zone in ReportedInTimeZoneID. | ||||
Summary | nvarchar(255) | Description | - | |
Description:The summary of the time log record. The value of this field corresponds to the description of the entity specified in RelatedEntityID. | ||||
TimeLogID | int | - | ||
Description:No description available | ||||
TimeLogTypeID | nvarchar(15) | Type | EPTimeLogType | |
Description:The identifier of the time log type associated with the time log record. The value of this field corresponds to the value of the EPTimeLogType.TimeLogTypeID field. | ||||
TimeSpent | int | Time Spent | - | |
Description:The time spent of the time log record. The interval in minutes between StartDate and EndDate. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||