Table Detail Report
RAD_BILL_CATEGORIES
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Rad Bill Only Categories |
Definition: | The Rad_Bill_Categories table contains the relationship between a category and task assays. |
Table Type: | REFERENCE |
Column Detail - RAD_BILL_CATEGORIES
Column Name | Type | Null? | Definition |
---|---|---|---|
BILL_CAT_CD | DOUBLE | N | The Bill_Cat_Cd uniquely identifies a row in the Rad_Bill_Categories table. It serves no other purpose other than to uniquely identify the row. |
TASK_ASSAY_CD | DOUBLE | N | The Task_Assay_Cd is a foreign key to the Discrete_Task_Assay table. It identifies the bill only that is assigned to this category. |
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 - RAD_BILL_CATEGORIES
Child Column in RAD_BILL_CATEGORIES(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | TASK_ASSAY_CD | DISCRETE_TASK_ASSAY | TASK_ASSAY_CD |
RAD_CONFIGURATION
Column Section | Top of Page |
Table-level Detail
Description: | RadNet Configuration |
Definition: | This table contains configuration settings specific to radnet. |
Table Type: | REFERENCE |
Column Detail - RAD_CONFIGURATION
Column Name | Type | Null? | Definition |
---|---|---|---|
PARAMETER_DESC | VARCHAR(255) | Y | The parameter_desc field conations descriptive information about a parameter |
PARAMETER_NAME | VARCHAR(60) | N | The parameter_name field names a radiology configuration parameter |
RAD_CONFIGURATION_ID | DOUBLE | N | The Rad_Configuration_Id uniquely identifies a row in the Rad_Configuration table. It serves no other purpose other than to uniquely identify the row |
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. |
VALUE_DT_TM | DATETIME | Y | The value_date field contains date data about a parameter |
VALUE_NUM | DOUBLE | Y | The value_num field contains numerical data about a parameter |
VALUE_TEXT | VARCHAR(255) | Y | The value_text field contains textual data about a parameter |
RAD_CONFIG_DATA
Column Section | Top of Page |
Table-level Detail
Description: | Configuration data for system controls. |
Definition: | This table holds RadNet system configuration data. This table is meant to replace tables that are specific to certain functionality. |
Table Type: | REFERENCE |
Column Detail - RAD_CONFIG_DATA
Column Name | Type | Null? | Definition |
---|---|---|---|
BREAST_DENSITY_TEXT | VARCHAR(2000) | Y | Contains the Breast Density Statement for the given Parent Entity Id. |
CONTROL_CHAR | VARCHAR(255) | Y | Holds the string value of the control named by control_name. |
CONTROL_DT_TM | DATETIME | Y | Holds the date/time value of the control named by control_name. |
CONTROL_NAME | VARCHAR(255) | Y | The name of the specific database setting. |
CONTROL_NUMBER | DOUBLE | N | Holds the numeric value of the control named by control_name. |
DOMAIN_CD | DOUBLE | N | Describes the group of settings that this row pertains to. |
PARENT_ENTITY_ID | DOUBLE | N | The primary id of the table that this row is a child of. |
PARENT_ENTITY_NAME | VARCHAR(255) | Y | The name of the table that the row on this table is a child of. |
RAD_CONFIG_DATA_ID | DOUBLE | N | The rad_config_data_id uniquely identifies a row in the Rad_config_data table. It serves no other purpose other than to uniquely identify the row. |
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. |
RAD_DEF_SERV_RES
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Rad Default Service Resources |
Definition: | The Rad_Def_Serv_Res table contains default locations for other service resources. (ex. folder check-in location for a library group) |
Table Type: | REFERENCE |
Column Detail - RAD_DEF_SERV_RES
Column Name | Type | Null? | Definition |
---|---|---|---|
DEF_SER_RES_CD | DOUBLE | N | The Def_Ser_Res_Cd is a foreign key to the Service_Resource table. This identifies a service resource that is used for a specific purpose by another location. |
SERVICE_RESOURCE_CD | DOUBLE | N | The Service_Resource_Cd identifies a service resource that is having a default location set up. |
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. |
USAGE_CD | DOUBLE | N | The Usage_Cd identifies what the default location is used for by the service resource. |
Relationship Detail - RAD_DEF_SERV_RES
Child Column in RAD_DEF_SERV_RES(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | DEF_SER_RES_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
RAD_EXAM_ROOM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Rad Exam Room |
Definition: | The Rad_Exam_Room table is a child of the service_resource table and contains information specific to the exam rooms where radiology procedures are performed. |
Table Type: | REFERENCE |
Column Detail - RAD_EXAM_ROOM
Column Name | Type | Null? | Definition |
---|---|---|---|
MPPS_RESET_IND | DOUBLE | N | This field indicates whether the system will allow MPPS to reset procedures. |
MPPS_START_IND | DOUBLE | N | This field indicates whether the system will allow MPPS to start procedures performed in this room. |
SERVICE_RESOURCE_CD | DOUBLE | N | The Service_Resource_Cd is a foreign key to the Service_Resource table. It uniquely identifies the exam room. |
TEMP_MULTI_FLAG | DOUBLE | Y | The Temp_Multi_Flag indicates if temporary tracking of multi day studies are being done within the exam room. |
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 - RAD_EXAM_ROOM
Child Column in RAD_EXAM_ROOM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
Parent Column in RAD_EXAM_ROOM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SERVICE_RESOURCE_CD | EXAM_ROOM_LIB_GRP_RELTN | SERVICE_RESOURCE_CD |