Entity MPFProgression

Description of Entity MPFProgression

This entity is for the Hong Kong Payroll.


List of all Dependencies of the Entity MPFProgression

Name

Code

Class Name

Relation_1201352

Relation_1201352

Reference


List of Attributes of the Entity MPFProgression

Name

Code

EmployeeSysId

EmployeeSysId

MPFProgSysId

MPFProgSysId

MPFProgEffDate

MPFProgEffDate

MPFPaymentDate

MPFPaymentDate

MPFEEStartDate

MPFEEStartDate

MPFERVolStartDate

MPFERVolStartDate

MPFCareerId

MPFCareerId

MPFMandatoryPolicyId

MPFMandatoryPolicyId

MPFVoluntaryPolicyId

MPFVoluntaryPolicyId

MPFScheme

MPFScheme

MPFTrustee

MPFTrustee

MPFMembershipNo

MPFMembershipNo

MPFCurrent

MPFCurrent

MPFRemarks

MPFRemarks


Entity Attribute EmployeeSysId of the Entity MPFProgression

Card of Attribute EmployeeSysId of the Entity MPFProgression

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

Yes


Description of Attribute EmployeeSysId of the Entity MPFProgression

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


Entity Attribute MPFProgSysId of the Entity MPFProgression

Card of Attribute MPFProgSysId of the Entity MPFProgression

Name

MPFProgSysId

Code

MPFProgSysId

Data Type

integer

Mandatory

Yes


Entity Attribute MPFProgEffDate of the Entity MPFProgression

Card of Attribute MPFProgEffDate of the Entity MPFProgression

Name

MPFProgEffDate

Code

MPFProgEffDate

Data Type

date

Mandatory

No


Entity Attribute MPFPaymentDate of the Entity MPFProgression

Card of Attribute MPFPaymentDate of the Entity MPFProgression

Name

MPFPaymentDate

Code

MPFPaymentDate

Data Type

date

Mandatory

No


Entity Attribute MPFEEStartDate of the Entity MPFProgression

Card of Attribute MPFEEStartDate of the Entity MPFProgression

Name

MPFEEStartDate

Code

MPFEEStartDate

Data Type

date

Mandatory

No


Entity Attribute MPFERVolStartDate of the Entity MPFProgression

Card of Attribute MPFERVolStartDate of the Entity MPFProgression

Name

MPFERVolStartDate

Code

MPFERVolStartDate

Data Type

date

Mandatory

No


Entity Attribute MPFCareerId of the Entity MPFProgression

Card of Attribute MPFCareerId of the Entity MPFProgression

Name

MPFCareerId

Code

MPFCareerId

Data Type

char(20)

Mandatory

No


Entity Attribute MPFMandatoryPolicyId of the Entity MPFProgression

Card of Attribute MPFMandatoryPolicyId of the Entity MPFProgression

Name

MPFMandatoryPolicyId

Code

MPFMandatoryPolicyId

Data Type

char(20)

Mandatory

No


Entity Attribute MPFVoluntaryPolicyId of the Entity MPFProgression

Card of Attribute MPFVoluntaryPolicyId of the Entity MPFProgression

Name

MPFVoluntaryPolicyId

Code

MPFVoluntaryPolicyId

Data Type

char(20)

Mandatory

No


Entity Attribute MPFScheme of the Entity MPFProgression

Card of Attribute MPFScheme of the Entity MPFProgression

Name

MPFScheme

Code

MPFScheme

Data Type

char(20)

Mandatory

No


Entity Attribute MPFTrustee of the Entity MPFProgression

Card of Attribute MPFTrustee of the Entity MPFProgression

Name

MPFTrustee

Code

MPFTrustee

Data Type

char(20)

Mandatory

No


Entity Attribute MPFMembershipNo of the Entity MPFProgression

Card of Attribute MPFMembershipNo of the Entity MPFProgression

Name

MPFMembershipNo

Code

MPFMembershipNo

Data Type

char(30)

Mandatory

No


Entity Attribute MPFCurrent of the Entity MPFProgression

Card of Attribute MPFCurrent of the Entity MPFProgression

Name

MPFCurrent

Code

MPFCurrent

Data Type

smallint

Mandatory

No


Entity Attribute MPFRemarks of the Entity MPFProgression

Card of Attribute MPFRemarks of the Entity MPFProgression

Name

MPFRemarks

Code

MPFRemarks

Data Type

char(100)

Mandatory

No


Previous
Home
Next