APHDR Data Sets

Army Public Health Data Repository (APHDR)

COPS_VRS_Registrations-USAPHC (10).xlsx

APHDR Data Sets

OMB:

Document [xlsx]
Download: xlsx | pdf

Overview

1.Cover Letter
2.COPS_VRS-USAPHC Atr

Sheet 1: 1.Cover Letter
This tab, 1.Cover Letter, descripes the information in the following tab of this document.



Tab
Description
2.COPS_VRS-USAPHC Atr Report on the elements available for selection. 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 Army STARRS (or USAPHC(Prov)) Approval User has accepted this as a valid element for their use-drop down list-Yes or No
H Army STARRS (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.COPS_VRS-USAPHC Atr
Source Source Tab Ord SourceTable Source Field Ord FieldName PII/HIPAA Sensitive USAPHC (Prov) Approval USAPHC (Prov) SP2Delta FieldType Nullability Primary Key Title Notes FDM Comments ADS Comment Code Table Reference
COPS/VRS 1 dbo.VRS_Applicant_Installation 1 applicant_id Yes No
numeric(5,0) NOT NULL
applicant_id USAPHC agree to drop - USAPHC originally thought this was someone that was registering. But COPS team explains that you don't apply to come on to the registration. You are either a registrant or not. These fields are not needed


COPS/VRS 1 dbo.VRS_Applicant_Installation 2 installation_id
No
numeric(5,0) NOT NULL
installation_id USAPHC agree to drop


COPS/VRS 2 dbo.VRS_Barred_List 1 Barred_id
No
decimal(18,0) NOT NULL
Barred_id USAPHC to review
No this is not the ID of a person who is barred, It is an internal key and will not be returned by the web service.
COPS/VRS 2 dbo.VRS_Barred_List 2 registrant_number_id
Yes
decimal(18,0) NOT NULL
registrant_number_id USAPHC to review


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


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


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


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


COPS/VRS 2 dbo.VRS_Barred_List 7 poc_name_txt Yes No
varchar(100) NOT NULL
poc_name_txt USAPHC to review


COPS/VRS 2 dbo.VRS_Barred_List 8 poc_comm_txt Yes No
varchar(25) NOT NULL
poc_comm_txt USAPHC to review


COPS/VRS 2 dbo.VRS_Barred_List 9 poc_dsn_txt Yes No
varchar(25) NOT NULL
poc_dsn_txt USAPHC to review


COPS/VRS 2 dbo.VRS_Barred_List 10 mpr_txt
No
varchar(25) NOT NULL
mpr_txt USAPHC to review


COPS/VRS 2 dbo.VRS_Barred_List 11 limited_bln
No
tinyint NOT NULL
limited_bln USAPHC to review


COPS/VRS 2 dbo.VRS_Barred_List 12 limited_to_txt
No
varchar(50) NOT NULL
limited_to_txt USAPHC to review


COPS/VRS 3 dbo.VRS_Functional_Area_Permissions 1 func_area_id
No
smallint NOT NULL
func_area_id USAPHC agree to drop


COPS/VRS 3 dbo.VRS_Functional_Area_Permissions 2 permission_id
No
smallint NOT NULL
permission_id USAPHC agree to drop


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
No
int NULL
Length_num



COPS/VRS 5 dbo.VRS_Lookup_Bicycle_Make 1 bicycle_make_id
No
smallint IDENTITY
bicycle_make_id



COPS/VRS 5 dbo.VRS_Lookup_Bicycle_Make 2 bicycle_make_txt
No
varchar(50) NOT NULL
bicycle_make_txt



COPS/VRS 5 dbo.VRS_Lookup_Bicycle_Make 3 delete_bln
No
bit NULL
delete_bln DEFAULT '0'


COPS/VRS 6 dbo.VRS_Lookup_Bicycle_Style 1 bicycle_style_id
No
smallint IDENTITY
bicycle_style_id



COPS/VRS 6 dbo.VRS_Lookup_Bicycle_Style 2 bicycle_style_txt
No
varchar(50) NOT NULL
bicycle_style_txt



COPS/VRS 6 dbo.VRS_Lookup_Bicycle_Style 3 delete_bln
No
bit NULL
delete_bln DEFAULT 0


COPS/VRS 7 dbo.VRS_Lookup_Bicycle_Type 1 bicycle_type_id
No
smallint IDENTITY
bicycle_type_id



COPS/VRS 7 dbo.VRS_Lookup_Bicycle_Type 2 bicycle_type_txt
No
varchar(50) NOT NULL
bicycle_type_txt



COPS/VRS 7 dbo.VRS_Lookup_Bicycle_Type 3 delete_bln
No
bit NULL
delete_bln DEFAULT 0


COPS/VRS 8 dbo.VRS_Lookup_Decal_Replacement_Reason 1 replacement_reason_id
No
numeric(18,0) IDENTITY
replacement_reason_id USAPHC agree to drop


COPS/VRS 8 dbo.VRS_Lookup_Decal_Replacement_Reason 2 replacement_reason_txt
No
varchar(50) NULL
replacement_reason_txt USAPHC agree to drop


COPS/VRS 8 dbo.VRS_Lookup_Decal_Replacement_Reason 3 deleted_bln
No
tinyint NULL
deleted_bln USAPHC agree to drop


COPS/VRS 9 dbo.VRS_Lookup_Decal_Returned_Reason 1 returned_reason_id
No
int IDENTITY
returned_reason_id USAPHC agree to drop


COPS/VRS 9 dbo.VRS_Lookup_Decal_Returned_Reason 2 returned_reason_txt
No
varchar(50) NOT NULL
returned_reason_txt USAPHC agree to drop


COPS/VRS 9 dbo.VRS_Lookup_Decal_Returned_Reason 3 deleted_bln
No
tinyint NOT NULL
deleted_bln USAPHC agree to drop


COPS/VRS 10 dbo.VRS_Lookup_Functional_Areas 1 func_area_id
No
smallint NOT NULL
func_area_id USAPHC agree to drop


COPS/VRS 10 dbo.VRS_Lookup_Functional_Areas 2 func_area_txt
No
varchar(50) NOT NULL
func_area_txt USAPHC agree to drop


COPS/VRS 11 dbo.VRS_Lookup_Image_Type 1 image_type_id
No
int IDENTITY
image_type_id USAPHC agree to drop


COPS/VRS 11 dbo.VRS_Lookup_Image_Type 2 image_type_txt
No
char(25) NULL
image_type_txt USAPHC agree to drop


COPS/VRS 12 dbo.VRS_Lookup_Institutional_Report_User_Permissions 1 level_id
No
int IDENTITY
level_id



COPS/VRS 12 dbo.VRS_Lookup_Institutional_Report_User_Permissions 2 level_user_id Yes No
int NULL
level_user_id



COPS/VRS 12 dbo.VRS_Lookup_Institutional_Report_User_Permissions 3 report_level_id
No
int NULL
report_level_id



COPS/VRS 13 dbo.VRS_Lookup_Officer 1 officer_id
No
int NOT NULL
officer_id



COPS/VRS 13 dbo.VRS_Lookup_Officer 2 officer_number_txt Yes No
varchar(25) NULL
officer_number_txt



COPS/VRS 13 dbo.VRS_Lookup_Officer 3 officer_last_name_txt Yes No
varchar(50) NULL
officer_last_name_txt



COPS/VRS 13 dbo.VRS_Lookup_Officer 4 officer_first_name_txt Yes No
varchar(50) NULL
officer_first_name_txt



COPS/VRS 13 dbo.VRS_Lookup_Officer 5 officer_middle_name_txt Yes No
varchar(50) NULL
officer_middle_name_txt



COPS/VRS 13 dbo.VRS_Lookup_Officer 6 officer_grade_rank_id DI No
smallint NULL
officer_grade_rank_id



COPS/VRS 13 dbo.VRS_Lookup_Officer 7 officer_installation_id
No
smallint NULL
officer_installation_id



COPS/VRS 14 dbo.VRS_Lookup_pet_gender 1 pet_gender_id
No
smallint IDENTITY
pet_gender_id



COPS/VRS 14 dbo.VRS_Lookup_pet_gender 2 pet_gender_description_txt
No
varchar(50) NULL
pet_gender_description_txt



COPS/VRS 15 dbo.VRS_Lookup_Pet_Species 1 species_id
No
int IDENTITY
species_id



COPS/VRS 15 dbo.VRS_Lookup_Pet_Species 2 species_txt
No
char(50) NULL
species_txt



COPS/VRS 16 dbo.VRS_Lookup_Position 1 position_id
No
smallint IDENTITY
position_id



COPS/VRS 16 dbo.VRS_Lookup_Position 2 position_txt
No
varchar(50) NULL
position_txt



COPS/VRS 17 dbo.VRS_Lookup_Reports 1 report_id
No
smallint NOT NULL
report_id USAPHC agree to drop


COPS/VRS 17 dbo.VRS_Lookup_Reports 2 report_name_txt
No
varchar(50) NOT NULL
report_name_txt USAPHC agree to drop


COPS/VRS 17 dbo.VRS_Lookup_Reports 3 report_desc_txt
No
varchar(50) NULL
report_desc_txt USAPHC agree to drop


COPS/VRS 17 dbo.VRS_Lookup_Reports 4 report_url
No
varchar(100) NULL
report_url USAPHC agree to drop


COPS/VRS 17 dbo.VRS_Lookup_Reports 5 type_id
No
smallint NOT NULL
type_id USAPHC agree to drop


COPS/VRS 17 dbo.VRS_Lookup_Reports 6 report_search_bln
No
int NOT NULL,
report_search_bln USAPHC agree to drop


COPS/VRS 18 dbo.VRS_Lookup_Reports_Criteria 1 criteria_id
No
smallint NOT NULL
criteria_id USAPHC agree to drop


COPS/VRS 18 dbo.VRS_Lookup_Reports_Criteria 2 criteria_label_txt
No
varchar(50) NOT NULL
criteria_label_txt USAPHC agree to drop


COPS/VRS 18 dbo.VRS_Lookup_Reports_Criteria 3 criteria_html_txt
No
varchar(7500) NOT NULL
criteria_html_txt USAPHC agree to drop


COPS/VRS 19 dbo.VRS_Lookup_Sponsor_Organizations 1 sponsor_organization_id DI No
smallint IDENTITY
sponsor_organization_id



COPS/VRS 19 dbo.VRS_Lookup_Sponsor_Organizations 2 sponsor_organization_txt Yes No
varchar(50) NULL
sponsor_organization_txt



COPS/VRS 19 dbo.VRS_Lookup_Sponsor_Organizations 3 sponsor_installation_id
No
int NULL
sponsor_installation_id



COPS/VRS 19 dbo.VRS_Lookup_Sponsor_Organizations 4 deactivate_bln
No
tinyint NULL
deactivate_bln



COPS/VRS 20 dbo.VRS_Lookup_Temp_Pass 1 temp_pass_id
No
int IDENTITY
temp_pass_id



COPS/VRS 20 dbo.VRS_Lookup_Temp_Pass 2 temp_pass_title_txt Yes No
varchar(50) NULL
temp_pass_title_txt



COPS/VRS 20 dbo.VRS_Lookup_Temp_Pass 3 temp_pass_regulation_txt Yes No
varchar(1000) NULL
temp_pass_regulation_txt



COPS/VRS 20 dbo.VRS_Lookup_Temp_Pass 4 installation_id
No
int NULL
installation_id



COPS/VRS 20 dbo.VRS_Lookup_Temp_Pass 5 logo_img
No
image NULL
logo_img



COPS/VRS 20 dbo.VRS_Lookup_Temp_Pass 6 watermark_img
No
image NULL
watermark_img



COPS/VRS 20 dbo.VRS_Lookup_Temp_Pass 7 show_photo_bln
No
tinyint NULL
show_photo_bln



COPS/VRS 20 dbo.VRS_Lookup_Temp_Pass 8 show_visitor_badge_bln
No
tinyint NULL
show_visitor_badge_bln



COPS/VRS 20 dbo.VRS_Lookup_Temp_Pass 9 show_visitor_name_bln
No
tinyint NULL
show_visitor_name_bln



COPS/VRS 20 dbo.VRS_Lookup_Temp_Pass 10 delete_bln
No
bit NULL
delete_bln DEFAULT 0


COPS/VRS 21 dbo.VRS_Lookup_Vehicle_Offense 1 vehicle_offense_id
No
smallint IDENTITY
vehicle_offense_id



COPS/VRS 21 dbo.VRS_Lookup_Vehicle_Offense 2 vehicle_offense_cd
No
varchar(4) NOT NULL
vehicle_offense_cd



COPS/VRS 21 dbo.VRS_Lookup_Vehicle_Offense 3 vehicle_offense_txt
No
varchar(25) NOT NULL
vehicle_offense_txt



COPS/VRS 22 dbo.VRS_Lookup_Vehicle_Status 1 Vehicle_Status_id
No
smallint IDENTITY
Vehicle_Status_id USAPHC agree to drop - look up table will be sent separately, not needed in the response.


COPS/VRS 22 dbo.VRS_Lookup_Vehicle_Status 2 Vehicle_Status_txt
No
char(15) NOT NULL
Vehicle_Status_txt USAPHC agree to drop


COPS/VRS 23 dbo.VRS_Lookup_Vehicle_Type 1 type_id
No
smallint IDENTITY
type_id



COPS/VRS 23 dbo.VRS_Lookup_Vehicle_Type 2 type_txt
No
char(30) NULL
type_txt



COPS/VRS 24 dbo.VRS_Registered_Bicycles 1 bicycle_id
No
int IDENTITY
bicycle_id



COPS/VRS 24 dbo.VRS_Registered_Bicycles 2 registrant_number_id Yes No
int NOT NULL
registrant_number_id



COPS/VRS 24 dbo.VRS_Registered_Bicycles 3 bicycle_registration_dt
No
datetime NULL
bicycle_registration_dt



COPS/VRS 24 dbo.VRS_Registered_Bicycles 4 bicycle_serial_number_txt
No
varchar(50) NOT NULL
bicycle_serial_number_txt



COPS/VRS 24 dbo.VRS_Registered_Bicycles 5 bicycle_decal_number_txt
No
varchar(50) NOT NULL
bicycle_decal_number_txt



COPS/VRS 24 dbo.VRS_Registered_Bicycles 6 bicycle_make_id
No
int NULL
bicycle_make_id



COPS/VRS 24 dbo.VRS_Registered_Bicycles 7 bicycle_model_txt
No
varchar(50) NULL
bicycle_model_txt



COPS/VRS 24 dbo.VRS_Registered_Bicycles 8 bicycle_type_id
No
int NULL
bicycle_type_id



COPS/VRS 24 dbo.VRS_Registered_Bicycles 9 bicycle_color_txt
No
varchar(50) NULL
bicycle_color_txt



COPS/VRS 24 dbo.VRS_Registered_Bicycles 10 bicycle_style_id
No
int NULL
bicycle_style_id



COPS/VRS 24 dbo.VRS_Registered_Bicycles 11 bicycle_created_dt
No
datetime NULL
bicycle_created_dt



COPS/VRS 24 dbo.VRS_Registered_Bicycles 12 bicycle_last_updated_dt
No
datetime NULL
bicycle_last_updated_dt



COPS/VRS 24 dbo.VRS_Registered_Bicycles 13 bicycle_created_by_user_id
No
int NULL
bicycle_created_by_user_id



COPS/VRS 24 dbo.VRS_Registered_Bicycles 14 bicycle_last_updated_user_id
No
int NULL
bicycle_last_updated_user_id



COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 1 Audit_Action_txt
No
char(1) NULL
Audit_Action_txt



COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 2 Audit_dt
No
datetime NULL
Audit_dt



COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 3 bicycle_id
No
int NULL
bicycle_id



COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 4 registrant_number_id
No
int NOT NULL
registrant_number_id



COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 5 bicycle_registration_dt
No
datetime NULL
bicycle_registration_dt



COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 6 bicycle_serial_number_txt
No
varchar(50) NOT NULL
bicycle_serial_number_txt



COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 7 bicycle_decal_number_txt
No
varchar(50) NOT NULL
bicycle_decal_number_txt



COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 8 bicycle_make_id
No
int NULL
bicycle_make_id



COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 9 bicycle_model_txt
No
varchar(50) NULL
bicycle_model_txt



COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 10 bicycle_type_id
No
int NULL
bicycle_type_id



COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 11 bicycle_color_txt
No
varchar(50) NULL
bicycle_color_txt



COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 12 bicycle_style_id
No
int NULL
bicycle_style_id



COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 13 bicycle_created_dt
No
datetime NULL
bicycle_created_dt



COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 14 bicycle_last_updated_dt
No
datetime NULL
bicycle_last_updated_dt



COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 15 bicycle_created_by_user_id
No
int NULL
bicycle_created_by_user_id



COPS/VRS 25 dbo.VRS_Registered_Bicycles_Audit 16 bicycle_last_updated_user_id
No
int NULL
bicycle_last_updated_user_id



COPS/VRS 26 dbo.VRS_Registered_Decals 1 decal_id
No
int IDENTITY
decal_id USAPHC agree to drop - Decal data not needed because required information is contained in regstration


COPS/VRS 26 dbo.VRS_Registered_Decals 2 registrant_number_id
No
int NULL
registrant_number_id USAPHC agree to drop


COPS/VRS 26 dbo.VRS_Registered_Decals 3 installation_id
No
int NULL
installation_id USAPHC agree to drop


COPS/VRS 26 dbo.VRS_Registered_Decals 4 vehicle_id
No
int NULL
vehicle_id USAPHC agree to drop


COPS/VRS 26 dbo.VRS_Registered_Decals 5 vehicle_year_num
No
int NULL
vehicle_year_num USAPHC agree to drop


COPS/VRS 26 dbo.VRS_Registered_Decals 6 vehicle_make_id
No
int NULL
vehicle_make_id USAPHC agree to drop


COPS/VRS 26 dbo.VRS_Registered_Decals 7 vehicle_model_txt
No
varchar(20) NULL
vehicle_model_txt USAPHC agree to drop


COPS/VRS 26 dbo.VRS_Registered_Decals 8 vehicle_decal_number_txt
No
varchar(7) NULL
vehicle_decal_number_txt USAPHC agree to drop


COPS/VRS 26 dbo.VRS_Registered_Decals 9 vehicle_decal_replacement_reason_id
No
int NULL
vehicle_decal_replacement_reason_id USAPHC agree to drop


COPS/VRS 26 dbo.VRS_Registered_Decals 10 vehicle_decal_updated_dt
No
datetime NULL
vehicle_decal_updated_dt USAPHC agree to drop


COPS/VRS 26 dbo.VRS_Registered_Decals 11 vehicle_decal_updated_by_user_id
No
int NULL
vehicle_decal_updated_by_user_id USAPHC agree to drop


COPS/VRS 26 dbo.VRS_Registered_Decals 12 recovered_bln
No
int NULL
recovered_bln USAPHC agree to drop


COPS/VRS 26 dbo.VRS_Registered_Decals 13 vehicle_decal_returned_reason_id
No
int NULL
vehicle_decal_returned_reason_id USAPHC agree to drop


COPS/VRS 27 dbo.VRS_Registered_Images 1 image_id
No
numeric(18,0) IDENTITY
image_id USAPHC agree to drop


COPS/VRS 27 dbo.VRS_Registered_Images 2 registrant_number_id
No
numeric(18,0) NOT NULL
registrant_number_id USAPHC agree to drop


COPS/VRS 27 dbo.VRS_Registered_Images 3 image_img
No
image NULL
image_img USAPHC agree to drop


COPS/VRS 27 dbo.VRS_Registered_Images 4 image_type_id
No
int NULL
image_type_id USAPHC agree to drop


COPS/VRS 27 dbo.VRS_Registered_Images 5 image_description_txt
No
varchar(100) NULL
image_description_txt USAPHC agree to drop


COPS/VRS 27 dbo.VRS_Registered_Images 6 image_created_dt
No
datetime NULL
image_created_dt USAPHC agree to drop


COPS/VRS 27 dbo.VRS_Registered_Images 7 image_created_id
No
int NULL
image_created_id USAPHC agree to drop


COPS/VRS 28 dbo.VRS_Registered_Images_Audit 1 Audit_Action_txt
No
char(1) NULL
Audit_Action_txt



COPS/VRS 28 dbo.VRS_Registered_Images_Audit 2 Audit_dt
No
datetime NULL
Audit_dt



COPS/VRS 28 dbo.VRS_Registered_Images_Audit 3 image_id
No
int NULL
image_id



COPS/VRS 28 dbo.VRS_Registered_Images_Audit 4 registrant_number_id
No
int NOT NULL
registrant_number_id



COPS/VRS 28 dbo.VRS_Registered_Images_Audit 5 image_img
No
image NULL
image_img



COPS/VRS 28 dbo.VRS_Registered_Images_Audit 6 image_type_id
No
int NULL
image_type_id



COPS/VRS 28 dbo.VRS_Registered_Images_Audit 7 image_description_txt
No
varchar(100) NULL
image_description_txt



COPS/VRS 28 dbo.VRS_Registered_Images_Audit 8 image_created_dt
No
datetime NULL
image_created_dt



COPS/VRS 28 dbo.VRS_Registered_Images_Audit 9 image_created_id
No
int NULL
image_created_id



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


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


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


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


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


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


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


COPS/VRS 29 dbo.VRS_Registered_Personnel 8 registrant_suffix_cd Yes No
varchar(6) NULL
registrant_suffix_cd USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 9 registrant_operator_number_txt
No
varchar(25) NULL
registrant_operator_number_txt USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 10 registrant_operator_state_id
No
int NULL
registrant_operator_state_id USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 11 registrant_category_id
No
int NULL
registrant_category_id USAPHC to review


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


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


COPS/VRS 29 dbo.VRS_Registered_Personnel 14 registrant_ets_dt
No
datetime NULL
registrant_ets_dt USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 15 registrant_component_id
No
int NULL
registrant_component_id USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 16 registrant_gender_id
Yes
int NULL
registrant_gender_id USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 17 registrant_height_txt
No
varchar(10) NULL
registrant_height_txt USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 18 registrant_weight_txt
No
varchar(5) NULL
registrant_weight_txt USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 19 registrant_eye_color_id
No
int NULL
registrant_eye_color_id USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 20 registrant_hair_color_id
No
int NULL
registrant_hair_color_id USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 21 registrant_marital_status_id
No
int NULL
registrant_marital_status_id USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 22 registrant_ethnicity_id
No
int NULL
registrant_ethnicity_id USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 23 registrant_race_id
No
int NULL
registrant_race_id USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 24 registrant_home_address_txt Yes No
varchar(100) NULL
registrant_home_address_txt USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 25 registrant_home_city_txt
No
varchar(50) NULL
registrant_home_city_txt USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 26 registrant_home_state_id
No
int NULL
registrant_home_state_id USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 27 registrant_home_zipcode_txt
No
varchar(15) NULL
registrant_home_zipcode_txt USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 28 registrant_home_country_id
No
int NULL
registrant_home_country_id USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 29 registrant_home_phone_txt Yes No
varchar(15) NULL
registrant_home_phone_txt USAPHC to review


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


COPS/VRS 29 dbo.VRS_Registered_Personnel 31 registrant_unit_address_txt Yes No
varchar(100) NULL
registrant_unit_address_txt USAPHC to review
It is entered by law enforcement, is not required, and is dependent upon what the registrant says, so it is not necessarily accurate.
COPS/VRS 29 dbo.VRS_Registered_Personnel 32 registrant_unit_city_txt
No
varchar(50) NULL
registrant_unit_city_txt USAPHC to review
It is entered by law enforcement, is not required, and is dependent upon what the registrant says, so it is not necessarily accurate.
COPS/VRS 29 dbo.VRS_Registered_Personnel 33 registrant_unit_state_id
No
int NULL
registrant_unit_state_id USAPHC to review
It is entered by law enforcement, is not required, and is dependent upon what the registrant says, so it is not necessarily accurate.
COPS/VRS 29 dbo.VRS_Registered_Personnel 34 registrant_unit_zipcode_txt
No
varchar(15) NULL
registrant_unit_zipcode_txt USAPHC to review
It is entered by law enforcement, is not required, and is dependent upon what the registrant says, so it is not necessarily accurate.
COPS/VRS 29 dbo.VRS_Registered_Personnel 35 registrant_unit_country_id
No
int NULL
registrant_unit_country_id USAPHC to review
It is entered by law enforcement, is not required, and is dependent upon what the registrant says, so it is not necessarily accurate.
COPS/VRS 29 dbo.VRS_Registered_Personnel 36 registrant_unit_phone_txt Yes No
varchar(25) NULL
registrant_unit_phone_txt USAPHC to review
It is entered by law enforcement, is not required, and is dependent upon what the registrant says, so it is not necessarily accurate.
COPS/VRS 29 dbo.VRS_Registered_Personnel 37 registrant_unit_phone_ext_txt Yes No
varchar(10) NULL
registrant_unit_phone_ext_txt USAPHC to review
It is entered by law enforcement, is not required, and is dependent upon what the registrant says, so it is not necessarily accurate.
COPS/VRS 29 dbo.VRS_Registered_Personnel 38 registrant_remarks_txt Yes No
varchar(100) NULL
registrant_remarks_txt USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 39 registrant_sponsor_id_value_id DI No
int NULL
registrant_sponsor_id_value_id USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 40 registrant_sponsor_id_value_txt Yes No
varchar(15) NULL
registrant_sponsor_id_value_txt USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 41 registrant_sponsor_last_name_txt Yes No
varchar(50) NULL
registrant_sponsor_last_name_txt USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 42 registrant_sponsor_first_name_txt Yes No
varchar(50) NULL
registrant_sponsor_first_name_txt USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 43 registrant_sponsor_relationship_id
No
int NULL
registrant_sponsor_relationship_id USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 44 registrant_sponsor_home_phone_txt Yes No
varchar(25) NULL
registrant_sponsor_home_phone_txt USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 45 registrant_created_dt
No
datetime NULL
registrant_created_dt USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 46 registrant_created_by_user_id
No
int NULL
registrant_created_by_user_id USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 47 registrant_last_updated_id
No
int NULL
registrant_last_updated_id USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 48 registrant_last_updated_dt
No
datetime NULL
registrant_last_updated_dt USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 49 registrant_sponsor_organization_id Yes No
int NULL
registrant_sponsor_organization_id USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 50 registrant_security_group_txt
No
varchar(10) NULL
registrant_security_group_txt USAPHC to review


COPS/VRS 29 dbo.VRS_Registered_Personnel 51 registrant_sponsor_deceased_bln
No
tinyint NULL
registrant_sponsor_deceased_bln USAPHC to review


COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 1 Audit_Action_txt
No
char(1) NULL
Audit_Action_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 2 Audit_dt
No
datetime NULL
Audit_dt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 3 registrant_number_id
No
int NULL
registrant_number_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 4 registrant_installation_id
No
int NULL
registrant_installation_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 5 registrant_id_type_id
No
int NULL
registrant_id_type_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 6 registrant_id_value_txt Yes No
varchar(25) NULL
registrant_id_value_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 7 registrant_last_name_txt Yes No
varchar(50) NULL
registrant_last_name_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 8 registrant_first_name_txt Yes No
varchar(50) NULL
registrant_first_name_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 9 registrant_middle_name_txt Yes No
varchar(50) NULL
registrant_middle_name_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 10 registrant_suffix_cd Yes No
varchar(6) NULL
registrant_suffix_cd



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 11 registrant_operator_number_txt
No
varchar(25) NULL
registrant_operator_number_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 12 registrant_operator_state_id
No
int NULL
registrant_operator_state_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 13 registrant_category_id
No
int NULL
registrant_category_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 14 registrant_grade_rank_id DI No
int NULL
registrant_grade_rank_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 15 registrant_birth_dt
No
datetime NULL
registrant_birth_dt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 16 registrant_ets_dt
No
datetime NULL
registrant_ets_dt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 17 registrant_component_id
No
int NULL
registrant_component_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 18 registrant_gender_id
No
int NULL
registrant_gender_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 19 registrant_height_txt
No
varchar(10) NULL
registrant_height_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 20 registrant_weight_txt
No
varchar(5) NULL
registrant_weight_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 21 registrant_eye_color_id
No
int NULL
registrant_eye_color_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 22 registrant_hair_color_id
No
int NULL
registrant_hair_color_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 23 registrant_marital_status_id
No
int NULL
registrant_marital_status_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 24 registrant_ethnicity_id
No
int NULL
registrant_ethnicity_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 25 registrant_race_id
No
int NULL
registrant_race_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 26 registrant_home_address_txt Yes No
varchar(100) NULL
registrant_home_address_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 27 registrant_home_city_txt
No
varchar(50) NULL
registrant_home_city_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 28 registrant_home_state_id
No
int NULL
registrant_home_state_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 29 registrant_home_zipcode_txt
No
varchar(15) NULL
registrant_home_zipcode_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 30 registrant_home_country_id
No
int NULL
registrant_home_country_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 31 registrant_home_phone_txt Yes No
varchar(25) NULL
registrant_home_phone_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 32 registrant_uic_id DI No
int NULL
registrant_uic_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 33 registrant_unit_address_txt Yes No
varchar(100) NULL
registrant_unit_address_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 34 registrant_unit_city_txt
No
varchar(50) NULL
registrant_unit_city_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 35 registrant_unit_state_id
No
int NULL
registrant_unit_state_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 36 registrant_unit_zipcode_txt
No
varchar(15) NULL
registrant_unit_zipcode_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 37 registrant_unit_country_id
No
int NULL
registrant_unit_country_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 38 registrant_unit_phone_txt Yes No
varchar(25) NULL
registrant_unit_phone_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 39 registrant_unit_phone_ext_txt Yes No
varchar(10) NULL
registrant_unit_phone_ext_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 40 registrant_remarks_txt Yes No
varchar(100) NULL
registrant_remarks_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 41 registrant_sponsor_id_value_id DI No
int NULL
registrant_sponsor_id_value_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 42 registrant_sponsor_id_value_txt Yes No
varchar(15) NULL
registrant_sponsor_id_value_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 43 registrant_sponsor_last_name_txt Yes No
varchar(50) NULL
registrant_sponsor_last_name_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 44 registrant_sponsor_first_name_txt Yes No
varchar(50) NULL
registrant_sponsor_first_name_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 45 registrant_sponsor_relationship_id
No
int NULL
registrant_sponsor_relationship_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 46 registrant_sponsor_home_phone_txt Yes No
varchar(25) NULL
registrant_sponsor_home_phone_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 47 registrant_created_dt
No
datetime NULL
registrant_created_dt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 48 registrant_created_by_user_id
No
int NULL
registrant_created_by_user_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 49 registrant_last_updated_id
No
int NULL
registrant_last_updated_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 50 registrant_last_updated_dt
No
datetime NULL
registrant_last_updated_dt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 51 registrant_sponsor_organization_id Yes No
int NULL
registrant_sponsor_organization_id



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 52 registrant_security_group_txt
No
varchar(10) NULL
registrant_security_group_txt



COPS/VRS 30 dbo.VRS_Registered_Personnel_Audit 53 registrant_sponsor_deceased_bln
No
tinyint NULL
registrant_sponsor_deceased_bln



COPS/VRS 31 dbo.VRS_Registered_Pets 1 pet_id
No
int IDENTITY
pet_id



COPS/VRS 31 dbo.VRS_Registered_Pets 2 registrant_number_id
No
int NULL
registrant_number_id



COPS/VRS 31 dbo.VRS_Registered_Pets 3 pet_registration_number_txt
No
varchar(50) NULL
pet_registration_number_txt



COPS/VRS 31 dbo.VRS_Registered_Pets 4 pet_license_number_txt
No
varchar(50) NULL
pet_license_number_txt



COPS/VRS 31 dbo.VRS_Registered_Pets 5 pet_species_id
No
smallint NULL
pet_species_id



COPS/VRS 31 dbo.VRS_Registered_Pets 6 pet_breed_txt
No
varchar(50) NULL
pet_breed_txt



COPS/VRS 31 dbo.VRS_Registered_Pets 7 pet_age_txt
No
varchar(50) NULL
pet_age_txt



COPS/VRS 31 dbo.VRS_Registered_Pets 8 pet_sex_id
No
smallint NULL
pet_sex_id



COPS/VRS 31 dbo.VRS_Registered_Pets 9 pet_color_txt
No
varchar(50) NULL
pet_color_txt



COPS/VRS 31 dbo.VRS_Registered_Pets 10 pet_markings_txt
No
varchar(50) NULL
pet_markings_txt



COPS/VRS 31 dbo.VRS_Registered_Pets 11 pet_registration_dt
No
datetime NULL
pet_registration_dt



COPS/VRS 31 dbo.VRS_Registered_Pets 12 pet_registration_expiration_dt
No
datetime NULL
pet_registration_expiration_dt



COPS/VRS 31 dbo.VRS_Registered_Pets 13 pet_description_txt
No
varchar(150) NULL
pet_description_txt



COPS/VRS 31 dbo.VRS_Registered_Pets 14 pet_created_dt
No
datetime NULL
pet_created_dt



COPS/VRS 31 dbo.VRS_Registered_Pets 15 pet_created_by_user_id
No
smallint NULL
pet_created_by_user_id



COPS/VRS 31 dbo.VRS_Registered_Pets 16 pet_last_updated_dt
No
datetime NULL
pet_last_updated_dt



COPS/VRS 31 dbo.VRS_Registered_Pets 17 pet_last_updated_id
No
smallint NULL
pet_last_updated_id



COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 1 Audit_Action_txt
No
char(1) NULL
Audit_Action_txt



COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 2 Audit_dt
No
datetime NULL
Audit_dt



COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 3 pet_id
No
int NULL
pet_id



COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 4 registrant_number_id
No
int NULL
registrant_number_id



COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 5 pet_registration_number_txt
No
varchar(50) NULL
pet_registration_number_txt



COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 6 pet_license_number_txt
No
varchar(50) NULL
pet_license_number_txt



COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 7 pet_species_id
No
int NULL
pet_species_id



COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 8 pet_breed_txt
No
varchar(50) NULL
pet_breed_txt



COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 9 pet_age_txt
No
varchar(50) NULL
pet_age_txt



COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 10 pet_sex_id
No
int NULL
pet_sex_id



COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 11 pet_color_txt
No
varchar(50) NULL
pet_color_txt



COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 12 pet_markings_txt
No
varchar(50) NULL
pet_markings_txt



COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 13 pet_registration_dt
No
datetime NULL
pet_registration_dt



COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 14 pet_registration_expiration_dt
No
datetime NULL
pet_registration_expiration_dt



COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 15 pet_description_txt
No
varchar(150) NULL
pet_description_txt



COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 16 pet_created_dt
No
datetime NULL
pet_created_dt



COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 17 pet_created_by_user_id
No
int NULL
pet_created_by_user_id



COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 18 pet_last_updated_dt
No
datetime NULL
pet_last_updated_dt



COPS/VRS 32 dbo.VRS_Registered_Pets_Audit 19 pet_last_updated_id
No
int NULL
pet_last_updated_id



COPS/VRS 33 dbo.VRS_Registered_Vehicles 1 vehicle_id
No
int IDENTITY
vehicle_id USAPHC to review
This is an index number for the table and will not be returned by the web service.
COPS/VRS 33 dbo.VRS_Registered_Vehicles 2 registrant_number_id
Yes
int NOT NULL
registrant_number_id USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 3 vehicle_vin_txt
No
varchar(30) NULL
vehicle_vin_txt USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 4 vehicle_decal_number_txt
No
varchar(7) NULL
vehicle_decal_number_txt USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 5 vehicle_decal_expiration_dt
No
datetime NULL
vehicle_decal_expiration_dt USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 6 vehicle_registration_dt
No
datetime NULL
vehicle_registration_dt USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 7 vehicle_year_num
No
int NULL
vehicle_year_num USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 8 vehicle_make_id
Yes
int NULL
vehicle_make_id USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 9 vehicle_model_txt
Yes
varchar(20) NULL
vehicle_model_txt USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 10 vehicle_body_style_id
Yes
int NULL
vehicle_body_style_id USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 11 vehicle_color_txt
No
varchar(20) NULL
vehicle_color_txt USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 12 vehicle_license_state_id
No
int NULL
vehicle_license_state_id USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 13 vehicle_license_country_id
No
int NULL
vehicle_license_country_id USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 14 vehicle_license_number_txt Yes No
varchar(15) NULL
vehicle_license_number_txt USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 15 vehicle_license_year_num
No
int NULL
vehicle_license_year_num USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 16 vehicle_signature_dt
No
datetime NULL
vehicle_signature_dt USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 17 vehicle_comments_txt Yes No
varchar(1000) NULL
vehicle_comments_txt USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 18 vehicle_status_id
No
int NULL
vehicle_status_id USAPHC to review
Actual text values could be Stolen, Storage, Impounded, or Operational
COPS/VRS 33 dbo.VRS_Registered_Vehicles 19 vehicle_state_emissions_bln
No
tinyint NULL
vehicle_state_emissions_bln USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 20 vehicle_insurance_req_bln
No
tinyint NULL
vehicle_insurance_req_bln USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 21 vehicle_insurance_company_name_txt
No
varchar(30) NULL
vehicle_insurance_company_name_txt USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 22 vehicle_insurance_policy_num_txt Yes No
varchar(30) NULL
vehicle_insurance_policy_num_txt USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 23 vehicle_insured_policy_expiration_dt
No
datetime NULL
vehicle_insured_policy_expiration_dt USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 24 vehicle_rfid_number_txt
No
varchar(30) NULL
vehicle_rfid_number_txt USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 25 vehicle_created_dt
No
datetime NULL
vehicle_created_dt USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 26 vehicle_updated_dt
No
datetime NULL
vehicle_updated_dt USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 27 vehicle_created_by_userid
No
int NULL
vehicle_created_by_userid USAPHC to review


COPS/VRS 33 dbo.VRS_Registered_Vehicles 28 vehicle_last_updated_userid
No
int NULL
vehicle_last_updated_userid USAPHC to review


COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 1 Audit_Action_txt
No
char(1) NULL
Audit_Action_txt



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 2 Audit_dt
No
datetime NULL
Audit_dt



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 3 vehicle_id
No
int NULL
vehicle_id



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 4 registrant_number_id
No
int NOT NULL
registrant_number_id



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 5 vehicle_vin_txt
No
varchar(30) NULL
vehicle_vin_txt



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 6 vehicle_decal_number_txt
No
varchar(7) NULL
vehicle_decal_number_txt



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 7 vehicle_decal_expiration_dt
No
datetime NULL
vehicle_decal_expiration_dt



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 8 vehicle_registration_dt
No
datetime NULL
vehicle_registration_dt



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 9 vehicle_year_num
No
int NULL
vehicle_year_num



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 10 vehicle_make_id
No
int NULL
vehicle_make_id



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 11 vehicle_model_txt
No
varchar(20) NULL
vehicle_model_txt



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 12 vehicle_body_style_id
No
int NULL
vehicle_body_style_id



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 13 vehicle_color_txt
No
varchar(20) NULL
vehicle_color_txt



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 14 vehicle_license_state_id
No
int NULL
vehicle_license_state_id



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 15 vehicle_license_country_id
No
int NULL
vehicle_license_country_id



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 16 vehicle_license_number_txt Yes No
varchar(15) NULL
vehicle_license_number_txt



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 17 vehicle_license_year_num
No
int NULL
vehicle_license_year_num



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 18 vehicle_signature_dt
No
datetime NULL
vehicle_signature_dt



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 19 vehicle_comments_txt Yes No
varchar(1000) NULL
vehicle_comments_txt



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 20 vehicle_status_id
No
int NULL
vehicle_status_id



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 21 vehicle_state_emissions_bln
No
tinyint NULL
vehicle_state_emissions_bln



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 22 vehicle_insurance_req_bln
No
tinyint NULL
vehicle_insurance_req_bln



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 23 vehicle_insurance_company_name_txt
No
varchar(30) NULL
vehicle_insurance_company_name_txt



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 24 vehicle_insurance_policy_num_txt Yes No
varchar(30) NULL
vehicle_insurance_policy_num_txt



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 25 vehicle_insured_policy_expiration_dt
No
datetime NULL
vehicle_insured_policy_expiration_dt



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 26 vehicle_rfid_number_txt
No
varchar(30) NULL
vehicle_rfid_number_txt



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 27 vehicle_created_dt
No
datetime NULL
vehicle_created_dt



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 28 vehicle_updated_dt
No
datetime NULL
vehicle_updated_dt



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 29 vehicle_created_by_userid
No
int NULL
vehicle_created_by_userid



COPS/VRS 34 dbo.VRS_Registered_Vehicles_Audit 30 vehicle_last_updated_userid
No
int NULL
vehicle_last_updated_userid



COPS/VRS 35 dbo.VRS_Registered_Weapons 1 weapon_id
No
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
No
varchar(30) NULL
weapon_serial_number_txt



COPS/VRS 35 dbo.VRS_Registered_Weapons 4 weapon_registration_number_txt
No
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
No
int NULL
weapon_type_id



COPS/VRS 35 dbo.VRS_Registered_Weapons 9 weapon_overall_length_txt
No
varchar(10) NULL
weapon_overall_length_txt



COPS/VRS 35 dbo.VRS_Registered_Weapons 10 weapon_barrel_length_txt
No
varchar(10) NULL
weapon_barrel_length_txt



COPS/VRS 35 dbo.VRS_Registered_Weapons 11 weapon_signature_dt
No
datetime NULL
weapon_signature_dt



COPS/VRS 35 dbo.VRS_Registered_Weapons 12 weapon_registration_dt
No
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
No
int NULL
weapon_finish_id



COPS/VRS 35 dbo.VRS_Registered_Weapons 15 weapon_description_txt
No
varchar(150) NULL
weapon_description_txt



COPS/VRS 35 dbo.VRS_Registered_Weapons 16 weapon_created_dt
No
datetime NULL
weapon_created_dt



COPS/VRS 35 dbo.VRS_Registered_Weapons 17 weapon_updated_dt
No
datetime NULL
weapon_updated_dt



COPS/VRS 35 dbo.VRS_Registered_Weapons 18 weapon_created_by_userid
No
int NULL
weapon_created_by_userid



COPS/VRS 35 dbo.VRS_Registered_Weapons 19 weapon_last_updated_userid
No
int NULL
weapon_last_updated_userid



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 1 Audit_Action_txt
No
char(1) NULL
Audit_Action_txt



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 2 Audit_dt
No
datetime NULL
Audit_dt



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 3 weapon_id
No
int NULL
weapon_id



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 4 registrant_number_id DI No
int NULL
registrant_number_id



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 5 weapon_serial_number_txt
No
varchar(30) NULL
weapon_serial_number_txt



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 6 weapon_registration_number_txt
No
varchar(15) NULL
weapon_registration_number_txt



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 7 weapon_make_id
No
int NULL
weapon_make_id



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 8 weapon_model_txt
No
varchar(30) NULL
weapon_model_txt



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 9 weapon_caliber_gauge_id
No
int NULL
weapon_caliber_gauge_id



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 10 weapon_type_id
No
int NULL
weapon_type_id



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 11 weapon_overall_length_txt
No
varchar(10) NULL
weapon_overall_length_txt



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 12 weapon_barrel_length_txt
No
varchar(10) NULL
weapon_barrel_length_txt



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 13 weapon_signature_dt
No
datetime NULL
weapon_signature_dt



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 14 weapon_registration_dt
No
datetime NULL
weapon_registration_dt



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 15 weapon_location_id
No
int NULL
weapon_location_id



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 16 weapon_finish_id
No
int NULL
weapon_finish_id



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 17 weapon_description_txt
No
varchar(150) NULL
weapon_description_txt



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 18 weapon_created_dt
No
datetime NULL
weapon_created_dt



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 19 weapon_updated_dt
No
datetime NULL
weapon_updated_dt



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 20 weapon_created_by_userid
No
int NULL
weapon_created_by_userid



COPS/VRS 36 dbo.VRS_Registered_Weapons_Audit 21 weapon_last_updated_userid
No
int NULL
weapon_last_updated_userid



COPS/VRS 37 dbo.VRS_Report_Adhoc 1 report_adhoc_Registrant_bln
No
tinyint NOT NULL
report_adhoc_Registrant_bln USAPHC agree to drop


COPS/VRS 37 dbo.VRS_Report_Adhoc 2 report_adhoc_Vehicle_bln
No
tinyint NOT NULL
report_adhoc_Vehicle_bln USAPHC agree to drop


COPS/VRS 37 dbo.VRS_Report_Adhoc 3 report_adhoc_Weapon_bln
No
tinyint NOT NULL
report_adhoc_Weapon_bln



COPS/VRS 37 dbo.VRS_Report_Adhoc 4 report_adhoc_Bicycle_bln
No
tinyint NOT NULL
report_adhoc_Bicycle_bln



COPS/VRS 37 dbo.VRS_Report_Adhoc 5 report_adhoc_Pets_bln
No
tinyint NOT NULL
report_adhoc_Pets_bln



COPS/VRS 37 dbo.VRS_Report_Adhoc 6 report_adhoc_join_txt
No
varchar(1500) NOT NULL
report_adhoc_join_txt USAPHC agree to drop


COPS/VRS 38 dbo.VRS_Report_Adhoc_saved_queries 1 query_id
No
numeric(18,0) IDENTITY
query_id USAPHC agree to drop


COPS/VRS 38 dbo.VRS_Report_Adhoc_saved_queries 2 user_id Yes No
numeric(18,0) NULL
user_id USAPHC agree to drop


COPS/VRS 38 dbo.VRS_Report_Adhoc_saved_queries 3 query_name_txt
No
varchar(50) NULL
query_name_txt USAPHC agree to drop


COPS/VRS 38 dbo.VRS_Report_Adhoc_saved_queries 4 query_txt
No
text NULL
query_txt USAPHC agree to drop


COPS/VRS 39 dbo.VRS_Reports_Criteria 1 report_id
No
numeric(18,0) NOT NULL
report_id USAPHC agree to drop


COPS/VRS 39 dbo.VRS_Reports_Criteria 2 criteria_id
No
numeric(18,0) NOT NULL
criteria_id USAPHC agree to drop


COPS/VRS 40 dbo.VRS_Temporary_Passes 1 pass_id
No
int IDENTITY
pass_id USAPHC likely not interested in this information but will review. Cox: These appear to be for people who are visitors to an installation and whose vehicle doesn't have a DoD decal and sticker, e.g., a rental car. We don't need these elements.


COPS/VRS 40 dbo.VRS_Temporary_Passes 2 pass_num_txt
No
varchar(15) NOT NULL
pass_num_txt



COPS/VRS 40 dbo.VRS_Temporary_Passes 3 registrant_installation_id
No
smallint NULL
registrant_installation_id



COPS/VRS 40 dbo.VRS_Temporary_Passes 4 issuing_installation_id
No
smallint NULL
issuing_installation_id



COPS/VRS 40 dbo.VRS_Temporary_Passes 5 registrant_number_id
No
int NULL
registrant_number_id



COPS/VRS 40 dbo.VRS_Temporary_Passes 6 ssn_txt DI No
varchar(9) NULL
ssn_txt



COPS/VRS 40 dbo.VRS_Temporary_Passes 7 last_name_txt Yes No
varchar(50) NOT NULL
last_name_txt



COPS/VRS 40 dbo.VRS_Temporary_Passes 8 first_name_txt Yes No
varchar(50) NOT NULL
first_name_txt



COPS/VRS 40 dbo.VRS_Temporary_Passes 9 middle_name_txt Yes No
varchar(50) NULL
middle_name_txt



COPS/VRS 40 dbo.VRS_Temporary_Passes 10 vehicle_VIN_txt
No
varchar(30) NULL
vehicle_VIN_txt



COPS/VRS 40 dbo.VRS_Temporary_Passes 11 vehicle_year_num
No
int NULL
vehicle_year_num



COPS/VRS 40 dbo.VRS_Temporary_Passes 12 vehicle_make_id
No
int NULL
vehicle_make_id



COPS/VRS 40 dbo.VRS_Temporary_Passes 13 vehicle_model_txt
No
varchar(20) NULL
vehicle_model_txt



COPS/VRS 40 dbo.VRS_Temporary_Passes 14 vehicle_body_style_id
No
int NULL
vehicle_body_style_id



COPS/VRS 40 dbo.VRS_Temporary_Passes 15 vehicle_color_txt
No
varchar(20) NULL
vehicle_color_txt



COPS/VRS 40 dbo.VRS_Temporary_Passes 16 vehicle_license_number_txt Yes No
varchar(20) NULL
vehicle_license_number_txt



COPS/VRS 40 dbo.VRS_Temporary_Passes 17 vehicle_license_state_id
No
int NULL
vehicle_license_state_id



COPS/VRS 40 dbo.VRS_Temporary_Passes 18 vehicle_license_year_num
No
int NULL
vehicle_license_year_num



COPS/VRS 40 dbo.VRS_Temporary_Passes 19 start_dt
No
datetime NULL
start_dt



COPS/VRS 40 dbo.VRS_Temporary_Passes 20 destination_txt
No
varchar(50) NULL
destination_txt



COPS/VRS 40 dbo.VRS_Temporary_Passes 21 no_of_days_num
No
int NULL
no_of_days_num



COPS/VRS 40 dbo.VRS_Temporary_Passes 22 approved_by_txt Yes No
varchar(25) NULL
approved_by_txt



COPS/VRS 40 dbo.VRS_Temporary_Passes 23 expired_dt
No
datetime NULL
expired_dt



COPS/VRS 40 dbo.VRS_Temporary_Passes 24 operator_number_txt Yes No
varchar(25) NULL
operator_number_txt



COPS/VRS 40 dbo.VRS_Temporary_Passes 25 operator_state_id
No
int NULL
operator_state_id



COPS/VRS 40 dbo.VRS_Temporary_Passes 26 operator_country_id
No
int NULL
operator_country_id



COPS/VRS 40 dbo.VRS_Temporary_Passes 27 birth_dt
No
datetime NULL
birth_dt



COPS/VRS 40 dbo.VRS_Temporary_Passes 28 race_id
No
int NULL
race_id



COPS/VRS 40 dbo.VRS_Temporary_Passes 29 ethnicity_id
No
int NULL
ethnicity_id



COPS/VRS 40 dbo.VRS_Temporary_Passes 30 gender_id
No
int NULL
gender_id



COPS/VRS 40 dbo.VRS_Temporary_Passes 31 height_txt
No
varchar(15) NULL
height_txt



COPS/VRS 40 dbo.VRS_Temporary_Passes 32 weight_txt
No
varchar(15) NULL
weight_txt



COPS/VRS 40 dbo.VRS_Temporary_Passes 33 eye_color_id
No
int NULL
eye_color_id



COPS/VRS 40 dbo.VRS_Temporary_Passes 34 hair_color_id
No
int NULL
hair_color_id



COPS/VRS 40 dbo.VRS_Temporary_Passes 35 poc_name_txt Yes No
varchar(40) NULL
poc_name_txt



COPS/VRS 40 dbo.VRS_Temporary_Passes 36 poc_phone_number_txt Yes No
varchar(25) NULL
poc_phone_number_txt



COPS/VRS 40 dbo.VRS_Temporary_Passes 37 visitor_type_txt
No
varchar(30) NULL
visitor_type_txt



COPS/VRS 40 dbo.VRS_Temporary_Passes 38 additional_drivers_txt Yes No
varchar(500) NULL
additional_drivers_txt



COPS/VRS 40 dbo.VRS_Temporary_Passes 39 rank_txt DI No
varchar(25) NULL
rank_txt



COPS/VRS 40 dbo.VRS_Temporary_Passes 40 suffix_cd Yes No
varchar(6) NULL
suffix_cd



COPS/VRS 41 dbo.VRS_User_Installation 1 user_id
No
int NOT NULL
user_id USAPHC agree to drop


COPS/VRS 41 dbo.VRS_User_Installation 2 installation_id
No
int NOT NULL
installation_id USAPHC agree to drop


COPS/VRS 41 dbo.VRS_User_Installation 3 last_updated_user_id
No
int NULL
last_updated_user_id USAPHC agree to drop


COPS/VRS 42 dbo.VRS_User_Installation_Audit 1 Audit_Action_txt
No
char(1) NULL
Audit_Action_txt



COPS/VRS 42 dbo.VRS_User_Installation_Audit 2 Audit_dt
No
datetime NULL
Audit_dt



COPS/VRS 42 dbo.VRS_User_Installation_Audit 3 user_id
No
int NULL
user_id



COPS/VRS 42 dbo.VRS_User_Installation_Audit 4 installation_id
No
int NOT NULL
installation_id



COPS/VRS 42 dbo.VRS_User_Installation_Audit 5 last_updated_user_id
No
int NULL
last_updated_user_id



COPS/VRS 43 dbo.VRS_User_Permissions 1 user_id
No
int NOT NULL
user_id USAPHC agree to drop


COPS/VRS 43 dbo.VRS_User_Permissions 2 func_area_id
No
int NOT NULL
func_area_id USAPHC agree to drop


COPS/VRS 43 dbo.VRS_User_Permissions 3 permission_id
No
int NULL
permission_id USAPHC agree to drop


COPS/VRS 43 dbo.VRS_User_Permissions 4 last_updated_user_id
No
int NULL
last_updated_user_id USAPHC agree to drop


COPS/VRS 44 dbo.VRS_User_Permissions_Audit 1 Audit_Action_txt
No
char(1) NULL
Audit_Action_txt



COPS/VRS 44 dbo.VRS_User_Permissions_Audit 2 Audit_dt
No
datetime NULL
Audit_dt



COPS/VRS 44 dbo.VRS_User_Permissions_Audit 3 user_id
No
int NULL
user_id



COPS/VRS 44 dbo.VRS_User_Permissions_Audit 4 func_area_id
No
int NOT NULL
func_area_id



COPS/VRS 44 dbo.VRS_User_Permissions_Audit 5 permission_id
No
int NULL
permission_id



COPS/VRS 44 dbo.VRS_User_Permissions_Audit 6 last_updated_user_id
No
int NULL
last_updated_user_id



















Key:














USAPHC recently decided to add this Element












USAPHC recently decided to drop this Element












File Typeapplication/vnd.openxmlformats-officedocument.spreadsheetml.sheet
File Modified0000-00-00
File Created0000-00-00
© 2025 OMB.report | Privacy Policy