Record Layout for CorpPak, SICPak and MarketPak
 
Inspection Table
Field Name Description
Length
Decimal Places
act_nr Activity Number
9
0
rpt_id Report ID
7
  
csho_id CSHO ID No.
5
  
estab_name Establishment Name
30
  
site_st Site Street
30
  
usps Post Office
25
  
site_state Site State
2
  
site_zip Site Zip Code
5
  
duns_nr Dun & Bradstreet Number
9
0
open_date Opening Date
8
  
lst_cls_dt Closing Conference Date
8
  
sh_code Safety or Health
1
  
sic Primary SIC Code
4
  
insp_type Inspection Type
1
  
insp_scope Inspection Scope
1
  
emp_est_nr Employees at Site
5
0
emp_cvr_nr Employees Covered
5
0
emp_tot_nr Employees Total
7
0
walk_thru Walk Around
1
  
union_rep Union
1
  
close_date Case Closed Date
8
  
antic_srvd Warrant
1
  
lwdi_rate Lost Work Day Injury Rate
6
2
tot_pen Total Penalties
13
2
tot_fta Total Failure to Abate Penalties
13
2
tot_viol Total Violations
5
0
tot_viol_s Total Serious Violations
5
0
Violation Table
act_nr Activity Number
9
0
act_cit_nr Citation Number
16
  
del_flag Deletion Flag
1
  
cur_pen Current Penalty
11
2
init_pen Initial Penalty
11
2
cur_type Current Type
1
  
init_type Initial Type
1
  
section Violation Section
8
  
items Violation Items
14
  
abate_dt Abatement Date
8
  
viol_cntst Violation Contested
1
  
pen_cntst Penalty Contested
1
  
abate_empr Employer Contested
1
  
abate_empe Employee Contested
1
  
fta_pen Failure-to-abate Penalty
11
2