Sage EasyPay Data Model

Entity SIProgression

Description of Entity SIProgression

This entity is for the Vietnam Payroll.

List of all Dependencies of the Entity SIProgression

Relation_1085212

Relation_1085212

Reference

Relation_1085213

Relation_1085213

Reference

Relation_1085214

Relation_1085214

Reference

Relation_1085215

Relation_1085215

Reference

Relation_1085221

Relation_1085221

Reference

List of Attributes of the Entity SIProgression

Entity Attribute EmployeeSysId of the Entity SIProgression

Card of Attribute EmployeeSysId of the Entity SIProgression

Name	EmployeeSysId
Code	EmployeeSysId
Data Type	integer
Mandatory	Yes

Description of Attribute EmployeeSysId of the Entity SIProgression

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

Entity Attribute SIProgSysId of the Entity SIProgression

Card of Attribute SIProgSysId of the Entity SIProgression

Name	SIProgSysId
Code	SIProgSysId
Data Type	integer
Mandatory	Yes

Entity Attribute SIProgCurrent of the Entity SIProgression

Card of Attribute SIProgCurrent of the Entity SIProgression

Name	SIProgCurrent
Code	SIProgCurrent
Data Type	smallint
Mandatory	No

Entity Attribute SIProgressionDate of the Entity SIProgression

Card of Attribute SIProgressionDate of the Entity SIProgression

Name	SIProgressionDate
Code	SIProgressionDate
Data Type	date
Mandatory	No

Entity Attribute SIEffectiveDate of the Entity SIProgression

Card of Attribute SIEffectiveDate of the Entity SIProgression

Name	SIEffectiveDate
Code	SIEffectiveDate
Data Type	date
Mandatory	No

Entity Attribute SICareerId of the Entity SIProgression

Card of Attribute SICareerId of the Entity SIProgression

Name	SICareerId
Code	SICareerId
Data Type	char(20)
Mandatory	No

Entity Attribute SIProgPolicyId of the Entity SIProgression

Card of Attribute SIProgPolicyId of the Entity SIProgression

Name	SIProgPolicyId
Code	SIProgPolicyId
Data Type	char(20)
Mandatory	No

Entity Attribute PreviousSIWage of the Entity SIProgression

Card of Attribute PreviousSIWage of the Entity SIProgression

Name	PreviousSIWage
Code	PreviousSIWage
Data Type	double
Mandatory	No

Entity Attribute CurrentSIWage of the Entity SIProgression

Card of Attribute CurrentSIWage of the Entity SIProgression

Name	CurrentSIWage
Code	CurrentSIWage
Data Type	double
Mandatory	No

Entity Attribute SIRegistrationDate of the Entity SIProgression

Card of Attribute SIRegistrationDate of the Entity SIProgression

Name	SIRegistrationDate
Code	SIRegistrationDate
Data Type	date
Mandatory	No

Entity Attribute SIBookNo of the Entity SIProgression

Card of Attribute SIBookNo of the Entity SIProgression

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

Entity Attribute SIProgRemarks of the Entity SIProgression

Card of Attribute SIProgRemarks of the Entity SIProgression

Name	SIProgRemarks
Code	SIProgRemarks
Data Type	char(100)
Mandatory	No