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.