Table Detail Report
FILM_USAGE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Film Usage |
Definition: | The Film_Usage table contains standard information about how much film is used during a specific procedure. |
Table Type: | REFERENCE |
Column Detail - FILM_USAGE
Column Name | Type | Null? | Definition |
---|---|---|---|
CATALOG_CD | DOUBLE | N | The Catalog_Cd is a foreign key to the Order_Catalog table. This identifies a certain orderable procedure. |
FILM_SIZE_CD | DOUBLE | N | The Film_Size_Cd identifies a specific film size that is used when performing a certain procedure. |
FILM_TYPE_CD | DOUBLE | N | the Film_Type_Cd identifies the type of film that is used when performing a certain procedure. |
STANDARD_QTY | DOUBLE | Y | The Standard_Qty contains the standard number of films that are used when performing a certain procedure. |
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 - FILM_USAGE
Child Column in FILM_USAGE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CATALOG_CD | SERVICE_DIRECTORY | CATALOG_CD |
LIBRARY_GROUP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Library Group |
Definition: | The Library_Group table is a child of the service_resource table and contains information specific to the library groups which are a part of the image management area. |
Table Type: | REFERENCE |
Column Detail - LIBRARY_GROUP
Column Name | Type | Null? | Definition |
---|---|---|---|
CHK_DIFF_BORR_IND | DOUBLE | Y | The Chk_Diff_Borr_Ind indicates whether or not the system should look to see if any subordinate folders are checked out to a different borrower when a folder is being returned from a loan. |
DAILY_FOLDER_IND | DOUBLE | Y | The Daily_Folder_Ind indicates if a new folder should be generated each day that a patient has an exam performed. |
FOLDER_NBR_FORMAT_CD | DOUBLE | N | The Folder_Nbr_Format_Cd identifies the folder number format that is used within this library group. (ex. med rec, soc sec, etc.) |
RETURN_LOC_FLAG | DOUBLE | Y | The Return_Loc_Flag indicates which of the default locations to use when a folder is being returned. |
SERVICE_RESOURCE_CD | DOUBLE | N | The Service_Resource_Cd is a foreign key to the Service_Resource table. This serves as a unique identifier for the library group. |
UNREAD_FILMS_IND | DOUBLE | Y | The Unread_Films_Ind indicates whether or not an unread film should be able to be loaned. This is controlled at the library group level. |
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 - LIBRARY_GROUP
Child Column in LIBRARY_GROUP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | SERVICE_RESOURCE_CD | SERVICE_RESOURCE | SERVICE_RESOURCE_CD |
Parent Column in LIBRARY_GROUP (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | SERVICE_RESOURCE_CD | EXAM_ROOM_LIB_GRP_RELTN | LIB_GROUP_CD |
LIB_GRP_RELTN | LIB_GROUP_CD | ||
LIB_GRP_RELTN | SERVICE_RESOURCE_CD |
LIB_GRP_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Lirbrary Group Relation |
Definition: | The Lib_Grp_Reltn table contains relationships between library groups. This is used within the image management area. (specifically for pull lists) |
Table Type: | REFERENCE |
Column Detail - LIB_GRP_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
LIB_GROUP_CD | DOUBLE | N | The Lib_Group_Cd is a foreign key to the Library_Group table. This uniquely identifies a library group. |
SERVICE_RESOURCE_CD | DOUBLE | N | The Service_Resource_Cd is a foreign key to the Library_Group table. This uniquely identifies a library group. This allows library groups to be logically linked together for pull list purposes. |
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 - LIB_GRP_RELTN
Child Column in LIB_GRP_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LIB_GROUP_CD | LIBRARY_GROUP | SERVICE_RESOURCE_CD |
SERVICE_RESOURCE_CD | LIBRARY_GROUP | SERVICE_RESOURCE_CD |
PROXY_EXEMPTIONS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Proxy Exemptions |
Definition: | The Proxy_Exemptions table contains a list of sub-sections in which a radiologist/resident does notallow proxying. |
Table Type: | REFERENCE |
Column Detail - PROXY_EXEMPTIONS
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVITY_SUB_TYPE_CD | DOUBLE | N | The Activity_Sub_Type_Cd field identifies the Activity Sub Type or modality that the radiologist wants to restrict proxy for. |
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
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 - PROXY_EXEMPTIONS
Child Column in PROXY_EXEMPTIONS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PRSNL | PERSON_ID |
PERSON_ID | RAD_RES_INFO | PERSON_ID |
PROXY_GROUP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Proxy Group |
Definition: | The Proxy_Group table contains a radiologists/residents list of others who may proxy for them. |
Table Type: | REFERENCE |
Column Detail - PROXY_GROUP
Column Name | Type | Null? | Definition |
---|---|---|---|
PERSON_ID | DOUBLE | N | This is the value of the unique primary identifier of the person table. It is an internal system assigned number. |
PROXY_ID | DOUBLE | N | The Proxy_Id contains the Id of a person that has been given privilege to proxy for a specific radiologist/resident. |
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 - PROXY_GROUP
Child Column in PROXY_GROUP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | PERSON_ID | PRSNL | PERSON_ID |
PROXY_ID | PRSNL | PERSON_ID | |
PERSON_ID | RAD_RES_INFO | PERSON_ID |