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