PAPROFILE – No description in the Lawson data dictionary

System: Personnel (PA)
Prefix: PPF
Primary key: COMPANY, WEB-TYPE, SEQ
Fields: 4
Updated by: 2 programs
Referenced by: 0 programs

PAPROFILE is a Lawson Personnel table (prefix PPF); no description in the lawson data dictionary. It is indexed by COMPANY, WEB-TYPE, SEQ (PPFSET1). It is related 1:1 to PRSYSTEM and 1:M to PAPROMAP. It is updated by HR00.1 and HR01.1. The table has 4 fields, 1 index and 2 documented relations.

About PAPROFILE

No description in the Lawson data dictionary.

Fields (4)

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

Field / column	Type	Description & values	Updated by
`PPF-COMPANY` PK COMPANY	Numeric 4	—	—
`PPF-WEB-TYPE` PK WEB_TYPE	Alpha 3	Indicates the type of profile. `1` Physician `2` Nurse	—
`PPF-SEQ` PK SEQ	Numeric 3	Indicates the section of the profile. `E.g. 1` Education; 2 = Licenses	—
`PPF-DESCRIPTION` DESCRIPTION	Alpha 30 (Lower Case)	This field displays the description.	—

Indexes (1)

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

Index	Keys	Flags	Condition	Used in
`PPFSET1`	`COMPANY`, `WEB-TYPE`, `SEQ`	Primary		HR00.1, HR01.1

Relations

One to one (1) — lookups and parents

Relation	Table	Rules	Condition	Field map
Company	PRSYSTEM	Required		`PPF-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`

One to many (1) — child tables

Relation	Table	Rules	Condition	Field map
Profile Map	PAPROMAP			`PPF-COMPANY` → `PPM-COMPANY`, `PPF-WEB-TYPE` → `PPM-WEB-TYPE`, `PPF-SEQ` → `PPM-SEQ`, → `PPM-TYPE`, → `PPM-CODE`, → `PPM-SEQ-NBR`

Programs

Updated by (2)

HR00.1 Company
HR01.1 Process Level