FO_Hub_Job_Definition
This table contains the basic information to define a HUB Job.
The HUB JOB is executed by the SLA service on the defined schedule. The actual activities for each job are defined in the table.
The site will typically define Hub Jobs via CSTools GUI not through table maintenance.
| Field | Type | Notes |
|---|---|---|
|
Hub_Job_Def_ID |
int |
ID field, a counter. Unique |
|
HubCode |
varchar(50) |
Code for HUB |
|
JobID |
varchar(50) |
Enter a unique ID for job. Enter an ID to create a naming convention which assists in readily identifying jobs. |
|
JobName |
varchar(80) |
Description of job. |
|
Notes |
varchar(MAX) |
Informational |
|
RunDaily |
bit |
Bit flag that determines if job is run daily. Enter 0 or 1 0 = do not run daily 1 = run job daily |
|
WeeklyJobDays |
varchar(50) |
Indicates which day of week job runs. Multidimensional pipe delimited value, with leading and trailing pipes. Enter days separated by pipes. Days are represented by the characters: X,M,T,W,H,F,S. |
|
ScheduleType |
varchar(50) |
Job schedule type. Enter an allowed value. Allowed values: Daily Weekly MonthDate MonthWeekDay |
|
MonthDate |
varchar(2000) |
Defines a month date combination. Multidimensional pipe delimited value, with leading and trailing pipes. Enter month-day combinations separated by pipes. Use a 2-digit month and a 2-digit day. IE: |MM-DD|MM-DD| |
|
MonthWeekDay |
varchar(2000) |
Indicates a month week day combination. Pipe delimited formatted as Month-Week-Day | Month-Week-Day using 2 digit month and week and single digit for day of week. Valid Weeks are 01-05. Valid Days are 0-6 IE: |MM-WW-D|MM-WW-D| |
|
NextRunDate |
datetime |
Date Time format to indicate next run date. When new schedule is created, this date must be current or future time. |
|
LastRunDate |
datetime |
Date Time stamp to indicate when schedule last ran. If this field is blank, it means the job has never run. |
|
StartTimeSecsMidnight |
int |
Seconds after minute to start job. Enter an integer between 0 and 59 for the seconds. |
|
CollectStartDateKey |
varchar(50) |
Start collection date range relative to current date. Format as T +/- integer. |
|
CollectEndDateKey |
varchar(50) |
End collection date range relative to current date. Format as T +/- integer. |
|
CollectStartTimeSecsMidnight |
int |
Start collection time. Recorded as seconds after midnight. Enter an integer between 0 and 59 for the seconds. |
|
CollectEndTimeSecsMidnight |
int |
End collection time. Recorded as seconds after midnight. Enter an integer between 0 and 59 for the seconds. |
|
ActivateSO |
bit |
Bit flag to determine if Standing Order activation is performed on this job. Enter 0 or 1 0 = do not activate standing order for this job 1 = active standing order for this job |
|
DeviceLocation |
varchar(50) |
Enter valid device location used during job processing. |
|
OrderCreateUserLocation |
varchar(50) |
User location recorded for order creation in Standing Order activation process. |
|
ActivateUserLocation |
varchar(50) |
User location recorded for activate in Standing Order activation process. |
|
PerfLabRulesUserLocation |
varchar(50) |
User location utilized for performing lab rules in Standing Order activation process. |
|
TriggerLabels |
bit |
Bit flag to determine if labels will be triggered in this job. Enter 0 or 1 0 = do not trigger labels 1 = trigger labels |
|
LabelDeviceLocation |
varchar(50) |
Enter a valid device location as in the FO_LabelTrigger table. |
|
LabelServiceID |
varchar(50) |
Enter a valid label service ID as in the FO_LabelTrigger table. |
|
LabelType |
varchar(50) |
Enter a valid label type as in the FO_LabelTrigger table. Default is C (container). |
|
Active |
bit |
Bit flag to determine if this definition record is active. Enter 0 or 1 0 = inactive 1 = active |
|
CreateDate |
datetime |
Date record was created. Informational |
|
EditDate |
datetime |
Date record was last edited. Informational |
|
CreateUser |
varchar(50) |
User who created record. Informational |
|
EditUser |
varchar(50) |
User who last edited record. Informational |
|
SubscriptionID |
varchar(255) |
Enter a valid subscription ID to direct report outputs other than labels. |
|
SubscriptionJobID |
varchar(50) |
Not in use. |
|
Requisition |
bit |
Bit flag to determine if requisitions should be produced. Enter 0 or 1 0 = do not produce requisitions 1 = produce requisitions |
|
CollectionList |
bit |
Bit flag to determine if collection lists should be produced. Enter 0 or 1 0 = do not produce collection lists 1 = produce collection lists |
|
AuditCollectionList |
bit |
Bit flag to determine if audit lists should be produced. Enter 0 or 1 0 = do not produce audit lists 1 = produce audit lists |
|
ABNForms |
bit |
Bit flag to determine if ABN forms should be produced. Enter 0 or 1 0 = do not produce ABN forms 1 = produce ABN forms |
|
SubscriptionID_Req |
varchar(255) |
Enter a valid subscription ID to direct requisition reports. |
|
SubscriptionID_ABN |
varchar(255) |
Enter a valid subscription ID to direct ABN reports. |
|
SubscriptionID_Audit |
varchar(255) |
Enter a valid subscription ID to direct audit reports. |
|
OrderPriority |
varchar(50) |
Defines the list of priority codes used to filter the list of accessions to qualify. Multidimensional pipe delimited value, with leading and trailing pipes. Enter valid priority codes separated by pipes. |
|
FutureOrders |
bit |
Bit flag to determine if future orders audit should be produced. Enter 0 or 1 0 = do not produce future orders audit 1 = produce future orders audit If this is 1, or true, other outputs are not allowed. |
|
SubscriptionID_Future |
varchar(255) |
Enter a valid subscription ID to direct future order audit reports. |
|
LimitToActivatedOrders |
bit |
Bit flag to determine if Hub job will search both standing order tables and active orders table. Default is skip this entry, leave this field blank. Enter 0 or 1 0 or skip this entry = Hub Job will search both the standing order tables as well as active orders tables 1 = Hub job will only search the standing order tables |