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 HR51.8 HR515 HR54.1 HR55.2
HR70.1 HRS1.1 HRSC.1 HS208 HS705 PR521
XH700 XH777 EXI2.1 EXI4.1 LP100 LP101
LP130 LP140 LP145 LP180 LP188 LP197
LP198 LP231 LP240 LP251 LP260 LP262
LP264 LP32.1 LP32.2 LP32.3 LP53.1 LP553
LP554 LP80.1 HS11.1 HS11.2 PA06.1 PA09.1
PA103 PA11.1 PA113 PA149 PA16.1 PA170
PA20.1 PA206 PA208 PA21.1 PA213 PA22.1
PA24.1 PA242 PA248 PA249 PA27.1 PA292
PA294 PA302 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 PA80.1 PA80.2
PA82.1 PA90.1 PA92.2 PA93.4 PA94.1 TR207
TR21.1 TR22.1 TR222 TR26.1 TR500 HS20.1
HS21.1 PR03.1 PR04.1 PR128 PR129 PR130
PR131 PR132 PR134 PR135 PR136 PR139
PR140 PR141 PR142 PR160 PR180 PR189
PR195 PR197 PR204 PR212 PR214 PR223
PR226 PR229 PR23.1 PR23.3 PR247 PR260
PR274 PR277 PR29.1 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 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 XR774 XR775 SNEM.1 TA147
TA170 TA175 TA260 TA265 TA290 XT795
TM240 TM245 TM250 TM255 TM260 TM265
TM470 TM570 TM70.1 TM71.1 HRLRD


UPDATED BY
HR02.1 BN231 BN232 BN238 BN246 BN305
HCCP.1 HCDL.1 HDPT.1 HR00.1 HR01.1 HR11.1
HR11.2 HR14.1 HR202 HR211 HR213 HR511
HR514 PA02.1 PA100 PA102 PA115 PA13.1
PA13.2 PA171 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 PA345 PA350 PA355 PA360 PA370
PA371 PA402 PA502 PA513 PA52.1 PA52.3
PA52.4 PA52.5 PA532 PA66.2 HS36.1 PR110
PR113 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 PR137 PR270 PR275 PR276 PR279
UK183 UK184 XR275 HS703 PA341 HS01.1
HS34.1 TM52.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
XH700 XH777
XR774 XR775
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 HR511
HS703 LP251
LP32.3 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA171
PA172 PA202
PA210 PA211
PA212 PA214
PA215 PA216
PA217 PA218


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: Wed Jun 08 20:49:04 2016

Home
Contact Us



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