Project

Projectname Pay Structure Derivation Projectauthor Rama (MLC) Projectdescription Transforming Company Policies to Data Model Date of report 3/30/00 Title of report Detailed entity and relationship information

---

Image of diagram (clickable)

---

Entities

Group Pay Structure Abbreviation: Group Pay Structure Description: Transaltion of Company Policies Weak: No
Attributename	Description	Datatype	Length	Decimalplaces	Domain	PK	FK
GROUP	Pay group	VARCHAR	16	0		YES	-
VARIANT	Variant for group	VARCHAR	16	0		YES	-
PAY_ELEMENT	Pay element in the Group	VARCHAR	32	0		YES	-
FKVARIANT		VARCHAR	16	0		-	YES
FKGROUP		VARCHAR	16	0		-	YES

Group Pay Variant Abbreviation: Group Pay Variant Description: Pay variants for Group Weak: No
Attributename	Description	Datatype	Length	Decimalplaces	Domain	PK	FK
GROUP	Pay group	VARCHAR	16	0		YES	-
VARIANT	Variants for the Pay Group	VARCHAR	16	0		YES	-
FKPAY_ELEMENT		VARCHAR	32	0		-	YES
FKVARIANT		VARCHAR	16	0		-	YES
FKGROUP		VARCHAR	16	0		-	YES

EMPLOYEE Abbreviation: EMP Description: Empoloyee in company Weak: No
Attributename	Description	Datatype	Length	Decimalplaces	Domain	PK	FK
EMP	Employee Number	VARCHAR	16	0		YES	-
EMP_NAME	Name of the Employee	VARCHAR	50	0		-	-
IS_MALE_OR_FEMALE	Gender	VARCHAR	1	0		-	-
JOB_TITLE	Job Description	VARCHAR	40	0		-	-
ESI_DISPENSARY	Esi Dispensary Code	VARCHAR	50	0		-	-
PAYMENT_MODE		VARCHAR	15	0		-	-
FATHER_NAME		VARCHAR	50	0		-	-

Emp Pay Group Selected Abbreviation: Description: Pay Group selected for the employee Weak: No
Attributename	Description	Datatype	Length	Decimalplaces	Domain	PK	FK
EMP	Employee Number	VARCHAR	16	0		YES	-
GROUP	Pay Group selected for the Employee	VARCHAR	16	0		-	-

Emp Pay Variant Selected Abbreviation: Description: VARIANTS SELECTED FOR EMPLOYEE Weak: No
Attributename	Description	Datatype	Length	Decimalplaces	Domain	PK	FK
EMP	EMPLOYEE NUMBER	VARCHAR	16	0		YES	-
VARIANT	PAY VARIANT SELECTED	VARCHAR	16	0		YES	-

Emp Dependency Values Abbreviation: Description: Employee Job Information Weak: No
Attributename	Description	Datatype	Length	Decimalplaces	Domain	PK	FK
EMP	Employee Number	VARCHAR	16	0		YES	-
DEPENDENCY	Dependencies	VARCHAR	16	0		-	-
DEP_VALUE	Values for Dependencies	VARCHAR	50	0		-	-

EMP_PAY_STRUCTURE Abbreviation: Description: Pay Structure for Employee Weak: No
Attributename	Description	Datatype	Length	Decimalplaces	Domain	PK	FK
EMP	Employee Number	VARCHAR	16	0		YES	-
PAY_ELEMENT	Pay element configured	VARCHAR	32	0		YES	-
SYS_VALUE	System Derived value	NUMERIC	13	2		-	-
USER_VALUE	User Derived Value	NUMERIC	13	2		-	-
IS_DB_CR	Db/ Cr indicator	VARCHAR	2	0		-	-

Relationships

GPV_TO_GPS Abbreviation: Description: FROM TO 1:1 1:1 Group Pay Variant Group Pay Structure