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.

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
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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PCMSET1COMPANY, PROCESS-LEVEL, TYPE, CODE, PROFIC-LEVELPrimaryHR00.1, HR01.1, HS50.3, HS50.4, PA07.1, PA08.1, PA20.1, PA207 +13 more
PCMSET2PROFIC-LEVEL, COMPANY, PROCESS-LEVEL, TYPE, CODEHR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +22 more (list truncated in source)
PCMSET3CODE, TYPE, COMPANY, PROCESS-LEVEL, SEQ, PROFIC-LEVELKeyChangeHR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +22 more (list truncated in source)
PCMSET4COMPANY, PROCESS-LEVEL, TYPE, CODE, SEQ, PROFIC-LEVELKeyChangeHR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +22 more (list truncated in source)

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredPCM-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)