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 & 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
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_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
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_VENDOR_NAME | VARCHAR | No |
The name of the vendor.
12 | ATCHMENT_MCR_ID | VARCHAR | No |
The unique ID of the carrier record that is attached to the customer service communication.
13 | ATCHMENT_MCR_ID_CARRIER_NAME | VARCHAR | No |
The name of the carrier record.
14 | ATCHMENT_REF_ID | NUMERIC | No |
The unique ID of the referral record that is attached to the customer service communication.
15 | ATCHMENT_CLM_ID | NUMERIC | No |
The unique ID of the AP Claim record that is attached to the customer service communication.
16 | ATCHMENT_NET_ID | VARCHAR | No |
The unique ID of the network record that is attached to the customer service communication.
17 | ATCHMENT_NET_ID_NETWORK_NAME | VARCHAR | No |
The name of the network.
18 | ATCHMENT_LOC_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
19 | ATCHMENT_POS_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
20 | ATCHMENT_DEP_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
21 | ATCHMENT_PBA_ID | VARCHAR | No |
The unique ID of the premium billing account record that is attached to the customer service communication.
22 | ATCHMENT_EAR_ID | NUMERIC | No |
The unique ID of the account record that is attached to the customer service communication.
23 | ATCHMENT_NCS_ID | NUMERIC | No |
The unique ID of the customer service communication record that is attached to the customer service communication.
24 | 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
Campaign Associated with CRM
Scheduling Abandoned
Scheduling Denied
Linked to Appointment
Attached with Billing Activity
Refill Requested
Created by Campaign
Triggered Inclusion in Campaign
Nurse Triage Message Received
Confirmed Appointment
Unconfirmed Appointment
Appeal Created
Grievance Created
Appeal Opened
Grievance Opened
Estimate Updated
Estimate Voided
Related Assessment
Opened by CRM
Sent Video Visit Link
Interested in Research Study
Assessed Visit
25 | ATCHMENT_RSN_CMT | VARCHAR | No |
The attachment reason comment for the customer service communication attachment.
26 | ATCHMENT_HAR_ID | NUMERIC | No |
The unique ID of the hospital account record that is attached to the customer service communication.
27 | ATCHMENT_CVG_ID | NUMERIC | No |
The unique ID of the coverage record that is attached to the customer service communication.
28 | ATCHMENT_PROG_ID_MEMBERSHIP_NAME | VARCHAR | No |
The name for membership/benefit record.
29 | ATCHMENT_ZIP | VARCHAR | No |
The ZIP code that was associated with the attachment when it was added to the customer service communication.
30 | ATCHMENT_PROSPECT_ID | NUMERIC | No |
The unique ID of the prospective patient record that is attached to the customer service communication.
31 | ATCHMENT_CAMPAIGN_ID | NUMERIC | No |
The unique ID of the campaign record that is attached to a customer service communication.
32 | ATCHMENT_CAMPAIGN_ID_CAMPAIGN_NAME | VARCHAR | No |
The name of the campaign record.
33 | ATCHMENT_ORDER_ID | NUMERIC | No |
Stores relevant order records for this NCS record.
34 | ATCHMENT_ESTIMATE_ID | NUMERIC | No |
The unique ID of the estimate record that is attached to the customer service communication.
35 | ATCHMENT_DOCUMENT_ID | VARCHAR | No |
The unique ID of the document record that is attached to this customer service communication line.
36 | ATCHMENT_CLAIM_RECON_ID | VARCHAR | No |
The unique ID of the rejected claim record that is attached to the customer service communication.
37 | ATCHMENT_RESEARCH_ID_RESEARCH_STUDY_NAME | VARCHAR | No |
The name of the research study record.
38 | ATCHMENT_AUTH_REQUEST_ID | NUMERIC | No |
Stores relevant authorization requests for CRM