PatientAddress
| Field | Type | Length | Allow Null | Natural Key | Description | |
|---|---|---|---|---|---|---|
| 1 | Record Type ID | String |
Indicates the record type. For this record it will always be “PatientAddress”. |
|||
| 2 | Patient ID | REF |
Surrogate key to a patientCorresponds to a (Patient line in the same file set)’s ID value |
|||
| 3 | Patient Identifier | String | 128 |
Part of Natural Key Identifier. Typically, the source’s or practice’s key Identifier for a patient *Natural Key for existing patient |
||
| 4 | Patient Record Authority ID | REF |
Surrogate Key to a Record Authority. |
|||
| 5 | Street1 | String | 100 | |||
| 6 | Street2 | String | 100 | |||
| 7 | Street3 | String | 100 | |||
| 8 | City | String | 50 | |||
| 9 | State | String | 20 |
2 Characters |
||
| 10 | Postal Code | String | 20 | |||
| 11 | County | String | 50 | |||
| 12 | Country | String | 50 | |||
| 13 | Active From Date | Date | ||||
| 14 | Active To Date | Date | ||||
| 15 | Address Type | Term |
code|name|namespace|family|ns desc |
|||
| 16 | Inserted Audit Data | Audit |
Audit data for when the record was inserted/created |
|||
| 17 | Last Modified Audit Data | Audit |
Audit data for when the record was last modified |
|||
| 18 | ID | ID |
Surrogate key to an address |