WFCHDIRECT FILE

                           Channels Directory

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

DIR-DIRECTORY-NAME   Alpha 20
Directory Name

DIR-DIRECTORY-TYPE   Alpha 1
Directory Type

DIR-URL-ALIAS        Alpha 99  (Lower Case)
Url Alias

DIR-DIRECTORY        Alpha 99  (Lower Case)
Directory

DIR-DIRECT-STATUS    Alpha 1
Direct Status        A = Active
                     I = Inactive

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

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


DIR-SH-URL-ALIAS     Derived
Sh Url Alias

DIR-SH-DIRECTORY     Derived
Sh Directory

                         WFCHDIRECT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

DIRSET1   DIRECTORY-NAME

DIRSET2   DIRECTORY-NAMEKeyChange
          DIRECTORY-TYPE

                         WFCHDIRECT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfchandir      WFCHANDIR

                            DIR-DIRECTORY-NAME    -> WCD-DIRECTORY-NAME  (WCDSET2)
                                                     WCD-CHANNEL-NAME

Wfchinfdtl     WFCHINFDTL

                            DIR-DIRECTORY-NAME    -> WID-DIRECTORY-NAME
                                                     WID-INFORMATION
                                                     WID-RULETAG

Wfchusrcd      WFCHUSRCD

                            DIR-DIRECTORY-NAME    -> UCD-DIRECTORY-NAME
                                                     UCD-CHANNEL-NAME
                                                     UCD-DIRECTORY-ID

Wfchusrcdi     WFCHUSRCDI

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