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. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated 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 9Contains 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 SET3
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 are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
TGRSET1
  1. COMPANY
  2. EMPLOYEE
  3. EMPLOYEE-GROUP
  4. EFFECTIVE-DATE
  5. QUALIFY-FLAG
PrimaryBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
TGRSET2
  1. COMPANY
  2. EMPLOYEE
  3. EFFECTIVE-DATE
  4. EMPLOYEE-GROUP
  5. QUALIFY-FLAG
LP100
TGRSET3
  1. COMPANY
  2. EMPLOYEE
  3. EMPLOYEE-GROUP
  4. HOLD-FLAG ↓
  5. EFFECTIVE-DATE ↓
  6. QUALIFY-FLAG
KeyChangeHR11.1, HR511, LT101, LT111, LP100, PA100, PA52.4
TGRSET4
  1. COMPANY
  2. EMPLOYEE-GROUP
  3. EMPLOYEE
  4. EFFECTIVE-DATE
  5. QUALIFY-FLAG
HR55.1, HR55.2, HR55.3

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMEMPLOYEEPERSGROUPPAEMPLOYEETAEEGROUP

One to one (4) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
TGR-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
EmployeeEMPLOYEERequired
TGR-COMPANY→EMP-COMPANY
TGR-EMPLOYEE→EMP-EMPLOYEE
Employee GroupPERSGROUPRequired
TGR-COMPANY→PRG-COMPANY
TGR-EMPLOYEE-GROUP→PRG-GROUP-NAME
PaemployeePAEMPLOYEERequired
TGR-COMPANY→PEM-COMPANY
TGR-EMPLOYEE→PEM-EMPLOYEE

Programs

Updated by (68)