Sage EasyPay Data Model

Entity PhPrevEmployer

Description of Entity PhPrevEmployer

This entity is for the Philippines Payroll.

List of all Dependencies of the Entity PhPrevEmployer

Relation_920008

Reference

List of Attributes of the Entity PhPrevEmployer

Entity Attribute PersonalSysId of the Entity PhPrevEmployer

Card of Attribute PersonalSysId of the Entity PhPrevEmployer

Name	PersonalSysId
Code	PersonalSysId
Data Type	integer
Mandatory	No

Description of Attribute PersonalSysId of the Entity PhPrevEmployer

This attribute is the system generated identifier. It is blind to the user. It also holds the primary key for the Personal table.

Entity Attribute PhPrevEmployerSysId of the Entity PhPrevEmployer

Card of Attribute PhPrevEmployerSysId of the Entity PhPrevEmployer

Name	PhPrevEmployerSysId
Code	PhPrevEmployerSysId
Data Type	integer
Mandatory	Yes

Entity Attribute PhPrevERTIN of the Entity PhPrevEmployer

Card of Attribute PhPrevERTIN of the Entity PhPrevEmployer

Name	PhPrevERTIN
Code	PhPrevERTIN
Data Type	char(30)
Mandatory	No

Entity Attribute PhPrevERName of the Entity PhPrevEmployer

Card of Attribute PhPrevERName of the Entity PhPrevEmployer

Name	PhPrevERName
Code	PhPrevERName
Data Type	char(150)
Mandatory	No

Entity Attribute PhPrevERAddress of the Entity PhPrevEmployer

Card of Attribute PhPrevERAddress of the Entity PhPrevEmployer

Name	PhPrevERAddress
Code	PhPrevERAddress
Data Type	char(50)
Mandatory	No

Entity Attribute Postal Code of the Entity PhPrevEmployer

Card of Attribute Postal Code of the Entity PhPrevEmployer

Name	Postal Code
Code	PostalCode
Data Type	char(6)
Mandatory	No

Description of Attribute Postal Code of the Entity PhPrevEmployer

Stores the postal code of the person's address.

Entity Attribute PENonTax13MOthers of the Entity PhPrevEmployer

Card of Attribute PENonTax13MOthers of the Entity PhPrevEmployer

Name	PENonTax13MOthers
Code	PENonTax13MOthers
Data Type	double
Mandatory	No

Entity Attribute PENonTaxSalaryOthers of the Entity PhPrevEmployer

Card of Attribute PENonTaxSalaryOthers of the Entity PhPrevEmployer

Name	PENonTaxSalaryOthers
Code	PENonTaxSalaryOthers
Data Type	double
Mandatory	No

Entity Attribute PENonTaxSSSOthers of the Entity PhPrevEmployer

Card of Attribute PENonTaxSSSOthers of the Entity PhPrevEmployer

Name	PENonTaxSSSOthers
Code	PENonTaxSSSOthers
Data Type	double
Mandatory	No

Entity Attribute PETax13MOthers of the Entity PhPrevEmployer

Card of Attribute PETax13MOthers of the Entity PhPrevEmployer

Name	PETax13MOthers
Code	PETax13MOthers
Data Type	double
Mandatory	No

Entity Attribute PETaxSalaryOthers of the Entity PhPrevEmployer

Card of Attribute PETaxSalaryOthers of the Entity PhPrevEmployer

Name	PETaxSalaryOthers
Code	PETaxSalaryOthers
Data Type	double
Mandatory	No

Entity Attribute PEErTaxWithheld of the Entity PhPrevEmployer

Card of Attribute PEErTaxWithheld of the Entity PhPrevEmployer

Name	PEErTaxWithheld
Code	PEErTaxWithheld
Data Type	double
Mandatory	No

Entity Attribute PEBasicSalaryMWE of the Entity PhPrevEmployer

Card of Attribute PEBasicSalaryMWE of the Entity PhPrevEmployer

Name	PEBasicSalaryMWE
Code	PEBasicSalaryMWE
Data Type	double
Mandatory	No

Entity Attribute PEHolidayPayMWE of the Entity PhPrevEmployer

Card of Attribute PEHolidayPayMWE of the Entity PhPrevEmployer

Name	PEHolidayPayMWE
Code	PEHolidayPayMWE
Data Type	double
Mandatory	No

Entity Attribute PEOvertimeMWE of the Entity PhPrevEmployer

Card of Attribute PEOvertimeMWE of the Entity PhPrevEmployer

Name	PEOvertimeMWE
Code	PEOvertimeMWE
Data Type	double
Mandatory	No

Entity Attribute PENightShiftMWE of the Entity PhPrevEmployer

Card of Attribute PENightShiftMWE of the Entity PhPrevEmployer

Name	PENightShiftMWE
Code	PENightShiftMWE
Data Type	double
Mandatory	No

Entity Attribute PEHazardPayMWE of the Entity PhPrevEmployer

Card of Attribute PEHazardPayMWE of the Entity PhPrevEmployer

Name	PEHazardPayMWE
Code	PEHazardPayMWE
Data Type	double
Mandatory	No

Entity Attribute PETaxBasicSalary of the Entity PhPrevEmployer

Card of Attribute PETaxBasicSalary of the Entity PhPrevEmployer

Name	PETaxBasicSalary
Code	PETaxBasicSalary
Data Type	double
Mandatory	No

Entity Attribute PEDeMinimis of the Entity PhPrevEmployer

Card of Attribute PEDeMinimis of the Entity PhPrevEmployer

Name	PEDeMinimis
Code	PEDeMinimis
Data Type	double
Mandatory	No

Home