Lawson Insight Technical Documentation |
|
DEPTCODE
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
AC541 AC542 BN100 BN101 BN102 BN103
BN105 BN145 BN150 BN230 BN231 BN232
BN238 BN240 BN242 BN245 BN246 BN320
BN335 HCCP.1 HCOP.1 HCOP.2 FC202 HDPT.1
HGLM.1 HPOS.1 HPQC.1 HPRS.1 HR11.1 HR11.2
HR12.1 HR14.1 HR15.1 HR155 HR170 HR202
HR211 HR213 HR217 HR220 HR511 HR514
HR515 HR54.1 HR55.2 HR650 HR70.1 HRS1.1
HRSC.1 ZR651 HS11.1 PA02.1 PA06.1 PA09.1
PA100 PA102 PA11.1 PA113 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 PA227 PA24.1 PA242 PA248 PA249
PA259 PA27.1 PA271 PA272 PA290 PA294
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 PA570 PA59.1 PA590 PA66.2 PA66.3
PA71.1 PA73.1 PA80.1 PA80.2 PA90.1 PA93.4
PA94.1 TR207 TR21.1 TR22.1 TR26.1 TR500
HS20.1 HS21.1 HS36.1 PR03.1 PR04.1 PR110
PR113 PR120 PR128 PR13.1 PR13.5 PR13.6
PR13.8 PR130 PR131 PR132 PR134 PR136
PR137 PR139 PR140 PR141 PR142 PR160
PR180 PR189 PR195 PR204 PR212 PR214
PR226 PR229 PR23.1 PR23.3 PR247 PR260
PR270 PR275 PR276 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 PR36.1 PR37.1 PR38.1 PR39.2 PR45.1
PR529 PR530 PR560 PR80.1 PR80.2 PR82.1
PR82.2 PRSC.1 UK102 UK13.1 UK141 UK183
UK184 UK201 UK277 UK560 TA147 TA170
TA175 TA260 TA265 TA290 TM240 TM245
TM250 TM255 TM260 TM265 TM470 TM570
TM70.1 TM71.1 UK120 UK60.1 UK70.1 FCLRD
HRLRD PA341 HS01.1 HS34.1 TM52.1
UPDATED BY
HR02.1 HR702 HR00.1 HR01.1 PBIP.1 PR197
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DPT-COMPANY Numeric 4 HR02.1
Element: Company Contains the number that represents an
established company and is entered on
all functions.
DPT-PROCESS-LEVEL Alpha 5 HR02.1
Element: Process Level Contains the process level to which
this department belongs.
DPT-DEPARTMENT Alpha 5 HR02.1
Element: Department Contains the department.
DPT-NAME Alpha 30 (Lower Case) BN245 FC202
Element: Name Contains the name or description of the HR02.1 PA218
department. PA242 PA71.1
PA73.1 PA80.1
PA80.2 PR131
PR142
DPT-DEP-DIST-CO Numeric 4 HR02.1
Element: Dep Dist Co Contains the department's payroll
distribution company.
DPT-DEP-ACCT-UNIT Alpha 15 HR02.1
Department Account Contains the department's payroll
Unit expense accounting unit.
DPT-DEP-ACCOUNT Numeric 6 HR02.1
Element: Department AccContains the department's payroll
expense account number.
DPT-DEP-SUB-ACCT Numeric 4 HR02.1
Department Contains the department's payroll
Subaccount expense subaccount number.
DPT-SEC-LVL Numeric 1 HR02.1
Element: Sec Lvl Contains the default security level for
the department.
DPT-SEC-LOCATION Alpha 10 HR02.1
Element: Sec Location Contains the default security location
for the department.
DPT-SEGMENT-FLAG Alpha 1 HR02.1
Element: Segment Flag Identifies the user analysis
values included on payroll expense
transactions.
DPT-ACTIVE-FLAG Alpha 1 HR02.1 HR702
Element: Status The Active flag of the credit card
type.
A = Active
I = Inactive
DPT-USER-ID Alpha 10 (Lower Case) HR02.1 HR702
Element: User
DPT-DATE-STAMP Numeric 8 (yyyymmdd) HR02.1 HR702
Element: Date Stamp This field contains the server date
(month, date, and year) of the last
change to this record.
DPT-TIME-STAMP Numeric 6 (hhmmss) HR02.1 HR702
Element: Time Stamp Contains the server time (hour, minute,
and second) when the record was last
changed.
DEPTCODE FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
DPTSET1 COMPANY AC541 AC542
PROCESS-LEVEL BN100 BN101
DEPARTMENT BN102 BN103
BN105 BN145
BN150 BN230
BN231 BN232
BN238 BN240
BN242 BN245
BN246 BN320
BN335 HCCP.1
HCOP.1 HCOP.2
FC202 HDPT.1
HGLM.1 HPOS.1
HPQC.1 HPRS.1
HR00.1 HR01.1
...
DPTSET2 COMPANY BN231 BN232
DEPARTMENT BN238 BN246
PROCESS-LEVEL FC202 HR11.1
HR11.2 HR211
HR213 HR511
HR650 ZR651
PA02.1 PA100
PA102 PA13.1
PA13.2 PA171
PA172 PA202
PA211 PA212
PA214 PA215
PA216 PA217
PA218 PA219
PA220 PA221
...
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
|