PAT_ENC_6

Description:

This table supplements the PAT_ENC, PAT_ENC_2, PAT_ENC_3, PAT_ENC_4, and PAT_ENC_5 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	PAT_ENC_DATE_REAL	FLOAT	No
	A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc.
3	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
4	LINKED_ENC_CSN	NUMERIC	No
	The unique contact serial number of the visit that represents the official visit. Intended for (FINLAND) ad hoc encounters that need to be associated with an official visit.
5	LMP_PRECISION_C_NAME	VARCHAR	No
	The uncertainty of the last menstrual period date stored in the PAT_ENC.LMP_DATE column. May contain organization-specific values: Yes Category Entries: Exact Date Within Days Within Weeks Within Months Within Years LMP Unknown Approximate
6	PLANNED_BILL_AREA_ID	NUMERIC	No
	Used to track what the bill area was for an appointment at the time of check in.
7	PLANNED_BILL_AREA_ID_BILL_AREA_NAME	VARCHAR	No
	The record name of this bill area, financial subdivision, or financial division.
8	BCRA_BRCA_GENE_MUT_C_NAME	VARCHAR	No
	The patient's risk factor category number for the Presence of BRCA 1/2 Mutation breast cancer risk factor. May contain organization-specific values: No Category Entries: No Yes Unknown
9	SVC_TARGET_EFFORT_YN	VARCHAR	No
	Flag to indicate that additional effort was needed on behalf of staff to work this encounter in order to meet service targets. May contain organization-specific values: No Category Entries: No Yes
10	OUTPAT_VISIT_GRP_C_NAME	VARCHAR	No
	Used to indicate additional visit type information for reporting purposes. May contain organization-specific values: Yes
11	PSYCH_ARRIVAL_C_NAME	VARCHAR	No
	Indicates the method of arrival for the patient for psychiatric care. May contain organization-specific values: Yes
12	PLAN_RECUR_TREAT_YN	VARCHAR	No
	Indicates whether the visit is part of a planned recurring treatment period. The category values for this column were already listed for column: SVC_TARGET_EFFORT_YN
13	HUS_VISIT_TYPE_C_NAME	VARCHAR	No
	Additional visit type information required for HUS visits for reporting purposes. May contain organization-specific values: Yes No Entries Defined
14	SOCIAL_SRVC_AREA_C_NAME	VARCHAR	No
	Indicates the social care service area for the visit. May contain organization-specific values: Yes No Entries Defined
15	EXT_LTC_PAT_YN	VARCHAR	No
	Indicates whether a patient is a long term care patient at an external organization. The category values for this column were already listed for column: SVC_TARGET_EFFORT_YN
16	VETERAN_ENC_MED_CVG_C_NAME	VARCHAR	No
	This holds the medical coverage level for a given patient encounter. The medical coverage denotes the level of coverage a patient is using for a given encounter. The coverage level determines how much the patient will be billed. This column is frequently used to link to the ZC_VETERAN_MED_CVG table. May contain organization-specific values: Yes No Entries Defined
17	VETERAN_BILLING_CODE_C_NAME	VARCHAR	No
	This holds the veteran billing code for a given patient encounter. The billing code denotes the type of appointment that was given which in turns determines how much the patient should be billed. This column is frequently used to link to the ZC_VETERAN_BILLING_CODE table. May contain organization-specific values: Yes No Entries Defined
18	ED_REF_CALLBAK_D_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.
19	RFV_USED_TO_SCHED_C_NAME	VARCHAR	No
	Stores the reason for visit the user selected to schedule an appointment through MyChart. May contain organization-specific values: Yes
20	BMI_PERCENTILE	NUMERIC	No
	This item stores the patient's BMI percentile. This item will be null for ages greater than 20, and is calculated based on the patient's height, weight, and sex.
21	CREATION_ORD_ID	NUMERIC	No
	The ID number of the order which created the patient contact.
22	EXT_TX_STATUS_C_NAME	VARCHAR	No
	An optional item used to document the encounter's External Transportation Status/Needs. There is no standard functionality that is driven by this item. This item can be used to drive reporting, confirmation errors, or WQ activities. May contain organization-specific values: Yes No Entries Defined
23	EXT_TX_STATUS_CMT	VARCHAR	No
	An optional item used to document the encounter's External Transportation Comments. There is no standard functionality that is driven by this item. This item can be used to driver reporting, confirmation errors, or WQ activities.
24	EXT_ACCM_STATUS_C_NAME	VARCHAR	No
	An optional item used to document the encounter's External Accommodation Status/Needs. There is no standard functionality that is driven by this item. This item can be used to driver reporting, confirmation errors, or workqueue activities. May contain organization-specific values: Yes No Entries Defined
25	EXT_ACCM_STATUS_CMT	VARCHAR	No
	An optional item used to document the encounter's External Accommodation Comments. There is no standard functionality that is driven by this item. This item can be used to driver reporting, confirmation errors, or workqueue activities.
26	SG_AT_RISK_IND_C_NAME	VARCHAR	No
	Stores the at risk indicator for a specific visit. May contain organization-specific values: Yes No Entries Defined
27	SG_FC_STATUS_C_NAME	VARCHAR	No
	Stores the financial counselling status for a specific visit. May contain organization-specific values: Yes Category Entries: Not Started In Progress Completed
28	ELIG_PLAN_SELECT_YN	VARCHAR	No
	This item indicates if an eligibility plan is currently selected for this encounter. The category values for this column were already listed for column: SVC_TARGET_EFFORT_YN
29	SG_MOH_URGENCY_C_NAME	VARCHAR	No
	Used to indicate whether an appointment is urgent or non-urgent for Ministry of Health regulatory reporting. May contain organization-specific values: Yes No Entries Defined
30	SG_NAMED_REFERRAL_YN	VARCHAR	No
	Used for validation of the patient class and regulatory reporting for whether a patient was referred to a particular provider. The category values for this column were already listed for column: SVC_TARGET_EFFORT_YN
31	SG_PAT_REQUEST_YN	VARCHAR	No
	Used to indicate whether a patient requested to see a particular doctor and thus should be a private patient. The category values for this column were already listed for column: SVC_TARGET_EFFORT_YN
32	SG_TREATMENT_PROG_C_NAME	VARCHAR	No
	Used to indicate the type of service programme that the appointment is assigned to. May contain organization-specific values: Yes No Entries Defined
33	SG_APPT_RATIONALE_C_NAME	VARCHAR	No
	Used to indicate whether an appointment was the earliest possible, at a patient request, at a doctor request, or force booked. This drives regulatory reporting functionality. May contain organization-specific values: Yes No Entries Defined
34	EVISIT_RFV_C_NAME	VARCHAR	No
	The category value of the reason for the e-visit. This number links to the value stored in the ON_DEMAND_VIDEO_VISIT_C of the ZC_ON_DEMAND_VIDEO_VISIT table. May contain organization-specific values: Yes Category Entries: General Video Visit Cough Sinus Rash Back Pain Headache Ear Infection Muscular Skeletal Injury Urinary Tract Infection Asthma Birth Control Evaluation Insect Bite Nausea Diarrhea Lactation Consultation Nutrition Consultation Chronic Obstructive Pulmonary Disease Sore Throat Gout Pink Eye General E-Visit Vaginal Discharge / Irritation Heartburn Fatigue Acne Constipation Sunburn Head Lice Emergency Contraception Poison Ivy Cold and Flu Anxiety Athlete's Foot Allergies COVID Concern Fever Tooth Pain Quitting Smoking Sleep Concerns Ear Pain Urgent Care Visit Urgent Care Visit (Covered) Abdominal Pain Diabetes Management Body Aches Breathing Difficulty Cold Sore Depression Dizziness Erectile Dysfunction Hair Loss High Blood Pressure Leg Swelling Menopause Motion Sickness Bloody Stool Eye Redness Snoring Sexually Transmitted Infection Sexually Transmitted Diseases Vaginal Bleeding Vomiting Wound Urinary Symptoms Lightheadedness
35	EVISIT_YN	VARCHAR	No
	Indicates whether this encounter is an E-Visit. This will be set only for appointment-based E-Visits. The category values for this column were already listed for column: SVC_TARGET_EFFORT_YN
36	EVISIT_TLH_ALLOWED_SUBLOC_C_NAME	VARCHAR	No
	The sublocation where the patient indicated they were currently located for a video visit or an e-visit. This information comes from a category value stored in I SER 32510. May contain organization-specific values: No Category Entries: Alabama Alaska Arizona Arkansas California Colorado Connecticut Delaware Florida Georgia Hawaii Idaho Illinois Indiana Iowa Kansas Kentucky Louisiana Maine Maryland Massachusetts Michigan Minnesota Mississippi Missouri Montana Nebraska Nevada New Hampshire New Jersey New Mexico New York North Carolina North Dakota Ohio Oklahoma Oregon Pennsylvania Rhode Island South Carolina South Dakota Tennessee Texas Utah Vermont Virginia Washington West Virginia Wisconsin Wyoming District of Columbia American Samoa Guam Northern Mariana Islands Puerto Rico United States Virgin Islands Alberta British Columbia Manitoba Newfoundland and Labrador New Brunswick Nova Scotia Ontario Prince Edward Island Quebec Saskatchewan Northwest Territories Nunavut Yukon
37	EVISIT_TLH_ALLOWED_LOC_C_NAME	VARCHAR	No
	The country where the patient indicated they were currently located for a video visit or an e-visit. This information comes from a category value stored in I ECT 70150. May contain organization-specific values: Yes Category Entries: Andorra United Arab Emirates Afghanistan Antigua and Barbuda Anguilla Albania Armenia Angola Antarctica Argentina American Samoa Austria Australia Aruba Aland Islands Azerbaijan Bosnia and Herzegovina Barbados Bangladesh Belgium Burkina Faso Bulgaria Bahrain Burundi Benin Saint Barthelemy Bermuda Brunei Darussalam Bolivia, Plurinational State of Bonaire, Sint Eustatius and Saba Brazil Bahamas Bhutan Bouvet Island Botswana Belarus Belize Canada Cocos (Keeling) Islands Congo, the Democratic Republic of the Central African Republic Congo Switzerland Cote d'Ivoire Cook Islands Chile Cameroon China Colombia Costa Rica Cuba Cabo Verde Curacao Christmas Island Cyprus Czech Republic Germany Djibouti Denmark Dominica Dominican Republic Algeria Ecuador Estonia Egypt Western Sahara Eritrea Spain Ethiopia Finland Fiji Falkland Islands (Malvinas) Micronesia, Federated States of Faroe Islands France Gabon United Kingdom of Great Britain and Northern Ireland Grenada Georgia French Guiana Guernsey Ghana Gibraltar Greenland Gambia Guinea Guadeloupe Equatorial Guinea Greece South Georgia and the South Sandwich Islands Guatemala Guam Guinea-Bissau Guyana Hong Kong Heard Island and McDonald Islands Honduras Croatia Haiti Hungary Indonesia Ireland Israel Isle of Man India British Indian Ocean Territory Iraq Iran, Islamic Republic of Iceland Italy Jersey Jamaica Jordan Japan Kenya Kyrgyzstan Cambodia Kiribati Comoros Saint Kitts and Nevis Korea, Democratic People's Republic of Korea, Republic of Kuwait Cayman Islands Kazakhstan Lao People's Democratic Republic Lebanon Saint Lucia Liechtenstein Sri Lanka Liberia Lesotho Lithuania Luxembourg Latvia Libya Morocco Monaco Moldova, Republic of Montenegro Saint Martin (French part) Madagascar Marshall Islands Macedonia, the former Yugoslav Republic of Mali Myanmar Mongolia Macao Northern Mariana Islands Martinique Mauritania Montserrat Malta Mauritius Maldives Malawi Mexico Malaysia Mozambique Namibia New Caledonia Niger Norfolk Island Nigeria Nicaragua Netherlands Norway Nepal Nauru Niue New Zealand Oman Panama Peru French Polynesia Papua New Guinea Philippines Pakistan Poland Saint Pierre and Miquelon Pitcairn Puerto Rico Palestine, State of Portugal Palau Paraguay Qatar Reunion Romania Serbia Russian Federation Rwanda Saudi Arabia Solomon Islands Seychelles Sudan Sweden Singapore Saint Helena, Ascension and Tristan da Cunha Slovenia Svalbard and Jan Mayen Slovakia Sierra Leone San Marino Senegal Somalia Suriname South Sudan Sao Tome and Principe El Salvador Sint Maarten (Dutch part) Syrian Arab Republic Swaziland Turks and Caicos Islands Chad French Southern Territories Togo Thailand Tajikistan Tokelau Timor-Leste Turkmenistan Tunisia Tonga Turkey Trinidad and Tobago Tuvalu Taiwan, Province of China Tanzania, United Republic of Ukraine Uganda United States Minor Outlying Islands United States of America Uruguay Uzbekistan Holy See Saint Vincent and the Grenadines Venezuela, Bolivarian Republic of Virgin Islands, British Virgin Islands, U.S. Viet Nam Vanuatu Wallis and Futuna Samoa Yemen Mayotte South Africa Zambia Zimbabwe
38	APPT_AUTH_STATUS_C_NAME	VARCHAR	No
	The authorization status of an appointment based on the information stored in any authorization records linked to an appointment (EPT-23025). May contain organization-specific values: No Category Entries: Not Authorized Authorized Authorization Not Needed Partially Authorized Missing Authorization Not Applicable
39	EVISIT_NEW_STATUS_C_NAME	VARCHAR	No
	The current workflow status of an e-visit encounter. Values include 1-In Progress, 2-Submitted, 3-Under Review, 4-Complete, 5-Expired, 6-Returned to Patient, and 7-Cancelled May contain organization-specific values: No Category Entries: Not E-Visit In-Progress Submitted by Patient Under Review Complete Expired Returned To Patient Canceled
40	LAB_RESP_USER_ID	VARCHAR	No
	The unique ID of the phlebotomist (EMP) currently responsible for the patient's lab draws for this encounter.
41	LAB_RESP_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
42	EXT_MEDS_UPD_INST_UTC_DTTM	DATETIME (UTC)	No
	Contains the most recent instant of update for external medications in external orders encounters.
43	INTF_PRIMARY_PAT_ENC_CSN_ID	NUMERIC	No
	Contains the CSN of the primary interface contact for this encounter.
44	OVERRIDE_BCRA_NUM_BIOPSY_C_NAME	VARCHAR	No
	The override value for the number of biopsies. The override value is used in the calculation of the Gail model risk score. May contain organization-specific values: No Category Entries: None One Two or more Unknown
45	OVERRIDE_BCRA_RACE_C_NAME	VARCHAR	No
	The override value for patient race. The override value is used in the calculation of the Gail model risk score. 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
46	OVERRIDE_GAIL_FACTOR_USER_ID	VARCHAR	No
	The user who overrode the factors for the Gail model.
47	OVERRIDE_GAIL_FACTOR_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
48	OVERRIDE_GAIL_FACTOR_DTTM	DATETIME (Local)	No
	The instant when the Gail factors were overridden.
49	VETERAN_COVERAGE_ENC_YN	VARCHAR	No
	Indicates whether the patient's encounter is expected to be covered by their VA coverage The category values for this column were already listed for column: SVC_TARGET_EFFORT_YN
50	ADJUD_TO_PHARMACY_COVERAGE_YN	VARCHAR	No
	Indicates whether we are adjudicating one or more of the medications administered to the patient to a pharmacy coverage. 'Y' indicates that medications will be adjudicated. 'N' or NULL indicate that no medications will be adjudicated to a pharmacy coverage. The category values for this column were already listed for column: SVC_TARGET_EFFORT_YN
51	TLH_APRV_SUBLOC_C_NAME	VARCHAR	No
	This contains the latest approved patient sublocation for an encounter. Sublocations are considered approved if a patient is able to schedule a video visit in that sublocation, or if it is manually set by a staff member during or after scheduling. The category values for this column were already listed for column: EVISIT_TLH_ALLOWED_SUBLOC_C_NAME
52	TLH_APRV_LOC_C_NAME	VARCHAR	No
	This contains the latest approved patient location for an encounter. Locations are considered approved if a patient is able to schedule a video visit in that location, or if it is manually set by a staff member during or after scheduling. The category values for this column were already listed for column: EVISIT_TLH_ALLOWED_LOC_C_NAME