Entity PhTaxEmployee

Description of Entity PhTaxEmployee

This entity is for the Philippines Payroll.


List of all Dependencies of the Entity PhTaxEmployee

Name

Code

Class Name

Relation_919935

Relation_919935

Reference


List of Attributes of the Entity PhTaxEmployee

Name

Code

PersonalSysId

PersonalSysId

PhTaxEESysId

PhTaxEESysId

From Pay Rec Year

FromPayRecYear

From Pay Rec Period

FromPayRecPeriod

From Pay Rec SubPeriod

FromPayRecSubPeriod

To Pay Rec Year

ToPayRecYear

To Pay Rec Period

ToPayRecPeriod

To Pay Rec SubPeriod

ToPayRecSubPeriod

Pay Rec ID

PayRecID

TaxLastProcessed

TaxLastProcessed


Entity Attribute PersonalSysId of the Entity PhTaxEmployee

Card of Attribute PersonalSysId of the Entity PhTaxEmployee

Name

PersonalSysId

Code

PersonalSysId

Data Type

integer

Mandatory

Yes


Description of Attribute PersonalSysId of the Entity PhTaxEmployee

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 PhTaxEESysId of the Entity PhTaxEmployee

Card of Attribute PhTaxEESysId of the Entity PhTaxEmployee

Name

PhTaxEESysId

Code

PhTaxEESysId

Data Type

integer

Mandatory

Yes


Entity Attribute From Pay Rec Year of the Entity PhTaxEmployee

Card of Attribute From Pay Rec Year of the Entity PhTaxEmployee

Name

From Pay Rec Year

Code

FromPayRecYear

Data Type

integer

Mandatory

No


Description of Attribute From Pay Rec Year of the Entity PhTaxEmployee

Shows the start of which year.
Example: From 2011


Entity Attribute From Pay Rec Period of the Entity PhTaxEmployee

Card of Attribute From Pay Rec Period of the Entity PhTaxEmployee

Name

From Pay Rec Period

Code

FromPayRecPeriod

Data Type

integer

Mandatory

No


Description of Attribute From Pay Rec Period of the Entity PhTaxEmployee

Shows the start of which period.
Example: From period "2" = February


Entity Attribute From Pay Rec SubPeriod of the Entity PhTaxEmployee

Card of Attribute From Pay Rec SubPeriod of the Entity PhTaxEmployee

Name

From Pay Rec SubPeriod

Code

FromPayRecSubPeriod

Data Type

integer

Mandatory

No


Description of Attribute From Pay Rec SubPeriod of the Entity PhTaxEmployee

Shows the start of which sub period.
Example: From sub period "1"


Entity Attribute To Pay Rec Year of the Entity PhTaxEmployee

Card of Attribute To Pay Rec Year of the Entity PhTaxEmployee

Name

To Pay Rec Year

Code

ToPayRecYear

Data Type

integer

Mandatory

No


Description of Attribute To Pay Rec Year of the Entity PhTaxEmployee

Shows till which year the tax is to be included.
Example: To 2013


Entity Attribute To Pay Rec Period of the Entity PhTaxEmployee

Card of Attribute To Pay Rec Period of the Entity PhTaxEmployee

Name

To Pay Rec Period

Code

ToPayRecPeriod

Data Type

integer

Mandatory

No


Description of Attribute To Pay Rec Period of the Entity PhTaxEmployee

Shows till which period the tax is to be included.
Example: To period "7" = July


Entity Attribute To Pay Rec SubPeriod of the Entity PhTaxEmployee

Card of Attribute To Pay Rec SubPeriod of the Entity PhTaxEmployee

Name

To Pay Rec SubPeriod

Code

ToPayRecSubPeriod

Data Type

integer

Mandatory

No


Description of Attribute To Pay Rec SubPeriod of the Entity PhTaxEmployee

Shows till which sub period the tax is to be included.
Example: To sub period "4"


Entity Attribute Pay Rec ID of the Entity PhTaxEmployee

Card of Attribute Pay Rec ID of the Entity PhTaxEmployee

Name

Pay Rec ID

Code

PayRecID

Data Type

char(20)

Mandatory

No


Description of Attribute Pay Rec ID of the Entity PhTaxEmployee

Stores the identity for the pay record.
Example: Normal / Normal Time Sheet


Entity Attribute TaxLastProcessed of the Entity PhTaxEmployee

Card of Attribute TaxLastProcessed of the Entity PhTaxEmployee

Name

TaxLastProcessed

Code

TaxLastProcessed

Data Type

smallint

Mandatory

No


Description of Attribute TaxLastProcessed of the Entity PhTaxEmployee

Shows when the tax was last processed.