WFCHLSTDTL FILE

                          Channels List Detail

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

LDT-LIST             Alpha 15
List

LDT-DIRECTORY-ID     Numeric 15
Directory Id

LDT-INFORM-TYPE      Numeric 1
Inform Type          1 = Generally not notified
                     2 = Generally notified
                     3 = Always notified
                     4 = Never notified

LDT-DELIVERY-TYPE    Alpha 1
Delivery Type        A = Attachment
                     E = EMail

LDT-PUBLISH-SUFFIX   Alpha 10  (Lower Case)
Publish Suffix

LDT-START-DATE       Numeric 8  (yyyymmdd)
Start Date

LDT-STOP-DATE        Numeric 8  (yyyymmdd)
Stop Date

LDT-FILTER-CATGORY   Alpha 1
Filter Catgory       Y = Yes
                     N = No

LDT-LISTDTL-STATUS   Alpha 1
Listdtl Status       A = Active
                     I = Inactive

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

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


                         WFCHLSTDTL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

LDTSET1   LIST
          DIRECTORY-ID

LDTSET2   DIRECTORY-ID
          LIST

                         WFCHLSTDTL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfchlist       WFCHLIST     Required

                            LDT-LIST            -> LIS-LIST  (LISSET1)

Wfrdidhdr      WFRDIDHDR    Required

                            LDT-DIRECTORY-ID    -> WDR-DIRECTORY-ID