WFCHUSRCD FILE

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

UCD-DIRECTORY-ID     Numeric 15
Directory Id

UCD-CHANNEL-NAME     Alpha 20
Channel Name

UCD-DIRECTORY-NAME   Alpha 20
Directory Name

UCD-ORDER-OPT        Numeric 4
Order Opt

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

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

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


                         WFCHUSRCD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

UCDSET1   DIRECTORY-ID
          CHANNEL-NAME
          DIRECTORY-NAME

UCDSET2   CHANNEL-NAME
          DIRECTORY-NAME
          DIRECTORY-ID

UCDSET3   DIRECTORY-NAME
          CHANNEL-NAME
          DIRECTORY-ID

UCDSET4   DIRECTORY-NAME
          DIRECTORY-ID
          CHANNEL-NAME

UCDSET5   CHANNEL-NAME
          DIRECTORY-ID
          DIRECTORY-NAME

UCDSET6   DIRECTORY-ID
          DIRECTORY-NAME
          CHANNEL-NAME

UCDSET7   DIRECTORY-ID  KeyChange
          CHANNEL-NAME
          ORDER-OPT
          DIRECTORY-NAME

                         WFCHUSRCD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfchannel      WFCHANNEL    Required

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

Wfchdirect     WFCHDIRECT   Required

                            UCD-DIRECTORY-NAME    -> DIR-DIRECTORY-NAME

Wfchusrch      WFCHUSRCH    Required

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

Wfrdidhdr      WFRDIDHDR    Required

                            UCD-DIRECTORY-ID      -> WDR-DIRECTORY-ID

                         WFCHUSRCD FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfchusrcdi     WFCHUSRCDI

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