From the course: Data Curation Foundations

Unlock the full course today

Join today to access over 22,500 courses taught by industry experts or purchase this course individually.

Picklists in a data dictionary

Picklists in a data dictionary

From the course: Data Curation Foundations

Start my 1-month free trial

Picklists in a data dictionary

“

- Now that we've looked at the main tables in the data dictionary, it's time to turn our attention to documenting picklists. In the last video, we looked at documentation, for our two main tables, hospital and discharge. Those are entities. But in our study, we care about the attributes, like how much the discharge cost and what type of hospital we are talking about. These attributes are categorical variables. Remember how we have to document not only the meaning of the variable itself, but also the meaning of each level? That's what I mean by documenting a picklist. Let's go back to our HCUP Data Dictionary and see what I mean. This Excel spreadsheet is in your exercise files for this video. Remember, it's called HCUP Data Dictionary. And in the last video, we looked at the documentation for our two main tables, hospital and discharge. Actually, let's go look at discharge for a moment. See, we have the same…

Contents