ATB_EDIT_ADDR_OVERRIDES
Description:
ATB Edit segment address overrides table.

Primary Key
Column Name Ordinal Position
AUTH_BUNDLE_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 AUTH_BUNDLE_ID NUMERIC No
The unique identifier (.1 item) for the auth bundle record.
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 OVR_ADDR_S_ENTITY_AUTH_ROLE_C_NAME VARCHAR No
Edit Segment - Override Address Table - Scope Role
May contain organization-specific values: No
Category Entries:
Requester
Ordering Provider
Primary Care Provider
Referring Provider
Service Provider
Service Location
Service Facility
Attending Provider
Admitting Provider
Operating Provider
Service-Level Service Provider
Referring Location
4 OVR_ADDR_S_PROV_ID_PROV_NAME VARCHAR No
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
5 OVR_ADDR_S_FACILITY_ID_LOC_NAME VARCHAR No
The name of the revenue location.
6 OVR_ADDR_S_DEPARTMENT_ID_EXTERNAL_NAME VARCHAR No
The external name of the department record. This is often used in patient correspondence such as reminder letters.
7 OVR_ADDR_S_VENDOR_ID_VENDOR_NAME VARCHAR No
The name of the vendor.
8 OVR_ADDR_B_HOUSENUM VARCHAR No
Edit Segment - Override Address Table - Basis House Number
9 OVR_ADDR_B_STADDR VARCHAR No
Edit Segment - Override Address Table - Basis Street Address
10 OVR_ADDR_B_CITY VARCHAR No
Edit Segment - Override Address Table - Basis City
11 OVR_ADDR_B_ZIP VARCHAR No
Edit Segment - Override Address Table - Basis Zip
12 OVR_ADDR_B_DISTRICT_C_NAME VARCHAR No
Edit Segment - Override Address Table - Basis District
May contain organization-specific values: Yes
13 OVR_ADDR_B_COUNTY_2_C_NAME VARCHAR No
Edit Segment - Override Address Table - Basis County
May contain organization-specific values: Yes
14 OVR_ADDR_B_COUNTRY_2_C_NAME VARCHAR No
Edit Segment - Override Address Table - Basis Country
May contain organization-specific values: Yes
15 OVR_ADDR_R_HOUSENUM VARCHAR No
Edit Segment - Override Address Table - Replacement House Number
16 OVR_ADDR_R_STADDR VARCHAR No
Edit Segment - Override Address Table - Replacement Street Address
17 OVR_ADDR_R_CITY VARCHAR No
Edit Segment - Override Address Table - Replacement City
18 OVR_ADDR_R_TAX_STATE_C_NAME VARCHAR No
Edit Segment - Override Address Table - Replacement State
May contain organization-specific values: Yes
19 OVR_ADDR_R_ZIP VARCHAR No
Edit Segment - Override Address Table - Replacement Zip
20 OVR_ADDR_R_DISTRICT_C_NAME VARCHAR No
Edit Segment - Override Address Table - Replacement District
The category values for this column were already listed for column: OVR_ADDR_B_DISTRICT_C_NAME
21 OVR_ADDR_R_COUNTY_2_C_NAME VARCHAR No
Edit Segment - Override Address Table - Replacement County
The category values for this column were already listed for column: OVR_ADDR_B_COUNTY_2_C_NAME
22 OVR_ADDR_R_COUNTRY_2_C_NAME VARCHAR No
Edit Segment - Override Address Table - Replacement Country
The category values for this column were already listed for column: OVR_ADDR_B_COUNTRY_2_C_NAME
23 OVR_ADDR_IS_ACT_YN VARCHAR No
Edit Segment - Override Address Table - Is Override Active
May contain organization-specific values: No
Category Entries:
No
Yes
24 OVR_ADDR_USER_ID VARCHAR No
Edit Segment - Override Address Table - Activation User
25 OVR_ADDR_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
26 OVR_ADDR_INST_UTC_DTTM DATETIME (UTC) No
Edit Segment - Override Address Table - Activation Instant
27 OVR_ADDR_B_TAX_STATE_C_NAME VARCHAR No
Edit Segment - Override Address Table - Basis State
The category values for this column were already listed for column: OVR_ADDR_R_TAX_STATE_C_NAME