Table Detail Report

PROCEDURE_ORDER_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Procedure Order Relationship
Definition: This table associates Procedures to Orders. This relationship is needed to comply with USCDI regulations.
Table Type: ACTIVITY





Column Detail - PROCEDURE_ORDER_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.
ORDER_ID DOUBLE Y The ID of the order associated to the procedure. It is a foreign key to the Orders table.
PROCEDURE_ID DOUBLE Y The ID of the procedure associated to the order. It is a foreign key to the Procedure table.
PROCEDURE_ORDER_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the PROCEDURE_ORDER_RELTN table.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 - PROCEDURE_ORDER_RELTN


Child Column in PROCEDURE_ORDER_RELTN(FK) Parent Table Name Parent Column Name
Parents: ORDER_ID ORDERS ORDER_ID
PROCEDURE_ID PROCEDURE PROCEDURE_ID


PROCEDURE_PROCEDURE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Procedure Procedure Relation
Definition: Relates Millennium concept Procedure to a Procedure.
Table Type: ACTIVITY





Column Detail - PROCEDURE_PROCEDURE_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.
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.
CHILD_PROCEDURE_ID DOUBLE Y Forgein key, Unique generated number that identifies a single row on the PROCEDURE table [Primary key id from the PROCEDURE 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.
PARENT_PROCEDURE_ID DOUBLE Y Foreign key, Unique generated number that identifies a single row on the PROCEDURE table [Primary key id from the PROCEDURE table].
PROCEDURE_PROCEDURE_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the PROCEDURE_PROCEDURE_RELTN 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 - PROCEDURE_PROCEDURE_RELTN


Child Column in PROCEDURE_PROCEDURE_RELTN(FK) Parent Table Name Parent Column Name
Parents: CHILD_PROCEDURE_ID PROCEDURE PROCEDURE_ID
PARENT_PROCEDURE_ID PROCEDURE PROCEDURE_ID


PROC_MODIFIER



Column Section Top of Page


Table-level Detail

Description: Procedure Modifier
Definition: Holds modifiers to procedures.
Table Type: ACTIVITY





Column Detail - PROC_MODIFIER


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 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.
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.
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.
GROUP_SEQ DOUBLE Y Supports multiple groups of the modifier
NOMENCLATURE_ID DOUBLE N Unique identifier for nomenclature item.
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the row is related ( procedure_id, diagnosis_id, drg_id ).
PARENT_ENTITY_NAME VARCHAR(32) N The upper case name of the table to which this row is related ( PROCEDURE, DIAGNOSIS, DRG ).
PROC_MODIFIER_ID DOUBLE N Unique identifier for row on PROC_MODIFIER table.
SEQUENCE DOUBLE Y Supports multiple nomenclature items as part of a single modifier.
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.


PROC_PRSNL_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: PROC PRSNL RELTN
Definition: Procedure Personnel Relationship
Table Type: ACTIVITY





Column Detail - PROC_PRSNL_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.
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.
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.
FREE_TEXT_CD DOUBLE N Free text code
FT_PRSNL_NAME DOUBLE Y This is the free text name
PROCEDURE_ID DOUBLE N This is the value of the unique primary identifier of the procedure table. It is an internal system assigned number.
PROC_FT_PRSNL VARCHAR(255) Y Free-text text field for who did the procedure
PROC_PRSNL_FT_IND DOUBLE Y Indicates that who did it was entered as a free-text
PROC_PRSNL_RELTN_CD DOUBLE N Identifies the specific type of relationship between a procedure and personnel.
PROC_PRSNL_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the procedure personnel relationship table. It is an internal system assigned number.
PRSNL_PERSON_ID DOUBLE N This is the value of the unique primary identifier of the personnel table. It is an internal system assigned number.
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 - PROC_PRSNL_RELTN


Child Column in PROC_PRSNL_RELTN(FK) Parent Table Name Parent Column Name
Parents: PROCEDURE_ID PROCEDURE PROCEDURE_ID
PRSNL_PERSON_ID PRSNL PERSON_ID


PRSNL_SUSPENSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Personnel Suspension Table
Definition: Stores physician suspension data for a given doctor for multiple facilities.
Table Type: ACTIVITY





Column Detail - PRSNL_SUSPENSION


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.
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.
FREETEXT_COMMENT VARCHAR(255) Y Comment field for suspensions.
ORGANIZATION_ID DOUBLE N Unique identifier for Organization table.
PRSNL_ID DOUBLE N Unique identifier for Prsnl table.
PRSNL_SUSPENSION_ID DOUBLE N Unique identifier for Prsnl_Suspension table.
SUSPENDED_CHARTS DOUBLE Y The number of charts for the personnel that qualified for suspension when the suspension was created.
SUSPENDED_DOCUMENTS DOUBLE Y The number of documents for the personnel that qualified for suspension when the suspension was created.
SUSPENDED_ORDERS DOUBLE N The number of orders for the personnel that qualified for suspension when the suspension was created.
SUSP_BEGIN_DT_TM DATETIME Y Beginning date and time for a suspension. Will always have a time of "00:00:00.00"
SUSP_BEGIN_TZ DOUBLE N suspension begin time zone
SUSP_END_DT_TM DATETIME Y Ending date and time for a suspension. Will always have a time of "23:59:59.00"
SUSP_END_TZ DOUBLE N suspension end time zone
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 - PRSNL_SUSPENSION


Child Column in PRSNL_SUSPENSION(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PRSNL_ID PRSNL PERSON_ID