WFUSERTASK FILE
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
WUT-WF-RM-ID Alpha 80 (Lower Case)
Element: Wf Rm Id
WUT-TASK Alpha 20 (Lower Case)
Element: Task
WUT-START-DATE Numeric 8 (yyyymmdd)
Element: Start Date
WUT-STOP-DATE Numeric 8 (yyyymmdd)
Element: Stop Date
WUT-FILTER-CATGORY Alpha 1
Element: Filter CatgoryY = Yes
N = No
WUT-DISPLAY-ALL Alpha 1
Element: Display All Y = Yes
N = No
WFUSERTASK FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
WUTSET1 WF-RM-ID
TASK
WUTSET2 TASK
WF-RM-ID
WFUSERTASK FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Wftask WFTASK Required
WUT-TASK -> WTA-TASK (WTASET1)
Wfusrprofl WFUSRPROFL Required
WUT-WF-RM-ID -> WFU-WF-RM-ID
WFUSERTASK FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Wfusercat WFUSERCAT
WUT-WF-RM-ID -> WFT-WF-RM-ID
WUT-TASK -> WFT-TASK
WFT-WORK-CATEGORY
WFT-WORK-CAT-VALUE
|
