CUST_SERV_ATCHMENT
Description:
Extracts the attachments 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 ID of the customer service communication record for this row.
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 ATCHMENT_USER_ID VARCHAR No
The unique ID associated with the user record for this row. This column is frequently used to link to the CLARITY_EMP table.
4 ATCHMENT_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
5 ATCHMENT_INSTANT DATETIME (UTC) No
The instant that this attachment line was added to the customer service communication record.
6 ATCHMENT_TYPE_C_NAME VARCHAR No
The attachment type category ID for the customer service communication attachment.
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 ATCHMENT_PT_CSN_ID NUMERIC No
The unique contact serial number for the patient encounter that is attached to the customer service communication. This number is unique across all patient encounters in your system. If you use IntraConnect this is the Unique Contact Identifier (UCI).
8 ATCHMENT_SER_ID VARCHAR No
The unique ID of the provider record that is attached to the customer service communication.
9 ATCHMENT_EMP_GRP_ID VARCHAR No
The unique ID of the employer group record that is attached to the customer service communication.
10 ATCHMENT_EMP_GRP_ID_PLAN_GRP_NAME VARCHAR No
The name of the employer group record
11 ATCHMENT_VEN_ID VARCHAR No
The unique ID of the vendor record that is attached to the customer service communication.
12 ATCHMENT_VEN_ID_VENDOR_NAME VARCHAR No
The name of the vendor.
13 ATCHMENT_MCR_ID VARCHAR No
The unique ID of the carrier record that is attached to the customer service communication.
14 ATCHMENT_MCR_ID_CARRIER_NAME VARCHAR No
The name of the carrier record.
15 ATCHMENT_REF_ID NUMERIC No
The unique ID of the referral record that is attached to the customer service communication.
16 ATCHMENT_CLM_ID NUMERIC No
The unique ID of the AP Claim record that is attached to the customer service communication.
17 ATCHMENT_NET_ID VARCHAR No
The unique ID of the network record that is attached to the customer service communication.
18 ATCHMENT_NET_ID_NETWORK_NAME VARCHAR No
The name of the network.
19 ATCHMENT_LOC_ID NUMERIC No
The unique ID of the location record that is attached to the customer service communication.
20 ATCHMENT_POS_ID NUMERIC No
The unique ID of the place of service record that is attached to the customer service communication.
21 ATCHMENT_DEP_ID NUMERIC No
The unique ID of the department record that is attached to the customer service communication.
22 ATCHMENT_PBA_ID VARCHAR No
The unique ID of the premium billing account record that is attached to the customer service communication.
23 ATCHMENT_EAR_ID NUMERIC No
The unique ID of the account record that is attached to the customer service communication.
24 ATCHMENT_NCS_ID NUMERIC No
The unique ID of the customer service communication record that is attached to the customer service communication.
25 ATCHMENT_RSN_C_NAME VARCHAR No
The attachment reason category ID for the customer service communication attachment.
May contain organization-specific values: Yes
Category Entries:
Other
Copied from CRM
Scheduled Appointment
Changed Appointment
Canceled Appointment
Rescheduled Appointment
Added to Waitlist
Copied to CRM
Recommended
Transfer Initiated
Destination Added
Transfer Center Admission
Scheduled and Recommended
Transfer Request Order Signed
Waiver of Liability
Created by This Campaign
26 ATCHMENT_RSN_CMT VARCHAR No
The attachment reason comment for the customer service communication attachment.
27 ATCHMENT_HAR_ID NUMERIC No
The unique ID of the hospital account record that is attached to the customer service communication.
28 ATCHMENT_CVG_ID NUMERIC No
The unique ID of the coverage record that is attached to the customer service communication.
29 ATCHMENT_PROG_ID VARCHAR No
The unique ID of the program record that is attached to the customer service communication.
30 ATCHMENT_ZIP VARCHAR No
The ZIP code that was associated with the attachment when it was added to the customer service communication.
31 ATCHMENT_PROSPECT_ID NUMERIC No
The unique ID of the prospective patient record that is attached to the customer service communication.
32 ATCHMENT_CAMPAIGN_ID NUMERIC No
The unique ID of the campaign record that is attached to a customer service communication.
33 ATCHMENT_CAMPAIGN_ID_CAMPAIGN_NAME VARCHAR No
The name of the campaign record.
34 ATCHMENT_ORDER_ID NUMERIC No
Stores relevant order records for this NCS record.
35 ATCHMENT_ESTIMATE_ID NUMERIC No
The unique ID of the estimate record that is attached to the customer service communication.
36 ATCHMENT_DOCUMENT_ID VARCHAR No
The unique ID of the document record that is attached to this customer service communication line.
37 ATCHMENT_CLAIM_RECON_ID VARCHAR No
The unique ID of the rejected claim record that is attached to the customer service communication.
38 ATCHMENT_RESEARCH_ID VARCHAR No
The unique ID of the research study record that is attached to the customer service communication.