HH_PAT_CERT_PERIOD
Description:
This table contains information for the cert period to which a Home Health contact belongs.

Primary Key
Column Name Ordinal Position
PAT_ENC_CSN_ID 1

Column Information
Name Type Discontinued?
1 PAT_ID VARCHAR No
Unique identifier for the patient.
2 CONTACT_DATE_REAL FLOAT No
Unique identifier for this contact for this patient.
3 CARE_PLAN_ID VARCHAR No
The care plan to which the contact is linked. Links to table CARE_INTEGRATOR.
4 CERT_PERIOD INTEGER No
The cert period to which the contact is linked.
5 VISIT_SET INTEGER No
The visit set of which the contact is a part.
6 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).
7 CONTACT_DATE DATETIME No
The date of this contact in calendar format.
8 POC_ENC_NUM INTEGER No
The serial number of the plan of care encounter that the contact created.
9 CM_CT_OWNER_ID VARCHAR No
The Community ID (CID) of the instance that owns this contact. This is populated only if you use IntraConnect.
10 AUTH_PROVIDER_ID VARCHAR No
The record ID for the provider who signed the verbal order that authorized this visit.
11 REPORTING_DISC_C_NAME VARCHAR No
This item stores the reporting discipline of the provider who completed the encounter.
May contain organization-specific values: No
Category Entries:
Registered Nurse
Licensed Practical Nurse
Physical Therapist
Physical Therapy Assistant
Occupational Therapist
Occupational Therapy Assistant
Speech-Language Pathologist
Medical Social Worker
Home Health Aide
Chaplain
Homemaker
Other
12 POC_ENC_DEL_YN VARCHAR No
Stores if the Plan of Care encounter's certification period has been deleted.
May contain organization-specific values: No
Category Entries:
No
Yes
13 IS_SPOC_CERT_ENC_YN VARCHAR No
Whether this encounter created a certification period that is associated with a plan of care.
The category values for this column were already listed for column: POC_ENC_DEL_YN
14 VISIT_SET_VERSION INTEGER No
The version of the visit set to which the visit belongs.