vr_TimeAndAttendance

Updated November 27, 2025 15:22

Field Name	Field Description	Data Type	FK Join
AccountCode	Account Code	nvarchar
AccountId	Account Id	int	vr_account
AccountName	Account Name	nvarchar
ApplyMultiplier	Apply Multiplier	bit
ApprovedDate	Approved Date	datetime
ApproverId	User Id (Approver)	int	vr_Users
ApproverName	Approver Name	nvarchar
BatchJobId	Batch Job Id	int	vr_BatchJob
BatchNumber	Batch Number	int
BeginingXCoordinate	Beginning X Coordinate	nvarchar
BeginingYCoordinate	Beginning Y Coordinate	nvarchar
CalendarHours	Calendar Hours	decimal
ChargeRate	Charge Rate	decimal
CostRate	Cost Rate	decimal
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CrewId	Crew Id	int	vrpt_crew
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
Differential	Differential	decimal
ExtendedCost	Extended Cost	decimal
ExtendedRetail	Extended Retail	decimal
FailedPM	Indicates if the PM Failed	bit
HierarchyLevel	Hierarchy Level	nvarchar
Hours	Hours	decimal
Id	Time and Attendance Id	int
ipAddress	IP Address	nvarchar
LaborComment	Labor Comment	nvarchar
LaborPercentage	Labor Percentage	decimal
LeaseBatchJobId	Lease Batch Job Id	int	vr_BatchJob
LocationCode	Location Code	nvarchar
LocationTypeName	Location Type Name	nvarchar
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
Nocharge	No Charge	bit
NotLocated	Not Located	bit
PositionCode	Position Code	nvarchar
PositionDescription	Position Description	nvarchar
PositionId	Poistion Id	int	vr_Position
PostDate	Post Date	datetime
RateMultiplier	Rate Multiplier	decimal
ResolutionId	Resolution Id	int
ShiftCode	Shift Code	nvarchar
ShiftDescription	Shift Description	nvarchar
ShiftId	Shift Id	int	vr_shift
SLPostDate	Sub Ledger Post Date	datetime
start	Start	datetime
TaskCode	Task Code	nvarchar
TaskCompletionDate	Task Completion Date	datetime
TaskDescription	Task Description	nvarchar
TaskFinishDate	Task Finish Date	datetime
TaskId	Task Id	int	vrpt_Task
Taxable	Indicates if this Time and Attendance is taxable	bit
TaxAmount	Tax Amount	decimal
TechnicianChargeRate	Technician Charge Rate	decimal
TechnicianCode	Technician Code	nvarchar
TechnicianHasEmail	Technician Has Email	bit
TechnicianId	Technician Id	int	vrpt_Technician
TechnicianName	Technician Name	nvarchar
TechnicianWorkGroupId	Technician Work Group Id	int
TimeSubTypeCode	Time Sub Type Code	nvarchar
TimeSubTypeDescription	Time Sub Type Description	nvarchar
TimeSubTypeId	Time Sub Type Id	int
TimeTypeChargeRate	Time Type Charge Rate	decimal
TimeTypeCode	Time Type Code	nvarchar
TimeTypeDescription	Time Type Description	nvarchar
TimeTypeEarnsCompTime	Indicates if the Time Type record earns comp time	bit
TimeTypeId	Time Type Id	int	vr_TimeType
TimeTypeProductiveTime	Indicates if the Time Type record is productive time	bit
TradeCode	Trade Code	nvarchar
TradeDescription	Trade Description	nvarchar
TradeId	Trade Id	int	vr_Trade
TransDateTime	Transaction Date Time	datetime
WorkNotDone	Work Not Done	bit
WorkOrderId	Work Order Id	int	vr_WorkOrder
WorkOrderNumber	Work Order Number	nvarchar
WorkOrderTaskId	Work Order Task Id	int	vr_WorkOrderTask
WorkOrderTaskScheduleId	Work Order Task Schedule Id	int	vrpt_Workordertaskschedule
XCoordinate	X Coordinate	nvarchar
YCoordinate	Y Coordinate	nvarchar

Articles in this section