WFCHUSRCDI FILE

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WUI-DIRECTORY-ID     Numeric 15
Directory Id

WUI-CHANNEL-NAME     Alpha 20
Channel Name

WUI-DIRECTORY-NAME   Alpha 20
Directory Name

WUI-INFORMATION      Alpha 25  (Lower Case)
Information

WUI-RULETAG          Alpha 15
Ruletag

WUI-ORDER-OPT        Numeric 4
Order Opt

WUI-PUBLISH          Numeric 12
Publish

WUI-MULT-PUBLISH     Alpha 1
Mult Publish         N = No
                     Y = Yes

WUI-SUBSCRIBE        Alpha 1
Subscribe            A = All
                     N = No
                     Y = Yes

WUI-INFORM-TYPE      Numeric 1
Inform Type          1 = Generally not notified
                     2 = Generally notified
                     3 = Always notified
                     4 = Never notified

WUI-DELIVERY-TYPE    Alpha 1
Delivery Type        A = Attachment to Email
                     U = URL

WUI-DATE             Numeric 8  (yyyymmdd)
Date                 This field contains the system date
                     when this was created.

WUI-TIME             Numeric 8
Time                 This field is updated automatically to
                     indicate the time that the GL entry was
                     created. It is system-maintained.


WUI-INFONAME-DESC    Derived
Infoname Desc

                         WFCHUSRCDI FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WUISET1   DIRECTORY-ID
          CHANNEL-NAME
          DIRECTORY-NAME
          INFORMATION
          RULETAG

WUISET2   CHANNEL-NAME
          DIRECTORY-NAME
          DIRECTORY-ID
          INFORMATION
          RULETAG

WUISET3   DIRECTORY-NAME
          CHANNEL-NAME
          DIRECTORY-ID
          INFORMATION
          RULETAG

WUISET4   INFORMATION
          RULETAG
          DIRECTORY-NAME
          CHANNEL-NAME
          DIRECTORY-ID

WUISET5   DIRECTORY-NAME
          DIRECTORY-ID
          CHANNEL-NAME
          INFORMATION
          RULETAG

WUISET6   INFORMATION
          RULETAG
          DIRECTORY-ID
          DIRECTORY-NAME
          CHANNEL-NAME

WUISET7   DIRECTORY-ID  KeyChange
          CHANNEL-NAME
          DIRECTORY-NAME
          ORDER-OPT
          INFORMATION
          RULETAG

                         WFCHUSRCDI FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfchannel      WFCHANNEL    Required

                            WUI-CHANNEL-NAME      -> WCN-CHANNEL-NAME  (WCNSET1)

Wfchdirect     WFCHDIRECT   Required

                            WUI-DIRECTORY-NAME    -> DIR-DIRECTORY-NAME

Wfchinfdtl     WFCHINFDTL   Required

                            WUI-INFORMATION       -> WID-INFORMATION
                            WUI-RULETAG           -> WID-RULETAG

Wfchusrcd      WFCHUSRCD    Required

                            WUI-DIRECTORY-ID      -> UCD-DIRECTORY-ID
                            WUI-CHANNEL-NAME      -> UCD-CHANNEL-NAME
                            WUI-DIRECTORY-NAME    -> UCD-DIRECTORY-NAME

Wfrdidhdr      WFRDIDHDR    Required

                            WUI-DIRECTORY-ID      -> WDR-DIRECTORY-ID

                         WFCHUSRCDI FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfchpub        WFCHPUB

                            WUI-INFORMATION       -> WPB-INFORMATION
                            WUI-RULETAG           -> WPB-RULETAG
                                                     WPB-PUBLISH