TAEEGROUP – Absence Plan Employee Group

System: Absence Management (LP)
Prefix: TGR
Primary key: COMPANY, EMPLOYEE, EMPLOYEE-GROUP, EFFECTIVE-DATE, QUALIFY-FLAG
Fields: 12
Updated by: 68 programs
Referenced by: 0 programs

TAEEGROUP is the Absence Plan Employee Group table in Lawson Absence Management (prefix TGR). It is indexed by COMPANY, EMPLOYEE, EMPLOYEE-GROUP, EFFECTIVE-DATE, QUALIFY-FLAG (TGRSET1); alternate indexes: TGRSET2, TGRSET3 and TGRSET4. It is related 1:1 to PRSYSTEM, EMPLOYEE, PERSGROUP and PAEMPLOYEE. It is updated by BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 and 60 more. The table has 12 fields, 4 indexes and 4 documented relations.

About TAEEGROUP

No description in the Lawson data dictionary.

Fields (12)

Column = COBOL field name without the TGR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`TGR-COMPANY` PK COMPANY	Numeric 4	—	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
`TGR-EMPLOYEE` PK EMPLOYEE	Numeric 9	Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
`TGR-EMPLOYEE-GROUP` PK EMPLOYEE_GROUP	Alpha 10	—	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
`TGR-EFFECTIVE-DATE` PK EFFECTIVE_DATE	Numeric 8 (yyyymmdd)	—	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
`TGR-QUALIFY-FLAG` PK QUALIFY_FLAG	Numeric 1	— `0` No `1` Yes `2` Action Reversal	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
`TGR-HOLD-FLAG` HOLD_FLAG	Numeric 1	— `0` No `1` Yes	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
`TGR-CREATE-DATE` CREATE_DATE	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
`TGR-CREATE-TIME` CREATE_TIME	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
`TGR-CREATE-USER-ID` CREATE_USER_ID	Alpha 10 (Lower Case)	—	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
`TGR-DATE-STAMP` DATE_STAMP	Numeric 8 (yyyymmdd)	This field contains the server date (month, date, and year) of the last change to this record.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
`TGR-TIME-STAMP` TIME_STAMP	Numeric 6 (hhmmss)	Contains the server time (hour, minute, and second) when the record was last changed.	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)
`TGR-USER-ID` USER_ID	Alpha 10 (Lower Case)	—	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +52 more (list truncated in source)

Indexes (4)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Used in
`TGRSET1`	`COMPANY`, `EMPLOYEE`, `EMPLOYEE-GROUP`, `EFFECTIVE-DATE`, `QUALIFY-FLAG`	Primary	BN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
`TGRSET2`	`COMPANY`, `EMPLOYEE`, `EFFECTIVE-DATE`, `EMPLOYEE-GROUP`, `QUALIFY-FLAG`		LP100
`TGRSET3`	`COMPANY`, `EMPLOYEE`, `EMPLOYEE-GROUP`, `HOLD-FLAG`, `EFFECTIVE-DATE`, `QUALIFY-FLAG`	KeyChange	HR11.1, HR511, LT101, LT111, LP100, PA100, PA52.4
`TGRSET4`	`COMPANY`, `EMPLOYEE-GROUP`, `EMPLOYEE`, `EFFECTIVE-DATE`, `QUALIFY-FLAG`		HR55.1, HR55.2, HR55.3

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Field map
Company	PRSYSTEM	Required	`TGR-COMPANY` → `PRS-COMPANY`, `Spaces` → `PRS-PROCESS-LEVEL`
Employee	EMPLOYEE	Required	`TGR-COMPANY` → `EMP-COMPANY`, `TGR-EMPLOYEE` → `EMP-EMPLOYEE`
Employee Group	PERSGROUP	Required	`TGR-COMPANY` → `PRG-COMPANY`, `TGR-EMPLOYEE-GROUP` → `PRG-GROUP-NAME`
Paemployee	PAEMPLOYEE	Required	`TGR-COMPANY` → `PEM-COMPANY`, `TGR-EMPLOYEE` → `PEM-EMPLOYEE`

Programs

Updated by (68)

BN305 Highly Compensated Employees
HAP3.1 Applicant Option 4 Selection Invoke
HCRE.1 Action Reason Code Selects
HEP4.1 Employee Option 4 Selection Invoke
HPOS.1 Position Selection Invoke
HPQC.1 Prqcentgrp Select Invoke
HPRS.1 Process Level Select Invoke
HR11.1 Employee
HR11.2 Compensation Analysis
HR11.4 Employee Assignment Inquiry
HR15.1 User Fields
HR155 Employee Group Update
HR156 Employee Group Company Update
HR28.1 Employee Ethnicity
HR511 Employee Conversion
HR515 User Field Conversion
HR54.1 Employee History Correction
HR55.1 Employee Group Definition
HR55.2 Employee Groups By Employees
HR55.3 Employee Groups By Criteria
HRS1.1 Select Control
HRSC.1 Select Control
LP100 Employee Absence Plan Update
LP101 Mass Absence Plan Add
LP35.1 Employee Absence Group Audit
LT101 HRM Receiver Update
LT111 HRM Receiver Update
PA02.1 Position
PA100 Action Update
PA102 Position Update
PA115 Employee Purge
PA13.1 Multiple Positions and Jobs
PA13.2 Multiple Position and Job History
PA16.1 Company Property
PA20.1 Education
PA21.1 Competencies
PA22.1 Certifications
PA24.1 Relocation
PA27.1 Contracts
PA34.1 Applicant Education
PA35.1 Applicant Competencies
PA36.1 Applicant Certification
PA38.1 Applicant Relocation
PA502 Position Conversion
PA513 Position and Job Conversion
PA52.1 Individual Action
PA52.3 Mass Action
PA52.4 Hire an Applicant
PA52.5 Position and Job Action
PA520 Employee and Applicant Code Conversion
PA54.1 Personnel Action History Correction
PR110 Step And Grade Audit
PR113 United States Tax Deduction Update
PR12.6 Employee Automatic Deposit
PR120 Mass Pay Update
PR13.1 Employee United States Taxes
PR13.5 Employee Canada Taxes
PR13.6 Employee Canada Taxes
PR13.8 U.S. Tax Deduction Errors
PR13.9 Employee Additional Tax Details
PR30.2 Employee Automatic Time Record
PR512 Employee ACH Distribution Interface
TR21.1 Employee Training History
TR22.1 Session Completion
TR26.1 Employee Training Competency Maintenance
TR500 Training Conversion
ZH156 Employee Group Company Update
ZH510 Update PCP from ZPENDPCP