ATB_EDIT_CTNUM_OVERRIDES
Description:
ATB Edit segment provider phone 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_CTNUM_S_ENTITY_AUTH_ROLE_C_NAME VARCHAR No
Edit Segment - Override Provider Phone 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_CTNUM_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_CTNUM_S_FACILITY_ID_LOC_NAME VARCHAR No
The name of the revenue location.
6 OVR_CTNUM_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_CTNUM_S_VENDOR_ID_VENDOR_NAME VARCHAR No
The name of the vendor.
8 OVR_ATB_OVRCONTACTNUM_TYPE_C_NAME VARCHAR No
Edit Segment - Override Contact Number Table - Scope Contact Number Type
May contain organization-specific values: No
Category Entries:
Phone Number
9 OVR_CTNUM_B_NUM VARCHAR No
Edit Segment - Override Contact Number Table - Basis Contact Number
10 OVR_CTNUM_R_NUM VARCHAR No
Edit Segment - Override Contact Number Table - Replacement Contact Number
11 OVR_CTNUM_ACTIVE_YN VARCHAR No
Edit Segment - Override Contact Number Table - Override Is Active
May contain organization-specific values: No
Category Entries:
No
Yes
12 OVR_CTNUM_USER_ID VARCHAR No
Edit Segment - Override Contact Number Table - Activation User
13 OVR_CTNUM_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
14 OVR_CTNUM_ACT_UTC_DTTM DATETIME (UTC) No
Edit Segment - Override Contact Number Table - Activation Instant