Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SISCHED


                              SISCHED FILE

UPDATED BY

RD03.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SSD-WEB-USER           Alpha 80  (Lower Case)                    RD03.1
Element: Web User

SSD-SEQ-NUMBER         Numeric 10                                RD03.1
Element: Seq Number

SSD-DATE               Numeric 8  (yyyymmdd)                     RD03.1
Element: Date          This field contains the system date
                       when this was created.

SSD-TIME               Numeric 6  (hhmmss)                       RD03.1
Element: Time

SSD-TO-TIME            Numeric 6  (hhmmss)                       RD03.1
Element: To Time

SSD-MEMO               Alpha 99  (Lower Case)                    RD03.1
Element: Memo

SSD-PLACE              Alpha 15  (Lower Case)                    RD03.1
Element: Place

SSD-CAL-TYPE           Alpha 2                                   RD03.1
Element: Cal Type      CE = Corporate Event
                       IE = Industry Event
                       SE = Special Event

SSD-VIEW               Alpha 1                                   RD03.1
Element: View          N = Not Private
                       P = Private

SSD-DETAIL             Alpha 256  (Lower Case)                   RD03.1
Element: Detail

SSD-ACTIVITY-GRP       Alpha 15                                  RD03.1
Element: Activity Grp

SSD-ACTIVITY           Alpha 15                                  RD03.1
Element: Activity

                         SISCHED FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SSDSET1   WEB-USER                                               RD03.1
          SEQ-NUMBER

SSDSET2   WEB-USER      KeyChange
          DATE
          TIME
          SEQ-NUMBER

SSDSET3   ACTIVITY      KeyChange
          SEQ-NUMBER
          WEB-USER

SSDSET4   ACTIVITY-GRP  KeyChange
          ACTIVITY
          SEQ-NUMBER
          WEB-USER

                         SISCHED FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sirdidhdr      SIRDIDHDR    Not Required, Delete Restricted

                            SSD-WEB-USER    -> IDH-WEB-USER  (IDHSET7)

Webuser        WEBUSER      Required

                            SSD-WEB-USER    -> WUR-WEB-USER