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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

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 SET3
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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
SESSET1
  1. COURSE
  2. SESSION
  3. START-DATE
PrimaryHS50.3, HS50.4, TR04.1, TR04.2, TR04.3, TR09.1, TR11.1, TR120 +14 more
SESSET2
  1. COURSE
  2. START-DATE
  3. SESSION
TR01.1
SESSET3
  1. OBJ-ID
TR21.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PCODESPASCOSTPACOURSEPAINSCOURSPAINSTSESPAREGISTERPATRNHISTEMPCODESPASESSION

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 Cascades
SES-COURSE→COS-COURSE
SES-SESSION→COS-SESSION
SES-START-DATE→COS-START-DATE
—→COS-COST-TYPE
—→COS-COST-CAT
CoursePACOURSE
SES-COURSE→CRS-COURSE
—→CRS-EFFECTIVE-DATE
Course InstrPAINSCOURS
SES-COURSE→INC-COURSE
—→INC-INSTRUCT
Inst ObjidPAINSTSES
SES-OBJ-ID→ISE-OBJ-ID
—→ISE-INSTRUCT
—→ISE-INSTR-TYPE
InstructorPAINSTSESDelete Cascades
SES-COURSE→ISE-COURSE
SES-SESSION→ISE-SESSION
SES-START-DATE→ISE-START-DATE
—→ISE-INSTR-TYPE
—→ISE-INSTRUCT
Reg ObjidPAREGISTER
SES-OBJ-ID→REG-OBJ-ID
—→REG-COMPANY
—→REG-EMPLOYEE
RegisterPAREGISTERDelete Cascades
SES-COURSE→REG-COURSE
SES-SESSION→REG-SESSION
SES-START-DATE→REG-START-DATE
—→REG-COMPANY
—→REG-EMPLOYEE
Train HistPATRNHIST
SES-OBJ-ID→TRH-OBJ-ID
—→TRH-COMPANY
—→TRH-EMPLOYEE
Trng CompetEMPCODES
SES-OBJ-ID→EPC-OBJ-ID
—→EPC-COMPANY
—→EPC-EMP-APP
—→EPC-EMPLOYEE
—→EPC-TYPE
—→EPC-CODE

Programs

Updated by (8)

Referenced by (15)