BORROWER_LENDER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Borrower Lender
Definition: The Borrower_Lender table contains those persons and places that either borrow or lend films/folders within image management applications.
Table Type: REFERENCE





Column Detail - BORROWER_LENDER


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.
BORROWER_LENDER_ID DOUBLE N The Borrower_Lender_Id uniquely identifies a row within the Borrower_Lender table. It has no other meaning or purpose other than to serve as a unique id.
BORROWER_LENDER_IND DOUBLE N The Borrower_Lender_Ind indicates if this entry is a borrower or a lender.
CONTACT_NAME VARCHAR(100) Y If the borrower or lender is a place, rather than a person, then this contains the name of the person to contact at that site.
MAIL_NAME VARCHAR(100) Y The Mail_Name contains the name of the borrower or lender formatted the way that it should print on letters and labels.
NAME VARCHAR(100) Y The Name contains the name of the borrower or lender formatted the way that is should appear in a pick list.
NAME_KEY VARCHAR(100) N The Name_Key contains the value of the name field in all caps. This field exists only for search capability, it will never be viewed.
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 - BORROWER_LENDER




Parent Column in BORROWER_LENDER (PK) Child Table Name Child Column Name
Children: BORROWER_LENDER_ID RAD_REQUEST LENDER_ID


BORROWING_ENTITY



Column Section Top of Page


Table-level Detail

Description: Borrowing Entity
Definition: The Borrowing_Entity table is a floating table that contains common information about borrowers. Since a borrower can be a person or place, they potentially exist on different tables.
Table Type: REFERENCE





Column Detail - BORROWING_ENTITY


Column Name Type Null? Definition
DEF_LOAN_INTERVAL DOUBLE Y The Def_Loan_Interval contains the default number of days that a borrower can keep an item on loan.
LOAN_COMMENTS VARCHAR(255) Y The Loan Comments contains any free text information about a borrower.
LOAN_LETTER_IND DOUBLE Y The Loan_Letter_Ind indicates whether or not a reminder letter should be sent if a loan were to become overdue.
PARENT_ENTITY_ID DOUBLE N The Parent_Entity_Id contains the primary key of the parent table.
PARENT_ENTITY_NAME VARCHAR(32) N The Parent_Entity_Name contains the name of the parent table. This, along with the parent_entity_id, allows the borrowing_entity table to have multiple parents.
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.


CODED_EXAM_REASON



Column Section Relationship Section Top of Page


Table-level Detail

Description: Coded Exam Reason
Definition: The Coded_Exam_Reason table contains a list of reasons for exam that can be chosen from at the time that the order is placed.
Table Type: REFERENCE





Column Detail - CODED_EXAM_REASON


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.
DESCRIPTION VARCHAR(255) Y The Description contains the reason for exam that will appear in pick lists.
DISCIPLINE_TYPE_CD DOUBLE N This column identifies the discipline or product that the reason is built for. This will be 0 if it is a common reason used by all teams.
EXAM_REASON_ID DOUBLE N The exam_reason_id is a unique, meaningless number that serves only as a unique identifier for the coded exam reason.
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 - CODED_EXAM_REASON




Parent Column in CODED_EXAM_REASON (PK) Child Table Name Child Column Name
Children: EXAM_REASON_ID EXAM_REASON EXAM_REASON_ID


RAD_ACR_COMPONENTS



Column Section Top of Page


Table-level Detail

Description: This table constains all reference components used to build ACR codes.
Definition: RadNet ACR Components
Table Type: REFERENCE





Column Detail - RAD_ACR_COMPONENTS


Column Name Type Null? Definition
ACR_DESCRIPTION LONGTEXT Y This column contains the textual description for the ACR component.
ACR_STR VARCHAR(12) N This column contains the individual element of the ACR Code.
PARENT_ANAT_STR VARCHAR(1) N This column is used to represent the hierarchy between ACR strings.
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_COMBINE_LABEL



Column Section Top of Page


Table-level Detail

Description: Radiology Combine Label
Definition: This table contains data related to image management combines. it records information about the labels that are being generated.
Table Type: ACTIVITY





Column Detail - RAD_COMBINE_LABEL


Column Name Type Null? Definition
COMBINE_ID DOUBLE N This column identifies the combine that the label information is associated with.
COMBINE_IND DOUBLE N This column indicates if the row is related to a combine or uncombine.
LIB_GROUP_CD DOUBLE Y This field identifies the library group that the folder resides in.
SEQ_OBJECT_ID DOUBLE N This field identifies the folder that the label is for
TYPE_MEAN VARCHAR(12) Y This contains the meaning of the folder type. It indicates if a folder is a regular folder or a foreign folder.
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.