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.

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

IndexKeysFlagsConditionUsed in
DPTSET1COMPANY, PROCESS-LEVEL, DEPARTMENTPrimaryBN100, BN101, BN102, BN103, BN105, BN145, BN150, BN230 +22 more (list truncated in source)
DPTSET2COMPANY, DEPARTMENT, PROCESS-LEVELBN231, BN232, BN238, BN246, BN305, HR11.1, HR11.2, HR11.4 +22 more (list truncated in source)

Relations

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredDPT-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
DeptsegblkDEPTSEGBLKNot RequiredDPT-COMPANY → DSG-COMPANY, DPT-PROCESS-LEVEL → DSG-PROCESS-LEVEL, DPT-DEPARTMENT → DSG-DEPARTMENT
Expense AcctGLMASTERRequiredDPT-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 LevelPRSYSTEMRequiredDPT-COMPANY → PRS-COMPANY, DPT-PROCESS-LEVEL → PRS-PROCESS-LEVEL

One to many (5) — child tables

RelationTableRulesConditionField map
Assn ResourcePAASSIGNEDDelete CascadesDPT-COMPANY → PAA-COMPANY, DPT-PROCESS-LEVEL → PAA-PROCESS-LEVEL, DPT-DEPARTMENT → PAA-DEPARTMENT, → PAA-JOB-CODE, → PAA-POSITION
BudgetPABUDGETDelete CascadesDPT-COMPANY → PAB-COMPANY, DPT-PROCESS-LEVEL → PAB-PROCESS-LEVEL, DPT-DEPARTMENT → PAB-DEPARTMENT, → PAB-JOB-CODE, → PAB-EFFECT-DATE, → PAB-POSITION
EmployeeEMPLOYEEDelete RestrictedDPT-COMPANY → EMP-COMPANY, DPT-PROCESS-LEVEL → EMP-PROCESS-LEVEL, DPT-DEPARTMENT → EMP-DEPARTMENT, → EMP-EMPLOYEE
PaencumberPAENCUMBERDelete RestrictedDPT-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 CascadesDPT-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)