WFRDIDHDR FILE

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

WDR-DIRECTORY-ID     Numeric 15
Directory Id

WDR-DIR-STATUS       Alpha 1
Dir Status           A = Active
                     I = Inactive
                     H = Historical

WDR-SEARCH-NAME      Alpha 30
Search Name

WDR-DIR-ID-DESC      Alpha 50  (Lower Case)
Dir Id Desc

WDR-LAST-ID-SEQ      Numeric 6
Last Id Seq

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

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


WDR-SH-ID-DESC       Derived
Sh Id Desc

                         WFRDIDHDR FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WDRSET1   DIRECTORY-ID

WDRSET2   DIRECTORY-ID  KeyChange
          DIR-STATUS

WDRSET3   SEARCH-NAME   KeyChange
          DIRECTORY-ID
          DIR-STATUS

                         WFRDIDHDR FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfrdidtemp     WFRDIDTEMP   Required

                            WDR-DIRECTORY-ID    -> DTP-DIRECTORY-ID  (DTPSET1)

                         WFRDIDHDR FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Wfchlstdtl     WFCHLSTDTL

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

Wfchlstgrp     WFCHLSTGRP

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

Wfchsubscr     WFCHSUBSCR

                            WDR-DIRECTORY-ID    -> SUB-DIRECTORY-ID
                                                   SUB-LIST-GROUP

Wfchusrcd      WFCHUSRCD

                            WDR-DIRECTORY-ID    -> UCD-DIRECTORY-ID
                                                   UCD-CHANNEL-NAME
                                                   UCD-DIRECTORY-NAME

Wfchusrch      WFCHUSRCH

                            WDR-DIRECTORY-ID    -> WUC-DIRECTORY-ID
                                                   WUC-CHANNEL-NAME

Wfrdiddtl      WFRDIDDTL

                            WDR-DIRECTORY-ID    -> WRD-DIRECTORY-ID
                                                   WRD-SEQ-NUMBER