PAMODOPT – Training Options

System
Personnel (PA)
Prefix
MOD
Primary key
KEY
Fields
12
Updated by
1 program
Referenced by
16 programs

PAMODOPT is the Training Options table in Lawson Personnel (prefix MOD). It is indexed by KEY (MODSET1). It is related 1:1 to CUCODES, CUTABLE and PCODES. It is updated by TR00.1 and referenced by CU00.1, TR01.1, TR03.1, TR10.1, TR10.2, TR11.1, TR11.2, TR12.1 and 8 more. The table has 12 fields, 1 index and 3 documented relations.

About PAMODOPT

Contains system setup information. It includes flags that indicate whether the wait list will be used; whether the wait list will be automatic or manual; the order in which registrants will be taken from the wait list; whether employees can be on more than one wait list for the same course; or whether employee can register for more than one session of the same course. It also indicates what skill source, if any, defaults on TR22.1 (Session Completion). Before TR01.1 (Course) can be used, the flag that indicates whether the wait list will be used must be set to create a record. TR00.1 is the primary program that updates this file.

Fields (12)

Column = COBOL field name without the MOD- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / columnTypeDescription & valuesUpdated by
MOD-KEY PK
KEY		Alpha 1Contains a placeholder.TR00.1
MOD-APPROVAL-FLAG
APPROVAL_FLAG		Alpha 1Indicates whether the course approval option is in use.
  • Y Yes
  • N No
TR00.1
MOD-WAITLIST-FLAG
WAITLIST_FLAG		Alpha 1Indicates whether the wait list option is in use.
  • Y Yes
  • N No
TR00.1
MOD-WAITLIST-DISP
WAITLIST_DISP		Alpha 1If the wait list is used, this field indicates whether wait lists are automatic. If wait lists are automatic, the system places employees on a wait list when a session is filled. The system registers employees into a session if openings occur. If wait lists are not automatic, the registrar places employees on a wait list. The registrar also registers employees into sessions if openings occur.
  • Y Automatic Wait List
  • N No Automatic Wait List
TR00.1
MOD-AUTO-WAITL-SEQ
AUTO_WAITL_SEQ		Alpha 1If the wait list is automatic, this field indicates the method by which the system chooses which employee to confirm into a session from the wait list.
  • T Filled by Date/Time Order
  • R Filled by Req Trng & Then Date
TR00.1
MOD-MULT-WAIT-ALLW
MULT_WAIT_ALLW		Alpha 1Indicates whether employees can be placed on wait lists for more than one session of the same course.
  • Y Yes
  • N No
TR00.1
MOD-MULT-REG-ALLW
MULT_REG_ALLW		Alpha 1Indicates whether employees can confirmed for more than one session of the same course.
  • Y Yes
  • N No
TR00.1
MOD-SKILL-SOURCE
SKILL_SOURCE		Alpha 10Contains the skill source, if any, that defaults on TR03.1 (Course Attributes). If the field is empty, no skill source defaults.TR00.1
MOD-CURRENCY-CODE
CURRENCY_CODE		Alpha 5Contains the base currency for the training system.TR00.1
MOD-CURR-ND
CURR_ND		Numeric 1The number of decimals assigned to a particular account as determined by the account currency.TR00.1
MOD-CURRENCY-FLAG
CURRENCY_FLAG		Alpha 1Indicates whether the training system allows multiple currencies.TR00.1
MOD-CURRENCY-TABLE
CURRENCY_TABLE		Alpha 12Contains the currency table used for the training system.TR00.1

Indexes (1)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
MODSET1KEYPrimaryCU00.1, TR00.1, TR01.1, TR03.1, TR10.1, TR10.2, TR11.1, TR11.2 +9 more

Relations

One to one (3) — lookups and parents

RelationTableRulesConditionField map
CurrencyCUCODESRequiredWhen MOD-CURRENCY-CODE != SpacesMOD-CURRENCY-CODE → CUC-CURRENCY-CODE
Currency TableCUTABLERequiredWhen MOD-CURRENCY-TABLE != SpacesMOD-CURRENCY-TABLE → CTB-CURRENCY-TABLE
Skill SourcePCODESRequiredWhen MOD-SKILL-SOURCE != Spaces"SS" → PCO-TYPE, MOD-SKILL-SOURCE → PCO-CODE

Programs

Updated by (1)

Referenced by (16)