DEPTCODE FILE
Department
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.
REFERENCED BY
BN100 BN101 BN102 BN103 BN105 BN145
BN150 BN231 BN232 BN238 BN240 BN245
BN246 BN335 HCCP.1 HCOP.1 HCOP.2 HDPT.1
HR11.1 HR12.1 HR14.1 HR15.1 HR155 HR170
HR202 HR211 HR213 HR511 HR514 HR54.1
HR55.2 HR70.1 HR700 HRS1.1 HRSC.1 HS11.1
PA02.1 PA06.1 PA09.1 PA100 PA102 PA11.1
PA13.1 PA13.2 PA149 PA16.1 PA170 PA171
PA172 PA20.1 PA202 PA206 PA208 PA21.1
PA211 PA212 PA213 PA214 PA215 PA216
PA217 PA218 PA219 PA22.1 PA220 PA221
PA222 PA224 PA225 PA24.1 PA242 PA248
PA249 PA259 PA271 PA272 PA290 PA300
PA302 PA305 PA310 PA311 PA315 PA320
PA325 PA330 PA335 PA34.1 PA340 PA345
PA35.1 PA350 PA355 PA36.1 PA360 PA370
PA371 PA372 PA38.1 PA391 PA402 PA42.1
PA490 PA502 PA513 PA52.1 PA52.2 PA52.3
PA52.4 PA52.5 PA520 PA53.1 PA532 PA54.1
PA59.1 PA590 PA66.2 PA66.3 PA71.1 PA73.1
PA80.1 PA80.2 PA90.1 PA93.4 TR21.1 TR22.1
TR500 HS20.1 HS21.1 PR03.1 PR120 PR128
PR13.1 PR131 PR132 PR134 PR136 PR137
PR139 PR140 PR141 PR142 PR150 PR195
PR199 PR212 PR214 PR226 PR23.1 PR23.3
PR260 PR270 PR275 PR276 PR277 PR295
PR30.1 PR32.1 PR32.2 PR33.1 PR33.2 PR33.3
PR35.1 PR35.2 PR35.3 PR35.4 PR35.5 PR35.6
PR35.8 PR36.1 PR37.1 PR38.1 PR39.2 PR45.1
PR530 PR560 PR80.1 PR82.1 PR82.2 PR85.1
UK102 UK330 TA170 TA175 TA260 TA265
TA290 TM240 TM245 TM250 TM255 TM470
TM52.1 TM570 TM70.1 TM71.1 UK120 UK60.1
UK70.1 PA341 HS01.1 HS34.1
UPDATED BY
HR02.1 HR00.1 HR01.1 PBIP.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DPT-COMPANY Numeric 4 HR02.1
Company Contains the number that represents an
established company and is entered on
all functions.
DPT-PROCESS-LEVEL Alpha 5 HR02.1
Process Level Contains the process level to which
this department belongs.
DPT-DEPARTMENT Alpha 5 HR02.1
Department Contains the department.
DPT-NAME Alpha 30 (Lower Case) BN245 HR02.1
Name Contains the name or description of the PA242 PA71.1
department. PA73.1 PA80.1
PA80.2 PR131
PR142
DPT-DEP-DIST-CO Numeric 4 HR02.1 HR11.1
Dep Dist Co Contains the department's payroll HR511 PA02.1
distribution company. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
DPT-DEP-ACCT-UNIT Alpha 15 HR02.1 HR11.1
Department Account Contains the department's payroll HR511 PA02.1
Unit expense accounting unit. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
DPT-DEP-ACCOUNT Numeric 6 HR02.1 HR11.1
Department Account Contains the department's payroll HR511 PA02.1
expense account number. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
DPT-DEP-SUB-ACCT Numeric 4 HR02.1 HR11.1
Department Contains the department's payroll HR511 PA02.1
Subaccount expense subaccount number. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
DPT-SEC-LVL Numeric 1 HR02.1 HR11.1
Sec Lvl Contains the default security level for HR511 PA02.1
the department. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
DPT-SEC-LOCATION Alpha 10 HR02.1 HR11.1
Sec Location Contains the default security location HR511 PA02.1
for the department. PA100 PA102
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR13.1
DPT-SEGMENT-FLAG Alpha 1 HR02.1
Segment Flag Identifies the user analysis
values included on payroll expense
ransactions.
DEPTCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DPTSET1 COMPANY BN100 BN101
PROCESS-LEVEL BN102 BN103
DEPARTMENT BN105 BN145
BN150 BN231
BN232 BN238
BN240 BN245
BN246 BN335
HCCP.1 HCOP.1
HCOP.2 HDPT.1
HR00.1 HR01.1
HR02.1 HR11.1
HR12.1 HR14.1
HR15.1 HR155
HR170 HR202
HR211 HR213
...
DPTSET2 COMPANY BN231 BN232
DEPARTMENT BN238 BN246
PROCESS-LEVEL HR11.1 HR211
HR213 HR511
PA02.1 PA100
PA102 PA13.1
PA13.2 PA171
PA172 PA202
PA211 PA212
PA214 PA215
PA216 PA217
PA218 PA219
PA220 PA221
PA222 PA224
PA225 PA259
...
DEPTCODE FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Company PRSYSTEM Required
DPT-COMPANY -> PRS-COMPANY
Spaces -> PRS-PROCESS-LEVEL
Deptsegblk DEPTSEGBLK Not Required
DPT-COMPANY -> DSG-COMPANY
DPT-PROCESS-LEVEL -> DSG-PROCESS-LEVEL
DPT-DEPARTMENT -> DSG-DEPARTMENT
Expense Acct GLMASTER Required
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 Level PRSYSTEM Required
DPT-COMPANY -> PRS-COMPANY
DPT-PROCESS-LEVEL -> PRS-PROCESS-LEVEL
DEPTCODE FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Assn Resource PAASSIGNED Delete Cascades
DPT-COMPANY -> PAA-COMPANY
DPT-PROCESS-LEVEL -> PAA-PROCESS-LEVEL
DPT-DEPARTMENT -> PAA-DEPARTMENT
PAA-JOB-CODE
PAA-POSITION
Budget PABUDGET Delete Cascades
DPT-COMPANY -> PAB-COMPANY
DPT-PROCESS-LEVEL -> PAB-PROCESS-LEVEL
DPT-DEPARTMENT -> PAB-DEPARTMENT
PAB-JOB-CODE
PAB-EFFECT-DATE
PAB-POSITION
Employee EMPLOYEE Delete Restricted
DPT-COMPANY -> EMP-COMPANY
DPT-PROCESS-LEVEL -> EMP-PROCESS-LEVEL
DPT-DEPARTMENT -> EMP-DEPARTMENT
EMP-EMPLOYEE
Position PAPOSITION Delete Cascades
DPT-COMPANY -> POS-COMPANY
DPT-PROCESS-LEVEL -> POS-PROCESS-LEVEL
DPT-DEPARTMENT -> POS-DEPARTMENT
POS-POSITION
POS-EFFECT-DATE
|