Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PASESSION FILE

                                Sessions

Contains session information for each course. Each course can have an
unlimited number of sessions. A session record remains in place as long as
there is registration information for the session. A session cannot be deleted
until all registration information is removed from the Registration
Information file.

TR04.1 (Session) is the primary program that updates this file.

REFERENCED BY

HS50.3    HS50.4    TR09.1    TR11.1    TR200     TR202
TR204     TR207     TR22.1    TR220     TR221     TR26.1
TR01.1    TR21.1

UPDATED BY

TR04.1    TR04.3    TR120     TR121     TR20.1    TR20.2
TR20.3

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

SES-COURSE           Alpha 10                                    TR04.1
Course Code          Contains the course code.

SES-SESSION          Numeric 5                                   TR04.1
Session              Contains the session number.

SES-START-DATE       Numeric 8  (yyyymmdd)                       TR04.1
Session Start Date   Contains the session start date. The
                     course start date defaults.

SES-END-DATE         Numeric 8  (yyyymmdd)                       TR04.1
Session End Date     Contains the session end date.

SES-FACILITY         Alpha 10                                    TR04.1
Facility             Contains the facility in which the
                     session will be held.

SES-SITE             Alpha 30  (Lower Case)                      TR04.1
Site                 Contains the session location.

SES-SESSION-STATUS   Alpha 2                                     TR04.1  TR120
Session Status       Indicates the session status.               TR121   TR20.1
                     OP = Open; Default value.                   TR20.2  TR20.3
                     FL = Filled
                     FA = Filled - Active Wait List
                     PR = Proposed
                     CN = Canceled
                     CM = Completed

SES-DURATION         Alpha 60  (Lower Case)                      TR04.1
Duration             Contains additional information on
                     session dates and times.

SES-START-TIME       Numeric 6  (hhmmss)                         TR04.1
Starting Time on     Contains the starting time for the
First Date           first day of the session.

SES-END-TIME         Numeric 6  (hhmmss)                         TR04.1
Ending Time on Last  Contains the ending time for the last
Date                 day of the session.

SES-COURSE-TYPE      Alpha 10                                    TR04.1
Course Type          Indicates the type of course.

SES-ENROLL-MIN       Numeric 3                                   TR04.1
Minimum Enrollment   Indicates the minimum number of session
                     participants.

SES-ENROLL-MAX       Numeric 3                                   TR04.1  TR120
Maximum Enrollment   Indicates the maximum number of session     TR121
                     participants.

SES-COURSE-FILL-DT   Numeric 8  (yyyymmdd)                       TR04.1  TR120
Date Course Was      Contains the date the course is filled.     TR121   TR20.1
Filled                                                           TR20.2  TR20.3

SES-START-REG-DATE   Numeric 8  (yyyymmdd)                       TR04.1
Registration Start   Contains the date registration begins.
Date

SES-END-REG-DATE     Numeric 8  (yyyymmdd)                       TR04.1
Registration End     Contains the date registration ends.
Date

SES-CONFIRMED-PART   Numeric 3                                   TR04.1  TR120
Confirmed            Contains the number of confirmed            TR121   TR20.1
Participants         participants.                               TR20.2  TR20.3

SES-WAITLIST         Numeric 3                                   TR04.1  TR120
Registrants on Wait  Contains the number of registrants on       TR121   TR20.1
List                 the wait list.                              TR20.2  TR20.3

SES-REASON           Alpha 10                                    TR04.1
Cancellation Reason  Contains the reason the session was
                     canceled.

SES-OVERALL-EVAL     Signed 7.2                                  TR04.1  TR04.3
Overall Evaluation   Indicates the session's quality or
                     usefulness.

SES-OVERLL-EVAL-BS   Signed 7.2                                  TR04.1  TR04.3
Base                 Contains the total number upon which
                     the overall evaluation is based.

SES-MATERIALS-EVAL   Signed 7.2                                  TR04.1  TR04.3
Materials Evaluation Indicates the materials' quality or
                     usefulness.

SES-MATERL-EVAL-BS   Signed 7.2                                  TR04.1  TR04.3
Base                 Contains the total number on which the
                     materials evaluation is based.

SES-PERPETUAL        Alpha 1                                     TR04.1
Perpetual            Indicates whether this is an on-going
                     class.
                     Y = Yes
                     N = No; Default value

SES-OBJ-ID           Numeric 12                                  TR04.1
Object               This is the object identifier. It is
Identification       used to relate commitments or posted
                     transactions back to the originating
                     subsystems. Each subsystem record that
                     is updated as a commitment or posted
                     transaction is assigned an object
                     identifier. The object identifier is
                     maintained in the subsystem files and in
                     the Activity Commitments Detail and
                     Activity Transaction files. The object
                     identifier is a unique key used to drill
                     back from Activity Management to the
                     subsystems.

SES-SHORT-DURATION   Derived
Short Duration       Contains a short form of the duration.
                     Used for the Drill Around feature.

                         PASESSION FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SESSET1   COURSE                                                 HS50.3  HS50.4
          SESSION                                                TR04.1  TR04.2
          START-DATE                                             TR04.3  TR09.1
                                                                 TR11.1  TR120
                                                                 TR121   TR20.1
                                                                 TR20.2  TR20.3
                                                                 TR200   TR202
                                                                 TR204   TR207
                                                                 TR22.1  TR220
                                                                 TR221   TR26.1

SESSET2   COURSE                                                 TR01.1
          START-DATE
          SESSION

SESSET3   OBJ-ID                                                 TR21.1

                         PASESSION FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cancel         PCODES       Not Required

                            "RC"              -> PCO-TYPE
                            SES-REASON        -> PCO-CODE

Facility       PCODES       Not Required

                            "FC"              -> PCO-TYPE
                            SES-FACILITY      -> PCO-CODE

                         PASESSION FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cost           PASCOST

                            SES-COURSE        -> COS-COURSE
                            SES-SESSION       -> COS-SESSION
                            SES-START-DATE    -> COS-START-DATE
                                                 COS-COST-TYPE
                                                 COS-COST-CAT

Course         PACOURSE

                            SES-COURSE        -> CRS-COURSE
                                                 CRS-EFFECTIVE-DATE

Course Instr   PAINSCOURS

                            SES-COURSE        -> INC-COURSE
                                                 INC-INSTRUCT

Inst Objid     PAINSTSES

                            SES-OBJ-ID        -> ISE-OBJ-ID
                                                 ISE-INSTRUCT
                                                 ISE-INSTR-TYPE

Instructor     PAINSTSES    Delete Cascades

                            SES-COURSE        -> ISE-COURSE
                            SES-SESSION       -> ISE-SESSION
                            SES-START-DATE    -> ISE-START-DATE
                                                 ISE-INSTR-TYPE
                                                 ISE-INSTRUCT

Reg Objid      PAREGISTER

                            SES-OBJ-ID        -> REG-OBJ-ID
                                                 REG-COMPANY
                                                 REG-EMPLOYEE

Register       PAREGISTER

                            SES-COURSE        -> REG-COURSE
                            SES-SESSION       -> REG-SESSION
                            SES-START-DATE    -> REG-START-DATE
                                                 REG-COMPANY
                                                 REG-EMPLOYEE

Train Hist     PATRNHIST

                            SES-OBJ-ID        -> TRH-OBJ-ID
                                                 TRH-COMPANY
                                                 TRH-EMPLOYEE

Trng Compet    EMPCODES

                            SES-OBJ-ID        -> EPC-OBJ-ID
                                                 EPC-COMPANY
                                                 EPC-EMP-APP
                                                 EPC-EMPLOYEE
                                                 EPC-TYPE
                                                 EPC-CODE