Table Detail Report

TRANS_FOLD_EXCLUSIONS



Column Section Relationship Section Top of Page


Table-level Detail

Description: Transfer Folder Exclusions
Definition: The Trans_Fold_Exclusion table contains folder types that should be excluded whenever a batch folder transfer is executed.
Table Type: REFERENCE





Column Detail - TRANS_FOLD_EXCLUSIONS


Column Name Type Null? Definition
IMAGE_CLASS_TYPE_CD DOUBLE N The Image_Class_Type_Cd is a foreign key to the Image_Class_Type table. It identifies the folder type that should be excluded from thetransfer pull list.
TRANS_RULE_ID DOUBLE N The trans_rule_id serves as a foreign key to the rad_fold_trans_rule table. It uniquely identifies the transfer rule that the folder exclusions are a part of.
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 - TRANS_FOLD_EXCLUSIONS


Child Column in TRANS_FOLD_EXCLUSIONS(FK) Parent Table Name Parent Column Name
Parents: IMAGE_CLASS_TYPE_CD IMAGE_CLASS_TYPE IMAGE_CLASS_TYPE_CD
TRANS_RULE_ID RAD_FOLD_TRANS_RULE TRANS_RULE_ID