PATIENT_OTH_STADDR

Description: |
Contains the Other street address from the patient's Other Address, which can be used by pharmacy to determine where to mail prescriptions. This address is in addition to the patient's home address, the patient's temporary address, and the patient's confidential address. The items in this table are related to the other address items in PATIENT_2 table. Another related table would be the PATIENT_OTH_ADDCOM table which contains the comments that relate to a patient's Other Address.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ID | VARCHAR | No |
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
2 | LINE | INTEGER | No |
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 | OTH_STREET_ADDR | VARCHAR | No |
Contains the street address from the patient's prescription Address, which can be used by pharmacy to determine where to mail prescriptions.