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. |