Table Detail Report

ICLASS_ACC_ORDER_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: iclass_acc_order_r
Definition: Image class, accession, order relationship
Table Type: ACTIVITY





Column Detail - ICLASS_ACC_ORDER_R


Column Name Type Null? Definition
ACCESSION VARCHAR(20) Y This column identifies the accession that is associated with the particular folder.
ORDER_ID DOUBLE N This column contains the order_id that is associated with this particular folder.
SEQ_OBJECT_ID DOUBLE N This column identifies the folder that is associated with a particular accession/order_id.
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 - ICLASS_ACC_ORDER_R


Child Column in ICLASS_ACC_ORDER_R(FK) Parent Table Name Parent Column Name
Parents: SEQ_OBJECT_ID IMAGE_CLASS SEQ_OBJECT_ID
ORDER_ID ORDER_RADIOLOGY ORDER_ID


ICLASS_PERSON_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Image Class Person Relation
Definition: The Iclass_Person_Reltn table contains a list of all personnel that have exams stored in a certain piece of media.
Table Type: ACTIVITY





Column Detail - ICLASS_PERSON_RELTN


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.
SEQ_OBJECT_ID DOUBLE N The Seq_Object_Id is a foreign key to the Image_Class table. It serves as a unique identifier for the folder/media.
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 - ICLASS_PERSON_RELTN


Child Column in ICLASS_PERSON_RELTN(FK) Parent Table Name Parent Column Name
Parents: SEQ_OBJECT_ID IMAGE_CLASS SEQ_OBJECT_ID
PERSON_ID PERSON PERSON_ID


IMAGE_CLASS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Image Class
Definition: The Image_Class table contains common information about a specific container of exams. (ex. folders, tapes, cine, etc.)
Table Type: ACTIVITY





Column Detail - IMAGE_CLASS


Column Name Type Null? Definition
ACTIVE_VOLUME_IND DOUBLE Y The Active_Volume_Ind indicates if the folder is the current, active volume.
CREATION_DT_TM DATETIME Y The Creation_Dt_Tm captures the date and time that the folder/media was created within the system.
FILING_NUMBER VARCHAR(100) Y The Filing_Number contains an identifier for the folder/media specific to the filing method used.
HISTORY_LABEL_PRINT_IND DOUBLE Y The History_Label_Print_Ind indicates whether or not historical labels should be printed.
IMAGE_CLASS_TYPE_CD DOUBLE N The Image_Class_Type_Cd is a foreign key to the Image_Class_Type table. This uniquely identifies a folder type.
LABEL_PRINT_DT_TM DATETIME Y The label_print_dt_tm contains the date and time that the folder label originally printed.
LOST_COMMENT VARCHAR(255) Y The Lost_Comment contains any free text comments related to the folder/media being lost.
LOST_IND DOUBLE Y the Lost_Ind indicates whether or not a folder is marked as lost.
NBR_EXAMS DOUBLE Y The Nbr_Exams contains the number of exams that reside in the folder/media item.
NEW_FOLD_IND DOUBLE Y The new_fold_ind indicates if the folder is a newly created folder in which no exams exist at this time. Once exams are placed in the folder, the new_fold_ind will no longer be set.
PENDING_EXAM_CNT DOUBLE Y The pending_exam_cnt keeps track of the number of exams that have been ordered that will eventually load to the specific folder. This number is only relevant if the folder is 'new'.
PURGE_IND DOUBLE Y The Purge_Ind indicates is the folder/media item has been marked for purge.
SEQ_OBJECT_ID DOUBLE N The Seq_Object_Id is a foreign key to the Trackable_Object table. This uniquely identifies the folder/media item.
UPDATEABLE_IND DOUBLE Y The Updateable_Ind indicates if this volume is the active volume.
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.
VOLUME DOUBLE Y The Volume field contains the volume number of the folder. This is a sequential number.



Relationship Detail - IMAGE_CLASS


Child Column in IMAGE_CLASS(FK) Parent Table Name Parent Column Name
Parents: IMAGE_CLASS_TYPE_CD IMAGE_CLASS_TYPE IMAGE_CLASS_TYPE_CD
SEQ_OBJECT_ID TRACKABLE_OBJECT SEQ_OBJECT_ID




Parent Column in IMAGE_CLASS (PK) Child Table Name Child Column Name
Children: SEQ_OBJECT_ID FOLDER SEQ_OBJECT_ID
FOREIGN_FOLDER SEQ_OBJECT_ID
ICLASS_ACC_ORDER_R SEQ_OBJECT_ID
ICLASS_PERSON_RELTN SEQ_OBJECT_ID
MEDIA SEQ_OBJECT_ID
TEMPORARY_FOLDER SEQ_OBJECT_ID


IMAGE_CLASS_TYPE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Image Class Type
Definition: The Image_Class_Type table contains information about all of the different folder/media types within the image management system.
Table Type: REFERENCE





Column Detail - IMAGE_CLASS_TYPE


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.
BEG_EFFECTIVE_DT_TM DATETIME N The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CONTENT_LABEL_CNT DOUBLE Y Identifies the number of Content Labels to be created.
CREATE_BY_ACC_IND DOUBLE Y This column indicates if a certain folder type should be created by accession.
DEFAULT_RETURN_LOCN_CD DOUBLE N The Default_Return_Locn_Cd is a foreign key to the Track_Pt_Library table. This uniquely identifies the library that should be used as a home location when creating a new folder/media item of this certain type.
DEFAULT_TRACKING_POINT_CD DOUBLE N The Default_Tracking_Point_Cd is a foreign key to the Track_Pt_Library table. This uniquely identifies the library/tracking point that should be used as a current location when creating a new folder/media item of this certain type.
END_EFFECTIVE_DT_TM DATETIME N The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
IMAGE_CLASS_TYPE_CD DOUBLE N The Image_Class_Type_Cd uniquely identifies a row within the Image_Class_Type table. It has no other meaning or purpose other than to serve as a unique id.
LABEL_CNT DOUBLE Y The Label_Cnt specifies the number of labels that should print when a folder/media item of this type is created.
LIB_GROUP_CD DOUBLE N The Lib_Group_Cd is a foreign key to the Library_Group table. It identifies which library group the folder/media type belongs to.
LOANABLE_IND DOUBLE Y The Loanable_Ind indicates if the folders and or media items of this certain type can be loaned.
MAX_EXAMS DOUBLE Y The Max_Exams indicates the maximum number of exams that can be stored within a folder/media item of this type.
PARENT_IMAGE_CLASS_TYPE_CD DOUBLE N The Parent_Image_Class_Type_Cd allows for a hierarchical structure among folder types. It contains the parent folder type for a specified folder.
STORE_EXAMS_IND DOUBLE Y The Stores_Exams_Ind indicates whether or not a folder should store exams.
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 - IMAGE_CLASS_TYPE


Child Column in IMAGE_CLASS_TYPE(FK) Parent Table Name Parent Column Name
Parents: IMAGE_CLASS_TYPE_CD CODE_VALUE CODE_VALUE
PARENT_IMAGE_CLASS_TYPE_CD IMAGE_CLASS_TYPE IMAGE_CLASS_TYPE_CD
DEFAULT_RETURN_LOCN_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
DEFAULT_TRACKING_POINT_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
LIB_GROUP_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in IMAGE_CLASS_TYPE (PK) Child Table Name Child Column Name
Children: IMAGE_CLASS_TYPE_CD IMAGE_CLASS IMAGE_CLASS_TYPE_CD
IMAGE_CLASS_TYPE PARENT_IMAGE_CLASS_TYPE_CD
TRANS_FOLD_EXCLUSIONS IMAGE_CLASS_TYPE_CD


IMAGE_HISTORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Image History
Definition: The Image_History table contains all historical movement for a specific media or exam.
Table Type: ACTIVITY





Column Detail - IMAGE_HISTORY


Column Name Type Null? Definition
ACTION_CD DOUBLE N The Action_Cd identifies which action is being recorded for historical purposes. (ex. loaned, transferred, purged, created, etc.)
ACTION_COMMENTS VARCHAR(255) Y The Action_Comments contains general comments about the transaction that is being logged.
ACTION_DT_TM DATETIME N the Action_Dt_Tm field captures the date and time that the action took place. (ex. the date and time that the folder was loaned.)
ACTION_METHOD_CD DOUBLE N The Action_Method_Cd indicates the method of transport for those actions that require the folder/media item to be moved.
AGENT VARCHAR(50) Y The Agent field identifies the person who picked up the folder for a specific borrower.
FROM_DT_TM DATETIME Y The From_Dt_Tm field captures the beginning date and time of a date range. For a loan transaction this would be the date and time that the folder was loaned.
LOGGED_DT_TM DATETIME Y The Logged_Dt_Tm field captures the time that the transaction was entered into the system.
NBR_COPIES DOUBLE Y The Nbr_Copies field is used for the copy action. It indicates how many copies were made of a certain film exam.
REQUEST_DT_TM DATETIME Y The Request_Dt_Tm captures the date and time that a folder/media item was requested.
REQUEST_PARENT_ID DOUBLE N The request_parent_id, along with the request_parent_name, uniquely identify the requestor for the action that was logged in image history.
REQUEST_PARENT_NAME VARCHAR(32) Y The request_parent_name, along with the request_parent_id, uniquely identify the requestor for the action that was logged in image history.
REQUEST_RETURN_DT_TM DATETIME Y The Request_Return_Dt_Tm captures the date and time that a folder/media item was requested to be returned.
SEQ_OBJECT_ID DOUBLE N The Seq_Object_Id is a foreign key to the Trackable_Object table. It uniquely identifies the folder/media item involved with this transaction.
TRANSACTION_ID DOUBLE N The Transaction_Id identifies the person who executed the transaction. This is a foreign key to the Prsnl table.
TRK_PT_PARENT_ID DOUBLE N The trk_pt_parent_id along with the trk_pt_parent_name uniquely identify the tracking point/person/location that last had the folder.
TRK_PT_PARENT_NAME VARCHAR(32) Y The trk_pt_parent_name along with the trk_pt_parent_id uniquely identify the tracking point/person/location that last had the 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.



Relationship Detail - IMAGE_HISTORY


Child Column in IMAGE_HISTORY(FK) Parent Table Name Parent Column Name
Parents: TRANSACTION_ID PRSNL PERSON_ID
SEQ_OBJECT_ID TRACKABLE_OBJECT SEQ_OBJECT_ID