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 Billing Account Guarantor Account CRM Hospital Account Clinical Call 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
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
8	OVERRIDE_REASON_CMT	VARCHAR	No
	Stores the comment on the reason why the user overrode the required attachment