WFACTIVITY FILE
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WAC-WORKUNIT Numeric 12
Element: Workunit
WAC-PROCESS-ID Numeric 12
Element: Process Id
WAC-ACTIVITY-ID Alpha 20 (Lower Case)
Element: Activity Id
WAC-ACTIVITY-NAME Alpha 20 (Lower Case)
Element: Activity Name
WAC-ACTIVITY-TYPE Alpha 10
Element: Activity Type
WAC-ACT-STATUS Alpha 1
Element: Act Status
WAC-START-DATE Numeric 8 (yyyymmdd)
Element: Start Date
WAC-START-TIME Numeric 6 (hhmmss)
Element: Start Time
WAC-END-DATE Numeric 8 (yyyymmdd)
Element: Ending Date The ending date in a range of dates.
WAC-END-TIME Numeric 6 (hhmmss)
Element: End Time
WAC-WF-SEQ-NBR Numeric 6
Element: Wf Seq Nbr
WFACTIVITY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WACSET1 WORKUNIT
PROCESS-ID
ACTIVITY-ID
WACSET2 WORKUNIT KeyChange
PROCESS-ID
START-DATE
START-TIME
ACTIVITY-ID
WACSET3 WORKUNIT KeyChange
PROCESS-ID
WF-SEQ-NBR
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
|
