DEPTCODE – Department

System
Human Resources (HR)
Prefix
DPT
Primary key
COMPANY, PROCESS-LEVEL, DEPARTMENT
Fields
15
Updated by
3 programs
Referenced by
310 programs

DEPTCODE is the Department table in Lawson Human Resources (prefix DPT). It is indexed by COMPANY, PROCESS-LEVEL, DEPARTMENT (DPTSET1); alternate indexes: DPTSET2. It is related 1:1 to PRSYSTEM, DEPTSEGBLK and GLMASTER and 1:M to PAASSIGNED, PABUDGET, EMPLOYEE, PAENCUMBER and PAPOSITION. It is updated by HR00.1, HR01.1 and HR02.1 and referenced by BN100, BN101, BN102, BN103, BN105, BN145, BN150, BN230 and 302 more. The table has 15 fields, 2 indexes and 9 documented relations.

About DEPTCODE

Contains information about user-defined department codes. Departments are the lowest level for expensing and reporting in the Lawson Payroll system. HR02.1 (Department) is the primary program that updates this file. Departments are optional.

Fields (15)

Column = COBOL field name without the DPT- 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
#DPT-COMPANY PK
COMPANY		Numeric 4Contains the number that represents an established company and is entered on all functions.HR02.1
#DPT-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5Contains the process level to which this department belongs.HR02.1
#DPT-DEPARTMENT PK
DEPARTMENT		Alpha 5Contains the department.HR02.1
#DPT-NAME
NAME		Alpha 30 (Lower Case)Contains the name or description of the department.BN245, HR02.1, LP32.3, PA218, PA242, PA71.1, PA80.1, PA80.2 +3 more
#DPT-DEP-DIST-CO
DEP_DIST_CO		Numeric 4Contains the department's payroll distribution company.HR02.1, PA52.5
#DPT-DEP-ACCT-UNIT
DEP_ACCT_UNIT		Alpha 15Contains the department's payroll expense accounting unit.HR02.1, PA52.5
#DPT-DEP-ACCOUNT
DEP_ACCOUNT		Numeric 6Contains the department's payroll expense account number.HR02.1, PA52.5
#DPT-DEP-SUB-ACCT
DEP_SUB_ACCT		Numeric 4Contains the department's payroll expense subaccount number.HR02.1, PA52.5
#DPT-SEC-LVL
SEC_LVL		Numeric 1Contains the default security level for the department.HR02.1
#DPT-SEC-LOCATION
SEC_LOCATION		Alpha 10Contains the default security location for the department.HR02.1
#DPT-SEGMENT-FLAG
SEGMENT_FLAG		Alpha 1Identifies the user analysis values included on payroll expense transactions.HR02.1
#DPT-ACTIVE-FLAG
ACTIVE_FLAG		Alpha 1The Active flag of the credit card type.
  • A Active
  • I Inactive
HR02.1
#DPT-USER-ID
USER_ID		Alpha 10 (Lower Case)—HR02.1
#DPT-DATE-STAMP
DATE_STAMP		Numeric 8 (yyyymmdd)This field contains the server date (month, date, and year) of the last change to this record.HR02.1
#DPT-TIME-STAMP
TIME_STAMP		Numeric 6 (hhmmss)Contains the server time (hour, minute, and second) when the record was last changed.HR02.1

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
DPTSET1
  1. COMPANY
  2. PROCESS-LEVEL
  3. DEPARTMENT
PrimaryBN100, BN101, BN102, BN103, BN105, BN145, BN150, BN230 +22 more (list truncated in source)
DPTSET2
  1. COMPANY
  2. DEPARTMENT
  3. PROCESS-LEVEL
BN231, BN232, BN238, BN246, BN305, HR11.1, HR11.2, HR11.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)
PRSYSTEMDEPTSEGBLKGLMASTERPAASSIGNEDPABUDGETEMPLOYEEPAENCUMBERPAPOSITIONDEPTCODE

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
DPT-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
DeptsegblkDEPTSEGBLKNot Required
DPT-COMPANY→DSG-COMPANY
DPT-PROCESS-LEVEL→DSG-PROCESS-LEVEL
DPT-DEPARTMENT→DSG-DEPARTMENT
Expense AcctGLMASTERRequired
DPT-DEP-DIST-CO→GLM-COMPANY
DPT-DEP-ACCT-UNIT→GLM-ACCT-UNIT
DPT-DEP-ACCOUNT→GLM-ACCOUNT
DPT-DEP-SUB-ACCT→GLM-SUB-ACCOUNT
Process LevelPRSYSTEMRequired
DPT-COMPANY→PRS-COMPANY
DPT-PROCESS-LEVEL→PRS-PROCESS-LEVEL

One to many (5) — child tables

RelationTableRulesConditionField map
Assn ResourcePAASSIGNEDDelete Cascades
DPT-COMPANY→PAA-COMPANY
DPT-PROCESS-LEVEL→PAA-PROCESS-LEVEL
DPT-DEPARTMENT→PAA-DEPARTMENT
—→PAA-JOB-CODE
—→PAA-POSITION
BudgetPABUDGETDelete Cascades
DPT-COMPANY→PAB-COMPANY
DPT-PROCESS-LEVEL→PAB-PROCESS-LEVEL
DPT-DEPARTMENT→PAB-DEPARTMENT
—→PAB-JOB-CODE
—→PAB-EFFECT-DATE
—→PAB-POSITION
EmployeeEMPLOYEEDelete Restricted
DPT-COMPANY→EMP-COMPANY
DPT-PROCESS-LEVEL→EMP-PROCESS-LEVEL
DPT-DEPARTMENT→EMP-DEPARTMENT
—→EMP-EMPLOYEE
PaencumberPAENCUMBERDelete Restricted
DPT-COMPANY→PEN-COMPANY
Spaces→PEN-POSITION
DPT-PROCESS-LEVEL→PEN-PROCESS-LEVEL
DPT-DEPARTMENT→PEN-DEPARTMENT
—→PEN-JOB-CODE
—→PEN-EMPLOYEE
—→PEN-GLT-OBJ-ID
—→PEN-ATN-OBJ-ID
PositionPAPOSITIONDelete Cascades
DPT-COMPANY→POS-COMPANY
DPT-PROCESS-LEVEL→POS-PROCESS-LEVEL
DPT-DEPARTMENT→POS-DEPARTMENT
—→POS-POSITION
—→POS-EFFECT-DATE

Programs

Updated by (3)

Referenced by (310)