Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PASESSION


                             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     TR201
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
Element: Course Code   Contains the course code.

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

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

SES-END-DATE           Numeric 8  (yyyymmdd)                     TR04.1
Element: Session End DaContains the session end date.

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

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

SES-SESSION-STATUS     Alpha 2                                   TR04.1  TR120
Element: Session StatusIndicates 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
Element: 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
Element: Course Type   Indicates the type of course.

SES-ENROLL-MIN         Numeric 3                                 TR04.1
Element: Minimum EnrollIndicates the minimum number of session
                       participants.

SES-ENROLL-MAX         Numeric 3                                 TR04.1  TR120
Element: Maximum EnrollIndicates 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
Element: Cancellation RContains the reason the session was
                       canceled.

SES-OVERALL-EVAL       Signed 7.2                                TR04.1  TR04.3
Element: Overall EvaluaIndicates the session's quality or
                       usefulness.

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

SES-MATERIALS-EVAL     Signed 7.2                                TR04.1  TR04.3
Element: Materials EvalIndicates the materials' quality or
                       usefulness.

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

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

SES-OBJ-ID             Numeric 12                                TR04.1
Element: Obj Id        This is the object identifier. It is
                       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
Element: Short DurationContains 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   TR201
                                                                 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

Cancel Reason  PCODES       Required
                            When (SES-REASON != Spaces )

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

Course Type    PCODES       Required
                            When (SES-COURSE-TYPE != Spaces )

                            "CT"               -> PCO-TYPE
                            SES-COURSE-TYPE    -> PCO-CODE

Facility       PCODES       Required
                            When SES-FACILITY != Spaces

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

                         PASESSION FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Cost           PASCOST      Delete Cascades

                            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   Delete Cascades

                            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