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 |