Sample of Data Element Description:
| Client Stores information about a client that does not vary with each case. Attribute | Type | Note | Old Table (Attribute) | Update Tab
| id | integer | unique key for the client | registration (id) | Reg
| ssn | char(11) | optional; not used as a key
| registration (ssn) | Reg
| last_name | varchar(20) | | registration (lastname) | Reg
| first_name | varchar(20) | | registration (firstname) | Reg
| middle_name | varchar(20) | | | Reg
| sort_last_name | varchar(20) | | |
| suffix | varchar(7) | | | Reg
| soundex_key | char(17) | for name matching | |
| dob | date | | registration (dob) | Reg
| age | varchar(2) | calculated age as number of complete years
| registration (age) |
| medicaid_id | varchar(20) | Medicaid ID
| | Reg
| culture_race_code | integer | checked via code table culture_race
| registration (culture/race) | Reg
| culture_race_other_code | integer | Secondary culture/race; checked via code table culture_race | registration | (culture/race other) Reg
| language_code | char(1) | checked via code table language | | Reg
| sex | char(1) | checked via code table sex_code | | Reg
| added_by | varchar(8) | application user, for audit trail
| |
| date_added | date | for audit trail
| |
| last_updated_by | varchar(8) | user_ID from Users; for audit trail
| |
| last_update_date | date | for audit trail
| |
| | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|