WFPROCTRAN FILE
REFERENCED BY
WF46.1
UPDATED BY
WF42.1 WF45.1 WF140 WF20.1 WF20.2
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WPT-WORKUNIT Numeric 12 WF42.1
Element: Workunit
WPT-PROCESS-ID Numeric 12 WF42.1
Element: Process Id
WPT-PROCESS-NAME Alpha 20 (Lower Case) WF42.1
Element: Process Name
WPT-PROC-STATUS Alpha 1 WF42.1
Element: Proc Status
WPT-PARENT-PID Numeric 12 WF42.1
Element: Parent Pid
WPT-PARENT-AID Numeric 12 WF42.1
Element: Parent Aid
WPT-LST-SEQ-NBR Numeric 6 WF45.1
Element: Lst Seq Nbr
WPT-DATE Numeric 8 (yyyymmdd) WF42.1
Element: Date This field contains the system date
when this was created.
WPT-TIME Numeric 6 (hhmmss) WF42.1
Element: Time
WFPROCTRAN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WPTSET1 WORKUNIT WF140 WF20.1
PROCESS-ID WF20.2 WF42.1
WF45.1 WF46.1
WPTSET2 WORKUNIT*
PROCESS-ID
WFPROCTRAN FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Wfproc WFPROC Required
WPT-PROCESS-NAME -> WPP-PROCESS-NAME (WPPSET1)
Wfworkunit WFWORKUNIT Required
WPT-WORKUNIT -> WFW-WORKUNIT
WFPROCTRAN FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Wfactivity WFACTIVITY Delete Cascades
WPT-WORKUNIT -> WAC-WORKUNIT
WPT-PROCESS-ID -> WAC-PROCESS-ID
WAC-ACTIVITY-ID
Wfproclog WFPROCLOG Delete Cascades
WPT-WORKUNIT -> WPL-WORKUNIT
WPT-PROCESS-ID -> WPL-PROCESS-ID
WPL-SEQ-NBR
|
