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