PASESSION

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 TR207 TR22.1 TR220
TR221 TR21.1


UPDATED BY
TR04.1 TR04.3 TR120 TR121 TR20.1 TR20.2
TR20.3 TR20.4 HS50.3 HS50.4 TR201 TR202
TR204 TR26.1 TR01.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
SES-COURSE
Element: Course Code		Alpha 10
Contains the course code.
TR04.1
SES-SESSION
Element: Session		Numeric 5
Contains the session number.
TR04.1
SES-START-DATE
Element: Session Start Date		Numeric 8 (yyyymmdd)
Contains the session start date. The course start date defaults.
TR04.1
SES-END-DATE
Element: Session End Date		Numeric 8 (yyyymmdd)
Contains the session end date.
TR04.1
SES-FACILITY
Element: Facility		Alpha 10
Contains the facility in which the session will be held.
TR04.1
SES-SITE
Element: Site		Alpha 30 (Lower Case)
Contains the session location.
TR04.1
SES-SESSION-STATUS
Element: Session Status		Alpha 2
Indicates 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
Element: Duration		Alpha 60 (Lower Case)
Contains additional information on session dates and times.
TR04.1
SES-START-TIME
Starting Time on
First Date		Numeric 6 (hhmmss)
Contains the starting time for the first day of the session.
TR04.1
SES-END-TIME
Ending Time on Last
Date		Numeric 6 (hhmmss)
Contains the ending time for the last day of the session.
TR04.1
SES-COURSE-TYPE
Element: Course Type		Alpha 10
Indicates the type of course.
TR04.1
SES-ENROLL-MIN
Element: Minimum Enrollment		Numeric 3
Indicates the minimum number of session participants.
TR04.1
SES-ENROLL-MAX
Element: Maximum Enrollment		Numeric 3
Indicates the maximum number of session participants.
TR04.1 TR120
TR121
SES-COURSE-FILL-DT
Date Course Was
Filled		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
Registration Start
Date		Numeric 8 (yyyymmdd)
Contains the date registration begins.
TR04.1
SES-END-REG-DATE
Registration End
Date		Numeric 8 (yyyymmdd)
Contains the date registration ends.
TR04.1
SES-CONFIRMED-PART
Confirmed
Participants		Numeric 3
Contains the number of confirmed participants.
TR04.1 TR120
TR121 TR20.1
TR20.2 TR20.3
TR20.4
SES-WAITLIST
Registrants on Wait
List		Numeric 3
Contains the number of registrants on the wait list.
TR04.1 TR120
TR121 TR20.1
TR20.2 TR20.3
TR20.4
SES-REASON
Element: Cancellation Reason		Alpha 10
Contains the reason the session was canceled.
TR04.1
SES-OVERALL-EVAL
Element: Overall Evaluation		Signed 7.2
Indicates the session's quality or usefulness.
TR04.1 TR04.3
SES-OVERLL-EVAL-BS
Element: Base		Signed 7.2
Contains the total number upon which the overall evaluation is based.
TR04.1 TR04.3
SES-MATERIALS-EVAL
Element: Materials Evaluation		Signed 7.2
Indicates the materials' quality or usefulness.
TR04.1 TR04.3
SES-MATERL-EVAL-BS
Element: Base		Signed 7.2
Contains the total number on which the materials evaluation is based.
TR04.1 TR04.3
SES-PERPETUAL
Element: Perpetual		Alpha 1
Indicates whether this is an on-going class. Y = Yes N = No; Default value
TR04.1
SES-OBJ-ID
Element: Obj Id		Numeric 12
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.
TR04.1
SES-SHORT-DURATION
Element: Short Duration		Derived
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
SESSION
START-DATE
HS50.3 HS50.4
TR04.1 TR04.2
TR04.3 TR09.1
TR11.1 TR120
TR121 TR20.1
TR20.2 TR20.3
TR20.4 TR200
TR201 TR202
TR204 TR207
TR22.1 TR220
TR221 TR26.1
SESSET2 COURSE
START-DATE
SESSION
TR01.1
SESSET3 OBJ-ID
TR21.1


PASESSION FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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

File created: Wed Jun 08 20:50:26 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.