Table Detail Report

PM_DOC_DESTINATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: PM_DOC_DESTINATION
Definition: Document routing destinations.
Table Type: REFERENCE





Column Detail - PM_DOC_DESTINATION


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 Y 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 Y The person who caused the active_status_cd to be set or change.
BATCH_IND DOUBLE Y Flag to determine whether this destination will print to the PM batch document que (PM_DOC_BATCH_PRINT table)
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.
COPIES DOUBLE Y Number of copies of the document to print to this destination
DESTINATION_ID DOUBLE N Primary key (sequence generated).
DISTRIBUTION_ID DOUBLE N Foreign key attribute associating the destination with a specific distribution on the pm_doc_distribution table
DOCUMENT_ID DOUBLE N Foreign key attribute associating the destination to a specific document on the pm_doc_document table.
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.
OUTPUT_DEST_CD DOUBLE Y The output destination (printer) for this destination. Can be multiple Code Sets.
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_DOC_DESTINATION


Child Column in PM_DOC_DESTINATION(FK) Parent Table Name Parent Column Name
Parents: DISTRIBUTION_ID PM_DOC_DISTRIBUTION DISTRIBUTION_ID
DOCUMENT_ID PM_DOC_DOCUMENT DOCUMENT_ID


PM_DOC_DISTRIBUTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: PM DOC DISTRIBUTION
Definition: Defines the distributions for PM Document routings
Table Type: REFERENCE





Column Detail - PM_DOC_DISTRIBUTION


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 Y 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 Y 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.
DISTRIBUTION_DESC CHAR(100) Y Free-text description of the distribution
DISTRIBUTION_ID DOUBLE N Primary key
DISTRIBUTION_NAME CHAR(32) N The name of the distribution
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.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on 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 - PM_DOC_DISTRIBUTION


Child Column in PM_DOC_DISTRIBUTION(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID




Parent Column in PM_DOC_DISTRIBUTION (PK) Child Table Name Child Column Name
Children: DISTRIBUTION_ID PM_DOC_DESTINATION DISTRIBUTION_ID
PM_DOC_DIST_FILTER DISTRIBUTION_ID


PM_DOC_DOCUMENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: PM DOC DOCUMENT
Definition: Stores name, description, ccl object name of PM Documents
Table Type: REFERENCE





Column Detail - PM_DOC_DOCUMENT


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 Y 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 Y 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.
DOCUMENT_DESC CHAR(100) Y Free-text description of the document
DOCUMENT_ID DOUBLE N Primary key
DOCUMENT_NAME CHAR(32) N The Name of the document.
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.
PROGRAM_NAME CHAR(32) N CCL object name to be executed for the PM Document
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_DOC_DOCUMENT




Parent Column in PM_DOC_DOCUMENT (PK) Child Table Name Child Column Name
Children: DOCUMENT_ID PM_DOC_DESTINATION DOCUMENT_ID
PM_DOC_PRINT_HIST PRINTED_DOCUMENT_ID


PM_DOC_PRINT_HIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Patient Management Document Print History
Definition: Provides the history of documents printed from practice management.
Table Type: ACTIVITY





Column Detail - PM_DOC_PRINT_HIST


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N Uniquely identifies the encounter related to the printed document.
OUTPUT_DESTINATION_ID DOUBLE N Uniquely identifies the output destination to which the document was distributed.
PERSON_ID DOUBLE N Uniquely identifies the person for whom the document was printed.
PM_DOC_PRINT_HIST_ID DOUBLE N Computer generated number to uniquely identify a row on the PM_DOC_PRINT_HIST table.
PRINTED_BY_PRSNL_ID DOUBLE N Uniquely identifies the person who printed the document.
PRINTED_DOCUMENT_ID DOUBLE N Uniquely identifies the document that was printed.
PRINTED_DT_TM DATETIME N The date and time the document was printed.
PRINTED_FILE_NAME VARCHAR(100) N The file name of the document that was printed.
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_DOC_PRINT_HIST


Child Column in PM_DOC_PRINT_HIST(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
OUTPUT_DESTINATION_ID OUTPUT_DEST OUTPUT_DEST_CD
PERSON_ID PERSON PERSON_ID
PRINTED_DOCUMENT_ID PM_DOC_DOCUMENT DOCUMENT_ID
PRINTED_BY_PRSNL_ID PRSNL PERSON_ID


PM_FILTER



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table contains relationships for a filter and filter values.
Definition: This table holds the relationship for a filter.
Table Type: REFERENCE





Column Detail - PM_FILTER


Column Name Type Null? Definition
APP_FLAG DOUBLE N Flag used to indicate what type of application the filter is for.
CODE_SET DOUBLE Y Code set used for coded filter type
FILTER_NAME VARCHAR(40) N Name for the filter.
MULTIPLES_IND DOUBLE N Flag that indicates whether filter has multiple default values.
OPTIONS_BIT DOUBLE Y Options bit used to store attributes of the filter
PM_FILTER_ID DOUBLE N primary key
TYPE_FLAG DOUBLE N Flag used to indicate type for the filter value.
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_FILTER




Parent Column in PM_FILTER (PK) Child Table Name Child Column Name
Children: PM_FILTER_ID PM_FILTER_VALUES PM_FILTER_ID