PACOMPPROF – No description in the Lawson data dictionary

System
Personnel (PA)
Prefix
PCM
Primary key
COMPANY, PROCESS-LEVEL, TYPE, CODE, PROFIC-LEVEL
Fields
12
Updated by
98 programs
Referenced by
18 programs

PACOMPPROF is a Lawson Personnel table (prefix PCM); no description in the lawson data dictionary. It is indexed by COMPANY, PROCESS-LEVEL, TYPE, CODE, PROFIC-LEVEL (PCMSET1); alternate indexes: PCMSET2, PCMSET3 and PCMSET4. It is related 1:1 to PRSYSTEM and PCODES. It is updated by HR00.1, HR01.1, HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2 and 90 more and referenced by HS50.3, HS50.4, PA08.1, PA20.1, PA207, PA21.1, PA22.1, PA24.1 and 10 more. The table has 12 fields, 4 indexes and 4 documented relations.

About PACOMPPROF

No description in the Lawson data dictionary.

Fields (12)

Column = COBOL field name without the PCM- 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 / columnTypeDescription & valuesUpdated by
#PCM-COMPANY PK
COMPANY		Numeric 4—PA07.1
#PCM-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5—PA07.1
#PCM-CODE PK
CODE		Alpha 10Code that is valid for the specified record type.PA07.1
#PCM-TYPE PK
TYPE		Alpha 2This identifies whether this record is created because of a picking transaction, or because of a return. Valid values are: "IS" = Picking transaction. "RR" = Return. ~$1 VENDOR The vendor's identification code.
  • DF Default
  • AB Abilities
  • KN Knowledge
  • OA Other Attributes
  • SK Skills
PA07.1
#PCM-PROFIC-LEVEL PK
PROFIC_LEVEL		Alpha 10—PA07.1
#PCM-SEQ SET3 SET4
SEQ		Numeric 3This field contains the record sequence number.HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +52 more (list truncated in source)
#PCM-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1The Active flag of the credit card type.
  • A Active
  • I Inactive
PA07.1
#PCM-DESCRIPTION
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.PA07.1
#PCM-COMMENTS
COMMENTS		Alpha 50 (Lower Case)This field contains the text you enter for the comment to be associated with an asset. You can have multiple lines of comments for each comment type.PA07.1
#PCM-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.PA07.1
#PCM-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.PA07.1
#PCM-USER-ID
USER_ID		Alpha 10 (Lower Case)—PA07.1

Indexes (4)

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.

IndexKeysFlagsConditionUsed in
PCMSET1
  1. COMPANY
  2. PROCESS-LEVEL
  3. TYPE
  4. CODE
  5. PROFIC-LEVEL
PrimaryHR00.1, HR01.1, HS50.3, HS50.4, PA07.1, PA08.1, PA20.1, PA207 +13 more
PCMSET2
  1. PROFIC-LEVEL
  2. COMPANY
  3. PROCESS-LEVEL
  4. TYPE
  5. CODE
HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +22 more (list truncated in source)
PCMSET3
  1. CODE
  2. TYPE
  3. COMPANY
  4. PROCESS-LEVEL
  5. SEQ
  6. PROFIC-LEVEL
KeyChangeHR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +22 more (list truncated in source)
PCMSET4
  1. COMPANY
  2. PROCESS-LEVEL
  3. TYPE
  4. CODE
  5. SEQ
  6. PROFIC-LEVEL
KeyChangeHR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMPCODESPACOMPPROF

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
PCM-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Hr CodesPCODESRequiredWhen (PCM-TYPE != "DF")
PCM-TYPE→PCO-TYPE
PCM-CODE→PCO-CODE
Process LevelPRSYSTEMRequiredWhen (PCM-PROCESS-LEVEL != Spaces)
PCM-COMPANY→PRS-COMPANY
PCM-PROCESS-LEVEL→PRS-PROCESS-LEVEL
ProficiencyPCODESRequired
"PF"→PCO-TYPE
PCM-PROFIC-LEVEL→PCO-CODE

Programs

Updated by (98)

Referenced by (18)