Table Detail Report

DCP_DEVICE_LOCATION



Column Section Top of Page


Table-level Detail

Description: DCP DEVICE LOCATION
Definition: Specifies the Device that is installed in a given location
Table Type: REFERENCE





Column Detail - DCP_DEVICE_LOCATION


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 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.
DCP_DEVICE_LOCATION_ID DOUBLE N Device Location ID. Primary Key from CareNet_seq
DNS_NAME VARCHAR(255) Y Specifies the DNS name of the deviceColumn
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.
IP_ADDRESS VARCHAR(255) Y Specifies the IP address of the device
LOCATION_CD DOUBLE N Specifies the location the device is installed at
PASSWORD_TXT VARCHAR(100) N Specifies the password that should be used to gain access to the device.
PORT_NUMBER DOUBLE Y Specifies the port number for the IP Address
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.
USERNAME_TXT VARCHAR(50) N Specifies the user name that should be used to connect to the device


DCP_EQUATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP EQUATION
Definition: This is the parent table of the equations used in the DCP Online Clin Calculator
Table Type: REFERENCE





Column Detail - DCP_EQUATION


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.
ALLPOSITION_IND DOUBLE N All Position IndicatorColumn
BEGIN_AGE_FLAG DOUBLE Y identifies what the begin age is (hrs, days, wks, etc.) Column
BEGIN_AGE_NBR DOUBLE Y The number of days, weeks, months, etcColumn
CALCVALUE_DESCRIPTION VARCHAR(100) Y the label for the calculated valueColumn
DCP_EQUATION_ID DOUBLE N The unique identifier for the equationColumn
DESCRIPTION VARCHAR(100) Y The name of the equationColumn
DESCRIPTION_KEY VARCHAR(100) Y the name of the equationColumn
END_AGE_FLAG DOUBLE Y identifies what the end age is (hrs, days, wks, etc.) Column
END_AGE_NBR DOUBLE Y the number of weeks, days, etcColumn
EQUATION_CODE VARCHAR(250) Y A code determined by the tool that is used to identify the equationColumn
EQUATION_DISPLAY VARCHAR(250) Y The equation string that the user has typed into (a + b)Column
EQUATION_MEANING VARCHAR(12) Y A hardcode value to identify the equationColumn
GENDER_CD DOUBLE N the code that uniquely identifies a genderColumn
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 - DCP_EQUATION




Parent Column in DCP_EQUATION (PK) Child Table Name Child Column Name
Children: DCP_EQUATION_ID DCP_EQUA_COMPONENT DCP_EQUATION_ID
DCP_EQUA_POSITION DCP_EQUATION_ID


DCP_EQUA_COMPONENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP EQUA COMPONENT
Definition: This table contains each component as it relates to a dcp equation
Table Type: REFERENCE





Column Detail - DCP_EQUA_COMPONENT


Column Name Type Null? Definition
COMPONENT_CODE VARCHAR(5) Y A code determined by the db tool to identify the componentColumn
COMPONENT_DESCRIPTION VARCHAR(50) Y a description of the componentColumn
COMPONENT_FLAG DOUBLE Y identifies what kind component this isColumn
COMPONENT_LABEL VARCHAR(50) Y a label the user determines that will be used in the calc when displaying the component
CONSTANT_VALUE DOUBLE Y the value of a numeric constantColumn
CORRESPONDING_EQUATION_ID DOUBLE Y a number that uniquely identifies an equationColumn
DCP_COMPONENT_ID DOUBLE N a number that uniquely identifies the componentColumn
DCP_EQUATION_ID DOUBLE N A unique number that identifies an equation.Column
DUPLICATE_COMPONENT_NAME VARCHAR(50) Y Identifies the parent component of a duplicate
EVENT_CD DOUBLE Y a unique identifier to an event cdColumn
REQUIRED_IND DOUBLE Y identifies whether or not this component is required for this equationColumn
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 - DCP_EQUA_COMPONENT


Child Column in DCP_EQUA_COMPONENT(FK) Parent Table Name Parent Column Name
Parents: DCP_EQUATION_ID DCP_EQUATION DCP_EQUATION_ID




Parent Column in DCP_EQUA_COMPONENT (PK) Child Table Name Child Column Name
Children: DCP_COMPONENT_ID DCP_UNIT_MEASURE DCP_COMPONENT_ID
DCP_EQUATION_ID DCP_UNIT_MEASURE DCP_EQUATION_ID


DCP_EQUA_POSITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: This table holds the list of positions assigned to an equation
Definition: This table hold the lists of positins assigned to an equation
Table Type: REFERENCE





Column Detail - DCP_EQUA_POSITION


Column Name Type Null? Definition
DCP_EQUATION_ID DOUBLE N This is the unique identifier for the parent equation
POSITION_CD DOUBLE N code value for a specified positionColumn
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 - DCP_EQUA_POSITION


Child Column in DCP_EQUA_POSITION(FK) Parent Table Name Parent Column Name
Parents: DCP_EQUATION_ID DCP_EQUATION DCP_EQUATION_ID


DCP_PRSNL_LOC_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: DCP PRSNL LOC R
Definition: This table associates a personnel with a location_group.
Table Type: ACTIVITY





Column Detail - DCP_PRSNL_LOC_R


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.
END_TIME DATETIME Y Ending time of the assignmentColumn
LOCATION_CD DOUBLE N Code value of the location_groupColumn
NOTE VARCHAR(255) Y User-defined string containing clinician informationColumn
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
START_TIME DATETIME Y Starting time of the assignmentColumn
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 - DCP_PRSNL_LOC_R


Child Column in DCP_PRSNL_LOC_R(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PRSNL PERSON_ID