Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

BSIDCHFLD


                             BSIDCHFLD FILE

                            ID Channel Field

The folders available to a given ID.

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

ICF-ID                 Alpha 20  (Lower Case)                    BS99.2
Element: Id            This is the user ID to whom this
                       information belongs.

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

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

ICF-ORDER-OPT          Numeric 4                                 BS99.2
Element: Order Opt     A user preference that determines the
                       sort order used by the eBroadcast viewer
                       for folders in a channel

ICF-SUBSCRIBE          Alpha 1                                   BS99.2
Element: Subscribe     Determines whether the ID in this file
                       has set preferences to subscribe or
                       unsubscribe.
                       A = Active
                       I = Inactive

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

ICF-TIME               Numeric 6  (hhmmss)                       BS99.2
Element: Time

                         BSIDCHFLD FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

ICFSET1   ID                                                     BS99.1  BS99.2
          CHANNEL                                                BS99.3
          FOLDER

ICFSET2   CHANNEL
          FOLDER
          ID

ICFSET3   FOLDER                                                 BS10.1  BS10.2
          CHANNEL                                                BS10.3  BS19.1
          ID                                                     BS19.2  BS19.3

ICFSET4   FOLDER
          ID
          CHANNEL

ICFSET5   CHANNEL
          ID
          FOLDER

ICFSET6   ID
          FOLDER
          CHANNEL

ICFSET7   ID            KeyChange
          CHANNEL
          ORDER-OPT
          FOLDER

                         BSIDCHFLD FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bschannel      BSCHANNEL    Not Required

                            ICF-CHANNEL    -> BCH-CHANNEL  (BCHSET1)

Bsfolder       BSFOLDER     Required

                            ICF-FOLDER     -> BFD-FOLDER

Bsidchan       BSIDCHAN     Not Required

                            ICF-ID         -> ICH-ID
                            ICF-CHANNEL    -> ICH-CHANNEL

Sirdidhdr      SIRDIDHDR    Not Required

                            ICF-ID         -> IDH-ID

                         BSIDCHFLD FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Bsidchfldi     BSIDCHFLDI

                            ICF-ID         -> FIF-ID
                            ICF-CHANNEL    -> FIF-CHANNEL
                            ICF-FOLDER     -> FIF-FOLDER
                                              FIF-INFORMATION
                                              FIF-RULE-TAG