Table Detail Report
RAD_PROTOCOL_DEFINITION
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | RadNet Protocol Definition |
Definition: | Stores instructions about how to perform tasks related to an orderable. |
Table Type: | REFERENCE |
Column Detail - RAD_PROTOCOL_DEFINITION
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. |
PROTOCOL_DESC_TXT | VARCHAR(512) | N | Description of the protocol. |
PROTOCOL_NAME | VARCHAR(40) | N | The name of the protocol. |
RAD_PROTOCOL_DEFINITION_ID | DOUBLE | N | Unique, generated number that identifies a single row on the RAD_PROTOCOL_DEFINITION table. |
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_PROTOCOL_DEFINITION
Parent Column in RAD_PROTOCOL_DEFINITION (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RAD_PROTOCOL_DEFINITION_ID | RAD_PROTOCOL_ACT | PROTOCOL_ID |
RAD_PROTOCOL_ACT_HIST | PROTOCOL_ID | ||
RAD_PROTOCOL_CATALOG_R | RAD_PROTOCOL_DEFINITION_ID |
RAD_QUESTIONS
Column Section | Top of Page |
Table-level Detail
Description: | Rad Questions |
Definition: | The Rad_Questions table contains the questions that are used within the system controls database tools. |
Table Type: | REFERENCE |
Column Detail - RAD_QUESTIONS
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. |
APPLICATION_NAME | VARCHAR(30) | Y | The Application_Name identifies the system control application that the questions are a part of. |
QUESTION_ID | DOUBLE | N | The Question_Id uniquely identifies a row in the Rad_Questions table. It serves no other purpose other than to uniquely identify the row. |
QUESTION_TEXT | VARCHAR(255) | Y | The Question_Text field contains the actual question that will appear in the application. |
RESP_TYPE_FLAG | DOUBLE | Y | The Resp_Type_Flag indicates what form of an answer is produced from answering the question. (ex. yes/no, multiple choice, numeric) |
SEQUENCE | DOUBLE | Y | The Sequence field indicates what order the questions should appear within the application. |
TABLE_COLUMN | VARCHAR(35) | Y | The Table_Column identifies the field that is populated by the answer to the question. |
TABLE_NAME | VARCHAR(35) | Y | The Table_Name identifies the table that the Table_Column exists upon. |
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_RELEVANT_PRIOR_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | RadNet Relevant Prior Relation |
Definition: | Contains the orderables to be used as relevant priors for a specific orderable. |
Table Type: | REFERENCE |
Column Detail - RAD_RELEVANT_PRIOR_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
CATALOG_CD | DOUBLE | N | The orderable with priors defined. |
PRIOR_CATALOG_CD | DOUBLE | N | The orderable that is a prior of the catalog_cd |
RAD_RELEVANT_PRIOR_RELTN_ID | DOUBLE | N | Unique generated number that identifies a single row on the RAD_RELEVANT_PRIOR_RELTN table. |
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_RELEVANT_PRIOR_RELTN
Child Column in RAD_RELEVANT_PRIOR_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATALOG_CD | ORDER_CATALOG | CATALOG_CD |
PRIOR_CATALOG_CD | ORDER_CATALOG | CATALOG_CD |
RAD_REQ_CONTROLS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Radiology Requisition Controls |
Definition: | The Rad_Req_Controls table contains system level settings related to the patient packet / requisition. |
Table Type: | REFERENCE |
Column Detail - RAD_REQ_CONTROLS
Column Name | Type | Null? | Definition |
---|---|---|---|
KEEP_NBR_DAYS | DOUBLE | Y | The Keep_Nbr_Days column contains the number of days that the requisition should be kept on-line |
PREVIOUS_EXAMS_FLAG | DOUBLE | Y | The Previous_Exams_Flag indicates how previous exams should be handled on the requisition. |
PRINT_ADVANCE_NBR_DAYS | DOUBLE | Y | The Print_Advance_Nbr_Days indicates how many days in advance of the requested date that the requisition should print. |
PRINT_CANCEL_NOTICE_IND | DOUBLE | Y | The Print_Cancel_Notice_Ind indicates if cancellation notices will be utilized |
PRINT_MODIFIED_IND | DOUBLE | Y | This column indicates if a requisition should be printed when an order is modified. |
PRINT_REPLACED_IND | DOUBLE | Y | The Print_Replaced_Ind indicates if requisitions are to print when a procedure is replaced. |
SERVICE_RESOURCE_CD | DOUBLE | N | The Service_Resource_Cd is a foreign key to the Service Resource table. It uniquely identifies the Department for which the settings are for. |
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_REQ_CONTROLS
Child Column in RAD_REQ_CONTROLS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
RAD_RESPONSES
Column Section | Top of Page |
Table-level Detail
Description: | Rad Responses |
Definition: | The Rad_Responses table contains valid responses for the questions on the Rad_Questions table. These questions and responses are used within the system controls database tools. |
Table Type: | REFERENCE |
Column Detail - RAD_RESPONSES
Column Name | Type | Null? | Definition |
---|---|---|---|
FLAG_VALUE | DOUBLE | Y | Indicates what value should be assigned to a flag field when this response is chosen. |
QUESTION_ID | DOUBLE | N | The Question_Id is a foreign key to the Rad_Questions table. It identifies which question this response is associated with. |
RESPONSE_TEXT | VARCHAR(255) | Y | The Response_Text holds the actual response that appears in the pick list. |
SEQUENCE | DOUBLE | N | The Sequence indicates the order that the responses should appear in the pick list. |
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. |