Pennsylvania Commission on Sentencing (PCS)
SGS Web Data Codebook: 2001 – 2010
NOTES:
- SGS Web is the sentencing guideline application used by the counties to calculate guideline recommendations and report sentences to the Commission.
- Data sets are available in either General Release or Contracted Release versions. See the Commission’s Release of Information Policy (http://pcs.la.psu.edu ) for more details.
- The following variables are not included in the General Release version: SSN, Narrative, Reason_Text and are designated with an asterisk (*).
- Judicial Proceeding is abbreviated as JP. This refers to all offenses for an offender sentenced on the same date, by the same judge, regardless of the date(s) the offenses were committed.
- The data are based on information reported on paper or electronic Guideline Sentence Forms to the Commission on Sentencing; therefore the Commission warrants neither the accuracy nor the completeness of the data provided.
Variable Name / Type / Source / Level / Description / Values / Collection began (date or year) / Collection ended (date or year) /BC_ELIG / Char / SGS Web / Offense / Statutory eligibility of offense for boot camp
BC_ELIG takes into account age, offense, and enhancements / M=Maybe,
Y=Yes,
N=No
BOOTCAMPAUTHORIZED / Char / SGS Web / JP / Judge authorized offender for boot camp / Y=Yes,
N=No
CASE_LASTUPD / NumChar / SGS Web / JP / Date and time case status becomes final
(mm/dd/yyyy hh:mm:ss)
CID / Char / SGS Web / JP / Commission ID number / W=Sequential number automatically created in SGS Web,
non-W=Entered from paper guideline form sent to the Commission
CIP / Num / PCS / Offense / County Intermediate Punishment (CIP) is the most serious sanction for this offense / 1 = Yes,
. = No
CONFORM / Char / PCS / Offense / Conformity to sentencing guidelines
CONFORMITY recoded into six categories / Above,
Aggravated,
Below,
Mitigated,
Procedural,
Standard
“ “ = missing
CONFORMITY / Char / SGS Web / Offense / Conformity to sentencing guidelines / Aggravated,
Aggravated/Mandatory,
Mitigated,
Mitigated/Mandatory,
Outside Above,
Outside Above/Mandatory,
Outside Below,
Outside Below/Mandatory,
Procedural Departure-Clinical Recommendation,
Standard,
Standard-Clinical Recommendation,
Standard/Mandatory,
Standard/State IP,
“ “ = missing
COUNTY / Char / SGS Web / JP / Pennsylvania county where offender was sentenced
CSHOURSLOWER / Num / SGS Web / Offense / Community service hours (lower end of range) / . = missing / 12/3/2008
CSHOURSUPPER / Num / SGS Web / Offense / Community service hours (upper end of range) / . = missing / 12/3/2008
CTY_REENTRY / Char / SGS Web / JP / Offender eligible for county reentry / Y=Yes,
N=No,
NA=Not applicable / 12/3/2008
CTY_REENTRY_TYPE / Char / SGS Web / JP / Type of county reentry program
On 4/2010 variable changes to specify other for REENTRY_TYPE_LST / “ “ = missing / 12/3/2008
CTY_REENTRY_WHENELIG / Char / SGS Web / JP / When offender is eligible for county reentry
On 4/2010 variable changes to specify other for REENTRY_WHENELIG_LST / “ “ = missing / 12/3/2008
DISPOSITION / Char / SGS Web / Offense / Disposition / Bench Trial,
Jury Trial,
Neg. (Negotiated) Guilty Plea,
Nolo Contendere,
Non-Neg. (Non-Negotiated) Guilty Plea,
Other,
“ “ = missing
DOB / Num / SGS Web / JP / Offender date of birth
(mm/dd/yyyy) / . = missing
DOB2 / Num / PCS / JP / Offender date of birth
From a source other than this judicial proceeding
(mm/dd/yyyy) / . = missing
DOCKET / Char / SGS Web / JP / Docket number
Official identifier assigned by the courts. DOCKET number is assigned when the judicial proceeding is first initiated, but individual offenses within the judicial proceeding may have different OFN_DOCKET numbers. / “ “ = missing
DOF / Num / SGS Web / Offense / Date of offense
(mm/dd/yyyy) / . = missing
DOFAGE / Num / PCS / Offense / Offender’s age at date of offense (years)
Calculated as (DOF minus DOB) divided by 365.25 / . = missing
DOF_RANGE_END / Num / SGS Web / Offense / Latest offense date when offense committed over a range of dates
(mm/dd/yyyy) / . = missing
DOF_RANGE_START / Num / SGS Web / Offense / Earliest offense date when offense committed over a range of dates
(mm/dd/yyyy) / . = missing
DOS / Num / SGS Web / Offense / Date of sentence
(mm/dd/yyyy)
DOSAGE / Num / PCS / Offense / Offender's age at date of sentence (years)
Calculated as (DOS minus DOB) divided by 365.25 / . = missing
DRUG / Char / PCS / Offense / Type of drug / Cocaine, Meth., PCP,
Designer Drugs,
Ectasy,
Look-Alike Drugs
Marijuana,
Meth, Manuf w/ Child,
Narcotics,
Other Drug Offenses,
Oxycontin,
Prescription Pills,
Steroids,
Unspecified Controlled Substance
“ “ = missing
DRUG_AMT / Num / SGS Web / Offense / Drug amount
Accompanied by DRUG_UNIT / . = missing
DRUG_QTY / Char / PCS / Offense / PCS categories of drug quantity based on type of drug / “ “ = missing
DRUG_UNIT / Char / SGS Web / Offense / Unit of measurement for drugs
Accompanies DRUG_AMT / Does Not Apply,
grams,
lbs (pounds),
pills,
plants,
“ “ = missing
DUILABEL / Char / PCS / Offense / DUI offense number and tier / “ “ = missing
DUI_NUM / Num / SGS Web / Offense / Number of prior DUI’s
Only relevant for 75-3731 / . = missing
ENHANCEMENT_SCHOOL / Char / SGS Web / Offense / School enhancement / Y=Yes,
. = missing or no enhancement
ENHANCEMENT_WEAPONS / Char / SGS Web / Offense / Weapons enhancement -- Type of Weapon / Gun/Other,
Hammer/Blunt Instrument, HandGun/Pistol/Revolver,
Knife/Sharp Instrument,
Long Gun/Rifle/Shotgun,
Other Weapon,
Unknown Weapon,
“ “ = missing or no enhancement
ENHANCEMENT_YOUTH / Char / SGS Web / Offense / Youth enhancement / Y=Yes,
“ “ = missing or no enhancement
ETHNICINTIMIDATION / Char / SGS Web / Offense / Ethnic intimidation
JPO_ETHNIC renamed ETHNICINTIMIDATION for 2001-2007 / Y=Yes,
“ “ = missing or no ethnic intimidation
FINE / Num / PCS / Offense / Fine is the most serious sanction for this offense / 1= Yes,
. = No
FINESLOWER / Num / SGS Web / Offense / Lower range of fines
(dollars) / . = missing
Negative value = / 12/3/2008
FINESUPPER / Num / SGS Web / Offense / Upper range of fines
(dollars) / . = missing
Negative value = / 12/3/2008
GLEPOCH / Char / PCS / Offense / Edition of sentencing guidelines / 5th Ed,
6th Ed,
6th Ed, Revised
GRADE / Num / PCS / Offense / Offense statutory grade / 1 = Unclassified misdemeanor,
2 = Misdemeanor 3,
3 = Misdemeanor 2,
4 = Misdemeanor 1,
5 = Unclassified felony,
6 = Felony 3,
7 = Felony 2,
8 = Felony 1,
9 = Homicide 2,
10 = Homicide 1,
GUIDELINE_RANGE / Char / SGS Web / Offense / Sentencing guideline range
[mitigated sentence-(lower guideline-upper guideline)-aggravated sentence] / ~ = aggravated/mitigated range not applicable,
RS = restorative sanction,
RIP = restrictive intermediate punishment,
GUILTY_NO_PENALTY / Char / SGS Web / Offense / Guilt with no further penalty / Yes,
“ “ = No
INCHOATE / Char / SGS Web / Offense / Inchoate offense
Inchoate murder (18-2502) is both complete and incomplete / Complete,
Incomplete
INCMAX / Num / PCS / Offense / Total maximum incarceration time (months)
Sum of INC_MAX_DAYS (converted to months) and INC_MAX_MONTHS / . = missing or life/death sentence
INCMIN / Num / PCS / Offense / Total minimum incarceration time (months)
Sum of INC_MIN_DAYS (converted to months) and INC_MIN_MONTHS / . = missing or life/death sentence
INC_END / Num / SGS Web / Offense / Date incarceration sentence ends
(mm/dd/yyyy) / 12/31/9999 = life or death sentence or sentence concurrent or consecutive to life or death sentence,
. = missing or no incarceration
INC_MAX_DAYS / Num / SGS Web / Offense / Maximum length of incarceration (days)
SGS users can enter sentence in days, months or a combination of days and months. See INCMAX for total. / . = missing
INC_MAX_MONTHS / Num / SGS Web / Offense / Maximum length of incarceration (months)
SGS users can enter sentence in days, months or a combination of days and months. See INCMAX for total. / . = missing or life/death sentence
INC_MIN_DAYS / Num / SGS Web / Offense / Minimum length of incarceration (days)
SGS users can enter sentence in days, months or a combination of days and months. See INCMIN for total. / . = missing
INC_MIN_MONTHS / Num / SGS Web / Offense / Minimum length of incarceration (months)
SGS users can enter sentence in days, months or a combination of days and months. See INCMIN for total. / . = missing or life/death sentence
INC_RELATEDCOUNT / Char / SGS Web / Offense / Count number that incarceration is related to / “ “ = missing
INC_RELATEDOTN / Char / SGS Web / Offense / Offense tracking number (OTN) that incarceration is related to / “ “ = missing
INC_RELATEDTO / Char / SGS Web / Offense / ID number that incarceration is related to / “ “ = missing
INC_RELATIONSHIP / Char / SGS Web / Offense / Relationship to other sentence / Concurrent,
Consecutive,
“ “ = missing
INC_SANCTION_EXISTS / Char / SGS Web / Offense / Incarceration sanction exists for this offense / Y=Yes,
N=No,
“ “ = missing
INC_SANCTION_ID / Char / SGS Web / Offense / Incarceration sanction ID
ID for concurrent/consecutive / “ “ = missing
INC_START / Num / SGS Web / Offense / Date incarceration sentence begins
(mm/dd/yyyy) / 12/31/9999 = life or death sentence or sentence concurrent or consecutive to life or death sentence,
. = missing or no incarceration
INC_TYPE / Char / SGS Web / Offense / Type of Incarceration / State Facility,
County Facility,
Unknown,
“ “ = missing
INC_WRA / Char / SGS Web / Offense / Work release authorized / Y=Yes,
N=No,
“ “ = missing
IP_CONSISTENT / Char / SGS Web / Offense / Intermediate Punishment (IP) consistent with clinical recommendation / Y=Yes,
N=No,
“ “ = missing
IP_CSHOURS / Num / SGS Web / Offense / Intermediate punishment (IP) community service hours (hrs) / . = missing / 12/3/2008
IP_ELIG / Char / SGS Web / Offense / Statutory eligibility of offense for intermediate punishment
Does not take mandatories into consideration / Y=Yes,
N=No
IP_END / Num / SGS Web / Offense / Date intermediate punishment sentence ends
(mm/dd/yyyy) / . = missing
IP_RELATEDCOUNT / Char / SGS Web / Offense / Count number that intermediate punishment is related to / “ “ = missing
IP_RELATEDOTN / Char / SGS Web / Offense / Offense tracking number (OTN) that intermediate punishment is related to / “ “ = missing
IP_RELATEDTO / Char / SGS Web / Offense / ID number that intermediate punishment is related to / “ “ = missing
IP_RELATIONSHIP / Char / SGS Web / Offense / CIP relationship to other sentence / Concurrent,
Consecutive,
“ “ = missing
IP_SANCTION_EXISTS / Char / SGS Web / Offense / Intermediate punishment sanction exists for this offense
Includes both state intermediate punishment and county intermediate punishment / Y=Yes,
N=No,
“ “ = missing
IP_SANCTION_ID / Char / SGS Web / Offense / Intermediate punishment sanction ID
ID for concurrent/consecutive sentence / “ “ = missing
IP_START / Num / SGS Web / Offense / Date intermediate punishment sentence begins
(mm/dd/yyyy) / . = missing
JAIL / Num / PCS / Offense / County jail is the most serious sanction for this offense / 1 = Yes,
. = No
JMAX / Num / PCS / Offense / Total maximum jail incarceration time (months)
Sum of INC_MAX_DAYS (converted to months) and INC_MAX_MONTHS when county jail is the most serious sanction for offense / . = missing
997 = Life
998 = Death
JMIN / Num / PCS / Offense / Total minimum jail incarceration time (months)
Sum of INC_MIN_DAYS (converted to months) and INC_MIN_MONTHS when county jail is the most serious sanction for offense / . = missing
997 = Life
998 = Death
JPO_DRGSUBSEQ / Char / SGS Web / Offense / Judicial proceeding offense is second or subsequent drug offense / 780115=second or subsequent drug offense,
“ “ = first drug offense or missing
JPO_ID / Char / SGS Web / Offense / Judicial proceeding offense ID
JPR_ID / Char / SGS Web / JP / Judicial proceeding ID
A judicial proceeding consists of all offenses committed by the same offender sentenced on the same date by the same judge. JPR_ID is automatically assigned to a judicial proceeding. There is a 1:1 relationship between OFF_ID and JPR_ID.
JPR_LASTUPDATE / Char / SGS Web / JP / Date and time SGS Web entry last updated by SGS Web user
(mm/dd/yyyy hh:mm:ss)
JPS_ASSESSMENT / Char / SGS Web / JP / A preliminary assessment and/or court reporting network (CRN) evaluation was completed [75-3816] / Y=Yes,
N=No,
“ “ = missing
JPS_DA_EVAL / Char / SGS Web / JP / A drug and alcohol evaluation and/or full assessment [75-3814] was completed / Y=Yes,
N=No
(NOTE: ‘No’ is the default; no distinction between ‘No’ and missing)
JPS_DRUG_DEPENDENT / Char / SGS Web / JP / The offender is drug or alcohol dependent and in need of treatment / Y=Yes,
N=No