Entity SOCSOProgression

Description of Entity SOCSOProgression

This entity is for the Malaysia Payroll.


List of all Dependencies of the Entity SOCSOProgression

Name

Code

Class Name

Relation_771006

Relation_771006

Reference


List of Attributes of the Entity SOCSOProgression

Name

Code

EmployeeSysId

EmployeeSysId

Effective Date

SOCSOEffectiveDate

Career Code

SOCSOCareerId

SOCSO Policy

SOCSOProgPolicyId

SOCSO Scheme

SOCSOProgSchemeId

SOCSOP1Payment

SOCSOP1Payment

Remarks

SOCSORemarks

Current

SOCSOCurrent


Entity Attribute EmployeeSysId of the Entity SOCSOProgression

Card of Attribute EmployeeSysId of the Entity SOCSOProgression

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

Yes


Description of Attribute EmployeeSysId of the Entity SOCSOProgression

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


Entity Attribute Effective Date of the Entity SOCSOProgression

Card of Attribute Effective Date of the Entity SOCSOProgression

Name

Effective Date

Code

SOCSOEffectiveDate

Data Type

date

Mandatory

Yes


Description of Attribute Effective Date of the Entity SOCSOProgression

Shows the effective date of the SOCSO progression. It also holds the primary key for the SOCSOProgression table.
It is usually in the format: DD-MM-YYYY.


Entity Attribute Career Code of the Entity SOCSOProgression

Card of Attribute Career Code of the Entity SOCSOProgression

Name

Career Code

Code

SOCSOCareerId

Data Type

char(20)

Mandatory

No


Description of Attribute Career Code of the Entity SOCSOProgression

Shows the identity of the career for the employee.
Example: FirstRecord / Transfer / Promotion / SalaryAdjust etc


Entity Attribute SOCSO Policy of the Entity SOCSOProgression

Card of Attribute SOCSO Policy of the Entity SOCSOProgression

Name

SOCSO Policy

Code

SOCSOProgPolicyId

Data Type

char(20)

Mandatory

No


Description of Attribute SOCSO Policy of the Entity SOCSOProgression

Shows the identity of the SOCSO Policy.


Entity Attribute SOCSO Scheme of the Entity SOCSOProgression

Card of Attribute SOCSO Scheme of the Entity SOCSOProgression

Name

SOCSO Scheme

Code

SOCSOProgSchemeId

Data Type

char(20)

Mandatory

No


Description of Attribute SOCSO Scheme of the Entity SOCSOProgression

Shows the identity of the SOCSO scheme.
Example: Pension / NonPension / Private etc


Entity Attribute SOCSOP1Payment of the Entity SOCSOProgression

Card of Attribute SOCSOP1Payment of the Entity SOCSOProgression

Name

SOCSOP1Payment

Code

SOCSOP1Payment

Data Type

smallint

Mandatory

No


Description of Attribute SOCSOP1Payment of the Entity SOCSOProgression

Shows the payment for the SOCSO progression.


Entity Attribute Remarks of the Entity SOCSOProgression

Card of Attribute Remarks of the Entity SOCSOProgression

Name

Remarks

Code

SOCSORemarks

Data Type

char(100)

Mandatory

No


Description of Attribute Remarks of the Entity SOCSOProgression

Stores any remarks about the SOCSO progression.


Entity Attribute Current of the Entity SOCSOProgression

Card of Attribute Current of the Entity SOCSOProgression

Name

Current

Code

SOCSOCurrent

Data Type

smallint

Mandatory

No


Description of Attribute Current of the Entity SOCSOProgression

Shows if the employee is currently employed in that company.