Table Detail Report
PM_FLX_FORM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PM Flex Form |
Definition: | Stores reference data that is used to describe a flexible form available in a conversation. |
Table Type: | REFERENCE |
Column Detail - PM_FLX_FORM
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
CREATE_DT_TM | DATETIME | N | The date and time the record was created. |
CREATE_PRSNL_ID | DOUBLE | N | The personnel ID of the person who created the row in the table. |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
FLX_FORM_DESCRIPTION | VARCHAR(255) | Y | Stores the description of the flexible form. |
FLX_FORM_NAME | VARCHAR(100) | Y | Stores the name of the flexible form. |
FLX_FORM_TYPE_CD | DOUBLE | N | CODE SET: 4002187 Code value for the type of flexible form. |
INFO_LONG_TEXT_REF_ID | DOUBLE | N | SEQUENCE NAME: LONG_DATA_SEQ Stores the identifier of the row on the long_text_reference table containing the text associated with the options of the flexible form. |
PM_FLX_FORM_ID | DOUBLE | N | SEQUENCE NAME: PM_FLX_CONVERSATION_ID_SEQ Stores the identifier of the row on the pm_flx_form table containing the reference data of the flexible form. It is the primary key of the PM-FLX_FORM table. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - PM_FLX_FORM
Child Column in PM_FLX_FORM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | INFO_LONG_TEXT_REF_ID | LONG_BLOB_REFERENCE | LONG_BLOB_ID |
Parent Column in PM_FLX_FORM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PM_FLX_FORM_ID | PM_FLX_PROMPT | PM_FLX_FORM_ID |
PM_FLX_TASK_CONV_RELTN | PM_FLX_FORM_ID |
PM_HIST_TRACKING
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | PM History Tracking |
Definition: | Master audit tracking table that contains the creation information about a history audit. |
Table Type: | ACTIVITY |
Column Detail - PM_HIST_TRACKING
Column Name | Type | Null? | Definition |
---|---|---|---|
AUTHORIZATION_ID | DOUBLE | Y | Uniquely identifies the related row on the AUTHORIZATION table. |
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
CONVERSATION_UUID | VARCHAR(100) | Y | Will uniquely identify the registration conversation universally. |
CONV_TASK_NUMBER | DOUBLE | N | This is the conversation task used to create a history transaction. 0 when written from other than a conversation. |
CREATE_DT_TM | DATETIME | Y | This is the date and time that a row is created. |
CREATE_PRSNL_ID | DOUBLE | N | This is the person responsible for creating a history transaction. |
CREATE_TASK | DOUBLE | Y | This is the task responsible for creating a history transaction. |
DEVICE_LOCATION_TXT | VARCHAR(255) | Y | The location of the device (as configured through WTSLocation) where the user initiated the registration transaction. |
ENCNTR_ID | DOUBLE | N | This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number. |
FACILITY_ORG_ID | DOUBLE | N | Contains the foreign key to the organization table identifying the associated facility for this history tracking row |
HL7_EVENT | VARCHAR(10) | Y | Stores the according HL7 Event. |
OMIT_REBILL_IND | DOUBLE | N | Indicates that insurance payers should not be rebilled (claims resubmitted) based on changes made during the registration transaction. |
PCID_TXT | VARCHAR(255) | Y | The PC identifier (as configured through WTSLocation) where the user initiated registration transactions. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PM_HIST_TRACKING_ID | DOUBLE | N | Unique Identifier. |
TRANSACTION_DT_TM | DATETIME | Y | Date and time the transaction, which triggered the history row, occurred. This field can be system assigned or manually manipulated by users. |
TRANSACTION_REASON_CD | DOUBLE | N | Identifies the reason for the transaction. |
TRANSACTION_REASON_TXT | VARCHAR(100) | Y | Text that describes the reason for the transaction. |
TRANSACTION_TYPE_TXT | VARCHAR(4) | Y | Type of transaction that occurred. Example: UPDT, ATDS, etc. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
WORK_ITEM_PROC_IND | DOUBLE | N | Indicates whether the work item publication process has completed for the registration transaction. |
Relationship Detail - PM_HIST_TRACKING
Child Column in PM_HIST_TRACKING(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | AUTHORIZATION_ID | AUTHORIZATION | AUTHORIZATION_ID |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
FACILITY_ORG_ID | ORGANIZATION | ORGANIZATION_ID | |
PERSON_ID | PERSON | PERSON_ID |
Parent Column in PM_HIST_TRACKING (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | PM_HIST_TRACKING_ID | ADDRESS_HIST | PM_HIST_TRACKING_ID |
AUTHORIZATION_HIST | PM_HIST_TRACKING_ID | ||
AUTHORIZATION_ITEM_HIST | PM_HIST_TRACKING_ID | ||
AUTH_CODE_VALUE_R_HIST | PM_HIST_TRACKING_ID | ||
AUTH_DETAIL_HIST | PM_HIST_TRACKING_ID | ||
AUTH_ITEM_ORDER_R_HIST | PM_HIST_TRACKING_ID | ||
AUTH_MANAGEMENT_HIST | PM_HIST_TRACKING_ID | ||
AUTH_REFERRAL_RELTN_HIST | PM_HIST_TRACKING_ID | ||
AUTH_SCH_EVENT_RELTN_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_ACP_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_ALIAS_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_AMBULANCE_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_CATCHMENT_R_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_CLASSIFICTN_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_CODE_VALUE_R_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_FLEX_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_INFO_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_INPTNT_REHAB_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_LEAVE_HISTORY | PM_HIST_TRACKING_ID | ||
ENCNTR_LEGAL_AUTH_R_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_LOCATION_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_LOC_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_MEDICARE_MGMT_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_OCCURRENCE_CODE_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_PENDING_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_PERSON_RELTN_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_PLAN_AUTH_R_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_PLAN_COB_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_PLAN_COB_R_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_PLAN_DATE_PRD_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_PLAN_ELIG_BNFT_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_PLAN_ELIG_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_PLAN_RELTN_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_PRSNL_RELTN_HISTORY | PM_HIST_TRACKING_ID | ||
ENCNTR_SLICE_HIST | PM_HIST_TRACKING_ID | ||
ENCNTR_SOCIAL_HEALTH_HIST | PM_HIST_TRACKING_ID | ||
GUAR_FINANCIAL_RESP_HIST | PM_HIST_TRACKING_ID | ||
GUAR_FIN_RESP_RELTN_HIST | PM_HIST_TRACKING_ID | ||
PATIENT_EVENT_DETAIL_HIST | PM_HIST_TRACKING_ID | ||
PATIENT_EVENT_HIST | PM_HIST_TRACKING_ID | ||
PERSON_ALIAS_HIST | PM_HIST_TRACKING_ID | ||
PERSON_CODE_VALUE_R_HIST | PM_HIST_TRACKING_ID | ||
PERSON_DATA_NOT_COLL_HIST | PM_HIST_TRACKING_ID | ||
PERSON_DESIGNATION_HIST | PM_HIST_TRACKING_ID | ||
PERSON_DISMISSAL_ACTN_HIST | PM_HIST_TRACKING_ID | ||
PERSON_DISMISSAL_HIST | PM_HIST_TRACKING_ID | ||
PERSON_FIN_ASSET_HIST | PM_HIST_TRACKING_ID | ||
PERSON_FLEX_HIST | PM_HIST_TRACKING_ID | ||
PERSON_INFO_HIST | PM_HIST_TRACKING_ID | ||
PERSON_MILITARY_HIST | PM_HIST_TRACKING_ID | ||
PERSON_NAME_HIST | PM_HIST_TRACKING_ID | ||
PERSON_ORG_RELTN_HIST | PM_HIST_TRACKING_ID | ||
PERSON_PATIENT_HIST | PM_HIST_TRACKING_ID | ||
PERSON_PAY_PROPENSITY_HIST | PM_HIST_TRACKING_ID | ||
PERSON_PERSON_RELTN_HIST | PM_HIST_TRACKING_ID | ||
PERSON_PLAN_AUTH_R_HIST | PM_HIST_TRACKING_ID | ||
PERSON_PLAN_PROFILE_HIST | PM_HIST_TRACKING_ID | ||
PERSON_PLAN_PROFILE_R_HIST | PM_HIST_TRACKING_ID | ||
PERSON_PLAN_RELTN_HIST | PM_HIST_TRACKING_ID | ||
PERSON_PORTAL_INVITE_HIST | PM_HIST_TRACKING_ID | ||
PERSON_PREF_COMM_HIST | PM_HIST_TRACKING_ID | ||
PERSON_PREF_HIST | PM_HIST_TRACKING_ID | ||
PERSON_SOCIAL_HEALTH_HIST | PM_HIST_TRACKING_ID | ||
PERSON_TRIBAL_AFLTN_HIST | PM_HIST_TRACKING_ID | ||
PERSON_VETERAN_HIST | PM_HIST_TRACKING_ID | ||
PHONE_HIST | PM_HIST_TRACKING_ID | ||
PM_TRANSACTION | PM_HIST_TRACKING_ID | ||
PM_USER_DEFINED_HIST | PM_HIST_TRACKING_ID | ||
PM_WAIT_LIST_HIST | PM_HIST_TRACKING_ID | ||
RVC_COMMENT_HIST | PM_HIST_TRACKING_ID |
PM_LOCK
Column Section | Top of Page |
Table-level Detail
Description: | Person lock. |
Definition: | Stores identifiers of persons that are currently being accessed by a given user within a flexible ADT conversation. This table will be queried before any operation begins on a person to ensure that they are not being accessed by another user. |
Table Type: | ACTIVITY |
Column Detail - PM_LOCK
Column Name | Type | Null? | Definition |
---|---|---|---|
LOCK_DT_TM | DATETIME | N | Date and time the person was locked. Used to determine how long the lock has been in place and in lock timeout functionality. |
LOCK_ID | DOUBLE | N | This is the value of the unique primary identifier of the pm_lock table. It is an internal system assigned number. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. This is the person (patient) that is currently locked by another user. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
USER_ID | DOUBLE | N | The identifier, from the prsnl/person table, of the user that has gained the lock on the given person/patient denoted in the person_id column. |
PM_OFFER_PROC_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Patient Management Offer Procedure Relationship |
Definition: | Contains a series of links between individual Offers (in person management) and procedures. Each Offer represents a patient attendance, during which any number of procedures could occur. This table provides a reporting link between the patient attendance and the procedures coded against said attendance. |
Table Type: | ACTIVITY |
Column Detail - PM_OFFER_PROC_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
PM_OFFER_ID | DOUBLE | N | Uniquely identifies the related offer. |
PM_OFFER_PROC_RELTN_ID | DOUBLE | N | Uniquely identifies a relationship between individual Offers (in Person Management) and procedures. Each Offer represents a patient attendance, during which any number of procedures could occur. This table provides a reporting link between the patient attendance and the procedures coded against said attendance. |
PROCEDURE_ID | DOUBLE | N | Uniquely identifies the related procedure. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - PM_OFFER_PROC_RELTN
Child Column in PM_OFFER_PROC_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PM_OFFER_ID | PM_OFFER | PM_OFFER_ID |
PROCEDURE_ID | PROCEDURE | PROCEDURE_ID |
PM_PHY_ACT_HIST
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Physician activity history. |
Definition: | Physician activity history. |
Table Type: | ACTIVITY |
Column Detail - PM_PHY_ACT_HIST
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | N | The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc. |
ACTIVE_STATUS_CD | DOUBLE | N | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PHYSICIAN_STATUS_CD | DOUBLE | N | Physician status code identifies the status of the physician. (For Example: In, In Surgery, Out, etc.) |
PHY_ACT_HIST_ID | DOUBLE | N | This is the value of the unique primary identifier of the pm_phy_act_hist table. It is an internal system assigned number. |
PHY_ACT_HIST_TYPE_CD | DOUBLE | N | Activity type code identifies the type of activity that the physician did. (For Example: Changed Status, Logged In, Get Messages, etc.) |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. |
UPDT_CNT | DOUBLE | N | Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. |
UPDT_ID | DOUBLE | N | The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. |
Relationship Detail - PM_PHY_ACT_HIST
Child Column in PM_PHY_ACT_HIST(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PERSON | PERSON_ID |