SharePoint

Key Filters

Search DOC elements

Skip Navigation LinksDOC_Elements

Department of Corrections (DOC) Data Elements

Search elements of other agencies

Search all elements

  Data Element                                              Description
AboveCutOffLevel
Selected
Above Cut-Off Level
No
N/A
Yes/No
Fixed
DOC
DOC
dbo_tblRISPDATA
1998
N/A
1
Yes
This table appears to be comprehensive back to 2009.
accomplices
Normal
Did the inmate have accomplices?
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
AcqrdKnwldg_Cd
Normal
Knowledge Acquired Code
No
N/A
Text
Fixed (3)
DOC
DOC
dbo_tblEval / dbo_tblEvalHist
2000
2008
4
Yes
Data appears to be fairly comprehensive starting in 2002.
AfterCare_Id
Normal
After Care ID Code
No
N/A
Number
Fixed
DOC
DOC
dbo_tblEval / dbo_tblEvalHist
2000
2008
5
Yes
Data appears to be fairly comprehensive starting in 2002.
AfterCare_RcmdFlag
Normal
Aftercare Recommended
No
N/A
Yes/No
Fixed
DOC
DOC
dbo_tblEval / dbo_tblEvalHist
2000
2008
5
Yes
Data appears to be fairly comprehensive starting in 2002.
Alcohol
Normal
Positive for Alcohol
No
N/A
Yes/No
Fixed
DOC
DOC
dbo_tblRISPDATA
1998
N/A
4
Yes
This table appears to be comprehensive back to 2009.
alcohol
Normal
Does the inmate have a history of alcohol use?
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.  [ there is a category for IC and a category for RC ]
Amphetamine
Normal
Positive for Amphetamine
No
N/A
Yes/No
Fixed
DOC
DOC
dbo_tblRISPDATA
1998
N/A
4
Yes
This table appears to be comprehensive back to 2009.
AsmtVer_Num
Normal
Assessment version number
dbo_tblInmTestScore / dbo_tblInmTestScoreHist
5
YES
Data appears to be fairly comprehensive beginning in 2002.
Attend_Cd
Normal
Attendance Code
No
N/A
Text
Fixed (3)
DOC
DOC
dbo_tblEval / dbo_tblEvalHist
2000
2008
1
Yes
Data in this table appears to be fairly comprehensive starting in 2002.  This field was most frequently completed for programs ending 2003-2006.
bail_days
Normal
Bail Days
No
N/A
Text
Fixed (4 char)
DOC
DOC
dbo_Senrec
No
bail_mths
Normal
Bail Months
No
N/A
Text
Fixed (3 char)
DOC
DOC
dbo_Senrec
No
bail_yrs
Normal
Bail Years
No
N/A
Text
Fixed (3 char)
DOC
DOC
dbo_Senrec
No
Barbiturates
Normal
Positive for Barbiturates
No
N/A
Yes/No
Fixed
DOC
DOC
dbo_tblRISPDATA
1998
N/A
4
Yes
This table appears to be comprehensive back to 2009.
Benzodiazepine
Normal
Positive for Benzodiazepine
No
N/A
Yes/No
Fixed
DOC
DOC
dbo_tblRISPDATA
1998
N/A
4
Yes
This table appears to be comprehensive back to 2009.
boot_camp_elig
Normal
Is the inmate eligible for Boot Camp?
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
both_a_d
Normal
Does the inmate have a history of alcohol and drug use?
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.  [ there is a category for IC and a category for RC ]
build
Normal
Physical build of the inmate
No
N/A
Text
Fixed (3 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
Cannabinoid
Normal
Positive for Cannabinoid
No
N/A
Yes/No
Fixed
DOC
DOC
dbo_tblRISPDATA
1998
N/A
4
Yes
This table appears to be comprehensive back to 2009.
Cannibimimetics
Normal
Positive for Cannibimimetics
No
N/A
Yes/No
Fixed
DOC
DOC
dbo_tblRISPDATA
1998
N/A
4
Yes
This table appears to be comprehensive back to 2009.
category_charge
Normal
Category of the Charge
No
N/A
Text
Fixed (1)
DOC
DOC
dbo_Mischg
1998
2000
5
Yes
Always equal to category_charge1.  This table appears to be comprehensive back to 1998.
Cathinones
Normal
Positive for Cathinones
No
N/A
Yes/No
Fixed
DOC
DOC
dbo_tblRISPDATA
1998
N/A
4
Yes
This table appears to be comprehensive back to 2009.
chrg_description
Normal
Charge Description
No
N/A
Text
Fixed (40)
DOC
DOC
dbo_Mischg
1998
2000
5
Yes
This table appears to be comprehensive back to 1998.
citizenship
Normal
Inmates country of citizenship.
No
N/A
Text
Fixed (3 char)
DOC
DOC
dbo_Perrec
1989
N/A
1
Yes
Table is archived in monthly snapshots going back to 2007.
city_of_birth
Normal
City in which the inmate was born
No
N/A
Text
Fixed (14 char)
DOC
DOC
dbo_Perrec
1989
N/A
2
Yes
Table is archived in monthly snapshots going back to 2007.
class_of_sent
Normal
Class of Sentence Code for Minimum Sentence
No
N/A
Text
Fixed (2 char)
DOC
DOC
dbo_tblSearchInmateInfo
2003
N/A
4
Yes
This code is tied to the Inmate Number.  Table is archived in monthly snapshots going back to 2007.  
cntinued_frm_doc_n
Normal
Prior Inmate Number when an inmate rolls over into a new sentence without being released
No
N/A
Text
Fixed (6 char)
DOC
DOC
dbo_Senrec
1989
N/A
4
Cocaine
Normal
Positive for Cocaine
No
N/A
Yes/No
Fixed
DOC
DOC
dbo_tblRISPDATA
1998
N/A
4
Yes
This table appears to be comprehensive back to 2009.
comment
Normal
Comments
No
N/A
Text
Fixed (1)
DOC
DOC
dbo_Miscon
1998
2000
4
Yes
This table appears to be comprehensive back to 1998.
commit_cnty
Normal
County from which the inmate was committed.  
No
N/A
Text
Fixed (3 char)
DOC
DOC
dbo_tblSearchInmateInfo
2003
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.  Every time an inmate is committed to an institution this field with remain with inmate number
commit_crdit_days
Normal
Commitment Credit Days
No
N/A
Text
Fixed (4 char)
DOC
DOC
dbo_Senrec
1989
N/A
4
commit_crdit_mths
Normal
Commitment Credit Months
No
N/A
Text
Fixed (3 char)
DOC
DOC
dbo_Senrec
1989
N/A
4
commit_crdit_yrs
Normal
Commitment Credit Years
No
N/A
Text
Fixed (3 char)
DOC
DOC
dbo_Senrec
1989
N/A
4
commit_date
Normal
Date on which the inmate was committed to DOC (YYYYMMDD)
No
N/A
Text
Fixed (8 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
commit_time
Normal
Time at which the inmate was committed to DOC (HHMM)
No
N/A
Text
Fixed (4 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
complexion
Normal
Inmates Color of complexion
No
N/A
Text
Fixed (3 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.
ComplOrFail_SW
Normal
Program Completion Status Code
No
N/A
Number
Fixed
DOC
DOC
dbo_tblEval / dbo_tblEvalHist
2000
2008
5
Yes
Field is null if inmate is currently enrolled.  Data appears to be fairly comprehensive starting in 2002.  
confinement
Normal
Pre-Hearing Confinement
No
N/A
Text
Fixed (1)
DOC
DOC
dbo_Miscon
1998
2000
3
Yes
This table appears to be comprehensive back to 1998.
confinement_date
Normal
Date of Pre-Hearing Confinement (YYYYMMDD)
No
N/A
Text
Fixed (8)
DOC
DOC
dbo_Miscon
1998
2000
4
Yes
This table appears to be comprehensive back to 1998.
confinement_time
Normal
Time of Pre-Hearing Confinement (HHMM)
No
N/A
Text
Fixed (4)
DOC
DOC
dbo_Miscon
1998
2000
4
Yes
This table appears to be comprehensive back to 1998.
control_number
Normal
Unique Inmate Identifier
No
N/A
Text
Fixed (6 char)
DOC
DOC
dbo_tblSearchInmateInfo
2003
N/A
4
Yes
Each inmate has only one Control Number.  It has a one to many relationship with Inmate Number.
country_of_birth
Normal
Country in which the inmate was born
No
N/A
Text
Fixed (3 char)
DOC
DOC
dbo_Perrec
1989
N/A
2
Yes
Table is archived in monthly snapshots going back to 2007.
counts
Normal
Number of Counts Charged With
No
N/A
Text
Fixed (3; Open-ended)
DOC
DOC
dbo_Mischg
1998
2000
5
Yes
This table appears to be comprehensive back to 1998.
ctgory_of_chrgs
Normal
Severity of Charge
No
N/A
Text
Fixed (1)
DOC
DOC
dbo_Miscon
1998
2000
5
YES
This table appears to be comprehensive back to 1998.  [ there are 5 different categories available ]
curr_inmate_num
Normal
Inmate Number
No
N/A
Text
Fixed (6 char)
DOC
DOC
dbo_Senrec
1989
N/A
4
inmates receive an inmate number upon returning to prison with a new offense.
CurrLoc_Cd
Normal
Inmate's current location
No
N/A
Text
Fixed (3 char)
DOC
DOC
dbo_tblSearchInmateInfo
2003
N/A
4
No
custody
Normal
Custody Level
No
N/A
Text
Fixed (3 char)
DOC
DOC
dbo_tblSearchInmateInfo
2003
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.  Includes Temporary Custody Levels 1 and 2.
da_ed
Normal
Initial Classification Drug/Alcohol Education Needed
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.  [ there is a category for IC and a category for RC ]
da_no_abuse
Normal
Initial Classification Drug/Alcohol No Abuse Indicator
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
4
Yes
Table is archived in monthly snapshots going back to 2007.   [ there is a category for IC and a category for RC ]
da_observa
Normal
Drug/Alcohol Problem was found through a D/A Tool
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.   [ there is a category for IC and a category for RC ]
da_ongoing
Normal
IC Drug/Alcohol Ongoing Treatment Needed
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.   [ there is a category for IC and a category for RC ]
da_other
Normal
Drug/Alcohol Problem was found through other means
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.   [ there is a category for IC and a category for RC ]
da_psi
Normal
Drug/Alcohol Problem was found through PSI
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.   [ there is a category for IC and a category for RC ]
da_score
Normal
IC Drug/Alcohol Score
No
N/A
Text
Fixed (2 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.   [ there is a category for IC and a category for RC ]
da_self
Normal
Drug/Alcohol Problem was self-reported
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.   [ there is a category for IC and a category for RC ]
da_self_help
Normal
IC Drug/Alcohol Self Help Needed
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.   [ there is a category for IC and a category for RC ]
data_followup
Normal
Misconduct data entry follow-up type
dbo_Miscon
YES
This table appears to be comprehensive back to 1998.
date_of_birth
Normal
Inmate's Date of Birth (YYYYMMDD)
No
N/A
Text
Fixed (8 char)
DOC
DOC
dbo_tblSearchInmateInfo
2003
N/A
4
Yes
date_reviewed
Normal
Date Reviewed (YYYYMMDD)
No
N/A
Text
Fixed (8)
DOC
DOC
dbo_Miscon
1998
2000
5
Yes
This table appears to be comprehensive back to 1998.
delete_date
Normal
Date of inmate's release (date YYYDDD)
No
N/A
Text
Fixed (7 char)
DOC
DOC
dbo_tblSearchInmateInfo
2003
N/A
4
No
Delete date field of 9999999 indicates the inmate is currently active.  Delete date can change each time an inmate is released.  
Discharge_Id
Normal
Discharge ID Code
No
N/A
Number
Fixed
DOC
DOC
dbo_tblEval / dbo_tblEvalHist
2000
2008
1
Yes
Data appears to be fairly comprehensive starting in 2002.
drug_related
Normal
Drug-Related Misconduct
No
N/A
Text
Fixed (1)
DOC
DOC
dbo_Miscon
1998
2000
1
Yes
This table appears to be comprehensive back to 1998.
drugs
Normal
Does the inmate have a history of drug use?
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.   [ there is a category for IC and a category for RC ]
Dtn_SW
Normal
Active Detainer Switch
No
N/A
Yes/No
DOC
DOC
dbo_tblSearchInmateInfo
No
0=Yes, 1=No
ed_cond
Normal
Educational Needs
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.   [ there is a category for IC and a category for RC ]
ed_ed_rec
Normal
Educational Needs found through education records
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.   [ there is a category for IC and a category for RC ]
ed_other
Normal
Educational Needs found through other means
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.   [ there is a category for IC and a category for RC ]
ed_psi
Normal
Educational Needs found through PSI
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.   [ there is a category for IC and a category for RC ]
ed_self_rpt
Normal
Educational Needs found through self-report
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.   [ there is a category for IC and a category for RC ]
effective_date
Normal
The Effective Date for the beginning of the minimum sentence
No
N/A
Text
Fixed (8 char)
DOC
DOC
dbo_Senrec
1989
N/A
4
emotion_cond
Normal
Indicates the emotional condition of the inmate
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.   [ there is a category for IC and a category for RC ]
employ_ind
Normal
Initial Classification Employment Indicator
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.  [ there is a category for IC and a category for RC ]
escape_days
Normal
Amount of escape time an inmate has to serve (days)
No
N/A
Text
Fixed (4 char)
DOC
DOC
dbo_Senrec
1989
N/A
4
escape_mths
Normal
Amount of escape time an inmate has to serve (months)
No
N/A
Text
Fixed (3 char)
DOC
DOC
dbo_Senrec
1989
N/A
4
escape_yrs
Normal
Amount of escape time an inmate has to serve (years)
No
N/A
Text
Fixed (3 char)
DOC
DOC
dbo_Senrec
1989
N/A
4
escpe_hist
Normal
Initial Classification Escape History 1
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
3
Yes
Table is archived in monthly snapshots going back to 2007.  [ there are 5 different categories available ]  
ethnic_id
Normal
ethnic identity
No
N/A
Text
Fixed (2)
DOC
DOC
Clssnp
4
YES
snapshots back to 2007
ethnic_identity
Normal
Ethnic group of the inmate
No
N/A
Text
Fixed (2 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
Eval_Des
Normal
Comments
No
N/A
Memo
Free; Open-ended
DOC
DOC
dbo_tblEval / dbo_tblEvalHist
2000
2008
4
Yes
Data appears to be fairly comprehensive starting in 2002.
event_date
Normal
Date when inamtes photo was taken (MMDDYYY)
No
N/A
Text
Fixed (8 char)
DOC
DOC
dbo_tblSearchInmateInfo
3
Yes
Table is archived in monthly snapshots going back to 2007.  
event_number
Normal
Event Number when inmates photo was taken
No
N/A
Text
Fixed (9 char)
DOC
DOC
dbo_tblSearchInmateInfo
3
Yes
Table is archived in monthly snapshots going back to 2007.  
Evltr_EmpNum
Normal
Evaluated by (Employee Number)
No
N/A
Text
Fixed (9)
DOC
DOC
dbo_tblEval / dbo_tblEvalHist
2000
2008
4
Yes
Data appears to be fairly comprehensive starting in 2002.
eyes
Normal
inmates eye color
No
N/A
Text
Fixed (3 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
Fab_ind
Normal
Correctional Plan required indicator (only applies to RST assessment)
dbo_tblInmTestScore / dbo_tblInmTestScoreHist
1
YES
Data appears to be fairly comprehensive beginning in 2002.
Fac_Cd
Normal
Facility Code where the Program was Taken
No
N/A
Text
Fixed (3)
DOC
DOC
dbo_tblEval / dbo_tblEvalHist
2000
2008
5
Yes
Data appears to be fairly comprehensive starting in 2002.
facbed_bed_num
Normal
Facility Bed Number where the inmate is housed
No
N/A
Text
Fixed (2 char)
DOC
DOC
dbo_tblSearchInmateInfo
2003
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.  
facbed_building
Normal
Facility Building where the inmate is housed
No
N/A
Text
Fixed (2 char)
DOC
DOC
dbo_tblSearchInmateInfo
2003
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.  
facbed_cell_dorm
Normal
Facility Cell or Dorm where the inmate is housed
No
N/A
Text
Fixed (3 char)
DOC
DOC
dbo_tblSearchInmateInfo
2003
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.  
facbed_level
Normal
Facility Level where the inmate is housed
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_tblSearchInmateInfo
2003
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.  
facbed_section
Normal
Facility Section where the inmate is housed
No
N/A
Text
Fixed (2 char)
DOC
DOC
dbo_tblSearchInmateInfo
2003
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.  
Fail_RsnCd
Normal
Code for the Reason an Inmate Failed the Program
No
N/A
Text
Fixed (3)
DOC
DOC
dbo_tblEval / dbo_tblEvalHist
2000
2008
5
Yes
Data appears to be fairly comprehensive starting in 2002.
fbi_num
Normal
FBI Number
No
N/A
Text
Fixed (12 char)
DOC
DOC
dbo_tblSearchInmateInfo
2003
N/A
4
No
Fentanyl
Normal
Positive for Fentanyl
No
N/A
Yes/No
Fixed
DOC
DOC
dbo_tblRISPDATA
1998
N/A
4
Yes
This table appears to be comprehensive back to 2009.
flag
Normal
Write/Rewrite/Delete flag
No
N/A
Text
Fixed (1)
DOC
DOC
dbo_Mischg
5
Yes
This flag is used by programs to determine the type of file operation to perform.  This table appears to be comprehensive back to 1998. [ there are 5 different categories available ]
form_141
Normal
AC or DC Status Code
No
N/A
Text
Fixed (3)
DOC
DOC
dbo_Miscon
1998
2000
5
Yes
This table appears to be comprehensive back to 1998.
Frst_Nm
Normal
First Name of the Inmate
No
N/A
Text
Fixed (15 char)
DOC
DOC
dbo_tblSearchInmateInfo
2003
N/A
4
Yes
Name is tied to inmate number.  All Aliases on inmates are maintained.  Table is archived in monthly snapshots going back to 2007.  
gbmi
Normal
Guilty But Mentally Ill
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Senrec
1989
N/A
4
grade_complete
Normal
Highest educational grade completed at the time of reception
No
N/A
Text
Fixed (2 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
Grp_Cd
Normal
Code assigned to the group
No
N/A
Text
Fixed (8)
DOC
DOC
dbo_tblEval / dbo_tblEvalHist
2000
2008
5
Yes
Data appears to be fairly comprehensive starting in 2002.
Guilty
Normal
Inmate was Guilty
No
N/A
Yes/No
Fixed
DOC
DOC
dbo_tblRISPDATA
1998
N/A
4
Yes
If guilty, an inmate is added to tracking to be tested once a month for 6 months.  This table appears to be comprehensive back to 2009.
hair
Normal
inmates hair color
No
N/A
Text
Fixed (3 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
hearing_after_date
Normal
Schedule Anytime After Date (YYYYMMDD)
No
N/A
Text
Fixed (8)
DOC
DOC
dbo_Miscon
1998
2000
2
Yes
This table appears to be comprehensive back to 1998.
hearing_after_time
Normal
Schedule Anytime After Time (HHMM)
No
N/A
Text
Fixed (4)
DOC
DOC
dbo_Miscon
1998
2000
2
Yes
This table appears to be comprehensive back to 1998.
hearings_held
Normal
Hearings Held
No
N/A
Text
Fixed (2)
DOC
DOC
dbo_Miscon
1998
2000
5
Yes
This table appears to be comprehensive back to 1998.
height_feet
Normal
Inmates height (feet)
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
height_inches
Normal
Inmates height (inches)
No
N/A
Text
Fixed (2 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
HousingUnit
Normal
Housing Unit of Inmate
No
N/A
Text
Fixed (50)
DOC
DOC
dbo_tblRISPDATA
1998
N/A
5
Yes
This table appears to be comprehensive back to 2009.
ic_data_entry_dt
Normal
Initial Classification Data Entry Date (YYYYMMDD)
No
N/A
Text
Fixed (8 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
ic_date
Normal
Initial Classification Date (YYYYMMDD)
No
N/A
Text
Fixed (8 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
ic_institut_adj
Normal
Initial Classification Institutional Adjustment
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.  
ic_medical_cond
Normal
Indicates the medical condition of the inmate
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.  [ there is an IC and RC category ]
ic_mrtl_stat_fr_cl
Normal
Marital Status
No
N/A
Text
Fixed (3 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.
ic_mths_to_release
Normal
Initial Classification Time expected to release in months
No
N/A
Text
Fixed (4 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.
ic_prev_off
Normal
Inmates previous offense is sexual in nature.
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.  
ic_prior_commits
Normal
Initial Classification Number of Prior Commitments
No
N/A
Text
Fixed (2 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
ic_prog_code_1
Normal
IC Program Code used to identify the inmate for security and housing purposes
No
N/A
Text
Fixed (1 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.    [ there are 3 different categories available for IC ]
ic_s_day
Normal
Initial Classification Date Day (DD)
No
N/A
Text
Fixed (2 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
ic_s_month
Normal
Initial Classification Date Month (MM)
No
N/A
Text
Fixed (2 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
ic_s_year
Normal
Initial Classification Date Year (YYYY)
No
N/A
Text
Fixed (4 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
ic_special_sent
Normal
Special Class of Sentence categories
No
N/A
Text
Fixed (2 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
only for Class of sent EX, EP and LF.  Table is archived in monthly snapshots going back to 2007.
indictment_num
Normal
Indictment Number
No
N/A
Text
Fixed (12 char)
DOC
DOC
dbo_Senrec
1989
N/A
3
Inm_EndDt
Normal
Program End Date (MM/DD/YYYY)
No
N/A
Date
Fixed
DOC
DOC
dbo_tblEval / dbo_tblEvalHist
2000
2008
5
Yes
Data appears to be fairly comprehensive starting in 2002.
Inm_RecmdDt
Normal
Date Recommended (MM/DD/YYYY HH:MM:SS AM/PM)
No
N/A
Date/Time
Fixed
DOC
DOC
dbo_tblRecmdPrgm / dbo_tblRecmdPrgmHist
2000
2008
5
No
Once an inmate completes a program, they are removed, so information specific to this table are lost.  Data appears to be fairly comprehensive starting in 2002.  
Inm_StrDt
Normal
Program Start Date (MM/DD/YYYY)
No
N/A
Date
Fixed
DOC
DOC
dbo_tblEval / dbo_tblEvalHist
2000
2008
5
Yes
Data appears to be fairly comprehensive starting in 2002.
Inm_UnSuitable_Flag
Normal
Unsuitable for Placement in the Program
No
N/A
Yes/No
Fixed
DOC
DOC
dbo_tblRecmdPrgm / dbo_tblRecmdPrgmHist
2000
2008
1
No
Once an inmate completes a program, they are removed, so information specific to this table are lost.  Data appears to be fairly comprehensive starting in 2002.  
inmate_cnt_num1
Normal
Unique Identifier for each Individual in the DOC System
No
N/A
Text
Fixed (6)
DOC
DOC
dbo_Mischg
1998
2000
5
Yes
Always equal to inmate_cnt_num2.  This table appears to be comprehensive back to 1998.
inmate_cnt_num2
Normal
Unique Identifier for each Individual in the DOC System
No
N/A
Text
Fixed (6)
DOC
DOC
dbo_Mischg
1998
2000
5
Yes
Always equal to inmate_cnt_num1.  This table appears to be comprehensive back to 1998.
inmate_notice_date
Normal
Date Inmate Served Noticed (YYYYMMDD)
No
N/A
Text
Fixed (8)
DOC
DOC
dbo_Miscon
1998
2000
2
Yes
This table appears to be comprehensive back to 1998.
inmate_notice_time
Normal
Time Inmate Served Noticed (HHMM)
No
N/A
Text
Fixed (4)
DOC
DOC
dbo_Miscon
1998
2000
2
Yes
This table appears to be comprehensive back to 1998.
inmate_num
Normal
Inmate Number
No
N/A
Text
Fixed (6 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
inmate_number
Normal
Inmate Number
No
N/A
Text
Fixed (6 char)
DOC
DOC
dbo_tblSearchInmateInfo
2003
N/A
4
Yes
inmates receive an inmate number upon returning to prison with a new offense.
Inmate_number
Normal
DOC Inmate ID
No
N/A
Text
Fixed (6)
DOC
DOC
dbo_tblInmTestScore / dbo_tblInmTestScoreHist
2002
N/A
5
Yes
Data appears to be fairly comprehensive beginning in 2002.
inmate_version
Normal
Is There an Inmate Version
No
N/A
Text
Fixed (1)
DOC
DOC
dbo_Miscon
1998
2000
2
Yes
This table appears to be comprehensive back to 1998.
InmateName
Normal
Inmate's Name
No
N/A
Text
Fixed (100)
DOC
DOC
dbo_tblRISPDATA
1998
N/A
5
Yes
This table appears to be comprehensive back to 2009.
InmateRefuses_Flag
Normal
Inmate Refused to Participate in the Program
No
N/A
Yes/No
Fixed
DOC
DOC
dbo_tblRecmdPrgm / dbo_tblRecmdPrgmHist
2000
2008
1
No
Once an inmate completes a program, they are removed, so information specific to this table are lost.  Data appears to be fairly comprehensive starting in 2002.  
inmte_plea_gilty
Normal
Number of Counts the Inmate Plead Guilty
No
N/A
Text
Fixed (3; Open-ended)
DOC
DOC
dbo_Mischg
1998
2000
5
Yes
This table appears to be comprehensive back to 1998.
inmte_plea_ngilty
Normal
Number of Counts the Inmate Plead Not Guilty
No
N/A
Text
Fixed (3; Open-ended)
DOC
DOC
dbo_Mischg
1998
2000
5
Yes
This table appears to be comprehensive back to 1998.
inmte_plea_nplea
Normal
Number of Counts the Inmate Did Not Enter a Plea
No
N/A
Text
Fixed (3; Open-ended)
DOC
DOC
dbo_Mischg
1998
2000
5
Yes
This table appears to be comprehensive back to 1998.
inst_hvl_desc
Normal
Facility Description Where the Misconduct Was Written
No
N/A
Text
Fixed (23)
DOC
DOC
dbo_Miscon
1998
2000
5
Yes
This table appears to be comprehensive back to 1998.
institution
Normal
Facility Code Where the Misconduct Was Written
No
N/A
Text
Fixed (3)
DOC
DOC
dbo_Miscon
1998
2000
5
Yes
This table appears to be comprehensive back to 1998.
intellgnt_rate
Normal
Inmate's IQ Score
No
N/A
Text
Fixed (3 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
judge
Normal
Name of the judge providing Sentence
No
N/A
Text
Fixed (14 char)
DOC
DOC
dbo_Senrec
1989
N/A
3
legal_address_1
Normal
Inmates Legal Mailing Address
No
N/A
Text
Fixed (20 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.
legal_address_2
Normal
Inmates Legal Mailing Address
No
N/A
Text
Fixed (20 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.
legal_city
Normal
City of Inmates Legal Mailing Address
No
N/A
Text
Fixed (14 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.
legal_state
Normal
State of Inmates Legal Mailing Address
No
N/A
Text
Fixed (2 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.
legal_zip_code
Normal
Zip Code of Inmates Legal Mailing Address
No
N/A
Text
Fixed (5 char)
DOC
DOC
dbo_Perrec
1989
N/A
3
Yes
Table is archived in monthly snapshots going back to 2007.
location_permanent
Normal
Permanent Location where the inmate is housed
No
N/A
Text
Fixed (3 char)
DOC
DOC
dbo_tblSearchInmateInfo
2003
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
location_temporary
Normal
Location where the inmate is temporarily housed
No
N/A
Text
Fixed (3 char)
DOC
DOC
dbo_tblSearchInmateInfo
2003
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.
lst_name
Normal
Last Name of staff doing Initial Classification
No
N/A
Text
Fixed (15 char)
DOC
DOC
dbo_Perrec
1989
N/A
4
Yes
Table is archived in monthly snapshots going back to 2007.  [ there is an IC and RC category ]
Select
Data Element
Definition
NIEM Compliant
NIEM Definition
Data Type
Field Type
Source Agency
User Agency
Element Location
Date Established
Date Revised
Data Quality
Historically Archived
Comments
Sensitive/Confidential data? (Yes/No)
1 - 150Next

DOC Value Codes
  
  
  
  
0Not Above Cut Off Level
  
-1Above Cut Off Level
Agency Contact
Use SHIFT+ENTER to open the menu (new window).
Bret Bucklen
DOC(717) 728-4055kbucklen@pa.gov