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 Video Visit
Urgent Care Video 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
Primary Care Video Visit
Behavioral Health Video Visit
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
53 | ENC_CLOSE_UTC_DTTM | DATETIME (UTC) | No |
The instant the visit was closed
54 | SPLIT_FILING_ORDER_YN | VARCHAR | No |
Indicates whether we are planning to use a separate filing order to bill pumps, per diems, kit codes, and supplies to a medical account for a Med Access investigation. 'Y' indicates that a separate filing order will be created. 'N' or NULL indicate that only one filing order will be used.
The category values for this column were already listed for column: SVC_TARGET_EFFORT_YN