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
TR09.1 TR11.1 TR200 TR202 TR204 TR207
TR22.1 TR220 TR221 TR26.1 TR01.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 TR26.1
Session Contains the session number.
SES-START-DATE Numeric 8 (yyyymmdd) TR04.1 TR26.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 TR04.1 TR04.2
SESSION TR04.3 TR09.1
START-DATE 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 TR26.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
Training Skill EMPCODES
SES-OBJ-ID -> EPC-OBJ-ID
"SK" -> EPC-TYPE
EPC-COMPANY
EPC-EMP-APP
EPC-EMPLOYEE
EPC-CODE
|