WFCHUSRCH FILE

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WUC-DIRECTORY-ID     Numeric 15
Directory Id

WUC-CHANNEL-NAME     Alpha 20
Channel Name

WUC-ORDER-OPT        Numeric 4
Order Opt

WUC-SUBSCRIBE        Alpha 1
Subscribe            N = No
                     Y = Yes

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

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


                         WFCHUSRCH FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WUCSET1   DIRECTORY-ID
          CHANNEL-NAME

WUCSET2   CHANNEL-NAME
          DIRECTORY-ID

WUCSET3   DIRECTORY-ID  KeyChange
          ORDER-OPT
          CHANNEL-NAME

                         WFCHUSRCH FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfchannel      WFCHANNEL    Required

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

Wfrdidhdr      WFRDIDHDR    Required

                            WUC-DIRECTORY-ID    -> WDR-DIRECTORY-ID

                         WFCHUSRCH FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfchusrcd      WFCHUSRCD

                            WUC-DIRECTORY-ID    -> UCD-DIRECTORY-ID
                            WUC-CHANNEL-NAME    -> UCD-CHANNEL-NAME
                                                   UCD-DIRECTORY-NAME