PAT_ENC_4
Description:
This table supplements the PAT_ENC, PAT_ENC_2, and PAT_ENC_3 tables. It contains additional information related to patient encounters or appointments.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1

Column Information
Name Type Discontinued?
1 PAT_ENC_CSN_ID NUMERIC No
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2 FAMILY_SIZE INTEGER No
The number of members in the patient's family.
3 VISIT_NUMBER VARCHAR No
The visit number for the given contact.
4 PAT_CNCT_IND_C_NAME VARCHAR No
The patient contact indicator category number for the patient encounter.
May contain organization-specific values: Yes
5 DENTAL_STUDENT_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.
6 LOC_VISIT_ID_LOC_NAME VARCHAR No
The name of the revenue location.
7 COPAY_NOT_COVERED_C_NAME VARCHAR No
The copay not covered category number for the patient encounter.
May contain organization-specific values: Yes
Category Entries:
Not Covered
8 COPAY_COLL_FLAG_YN VARCHAR No
The copay collected flag that indicates whether a copay was collected from the patient encounter.
9 COPAY_COLL_PERSON VARCHAR No
The unique ID number of the person who collected the patient's copay for the encounter.
10 COPAY_WAIVE_RSN_C_NAME VARCHAR No
The copay waive reason category number for the patient encounter.
May contain organization-specific values: Yes
No Entries Defined
11 COPAY_MIN_VALUE NUMERIC No
The value of the minimum copay.
12 COPAY_RECEIPT_NUM VARCHAR No
The receipt number of the copay collected.
13 BEN_ADJ_COINS_AMT NUMERIC No
The adjudicated coinsurance amount for the visit calculated by the benefits engine.
14 BEN_ADJ_DEDUCT_AMT NUMERIC No
The portion of the self-pay amount applied to the deductible for the visit.
15 PAT_HOMELESS_YN VARCHAR No
Indicates if a patient is homeless.
May contain organization-specific values: No
Category Entries:
Yes
No
16 PAT_HOMELESS_TYP_C_NAME VARCHAR No
Characterizes the patients homelessness (for example chronic or sporadic)
May contain organization-specific values: Yes
17 PERCENTAGE_OF_FPL NUMERIC No
Indicates where the patient falls on the federal poverty level as a percentage.
18 MSG_RECEIVED_DTTM DATETIME (Local) No
The date and time the encounter creation In Basket message was received.
19 TOBACCO_USE_VRFY_YN VARCHAR No
This column indicates whether the patient's tobacco usage has been verified. A Y indicates the usage was verified. An N or null indicates the tobacco usage was not verified. It extracts a virtual item, which is calculated using EPT-19202.
20 CR_TX_TYPE_C_NAME VARCHAR No
The transaction type category number for the encounter(E-Visit or Copay).
May contain organization-specific values: No
Category Entries:
E-Visit
Copay
21 ORIG_ENC_CSN NUMERIC No
Holds the CSN of the encounter this Remote Consult encounter is responding to.
22 PHYS_BP_COMMENTS VARCHAR No
This column contains the comments entered for the last recorded blood pressure for this visit.
23 PHYS_TEMP_COMMENTS VARCHAR No
This column contains the comments entered for the last recorded temperature for this visit.
24 PHYS_TEMPSRC_COMNTS VARCHAR No
This column contains the comments entered for the last recorded temperature source for this visit.
25 PHYS_PULSE_COMMENTS VARCHAR No
This column contains the comments entered for the last recorded pulse for this visit.
26 PHYS_WEIGHT_COMNTS VARCHAR No
This column contains the comments entered for the last recorded weight for this visit.
27 PHYS_HEIGHT_COMNTS VARCHAR No
This column contains the comments entered for the last recorded height for this visit.
28 PHYS_RESP_COMMENTS VARCHAR No
This column contains the comments entered for the last recorded respirations for this visit.
29 PHYS_SPO2_COMMENTS VARCHAR No
This column contains the comments entered for the last recorded oxygen saturation level (SpO2) for this visit.
30 PHYS_PF_COMMENTS VARCHAR No
This column contains the comments entered for the last recorded peak flow for this visit.
31 INTERPRT_ASGN_CMT VARCHAR No
Comments regarding the interpreter assigned to the patient's contact.
32 PAT_HOUSING_STAT_C_NAME VARCHAR No
This item stores the patient's current housing status. This is a category list item that may contain values such as Stable/Permanent, Temporary, Unstable, or Unknown.
May contain organization-specific values: Yes
No Entries Defined
33 BCRA_AGE INTEGER No
The patient's age at the time of the risk assessment.
34 BCRA_MENARCHE_AGE_C_NAME VARCHAR No
The patient's risk factor category number for the Age at Menarche breast cancer risk factor.
May contain organization-specific values: No
Category Entries:
14 or older
12 - 13
Under 12
Unknown
35 BCRA_FST_LIVBIRTH_C_NAME VARCHAR No
The patient's risk factor category number for the Age at First Live Birth breast cancer risk factor.
May contain organization-specific values: No
Category Entries:
Under 20
20 - 24
25 - 29
30 or older
Nulliparous
Unknown
36 BCRA_FST_DEG_REL_C_NAME VARCHAR No
The patient's risk factor category number for the Number of Affected First Degree Relatives breast cancer risk factor. Only first degree relatives are considered.
May contain organization-specific values: No
Category Entries:
None
One
Two or more
Unknown
37 BCRA_NUM_BIOPSY_C_NAME VARCHAR No
The patient's risk factor category number for the Number of Breast Biopsies breast cancer risk factor.
May contain organization-specific values: No
Category Entries:
None
One
Two or more
Unknown
38 BCRA_ATYP_HYPLSA_C_NAME VARCHAR No
The patient's risk factor category number for the Presence of Atypical Hyperplasia in Breast Biopsies breast cancer risk factor.
May contain organization-specific values: No
Category Entries:
No
Yes
Unknown
39 BCRA_RACE_C_NAME VARCHAR No
The patient's risk factor category number for the Race breast cancer risk factor.
May contain organization-specific values: No
Category Entries:
White
African American
Hispana/Latina (for Gail 3.01)
Hispana/Latina, US born
Hispana/Latina, born outside the US
Chinese American
Japanese American
Filipino American
Hawaiian
Pacific Islander
Other Asian American
American Indian or Alaskan Native
Missing Birth Country
Unknown
40 LB_ENC_START_DT DATETIME No
This identifies the start date of a Lab Requisition encounter.
41 LB_ENC_END_DT DATETIME No
This identifies the end date of a Lab Requisition encounter.
42 WAITING_LIST_ID NUMERIC No
The unique ID of the Waiting List record associated with this encounter. This column can be used to link to the WAITING_LIST_INFO table.
43 SUBMITTER_ID NUMERIC No
The submitting organization that the results for the lab orders on this encounter should be sent to.
44 SUBMITTER_ID_RECORD_NAME VARCHAR No
The name of the submitter record.
45 BILL_TO_SUBMITTER_C_NAME VARCHAR No
Flag indicating whether the submitter should be billed for any lab procedures performed.
May contain organization-specific values: No
Category Entries:
Client Bill
Patient Bill
46 SUBMITTER_ACCT_ID NUMERIC No
The submitter account to be used when billing laboratory procedures.
47 LB_BLNG_ENC_SRVC_DT DATETIME No
This identifies the service date of the Billing encounter used for Lab Billing. The date is in the time zone of the lab department that created the encounter.
48 ECHKIN_STATUS_C_NAME VARCHAR No
The status of the eCheck-In for this appointment.
May contain organization-specific values: No
Category Entries:
Not Offered
Not Yet Available
Not Started
In Progress
Completed
Not Needed
Not Completed
Filtered
Required - Not Offered
Required - Not Started
Required - In Progress
Required - Completed
Required - Not Needed
Required - Filtered
Optional - Not Offered
Optional - Not Started
Optional - In Progress
Optional - Completed
Optional - Not Needed
Optional - Filtered
49 PB_VISIT_HAR_ID NUMERIC No
The hospital account record used by the Professional Billing system for a given contact.
50 TECHNICAL_REFERRAL_ID NUMERIC No
The MassHealth technical referral associated with the encounter.
51 CR_CLIENT_REF_IDNT VARCHAR No
Used to store the client ID returned by the copay reduction web service
52 CR_BENEFIT_REF_IDNT VARCHAR No
The benefit reference ID number of the patient for the current encounter.
53 CR_MESSAGE_ENGLISH VARCHAR No
The copay message returned by the web service in English.
54 CR_MESSAGE_SPANISH VARCHAR No
The copay message returned by the web service in Spanish.
55 CR_QUERY_SENT_UTC_DTTM DATETIME (UTC) No
Instant the copay reduction web service query was sent to the server
56 CR_RESP_RECVD_UTC_DTTM DATETIME (UTC) No
Specifies the instant when the response to the copay reduction web service query was received
57 CR_QUERY_ERROR VARCHAR No
Specifies the error received in the response to the query sent out to get the copay reduction for the current patient encounter.
58 COPAY_REDUCTION_AMT NUMERIC No
The amount by which the copay should be reduced for the current visit