vrpt_StatusHistory

Updated January 20, 2026 16:48

Field Name	Field Description	Data Type	FK Join
act_name	Project Activity (Task) Name	nvarchar
api_number	Invoice Number	nvarchar
ce_controlNumber	Biomed Equipment Control Number	nvarchar
ce_name	Biomed Equipment Name	nvarchar
con_number	Contract Number	nvarchar
createdBy	Created By	nvarchar
est_number	Estimate Number	nvarchar
ev_code	Event Code	nvarchar
EV_NAME	Event Name	nvarchar
fm_tagNumber	Equipment Tag Number	nvarchar
FullStatus	Concatenated field (Status Description + Status Note)	nvarchar
Id	Status History Id	int
itfm_tagNumber	IT Equipment Tag Number	nvarchar
lease_number	Lease Number	nvarchar
log_number	Request Log Number	nvarchar
or_number	Sales Order Number	nvarchar
po_number	Purchase Order Number	nvarchar
poco_number	PO Change Order Number	nvarchar
pr_number	Purchase Requisition Number	nvarchar
proj_number	Project Number	nvarchar
qt_number	Quote Number	nvarchar
ret_number	Returns Number	nvarchar
sqr_number	Material Request Number	nvarchar
ss_code	Status Code	nvarchar
StatusDescrition	Status Description	nvarchar
StatusNote	Status Note	nvarchar
STH_ACT_FK	Project Activity (Task) Id	int	vrpt_ProjectTask
sth_api_fk	Invoice Id	int	vr_Invoice
sth_bi_fk	Capital Planning Work Element Id	int	vr_CPWorkElement
sth_ce_fk	Biomed Equipment Id	int	vr_CEEquipment
sth_cfg_fk	Capital Planning Project Request Id	int	vrpt_cpProjectRequest
sth_cfr_fk	Capital Planning Funding Request Id	int	vr_cpFundingRequest
sth_cjComponentRevision_fk	Capital Projects Component Revision Id	int
sth_cjDirectExpense_fk	Capital Projects Direct Expense Id	int
sth_cjFundingRevision_fk	Capital Projects Funding Revision Id	int
sth_cjIssue_fk	Capital Projects Issue Id	int
sth_cjMeeting_fk	Capital Projects Meeting Id	int
sth_cjProgressReport_fk	Capital Projects Progress Report Id	int
sth_cjProject_fk	Capital Projects Id	int
sth_cjProposal_fk	Capital Projects Proposal Id	int
STH_COMMENT	Comment	nvarchar
STH_CON_FK	Contract Id	int	vr_contract
STH_CONT_FK	Contractor Id	int	vr_Vendor
sth_cpCapitalRequestRevision_fk	Capital Planning Capital Requestion Revision	int
sth_createdDate	Record Creation Date	datetime
STH_CREATOR_FK	User Id (Record Creator)	int	vr_users
STH_DATE	Date	datetime
sth_dontSend	Don't Send	bit
sth_est_fk	Estimate Id	int
sth_ev_fk	Event Id	int	vr_Event
STH_FD_FK	Facility Id	int	vr_Facility
STH_FM_FK	Equipment Id	int	vr_equipment
STH_ITFM_FK	IT Equipment Id	int	vr_ITEquipment
sth_lease_fk	Lease Id	int	vrpt_Lease
STH_LOG_FK	Request Log Id	int	vr_Request
STH_MFG_FK	Manufacturer Id	int	vr_Vendor
STH_OR_FK	Sales Order Id	int	vr_SalesOrder
STH_PK	Status History Id	int
STH_PO_FK	Purchase Order Id	int	vr_PurchaseOrder
sth_poco_fk	Purchase Order Change Order Id	int
STH_PPO_FK	Obsolete Column (no longer in use)	int
STH_pr_FK	Purchase Requisition Id	int	vrpt_PurchaseRequisition
STH_PROJ_FK	Project Id	int	vr_Project
STH_QT_FK	Quote Id	int	vrpt_Quote
STH_RC_FK	Repair Center Id	int	vr_RepairCenter
STH_RET_FK	Returns Id	int
STH_SRQ_FK	Requestor Id	int	vr_Requestor
STH_SS_FK	Status Id	int	vr_Status
STH_TD_FK	To Do Id	int	vrpt_MyTaskToDoList
sth_user	User	nvarchar
STH_VEN_FK	Vendor Id	int	vr_Vendor
STH_WO_FK	Work Order Id	int	vr_WorkOrder
sth_woNumber	Work Order Number	nvarchar
td_title	To Do Title	nvarchar
wo_number	Work Order Number	nvarchar
wo_requestNumber	Request Number	nvarchar

Articles in this section