Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PACOURSE


                             PACOURSE FILE

                                Courses

Contains information about each course, including dates, frequency, CEUs, and
contact person. The CEU updates TR22.1 (Session Completion). A course record
remains in the Courses file as long as there is at least one session for the
course in the Sessions file.

TR01.1 (Courses) is the primary program that updates this file.

REFERENCED BY

AC551     TR02.1    TR02.2    TR03.1    TR08.1    TR09.1
TR11.1    TR12.1    TR14.1    TR20.1    TR20.2    TR20.3
TR200     TR201     TR202     TR204     TR207     TR21.1
TR210     TR220     TR221     HS50.1    HS50.2    HS50.3
HS50.4    HS51.1    HS51.2    HS52.1    HS52.2    PA115
PA262     PA263     PA62.1    PA63.1    PA64.1    PA64.2
PA65.1    PA65.2    TR04.1    TR06.1    TR10.1    TR113
TR114     TR120     TR121     TR13.1    TR13.2    TR15.1
TR205     TR22.1    TR222     TR26.1    TR500     HR04.2
HR04.3    HR04.7    HR04.8    HR80.1    HR80.2    HR80.3
HR80.4    HR80.5    HR80.6    HR80.7    HR80.8    HR80.9
HR81.1    HR81.2    HR81.3    HR81.4    HR81.5    HR81.6
HR81.7    HR81.8    HR81.9    HR82.1    HR82.2    HR82.3
HR82.4    HR82.5    HR82.6    HR82.7    HR82.8    HR82.9
HR83.1    HR83.2    HR83.3    HR83.4    HR83.5    HR83.6
HR83.7    HR83.8    HR83.9    HR84.1    HR84.2    HR84.3
HR84.4    HR84.5    HR84.6    HR84.7    HR84.8    HR84.9
HR85.1    HR85.2    HR85.3    HR85.4    HR85.5    HR85.6
HR85.7    HR85.8    HR86.1    HR86.2    HR86.3    HR86.4
HR86.5    HR86.6    HR86.7    HR86.8    HR86.9    HR87.1
HR87.2    HR87.3    HR87.4    HR87.5    HR87.6    HR87.7
HR87.8    HR87.9    HR88.1    HR88.2    HR88.3    HR88.4
HR88.5    HR88.6    HR88.7    HR89.1    HR89.2    HR89.3
HR89.4    HR89.5    HR89.6    HR89.7

UPDATED BY

TR01.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

CRS-COURSE             Alpha 10                                  TR01.1
Element: Course Code   Contains the course code.

CRS-EFFECTIVE-DATE     Numeric 8  (yyyymmdd)                     TR01.1
Element: Effective DateContains the date the course is
                       effective.

CRS-SHORT-CRS-DESC     Alpha 30  (Lower Case)                    TR01.1  TR04.1
Element: Course Name   Contains the course name.                 TR14.1  TR200
                                                                 TR204   TR207
                                                                 TR220   TR221

CRS-COURSE-DESC        Alpha 60  (Lower Case)                    TR01.1
Element: Course DescripContains the course description.

CRS-END-DATE           Numeric 8  (yyyymmdd)                     TR01.1
Element: End Date      Contains the course ending date.

CRS-FREQ               Alpha 1                                   TR01.1
Element: Fequency      Indicates how often the course is
                       offered.
                       0 = Daily
                       1 = Weekly
                       2 = Bi-Weekly
                       3 = Monthly
                       4 = Bi-Monthly
                       5 = Semi-Monthly
                       6 = Quarterly
                       7 = Annually
                       8 = Bi-Annually
                       9 = Semi-Annually

CRS-DURATION-UNITS     Signed 5.2                                TR01.1
Length/Unit of         Contains the course duration.
Measure

CRS-DURATION-MEAS      Alpha 1                                   TR01.1
Element: Length        Contains unit in which the course
                       duration is measured.
                       H = Hours
                       D = Days
                       W = Weeks
                       M = Months
                       Q = Quarters
                       S = Semesters

CRS-CEU-AWARDED        Signed 5.2                                TR01.1
Element: CEUs Awarded  Contains the number of Continuing
                       Education Units awarded after course
                       completion.

CRS-CEU-SOURCE         Alpha 10                                  TR01.1
Element: CEU Source    Contains the source of the Continuing
                       Education Units awarded for course
                       completion.

CRS-COURSE-TYPE        Alpha 10                                  TR01.1
Element: Course Type   Contains the course type.

CRS-COURSE-CAT         Alpha 10                                  TR01.1
Element: Course CategorContains the course category.

CRS-APPROVAL-FLAG      Alpha 1                                   TR01.1
Element: Approval      Indicates whether approval is required
                       to register for the course.
                       Y = Yes
                       N = No; Default value.

CRS-FIRST-NAME         Alpha 15  (Lower Case)                    TR01.1
Element: First Name    Contains the first name of the contact
                       person.

CRS-MIDDLE-INIT        Alpha 1                                   TR01.1
Element: Middle InitialContains the middle initial of the
                       contact person.

CRS-LAST-NAME          Alpha 30  (Lower Case)                    TR01.1
Element: Last Name     Contains the last name of the contact
                       person.

CRS-SHORT-NAME         Derived
Element: Name          Contains the short name of the contact
                       person.

CRS-WK-PHONE-CNTRY     Alpha 6                                   TR01.1
Work Telephone         Contains the country code of the
Country                contact person's work telephone number.

CRS-WK-PHONE-NBR       Alpha 15                                  TR01.1
Element: Work TelephoneContains the contact person's work
                       telephone number.

CRS-WK-PHONE-EXT       Alpha 5                                   TR01.1
Work Telephone         Contains the extension for the contact
Extension              person's work telephone number.

CRS-EMAIL-USR-NAME     Alpha 30  (Lower Case)                    TR01.1
Internal E-mail        Contains the contact person's internal
Address                E-mail address.

CRS-EMAIL-DOM-NAME     Alpha 30  (Lower Case)                    TR01.1
Internet E-mail        Contains the contact person's internet
Address                E-mail address.

                         PACOURSE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

CRSSET1   COURSE                                                 AC551   TR01.1
          EFFECTIVE-DATE                                         TR02.1  TR02.2
                                                                 TR03.1  TR08.1
                                                                 TR09.1  TR11.1
                                                                 TR12.1  TR14.1
                                                                 TR20.1  TR20.2
                                                                 TR20.3  TR200
                                                                 TR201   TR202
                                                                 TR204   TR207
                                                                 TR21.1  TR210
                                                                 TR220   TR221

CRSSET2   COURSE                                                 HS50.1  HS50.2
          EFFECTIVE-DATE*                                        HS50.3  HS50.4
                                                                 HS51.1  HS51.2
                                                                 HS52.1  HS52.2
                                                                 PA115   PA262
                                                                 PA263   PA62.1
                                                                 PA63.1  PA64.1
                                                                 PA64.2  PA65.1
                                                                 PA65.2  TR01.1
                                                                 TR02.1  TR02.2
                                                                 TR03.1  TR04.1
                                                                 TR06.1  TR09.1
                                                                 TR10.1  TR11.1
                                                                 TR113   TR114
                                                                 TR120   TR121
                                                                 ...

CRSSET3   COURSE-CAT    KeyChange, Subset                        HR04.2  HR04.3
          COURSE        Where (COURSE-CAT != Spaces )            HR04.7  HR04.8
          EFFECTIVE-DATE*                                        HR80.1  HR80.2
                                                                 HR80.3  HR80.4
                                                                 HR80.5  HR80.6
                                                                 HR80.7  HR80.8
                                                                 HR80.9  HR81.1
                                                                 HR81.2  HR81.3
                                                                 HR81.4  HR81.5
                                                                 HR81.6  HR81.7
                                                                 HR81.8  HR81.9
                                                                 HR82.1  HR82.2
                                                                 HR82.3  HR82.4
                                                                 HR82.5  HR82.6
                                                                 HR82.7  HR82.8
                                                                 ...

CRSSET4   SHORT-CRS-DESCKeyChange, Subset
          COURSE        Where (SHORT-CRS-DESC != Spaces )
          EFFECTIVE-DATE*

                         PACOURSE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Course Cat     PCODES       Not Required

                            "CC"               -> PCO-TYPE  (PCOSET1)
                            CRS-COURSE-CAT     -> PCO-CODE

Course Type    PCODES       Not Required

                            "CT"               -> PCO-TYPE
                            CRS-COURSE-TYPE    -> PCO-CODE

Prereq Options PAPREPROPT   Not Required

                            CRS-COURSE         -> PQO-COURSE

                         PACOURSE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Attributes     PAATTRIB

                            CRS-COURSE         -> TRB-COURSE
                                                  TRB-TYPE
                                                  TRB-CODE

Cost           PACOST

                            CRS-COURSE         -> CST-COURSE
                                                  CST-COST-TYPE
                                                  CST-COST-CAT
                                                  CST-EFFECTIVE-DATE

Instructor     PAINSCOURS

                            CRS-COURSE         -> INC-COURSE
                                                  INC-INSTRUCT

Prereq Cs      PAPREREQ

                            CRS-COURSE         -> RQS-COURSE
                            "CS"               -> RQS-PREREQ-TYPE
                                                  RQS-PREREQUISITE
                                                  RQS-COMPANY

Prereq Eg      PAPREREQ

                            CRS-COURSE         -> RQS-COURSE
                            "EG"               -> RQS-PREREQ-TYPE
                                                  RQS-PREREQUISITE
                                                  RQS-COMPANY

Prereq Sk      PAPREREQ

                            CRS-COURSE         -> RQS-COURSE
                            "SK"               -> RQS-PREREQ-TYPE
                                                  RQS-PREREQUISITE
                                                  RQS-COMPANY

Prereq Sv      PAPREREQ

                            CRS-COURSE         -> RQS-COURSE
                            "SV"               -> RQS-PREREQ-TYPE
                                                  RQS-PREREQUISITE
                                                  RQS-COMPANY

Prereqs        PAPREREQ

                            CRS-COURSE         -> RQS-COURSE
                                                  RQS-PREREQ-TYPE
                                                  RQS-PREREQUISITE
                                                  RQS-COMPANY

Register       PAREGISTER   Delete Restricted

                            CRS-COURSE         -> REG-COURSE
                                                  REG-SESSION
                                                  REG-START-DATE
                                                  REG-COMPANY
                                                  REG-EMPLOYEE

Ses Cost       PASCOST

                            CRS-COURSE         -> COS-COURSE
                                                  COS-SESSION
                                                  COS-START-DATE
                                                  COS-COST-TYPE
                                                  COS-COST-CAT

Session        PASESSION    Delete Restricted

                            CRS-COURSE         -> SES-COURSE
                                                  SES-SESSION
                                                  SES-START-DATE

Track          PATRACKDTL

                            CRS-COURSE         -> TKD-COURSE
                                                  TKD-TRACK

Training       PATRNHIST

                            CRS-COURSE         -> TRH-COURSE
                                                  TRH-COMPANY
                                                  TRH-EMPLOYEE
                                                  TRH-DATE-COMPLETED