vrpt_Task

Updated January 20, 2026 15:30

Field Name	Field Description	Data Type	FK Join
Active	Indicates if the Record is Active or Not	bit
AllowOnRequestForm	Allow On Request Form	bit
AllowPassAll	Allow Pass All	bit
ApplyMultiplier	Apply Multiplier	bit
ApprovalLevel	Approval Level	int
ApprovalRequired	Approval Required	bit
ApprovalSignOffNumber	Approavl Sign Off Number	int
AutoTrackPurposeId	Auto Track Purpose Id	int
AverageTime	Average Time	decimal
BarCoded	Bar Coded	bit
Bmp	Indicates if the task record is on a building maintenance program	bit
Code	Task Code	nvarchar
CodeDescription	Task Code and Description	nvarchar
CodeRelated	Code Related	bit
CreatedDate	Record Creation Date	datetime
CreatorId	User Id (Record Creator)	int	vr_users
CurrencyExchangeDate	Currency Exchange Date	datetime
CurrencyExchangeId	Currency Exchange Id	int
CurrencyId	Currency Id	int	vrpt_Currency
Description	Description	nvarchar
EffectiveDate	Effective Date	datetime
EstimatedCost	Estimated Cost	decimal
FixedJob	Indicates if the task record is a fixed job	bit
GeneralInspectionFormId	General Inspection Found	int
HasTaskSheet	Indicates if the task record has a task sheet	bit
HourlyRate	Hourly Rate	decimal
Id	Task Id	int
IntervalId	Interval Id	int
IsCalibration	Indicates if the task record is calibration	bit
IsKey	Is Key	bit
IsKeyCreate	Is Key Create	bit
IsKeyDestroy	Is Key Destroy	bit
IsKeyFound	Is Key Found	bit
IsKeyIssue	Is KeyI ssue	bit
IsKeyLost	Is Key Lost	bit
IsKeyReturn	Is Key Return	bit
LaborStandardTime	Labor Standard Time	decimal
MasterTask	Indicates if the task record is a master task	bit
MedTesterTask	Indicates if the task record is a medtester task	bit
ModifiedDate	Last Modified Date	datetime
ModifierId	User Id (Record Modifier)	int	vr_users
NotifyRequestor	Indicates Whether the Notify Requestor Box is Checked	bit
PMTaskSheet	PM Task Sheet	nvarchar
PreferredRepairCenterId	Repair Center Id	int	vr_RepairCenter
PrintOnNonPmWorkOrders	Indicates if the task record's task sheet is incuded on non PM Work Orders	bit
PrintOnPmWorkOrders	Indicates if the task record's task sheet is incuded on PM Work Orders	bit
PriorityId	Priority Id	int	vr_Priority
RecommendedInterval	Recommended Interval	int
Regulatory	Indicates if the task record is regulatory	bit
RequireActionRequested	Indicates if the task record requires action requested	bit
RequireAverageTimeUpdate	Indicates if the task record requires average time update	bit
RequireFailureCode	Indicates if the task record requires failure code	bit
RequireFAQ	Indicates if the task record requires frequently asked questions	bit
RequireKBResolution	Indicates if the task record requires knowledge base resolution	bit
RequireResolution	Indicates if the task record requires resolution	bit
RoomInspection	Indicates if the task record can be used on room inspections	bit
ShutDownNotification	Indicates if the task record has a shut down notification	bit
TaskSubTypeCode	Task Sub Type Code	nvarchar
TaskSubTypeDescription	Task Sub Type Description	nvarchar
TaskSubTypeId	Task Sub Type Id	int
TaskTypeCode	Task Type Code	nvarchar
TaskTypeDescription	Task Type Description	nvarchar
TaskTypeId	Task Type Id	int	vr_TaskType
TradeId	Trade Id	int	vr_Trade
ZoneRelated	Zone Related	bit

Articles in this section