Table Detail Report

RAD_FOLD_TRANS_RULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Rad Folder Transfer Rule
Definition: The Rad_Fold_Trans_Rule table contains the user define rules that are used while executing a batch transfer of folders within the image management area.
Table Type: REFERENCE





Column Detail - RAD_FOLD_TRANS_RULE


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.
ACT_FREQ_FLAG DOUBLE Y The Act_Freq_Flag indicates the unit of time that is used to determine the order activity criteria. (ex: daily, weekly, monthly, yearly)
ACT_FREQ_INTERVAL DOUBLE Y the Act_Freq_Interval indicates the number to be used along with the unit of time from the Act_Freq_Flag. For example if the flag indicates monthly, and the interval is 2, then the frequency would be every 2 months.
AGE_LIMIT_IND DOUBLE Y Indicates whether a rule has an Age_limit
BEGIN_DT_TM DATETIME Y The Begin_Dt_Tm identifies when the frequency that was specified should begin.
EXCLUDE_DECEASED_IND DOUBLE Y The Exclude_Deceased_Ind field indicates whether or not to exclude folders for a deceased patient.
EXCLUDE_INTCASE_IND DOUBLE Y The Exclude_IntCase_Ind field indicates whether or not to exclude folders that contain exams that have been marked as an interesting case.
EXCLUDE_MEDLEGAL_IND DOUBLE Y The Exclude_MedLegal_Ind field indicates whether or not to exclude folders that contain exams that have been marked for medical legal purposes.
FRI_IND DOUBLE Y The Fri_Ind field indicates if Friday is a day that the transfer rule is to be run.
FROM_LIB_CD DOUBLE N The From_Lib_Cd is a foreign key to the Track_Pt_Library table. It identifies the Library that folders are going to be moved from.
MAX_FOLD_CUTOFF VARCHAR(100) Y the Max_Fold_Cutoff field contains a folder number used when qualifying folders for transfer. For example, all folders with a folder number less than 1234567.
MON_IND DOUBLE Y The Mon_Ind field indicates if Monday is a day that the transfer rule is to be run.
PRIOR_DT_TM DATETIME Y The Prior_Dt_Tm contains a date and time that should be used when checking for order activity. For example, all folders that have not had activity since 12/12/96.
PULL_FREQ_FLAG DOUBLE Y The Pull_Freq_Flag indicates the unit of time that is used to determine the print frequency for the pull list. (ex: daily, weekly, monthly, yearly)
PULL_FREQ_INTERVAL DOUBLE Y the Pull_Freq_Interval indicates the number to be used along with the unit of time from the Pull_Freq_Flag. For example if the flag indicates monthly, and the interval is 2, then the frequency wouldbe every 2 months.
SAT_IND DOUBLE Y The Sat_Ind field indicates if Saturday is a day that the transfer rule is to be run.
SUN_IND DOUBLE Y The Sun_Ind field indicates if Sunday is a day that the transfer rule is to be run.
THU_IND DOUBLE Y The Thu_Ind field indicates if Thursday is a day that the transfer rule is to be run.
TO_LIB_CD DOUBLE N The To_Lib_Cd is a foreign key to the Track_Pt_Library table. It identifies the Library that folders are going to be moved to.
TRANS_RULE_ID DOUBLE N The trans_rule_id is a unique, meaningless number that serves no other purpose other than a unique identifier.
TUE_IND DOUBLE Y The Tue_Ind field indicates if Tuesday is a day that the transfer rule is to be run.
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.
WED_IND DOUBLE Y The Wed_Ind field indicates if Wednesday is a day that the transfer rule is to be run.



Relationship Detail - RAD_FOLD_TRANS_RULE


Child Column in RAD_FOLD_TRANS_RULE(FK) Parent Table Name Parent Column Name
Parents: FROM_LIB_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD
TO_LIB_CD SERVICE_RESOURCE SERVICE_RESOURCE_CD




Parent Column in RAD_FOLD_TRANS_RULE (PK) Child Table Name Child Column Name
Children: TRANS_RULE_ID PULL_TRANS_REQ TRANS_RULE_ID
TRANS_EXAM_EXCLUSIONS TRANS_RULE_ID
TRANS_FOLD_EXCLUSIONS TRANS_RULE_ID