DEPTCODE

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 BN230 BN234 BN240 BN242 BN245
BN320 BN335 BN556 HAP3.1 HCRE.1 HEP4.1
HPOS.1 HPQC.1 HPRS.1 HR12.1 HR15.1 HR155
HR156 HR170 HR217 HR220 HR255 HR51.2
HR51.3 HR51.6 HR515 HR52.2 HR52.6 HR54.1
HR55.2 HR70.1 HRS1.1 HRSC.1 HS208 HS705
LT11.5 PR521 ZH156 ZH503 ZH561 ZH568
EXI2.1 EXI4.1 LP100 LP101 LP130 LP140
LP145 LP180 LP188 LP197 LP198 LP231
LP240 LP251 LP260 LP262 LP264 LP53.1
LP553 LP554 LP80.1 HS11.1 HS11.2 PA06.1
PA09.1 PA103 PA113 PA149 PA16.1 PA20.1
PA208 PA21.1 PA213 PA22.1 PA24.1 PA242
PA248 PA249 PA27.1 PA302 PA31.3 PA34.1
PA340 PA35.1 PA36.1 PA372 PA38.1 PA391
PA42.1 PA42.3 PA490 PA495 PA520 PA53.1
PA535 PA54.1 PA570 PA59.1 PA590 PA71.1
PA73.1 PA90.1 PA93.4 TR207 TR21.1 TR22.1
TR222 TR26.1 TR500 ZE521 ZE531 ZE540
PR03.1 PR128 PR129 PR130 PR131 PR132
PR134 PR135 PR136 PR139 PR140 PR141
PR142 PR160 PR180 PR189 PR195 PR197
PR212 PR214 PR226 PR229 PR23.1 PR23.3
PR247 PR260 PR274 PR277 PR29.1 PR295
PR32.1 PR32.2 PR33.1 PR33.2 PR33.3 PR35.1
PR35.2 PR35.3 PR35.4 PR35.5 PR35.6 PR35.8
PR35.9 PR36.1 PR37.1 PR38.1 PR39.2 PR45.1
PR529 PR530 PR560 PR582 PR80.1 PR80.2
PR80.4 PR82.1 PR82.2 UK102 UK13.1 UK141
UK201 UK277 UK560 ZP530 ZP574 ZP576
ZP577 TA147 TA170 TA175 TA260 TA265
TA290 TM240 TM245 TM250 TM255 TM260
TM265 TM470 TM570 TM70.1 TM71.1 WA01.1
HRLRD HDPT.1 HR202 LP32.1 LP32.2 LP32.3
PA11.1 PA170 PA171 PA206 PA292 PA294
PA80.1 PA80.2 PA82.1 PA92.2 PA94.1 HS20.1
HS21.1 PR04.1 PR204 PR223 SNEM.1 HS34.1


UPDATED BY
BN231 BN232 BN238 BN246 BN305 HCCP.1
HCDL.1 HR00.1 HR01.1 HR02.1 HR11.1 HR11.2
HR14.1 HR211 HR213 HR228 HR28.1 HR511
HR514 HS703 LT101 ZH500 ZH510 PA02.1
PA100 PA102 PA115 PA13.1 PA13.2 PA172
PA202 PA210 PA211 PA212 PA214 PA215
PA216 PA217 PA218 PA219 PA220 PA221
PA222 PA223 PA224 PA225 PA227 PA259
PA271 PA272 PA290 PA310 PA311 PA315
PA320 PA325 PA330 PA335 PA341 PA345
PA350 PA355 PA360 PA370 PA371 PA402
PA502 PA513 PA52.1 PA52.3 PA52.4 PA52.5
PA532 PA66.2 ZE532 HS01.1 HS36.1 PR110
PR113 PR12.6 PR120 PR13.1 PR13.5 PR13.6
PR13.8 PR13.9 PR137 PR270 PR275 PR276
PR279 PR30.2 UK183 UK184 TM52.1 WACP.1
WAOP.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DPT-COMPANY
Element: Company Hr		Numeric 4
Contains the number that represents an established company and is entered on all functions.
HR02.1
DPT-PROCESS-LEVEL
Element: Process Lev Hr		Alpha 5
Contains the process level to which this department belongs.
HR02.1
DPT-DEPARTMENT
Element: Department		Alpha 5
Contains the department.
HR02.1
DPT-NAME
Element: 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
PR131 PR142
ZH500
DPT-DEP-DIST-CO
Element: Company		Numeric 4
Contains the department's payroll distribution company.
HR02.1 PA52.5
DPT-DEP-ACCT-UNIT
Element: Acct Unit		Alpha 15
Contains the department's payroll expense accounting unit.
HR02.1 PA52.5
DPT-DEP-ACCOUNT
Element: Account		Numeric 6
Contains the department's payroll expense account number.
HR02.1 PA52.5
DPT-DEP-SUB-ACCT
Element: Sub Acct		Numeric 4
Contains the department's payroll expense subaccount number.
HR02.1 PA52.5
DPT-SEC-LVL
Element: Sec Lvl		Numeric 1
Contains the default security level for the department.
HR02.1
DPT-SEC-LOCATION
Element: Sec Location		Alpha 10
Contains the default security location for the department.
HR02.1
DPT-SEGMENT-FLAG
Element: Segment Flag		Alpha 1
Identifies the user analysis values included on payroll expense transactions.
HR02.1
DPT-ACTIVE-FLAG
Element: Active Flag		Alpha 1
The Active flag of the credit card type.
A = Active
I = Inactive
HR02.1
DPT-USER-ID
Element: User		Alpha 10 (Lower Case)
HR02.1
DPT-DATE-STAMP
Element: 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
Element: Time Stamp		Numeric 6 (hhmmss)
Contains the server time (hour, minute, and second) when the record was last changed.
HR02.1


DEPTCODE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DPTSET1 COMPANY
PROCESS-LEVEL
DEPARTMENT
...
BN100 BN101
BN102 BN103
BN105 BN145
BN150 BN230
BN231 BN232
BN234 BN238
BN240 BN242
BN245 BN246
BN305 BN320
BN335 BN556
HCCP.1 HCDL.1
HAP3.1 HCRE.1
HDPT.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR00.1
DPTSET2 COMPANY
DEPARTMENT
PROCESS-LEVEL
...
BN231 BN232
BN238 BN246
BN305 HR11.1
HR11.2 HR211
HR213 HR228
HR28.1 HR511
HS703 LT101
ZH510 LP251
LP32.3 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA171
PA172 PA202
PA210 PA211
PA212 PA214


DEPTCODE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED 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
Paencumber PAENCUMBER Delete 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
Position PAPOSITION Delete Cascades
DPT-COMPANY->POS-COMPANY
DPT-PROCESS-LEVEL->POS-PROCESS-LEVEL
DPT-DEPARTMENT->POS-DEPARTMENT
  POS-POSITION
  POS-EFFECT-DATE

File created: Thu Jun 09 11:14:38 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.