REF_TEXT
Column Section | Top of Page |
Table-level Detail
Description: | Stores reference text. |
Definition: | Stores the reference text to be associated with order catalogs, tasks and other attributes. |
Table Type: | REFERENCE |
Column Detail - REF_TEXT
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. |
REFR_TEXT_ID | DOUBLE | N | The key to the table identifying the reference text. |
REF_TEXT_NAME | VARCHAR(100) | Y | Ref text name |
TEXT_ENTITY_ID | DOUBLE | N | The id of where the text is being stored, for example may be a long_text_id. |
TEXT_ENTITY_NAME | VARCHAR(32) | Y | The name of text type that is stored. For example could be 'LONG TEXT'. |
TEXT_LOCATOR | VARCHAR(50) | Y | A location of the text to be displayed, could be a directory or web page address. |
TEXT_TYPE_CD | DOUBLE | N | Defines what type of text this is, for example Patient Education, Nursing Preps, etc. |
TEXT_TYPE_FLAG | DOUBLE | Y | Field to identify what type of text has been built for this entity. |
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. |
REF_TEXT_FACILITY_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | REF TEXT FACILITY R |
Definition: | Stores the reference text to facility relationship |
Table Type: | REFERENCE |
Column Detail - REF_TEXT_FACILITY_R
Column Name | Type | Null? | Definition |
---|---|---|---|
FACILITY_CD | DOUBLE | N | Identifies the facility (zero means this is a default reference text, show this reference text unless another reference text is specified for a specific facility) |
PARENT_ENTITY_ID | DOUBLE | N | The id of the entity the text is being associated with, may be an Order Catalog CD or some other id/cd. |
PARENT_ENTITY_NAME | VARCHAR(32) | N | The name of the type of entity you are associating the text too, for example ORDERCATALOG. |
REF_TEXT_VARIATION_ID | DOUBLE | N | The id of the reference text. Foreign Key from the REF_TEXT_VARIATION table. |
TEXT_TYPE_CD | DOUBLE | N | Represents the type of reference text |
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 - REF_TEXT_FACILITY_R
Child Column in REF_TEXT_FACILITY_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REF_TEXT_VARIATION_ID | REF_TEXT_VARIATION | REF_TEXT_VARIATION_ID |
REF_TEXT_RELTN
Column Section | Top of Page |
Table-level Detail
Description: | Reference Text Relationship |
Definition: | This table is used to establish the relationship between the Reference Text to the entity the text exists for. |
Table Type: | REFERENCE |
Column Detail - REF_TEXT_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_DT_TM | DATETIME | N | Indicates the last time that the ACTIVE_IND was toggled. |
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_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. |
PARENT_ENTITY_ID | DOUBLE | N | The id of the Entity the text is being associated with, may be an Order Catalog CD or some other id/cd. |
PARENT_ENTITY_NAME | VARCHAR(32) | N | The name of the type of entity you are associating the text too, for example ORDERCATALOG or DISCRETEASSAY. |
REFR_TEXT_ID | DOUBLE | N | The id for the text to be associated with this entity. |
REF_TEXT_RELTN_ID | DOUBLE | N | The id to identify the relationship between an attribute and a piece of reference text. |
TEXT_TYPE_CD | DOUBLE | N | The type of text that is built for this entity. |
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. |
REF_TEXT_VARIATION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Reference Text Variation |
Definition: | Stores the reference text to parent_entity relationship. Used to depict different pieces of reference text for a parent_entity |
Table Type: | REFERENCE |
Column Detail - REF_TEXT_VARIATION
Column Name | Type | Null? | Definition |
---|---|---|---|
PARENT_ENTITY_ID | DOUBLE | N | The id of the entity the text is being associated with, may be an Order Catalog CD or some other id/cd. |
PARENT_ENTITY_NAME | VARCHAR(32) | N | The name of the type of entity you are associating the text too, for example ORDERCATALOG. |
REF_TEXT_NAME | VARCHAR(100) | Y | Represents the name of the reference text |
REF_TEXT_VARIATION_ID | DOUBLE | N | The ID of the reference text. Primary key. |
TEXT_TYPE_CD | DOUBLE | N | Represents the type of reference text |
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 - REF_TEXT_VARIATION
Parent Column in REF_TEXT_VARIATION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | REF_TEXT_VARIATION_ID | REF_TEXT_FACILITY_R | REF_TEXT_VARIATION_ID |
REF_TEXT_VERSION | REF_TEXT_VARIATION_ID |
REF_TEXT_VERSION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Reference Text Version |
Definition: | Stores the reference text version information |
Table Type: | REFERENCE |
Column Detail - REF_TEXT_VERSION
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. |
AUTO_INVOKE_PREP_IND | DOUBLE | N | Automatically invoke Nurse Preparations with-in Powerchart |
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. |
LONG_BLOB_ID | DOUBLE | N | The id of the long blob associated to this version of reference text. Foreign key from LONG_BLOB_REFERENCE table. |
REF_TEXT_VARIATION_ID | DOUBLE | N | The id of the reference text |
REF_TEXT_VERSION_ID | DOUBLE | N | The id of the reference text version |
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 - REF_TEXT_VERSION
Child Column in REF_TEXT_VERSION(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LONG_BLOB_ID | LONG_BLOB_REFERENCE | LONG_BLOB_ID |
REF_TEXT_VARIATION_ID | REF_TEXT_VARIATION | REF_TEXT_VARIATION_ID |