« Upcoming Add/Drop fees change | Main | f_get_ethnicity and f_get_race »
July 2, 2010
Research table script updated with new race code
I updated the research table script so that it pulls from the new race tables. The query is a lot more complex because the new race table allows multiple races to be saved per person. It also checks to see if the hispanic/latino flag is set on spbpers_ethn_cde and returns a "H" race code if found. For people that have multiple races, it returns an "X" code which identifies them as more than one race. For unknown or null race codes, it will return a "D" code for "declined to respond".
Posted by soukupm at July 2, 2010 3:44 PM
Comments
Post a comment
Thanks for signing in, . Now you can comment. (sign out)
(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)