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 |