WFPROCTRAN FILE
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WPT-WORKUNIT Numeric 12
Element: Workunit
WPT-PROCESS-ID Numeric 12
Element: Process Id
WPT-PROCESS-NAME Alpha 20 (Lower Case)
Element: Process Name
WPT-PROC-STATUS Alpha 1
Element: Proc Status
WPT-PARENT-PID Numeric 12
Element: Parent Pid
WPT-PARENT-AID Numeric 12
Element: Parent Aid
WPT-LST-SEQ-NBR Numeric 6
Element: Lst Seq Nbr
WPT-DATE Numeric 8 (yyyymmdd)
Element: Date This field contains the system date
when this was created.
WPT-TIME Numeric 6 (hhmmss)
Element: Time
WFPROCTRAN FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WPTSET1 WORKUNIT
PROCESS-ID
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-WF-SEQ-NBR
|
