Table Detail Report
DSM_COMPONENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | DSM-IV Components desc |
Definition: | DSM-IV Components |
Table Type: | ACTIVITY |
Column Detail - DSM_COMPONENT
Column Name | Type | Null? | Definition |
---|---|---|---|
AXIS_FLAG | DOUBLE | Y | Axis the assessment is being performed on (1-5) |
COMPONENT_DESC1 | VARCHAR(255) | Y | Primary component description field |
COMPONENT_DESC2 | VARCHAR(255) | Y | Secondary component description field |
COMPONENT_SEQ | DOUBLE | Y | User defined sequencing for order of precedence and component display purposes. |
DSM_ASSESSMENT_ID | DOUBLE | N | Unique identifier for the overall assessment |
DSM_COMPONENT_ID | DOUBLE | N | Unique identifier for the individual assessment component |
NOMENCLATURE_ID | DOUBLE | N | The DSM-IV or ICD-9 unique identifier |
PRIMARY_DIAG_IND | DOUBLE | Y | Indicates whether the component is the primary component for its particular axis. Override component_seq order of precedence |
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 - DSM_COMPONENT
Child Column in DSM_COMPONENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DSM_ASSESSMENT_ID | DSM_ASSESSMENT | DSM_ASSESSMENT_ID |
NOMENCLATURE_ID | NOMENCLATURE | NOMENCLATURE_ID |
EVENT_REFERENCE_RELTN
Column Section | Top of Page |
Table-level Detail
Description: | Event reference reltn is used to cross reference events |
Definition: | Event reference reltn is used to cross reference anticipated documents with documents that come through a transcription interface |
Table Type: | REFERENCE |
Column Detail - EVENT_REFERENCE_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. |
EVENT_CD | DOUBLE | N | The code value for document type |
INPUT_CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | The code value of a foreign system |
INPUT_REFERENCE_NBR | VARCHAR(60) | N | The reference number from inbound foreign system |
REFERENCE_NBR | VARCHAR(60) | N | The clinical event reference number |
RESULT_STATUS_CD | DOUBLE | N | result status code |
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. |
EVENT_SIGNATURE_FLEX
Column Section | Top of Page |
Table-level Detail
Description: | EVENT SIGNATURE FLEX |
Definition: | Table stores position codes that we are requiring co signatures from |
Table Type: | REFERENCE |
Column Detail - EVENT_SIGNATURE_FLEX
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. |
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. |
EVENT_SIGNATURE_FLEX_ID | DOUBLE | N | Unique ID for table |
POSITION_CD | DOUBLE | Y | Position of the personnel requiring co-signatures |
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. |
FLEX_CONTROL
Column Section | Top of Page |
Table-level Detail
Description: | This table is used by Flex to store controls. |
Definition: | In addition to the Flex Tool, the engine also reads this table for the Flexible Regisrtation. |
Table Type: | REFERENCE |
Column Detail - FLEX_CONTROL
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. |
BACKCOLOR | DOUBLE | Y | This hold a Visual Basic backcolor to describe the backcolor of the control. |
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. |
CODESET | DOUBLE | Y | Codeset. |
DESCRIPTION | VARCHAR(255) | Y | This is a description of the control. |
DISPLAY_ONLY_IND | DOUBLE | Y | This indicator tells the Engine whether or not this control is display only. |
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. |
FIELD | VARCHAR(255) | Y | This is and actual v500 database field that can and will be used to add update and delete to the database. |
FLEX_CONTROL_ID | DOUBLE | N | Sequence to the actual control. |
FONT_BOLD_IND | DOUBLE | Y | This indicates whether the given font is bold or not. |
FONT_ITALIC_IND | DOUBLE | Y | This indicates whether the given font is italic or not. |
FONT_NAME | VARCHAR(100) | Y | The Win32 font name chosen for the given control. |
FONT_SIZE | DOUBLE | Y | The Win32 font size chosen for the given control. |
FORECOLOR | DOUBLE | Y | The fore color of the given control, it may or may not effect the color of the text. |
HEIGHT | DOUBLE | Y | The height of the control given in twips. |
LABEL | VARCHAR(255) | Y | The Label for the control. |
LABEL_PSN | DOUBLE | Y | The position of the label. |
LEFT | DOUBLE | Y | Left value for the control given in twips. |
LONG_TEXT_ID | DOUBLE | Y | The long_text_id for the control., Used to tie it to a script |
PARENT_ENTITY_ID | DOUBLE | Y | The parent entity id of the control. |
PARENT_ENTITY_NAME | VARCHAR(32) | Y | The parent name of the control. |
REQUIRED_IND | DOUBLE | Y | This tells the engine whether or not a user must enter something in this field. |
TABORDER | DOUBLE | Y | The taborder of the given control. |
TOP | DOUBLE | Y | The top value in twips for the given control. |
TYPE | VARCHAR(12) | Y | This is a string telling us what kind of control we are dealing with. |
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. |
USER_DEFINED_IND | DOUBLE | Y | This indicator will tell us whether this is a 'Cerner' defined field or whether the user created this field at run time. |
WIDTH | DOUBLE | Y | This is the value of the width of the given control in twips. |
FLEX_DATA_SOURCE
Column Section | Top of Page |
Table-level Detail
Description: | FLEX DATA SOURCE |
Definition: | Contains the data sources or tree parents for the Flex Tool. Cerner Defined. |
Table Type: | REFERENCE |
Column Detail - FLEX_DATA_SOURCE
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 | 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. |
DESCRIPTION | VARCHAR(255) | Y | This is the description of the data source as viewed in the treeview in the flex tool. |
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. |
FLEX_DATA_SOURCE_ID | DOUBLE | N | This is an id that is generated for every data source that gets added to the system. |
PARENT_ID | DOUBLE | Y | This id will allow us to build a tree structure. |
PRODUCT | DOUBLE | Y | This field is used by the engine to give PM the ability to allow other Cerner Product Groups access to our tables. |
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. |