WFCHINFDTL FILE

                      Channels Information Detail

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WID-INFORMATION      Alpha 25  (Lower Case)
Information

WID-RULETAG          Alpha 15
Ruletag

WID-RULE-ORDER       Numeric 4
Rule Order

WID-DIRECTORY-NAME   Alpha 20
Directory Name

WID-INFO-NAME        Alpha 50  (Lower Case)
Info Name

WID-LIST-GROUP       Alpha 15
List Group

WID-INFO-STATUS      Alpha 1
Info Status          A = Active
                     I = Inactive

WID-COMBIN-RPT-RUL   Alpha 1
Combin Rpt Rul       N = No
                     Y = Yes

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

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


WID-SH-DIR-NAME      Derived
Sh Dir Name

WID-SH-INFO          Derived
Sh Info

                         WFCHINFDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WIDSET1   INFORMATION
          RULETAG

WIDSET2   RULETAG       KeyChange
          RULE-ORDER
          INFORMATION

WIDSET3   DIRECTORY-NAMEKeyChange
          INFORMATION
          RULETAG

WIDSET4   LIST-GROUP    KeyChange
          INFORMATION
          RULETAG
          DIRECTORY-NAME

WIDSET5   INFORMATION   KeyChange
          RULE-ORDER
          RULETAG

                         WFCHINFDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfchdirect     WFCHDIRECT   Required

                            WID-DIRECTORY-NAME    -> DIR-DIRECTORY-NAME  (DIRSET1)

Wfchgroup      WFCHGROUP    Required

                            WID-LIST-GROUP        -> CGR-LIST-GROUP

Wfchinfo       WFCHINFO     Required

                            WID-INFORMATION       -> INF-INFORMATION

Wfchrulhdr     WFCHRULHDR   Required

                            WID-RULETAG           -> RLH-RULETAG

                         WFCHINFDTL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfchpub        WFCHPUB

                            WID-INFORMATION       -> WPB-INFORMATION
                            WID-RULETAG           -> WPB-RULETAG
                                                     WPB-PUBLISH

Wfchsubscr     WFCHSUBSCR

                            WID-LIST-GROUP        -> SUB-LIST-GROUP
                                                     SUB-DIRECTORY-ID

Wfchusrcdi     WFCHUSRCDI

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