PASESSION – Sessions

System
Personnel (PA)
Prefix
SES
Primary key
COURSE, SESSION, START-DATE
Fields
26
Updated by
8 programs
Referenced by
15 programs

PASESSION is the Sessions table in Lawson Personnel (prefix SES). It is indexed by COURSE, SESSION, START-DATE (SESSET1); alternate indexes: SESSET2 and SESSET3. It is related 1:1 to PCODES and 1:M to PASCOST, PACOURSE, PAINSCOURS, PAINSTSES, PAREGISTER, PATRNHIST and EMPCODES. It is updated by TR04.1, TR04.3, TR120, TR121, TR20.1, TR20.2, TR20.3 and TR20.4 and referenced by HS50.3, HS50.4, TR01.1, TR09.1, TR11.1, TR200, TR201, TR202 and 7 more. The table has 26 fields, 3 indexes and 13 documented relations.

About PASESSION

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.

Fields (26)

Column = COBOL field name without the SES- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
SES-COURSE PK
COURSE		Alpha 10Contains the course code.TR04.1
SES-SESSION PK
SESSION		Numeric 5Contains the session number.TR04.1
SES-START-DATE PK
START_DATE		Numeric 8 (yyyymmdd)Contains the session start date. The course start date defaults.TR04.1
SES-END-DATE
END_DATE		Numeric 8 (yyyymmdd)Contains the session end date.TR04.1
SES-FACILITY
FACILITY		Alpha 10Contains the facility in which the session will be held.TR04.1
SES-SITE
SITE		Alpha 30 (Lower Case)Contains the session location.TR04.1
SES-SESSION-STATUS
SESSION_STATUS		Alpha 2Indicates the session status.
  • OP Open; Default value.
  • FL Filled
  • FA Filled - Active Wait List
  • PR Proposed
  • CN Canceled
  • CM Completed
TR04.1, TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4
SES-DURATION
DURATION		Alpha 60 (Lower Case)Contains additional information on session dates and times.TR04.1
SES-START-TIME
START_TIME		Numeric 6 (hhmmss)Contains the starting time for the first day of the session.TR04.1
SES-END-TIME
END_TIME		Numeric 6 (hhmmss)Contains the ending time for the last day of the session.TR04.1
SES-COURSE-TYPE
COURSE_TYPE		Alpha 10Indicates the type of course.TR04.1
SES-ENROLL-MIN
ENROLL_MIN		Numeric 3Indicates the minimum number of session participants.TR04.1
SES-ENROLL-MAX
ENROLL_MAX		Numeric 3Indicates the maximum number of session participants.TR04.1, TR120, TR121
SES-COURSE-FILL-DT
COURSE_FILL_DT		Numeric 8 (yyyymmdd)Contains the date the course is filled.TR04.1, TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4
SES-START-REG-DATE
START_REG_DATE		Numeric 8 (yyyymmdd)Contains the date registration begins.TR04.1
SES-END-REG-DATE
END_REG_DATE		Numeric 8 (yyyymmdd)Contains the date registration ends.TR04.1
SES-CONFIRMED-PART
CONFIRMED_PART		Numeric 3Contains the number of confirmed participants.TR04.1, TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4
SES-WAITLIST
WAITLIST		Numeric 3Contains the number of registrants on the wait list.TR04.1, TR120, TR121, TR20.1, TR20.2, TR20.3, TR20.4
SES-REASON
REASON		Alpha 10Contains the reason the session was canceled.TR04.1
SES-OVERALL-EVAL
OVERALL_EVAL		Signed 7.2Indicates the session's quality or usefulness.TR04.1, TR04.3
SES-OVERLL-EVAL-BS
OVERLL_EVAL_BS		Signed 7.2Contains the total number upon which the overall evaluation is based.TR04.1, TR04.3
SES-MATERIALS-EVAL
MATERIALS_EVAL		Signed 7.2Indicates the materials' quality or usefulness.TR04.1, TR04.3
SES-MATERL-EVAL-BS
MATERL_EVAL_BS		Signed 7.2Contains the total number on which the materials evaluation is based.TR04.1, TR04.3
SES-PERPETUAL
PERPETUAL		Alpha 1Indicates whether this is an on-going class.
  • Y Yes
  • N No; Default value
TR04.1
SES-OBJ-ID
OBJ_ID		Numeric 12This 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.TR04.1
SES-SHORT-DURATION
SHORT_DURATION		DerivedContains a short form of the duration. Used for the Drill Around feature.—

Indexes (3)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
SESSET1COURSE, SESSION, START-DATEPrimaryHS50.3, HS50.4, TR04.1, TR04.2, TR04.3, TR09.1, TR11.1, TR120 +14 more
SESSET2COURSE, START-DATE, SESSIONTR01.1
SESSET3OBJ-IDTR21.1

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CancelPCODESNot Required"RC" → PCO-TYPE, SES-REASON → PCO-CODE
Cancel ReasonPCODESRequiredWhen (SES-REASON != Spaces)"RC" → PCO-TYPE, SES-REASON → PCO-CODE
Course TypePCODESRequiredWhen (SES-COURSE-TYPE != Spaces)"CT" → PCO-TYPE, SES-COURSE-TYPE → PCO-CODE
FacilityPCODESRequiredWhen SES-FACILITY != Spaces"FC" → PCO-TYPE, SES-FACILITY → PCO-CODE

One to many (9) — child tables

RelationTableRulesConditionField map
CostPASCOSTDelete CascadesSES-COURSE → COS-COURSE, SES-SESSION → COS-SESSION, SES-START-DATE → COS-START-DATE, → COS-COST-TYPE, → COS-COST-CAT
CoursePACOURSESES-COURSE → CRS-COURSE, → CRS-EFFECTIVE-DATE
Course InstrPAINSCOURSSES-COURSE → INC-COURSE, → INC-INSTRUCT
Inst ObjidPAINSTSESSES-OBJ-ID → ISE-OBJ-ID, → ISE-INSTRUCT, → ISE-INSTR-TYPE
InstructorPAINSTSESDelete CascadesSES-COURSE → ISE-COURSE, SES-SESSION → ISE-SESSION, SES-START-DATE → ISE-START-DATE, → ISE-INSTR-TYPE, → ISE-INSTRUCT
Reg ObjidPAREGISTERSES-OBJ-ID → REG-OBJ-ID, → REG-COMPANY, → REG-EMPLOYEE
RegisterPAREGISTERDelete CascadesSES-COURSE → REG-COURSE, SES-SESSION → REG-SESSION, SES-START-DATE → REG-START-DATE, → REG-COMPANY, → REG-EMPLOYEE
Train HistPATRNHISTSES-OBJ-ID → TRH-OBJ-ID, → TRH-COMPANY, → TRH-EMPLOYEE
Trng CompetEMPCODESSES-OBJ-ID → EPC-OBJ-ID, → EPC-COMPANY, → EPC-EMP-APP, → EPC-EMPLOYEE, → EPC-TYPE, → EPC-CODE

Programs

Updated by (8)

Referenced by (15)