CUST_SERVICE_TRANSFER
Description:
The CUST_SERVICE_TRANSFER table contains information about patient transfer requests that have been documented in a customer service communication record. This can be used to report on communication documented by staff who facilitate calls between referring providers and admitting providers for potential transfer patients.

Primary Key
Column Name Ordinal Position
COMM_ID 1

Column Information
Name Type Discontinued?
1 COMM_ID NUMERIC No
The unique ID of the customer service communication record.
2 TRANS_PAT_SSN VARCHAR No
The social security number of the patient for whom the transfer is requested.
3 TRANS_REF_PROV VARCHAR No
The name of the referring provider who is requesting the patient be transferred.
4 TRANS_PAT_NAME VARCHAR No
The name of the patient for whom the transfer is requested.
5 TRANS_PAT_AGE INTEGER No
The age of the patient for whom the transfer is requested.
6 TRANS_PAT_SEX_C_NAME VARCHAR No
The category ID for the sex of the patient for whom the transfer is requested.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Nonbinary
X
Other
7 TRANS_PAT_POINT_OF_ORIGIN_C_NAME VARCHAR No
The point of origin category ID for the source location from which the requested patient will be physically transferred.
May contain organization-specific values: Yes
8 TRANS_REASON_C_NAME VARCHAR No
The transfer reason category ID for the patient transfer request.
May contain organization-specific values: Yes
9 TRANS_LVL_OF_CARE_C_NAME VARCHAR No
The level of care category ID for the patient transfer request.
May contain organization-specific values: Yes
10 TRANS_PAT_CLASS_C_NAME VARCHAR No
The patient class category ID for the patient transfer request.
May contain organization-specific values: Yes
11 TRANS_ACCOMMODATION_CODE_C_NAME VARCHAR No
The accommodation code category ID for the patient transfer request.
May contain organization-specific values: Yes
12 TRANS_ACCOMMODATION_REASON_C_NAME VARCHAR No
The accommodation code reason category ID for the patient transfer request.
May contain organization-specific values: Yes
13 TRANS_HOSPITAL_SERVICE_C_NAME VARCHAR No
The hospital service category ID for the patient transfer request.
May contain organization-specific values: Yes
14 TRANS_NEEDED_BY_DT DATETIME No
The date the patient transfer is needed by.
15 TRANS_CLIN_ACCEPTED_YN VARCHAR No
Indicates whether the patient transfer is clinically accepted or not.
May contain organization-specific values: No
Category Entries:
No
Yes
16 TRANS_CLIN_DECISION_USER_ID VARCHAR No
The unique ID of the user who recorded the clinical decision for the transfer request.
17 TRANS_CLIN_DECISION_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
18 TRANS_FIN_ACCEPTED_YN VARCHAR No
Indicates whether the patient transfer is financially accepted or not.
The category values for this column were already listed for column: TRANS_CLIN_ACCEPTED_YN
19 TRANS_FIN_DECISION_USER_ID VARCHAR No
The unique ID of the user who recorded the financial decision for the transfer request.
20 TRANS_FIN_DECISION_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
21 TRANS_DECISION_REASON_C_NAME VARCHAR No
The decision reason category ID for the patient transfer, entered when the request is either accepted or denied.
May contain organization-specific values: Yes
No Entries Defined
22 TRANS_REF_ORG_C_NAME VARCHAR No
The transfer referral organization category ID for the patient transfer request.
May contain organization-specific values: Yes
23 TRANS_PAT_DOB_DT DATETIME No
The date of birth of the patient for whom the transfer is requested.
24 TRANS_CLIN_DECISION_DATETIME DATETIME (UTC) No
The date and time when the clinical decision regarding the patient transfer request was recorded.
25 TRANS_FIN_DECISION_DATETIME DATETIME (UTC) No
The date and time when the financial decision regarding the patient transfer request was recorded.
26 REQUEST_STATUS_C_NAME VARCHAR No
This item stores the current status of the Transfer Center request.
May contain organization-specific values: No
Category Entries:
Pending
Accepted
Declined
Completed
Voided
Canceled
27 DEST_DECLINE_RSN_C_NAME VARCHAR No
This item stores why a considered destination was marked as declined for the request.
May contain organization-specific values: Yes
Category Entries:
Transfer not medically appropriate
Hospital at capacity
Patient out of network
Auto-declined
28 CANCEL_STATUS_RSN_C_NAME VARCHAR No
This item stores the reason why a Transfer Center request was canceled.
May contain organization-specific values: Yes
Category Entries:
Patient declined transfer
Took too long to respond
Referring location pulled request
Patient condition not suitable for transfer
Transfer request order canceled
Created in error
Duplicate request
29 REFERRING_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.
30 REFERRING_LOC_ID_LOC_NAME VARCHAR No
The name of the revenue location.
31 TRANSFER_TYPE_C_NAME VARCHAR No
This item stores the type of transfer being requested.
May contain organization-specific values: Yes
Category Entries:
Inpatient Transfer
Emergency Transfer
STEMI
Stroke
32 REFERRING_LOC_IS_OTHER_YN VARCHAR No
This column stores whether the referring location of this Transfer Center request is stored as a discrete record or as free text.
The category values for this column were already listed for column: TRANS_CLIN_ACCEPTED_YN
33 FREETEXT_REFERRING_LOC_NAME VARCHAR No
The referring location of a Transfer Center request, stored as free text.
34 REQUEST_IS_EMTALA_YN VARCHAR No
This item stores whether a patient transfer falls under EMTALA (Emergency Medical Treatment and Labor Act) legislation in the United States.
The category values for this column were already listed for column: TRANS_CLIN_ACCEPTED_YN
35 TRANSFER_REGION_ID NUMERIC No
Region associated with the Transfer Center request.
36 TRANSFER_REGION_ID_RECORD_NAME VARCHAR No
The name of this cleaning sector.
37 DEST_LOC_ID_LOC_NAME VARCHAR No
The name of the revenue location.
38 MODE_OF_TXPORT_C_NAME VARCHAR No
Describes by what method a Transfer Center patient is being transported to the destination location.
May contain organization-specific values: Yes
39 TXPORT_SERVICE_ID_LOC_NAME VARCHAR No
The name of the revenue location.
40 TXPORT_SERVICE_IS_OTHER_YN VARCHAR No
Indicates whether the transportation service provider has been stored as free text. If yes, then column FREETEXT_TXPORT_SERVICE_NAME will contain the free-text name.
The category values for this column were already listed for column: TRANS_CLIN_ACCEPTED_YN
41 TXPORT_CONTACT_NUM VARCHAR No
The contact number for the transportation service provider moving the patient to the destination location.
42 EXPECTED_ARRIVAL_DTTM DATETIME (Local) No
The date and time the patient is expected to arrive at the destination location.
43 TXPORT_DISPATCH_UTC_DTTM DATETIME (UTC) No
The date and time that the transportation service provider was dispatched to pick up the patient being transferred.
44 TXPORT_PICK_UP_UTC_DTTM DATETIME (UTC) No
The date and time that the patient was picked up from the referring location.
45 PAT_ARRIVAL_UTC_DTTM DATETIME (UTC) No
What time the patient arrived at the destination location.
46 FREETEXT_TXPORT_SERVICE_NAME VARCHAR No
This item stores the free-text name of the transportation service provider associated with a Transfer Center request.
The category values for this column were already listed for column: TRANS_CLIN_ACCEPTED_YN
47 SOURCE_ADMISSION_DTTM DATETIME (Local) No
The date and time of a request's source encounter. For manually entered encounters. For linked hospital encounters, use PAT_ENC_HSP__INP_ADM_DATE, for the inpatient admission date/time, and/or PAT_ENC_HSP__HOSP_ADMSN_TIME, for the date and time that the patient was first admitted to the facility, bedded in the ED, or confirmed for an HOV for this contact, regardless of patient's base patient class. For appointment encounters, use PAT_ENC_APPT__CONTACT_DATE for the date and PAT_ENC_APPT__PROV_START_TIME for the time.
48 SOURCE_ADMSN_LVL_OF_CARE_C_NAME VARCHAR No
The level of care of a request's source encounter. For manually entered encounters. For linked hospital encounters, use PAT_ENC_HSP__LEVEL_OF_CARE_C instead.
The category values for this column were already listed for column: TRANS_LVL_OF_CARE_C_NAME
49 TRANS_BACK_TO_REFERRING_LOC_YN VARCHAR No
Indicates whether a source encounter location is willing to accept a transfer back. 'Y' indicates that they are. 'N' or NULL indicates that they are not.
The category values for this column were already listed for column: TRANS_CLIN_ACCEPTED_YN
50 PAT_IS_IN_STATE_RESIDENT_YN VARCHAR No
Indicates whether or not the patient of a Transfer Center request is an in-state resident of the state of the target destination.
The category values for this column were already listed for column: TRANS_CLIN_ACCEPTED_YN
51 TRANS_REFER_ZONE_C_NAME VARCHAR No
The geographical zone of the referring facility.
May contain organization-specific values: Yes
No Entries Defined
52 TRANS_REQ_ZONE_C_NAME VARCHAR No
The geographical zone the referring facility asked to send the patient to.
The category values for this column were already listed for column: TRANS_REFER_ZONE_C_NAME
53 TRANS_DEST_ZONE_C_NAME VARCHAR No
The geographical zone of the selected destination.
The category values for this column were already listed for column: TRANS_REFER_ZONE_C_NAME
54 REQUESTED_DEST_LOC_ID_LOC_NAME VARCHAR No
The name of the revenue location.
55 TC_PRIORITY_C_NAME VARCHAR No
The priority of a Transfer Center request.
May contain organization-specific values: No
Category Entries:
Low
Normal
High
Critical
56 PRIN_ACC_PROV_CONTACT_IDENT INTEGER No
This stores the line number of the Contact Log entry that is the principal accepting provider for the Transfer Center request.
57 REFERRING_PROV_ADDR_ID VARCHAR No
This provides a link to the address of the referring provider. To obtain the address information, join to the table CLARITY_SER_ADDR on the ADDR_UNIQUE_ID column. If you use IntraConnect, you also need to join the REFERRING_PROV_ID column to CLARITY_SER_ADDR.PROV_ID.
58 SOURCE_ENC_DEPT VARCHAR No
The department where a source encounter on a request occurred. For manually entered encounters. For linked hospital encounters, use PAT_ENC_HSP__DEPARTMENT_ID. For linked appointment encounters, use PAT_ENC_APPT__DEPARTMENT_ID.
59 SOURCE_ENC_ROOM_AND_BED VARCHAR No
The bed (and room, if applicable) that a patient was assigned to in a manually entered source encounter. For linked hospital encounters, use PAT_ENC_HSP__ROOM_ID and PAT_ENC_HSP__BED_ID instead.