CUST_SERV_OVRIDE_ATCHMENT

Description: |
Extracts the overridden attachment types for this NCS (customer service) record.

Primary Key

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

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | COMM_ID | NUMERIC | No |
The unique identifier (.1 item) for the communication 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 | OVERRIDE_USER_ID | VARCHAR | No |
Stores user who overrode the required attachment.
4 | OVERRIDE_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
5 | OVERRIDE_ATTACH_UTC_DTTM | DATETIME (UTC) | No |
Stores instant that the required attachment type was overridden.
6 | OVERRIDE_REC_TYPE_C_NAME | VARCHAR | No |
Stores the type of record that was overridden.
May contain organization-specific values: No
Category Entries:
Patient
Appointment
Provider
Employer Group
Vendor
Carrier
Referral
AP Claim
Network
Location
Place of Service
Department
Premium & Fee Billing Account
Guarantor Account
CRM
Hospital Account
Clinical Encounter
Admission
Coverage
Program
Transfer Center Destination
Transfer Center Intake
Order
Prospective Patient
Campaign
Appointment Request
Estimate
File
Transfer Center Source Encounter
File Import
Scan
Member Transaction
Rejected Claim
Saved Session
Research Study
Appeal
Grievance
Authorization Request
Provider Assessment
Assessed Visit
Agency
Agent
7 | OVERRIDE_REASON_C_NAME | VARCHAR | No |
Stores the reason for why the attachment was overridden.
May contain organization-specific values: Yes
Category Entries:
Other
Unable to Find Record
Unable to Schedule
Unable to Determine
Awaiting Nurse Triage
8 | OVERRIDE_REASON_CMT | VARCHAR | No |
Stores the comment on the reason why the user overrode the required attachment