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
BN100 BN101 BN102 BN103 BN105 BN145
BN150 BN230 BN231 BN232 BN234 BN238
BN240 BN242 BN245 BN246 BN305 BN320
BN335 ET530 ET700 ETI2.1 HCCP.1 HCDL.1
HAP3.1 HDPT.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1
HR11.1 HR11.2 HR12.1 HR14.1 HR15.1 HR155
HR170 HR202 HR211 HR213 HR217 HR220
HR255 HR511 HR514 HR515 HR54.1 HR55.2
HR70.1 HRS1.1 HRSC.1 HS208 LP100 LP101
LP130 LP140 LP145 LP180 LP188 LP197
LP198 LP231 LP240 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 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
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 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
PR197 PR204 PR212 PR214 PR223 PR226
PR229 PR23.1 PR23.3 PR247 PR260 PR270
PR274 PR275 PR276 PR277 PR279 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 PR80.1
PR80.2 PR82.1 PR82.2 UK102 UK13.1 UK141
UK183 UK184 UK201 UK277 UK560 SNEM.1
TA147 TA170 TA175 TA260 TA265 TA290
TM240 TM245 TM250 TM255 TM260 TM265
TM470 TM570 TM70.1 TM71.1 HRLRD LP251
PA341 HS01.1 HS34.1 TM52.1
UPDATED BY
HR02.1 HR00.1 HR01.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
DPT-COMPANY Numeric 4 HR02.1
Element: Company Hr Contains the number that represents an
established company and is entered on
all functions.
DPT-PROCESS-LEVEL Alpha 5 HR02.1
Element: Process Lev HrContains 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 HR02.1
Element: Name Contains the name or description of the LP32.3 PA218
department. PA242 PA71.1
PA80.1 PA80.2
PR131 PR142
DPT-DEP-DIST-CO Numeric 4 HR02.1 PA52.5
Element: Company Contains the department's payroll
distribution company.
DPT-DEP-ACCT-UNIT Alpha 15 HR02.1 PA52.5
Element: Acct Unit Contains the department's payroll
expense accounting unit.
DPT-DEP-ACCOUNT Numeric 6 HR02.1 PA52.5
Element: Account Contains the department's payroll
expense account number.
DPT-DEP-SUB-ACCT Numeric 4 HR02.1 PA52.5
Element: Sub Acct Contains the department's payroll
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
Element: Active Flag The Active flag of the credit card
type.
A = Active
I = Inactive
DPT-USER-ID Alpha 10 (Lower Case) HR02.1
Element: User
DPT-DATE-STAMP Numeric 8 (yyyymmdd) HR02.1
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
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 BN100 BN101
PROCESS-LEVEL BN102 BN103
DEPARTMENT BN105 BN145
BN150 BN230
BN231 BN232
BN234 BN238
BN240 BN242
BN245 BN246
BN305 BN320
BN335 ET530
ET700 ETI2.1
HCCP.1 HCDL.1
HAP3.1 HDPT.1
HEP4.1 HPOS.1
HPQC.1 HPRS.1
...
DPTSET2 COMPANY BN231 BN232
DEPARTMENT BN238 BN246
PROCESS-LEVEL BN305 ET700
HR11.1 HR11.2
HR211 HR213
HR511 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 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
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
|