PCODESTYPE – No description in the Lawson data dictionary

System
Human Resources (HR)
Prefix
PCS
Primary key
TYPE
Fields
6
Updated by
1 program
Referenced by
3 programs

PCODESTYPE is a Lawson Human Resources table (prefix PCS); no description in the lawson data dictionary. It is indexed by TYPE (PCSSET1); alternate indexes: PCSSET2. It is related 1:M to PCODES and PCODESDTL. It is updated by HR100 and referenced by HR04.2, HR204 and PA532. The table has 6 fields, 2 indexes and 2 documented relations.

About PCODESTYPE

No description in the Lawson data dictionary.

Fields (6)

Column = COBOL field name without the PCS- 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
#PCS-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.—
#PCS-DESCRIPTION SET2
DESCRIPTION		Alpha 30 (Lower Case)This field displays the description.—
#PCS-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1The Active flag of the credit card type.
  • A Active
  • I Inactive
—
#PCS-SETUP-FLAG
SETUP_FLAG		Alpha 1—
  • N No
  • Y Yes
—
#PCS-DEFN-PROGRAM
DEFN_PROGRAM		Alpha 5The Data Mart Setup Program field contains the name of the program that provides the dimensions, members, and data selection parameters required by the data mart.—
#PCS-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.—

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.

IndexKeysFlagsConditionUsed in
PCSSET1
  1. TYPE
PrimaryHR04.2, HR100, HR204, PA532
PCSSET2
  1. DESCRIPTION
  2. TYPE
KeyChange, SubsetWhere (ACTIVE-FLAG = "A") And (SETUP-FLAG = "Y")HR04.2

Relations

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

One to many (2) — child tables

RelationTableRulesConditionField map
PcodesPCODESDelete Cascades
PCS-TYPE→PCO-TYPE
—→PCO-CODE
PcodesdtlPCODESDTLDelete Cascades
PCS-TYPE→PDD-TYPE
—→PDD-CODE

Programs

Updated by (1)

Referenced by (3)