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 |
TR04.1 | TR04.3 | TR120 | TR121 | TR20.1 | TR20.2 |
TR20.3 | TR20.4 |
FIELD NAME | DESCRIPTION/VALID VALUES | UPDATED BY | ||||||||
---|---|---|---|---|---|---|---|---|---|---|
SES-COURSE Element: Course Code | Alpha 10 Contains the course code. |
|
||||||||
SES-SESSION Element: Session | Numeric 5 Contains the session number. |
|
||||||||
SES-START-DATE Element: Session Start Date | Numeric 8 (yyyymmdd) Contains the session start date. The course start date defaults. |
|
||||||||
SES-END-DATE Element: Session End Date | Numeric 8 (yyyymmdd) Contains the session end date. |
|
||||||||
SES-FACILITY Element: Facility | Alpha 10 Contains the facility in which the session will be held. |
|
||||||||
SES-SITE Element: Site | Alpha 30 (Lower Case) Contains the session location. |
|
||||||||
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 |
|
||||||||
SES-DURATION Element: Duration | Alpha 60 (Lower Case) Contains additional information on session dates and times. |
|
||||||||
SES-START-TIME Starting Time on First Date | Numeric 6 (hhmmss) Contains the starting time for the first day of the session. |
|
||||||||
SES-END-TIME Ending Time on Last Date | Numeric 6 (hhmmss) Contains the ending time for the last day of the session. |
|
||||||||
SES-COURSE-TYPE Element: Course Type | Alpha 10 Indicates the type of course. |
|
||||||||
SES-ENROLL-MIN Element: Minimum Enrollment | Numeric 3 Indicates the minimum number of session participants. |
|
||||||||
SES-ENROLL-MAX Element: Maximum Enrollment | Numeric 3 Indicates the maximum number of session participants. |
|
||||||||
SES-COURSE-FILL-DT Date Course Was Filled | Numeric 8 (yyyymmdd) Contains the date the course is filled. |
|
||||||||
SES-START-REG-DATE Registration Start Date | Numeric 8 (yyyymmdd) Contains the date registration begins. |
|
||||||||
SES-END-REG-DATE Registration End Date | Numeric 8 (yyyymmdd) Contains the date registration ends. |
|
||||||||
SES-CONFIRMED-PART Confirmed Participants | Numeric 3 Contains the number of confirmed participants. |
|
||||||||
SES-WAITLIST Registrants on Wait List | Numeric 3 Contains the number of registrants on the wait list. |
|
||||||||
SES-REASON Element: Cancellation Reason | Alpha 10 Contains the reason the session was canceled. |
|
||||||||
SES-OVERALL-EVAL Element: Overall Evaluation | Signed 7.2 Indicates the session's quality or usefulness. |
|
||||||||
SES-OVERLL-EVAL-BS Element: Base | Signed 7.2 Contains the total number upon which the overall evaluation is based. |
|
||||||||
SES-MATERIALS-EVAL Element: Materials Evaluation | Signed 7.2 Indicates the materials' quality or usefulness. |
|
||||||||
SES-MATERL-EVAL-BS Element: Base | Signed 7.2 Contains the total number on which the materials evaluation is based. |
|
||||||||
SES-PERPETUAL Element: Perpetual | Alpha 1 Indicates whether this is an on-going class. Y = Yes N = No; Default value |
|
||||||||
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. |
|
||||||||
SES-SHORT-DURATION Element: Short Duration | Derived Contains a short form of the duration. Used for the Drill Around feature. |
|
NAME | KEY FIELDS | DESCRIPTION / SUBSET CONDITION | USED IN | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SESSET1 |
COURSE SESSION START-DATE |
|
| ||||||||||||||||||||||||||||
SESSET2 |
COURSE START-DATE SESSION |
|
| ||||||||||||||||||||||||||||
SESSET3 |
OBJ-ID |
|
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cancel | PCODES |
Not Required
| ||||||||||||
Cancel Reason | PCODES |
Required
| ||||||||||||
Course Type | PCODES |
Required
| ||||||||||||
Facility | PCODES |
Required
|
RELATION NAME |
RELATED FILE | INTEGRITY RULES / FIELD MATCH | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Cost | PASCOST |
Delete Cascades
| ||||||||||||||||||
Course | PACOURSE |
| ||||||||||||||||||
Course Instr | PAINSCOURS |
| ||||||||||||||||||
Inst Objid | PAINSTSES |
| ||||||||||||||||||
Instructor | PAINSTSES |
Delete Cascades
| ||||||||||||||||||
Reg Objid | PAREGISTER |
| ||||||||||||||||||
Register | PAREGISTER |
Delete Cascades
| ||||||||||||||||||
Train Hist | PATRNHIST |
| ||||||||||||||||||
Trng Compet | EMPCODES |
|
All trademarks and registered trademarks are the property of their
respective owners.