Patient Attributes
The Patient Attributes module contains additional demographic data that doesn't fit into the Patients File.
Note: A patient can have multiple values for the same attribute, most commonly for Race and Sexual Orientation.
Target Date
For a given target date, find all the cases that started on that date. Then find all patients for those cases. For those patients, return the data for the following demographics
data: Legal Sex, Sex Assigned at Birth, Sexual Orientation, Ethnic Group, Race, Preferred Language, Preferred Language for Care, and Gender Identity.
File Columns
Flat File Column Nullable? Data Type Purpose
Patient_ID No
The patient identifier, must be the the same identifier given in the "Patients" file.
Attribute_ID
No
The identifier of the category for the patient attribute variable.
Attribute_Name
Yes
The name of the category for the patient attribute variable. (e.g. Ethnic Group, Legal Sex, Preferred
Language, and Race).
Attribute_Value_ID No
The identifier of the patient attribute value variable.
Attribute_Value_Name
No
The name of the patient attribute value. (e.g. Non-Hispanic, Female, English, White or Caucasian).
Attribute_Value_Rank
No
The rank of the primary patient attribute value.
Observation_Time
No
DateTime
The time the observation was made.
Entered_Time
No
DateTime
The time the observation was documented.
Additional Column Details
Attribute_ID
If there is no Attribute ID identifier, use the same value as the Attribute_Name.
Attribute_Value_ID
If there is no Attribute Value ID identifier, use the same as the Attribute_Value_Name.
Observation Time
The date stored in this column must match the target date.
Entered Time
The date stored in this column must match the target date.
Example Data
Single Date Format
Z1234567, 62342, Ethnic Group, 1, Non-Hispanic, NULL, NULL, NULL
Z1234567, 32451, Legal Sex, 1, Female, NULL, NULL, NULL
Z1234567, 53421, Preferred Language, 22, English, NULL, NULL, NULL
Z1234567, 43213, Race, 1, White or Caucasion, 1, NULL, NULL
Z1234567, 42312, Ethnic Group, 1, Non-Hispanic, NULL, NULL, NULL
Multi Date Format
07/26/2024, Z1234567, 62342, Ethnic Group, 1, Non-Hispanic, NULL, NULL, NULL
07/26/2024, Z1234567, 32451, Legal Sex, 1, Female, NULL, NULL, NULL
07/26/2024, Z1234567, 53421, Preferred Language, 22, English. NULL, NULL, NULL
07/26/2024, Z1234567, 43213, Race, 1, White or Caucasion, 1, NULL, NULL
07/26/2024, Z1234567, 54678, Ethnic Group, 1, Non-Hispanic, NULL, NULL, NULL
Development Checklist
Global Requirements
o All columns are represented in file
o Columns are in correct order
o Required columns are never blank
o Column data types are obeyed
o File does not contain a header row
o Delimiter characters have been escaped
o No additional delimiters are used (e.g. quotes around each field)
o Target date follows module definition
o Extract always fully pulls each date, target date is never incomplete
o If using the multi date format, target date column has been added to the beginning of each row, formatted as MM/dd/yyyy (include leading zeroes)
o No whitespace in NULL fields
o File name matches the correct template
Single date: MODULE_SPECVERSION_SOURCESYSTEM_TARGETDATE_PULLDATE.csv
Multi date: MODULE_SPECVERSION_SOURCESYSTEM_FILELABEL_PULLDATE.csv
