| Field Name | Field Description | Data Type | FK Join |
|---|---|---|---|
| authorized | Authorized | int | |
| chargeAccountName | Account Name | nvarchar | |
| chargeAccountNumber | Account Number | nvarchar | |
| creatorID | User Id (Record Creator) | nvarchar | vr_users |
| creatorInitials | Creator Initials | nvarchar | |
| creatorName | Creator Name | nvarchar | |
| cstProg_code | Account Program Code | nvarchar | |
| departmentCode | Department Code | nvarchar | |
| departmentName | Department Name | nvarchar | |
| dist_code | District Code | nvarchar | |
| dist_name | District Name | nvarchar | |
| dist_pk | District Id | int | vr_district |
| dp_billingFrequency | Department Billing Frequency | int | |
| dp_dpt_fk | Department Type Id | int | vr_departmentType |
| dvsn_code | Division Code | nvarchar | |
| dvsn_name | Division Name | nvarchar | |
| dvsn_pk | Division Id | int | |
| fb_BIMBuildingID | BIM Building Id | int | |
| fb_code | Building Code | nvarchar | |
| fb_name | Building Name | nvarchar | |
| fd_code | Facility Code | nvarchar | |
| fd_name | Facility Name | nvarchar | |
| ff_code | Floor Code | nvarchar | |
| ff_description | Floor Description | nvarchar | |
| fu_description | Area Description | nvarchar | |
| fu_roomNumber | Area Room Number | nvarchar | |
| fu_unitID | Area Location Id | nvarchar | |
| ItemStatus | Item Status | nvarchar | |
| ItemTypeId | Item Type Id | int | |
| ItemTypeName | Item Type Name | varchar | |
| jco_description | Joint Commission Category Description | nvarchar | |
| log_creator_fk | User Id (Record Creator) | int | |
| log_InspectionFinding | Inspection Finding Number | bit | |
| LOG_NUMBER | Request Log Number | nvarchar | |
| LOG_RC_FK | Repair Center Id | int | vr_RepairCenter |
| lt_code | Request Log Type Code | nvarchar | |
| lt_description | Request Log Type Description | nvarchar | |
| lt_inspectionFinding | Inspection Finding Id | bit | vrpt_InspectionFinding |
| ModelNumber | Item Model Number | nvarchar | |
| modifierID | User Id (Record Modifier) | nvarchar | vr_users |
| modifierInitials | Modifier Initials | nvarchar | |
| modifierName | Modifier Name | nvarchar | |
| operatorID | User Id (Operator Id) | nvarchar | vr_Users |
| operatorInitials | Operator Initials | nvarchar | |
| operatorName | Operator Name | nvarchar | |
| pri_code | Priority Code | nvarchar | |
| pri_description | Priority Description | nvarchar | |
| pri_displayColor | Priority Display Color | nvarchar | |
| pri_DueInterval | Priority Due Interval | int | |
| pri_DueIntervalType | Priority Due Interval Type | nvarchar | |
| proj_accountNumber | Project Account Number | nvarchar | |
| proj_cst_fk | Account Id | int | vr_account |
| proj_dueDate | Project Due Date | datetime | |
| proj_email | Project Email | nvarchar | |
| proj_manager | Project Manager (Technician Name) | nvarchar | |
| proj_name | Project Name | nvarchar | |
| proj_number | Project Number | nvarchar | |
| proj_priority | Project Priority | nvarchar | |
| proj_requestor | Project Requestor | nvarchar | |
| proj_requestorPhone | Project Requestor Phone | nvarchar | |
| proj_rq_fk | Requestor Id | int | vr_Requestor |
| proj_scheduledDate | Project Scheduled Date | datetime | |
| proj_statusDescription | Project Status | nvarchar | |
| proj_supervisor | Project Supervisor | nvarchar | |
| proj_type | Project Type | nvarchar | |
| rc_authorizationRequired | Repair Center Authorization Required | bit | |
| rc_closetask | Repair Center Close Task | bit | |
| rc_code | Repair Center Code | nvarchar | |
| rc_dupeCheck | Repair Center Dupe Check | bit | |
| rc_name | Repair Center Name | nvarchar | |
| rc_notLocatedCount | Repair Center Not Located Count | int | |
| rc_PositionBasedRate | Repair Center Postition Based Rate | bit | |
| rc_ti_fk | Time Type Id | int | vr_TimeType |
| rg_code | Region Code | nvarchar | |
| rg_name | Region Name | nvarchar | |
| rg_pk | Region Id | int | vr_region |
| SerialNumber | Item Serial Number | nvarchar | |
| SubLocation | Item Sub Location | nvarchar | |
| TagDescription | Tag Description | nvarchar | |
| TagNumber | Tag Number | nvarchar | |
| tax_name | Tax Name | nvarchar | |
| tax_wocontractor | Tax Work Order Contractor | bit | |
| tax_wolabor | Tax Work Order Labor | bit | |
| tax_woothercharge | Tax Work Order Other Charges | bit | |
| tax_wopart | Tax Work Order Part | bit | |
| ti_chargerate | Time Type Charge Rate | decimal | |
| ti_code | Time Type Code | nvarchar | |
| ti_description | Time Type Description | nvarchar | |
| ti_productiveTime | Time Type Productive Time | bit | |
| wc_code | Work Order Type Code | nvarchar | |
| wc_description | Work Order Type Description | nvarchar | |
| wc_designated | Work Order Designation | smallint | |
| wc_requiregeneralcomment | Require General Comments | bit | |
| wcs_code | Work Order SubType Code | nvarchar | |
| wcs_description | Work Order SubType Description | nvarchar | |
| wcs_pk | Work Order SubType Id | int | vr_WorkOrderSubType |
| wo_act_fk | Project Activity (Task) Id | int | vrpt_ProjectTask |
| wo_actionRequested | Action Requested | nvarchar | |
| wo_actionRequiredByDepartment | Action Required by Department | bit | |
| wo_AdditionalReference | Additional Reference | nvarchar | |
| wo_autoPrint | Auto Print | bit | |
| wo_bi_fk | Work Element Id | int | vrpt_cpWorkElement |
| wo_billFixedCost | Bill Fixed Cost | bit | |
| wo_bj_fk | Batch Job Id | int | vr_BatchJob |
| wo_buildingServicesSignoff | Building Service Signoff Date | datetime | |
| wo_charge | Indicates Whether the Work Order is Chargeable or Not | bit | |
| wo_clnt_fk | Obsolete Column (No Longer Used) | int | |
| wo_completionDate | Completion (Closed) Date | datetime | |
| wo_cpPendingDeferral | Capital Planning Pending Deferral | bit | |
| wo_createdDate | Record Creation Date | datetime | |
| wo_creator_fk | User Id (Record Creator) | int | |
| wo_cst_fk | Account Id | int | vr_account |
| wo_cstProg_fk | Account Program Id | int | |
| wo_defaultMap_fk | Default Map Id | int | |
| wo_departmentAction | Department Action | nvarchar | |
| wo_departmentHead | Department Head | nvarchar | |
| wo_departmentSignoff | Department Signoff | datetime | |
| wo_dp_fk | Department Id | int | vr_Department |
| wo_dynamicGroupDescription | Dynamic Group Description | nvarchar | |
| wo_ecri_fk | Alert Device Id | int | |
| wo_estimateCost | Estimate Cost | decimal | |
| wo_estimatedEndDate | Estimated End Date | datetime | |
| wo_estimatedStartDate | Estimated Start Date | datetime | |
| wo_estimateHours | Estimate Hours | decimal | |
| wo_excludedFromRequestor | Excluded From Requestor | bit | |
| wo_fb_fk | Building Id | int | vr_building |
| wo_fd_fk | Facility Id | int | vr_Facility |
| wo_ff_fk | Floor Record Id | int | vr_floor |
| wo_finishDate | Finish Date | datetime | |
| wo_fiscalStart | Fiscal Year Start | nvarchar | |
| wo_fromdevice | From Device | bit | |
| wo_fromMedTester | From Med Tester | bit | |
| wo_fromService | From Service | bit | |
| wo_fu_fk | Area Record Id | int | vr_area |
| wo_isClosed | Is Closed | bit | |
| wo_isTemplate | Is Template | bit | |
| wo_isTicket | Is Ticket | bit | |
| wo_item_lineGeometry | Item Line Geometry | nvarchar | |
| wo_item_xCoordinate | Item X Coordinate | nvarchar | |
| wo_item_yCoordinate | Item Y Coordinate | nvarchar | |
| wo_lineGeometry | Line Geometry | nvarchar | |
| wo_linkedfromwo_fk | Work Order Id | int | vr_WorkOrder |
| wo_log_fk | Request Log Id | int | vr_Request |
| wo_modifiedDate | Last Modified Date | datetime | |
| wo_modifier_fk | User Id (Record Modifier) | int | |
| wo_NotifyMe | Notify Me | bit | |
| wo_number | Work Order Number | nvarchar | |
| wo_operator_user_fk | User Id | int | vr_Users |
| wo_operatorError | Operator Error | bit | |
| wo_outOfService | Out of Service | bit | |
| wo_overage_cst_fk | Account Id | int | vr_account |
| wo_pk | Work Order Id | int | |
| wo_postDate | Post Date | datetime | |
| wo_potentialRisktoOperator | Potential Risk to Operator | bit | |
| wo_potentialRisktoPatient | Potential Risk to Patient | bit | |
| wo_preventarchival | Prevent Archival | bit | |
| wo_pri_fk | Priority Id | int | vr_Priority |
| wo_printDate | Last Print Date | datetime | |
| wo_proj_fk | Project Id | int | vr_Project |
| wo_rc_fk | Repair Center Id | int | vr_RepairCenter |
| wo_ReferenceNumber | Reference Number | nvarchar | |
| wo_requestDate | Request Date | datetime | |
| wo_requestor | Requestor | nvarchar | |
| wo_requestorEmail | Requestor Email | nvarchar | |
| wo_requestorPhone | Requestor Phone # | nvarchar | |
| wo_rq_fk | Requestor Id | int | vr_Requestor |
| wo_serviceJob | Service Job | bit | |
| wo_signedoff | Signed Off | bit | |
| wo_signoffby_fk | User Id (Signed Off By) | int | vr_users |
| wo_skipZoneAutoAssign | Skip Zone Auto Assign | bit | |
| wo_slpostDate | Sub Ledger Post Date | datetime | |
| wo_ss_fk | Status Id | int | vr_Status |
| wo_startCreationDate | Start Creation Date | datetime | |
| wo_status | Work Order Status Note | nvarchar | |
| wo_supervisor | Work Order Supervisor | nvarchar | |
| wo_tax_fk | Tax Rate Id | int | vr_TaxRate |
| wo_taxCompound | Tax Compound | bit | |
| wo_taxRate | Tax Rate | decimal | |
| wo_taxRate2 | Tax Rate 2 | decimal | |
| wo_techComments | Tech Comments | nvarchar | |
| wo_tqm | TQM | bit | |
| wo_uiExport | UI Export | bit | |
| wo_warrantyJob | Warranty Job | bit | |
| wo_wc_fk | Work Order Type Id | int | vr_WorkOrderType |
| wo_wkid | Technicain Code | int | |
| wo_xCoordinate | X Coordinate | nvarchar | |
| wo_yCoordinate | Y Coordinate | nvarchar |