|
|
WFWUQUEUE FILE
UPDATED BY
WF46.1 WF140 WF20.1 WF20.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WWQ-WORKUNIT Numeric 12 WF46.1
Element: Workunit
WWQ-PROCESS-ID Numeric 12 WF46.1
Element: Process Id
WWQ-ACTIVITY-ID Alpha 20 (Lower Case) WF46.1
Element: Activity Id
WWQ-TASK Alpha 20 (Lower Case) WF46.1
Element: Task
WWQ-ID Alpha 20 (Lower Case) WF46.1
Element: Id
WWQ-JOB-ID Numeric 10 WF46.1
Element: Job Id
WWQ-WORK-DESC Alpha 99 (Lower Case) WF46.1
Element: Work Desc
WWQ-LIST-MESSAGE Alpha 80 (Lower Case) WF46.1
Element: List Message
WWQ-ACTION-LIST Alpha 99 (Lower Case) WF46.1
Element: Action List
WWQ-ACTION-TAKEN Alpha 30 (Lower Case) WF46.1
Element: Action Taken
WWQ-EXEC-LIST Alpha 99 (Lower Case) WF46.1
Element: Exec List
WWQ-PRE-EXEC Alpha 99 (Lower Case) WF46.1
Element: Pre Exec
WWQ-DISPLAY-EXEC Alpha 99 (Lower Case) WF46.1
Element: Display Exec
WWQ-RETURN-CODE Alpha 1 WF46.1
Element: Return Code
WWQ-RETRY Numeric 4 WF46.1
Element: Retry
WWQ-DISP-STATUS Numeric 1 WF46.1
Element: Disp Status
WWQ-WAIT-HOURS1 Numeric 4 WF46.1
Element: Wait Hours1
WWQ-REMINDER-TASK1 Alpha 20 WF46.1
Element: Reminder Task1
WWQ-REMINDED1 Alpha 1 WF46.1
Element: Reminded1 Y = Yes
N = No
WWQ-WAIT-HOURS2 Numeric 4 WF46.1
Element: Wait Hours2
WWQ-REMINDER-TASK2 Alpha 20 WF46.1
Element: Reminder Task2
WWQ-REMINDED2 Alpha 1 WF46.1
Element: Reminded2 Y = Yes
N = No
WWQ-REASSIGN Alpha 1 WF46.1
Element: Reassign Y = Yes
N = No
WWQ-REASSIGN-TASK Alpha 20 WF46.1
Element: Reassign Task
WWQ-REASSIGN-HOURS Numeric 4 WF46.1
Element: Reassign Hours
WWQ-CATEGORY-VALUE Alpha 20 (Lower Case) WF46.1
Element: Category Value
WFWUQUEUE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WWQSET1 WORKUNIT WF140 WF20.1
PROCESS-ID WF20.2 WF46.1
ACTIVITY-ID WF46.2
WWQSET2 TASK KeyChange
WORKUNIT
PROCESS-ID
ACTIVITY-ID
WWQSET3 DISP-STATUS KeyChange, Subset
WORKUNIT Where (REMINDED1 = "N"
PROCESS-ID And WAIT-HOURS1 != Zeroes )
ACTIVITY-ID Or (REMINDED2 = "N"
And WAIT-HOURS2 != Zeroes )
Or (REASSIGN = "N"
And REASSIGN-HOURS != Zeroes )
WWQSET4 TASK KeyChange
DISP-STATUS
WORKUNIT
CATEGORY-VALUE
PROCESS-ID
ACTIVITY-ID
WWQSET5 CATEGORY-VALUEKeyChange
WORKUNIT
PROCESS-ID
ACTIVITY-ID
WWQSET6 DISP-STATUS KeyChange
WORKUNIT
PROCESS-ID
ACTIVITY-ID
WFWUQUEUE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Wfactivity WFACTIVITY Required
WWQ-WORKUNIT -> WAC-WORKUNIT (WACSET1)
WWQ-PROCESS-ID -> WAC-PROCESS-ID
WWQ-ACTIVITY-ID -> WAC-ACTIVITY-ID
Wfproctran WFPROCTRAN Required
WWQ-WORKUNIT -> WPT-WORKUNIT
WWQ-PROCESS-ID -> WPT-PROCESS-ID
Wfworkunit WFWORKUNIT Required
WWQ-WORKUNIT -> WFW-WORKUNIT
WFWUQUEUE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Wfwuquedtl WFWUQUEDTL Delete Cascades
WWQ-WORKUNIT -> WQD-WORKUNIT
WWQ-PROCESS-ID -> WQD-PROCESS-ID
WWQ-ACTIVITY-ID -> WQD-ACTIVITY-ID
WQD-VAR-TYPE
WQD-VARIABLE-NAME
|
