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