Sage EasyPay Data Model

Entity HKPeriodOrdinance

Description of Entity HKPeriodOrdinance

This entity is for the Hong Kong Payroll.

List of all Dependencies of the Entity HKPeriodOrdinance

Relation_1855798

Reference

Relation_1849449

Reference

List of Attributes of the Entity HKPeriodOrdinance

Entity Attribute EmployeeSysId of the Entity HKPeriodOrdinance

Card of Attribute EmployeeSysId of the Entity HKPeriodOrdinance

Name	EmployeeSysId
Code	EmployeeSysId
Data Type	integer
Mandatory	Yes

Description of Attribute EmployeeSysId of the Entity HKPeriodOrdinance

System generated identifier. It is blind to the user. It also holds the primary key for the Employee table.

Entity Attribute OrdinSGSPGenId of the Entity HKPeriodOrdinance

Card of Attribute OrdinSGSPGenId of the Entity HKPeriodOrdinance

Name	OrdinSGSPGenId
Code	OrdinSGSPGenId
Data Type	char(30)
Mandatory	Yes

Description of Attribute OrdinSGSPGenId of the Entity HKPeriodOrdinance

Shows the generating identity of the HKPeriodOrdinance entity.
Example: A1 / A66 / A110

Entity Attribute Year of the Entity HKPeriodOrdinance

Card of Attribute Year of the Entity HKPeriodOrdinance

Name	Year
Code	PayRecYear
Data Type	integer
Mandatory	No

Description of Attribute Year of the Entity HKPeriodOrdinance

Shows the year for the pay record.
Example: 2012

Entity Attribute Period of the Entity HKPeriodOrdinance

Card of Attribute Period of the Entity HKPeriodOrdinance

Name	Period
Code	PayRecPeriod
Data Type	integer
Mandatory	No

Description of Attribute Period of the Entity HKPeriodOrdinance

Shows the period for the pay record.
Example: January = "1", February = "2", March = "3" etc.

Entity Attribute OrdinCalYear of the Entity HKPeriodOrdinance

Card of Attribute OrdinCalYear of the Entity HKPeriodOrdinance

Name	OrdinCalYear
Code	OrdinCalYear
Data Type	integer
Mandatory	No

Description of Attribute OrdinCalYear of the Entity HKPeriodOrdinance

Calculates the year of the ordinance.

Entity Attribute OrdinCalMth of the Entity HKPeriodOrdinance

Card of Attribute OrdinCalMth of the Entity HKPeriodOrdinance

Name	OrdinCalMth
Code	OrdinCalMth
Data Type	integer
Mandatory	No

Description of Attribute OrdinCalMth of the Entity HKPeriodOrdinance

Calculates the month of the ordinance.

Entity Attribute OrdinPeriodEOWage of the Entity HKPeriodOrdinance

Card of Attribute OrdinPeriodEOWage of the Entity HKPeriodOrdinance

Name	OrdinPeriodEOWage
Code	OrdinPeriodEOWage
Data Type	double
Mandatory	No

Description of Attribute OrdinPeriodEOWage of the Entity HKPeriodOrdinance

Shows the period of the employment ordinance wage.

Home