Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BSIDCHFLDI


                            BSIDCHFLDI FILE

                        ID Channel Field Detail

The publications available to a given ID.

REFERENCED BY

BS10.1    BS10.2    BS10.3    BS19.1    BS19.2    BS19.3

UPDATED BY

BS190     BS90.1    BS90.2    BS90.3    BS90.4    BS99.3
BS99.1    BS99.2    BS30.1    BS39.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

FIF-ID                 Alpha 20  (Lower Case)                    BS99.3
Element: Id            The user ID to whom this publication
                       has been distributed.

FIF-CHANNEL            Alpha 20                                  BS99.3
Element: Channel       The name of a channel. Channels are the
                       highest level grouping available for
                       Broadcasting System reports.

FIF-FOLDER             Alpha 20                                  BS99.3
Element: Folder        The name of a folder. Folders are the
                       secondary mechanism for organizing
                       Broadcasting System reports. Multiple
                       folders can exist within each channel.

FIF-INFORMATION        Alpha 20  (Lower Case)                    BS99.3
Element: Information   The information name from which this
                       publication was generated.

FIF-RULE-TAG           Alpha 15                                  BS99.3
Element: Rule Tag      The rule that is associated with this
                       publication.

FIF-ORDER-OPT          Numeric 4                                 BS99.3
Element: Order Opt     The field used for re-sorting
                       publications in the eBroadcast viewer.

FIF-PUBLISH            Numeric 12                                BS190   BS90.1
Element: Publish       The unique number for this publication.   BS90.2  BS90.3
                       It was generated by the InfoDistAgent.    BS90.4  BS99.3

FIF-MULT-PUBLISH       Alpha 1                                   BS190   BS90.1
Element: Mult Publish  Determines whether there are other        BS90.4  BS99.3
                       publications generated for this same
                       section of the report. It is used by the
                       eBroadcast viewer to  determine whether
                       or not there is publication history.
                       N = No
                       Y = Yes

FIF-SUBSCRIBE          Alpha 1                                   BS99.3
Element: Subscribe     Identifies whether the ID associated
                       with this publication has subsubscribed
                       or unsubscribed to this publication.
                       A = All
                       N = No
                       Y = Yes

FIF-NOTIFY             Numeric 1                                 BS99.3
Element: Notify        Determines whether the ID associated
                       with this record has entered a
                       notification preference.
                       1 = Generally not notified
                       2 = Generally notified
                       3 = Always notified
                       4 = Never notified

FIF-DELIVERY           Alpha 1                                   BS99.3
Element: Delivery      Sets the method of delivery if the ID
                       associated with this record has chosen
                       the notification option.
                       A = Attachment to Email
                       U = URL

FIF-DATE               Numeric 8  (yyyymmdd)                     BS99.3
Element: Date          This field contains the system date
                       when this was created.

FIF-TIME               Numeric 6  (hhmmss)                       BS99.3
Element: Time

FIF-SH-INFO-DESC       Derived
Element: Sh Info Desc

                         BSIDCHFLDI FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

FIFSET1   ID                                                     BS99.1  BS99.2
          CHANNEL                                                BS99.3
          FOLDER
          INFORMATION
          RULE-TAG

FIFSET2   CHANNEL
          FOLDER
          ID
          INFORMATION
          RULE-TAG

FIFSET3   FOLDER                                                 BS10.1  BS10.2
          CHANNEL                                                BS10.3  BS19.1
          ID                                                     BS19.2  BS19.3
          INFORMATION
          RULE-TAG

FIFSET4   INFORMATION                                            BS190   BS30.1
          RULE-TAG                                               BS39.1  BS90.1
          FOLDER                                                 BS90.2  BS90.3
          CHANNEL                                                BS90.4
          ID

FIFSET5   FOLDER
          ID
          CHANNEL
          INFORMATION
          RULE-TAG

FIFSET6   FOLDER
          INFORMATION
          RULE-TAG
          ID
          CHANNEL

FIFSET7   ID            KeyChange
          CHANNEL
          FOLDER
          ORDER-OPT
          INFORMATION
          RULE-TAG

FIFSET8   CHANNEL       KeyChange
          ID
          FOLDER
          INFORMATION
          RULE-TAG

FIFSET9   INFORMATION
          RULE-TAG
          ID
          FOLDER
          CHANNEL

                         BSIDCHFLDI FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bschannel      BSCHANNEL    Not Required

                            FIF-CHANNEL        -> BCH-CHANNEL  (BCHSET1)

Bsfolder       BSFOLDER     Required

                            FIF-FOLDER         -> BFD-FOLDER

Bsidchfld      BSIDCHFLD    Not Required

                            FIF-ID             -> ICF-ID
                            FIF-CHANNEL        -> ICF-CHANNEL
                            FIF-FOLDER         -> ICF-FOLDER

Bsidpub        BSIDPUB      Not Required

                            FIF-ID             -> IPB-ID
                            FIF-PUBLISH        -> IPB-PUBLISH

Bsinfohdr      BSINFOHDR    Not Required

                            FIF-INFORMATION    -> INF-INFORMATION

Bsrulehdr      BSRULEHDR    Required

                            FIF-RULE-TAG       -> RLH-RULE-TAG

Sirdidhdr      SIRDIDHDR    Not Required

                            FIF-ID             -> IDH-ID

                         BSIDCHFLDI FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bspublish      BSPUBLISH

                            FIF-INFORMATION    -> PUB-INFORMATION
                            FIF-RULE-TAG       -> PUB-RULE-TAG
                                                  PUB-RUN-SEQ
                                                  PUB-PUBLISH