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 |