EP
TimeCardMaint.EPTimecardDetailOrig
Required for correct join
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
AMIsProd | bit | - | ||
Description:Indicates a production related time activity | ||||
ARDocTypeNonexistent in DB | string | Type | - | |
Description:No description available | ||||
ARRefNbrNonexistent in DB | string | Reference Nbr. | ARRegister | |
Description:No description available | ||||
AppointmentCustomerID | int | Customer ID | Customer | |
Description:No description available | ||||
AppointmentID | int | Appointment Nbr. | FSAppointment | |
Description:No description available | ||||
ApprovalStatus | char(2) | Approval Status | - | |
Description:No description available | ||||
ApprovedDate | datetime | Approved Date | - | |
Description:No description available | ||||
ApproverID | int | Approver | EPEmployee | |
Description:No description available | ||||
BillableOvertimeCalcNonexistent in DB | int? | Billable OT | - | |
Description:No description available | ||||
BillableTimeCalcNonexistent in DB | int? | Billable Time | - | |
Description:The billable time for the employee. | ||||
Billed | bit | Billed | - | |
Description:No description available | ||||
CaseCD | nvarchar(15) | Case ID | CRCase | |
Description:The user-friendly unique identifier of the Case associated with this activity. | ||||
CertifiedJob | bit | Certified Job | - | |
Description:No description available | ||||
ContractCD | nvarchar | Contract ID | ContractBillingSchedule | |
Description:The user-friendly unique identifier of the Contract associated with this activity. | ||||
ContractID | int | Contract | Contract | |
Description:No description available | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:The identifier of the cost code associated with the activity. The value of this field corresponds to the value of the PMCostCode.costCodeID field. | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | Created At | - | |
Description:No description available | ||||
Date | datetime | Date | - | |
Description:The date of the record. The default date is defined in EP.EPEmployeeClass. | ||||
DayNonexistent in DB | string | Day | - | |
Description:The day of the week for which the activity has been reported. This is a read-only calculated field. Possible values: Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday. | ||||
DayOfWeekNonexistent in DB | int? | Day | - | |
Description:No description available | ||||
EarningTypeID | nvarchar(15) | Earning Type | EPEarningType | |
Description:No description available | ||||
EmployeeRate | decimal | Cost Rate | - | |
Description:Stores Employee's Hourly rate at the time the activity was released to PM | ||||
ExtRefNbr | nvarchar(30) | External Ref. Nbr | - | |
Description:No description available | ||||
IsActivityExistsNonexistent in DB | bool? | Activity Exists | - | |
Description:No description available | ||||
IsBillable | bit | Billable | - | |
Description:Indicates if the work hours are billable. | ||||
IsCorrected | bit | - | ||
Description:If true this Activity has been corrected in the Timecard and is no longer valid. Please hide this activity in all lists displayed in the UI since there is another valid activity. The valid activity has a refence back to the corrected activity via OrigTaskID field. | ||||
IsCreatedFromTimeLogNonexistent in DB | bool? | Time Log | - | |
Description:Read-only field that is equal to "true" in case the record was created based on entity. | ||||
IsOvertimeCalcNonexistent in DB | bool? | - | ||
Description:Indicates whether this work activity is associated with an overtime earning type, as defined by the PMTimeActivity.EarningTypeID property. This is a read-only calculated field. | ||||
JobID | int | - | ||
Description:No description available | ||||
LabourItemID | int | Labor Item | InventoryItem | |
Description:The identifier of the labor item associated with the activity. The labour item identifier. | ||||
LastBillableNonexistent in DB | bool? | - | ||
Description:No description available | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LogLineNbr | int | Log Ref. Nbr. | FSAppointmentLog | |
Description:No description available | ||||
NeedToBeDeletedNonexistent in DB | bool? | - | ||
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
OrigNoteID | uniqueidentifier | PMTimeActivity | ||
Description:Use for correction. Stores the reference to the original activity. | ||||
OverTimeCalcNonexistent in DB | int? | OT | - | |
Description:Represents the time spent for overtime items. This is a read-only calculated field. For overtime items, the value is taken from the EPTimecardDetail.TimeSpent property. | ||||
OvertimeBillable | int | Billable Overtime | - | |
Description:No description available | ||||
OvertimeItemID | int | InventoryItem | ||
Description:No description available | ||||
OvertimeMultiplierCalcNonexistent in DB | decimal? | OT Mult | - | |
Description:The overtime multiplier. The value by which the employee cost for this earning type is multiplied when the time activity is released. | ||||
OvertimeSpent | int | Overtime | - | |
Description:No description available | ||||
OwnerID | int | Owner | Contact | |
Description:No description available | ||||
ParentTaskNoteID | uniqueidentifier | Task | CRActivity | |
Description:The task associated with this activity. Only tasks that belong to the selected employee are available for selection. | ||||
ProjectID | int | Project | PMProject | |
Description:The project on which the employee worked. Available only if the Project Accounting feature is enabled. | ||||
ProjectTaskID | int | Project Task | PMTask | |
Description:The task on which the employee worked. Canceled project tasks cannot be used in time cards. If you select a project that has the default project task, this task is automatically populated. Only available if the Project Accounting feature is enabled. The project task identifier. | ||||
RefNoteID | uniqueidentifier | CRActivity | ||
Description:The identifier of the related CRActivity. Corresponds to the value of the CRActivity.NoteID field. | ||||
RegularTimeCalcNonexistent in DB | int? | RH | - | |
Description:The regular work time the employee spent on the project and task. | ||||
Released | bit | Released | - | |
Description:No description available | ||||
ReportedInTimeZoneID | nvarchar(32) | Reported in Time Zone | - | |
Description:No description available | ||||
ReportedOnDateNonexistent in DB | DateTime? | Reported On | - | |
Description:Date and Time are displayed and modified depending on the ReportedInTimeZoneID | ||||
SelectedNonexistent in DB | bool? | Selected | - | |
Description:No description available | ||||
ServiceID | int | Service | InventoryItem | |
Description:No description available | ||||
ShiftID | int | Shift Code | EPShiftCode | |
Description:The work shift during which the activity was performed. The default shift code is defined in EP.EPEmployee. This column appears only if the Shift Differential feature is enabled. | ||||
Summary | nvarchar(256) | Summary | - | |
Description:No description available | ||||
SummaryLineNbr | int | - | ||
Description:This is a adjusting activity for the summary line in the Timecard. | ||||
TimeBillable | int | Billable Time | - | |
Description:The billable time for the employee. | ||||
TimeCardCD | nvarchar(10) | EPTimeCard | ||
Description:The Time Card associated with this activity. | ||||
TimeLogID | int | - | ||
Description:The time log associated with this time activity. The value of this field corresponds to the time log in EPTimeLog.timeLogID. | ||||
TimeSheetCD | nvarchar(15) | - | ||
Description:No description available | ||||
TimeSpent | int | Time Spent | - | |
Description:The work time reported for the selected date. | ||||
TrackTime | bit | Track Time and Costs | - | |
Description:No description available | ||||
TranID | bigint | - | ||
Description:No description available | ||||
UnionID | nvarchar(15) | Union Local | PMUnion | |
Description:The union local associated with the time entry. The system automatically populates the Union Local column in the time card line by using the employee and project settings as follows: - If the employee has an associated union local and the project does not, the system inserts the union local of the employee. - If the employee has an associated union local that is one of the union locals associated with the project, the system inserts the union local of the employee. - If the employee has an associated union local that is not one of the union locals associated with the project, the system leaves the column blank. - If the employee has no associated union local, the system leaves the column blank. You can clear this property if a union local has been selected or select a union local manually, if needed. The property is available only when the Construction feature is enabled. The identifier of the union local associated with the activity. | ||||
WeekID | int | Time Card Week | EPWeekRaw | |
Description:Unique identifier of the Week associated with this Time Card. The value of this field corresponds to the value of the EPWeekRaw.Description field. | ||||
WorkCodeID | nvarchar(15) | WCC Code | PMWorkCode | |
Description:The work class compensation code (WCC Code) associated with the time card line. The work code associated with this activity. | ||||
WorkgroupID | int | Workgroup | EPCompanyTree | |
Description:The workgroup to which the employee belongs. | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||