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 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 HR105
HR11.1 HR11.2 HR11.4 HR12.1 HR14.1 HR15.1
HR155 HR156 HR170 HR202 HR211 HR213
HR217 HR220 HR228 HR255 HR28.1 HR51.2
HR51.3 HR51.6 HR51.8 HR511 HR514 HR515
HR52.2 HR52.6 HR54.1 HR55.2 HR70.1 HRS1.1
HRSC.1 HS208 HS705 LT101 LT11.5 LT111
LT13.5 PR521 ZH156 ZH500 ZH510 ZH568
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 PA02.1 PA06.1 PA09.1 PA100
PA102 PA103 PA105 PA11.1 PA113 PA115
PA13.1 PA13.2 PA149 PA16.1 PA170 PA171
PA172 PA20.1 PA202 PA206 PA208 PA21.1
PA210 PA211 PA212 PA213 PA214 PA215
PA216 PA217 PA218 PA219 PA22.1 PA220
PA221 PA222 PA223 PA224 PA225 PA227
PA24.1 PA242 PA248 PA249 PA259 PA27.1
PA271 PA272 PA290 PA292 PA294 PA302
PA31.3 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 PA42.3
PA490 PA495 PA502 PA513 PA52.1 PA52.2
PA52.3 PA52.4 PA52.5 PA520 PA53.1 PA532
PA535 PA54.1 PA570 PA59.1 PA590 PA66.2
PA66.3 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 ZE532 HS20.1
HS21.1 HS36.1 PR03.1 PR04.1 PR110 PR113
PR12.6 PR120 PR128 PR129 PR13.1 PR13.5
PR13.6 PR13.8 PR13.9 PR131 PR132 PR134
PR135 PR136 PR137 PR139 PR140 PR141
PR142 PR189 PR195 PR197 PR204 PR212
PR214 PR223 PR226 PR229 PR23.1 PR23.3
PR247 PR260 PR270 PR274 PR275 PR276
PR277 PR279 PR280 PR29.1 PR295 PR30.1
PR30.2 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 PR36.4 PR37.1 PR38.1
PR39.2 PR45.1 PR512 PR529 PR530 PR560
PR582 PR80.1 PR80.4 PR82.1 PR82.2 UK102
SNEM.1 TA147 TA175 TA260 TA265 TA290
TM240 TM245 TM250 TM255 TM260 TM265
TM470 TM570 TM70.1 TM71.1 HRLRD HS703
PA341 HS01.1 HS34.1 TM52.1


UPDATED BY
HR02.1 HR00.1 HR01.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 HR11.4
HR211 HR213
HR228 HR28.1
HR511 HS703
LT101 LT111
ZH510 LP251
LP32.3 PA02.1
PA100 PA102
PA115 PA13.1
PA13.2 PA171
PA172 PA202
PA210 PA211


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 02:15:55 2016

Home
Contact Us



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