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