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. |