EP
TimeCardMaint.EPTimeCardSummaryWithInfo
Timecard Summary Record projection with additional fields from Project and Project Task.
| Field Name | Type | Display Name | Foreign Key | |
|---|---|---|---|---|
ApprovalStatusNonexistent in DB | string | Approval Status | - | |
Description:Gets sets Approval Status | ||||
ApproverIDNonexistent in DB | int? | Approver | EPEmployee | |
Description:Gets sets Approver (Task or Project) | ||||
CertifiedJob | bit | Certified Job | - | |
Description:Gets sets Certified Job | ||||
CostCodeDescriptionNonexistent in DB | string | Cost Code Description | - | |
Description:Gets sets Cost Code's description | ||||
CostCodeID | int | Cost Code | PMCostCode | |
Description:Gets sets CostCode | ||||
CreatedByID | uniqueidentifier | Created By | Users | |
Description:No description available | ||||
CreatedByScreenID | char(8) | - | ||
Description:No description available | ||||
CreatedDateTime | datetime | - | ||
Description:No description available | ||||
Description | nvarchar(255) | Description | - | |
Description:No description available | ||||
EarningType | nvarchar(15) | Earning Type | EPEarningType | |
Description:No description available | ||||
EmployeeIDNonexistent in DB | int? | - | ||
Description:No description available | ||||
EmployeeRateNonexistent in DB | decimal? | Cost Rate | - | |
Description:Stores Employee's Hourly rate at the time the activity was released to PM | ||||
Fri | int | Fri | - | |
Description:No description available | ||||
IsBillable | bit | Billable | - | |
Description:No description available | ||||
JobID | int | - | ||
Description:No description available | ||||
LabourItemID | int | Labor Item | InventoryItem | |
Description:The non-stock item of the Labor type associated with the time card line. By default, the system selects the labor item associated with the employee. | ||||
LastModifiedByID | uniqueidentifier | Last Modified By | Users | |
Description:No description available | ||||
LastModifiedByScreenID | char(8) | - | ||
Description:No description available | ||||
LastModifiedDateTime | datetime | - | ||
Description:No description available | ||||
LineNbr | int | - | ||
Description:No description available | ||||
Mon | int | Mon | - | |
Description:No description available | ||||
NoteID | uniqueidentifier | - | ||
Description:No description available | ||||
ParentNoteID | uniqueidentifier | Task ID | CRActivity | |
Description:No description available | ||||
ProjectDescription | nvarchar | Project Description | - | |
Description:Gets sets Project's Description | ||||
ProjectID | int | Project | PMProject | |
Description:Gets sets ProjectID | ||||
ProjectManager | int | Project Manager | - | |
Description:Gets sets Project Manager | ||||
ProjectTaskDescription | nvarchar | Project Task Description | - | |
Description:Gets sets Project Task's description | ||||
ProjectTaskID | int | Project Task | PMTask | |
Description:Gets sets Project Task | ||||
Sat | int | Sat | - | |
Description:No description available | ||||
ShiftID | int | Shift Code | EPShiftCode | |
Description:No description available | ||||
Sun | int | Sun | - | |
Description:No description available | ||||
TaskApproverID | int | EPEmployee | ||
Description:Gets sets Task Approver | ||||
Thu | int | Thu | - | |
Description:No description available | ||||
TimeCardCD | nvarchar(10) | EPTimeCard | ||
Description:No description available | ||||
TimeSpentNonexistent in DB | int? | Time Spent | - | |
Description:No description available | ||||
Tue | int | Tue | - | |
Description:No description available | ||||
UnionID | nvarchar(15) | Union Local | PMUnion | |
Description:Gets sets Union | ||||
Wed | int | Wed | - | |
Description:No description available | ||||
WorkCodeID | nvarchar(15) | WCC Code | PMWorkCode | |
Description:Gets sets Work code | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||