Table Detail Report

PM_WORK_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Person Management Work Queue
Definition: Table that holds queued work items.
Table Type: ACTIVITY





Column Detail - PM_WORK_QUEUE


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.
COMPLETED_BY_ID DOUBLE N Person who completed the task.
COMPLETED_DT_TM DATETIME Y Date and time the task was completed.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
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.
REQ_BED_CD DOUBLE N Code value for a bed that was requested.
REQ_BUILDING_CD DOUBLE N Code Value for a requested building.
REQ_FACILITY_CD DOUBLE N Code Value for a requested facility.
REQ_NURSE_UNIT_CD DOUBLE N Code value for a requested nurse unit.
REQ_ROOM_CD DOUBLE N Code value for a requested room.
TRANSACTION_TXT VARCHAR(100) Y Field for text transaction description.
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.
WORK_ITEM_ID DOUBLE N Foreign key attribute associating the row to a specific work item (from the pm_que_work_item table).
WORK_QUEUE_DT_TM DATETIME Y Date and Time a particular work item was put into the queue.
WORK_QUEUE_ID DOUBLE N Primary Key for this table.



Relationship Detail - PM_WORK_QUEUE


Child Column in PM_WORK_QUEUE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID


PPR_CONSENT_STATUS



Column Section Relationship Section Top of Page


Table-level Detail

Description: PPR Consent Status
Definition: This table contains the consent status for a person at an encounter, org, or person level.
Table Type: ACTIVITY





Column Detail - PPR_CONSENT_STATUS


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 Y 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.
BLOB_REF_SCAN_ID DOUBLE N Blob reference id for a scanned in documents
COMMENT_TXT VARCHAR(250) Y A free text comment for the consent status.
CONSENT_ID DOUBLE N This is the consent_id that is constant across different versions. Use this for the retrieving the data.
CONSENT_PARENT_ENTITY_ID DOUBLE N Parent Entity Id, such as encntr_id, order_catalog_cd etc.,
CONSENT_PARENT_ENTITY_NAME VARCHAR(30) Y Parent Entity name, such as encounter, order, person etc,
CONSENT_POLICY_ID DOUBLE N The Policy for which the status has been captured.
CONSENT_STATUS_ID DOUBLE N The primary key on this table.
CONSENT_TYPE_CD DOUBLE N Type of the Consent. Examples are privacy, record access, consent to treat, etc.
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.
DOCUMENT_ON_FILE_IND DOUBLE Y Indicator whether the document is on-file.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
END_EFFECTIVE_DT_TM DATETIME Y 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.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
PARENT_ENTITY_ID DOUBLE N PARENT ENTITY IDENTIFIER
PARENT_ENTITY_NAME VARCHAR(32) N Name of entity specified in PARENT_ENTITY_ID.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
REASON_CD DOUBLE N The Reason for the status, based on the status.
STATUS_CD DOUBLE N Status of the Consent.
STATUS_CHANGE_REASON_CD DOUBLE N Codified Reason for the change in status. This field will be empty for a new consent
STATUS_CHANGE_REASON_TEXT VARCHAR(255) Y Free Text Reason for the change in status, this will be filled out only if the codified reason has a cdf meaning of OTHER
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 - PPR_CONSENT_STATUS


Child Column in PPR_CONSENT_STATUS(FK) Parent Table Name Parent Column Name
Parents: BLOB_REF_SCAN_ID BLOB_REFERENCE BLOB_REF_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
CONSENT_POLICY_ID PPR_CONSENT_POLICY CONSENT_POLICY_ID


PREEXIST_CONDITION



Column Section Relationship Section Top of Page


Table-level Detail

Description:
Definition:
Table Type: ACTIVITY





Column Detail - PREEXIST_CONDITION


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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 Y 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.
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.
DESCRIPTION VARCHAR(200) Y
END_EFFECTIVE_DT_TM DATETIME Y 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.
NOMENCLATURE_ID DOUBLE N
PERSON_PLAN_RELTN_ID DOUBLE N
PREEXIST_ID DOUBLE N Uniquely identifies a row on the PREEXIST_CONDITION 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_PRSNL_ID DOUBLE N
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 - PREEXIST_CONDITION


Child Column in PREEXIST_CONDITION(FK) Parent Table Name Parent Column Name
Parents: PERSON_PLAN_RELTN_ID PERSON_PLAN_RELTN PERSON_PLAN_RELTN_ID


PRODUCT_DEFAULT_ADDRESS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Product Default Address
Definition: Identifies the sequence of preferred addressing by Product.
Table Type: ACTIVITY





Column Detail - PRODUCT_DEFAULT_ADDRESS


Column Name Type Null? Definition
ADDRESS_ID DOUBLE N The ADDRESS_ID value inherited from the ADDRESS table.
ADDRESS_SEQ DOUBLE N Numeric sequence that determines the priority or precedence that one address row has over another for a given product.
PRODUCT_CD DOUBLE N The code value that identifies the Product for which the Address sequence applies.
PRODUCT_DEFAULT_ADDRESS_ID DOUBLE N This is the surrogate primary key column used to uniquely identify rows for this table.
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 - PRODUCT_DEFAULT_ADDRESS


Child Column in PRODUCT_DEFAULT_ADDRESS(FK) Parent Table Name Parent Column Name
Parents: ADDRESS_ID ADDRESS ADDRESS_ID


REVIEW_GROUP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: REVIEW GROUP RELTN
Definition: Review Group Relationship.
Table Type: ACTIVITY





Column Detail - REVIEW_GROUP_RELTN


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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 Y 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 Y 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.
DATA_STATUS_CD DOUBLE N Data status indicates a level of authenticity of the row data. Typically this will either be AUTHENTICATED or UNAUTHENTICATED.
DATA_STATUS_DT_TM DATETIME Y The date and time that the data_status_cd was set.
DATA_STATUS_PRSNL_ID DOUBLE N The person who caused the data_status_cd to be set or change.
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
END_EFFECTIVE_DT_TM DATETIME Y 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.
ORGANIZATION_ID DOUBLE N This is the value of the unique primary identifier of the organization table. It is an internal system assigned number.
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the address row is related (i.e., person_id, organization_id, etc.)
PARENT_ENTITY_NAME VARCHAR(30) N The upper case name of the table to which this address row is related (i.e., PERSON, PRSNL, ORGANIZATION, etc.)
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
REVIEW_GROUP_RELTN_ID DOUBLE N Review Group Reltn Id - Primary key
REVIEW_RELTN_FLAG DOUBLE Y Review Reltn Flag - This flag helps determine what reference review reltn this activity data was produced from.
SEQ_NBR DOUBLE Y Sequence Number - Maintains order of review relationships to a given person plan reltn or encounter plan reltn.
SPECIALTY_CD DOUBLE N Review Group Specialty Code.
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 - REVIEW_GROUP_RELTN


Child Column in REVIEW_GROUP_RELTN(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID