WFACTIVITY FILE
REFERENCED BY
WF46.1
UPDATED BY
WF43.1 WF140 WF20.1 WF20.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WAC-WORKUNIT Numeric 12 WF43.1
Element: Workunit
WAC-PROCESS-ID Numeric 12 WF43.1
Element: Process Id
WAC-ACTIVITY-ID Alpha 20 (Lower Case) WF43.1
Element: Activity Id
WAC-ACTIVITY-NAME Alpha 20 (Lower Case) WF43.1
Element: Activity Name
WAC-ACTIVITY-TYPE Alpha 10 WF43.1
Element: Activity Type
WAC-ACT-STATUS Alpha 1 WF43.1
Element: Act Status
WAC-START-DATE Numeric 8 (yyyymmdd) WF43.1
Element: Start Date
WAC-START-TIME Numeric 6 (hhmmss) WF43.1
Element: Start Time
WAC-END-DATE Numeric 8 (yyyymmdd) WF43.1
Element: Ending Date The ending date in a range of dates.
WAC-END-TIME Numeric 6 (hhmmss) WF43.1
Element: End Time
WFACTIVITY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WACSET1 WORKUNIT WF140 WF20.1
PROCESS-ID WF20.2 WF43.1
ACTIVITY-ID WF46.1
WACSET2 WORKUNIT KeyChange
PROCESS-ID
START-DATE
START-TIME
ACTIVITY-ID
WFACTIVITY FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Wfproctran WFPROCTRAN Required
WAC-WORKUNIT -> WPT-WORKUNIT (WPTSET1)
WAC-PROCESS-ID -> WPT-PROCESS-ID
Wfworkunit WFWORKUNIT Required
WAC-WORKUNIT -> WFW-WORKUNIT
WFACTIVITY FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Wfvactvar WFACTVAR Delete Cascades
WAC-WORKUNIT -> WAV-WORKUNIT
WAC-PROCESS-ID -> WAV-PROCESS-ID
WAC-ACTIVITY-ID -> WAV-ACTIVITY-ID
WAV-VARIABLE-NAME
|
