MS Corrections data dictionaries
| Tracking # |
R000377-030524 |
| Submitted | March 5, 2024 |
| Due | March 14, 2024 |
| Est. Completion | None |
MuckRock users can file, duplicate, track, and share public records requests like this one. Learn more.
Communications
From: Robert Stewart, Ph.D.
To Whom It May Concern:
Pursuant to the Mississippi Public Records Act, I hereby request the following records:
1) All data dictionaries and schemas used for or associated with databases (or other data repositories) used by the Mississippi Department of Corrections' offender management system.
2) Any documents sufficient to explain, detail, or describe the contents of tables and fields in any database (including which are considered exempt from disclosure or otherwise restricted, if applicable) used by the Mississippi Department of Corrections' offender management system.
“Data dictionary” refers to any set of information describing the contents of a database, including details about tables, columns, data types, and relationships among tables.
"Schema" refers to any set of information describing a database's overall structure and organization.
"Offender management system" refers to the database or software system that MDOC uses to manage information on all aspects of an offender’s incarcerations from intake to release.
The requested documents will be used for academic research. This request is not being made for commercial purposes.
In the event that there are fees, I would be grateful if you would inform me of the total charges in advance of fulfilling my request. I would prefer the request filled electronically, by e-mail attachment if available or CD-ROM if not.
Thank you in advance for your anticipated cooperation in this matter. I look forward to receiving your response to this request within 7 business days, as the statute requires.
Sincerely,
Robert Stewart, Ph.D.
From: Department of Corrections
Dear Robert Stewart:
This email is written notice that the Mississippi Department of Corrections (“MDOC”) has received your public records request. Pursuant to the provisions of Miss. Code Ann. § 25-61-5(1)(b), MDOC is providing notice that a response is anticipated in fourteen (14) days due to a significantly heavy workload. The reference number R000377-030524 for tracking purposes: Records Requested: To Whom It May Concern:
Pursuant to the Mississippi Public Records Act, I hereby request the following records:
1) All data dictionaries and schemas used for or associated with databases (or other data repositories) used by the Mississippi Department of Corrections' offender management system.
2) Any documents sufficient to explain, detail, or describe the contents of tables and fields in any database (including which are considered exempt from disclosure or otherwise restricted, if applicable) used by the Mississippi Department of Corrections' offender management system.
“Data dictionary” refers to any set of information describing the contents of a database, including details about tables, columns, data types, and relationships among tables.
"Schema" refers to any set of information describing a database's overall structure and organization.
"Offender management system" refers to the database or software system that MDOC uses to manage information on all aspects of an offender’s incarcerations from intake to release.
The requested documents will be used for academic research. This request is not being made for commercial purposes.
In the event that there are fees, I would be grateful if you would inform me of the total charges in advance of fulfilling my request. I would prefer the request filled electronically, by e-mail attachment if available or CD-ROM if not.
Thank you in advance for your anticipated cooperation in this matter. I look forward to receiving your response to this request within 7 business days, as the statute requires.
Sincerely,
Robert Stewart, Ph.D.
Upload documents directly: https://www.muckrock.com/
From: Department of Corrections
--- Please respond above this line ---
RE: PUBLIC RECORDS REQUEST of March 05, 2024., Reference # R000377-030524.
Dear Robert Stewart,
The Mississippi Department of Corrections received a public information request from you on March 05, 2024. Your request mentioned: "To Whom It May Concern:
Pursuant to the Mississippi Public Records Act, I hereby request the following records:
1) All data dictionaries and schemas used for or associated with databases (or other data repositories) used by the Mississippi Department of Corrections' offender management system.
2) Any documents sufficient to explain, detail, or describe the contents of tables and fields in any database (including which are considered exempt from disclosure or otherwise restricted, if applicable) used by the Mississippi Department of Corrections' offender management system.
“Data dictionary” refers to any set of information describing the contents of a database, including details about tables, columns, data types, and relationships among tables.
"Schema" refers to any set of information describing a database's overall structure and organization.
"Offender management system" refers to the database or software system that MDOC uses to manage information on all aspects of an offender’s incarcerations from intake to release.
The requested documents will be used for academic research. This request is not being made for commercial purposes.
In the event that there are fees, I would be grateful if you would inform me of the total charges in advance of fulfilling my request. I would prefer the request filled electronically, by e-mail attachment if available or CD-ROM if not.
Thank you in advance for your anticipated cooperation in this matter. I look forward to receiving your response to this request within 7 business days, as the statute requires.
Sincerely,
Robert Stewart, Ph.D.
Upload documents directly: https://www.muckrock.com/ *** The information requested is the intellectual property of the vendor, Motorola contact Motorola to request their system design and database definitions, etc.
If you have any questions or need additional information, please let me know.
Sincerely,
Public Records
From: Robert Stewart, Ph.D.
Hello,
I am following up regarding my public records request (Reference # R000377-030524) to provide clarification. I apologize if my original request was unclear. I am not requesting any intellectual property of Motorola, nor am I requesting any proprietary information that would fit under § 25-61-11.2.
To rephrase my request, I am requesting the record layouts of any databases used by the Mississippi DOC to store and maintain records of people under correctional control, including the names and descriptions of each field of data collected, and also which fields are considered exempt from disclosure or otherwise restricted, if applicable. The purpose of this request is to identify relevant fields for a forthcoming data request to minimize the burden on your department by ensuring my future request is as precise and streamlined as possible.
Best,
Robert Stewart, Ph.D.
From: Robert Stewart, Ph.D.
To Whom It May Concern:
I am following up on my Mississippi Public Records Act request (Reference # R000377-030524) and my reply dated March 10, 2024 to your response stating the requested data are "intellectual property of the vendor, Motorola." As I stated in my reply, I am not requesting any intellectual property of Motorola, nor am I requesting any proprietary information that would fit under § 25-61-11.2. Rather, I am requesting record layouts of any databases used by the Mississippi DOC to store and maintain records of people under correctional control.
Please let me know when I can expect to receive a response.
Thanks for your help, and let me know if further clarification is needed.
Files
There are no files associated with this request.