Entity HIProgression

Description of Entity HIProgression

This entity is for the Vietnam Payroll.


List of all Dependencies of the Entity HIProgression

Name

Code

Class Name

Relation_1085216

Relation_1085216

Reference

Relation_1085217

Relation_1085217

Reference

Relation_1085218

Relation_1085218

Reference

Relation_1085219

Relation_1085219

Reference

Relation_1085220

Relation_1085220

Reference


List of Attributes of the Entity HIProgression

Name

Code

EmployeeSysId

EmployeeSysId

HIProgSysId

HIProgSysId

HIProgCurrent

HIProgCurrent

HIEffectiveDate

HIEffectiveDate

HICareerId

HICareerId

HIProgPolicyId

HIProgPolicyId

HICardNo

HICardNo

HIPlaceCheck

HIPlaceCheck

HIProgRemarks

HIProgRemarks

HIRegExpDate

HIRegExpDate

HICardReturnedDate

HICardReturnedDate

HIProvince

HIProvince


Entity Attribute EmployeeSysId of the Entity HIProgression

Card of Attribute EmployeeSysId of the Entity HIProgression

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

Yes


Description of Attribute EmployeeSysId of the Entity HIProgression

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


Entity Attribute HIProgSysId of the Entity HIProgression

Card of Attribute HIProgSysId of the Entity HIProgression

Name

HIProgSysId

Code

HIProgSysId

Data Type

integer

Mandatory

Yes


Entity Attribute HIProgCurrent of the Entity HIProgression

Card of Attribute HIProgCurrent of the Entity HIProgression

Name

HIProgCurrent

Code

HIProgCurrent

Data Type

smallint

Mandatory

No


Entity Attribute HIEffectiveDate of the Entity HIProgression

Card of Attribute HIEffectiveDate of the Entity HIProgression

Name

HIEffectiveDate

Code

HIEffectiveDate

Data Type

date

Mandatory

No


Entity Attribute HICareerId of the Entity HIProgression

Card of Attribute HICareerId of the Entity HIProgression

Name

HICareerId

Code

HICareerId

Data Type

char(20)

Mandatory

No


Entity Attribute HIProgPolicyId of the Entity HIProgression

Card of Attribute HIProgPolicyId of the Entity HIProgression

Name

HIProgPolicyId

Code

HIProgPolicyId

Data Type

char(20)

Mandatory

No


Entity Attribute HICardNo of the Entity HIProgression

Card of Attribute HICardNo of the Entity HIProgression

Name

HICardNo

Code

HICardNo

Data Type

char(30)

Mandatory

No


Entity Attribute HIPlaceCheck of the Entity HIProgression

Card of Attribute HIPlaceCheck of the Entity HIProgression

Name

HIPlaceCheck

Code

HIPlaceCheck

Data Type

char(50)

Mandatory

No


Entity Attribute HIProgRemarks of the Entity HIProgression

Card of Attribute HIProgRemarks of the Entity HIProgression

Name

HIProgRemarks

Code

HIProgRemarks

Data Type

char(100)

Mandatory

No


Entity Attribute HIRegExpDate of the Entity HIProgression

Card of Attribute HIRegExpDate of the Entity HIProgression

Name

HIRegExpDate

Code

HIRegExpDate

Data Type

date

Mandatory

No


Entity Attribute HICardReturnedDate of the Entity HIProgression

Card of Attribute HICardReturnedDate of the Entity HIProgression

Name

HICardReturnedDate

Code

HICardReturnedDate

Data Type

date

Mandatory

No


Entity Attribute HIProvince of the Entity HIProgression

Card of Attribute HIProvince of the Entity HIProgression

Name

HIProvince

Code

HIProvince

Data Type

char(50)

Mandatory

No


Previous
Home
Next