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 | ||||
Day1Nonexistent in DB | int? | Day 1 | - | |
Description:Time Spent for day 1 | ||||
Day10Nonexistent in DB | int? | Day 10 | - | |
Description:Time Spent for day 10 | ||||
Day11Nonexistent in DB | int? | Day 11 | - | |
Description:Time Spent for day 11 | ||||
Day12Nonexistent in DB | int? | Day 12 | - | |
Description:Time Spent for day 12 | ||||
Day13Nonexistent in DB | int? | Day 13 | - | |
Description:Time Spent for day 13 | ||||
Day14Nonexistent in DB | int? | Day 14 | - | |
Description:Time Spent for day 14 | ||||
Day15Nonexistent in DB | int? | Day 15 | - | |
Description:Time Spent for day 15 | ||||
Day16Nonexistent in DB | int? | Day 16 | - | |
Description:Time Spent for day 16 | ||||
Day17Nonexistent in DB | int? | Day 17 | - | |
Description:Time Spent for day 17 | ||||
Day18Nonexistent in DB | int? | Day 18 | - | |
Description:Time Spent for day 18 | ||||
Day19Nonexistent in DB | int? | Day 19 | - | |
Description:Time Spent for day 19 | ||||
Day2Nonexistent in DB | int? | Day 2 | - | |
Description:Time Spent for day 2 | ||||
Day20Nonexistent in DB | int? | Day 20 | - | |
Description:Time Spent for day 20 | ||||
Day21Nonexistent in DB | int? | Day 21 | - | |
Description:Time Spent for day 21 | ||||
Day22Nonexistent in DB | int? | Day 22 | - | |
Description:Time Spent for day 22 | ||||
Day23Nonexistent in DB | int? | Day 23 | - | |
Description:Time Spent for day 23 | ||||
Day24Nonexistent in DB | int? | Day 24 | - | |
Description:Time Spent for day 24 | ||||
Day25Nonexistent in DB | int? | Day 25 | - | |
Description:Time Spent for day 25 | ||||
Day26Nonexistent in DB | int? | Day 26 | - | |
Description:Time Spent for day 26 | ||||
Day27Nonexistent in DB | int? | Day 27 | - | |
Description:Time Spent for day 27 | ||||
Day28Nonexistent in DB | int? | Day 28 | - | |
Description:Time Spent for day 28 | ||||
Day29Nonexistent in DB | int? | Day 29 | - | |
Description:Time Spent for day 29 | ||||
Day3Nonexistent in DB | int? | Day 3 | - | |
Description:Time Spent for day 3 | ||||
Day30Nonexistent in DB | int? | Day 30 | - | |
Description:Time Spent for day 30 | ||||
Day31Nonexistent in DB | int? | Day 31 | - | |
Description:Time Spent for day 31 | ||||
Day4Nonexistent in DB | int? | Day 4 | - | |
Description:Time Spent for day 4 | ||||
Day5Nonexistent in DB | int? | Day 5 | - | |
Description:Time Spent for day 5 | ||||
Day6Nonexistent in DB | int? | Day 6 | - | |
Description:Time Spent for day 6 | ||||
Day7Nonexistent in DB | int? | Day 7 | - | |
Description:Time Spent for day 7 | ||||
Day8Nonexistent in DB | int? | Day 8 | - | |
Description:Time Spent for day 8 | ||||
Day9Nonexistent in DB | int? | Day 9 | - | |
Description:Time Spent for day 9 | ||||
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 | ||||
FriObsolete | int | Friday | - | |
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 | ||||
MonObsolete | int | Monday | - | |
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 | ||||
SatObsolete | int | Saturday | - | |
Description:No description available | ||||
ShiftID | int | Shift Code | EPShiftCode | |
Description:No description available | ||||
SunObsolete | int | Sunday | - | |
Description:No description available | ||||
TaskApproverID | int | EPEmployee | ||
Description:Gets sets Task Approver | ||||
ThuObsolete | int | Thursday | - | |
Description:No description available | ||||
TimeCardCD | nvarchar(10) | EPTimeCard | ||
Description:No description available | ||||
TimeCardPeriodType | char(2) | Frequency | - | |
Description:Specifies the type of time card. | ||||
TimeSpent | int | Time Spent | - | |
Description:No description available | ||||
TueObsolete | int | Tuesday | - | |
Description:No description available | ||||
UnionID | nvarchar(15) | Union Local | PMUnion | |
Description:Gets sets Union | ||||
WedObsolete | int | Wednesday | - | |
Description:No description available | ||||
WorkCodeID | nvarchar(15) | WCC Code | PMWorkCode | |
Description:Gets sets Work code | ||||
WorkOrderNbr | nvarchar(15) | Work Order | SVOrder | |
Description:No description available | ||||
tstamp | timestamp | - | ||
Description:No description available | ||||