vrpt_cpAudit

Updated December 22, 2025 15:14

Field Name	Field Description	Data Type	FK Join
ai_code	Impact Priority Code	nvarchar
ai_description	Impact Priority Description	nvarchar
bi_number	Work Element Number	int
bi_pk	Work Element Id	int	vrpt_cpWorkElement
cpa_actionDate	Action Date	datetime
cpa_active	Indicates Whether the Audit is Active or Not	bit
cpa_adjustedReplacementYear	Adjusted Replacement Year	int
cpa_ai_fk	Capital Planning Audit Id	int	vrpt_cpAuidt
cpa_amps	Amps	int
cpa_auditor	Auditor	nvarchar
cpa_batchNumber	Batch Job	nvarchar
cpa_ce_fk	Biomed Equipment Id	int	vr_CEEquipment
cpa_cmi_fk	Capital Planning Master Item Id	int
cpa_cpat_fk	Capital Planning Audit Type Id	int
cpa_createdDate	Record Creation Date	datetime
cpa_creator_fk	User Id (Record Creator)	int	vr_users
cpa_csiCode	Construction Standards Institute Code	nvarchar
cpa_curr_fk	Currency Id	int	vrpt_Currency
cpa_date	Date	datetime
cpa_deficiency	Deficiency	nvarchar
cpa_deteriorationRate	Deterioration Rate	decimal
cpa_dp_fk	Department Id	int	vr_Department
cpa_elm_fk	UniFormat Id	int	vr_cpElement
cpa_exch_date	Currency Exchange Date	datetime
cpa_exch_fk	Currency Exchange Id	int
cpa_extendedCost	Extended Cost	decimal
cpa_fb_fk	Building Id	int	vr_building
cpa_fd_fk	Facility Id	int	vr_Facility
cpa_ff_fk	Floor Record Id	int	vr_floor
cpa_finishDate	Finish Date	datetime
cpa_fm_fk	Equipment Id	int	vr_equipment
cpa_fu_fk	Area Record Id	int	vr_area
cpa_inc_fk	Inventory Condition Id	int
cpa_installDate	Install Date	datetime
cpa_isRenewal	Is Renewal	bit
cpa_item_fk	Item Id	int
cpa_itemCode	Item Code (Tag Number)	nvarchar
cpa_itemDescription	Item Description	nvarchar
cpa_itemType_fk	Item Type Id	int
cpa_lifeExpectancy	Life Expectancy	int
cpa_modelNumber	Model Number	nvarchar
cpa_modifiedDate	Last Modified Date	datetime
cpa_modifier_fk	User Id (Record Modifier)	int	vr_users
cpa_notes	Notes	nvarchar
cpa_ns_fk	Entity Id	int	vr_Entity
cpa_number	Capital Planning Audit Number	int
cpa_p_fk	Asset Id	int	vr_asset
cpa_pk	Capital Planning Audit Id	int
cpa_quantity	Quantity	int
cpa_referenceNumber	Reference Number	nvarchar
cpa_renewalDate	Renewal Date	datetime
cpa_replacementYear	Replacement Year	int
cpa_requirement	Requirement	nvarchar
cpa_serialNumber	Serial Number	nvarchar
cpa_squareFootage	Square Footage	int
cpa_um_fk	Unit of Measure Id	int	vr_UnitMeasure
cpa_unit	Unit	nvarchar
cpa_unitCost	Unit Cost	decimal
cpa_usageCode	Usage Code	nvarchar
cpa_ven_fk	Vendor Id	int	vr_vendor
cpa_volts	Volts	int
cpa_wa_fk	Area Type Id	int	vr_areaType
cpat_code	Capital Planning Audit Type Code	nvarchar
cpat_description	Capital Planning Audit Type Description	nvarchar
cyi_number	Cyclic Renewal Number	int
cyi_pk	Cyclic Renewal Id	int	vrpt_cpCyclicRenewal
DepartmentName	Department Name	nvarchar
dp_code	Department Code	nvarchar
elm_code	Capital Planning Element Code	nvarchar
elm_levelDescription	Capital Planning Element Level Description	nvarchar
elm_pk	Capital Planning Element Id	int	vr_cpElement
fb_code	Building Code	nvarchar
fb_fbt_fk	Building Type Id	int	vr_buildingType
fb_name	Building Name	nvarchar
fb_pk	Building Id	int	vr_building
fd_code	Facility Code	nvarchar
fd_fdt_fk	Facility Type Id	int	vr_facilityType
fd_name	Facility Name	nvarchar
fd_pk	Facility Id	int	vr_facility
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
Id	Capital Planning Audit Id	int
inc_code	Inventory Condition Code	nvarchar
inc_description	Inventory Condition Description	nvarchar
ItemType	Item Type	varchar
level1Code	Level 1 Code	nvarchar
level1Description	Level 1 Description	nvarchar
level1PK	Level 1 PK	int
level2Code	Level 2 Code	nvarchar
level2Description	Level 2 Description	nvarchar
level2PK	Level 2 PK	int
level3Code	Level 3 Code	nvarchar
level3Description	Level 3 Description	nvarchar
level3PK	Level 3 PK	int
level4Code	Level 4 Code	nvarchar
level4Description	Level 4 Description	nvarchar
level4PK	Level 4 PK	int
log_inspectionFinding	Indicates if the request log record is from an inspection finding	bit
LOG_NUMBER	Reqeust Log Number	nvarchar
log_pk	Request Log Id	int	vr_Request
ven_name	Vendor Name	nvarchar
wa_description	Area Type Description	nvarchar
wo_number	Work Order Number	int
wo_pk	Work Order Id	int	vr_WorkOrder

Articles in this section