PAINSCOURS – Course Instructors
- System
- Personnel (PA)
- Prefix
INC- Primary key
COURSE,INSTRUCT- Fields
- 4
- Updated by
- 4 programs
- Referenced by
- 3 programs
PAINSCOURS is the Course Instructors table in Lawson Personnel (prefix INC). It is indexed by COURSE, INSTRUCT (INCSET1); alternate indexes: INCSET3. It is related 1:1 to PAINSTRUCT and 1:M to PACOURSE and PAINSTSES. It is updated by TR01.1, TR07.1, TR08.1 and TR14.1 and referenced by TR09.1, TR201 and TR207. The table has 4 fields, 2 indexes and 3 documented relations.
About PAINSCOURS
Contains the names of the instructors who can teach each course. TR08.1 (Instructor Courses) is the primary program that updates this file.
Fields (4)
Column = COBOL field name without the INC- 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 / column | Type | Description & values | Updated by |
|---|---|---|---|
#INC-INSTRUCT PKINSTRUCT | Numeric 10 | Contains the instructor's identification number. | TR08.1, TR14.1 |
#INC-COURSE PKCOURSE | Alpha 10 | Contains the course code. | TR08.1, TR14.1 |
#INC-EFFECTIVE-DATEEFFECTIVE_DATE | Numeric 8 (yyyymmdd) | Contains the first date the instructor can teach the course. | TR08.1, TR14.1 |
#INC-END-DATEEND_DATE | Numeric 8 (yyyymmdd) | Contains the last date the instructor can teach the course. | TR08.1, TR14.1 |
Indexes (2)
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.
| Index | Keys | Flags | Condition | Used in |
|---|---|---|---|---|
INCSET1 |
| Primary | TR01.1, TR08.1, TR09.1, TR14.1, TR201 | |
INCSET3 |
| TR07.1, TR09.1, TR14.1, TR207 |
Relations
One to one (1) — lookups and parents
| Relation | Table | Rules | Condition | Field map | |||
|---|---|---|---|---|---|---|---|
| Instructor | PAINSTRUCT | Required |
|