APHDR Data Sets

Army Public Health Data Repository (APHDR)

COPS_VRS-USAPHC (11).xlsx

APHDR Data Sets

OMB:

Document [xlsx]
Download: xlsx | pdf

Overview

1.Cover Letter
2.Summary By Table
3.COPS_VRS-USAPHC(Prov) Atr
Sheet1

Sheet 1: 1.Cover Letter
This tab, 1.Cover Letter, descripes the information in tabs 2-3.



Tab
Description
2.Summary By Table Summary report of the number of attributes that are in each of the 44 tables.
3.COPS_VRS-USAPHC (Prov) Atr Report on the attributes that can be selected. Explaination of the report column heads appears below, titled Column Definitions.




Column Definitions



Column Name Description
A Source Name of Data Source
B SourceTabOrd Ordinal Position of Table in Data Dictionary received from Source System-used internally
C SourceTable Name of the Table from which the data element is extracted from Source System
D SourceFieldOrd Ordinal Position of the data element in a Table in the Source System Data Dictionary-used internally
E FieldName Name of the data element (please use the literal format as in the column)
F PII/HIPAA Sensitive Please note YES, NO or DI (De-Identification)for the element PII or HIPAA sensitivity. If the element is PII or HIPAA sensitive and it will be de-identified, enter DI. A blank enter will be considered the same as a NO.
G NIMH (or USAPHC(Prov)) Approval User has accepted this as a valid element for their use-drop down list-Yes or No
H NIMH (or USAPHC(Prov)) SP2Delta Date the data element requested in Spiral-2. This will help in revising your existing extract routines
I FieldType This is the data type.
J Nullability This is the Nullability condition
K Primary Key Indicator if data element is a primary key (PK) or foreign key (FK) in this table
L Title Data Element Name
M Desc Dictionary meaning of the data element and enumerated values if applicable
N Values Information on values the element may have
O Notes Notes concerning the element
P FDM Comments Please add any comments that will help us understand the output extract.
Q ADS Comment Please add any comments on authoritativeness
R Code Table Reference Reference to code table.

Sheet 2: 2.Summary By Table
Number of Attributes Available for Selection

by Table within Source

Source
SourceTable Count

COPS/VRS





1 dbo.VRS_Applicant_Installation 2


2 dbo.VRS_Barred_List 12


3 dbo.VRS_Functional_Area_Permissions 2


4 dbo.VRS_Lookup_Accident_Violation_Type 3


5 dbo.VRS_Lookup_Bicycle_Make 3


6 dbo.VRS_Lookup_Bicycle_Style 3


7 dbo.VRS_Lookup_Bicycle_Type 3


8 dbo.VRS_Lookup_Decal_Replacement_Reason 3


9 dbo.VRS_Lookup_Decal_Returned_Reason 3


10 dbo.VRS_Lookup_Functional_Areas 2


11 dbo.VRS_Lookup_Image_Type 2


12 dbo.VRS_Lookup_Institutional_Report_User_Permissions 3


13 dbo.VRS_Lookup_Officer 7


14 dbo.VRS_Lookup_pet_gender 2


15 dbo.VRS_Lookup_Pet_Species 2


16 dbo.VRS_Lookup_Position 2


17 dbo.VRS_Lookup_Reports 6


18 dbo.VRS_Lookup_Reports_Criteria 3


19 dbo.VRS_Lookup_Sponsor_Organizations 4


20 dbo.VRS_Lookup_Temp_Pass 10


21 dbo.VRS_Lookup_Vehicle_Offense 3


22 dbo.VRS_Lookup_Vehicle_Status 2


23 dbo.VRS_Lookup_Vehicle_Type 2


24 dbo.VRS_Registered_Bicycles 14


25 dbo.VRS_Registered_Bicycles_Audit 16


26 dbo.VRS_Registered_Decals 13


27 dbo.VRS_Registered_Images 7


28 dbo.VRS_Registered_Images_Audit 9


29 dbo.VRS_Registered_Personnel 51


30 dbo.VRS_Registered_Personnel_Audit 53


31 dbo.VRS_Registered_Pets 17


32 dbo.VRS_Registered_Pets_Audit 19


33 dbo.VRS_Registered_Vehicles 28


34 dbo.VRS_Registered_Vehicles_Audit 30


35 dbo.VRS_Registered_Weapons 19


36 dbo.VRS_Registered_Weapons_Audit 21


37 dbo.VRS_Report_Adhoc 6


38 dbo.VRS_Report_Adhoc_saved_queries 4


39 dbo.VRS_Reports_Criteria 2


40 dbo.VRS_Temporary_Passes 40


41 dbo.VRS_User_Installation 3


42 dbo.VRS_User_Installation_Audit 5


43 dbo.VRS_User_Permissions 4


44 dbo.VRS_User_Permissions_Audit 6



44 source tables with
451 attributes

Sheet 3: 3.COPS_VRS-USAPHC(Prov) Atr
Source Source Tab Ord SourceTable Source Field Ord FieldName PII/HIPAA Sensitive USAPHC (Prov) Approval USAPHC (Prov) SP2Delta FieldType Nullability Primary Key Title Desc Values Notes FDM Comments ADS Comment Code Table Reference
COPS/VRS 1 dbo.VRS_Applicant_Installation 1 applicant_id Yes
?? numeric(5,0) NOT NULL
applicant_id





COPS/VRS 1 dbo.VRS_Applicant_Installation 2 installation_id

?? numeric(5,0) NOT NULL
installation_id





COPS/VRS 2 dbo.VRS_Barred_List 1 Barred_id

?? decimal(18,0) NOT NULL
Barred_id





COPS/VRS 2 dbo.VRS_Barred_List 2 registrant_number_id
Yes
decimal(18,0) NOT NULL
registrant_number_id





COPS/VRS 2 dbo.VRS_Barred_List 3 reason_id
Yes
int NOT NULL
reason_id





COPS/VRS 2 dbo.VRS_Barred_List 4 barring_installation_id
Yes
decimal(18,0) NOT NULL
barring_installation_id





COPS/VRS 2 dbo.VRS_Barred_List 5 effective_dt
Yes
datetime NOT NULL
effective_dt





COPS/VRS 2 dbo.VRS_Barred_List 6 termination_dt
Yes
datetime NOT NULL
termination_dt





COPS/VRS 2 dbo.VRS_Barred_List 7 poc_name_txt Yes

varchar(100) NOT NULL
poc_name_txt





COPS/VRS 2 dbo.VRS_Barred_List 8 poc_comm_txt Yes

varchar(25) NOT NULL
poc_comm_txt





COPS/VRS 2 dbo.VRS_Barred_List 9 poc_dsn_txt Yes

varchar(25) NOT NULL
poc_dsn_txt





COPS/VRS 2 dbo.VRS_Barred_List 10 mpr_txt


varchar(25) NOT NULL
mpr_txt





COPS/VRS 2 dbo.VRS_Barred_List 11 limited_bln


tinyint NOT NULL
limited_bln





COPS/VRS 2 dbo.VRS_Barred_List 12 limited_to_txt


varchar(50) NOT NULL
limited_to_txt





COPS/VRS 3 dbo.VRS_Functional_Area_Permissions 1 func_area_id


smallint NOT NULL
func_area_id





COPS/VRS 3 dbo.VRS_Functional_Area_Permissions 2 permission_id


smallint NOT NULL
permission_id





COPS/VRS 4 dbo.VRS_Lookup_Accident_Violation_Type 1 Accident_Violation_id
Yes
smallint NOT NULL
Accident_Violation_id





COPS/VRS 4 dbo.VRS_Lookup_Accident_Violation_Type 2 Accident_Violation_Desc
Yes
char(60) NULL
Accident_Violation_Desc





COPS/VRS 4 dbo.VRS_Lookup_Accident_Violation_Type 3 Length_num

?? int NULL
Length_num





COPS/VRS 5 dbo.VRS_Lookup_Bicycle_Make 1 bicycle_make_id


smallint IDENTITY
bicycle_make_id





COPS/VRS 5 dbo.VRS_Lookup_Bicycle_Make 2 bicycle_make_txt


varchar(50) NOT NULL
bicycle_make_txt





COPS/VRS 5 dbo.VRS_Lookup_Bicycle_Make 3 delete_bln


bit NULL
delete_bln

DEFAULT '0'


COPS/VRS 6 dbo.VRS_Lookup_Bicycle_Style 1 bicycle_style_id


smallint IDENTITY
bicycle_style_id





COPS/VRS 6 dbo.VRS_Lookup_Bicycle_Style 2 bicycle_style_txt


varchar(50) NOT NULL
bicycle_style_txt





COPS/VRS 6 dbo.VRS_Lookup_Bicycle_Style 3 delete_bln


bit NULL
delete_bln

DEFAULT 0


COPS/VRS 7 dbo.VRS_Lookup_Bicycle_Type 1 bicycle_type_id


smallint IDENTITY
bicycle_type_id





COPS/VRS 7 dbo.VRS_Lookup_Bicycle_Type 2 bicycle_type_txt


varchar(50) NOT NULL
bicycle_type_txt





COPS/VRS 7 dbo.VRS_Lookup_Bicycle_Type 3 delete_bln


bit NULL
delete_bln

DEFAULT 0


COPS/VRS 8 dbo.VRS_Lookup_Decal_Replacement_Reason 1 replacement_reason_id


numeric(18,0) IDENTITY
replacement_reason_id





COPS/VRS 8 dbo.VRS_Lookup_Decal_Replacement_Reason 2 replacement_reason_txt


varchar(50) NULL
replacement_reason_txt





COPS/VRS 8 dbo.VRS_Lookup_Decal_Replacement_Reason 3 deleted_bln


tinyint NULL
deleted_bln

DEFAULT 0


COPS/VRS 9 dbo.VRS_Lookup_Decal_Returned_Reason 1 returned_reason_id


int IDENTITY
returned_reason_id





COPS/VRS 9 dbo.VRS_Lookup_Decal_Returned_Reason 2 returned_reason_txt


varchar(50) NOT NULL
returned_reason_txt





COPS/VRS 9 dbo.VRS_Lookup_Decal_Returned_Reason 3 deleted_bln


tinyint NOT NULL
deleted_bln

DEFAULT 0


COPS/VRS 10 dbo.VRS_Lookup_Functional_Areas 1 func_area_id


smallint NOT NULL
func_area_id





COPS/VRS 10 dbo.VRS_Lookup_Functional_Areas 2 func_area_txt


varchar(50) NOT NULL
func_area_txt





COPS/VRS 11 dbo.VRS_Lookup_Image_Type 1 image_type_id


int IDENTITY
image_type_id





COPS/VRS 11 dbo.VRS_Lookup_Image_Type 2 image_type_txt


char(25) NULL
image_type_txt





COPS/VRS 12 dbo.VRS_Lookup_Institutional_Report_User_Permissions 1 level_id


int IDENTITY
level_id





COPS/VRS 12 dbo.VRS_Lookup_Institutional_Report_User_Permissions 2 level_user_id Yes

int NULL
level_user_id





COPS/VRS 12 dbo.VRS_Lookup_Institutional_Report_User_Permissions 3 report_level_id


int NULL
report_level_id





COPS/VRS 13 dbo.VRS_Lookup_Officer 1 officer_id


int NOT NULL
officer_id





COPS/VRS 13 dbo.VRS_Lookup_Officer 2 officer_number_txt Yes

varchar(25) NULL
officer_number_txt





COPS/VRS 13 dbo.VRS_Lookup_Officer 3 officer_last_name_txt Yes

varchar(50) NULL
officer_last_name_txt





COPS/VRS 13 dbo.VRS_Lookup_Officer 4 officer_first_name_txt Yes

varchar(50) NULL
officer_first_name_txt





COPS/VRS 13 dbo.VRS_Lookup_Officer 5 officer_middle_name_txt Yes

varchar(50) NULL
officer_middle_name_txt





COPS/VRS 13 dbo.VRS_Lookup_Officer 6 officer_grade_rank_id DI

smallint NULL
officer_grade_rank_id





COPS/VRS 13 dbo.VRS_Lookup_Officer 7 officer_installation_id


smallint NULL
officer_installation_id





COPS/VRS 14 dbo.VRS_Lookup_pet_gender 1 pet_gender_id


smallint IDENTITY
pet_gender_id





COPS/VRS 14 dbo.VRS_Lookup_pet_gender 2 pet_gender_description_txt


varchar(50) NULL
pet_gender_description_txt





COPS/VRS 15 dbo.VRS_Lookup_Pet_Species 1 species_id


int IDENTITY
species_id





COPS/VRS 15 dbo.VRS_Lookup_Pet_Species 2 species_txt


char(50) NULL
species_txt





COPS/VRS 16 dbo.VRS_Lookup_Position 1 position_id


smallint IDENTITY
position_id





COPS/VRS 16 dbo.VRS_Lookup_Position 2 position_txt


varchar(50) NULL
position_txt





COPS/VRS 17 dbo.VRS_Lookup_Reports 1 report_id

?? smallint NOT NULL
report_id





COPS/VRS 17 dbo.VRS_Lookup_Reports 2 report_name_txt

?? varchar(50) NOT NULL
report_name_txt





COPS/VRS 17 dbo.VRS_Lookup_Reports 3 report_desc_txt

?? varchar(50) NULL
report_desc_txt





COPS/VRS 17 dbo.VRS_Lookup_Reports 4 report_url

?? varchar(100) NULL
report_url





COPS/VRS 17 dbo.VRS_Lookup_Reports 5 type_id

?? smallint NOT NULL
type_id





COPS/VRS 17 dbo.VRS_Lookup_Reports 6 report_search_bln

?? int NOT NULL,
report_search_bln

DEFAULT 1


COPS/VRS 18 dbo.VRS_Lookup_Reports_Criteria 1 criteria_id

?? smallint NOT NULL
criteria_id





COPS/VRS 18 dbo.VRS_Lookup_Reports_Criteria 2 criteria_label_txt

?? varchar(50) NOT NULL
criteria_label_txt





COPS/VRS 18 dbo.VRS_Lookup_Reports_Criteria 3 criteria_html_txt

?? varchar(7500) NOT NULL
criteria_html_txt





COPS/VRS 19 dbo.VRS_Lookup_Sponsor_Organizations 1 sponsor_organization_id DI

smallint IDENTITY
sponsor_organization_id





COPS/VRS 19 dbo.VRS_Lookup_Sponsor_Organizations 2 sponsor_organization_txt Yes

varchar(50) NULL
sponsor_organization_txt





COPS/VRS 19 dbo.VRS_Lookup_Sponsor_Organizations 3 sponsor_installation_id


int NULL
sponsor_installation_id





COPS/VRS 19 dbo.VRS_Lookup_Sponsor_Organizations 4 deactivate_bln


tinyint NULL
deactivate_bln





COPS/VRS 20 dbo.VRS_Lookup_Temp_Pass 1 temp_pass_id


int IDENTITY
temp_pass_id





COPS/VRS 20 dbo.VRS_Lookup_Temp_Pass 2 temp_pass_title_txt Yes

varchar(50) NULL
temp_pass_title_txt





COPS/VRS 20 dbo.VRS_Lookup_Temp_Pass 3 temp_pass_regulation_txt Yes

varchar(1000) NULL
temp_pass_regulation_txt





COPS/VRS 20 dbo.VRS_Lookup_Temp_Pass 4 installation_id


int NULL
installation_id





COPS/VRS 20 dbo.VRS_Lookup_Temp_Pass 5 logo_img


image NULL
logo_img





COPS/VRS 20 dbo.VRS_Lookup_Temp_Pass 6 watermark_img


image NULL
watermark_img





COPS/VRS 20 dbo.VRS_Lookup_Temp_Pass 7 show_photo_bln


tinyint NULL
show_photo_bln





COPS/VRS 20 dbo.VRS_Lookup_Temp_Pass 8 show_visitor_badge_bln


tinyint NULL
show_visitor_badge_bln





COPS/VRS 20 dbo.VRS_Lookup_Temp_Pass 9 show_visitor_name_bln


tinyint NULL
show_visitor_name_bln





COPS/VRS 20 dbo.VRS_Lookup_Temp_Pass 10 delete_bln


bit NULL
delete_bln

DEFAULT 0


COPS/VRS 21 dbo.VRS_Lookup_Vehicle_Offense 1 vehicle_offense_id


smallint IDENTITY
vehicle_offense_id





COPS/VRS 21 dbo.VRS_Lookup_Vehicle_Offense 2 vehicle_offense_cd


varchar(4) NOT NULL
vehicle_offense_cd





COPS/VRS 21 dbo.VRS_Lookup_Vehicle_Offense 3 vehicle_offense_txt


varchar(25) NOT NULL
vehicle_offense_txt





COPS/VRS 22 dbo.VRS_Lookup_Vehicle_Status 1 Vehicle_Status_id
Yes
smallint IDENTITY
Vehicle_Status_id





COPS/VRS 22 dbo.VRS_Lookup_Vehicle_Status 2 Vehicle_Status_txt
Yes
char(15) NOT NULL
Vehicle_Status_txt





COPS/VRS 23 dbo.VRS_Lookup_Vehicle_Type 1 type_id


smallint IDENTITY
type_id





COPS/VRS 23 dbo.VRS_Lookup_Vehicle_Type 2 type_txt


char(30) NULL
type_txt





COPS/VRS 24 dbo.VRS_Registered_Bicycles 1 bicycle_id


int IDENTITY
bicycle_id





COPS/VRS 24 dbo.VRS_Registered_Bicycles 2 registrant_number_id Yes

int NOT NULL
registrant_number_id





COPS/VRS 24 dbo.VRS_Registered_Bicycles 3 bicycle_registration_dt


datetime NULL
bicycle_registration_dt





COPS/VRS 24 dbo.VRS_Registered_Bicycles 4 bicycle_serial_number_txt


varchar(50) NOT NULL
bicycle_serial_number_txt





COPS/VRS 24 dbo.VRS_Registered_Bicycles 5 bicycle_decal_number_txt


varchar(50) NOT NULL
bicycle_decal_number_txt





COPS/VRS 24 dbo.VRS_Registered_Bicycles 6 bicycle_make_id


int NULL
bicycle_make_id





COPS/VRS 24 dbo.VRS_Registered_Bicycles 7 bicycle_model_txt


varchar(50) NULL
bicycle_model_txt





COPS/VRS 24 dbo.VRS_Registered_Bicycles 8 bicycle_type_id


int NULL
bicycle_type_id





COPS/VRS 24 dbo.VRS_Registered_Bicycles 9 bicycle_color_txt


varchar(50) NULL
bicycle_color_txt





COPS/VRS 24 dbo.VRS_Registered_Bicycles 10 bicycle_style_id


int NULL
bicycle_style_id





COPS/VRS 24 dbo.VRS_Registered_Bicycles 11 bicycle_created_dt


datetime NULL
bicycle_created_dt





COPS/VRS 24 dbo.VRS_Registered_Bicycles 12 bicycle_last_updated_dt


datetime NULL
bicycle_last_updated_dt





COPS/VRS 24 dbo.VRS_Registered_Bicycles 13 bicycle_created_by_user_id


int NULL
bicycle_created_by_user_id





COPS/VRS 24 dbo.VRS_Registered_Bicycles 14 bicycle_last_updated_user_id


int NULL
bicycle_last_updated_user_id





COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 1 Audit_Action_txt


char(1) NULL
Audit_Action_txt





COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 2 Audit_dt


datetime NULL
Audit_dt





COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 3 bicycle_id


int NULL
bicycle_id





COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 4 registrant_number_id


int NOT NULL
registrant_number_id





COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 5 bicycle_registration_dt


datetime NULL
bicycle_registration_dt





COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 6 bicycle_serial_number_txt


varchar(50) NOT NULL
bicycle_serial_number_txt





COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 7 bicycle_decal_number_txt


varchar(50) NOT NULL
bicycle_decal_number_txt





COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 8 bicycle_make_id


int NULL
bicycle_make_id





COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 9 bicycle_model_txt


varchar(50) NULL
bicycle_model_txt





COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 10 bicycle_type_id


int NULL
bicycle_type_id





COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 11 bicycle_color_txt


varchar(50) NULL
bicycle_color_txt





COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 12 bicycle_style_id


int NULL
bicycle_style_id





COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 13 bicycle_created_dt


datetime NULL
bicycle_created_dt





COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 14 bicycle_last_updated_dt


datetime NULL
bicycle_last_updated_dt





COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 15 bicycle_created_by_user_id


int NULL
bicycle_created_by_user_id





COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 16 bicycle_last_updated_user_id


int NULL
bicycle_last_updated_user_id





COPS/VRS 26 dbo.VRS_Registered_Decals 1 decal_id


int IDENTITY
decal_id





COPS/VRS 26 dbo.VRS_Registered_Decals 2 registrant_number_id


int NULL
registrant_number_id





COPS/VRS 26 dbo.VRS_Registered_Decals 3 installation_id


int NULL
installation_id





COPS/VRS 26 dbo.VRS_Registered_Decals 4 vehicle_id


int NULL
vehicle_id





COPS/VRS 26 dbo.VRS_Registered_Decals 5 vehicle_year_num


int NULL
vehicle_year_num





COPS/VRS 26 dbo.VRS_Registered_Decals 6 vehicle_make_id


int NULL
vehicle_make_id





COPS/VRS 26 dbo.VRS_Registered_Decals 7 vehicle_model_txt


varchar(20) NULL
vehicle_model_txt





COPS/VRS 26 dbo.VRS_Registered_Decals 8 vehicle_decal_number_txt


varchar(7) NULL
vehicle_decal_number_txt





COPS/VRS 26 dbo.VRS_Registered_Decals 9 vehicle_decal_replacement_reason_id


int NULL
vehicle_decal_replacement_reason_id





COPS/VRS 26 dbo.VRS_Registered_Decals 10 vehicle_decal_updated_dt


datetime NULL
vehicle_decal_updated_dt





COPS/VRS 26 dbo.VRS_Registered_Decals 11 vehicle_decal_updated_by_user_id


int NULL
vehicle_decal_updated_by_user_id





COPS/VRS 26 dbo.VRS_Registered_Decals 12 recovered_bln


int NULL
recovered_bln





COPS/VRS 26 dbo.VRS_Registered_Decals 13 vehicle_decal_returned_reason_id


int NULL
vehicle_decal_returned_reason_id

DEFAULT 0


COPS/VRS 27 dbo.VRS_Registered_Images 1 image_id


numeric(18,0) IDENTITY
image_id





COPS/VRS 27 dbo.VRS_Registered_Images 2 registrant_number_id


numeric(18,0) NOT NULL
registrant_number_id





COPS/VRS 27 dbo.VRS_Registered_Images 3 image_img


image NULL
image_img





COPS/VRS 27 dbo.VRS_Registered_Images 4 image_type_id


int NULL
image_type_id





COPS/VRS 27 dbo.VRS_Registered_Images 5 image_description_txt


varchar(100) NULL
image_description_txt





COPS/VRS 27 dbo.VRS_Registered_Images 6 image_created_dt


datetime NULL
image_created_dt





COPS/VRS 27 dbo.VRS_Registered_Images 7 image_created_id


int NULL
image_created_id





COPS/VRS 28 dbo.VRS_Registered_Images_Audit 1 Audit_Action_txt


char(1) NULL
Audit_Action_txt





COPS/VRS 28 dbo.VRS_Registered_Images_Audit 2 Audit_dt


datetime NULL
Audit_dt





COPS/VRS 28 dbo.VRS_Registered_Images_Audit 3 image_id


int NULL
image_id





COPS/VRS 28 dbo.VRS_Registered_Images_Audit 4 registrant_number_id


int NOT NULL
registrant_number_id





COPS/VRS 28 dbo.VRS_Registered_Images_Audit 5 image_img


image NULL
image_img





COPS/VRS 28 dbo.VRS_Registered_Images_Audit 6 image_type_id


int NULL
image_type_id





COPS/VRS 28 dbo.VRS_Registered_Images_Audit 7 image_description_txt


varchar(100) NULL
image_description_txt





COPS/VRS 28 dbo.VRS_Registered_Images_Audit 8 image_created_dt


datetime NULL
image_created_dt





COPS/VRS 28 dbo.VRS_Registered_Images_Audit 9 image_created_id


int NULL
image_created_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 1 registrant_number_id
Yes
int IDENTITY
registrant_number_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 2 registrant_installation_id
Yes
int NULL
registrant_installation_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 3 registrant_id_type_id
Yes
int NULL
registrant_id_type_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 4 registrant_id_value_txt Yes Yes
varchar(25) NULL
registrant_id_value_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 5 registrant_last_name_txt Yes Yes
varchar(50) NULL
registrant_last_name_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 6 registrant_first_name_txt Yes Yes
varchar(50) NULL
registrant_first_name_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 7 registrant_middle_name_txt Yes Yes
varchar(50) NULL
registrant_middle_name_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 8 registrant_suffix_cd Yes

varchar(6) NULL
registrant_suffix_cd





COPS/VRS 29 dbo.VRS_Registered_Personnel 9 registrant_operator_number_txt


varchar(25) NULL
registrant_operator_number_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 10 registrant_operator_state_id


int NULL
registrant_operator_state_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 11 registrant_category_id


int NULL
registrant_category_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 12 registrant_grade_rank_id DI Yes
int NULL
registrant_grade_rank_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 13 registrant_birth_dt
Yes
datetime NULL
registrant_birth_dt





COPS/VRS 29 dbo.VRS_Registered_Personnel 14 registrant_ets_dt


datetime NULL
registrant_ets_dt





COPS/VRS 29 dbo.VRS_Registered_Personnel 15 registrant_component_id


int NULL
registrant_component_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 16 registrant_gender_id


int NULL
registrant_gender_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 17 registrant_height_txt


varchar(10) NULL
registrant_height_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 18 registrant_weight_txt


varchar(5) NULL
registrant_weight_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 19 registrant_eye_color_id


int NULL
registrant_eye_color_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 20 registrant_hair_color_id


int NULL
registrant_hair_color_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 21 registrant_marital_status_id


int NULL
registrant_marital_status_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 22 registrant_ethnicity_id


int NULL
registrant_ethnicity_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 23 registrant_race_id


int NULL
registrant_race_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 24 registrant_home_address_txt Yes

varchar(100) NULL
registrant_home_address_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 25 registrant_home_city_txt


varchar(50) NULL
registrant_home_city_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 26 registrant_home_state_id


int NULL
registrant_home_state_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 27 registrant_home_zipcode_txt


varchar(15) NULL
registrant_home_zipcode_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 28 registrant_home_country_id


int NULL
registrant_home_country_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 29 registrant_home_phone_txt Yes

varchar(15) NULL
registrant_home_phone_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 30 registrant_uic_id DI Yes
int NULL
registrant_uic_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 31 registrant_unit_address_txt Yes

varchar(100) NULL
registrant_unit_address_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 32 registrant_unit_city_txt


varchar(50) NULL
registrant_unit_city_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 33 registrant_unit_state_id


int NULL
registrant_unit_state_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 34 registrant_unit_zipcode_txt


varchar(15) NULL
registrant_unit_zipcode_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 35 registrant_unit_country_id


int NULL
registrant_unit_country_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 36 registrant_unit_phone_txt Yes

varchar(25) NULL
registrant_unit_phone_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 37 registrant_unit_phone_ext_txt Yes

varchar(10) NULL
registrant_unit_phone_ext_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 38 registrant_remarks_txt Yes

varchar(100) NULL
registrant_remarks_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 39 registrant_sponsor_id_value_id DI

int NULL
registrant_sponsor_id_value_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 40 registrant_sponsor_id_value_txt Yes

varchar(15) NULL
registrant_sponsor_id_value_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 41 registrant_sponsor_last_name_txt Yes

varchar(50) NULL
registrant_sponsor_last_name_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 42 registrant_sponsor_first_name_txt Yes

varchar(50) NULL
registrant_sponsor_first_name_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 43 registrant_sponsor_relationship_id


int NULL
registrant_sponsor_relationship_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 44 registrant_sponsor_home_phone_txt Yes

varchar(25) NULL
registrant_sponsor_home_phone_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 45 registrant_created_dt


datetime NULL
registrant_created_dt





COPS/VRS 29 dbo.VRS_Registered_Personnel 46 registrant_created_by_user_id


int NULL
registrant_created_by_user_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 47 registrant_last_updated_id


int NULL
registrant_last_updated_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 48 registrant_last_updated_dt


datetime NULL
registrant_last_updated_dt





COPS/VRS 29 dbo.VRS_Registered_Personnel 49 registrant_sponsor_organization_id Yes

int NULL
registrant_sponsor_organization_id





COPS/VRS 29 dbo.VRS_Registered_Personnel 50 registrant_security_group_txt


varchar(10) NULL
registrant_security_group_txt





COPS/VRS 29 dbo.VRS_Registered_Personnel 51 registrant_sponsor_deceased_bln


tinyint NULL
registrant_sponsor_deceased_bln





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 1 Audit_Action_txt


char(1) NULL
Audit_Action_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 2 Audit_dt


datetime NULL
Audit_dt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 3 registrant_number_id


int NULL
registrant_number_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 4 registrant_installation_id


int NULL
registrant_installation_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 5 registrant_id_type_id


int NULL
registrant_id_type_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 6 registrant_id_value_txt Yes

varchar(25) NULL
registrant_id_value_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 7 registrant_last_name_txt Yes

varchar(50) NULL
registrant_last_name_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 8 registrant_first_name_txt Yes

varchar(50) NULL
registrant_first_name_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 9 registrant_middle_name_txt Yes

varchar(50) NULL
registrant_middle_name_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 10 registrant_suffix_cd Yes

varchar(6) NULL
registrant_suffix_cd





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 11 registrant_operator_number_txt


varchar(25) NULL
registrant_operator_number_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 12 registrant_operator_state_id


int NULL
registrant_operator_state_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 13 registrant_category_id


int NULL
registrant_category_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 14 registrant_grade_rank_id DI

int NULL
registrant_grade_rank_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 15 registrant_birth_dt


datetime NULL
registrant_birth_dt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 16 registrant_ets_dt


datetime NULL
registrant_ets_dt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 17 registrant_component_id


int NULL
registrant_component_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 18 registrant_gender_id


int NULL
registrant_gender_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 19 registrant_height_txt


varchar(10) NULL
registrant_height_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 20 registrant_weight_txt


varchar(5) NULL
registrant_weight_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 21 registrant_eye_color_id


int NULL
registrant_eye_color_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 22 registrant_hair_color_id


int NULL
registrant_hair_color_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 23 registrant_marital_status_id


int NULL
registrant_marital_status_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 24 registrant_ethnicity_id


int NULL
registrant_ethnicity_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 25 registrant_race_id


int NULL
registrant_race_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 26 registrant_home_address_txt Yes

varchar(100) NULL
registrant_home_address_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 27 registrant_home_city_txt


varchar(50) NULL
registrant_home_city_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 28 registrant_home_state_id


int NULL
registrant_home_state_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 29 registrant_home_zipcode_txt


varchar(15) NULL
registrant_home_zipcode_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 30 registrant_home_country_id


int NULL
registrant_home_country_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 31 registrant_home_phone_txt Yes

varchar(25) NULL
registrant_home_phone_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 32 registrant_uic_id DI

int NULL
registrant_uic_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 33 registrant_unit_address_txt Yes

varchar(100) NULL
registrant_unit_address_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 34 registrant_unit_city_txt


varchar(50) NULL
registrant_unit_city_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 35 registrant_unit_state_id


int NULL
registrant_unit_state_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 36 registrant_unit_zipcode_txt


varchar(15) NULL
registrant_unit_zipcode_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 37 registrant_unit_country_id


int NULL
registrant_unit_country_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 38 registrant_unit_phone_txt Yes

varchar(25) NULL
registrant_unit_phone_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 39 registrant_unit_phone_ext_txt Yes

varchar(10) NULL
registrant_unit_phone_ext_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 40 registrant_remarks_txt Yes

varchar(100) NULL
registrant_remarks_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 41 registrant_sponsor_id_value_id DI

int NULL
registrant_sponsor_id_value_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 42 registrant_sponsor_id_value_txt Yes

varchar(15) NULL
registrant_sponsor_id_value_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 43 registrant_sponsor_last_name_txt Yes

varchar(50) NULL
registrant_sponsor_last_name_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 44 registrant_sponsor_first_name_txt Yes

varchar(50) NULL
registrant_sponsor_first_name_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 45 registrant_sponsor_relationship_id


int NULL
registrant_sponsor_relationship_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 46 registrant_sponsor_home_phone_txt Yes

varchar(25) NULL
registrant_sponsor_home_phone_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 47 registrant_created_dt


datetime NULL
registrant_created_dt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 48 registrant_created_by_user_id


int NULL
registrant_created_by_user_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 49 registrant_last_updated_id


int NULL
registrant_last_updated_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 50 registrant_last_updated_dt


datetime NULL
registrant_last_updated_dt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 51 registrant_sponsor_organization_id Yes

int NULL
registrant_sponsor_organization_id





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 52 registrant_security_group_txt


varchar(10) NULL
registrant_security_group_txt





COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 53 registrant_sponsor_deceased_bln


tinyint NULL
registrant_sponsor_deceased_bln





COPS/VRS 31 dbo.VRS_Registered_Pets 1 pet_id


int IDENTITY
pet_id





COPS/VRS 31 dbo.VRS_Registered_Pets 2 registrant_number_id


int NULL
registrant_number_id





COPS/VRS 31 dbo.VRS_Registered_Pets 3 pet_registration_number_txt


varchar(50) NULL
pet_registration_number_txt





COPS/VRS 31 dbo.VRS_Registered_Pets 4 pet_license_number_txt


varchar(50) NULL
pet_license_number_txt





COPS/VRS 31 dbo.VRS_Registered_Pets 5 pet_species_id


smallint NULL
pet_species_id





COPS/VRS 31 dbo.VRS_Registered_Pets 6 pet_breed_txt


varchar(50) NULL
pet_breed_txt





COPS/VRS 31 dbo.VRS_Registered_Pets 7 pet_age_txt


varchar(50) NULL
pet_age_txt





COPS/VRS 31 dbo.VRS_Registered_Pets 8 pet_sex_id


smallint NULL
pet_sex_id





COPS/VRS 31 dbo.VRS_Registered_Pets 9 pet_color_txt


varchar(50) NULL
pet_color_txt





COPS/VRS 31 dbo.VRS_Registered_Pets 10 pet_markings_txt


varchar(50) NULL
pet_markings_txt





COPS/VRS 31 dbo.VRS_Registered_Pets 11 pet_registration_dt


datetime NULL
pet_registration_dt





COPS/VRS 31 dbo.VRS_Registered_Pets 12 pet_registration_expiration_dt


datetime NULL
pet_registration_expiration_dt





COPS/VRS 31 dbo.VRS_Registered_Pets 13 pet_description_txt


varchar(150) NULL
pet_description_txt





COPS/VRS 31 dbo.VRS_Registered_Pets 14 pet_created_dt


datetime NULL
pet_created_dt





COPS/VRS 31 dbo.VRS_Registered_Pets 15 pet_created_by_user_id


smallint NULL
pet_created_by_user_id





COPS/VRS 31 dbo.VRS_Registered_Pets 16 pet_last_updated_dt


datetime NULL
pet_last_updated_dt





COPS/VRS 31 dbo.VRS_Registered_Pets 17 pet_last_updated_id


smallint NULL
pet_last_updated_id





COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 1 Audit_Action_txt


char(1) NULL
Audit_Action_txt





COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 2 Audit_dt


datetime NULL
Audit_dt





COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 3 pet_id


int NULL
pet_id





COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 4 registrant_number_id


int NULL
registrant_number_id





COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 5 pet_registration_number_txt


varchar(50) NULL
pet_registration_number_txt





COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 6 pet_license_number_txt


varchar(50) NULL
pet_license_number_txt





COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 7 pet_species_id


int NULL
pet_species_id





COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 8 pet_breed_txt


varchar(50) NULL
pet_breed_txt





COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 9 pet_age_txt


varchar(50) NULL
pet_age_txt





COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 10 pet_sex_id


int NULL
pet_sex_id





COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 11 pet_color_txt


varchar(50) NULL
pet_color_txt





COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 12 pet_markings_txt


varchar(50) NULL
pet_markings_txt





COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 13 pet_registration_dt


datetime NULL
pet_registration_dt





COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 14 pet_registration_expiration_dt


datetime NULL
pet_registration_expiration_dt





COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 15 pet_description_txt


varchar(150) NULL
pet_description_txt





COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 16 pet_created_dt


datetime NULL
pet_created_dt





COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 17 pet_created_by_user_id


int NULL
pet_created_by_user_id





COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 18 pet_last_updated_dt


datetime NULL
pet_last_updated_dt





COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 19 pet_last_updated_id


int NULL
pet_last_updated_id





COPS/VRS 33 dbo.VRS_Registered_Vehicles 1 vehicle_id


int IDENTITY
vehicle_id





COPS/VRS 33 dbo.VRS_Registered_Vehicles 2 registrant_number_id

?? int NOT NULL
registrant_number_id





COPS/VRS 33 dbo.VRS_Registered_Vehicles 3 vehicle_vin_txt


varchar(30) NULL
vehicle_vin_txt





COPS/VRS 33 dbo.VRS_Registered_Vehicles 4 vehicle_decal_number_txt


varchar(7) NULL
vehicle_decal_number_txt





COPS/VRS 33 dbo.VRS_Registered_Vehicles 5 vehicle_decal_expiration_dt


datetime NULL
vehicle_decal_expiration_dt





COPS/VRS 33 dbo.VRS_Registered_Vehicles 6 vehicle_registration_dt


datetime NULL
vehicle_registration_dt





COPS/VRS 33 dbo.VRS_Registered_Vehicles 7 vehicle_year_num


int NULL
vehicle_year_num





COPS/VRS 33 dbo.VRS_Registered_Vehicles 8 vehicle_make_id

?? int NULL
vehicle_make_id





COPS/VRS 33 dbo.VRS_Registered_Vehicles 9 vehicle_model_txt

?? varchar(20) NULL
vehicle_model_txt





COPS/VRS 33 dbo.VRS_Registered_Vehicles 10 vehicle_body_style_id


int NULL
vehicle_body_style_id





COPS/VRS 33 dbo.VRS_Registered_Vehicles 11 vehicle_color_txt


varchar(20) NULL
vehicle_color_txt





COPS/VRS 33 dbo.VRS_Registered_Vehicles 12 vehicle_license_state_id


int NULL
vehicle_license_state_id





COPS/VRS 33 dbo.VRS_Registered_Vehicles 13 vehicle_license_country_id


int NULL
vehicle_license_country_id





COPS/VRS 33 dbo.VRS_Registered_Vehicles 14 vehicle_license_number_txt Yes

varchar(15) NULL
vehicle_license_number_txt





COPS/VRS 33 dbo.VRS_Registered_Vehicles 15 vehicle_license_year_num


int NULL
vehicle_license_year_num





COPS/VRS 33 dbo.VRS_Registered_Vehicles 16 vehicle_signature_dt


datetime NULL
vehicle_signature_dt





COPS/VRS 33 dbo.VRS_Registered_Vehicles 17 vehicle_comments_txt Yes

varchar(1000) NULL
vehicle_comments_txt





COPS/VRS 33 dbo.VRS_Registered_Vehicles 18 vehicle_status_id

?? int NULL
vehicle_status_id





COPS/VRS 33 dbo.VRS_Registered_Vehicles 19 vehicle_state_emissions_bln


tinyint NULL
vehicle_state_emissions_bln





COPS/VRS 33 dbo.VRS_Registered_Vehicles 20 vehicle_insurance_req_bln


tinyint NULL
vehicle_insurance_req_bln





COPS/VRS 33 dbo.VRS_Registered_Vehicles 21 vehicle_insurance_company_name_txt


varchar(30) NULL
vehicle_insurance_company_name_txt





COPS/VRS 33 dbo.VRS_Registered_Vehicles 22 vehicle_insurance_policy_num_txt Yes

varchar(30) NULL
vehicle_insurance_policy_num_txt





COPS/VRS 33 dbo.VRS_Registered_Vehicles 23 vehicle_insured_policy_expiration_dt


datetime NULL
vehicle_insured_policy_expiration_dt





COPS/VRS 33 dbo.VRS_Registered_Vehicles 24 vehicle_rfid_number_txt


varchar(30) NULL
vehicle_rfid_number_txt





COPS/VRS 33 dbo.VRS_Registered_Vehicles 25 vehicle_created_dt


datetime NULL
vehicle_created_dt





COPS/VRS 33 dbo.VRS_Registered_Vehicles 26 vehicle_updated_dt


datetime NULL
vehicle_updated_dt





COPS/VRS 33 dbo.VRS_Registered_Vehicles 27 vehicle_created_by_userid


int NULL
vehicle_created_by_userid





COPS/VRS 33 dbo.VRS_Registered_Vehicles 28 vehicle_last_updated_userid


int NULL
vehicle_last_updated_userid





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 1 Audit_Action_txt


char(1) NULL
Audit_Action_txt





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 2 Audit_dt


datetime NULL
Audit_dt





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 3 vehicle_id


int NULL
vehicle_id





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 4 registrant_number_id


int NOT NULL
registrant_number_id





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 5 vehicle_vin_txt


varchar(30) NULL
vehicle_vin_txt





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 6 vehicle_decal_number_txt


varchar(7) NULL
vehicle_decal_number_txt





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 7 vehicle_decal_expiration_dt


datetime NULL
vehicle_decal_expiration_dt





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 8 vehicle_registration_dt


datetime NULL
vehicle_registration_dt





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 9 vehicle_year_num


int NULL
vehicle_year_num





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 10 vehicle_make_id


int NULL
vehicle_make_id





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 11 vehicle_model_txt


varchar(20) NULL
vehicle_model_txt





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 12 vehicle_body_style_id


int NULL
vehicle_body_style_id





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 13 vehicle_color_txt


varchar(20) NULL
vehicle_color_txt





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 14 vehicle_license_state_id


int NULL
vehicle_license_state_id





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 15 vehicle_license_country_id


int NULL
vehicle_license_country_id





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 16 vehicle_license_number_txt Yes

varchar(15) NULL
vehicle_license_number_txt





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 17 vehicle_license_year_num


int NULL
vehicle_license_year_num





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 18 vehicle_signature_dt


datetime NULL
vehicle_signature_dt





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 19 vehicle_comments_txt Yes

varchar(1000) NULL
vehicle_comments_txt





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 20 vehicle_status_id


int NULL
vehicle_status_id





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 21 vehicle_state_emissions_bln


tinyint NULL
vehicle_state_emissions_bln





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 22 vehicle_insurance_req_bln


tinyint NULL
vehicle_insurance_req_bln





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 23 vehicle_insurance_company_name_txt


varchar(30) NULL
vehicle_insurance_company_name_txt





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 24 vehicle_insurance_policy_num_txt Yes

varchar(30) NULL
vehicle_insurance_policy_num_txt





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 25 vehicle_insured_policy_expiration_dt


datetime NULL
vehicle_insured_policy_expiration_dt





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 26 vehicle_rfid_number_txt


varchar(30) NULL
vehicle_rfid_number_txt





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 27 vehicle_created_dt


datetime NULL
vehicle_created_dt





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 28 vehicle_updated_dt


datetime NULL
vehicle_updated_dt





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 29 vehicle_created_by_userid


int NULL
vehicle_created_by_userid





COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 30 vehicle_last_updated_userid


int NULL
vehicle_last_updated_userid





COPS/VRS 35 dbo.VRS_Registered_Weapons 1 weapon_id

?? int IDENTITY
weapon_id





COPS/VRS 35 dbo.VRS_Registered_Weapons 2 registrant_number_id DI Yes
int NULL
registrant_number_id





COPS/VRS 35 dbo.VRS_Registered_Weapons 3 weapon_serial_number_txt


varchar(30) NULL
weapon_serial_number_txt





COPS/VRS 35 dbo.VRS_Registered_Weapons 4 weapon_registration_number_txt


varchar(15) NULL
weapon_registration_number_txt





COPS/VRS 35 dbo.VRS_Registered_Weapons 5 weapon_make_id
Yes
int NULL
weapon_make_id





COPS/VRS 35 dbo.VRS_Registered_Weapons 6 weapon_model_txt
Yes
varchar(30) NULL
weapon_model_txt





COPS/VRS 35 dbo.VRS_Registered_Weapons 7 weapon_caliber_gauge_id
Yes
int NULL
weapon_caliber_gauge_id





COPS/VRS 35 dbo.VRS_Registered_Weapons 8 weapon_type_id

?? int NULL
weapon_type_id





COPS/VRS 35 dbo.VRS_Registered_Weapons 9 weapon_overall_length_txt


varchar(10) NULL
weapon_overall_length_txt





COPS/VRS 35 dbo.VRS_Registered_Weapons 10 weapon_barrel_length_txt


varchar(10) NULL
weapon_barrel_length_txt





COPS/VRS 35 dbo.VRS_Registered_Weapons 11 weapon_signature_dt


datetime NULL
weapon_signature_dt





COPS/VRS 35 dbo.VRS_Registered_Weapons 12 weapon_registration_dt


datetime NULL
weapon_registration_dt





COPS/VRS 35 dbo.VRS_Registered_Weapons 13 weapon_location_id
Yes
int NULL
weapon_location_id





COPS/VRS 35 dbo.VRS_Registered_Weapons 14 weapon_finish_id


int NULL
weapon_finish_id





COPS/VRS 35 dbo.VRS_Registered_Weapons 15 weapon_description_txt

?? varchar(150) NULL
weapon_description_txt





COPS/VRS 35 dbo.VRS_Registered_Weapons 16 weapon_created_dt


datetime NULL
weapon_created_dt





COPS/VRS 35 dbo.VRS_Registered_Weapons 17 weapon_updated_dt


datetime NULL
weapon_updated_dt





COPS/VRS 35 dbo.VRS_Registered_Weapons 18 weapon_created_by_userid


int NULL
weapon_created_by_userid





COPS/VRS 35 dbo.VRS_Registered_Weapons 19 weapon_last_updated_userid


int NULL
weapon_last_updated_userid





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 1 Audit_Action_txt


char(1) NULL
Audit_Action_txt





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 2 Audit_dt


datetime NULL
Audit_dt





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 3 weapon_id


int NULL
weapon_id





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 4 registrant_number_id DI

int NULL
registrant_number_id





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 5 weapon_serial_number_txt


varchar(30) NULL
weapon_serial_number_txt





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 6 weapon_registration_number_txt


varchar(15) NULL
weapon_registration_number_txt





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 7 weapon_make_id


int NULL
weapon_make_id





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 8 weapon_model_txt


varchar(30) NULL
weapon_model_txt





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 9 weapon_caliber_gauge_id


int NULL
weapon_caliber_gauge_id





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 10 weapon_type_id


int NULL
weapon_type_id





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 11 weapon_overall_length_txt


varchar(10) NULL
weapon_overall_length_txt





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 12 weapon_barrel_length_txt


varchar(10) NULL
weapon_barrel_length_txt





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 13 weapon_signature_dt


datetime NULL
weapon_signature_dt





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 14 weapon_registration_dt


datetime NULL
weapon_registration_dt





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 15 weapon_location_id


int NULL
weapon_location_id





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 16 weapon_finish_id


int NULL
weapon_finish_id





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 17 weapon_description_txt


varchar(150) NULL
weapon_description_txt





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 18 weapon_created_dt


datetime NULL
weapon_created_dt





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 19 weapon_updated_dt


datetime NULL
weapon_updated_dt





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 20 weapon_created_by_userid


int NULL
weapon_created_by_userid





COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 21 weapon_last_updated_userid


int NULL
weapon_last_updated_userid





COPS/VRS 37 dbo.VRS_Report_Adhoc 1 report_adhoc_Registrant_bln


tinyint NOT NULL
report_adhoc_Registrant_bln





COPS/VRS 37 dbo.VRS_Report_Adhoc 2 report_adhoc_Vehicle_bln


tinyint NOT NULL
report_adhoc_Vehicle_bln





COPS/VRS 37 dbo.VRS_Report_Adhoc 3 report_adhoc_Weapon_bln


tinyint NOT NULL
report_adhoc_Weapon_bln





COPS/VRS 37 dbo.VRS_Report_Adhoc 4 report_adhoc_Bicycle_bln


tinyint NOT NULL
report_adhoc_Bicycle_bln





COPS/VRS 37 dbo.VRS_Report_Adhoc 5 report_adhoc_Pets_bln


tinyint NOT NULL
report_adhoc_Pets_bln





COPS/VRS 37 dbo.VRS_Report_Adhoc 6 report_adhoc_join_txt


varchar(1500) NOT NULL
report_adhoc_join_txt





COPS/VRS 38 dbo.VRS_Report_Adhoc_saved_queries 1 query_id


numeric(18,0) IDENTITY
query_id





COPS/VRS 38 dbo.VRS_Report_Adhoc_saved_queries 2 user_id Yes

numeric(18,0) NULL
user_id





COPS/VRS 38 dbo.VRS_Report_Adhoc_saved_queries 3 query_name_txt


varchar(50) NULL
query_name_txt





COPS/VRS 38 dbo.VRS_Report_Adhoc_saved_queries 4 query_txt


text NULL
query_txt





COPS/VRS 39 dbo.VRS_Reports_Criteria 1 report_id


numeric(18,0) NOT NULL
report_id





COPS/VRS 39 dbo.VRS_Reports_Criteria 2 criteria_id


numeric(18,0) NOT NULL
criteria_id





COPS/VRS 40 dbo.VRS_Temporary_Passes 1 pass_id


int IDENTITY
pass_id





COPS/VRS 40 dbo.VRS_Temporary_Passes 2 pass_num_txt


varchar(15) NOT NULL
pass_num_txt





COPS/VRS 40 dbo.VRS_Temporary_Passes 3 registrant_installation_id


smallint NULL
registrant_installation_id





COPS/VRS 40 dbo.VRS_Temporary_Passes 4 issuing_installation_id


smallint NULL
issuing_installation_id





COPS/VRS 40 dbo.VRS_Temporary_Passes 5 registrant_number_id


int NULL
registrant_number_id





COPS/VRS 40 dbo.VRS_Temporary_Passes 6 ssn_txt DI

varchar(9) NULL
ssn_txt





COPS/VRS 40 dbo.VRS_Temporary_Passes 7 last_name_txt Yes

varchar(50) NOT NULL
last_name_txt





COPS/VRS 40 dbo.VRS_Temporary_Passes 8 first_name_txt Yes

varchar(50) NOT NULL
first_name_txt





COPS/VRS 40 dbo.VRS_Temporary_Passes 9 middle_name_txt Yes

varchar(50) NULL
middle_name_txt





COPS/VRS 40 dbo.VRS_Temporary_Passes 10 vehicle_VIN_txt


varchar(30) NULL
vehicle_VIN_txt





COPS/VRS 40 dbo.VRS_Temporary_Passes 11 vehicle_year_num


int NULL
vehicle_year_num





COPS/VRS 40 dbo.VRS_Temporary_Passes 12 vehicle_make_id


int NULL
vehicle_make_id





COPS/VRS 40 dbo.VRS_Temporary_Passes 13 vehicle_model_txt


varchar(20) NULL
vehicle_model_txt





COPS/VRS 40 dbo.VRS_Temporary_Passes 14 vehicle_body_style_id


int NULL
vehicle_body_style_id





COPS/VRS 40 dbo.VRS_Temporary_Passes 15 vehicle_color_txt


varchar(20) NULL
vehicle_color_txt





COPS/VRS 40 dbo.VRS_Temporary_Passes 16 vehicle_license_number_txt Yes

varchar(20) NULL
vehicle_license_number_txt





COPS/VRS 40 dbo.VRS_Temporary_Passes 17 vehicle_license_state_id


int NULL
vehicle_license_state_id





COPS/VRS 40 dbo.VRS_Temporary_Passes 18 vehicle_license_year_num


int NULL
vehicle_license_year_num





COPS/VRS 40 dbo.VRS_Temporary_Passes 19 start_dt


datetime NULL
start_dt





COPS/VRS 40 dbo.VRS_Temporary_Passes 20 destination_txt


varchar(50) NULL
destination_txt





COPS/VRS 40 dbo.VRS_Temporary_Passes 21 no_of_days_num


int NULL
no_of_days_num





COPS/VRS 40 dbo.VRS_Temporary_Passes 22 approved_by_txt Yes

varchar(25) NULL
approved_by_txt





COPS/VRS 40 dbo.VRS_Temporary_Passes 23 expired_dt


datetime NULL
expired_dt





COPS/VRS 40 dbo.VRS_Temporary_Passes 24 operator_number_txt Yes

varchar(25) NULL
operator_number_txt





COPS/VRS 40 dbo.VRS_Temporary_Passes 25 operator_state_id


int NULL
operator_state_id





COPS/VRS 40 dbo.VRS_Temporary_Passes 26 operator_country_id


int NULL
operator_country_id





COPS/VRS 40 dbo.VRS_Temporary_Passes 27 birth_dt


datetime NULL
birth_dt





COPS/VRS 40 dbo.VRS_Temporary_Passes 28 race_id


int NULL
race_id





COPS/VRS 40 dbo.VRS_Temporary_Passes 29 ethnicity_id


int NULL
ethnicity_id





COPS/VRS 40 dbo.VRS_Temporary_Passes 30 gender_id


int NULL
gender_id





COPS/VRS 40 dbo.VRS_Temporary_Passes 31 height_txt


varchar(15) NULL
height_txt





COPS/VRS 40 dbo.VRS_Temporary_Passes 32 weight_txt


varchar(15) NULL
weight_txt





COPS/VRS 40 dbo.VRS_Temporary_Passes 33 eye_color_id


int NULL
eye_color_id





COPS/VRS 40 dbo.VRS_Temporary_Passes 34 hair_color_id


int NULL
hair_color_id





COPS/VRS 40 dbo.VRS_Temporary_Passes 35 poc_name_txt Yes

varchar(40) NULL
poc_name_txt





COPS/VRS 40 dbo.VRS_Temporary_Passes 36 poc_phone_number_txt Yes

varchar(25) NULL
poc_phone_number_txt





COPS/VRS 40 dbo.VRS_Temporary_Passes 37 visitor_type_txt


varchar(30) NULL
visitor_type_txt





COPS/VRS 40 dbo.VRS_Temporary_Passes 38 additional_drivers_txt Yes

varchar(500) NULL
additional_drivers_txt





COPS/VRS 40 dbo.VRS_Temporary_Passes 39 rank_txt DI

varchar(25) NULL
rank_txt





COPS/VRS 40 dbo.VRS_Temporary_Passes 40 suffix_cd Yes

varchar(6) NULL
suffix_cd





COPS/VRS 41 dbo.VRS_User_Installation 1 user_id


int NOT NULL
user_id





COPS/VRS 41 dbo.VRS_User_Installation 2 installation_id


int NOT NULL
installation_id





COPS/VRS 41 dbo.VRS_User_Installation 3 last_updated_user_id


int NULL
last_updated_user_id





COPS/VRS 42 dbo.VRS_User_Installation_Audit 1 Audit_Action_txt


char(1) NULL
Audit_Action_txt





COPS/VRS 42 dbo.VRS_User_Installation_Audit 2 Audit_dt


datetime NULL
Audit_dt





COPS/VRS 42 dbo.VRS_User_Installation_Audit 3 user_id


int NULL
user_id





COPS/VRS 42 dbo.VRS_User_Installation_Audit 4 installation_id


int NOT NULL
installation_id





COPS/VRS 42 dbo.VRS_User_Installation_Audit 5 last_updated_user_id


int NULL
last_updated_user_id





COPS/VRS 43 dbo.VRS_User_Permissions 1 user_id


int NOT NULL
user_id





COPS/VRS 43 dbo.VRS_User_Permissions 2 func_area_id


int NOT NULL
func_area_id





COPS/VRS 43 dbo.VRS_User_Permissions 3 permission_id


int NULL
permission_id





COPS/VRS 43 dbo.VRS_User_Permissions 4 last_updated_user_id


int NULL
last_updated_user_id





COPS/VRS 44 dbo.VRS_User_Permissions_Audit 1 Audit_Action_txt


char(1) NULL
Audit_Action_txt





COPS/VRS 44 dbo.VRS_User_Permissions_Audit 2 Audit_dt


datetime NULL
Audit_dt





COPS/VRS 44 dbo.VRS_User_Permissions_Audit 3 user_id


int NULL
user_id





COPS/VRS 44 dbo.VRS_User_Permissions_Audit 4 func_area_id


int NOT NULL
func_area_id





COPS/VRS 44 dbo.VRS_User_Permissions_Audit 5 permission_id


int NULL
permission_id





COPS/VRS 44 dbo.VRS_User_Permissions_Audit 6 last_updated_user_id


int NULL
last_updated_user_id





Sheet 4: Sheet1
dbo.VRS_Applicant_Installation
dbo.VRS_Barred_List
dbo.VRS_Barred_List
dbo.VRS_Barred_List
dbo.VRS_Barred_List
dbo.VRS_Barred_List
dbo.VRS_Barred_List
dbo.VRS_Barred_List
dbo.VRS_Barred_List
dbo.VRS_Barred_List
dbo.VRS_Barred_List
dbo.VRS_Barred_List
dbo.VRS_Barred_List
dbo.VRS_Functional_Area_Permissions
dbo.VRS_Functional_Area_Permissions
dbo.VRS_Lookup_Accident_Violation_Type
dbo.VRS_Lookup_Accident_Violation_Type
dbo.VRS_Lookup_Accident_Violation_Type
dbo.VRS_Lookup_Bicycle_Make
dbo.VRS_Lookup_Bicycle_Make
dbo.VRS_Lookup_Bicycle_Make
dbo.VRS_Lookup_Bicycle_Style
dbo.VRS_Lookup_Bicycle_Style
dbo.VRS_Lookup_Bicycle_Style
dbo.VRS_Lookup_Bicycle_Type
dbo.VRS_Lookup_Bicycle_Type
dbo.VRS_Lookup_Bicycle_Type
dbo.VRS_Lookup_Decal_Replacement_Reason
dbo.VRS_Lookup_Decal_Replacement_Reason
dbo.VRS_Lookup_Decal_Replacement_Reason
dbo.VRS_Lookup_Decal_Returned_Reason
dbo.VRS_Lookup_Decal_Returned_Reason
dbo.VRS_Lookup_Decal_Returned_Reason
dbo.VRS_Lookup_Functional_Areas
dbo.VRS_Lookup_Functional_Areas
dbo.VRS_Lookup_Image_Type
dbo.VRS_Lookup_Image_Type
dbo.VRS_Lookup_Institutional_Report_User_Permissions
dbo.VRS_Lookup_Institutional_Report_User_Permissions
dbo.VRS_Lookup_Institutional_Report_User_Permissions
dbo.VRS_Lookup_Officer
dbo.VRS_Lookup_Officer
dbo.VRS_Lookup_Officer
dbo.VRS_Lookup_Officer
dbo.VRS_Lookup_Officer
dbo.VRS_Lookup_Officer
dbo.VRS_Lookup_Officer
dbo.VRS_Lookup_pet_gender
dbo.VRS_Lookup_pet_gender
dbo.VRS_Lookup_Pet_Species
dbo.VRS_Lookup_Pet_Species
dbo.VRS_Lookup_Position
dbo.VRS_Lookup_Position
dbo.VRS_Lookup_Reports
dbo.VRS_Lookup_Reports
dbo.VRS_Lookup_Reports
dbo.VRS_Lookup_Reports
dbo.VRS_Lookup_Reports
dbo.VRS_Lookup_Reports
dbo.VRS_Lookup_Reports_Criteria
dbo.VRS_Lookup_Reports_Criteria
dbo.VRS_Lookup_Reports_Criteria
dbo.VRS_Lookup_Sponsor_Organizations
dbo.VRS_Lookup_Sponsor_Organizations
dbo.VRS_Lookup_Sponsor_Organizations
dbo.VRS_Lookup_Sponsor_Organizations
dbo.VRS_Lookup_Temp_Pass
dbo.VRS_Lookup_Temp_Pass
dbo.VRS_Lookup_Temp_Pass
dbo.VRS_Lookup_Temp_Pass
dbo.VRS_Lookup_Temp_Pass
dbo.VRS_Lookup_Temp_Pass
dbo.VRS_Lookup_Temp_Pass
dbo.VRS_Lookup_Temp_Pass
dbo.VRS_Lookup_Temp_Pass
dbo.VRS_Lookup_Temp_Pass
dbo.VRS_Lookup_Vehicle_Offense
dbo.VRS_Lookup_Vehicle_Offense
dbo.VRS_Lookup_Vehicle_Offense
dbo.VRS_Lookup_Vehicle_Status
dbo.VRS_Lookup_Vehicle_Status
dbo.VRS_Lookup_Vehicle_Type
dbo.VRS_Lookup_Vehicle_Type
dbo.VRS_Registered_Bicycles
dbo.VRS_Registered_Bicycles
dbo.VRS_Registered_Bicycles
dbo.VRS_Registered_Bicycles
dbo.VRS_Registered_Bicycles
dbo.VRS_Registered_Bicycles
dbo.VRS_Registered_Bicycles
dbo.VRS_Registered_Bicycles
dbo.VRS_Registered_Bicycles
dbo.VRS_Registered_Bicycles
dbo.VRS_Registered_Bicycles
dbo.VRS_Registered_Bicycles
dbo.VRS_Registered_Bicycles
dbo.VRS_Registered_Bicycles
dbo.VRS_Registered_Bicycles_Audit
dbo.VRS_Registered_Bicycles_Audit
dbo.VRS_Registered_Bicycles_Audit
dbo.VRS_Registered_Bicycles_Audit
dbo.VRS_Registered_Bicycles_Audit
dbo.VRS_Registered_Bicycles_Audit
dbo.VRS_Registered_Bicycles_Audit
dbo.VRS_Registered_Bicycles_Audit
dbo.VRS_Registered_Bicycles_Audit
dbo.VRS_Registered_Bicycles_Audit
dbo.VRS_Registered_Bicycles_Audit
dbo.VRS_Registered_Bicycles_Audit
dbo.VRS_Registered_Bicycles_Audit
dbo.VRS_Registered_Bicycles_Audit
dbo.VRS_Registered_Bicycles_Audit
dbo.VRS_Registered_Bicycles_Audit
dbo.VRS_Registered_Decals
dbo.VRS_Registered_Decals
dbo.VRS_Registered_Decals
dbo.VRS_Registered_Decals
dbo.VRS_Registered_Decals
dbo.VRS_Registered_Decals
dbo.VRS_Registered_Decals
dbo.VRS_Registered_Decals
dbo.VRS_Registered_Decals
dbo.VRS_Registered_Decals
dbo.VRS_Registered_Decals
dbo.VRS_Registered_Decals
dbo.VRS_Registered_Decals
dbo.VRS_Registered_Images
dbo.VRS_Registered_Images
dbo.VRS_Registered_Images
dbo.VRS_Registered_Images
dbo.VRS_Registered_Images
dbo.VRS_Registered_Images
dbo.VRS_Registered_Images
dbo.VRS_Registered_Images_Audit
dbo.VRS_Registered_Images_Audit
dbo.VRS_Registered_Images_Audit
dbo.VRS_Registered_Images_Audit
dbo.VRS_Registered_Images_Audit
dbo.VRS_Registered_Images_Audit
dbo.VRS_Registered_Images_Audit
dbo.VRS_Registered_Images_Audit
dbo.VRS_Registered_Images_Audit
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Personnel_Audit
dbo.VRS_Registered_Pets
dbo.VRS_Registered_Pets
dbo.VRS_Registered_Pets
dbo.VRS_Registered_Pets
dbo.VRS_Registered_Pets
dbo.VRS_Registered_Pets
dbo.VRS_Registered_Pets
dbo.VRS_Registered_Pets
dbo.VRS_Registered_Pets
dbo.VRS_Registered_Pets
dbo.VRS_Registered_Pets
dbo.VRS_Registered_Pets
dbo.VRS_Registered_Pets
dbo.VRS_Registered_Pets
dbo.VRS_Registered_Pets
dbo.VRS_Registered_Pets
dbo.VRS_Registered_Pets
dbo.VRS_Registered_Pets_Audit
dbo.VRS_Registered_Pets_Audit
dbo.VRS_Registered_Pets_Audit
dbo.VRS_Registered_Pets_Audit
dbo.VRS_Registered_Pets_Audit
dbo.VRS_Registered_Pets_Audit
dbo.VRS_Registered_Pets_Audit
dbo.VRS_Registered_Pets_Audit
dbo.VRS_Registered_Pets_Audit
dbo.VRS_Registered_Pets_Audit
dbo.VRS_Registered_Pets_Audit
dbo.VRS_Registered_Pets_Audit
dbo.VRS_Registered_Pets_Audit
dbo.VRS_Registered_Pets_Audit
dbo.VRS_Registered_Pets_Audit
dbo.VRS_Registered_Pets_Audit
dbo.VRS_Registered_Pets_Audit
dbo.VRS_Registered_Pets_Audit
dbo.VRS_Registered_Pets_Audit
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Vehicles_Audit
dbo.VRS_Registered_Weapons
dbo.VRS_Registered_Weapons
dbo.VRS_Registered_Weapons
dbo.VRS_Registered_Weapons
dbo.VRS_Registered_Weapons
dbo.VRS_Registered_Weapons
dbo.VRS_Registered_Weapons
dbo.VRS_Registered_Weapons
dbo.VRS_Registered_Weapons
dbo.VRS_Registered_Weapons
dbo.VRS_Registered_Weapons
dbo.VRS_Registered_Weapons
dbo.VRS_Registered_Weapons
dbo.VRS_Registered_Weapons
dbo.VRS_Registered_Weapons
dbo.VRS_Registered_Weapons
dbo.VRS_Registered_Weapons
dbo.VRS_Registered_Weapons
dbo.VRS_Registered_Weapons
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Registered_Weapons_Audit
dbo.VRS_Report_Adhoc
dbo.VRS_Report_Adhoc
dbo.VRS_Report_Adhoc
dbo.VRS_Report_Adhoc
dbo.VRS_Report_Adhoc
dbo.VRS_Report_Adhoc
dbo.VRS_Report_Adhoc_saved_queries
dbo.VRS_Report_Adhoc_saved_queries
dbo.VRS_Report_Adhoc_saved_queries
dbo.VRS_Report_Adhoc_saved_queries
dbo.VRS_Reports_Criteria
dbo.VRS_Reports_Criteria
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_Temporary_Passes
dbo.VRS_User_Installation
dbo.VRS_User_Installation
dbo.VRS_User_Installation
dbo.VRS_User_Installation_Audit
dbo.VRS_User_Installation_Audit
dbo.VRS_User_Installation_Audit
dbo.VRS_User_Installation_Audit
dbo.VRS_User_Installation_Audit
dbo.VRS_User_Permissions
dbo.VRS_User_Permissions
dbo.VRS_User_Permissions
dbo.VRS_User_Permissions
dbo.VRS_User_Permissions_Audit
dbo.VRS_User_Permissions_Audit
dbo.VRS_User_Permissions_Audit
dbo.VRS_User_Permissions_Audit
dbo.VRS_User_Permissions_Audit
dbo.VRS_User_Permissions_Audit
File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00
© 2025 OMB.report | Privacy Policy