WFCHSUBSCR FILE

                          Channels Subscriber

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SUB-LIST-GROUP       Alpha 15
List Group

SUB-DIRECTORY-ID     Numeric 15
Directory Id

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

SUB-SUBSCRIBE-TYPE   Alpha 1
Subscribe Type       A = Add
                     E = Exclude

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

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


                         WFCHSUBSCR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SUBSET1   LIST-GROUP
          DIRECTORY-ID

SUBSET2   DIRECTORY-ID
          LIST-GROUP

                         WFCHSUBSCR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfchgroup      WFCHGROUP    Required

                            SUB-LIST-GROUP      -> CGR-LIST-GROUP  (CGRSET1)

Wfrdidhdr      WFRDIDHDR    Required

                            SUB-DIRECTORY-ID    -> WDR-DIRECTORY-ID

                         WFCHSUBSCR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfchinfdtl     WFCHINFDTL

                            SUB-LIST-GROUP      -> WID-LIST-GROUP
                                                   WID-INFORMATION
                                                   WID-RULETAG
                                                   WID-DIRECTORY-NAME

Wfchlstgrp     WFCHLSTGRP

                            SUB-DIRECTORY-ID    -> LGR-DIRECTORY-ID
                                                   LGR-SEQ-NUMBER
                                                   LGR-LIST-GROUP
                                                   LGR-LIST