{"id":288,"date":"2017-08-21T22:55:33","date_gmt":"2017-08-21T22:55:33","guid":{"rendered":"http:\/\/k12transparency.isolon.org\/?page_id=288"},"modified":"2017-08-22T00:46:36","modified_gmt":"2017-08-22T00:46:36","slug":"database-definitions-claimed-exemptions","status":"publish","type":"page","link":"http:\/\/k12transparency.isolon.org\/?page_id=288","title":{"rendered":"MSDE K12 Salary-Related Database Field Descriptions"},"content":{"rendered":"

[et_pb_section bb_built=”1″ fullwidth=”on” specialty=”off” background_image=”http:\/\/k12transparency.isolon.org\/wp-content\/uploads\/2017\/04\/Piggbank-FrontFacing.jpg” transparent_background=”off” allow_player_pause=”off” inner_shadow=”off” parallax=”off” parallax_method=”off” make_fullwidth=”off” use_custom_width=”off” width_unit=”on” make_equal=”off” use_custom_gutter=”off” global_module=”121″][et_pb_fullwidth_header title=”K12 Public School Compensation Transparency ” background_layout=”light” text_orientation=”center” header_fullscreen=”on” header_scroll_down=”on” parallax=”off” parallax_method=”off” content_orientation=”center” image_orientation=”center” custom_button_one=”off” button_one_letter_spacing=”0″ button_one_use_icon=”default” button_one_icon_placement=”right” button_one_on_hover=”on” button_one_letter_spacing_hover=”0″ custom_button_two=”off” button_two_letter_spacing=”0″ button_two_use_icon=”default” button_two_icon_placement=”right” button_two_on_hover=”on” button_two_letter_spacing_hover=”0″ title_font_size=”52px” subhead_font_size=”34px” title_font=”|on|||” subhead_font=”|on|||”]<\/p>\n

A case study of the dismal politics and practice of
\nK12 compensation transparency<\/strong><\/h2>\n

[\/et_pb_fullwidth_header][\/et_pb_section][et_pb_section bb_built=”1″][et_pb_row][et_pb_column type=”4_4″][et_pb_text _builder_version=”3.0.69″ background_layout=”light” text_orientation=”left” border_style=”solid”]<\/p>\n

Data Fields MSDE Claims are Exempt from Public Information Act Disclosure<\/strong><\/h3>\n

The data fields are described in MSDE\u2019s\u00a0Staff Reporting System Specifications and Procedures Manual<\/a>, June 2013,<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\u00a0<\/strong><\/td>\n<\/td>\n<\/td>\n<\/tr>\n
Data Field<\/strong><\/td>\nProvided by MSDE?*<\/strong><\/td>\nPage Number**<\/strong><\/td>\n<\/tr>\n
Record Type<\/td>\nN<\/td>\n9<\/td>\n<\/tr>\n
LEA<\/td>\nY<\/td>\n9<\/td>\n<\/tr>\n
School Number<\/td>\nN<\/td>\n9<\/td>\n<\/tr>\n
Unique Statewide Identifier<\/td>\nN<\/td>\n9<\/td>\n<\/tr>\n
Local Employee Number<\/td>\nN<\/td>\n9<\/td>\n<\/tr>\n
Last Name<\/td>\nY<\/td>\n9<\/td>\n<\/tr>\n
First Name<\/td>\nY<\/td>\n9<\/td>\n<\/tr>\n
Middle Name<\/td>\nN<\/td>\n9<\/td>\n<\/tr>\n
Generational Suffix<\/td>\nN<\/td>\n9<\/td>\n<\/tr>\n
BC-Maiden Last Name<\/td>\nN<\/td>\n10<\/td>\n<\/tr>\n
Birth Date<\/td>\nN<\/td>\n10<\/td>\n<\/tr>\n
Gender<\/td>\nN<\/td>\n10<\/td>\n<\/tr>\n
Hispanic\/Latino Ethnicity<\/td>\nN<\/td>\n10<\/td>\n<\/tr>\n
Race Code<\/td>\nN<\/td>\n10<\/td>\n<\/tr>\n
Social Security Number<\/td>\nN<\/td>\n10<\/td>\n<\/tr>\n
Degree<\/td>\nY<\/td>\n10<\/td>\n<\/tr>\n
Years of Experience<\/td>\nY<\/td>\n11<\/td>\n<\/tr>\n
Tenure Status<\/td>\nN<\/td>\n11<\/td>\n<\/tr>\n
Employment Date<\/td>\nN<\/td>\n12<\/td>\n<\/tr>\n
Most Recent Date of LEA Separation<\/td>\nN<\/td>\n12<\/td>\n<\/tr>\n
Cause of Separation<\/td>\nN<\/td>\n12<\/td>\n<\/tr>\n
Contract Months<\/td>\nN<\/td>\n13<\/td>\n<\/tr>\n
Full-Time Equivalency<\/td>\nN<\/td>\n13<\/td>\n<\/tr>\n
Previous Year of Employment<\/td>\nN<\/td>\n13<\/td>\n<\/tr>\n
Where Employed<\/td>\nS?<\/td>\n13<\/td>\n<\/tr>\n
State Residence<\/td>\nN<\/td>\n14<\/td>\n<\/tr>\n
Type of Experience<\/td>\nS?<\/td>\n14<\/td>\n<\/tr>\n
Location<\/td>\nY<\/td>\n14<\/td>\n<\/tr>\n
Budget<\/td>\nN<\/td>\n15<\/td>\n<\/tr>\n
Position<\/td>\nY<\/td>\n16<\/td>\n<\/tr>\n
Salary<\/td>\nN<\/td>\n17<\/td>\n<\/tr>\n
Subject X (With X = 1 to 6, treated as separate fields)<\/td>\nN<\/td>\n17<\/td>\n<\/tr>\n
Targeted Assistance School (TAS) Staff FTE<\/td>\nN<\/td>\n18<\/td>\n<\/tr>\n
Title I Paraprofessional<\/td>\nN<\/td>\n18<\/td>\n<\/tr>\n
Title I Qualified Paraprofessional<\/td>\nN<\/td>\n19<\/td>\n<\/tr>\n
School Assign X (With X = 0 to 9, treated as separate fields)<\/td>\nN<\/td>\n***<\/td>\n<\/tr>\n
Location Assign X (With X = 0 to 9, treated as separate fields)<\/td>\nN<\/td>\n***<\/td>\n<\/tr>\n
Budget Assign X (With X = 0 to 9, treated as separate fields)<\/td>\nN<\/td>\n***<\/td>\n<\/tr>\n
Position Assign X (With X = 0 to 9, treated as separate fields)<\/td>\nN<\/td>\n***<\/td>\n<\/tr>\n
Salary Assign X (With X = 0 to 9, treated as separate fields)<\/td>\nN<\/td>\n***<\/td>\n<\/tr>\n
FTE Assign X (With X = 0 to 9, treated as separate fields)<\/td>\nN<\/td>\n***<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

* MSDE\u2019s claim that a given data field is disclosable under the Public Information Act: Y=Yes, N=No, S?=Selectively disclosable? The claim is an implicit claim based on data fields for which MSDE provided data. \u00a0Some data fields (marked S?) had highly selective disclosure. \u00a0The most obvious explanation for this type of\u00a0disclosure\u00a0is that MSDE only selectively enters data for certain fields.
\n\u201c** As described in Staff Reporting System Specifications and Procedures Manual\u20132013-2014, Maryland State Department of Education, June 2013.
\n*** Data fields not described in ** above but included in the employee record system.<\/p>\n

 <\/p>\n

[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

A case study of the dismal politics and practice of K12 compensation transparency

\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t\t\n\t\t\t<\/div> Data Fields MSDE Claims are Exempt from Public Information Act Disclosure The data fields are described in MSDE\u2019s\u00a0Staff Reporting System Specifications and Procedures Manual, June 2013, \u00a0 Data Field Provided by MSDE?* Page Number** Record Type N 9 LEA Y 9 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":100,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"class_list":["post-288","page","type-page","status-publish","hentry"],"yoast_head":"\nMSDE K12 Salary-Related Database Field Descriptions - Maryland's K12 Public School Compensation Transparency<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/k12transparency.isolon.org\/?page_id=288\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MSDE K12 Salary-Related Database Field Descriptions - Maryland's K12 Public School Compensation Transparency\" \/>\n<meta property=\"og:description\" content=\"A case study of the dismal politics and practice of K12 compensation transparency Data Fields MSDE Claims are Exempt from Public Information Act Disclosure The data fields are described in MSDE\u2019s\u00a0Staff Reporting System Specifications and Procedures Manual, June 2013, \u00a0 Data Field Provided by MSDE?* Page Number** Record Type N 9 LEA Y 9 […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/k12transparency.isolon.org\/?page_id=288\" \/>\n<meta property=\"og:site_name\" content=\"Maryland's K12 Public School Compensation Transparency\" \/>\n<meta property=\"article:modified_time\" content=\"2017-08-22T00:46:36+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/k12transparency.isolon.org\\\/?page_id=288\",\"url\":\"https:\\\/\\\/k12transparency.isolon.org\\\/?page_id=288\",\"name\":\"MSDE K12 Salary-Related Database Field Descriptions - Maryland's K12 Public School Compensation Transparency\",\"isPartOf\":{\"@id\":\"http:\\\/\\\/k12transparency.isolon.org\\\/#website\"},\"datePublished\":\"2017-08-21T22:55:33+00:00\",\"dateModified\":\"2017-08-22T00:46:36+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/k12transparency.isolon.org\\\/?page_id=288#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/k12transparency.isolon.org\\\/?page_id=288\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/k12transparency.isolon.org\\\/?page_id=288#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\\\/\\\/k12transparency.isolon.org\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Secrecy Case Studies\",\"item\":\"https:\\\/\\\/k12transparency.isolon.org\\\/?page_id=113\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"MSDE: Secret Raw Data and Statistical Methods Resulting in Misleading Statewide Compensation Data\",\"item\":\"https:\\\/\\\/k12transparency.isolon.org\\\/?page_id=100\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"MSDE K12 Salary-Related Database Field Descriptions\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\\\/\\\/k12transparency.isolon.org\\\/#website\",\"url\":\"http:\\\/\\\/k12transparency.isolon.org\\\/\",\"name\":\"Maryland's K12 Public School Compensation Transparency\",\"description\":\"A case study of the dismal politics and practice of K12 compensation transparency\",\"publisher\":{\"@id\":\"http:\\\/\\\/k12transparency.isolon.org\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\\\/\\\/k12transparency.isolon.org\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"http:\\\/\\\/k12transparency.isolon.org\\\/#organization\",\"name\":\"Maryland's K12 Public School Compensation Transparency\",\"url\":\"http:\\\/\\\/k12transparency.isolon.org\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\\\/\\\/k12transparency.isolon.org\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"http:\\\/\\\/k12transparency.isolon.org\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/Piggbank-FrontFacing-1024x783.jpg\",\"contentUrl\":\"http:\\\/\\\/k12transparency.isolon.org\\\/wp-content\\\/uploads\\\/2017\\\/04\\\/Piggbank-FrontFacing-1024x783.jpg\",\"width\":1024,\"height\":783,\"caption\":\"Maryland's K12 Public School Compensation Transparency\"},\"image\":{\"@id\":\"http:\\\/\\\/k12transparency.isolon.org\\\/#\\\/schema\\\/logo\\\/image\\\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MSDE K12 Salary-Related Database Field Descriptions - Maryland's K12 Public School Compensation Transparency","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/k12transparency.isolon.org\/?page_id=288","og_locale":"en_US","og_type":"article","og_title":"MSDE K12 Salary-Related Database Field Descriptions - Maryland's K12 Public School Compensation Transparency","og_description":"A case study of the dismal politics and practice of K12 compensation transparency Data Fields MSDE Claims are Exempt from Public Information Act Disclosure The data fields are described in MSDE\u2019s\u00a0Staff Reporting System Specifications and Procedures Manual, June 2013, \u00a0 Data Field Provided by MSDE?* Page Number** Record Type N 9 LEA Y 9 […]","og_url":"https:\/\/k12transparency.isolon.org\/?page_id=288","og_site_name":"Maryland's K12 Public School Compensation Transparency","article_modified_time":"2017-08-22T00:46:36+00:00","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/k12transparency.isolon.org\/?page_id=288","url":"https:\/\/k12transparency.isolon.org\/?page_id=288","name":"MSDE K12 Salary-Related Database Field Descriptions - Maryland's K12 Public School Compensation Transparency","isPartOf":{"@id":"http:\/\/k12transparency.isolon.org\/#website"},"datePublished":"2017-08-21T22:55:33+00:00","dateModified":"2017-08-22T00:46:36+00:00","breadcrumb":{"@id":"https:\/\/k12transparency.isolon.org\/?page_id=288#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/k12transparency.isolon.org\/?page_id=288"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/k12transparency.isolon.org\/?page_id=288#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/k12transparency.isolon.org\/"},{"@type":"ListItem","position":2,"name":"Secrecy Case Studies","item":"https:\/\/k12transparency.isolon.org\/?page_id=113"},{"@type":"ListItem","position":3,"name":"MSDE: Secret Raw Data and Statistical Methods Resulting in Misleading Statewide Compensation Data","item":"https:\/\/k12transparency.isolon.org\/?page_id=100"},{"@type":"ListItem","position":4,"name":"MSDE K12 Salary-Related Database Field Descriptions"}]},{"@type":"WebSite","@id":"http:\/\/k12transparency.isolon.org\/#website","url":"http:\/\/k12transparency.isolon.org\/","name":"Maryland's K12 Public School Compensation Transparency","description":"A case study of the dismal politics and practice of K12 compensation transparency","publisher":{"@id":"http:\/\/k12transparency.isolon.org\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/k12transparency.isolon.org\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"http:\/\/k12transparency.isolon.org\/#organization","name":"Maryland's K12 Public School Compensation Transparency","url":"http:\/\/k12transparency.isolon.org\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/k12transparency.isolon.org\/#\/schema\/logo\/image\/","url":"http:\/\/k12transparency.isolon.org\/wp-content\/uploads\/2017\/04\/Piggbank-FrontFacing-1024x783.jpg","contentUrl":"http:\/\/k12transparency.isolon.org\/wp-content\/uploads\/2017\/04\/Piggbank-FrontFacing-1024x783.jpg","width":1024,"height":783,"caption":"Maryland's K12 Public School Compensation Transparency"},"image":{"@id":"http:\/\/k12transparency.isolon.org\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"http:\/\/k12transparency.isolon.org\/index.php?rest_route=\/wp\/v2\/pages\/288","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/k12transparency.isolon.org\/index.php?rest_route=\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/k12transparency.isolon.org\/index.php?rest_route=\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/k12transparency.isolon.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/k12transparency.isolon.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=288"}],"version-history":[{"count":7,"href":"http:\/\/k12transparency.isolon.org\/index.php?rest_route=\/wp\/v2\/pages\/288\/revisions"}],"predecessor-version":[{"id":334,"href":"http:\/\/k12transparency.isolon.org\/index.php?rest_route=\/wp\/v2\/pages\/288\/revisions\/334"}],"up":[{"embeddable":true,"href":"http:\/\/k12transparency.isolon.org\/index.php?rest_route=\/wp\/v2\/pages\/100"}],"wp:attachment":[{"href":"http:\/\/k12transparency.isolon.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=288"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}