Entity EmployPassProgression

Description of Entity EmployPassProgression

This shows the progression for the employee's employment pass. When the pass was sent in for application, when does it expiry, the issue date etc.


List of all Dependencies of the Entity EmployPassProgression

Name

Code

Class Name

Relation_79331

Relation_79331

Reference


List of Attributes of the Entity EmployPassProgression

Name

Code

EmployeeSysId

EmployeeSysId

Effective Date

EPEffectiveDate

Career Code

EPCareerId

Expiry Date

EPExpiryDate

Application Date

EPApplicationDate

Arrival Date

EPArrivalDate

Cancellation Date

EPCancellationDate

Issue Date

EPIssueDate

FIN No

EPFIN

Remarks

EPRemarks

Current

EPCurrent


Entity Attribute EmployeeSysId of the Entity EmployPassProgression

Card of Attribute EmployeeSysId of the Entity EmployPassProgression

Name

EmployeeSysId

Code

EmployeeSysId

Data Type

integer

Mandatory

Yes


Description of Attribute EmployeeSysId of the Entity EmployPassProgression

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 EmployPassProgression

Card of Attribute Effective Date of the Entity EmployPassProgression

Name

Effective Date

Code

EPEffectiveDate

Data Type

date

Mandatory

Yes


Description of Attribute Effective Date of the Entity EmployPassProgression

The effective date of the employment pass, i.e. when the pass was valid. It also acts as a primary key for the EmployPassProgression table.
It is usually in the format: DD-MM-YYYY.


Entity Attribute Career Code of the Entity EmployPassProgression

Card of Attribute Career Code of the Entity EmployPassProgression

Name

Career Code

Code

EPCareerId

Data Type

char(20)

Mandatory

No


Description of Attribute Career Code of the Entity EmployPassProgression

Shows the identity of the career for the employment pass holder.
Example: FirstRecord / Transfer / Promotion / SalaryAdjust etc


Entity Attribute Expiry Date of the Entity EmployPassProgression

Card of Attribute Expiry Date of the Entity EmployPassProgression

Name

Expiry Date

Code

EPExpiryDate

Data Type

date

Mandatory

No


Description of Attribute Expiry Date of the Entity EmployPassProgression

States the expiry date of the employment pass.
It is usually in the format: DD-MM-YYYY.


Entity Attribute Application Date of the Entity EmployPassProgression

Card of Attribute Application Date of the Entity EmployPassProgression

Name

Application Date

Code

EPApplicationDate

Data Type

date

Mandatory

No


Description of Attribute Application Date of the Entity EmployPassProgression

Shows the application date of the employment pass.
It is usually in the format: DD-MM-YYYY.


Entity Attribute Arrival Date of the Entity EmployPassProgression

Card of Attribute Arrival Date of the Entity EmployPassProgression

Name

Arrival Date

Code

EPArrivalDate

Data Type

date

Mandatory

No


Description of Attribute Arrival Date of the Entity EmployPassProgression

Shows the arrival date of the employment pass holder, i.e. the date the employee arrived in the country.
It is usually in the format: DD-MM-YYYY.


Entity Attribute Cancellation Date of the Entity EmployPassProgression

Card of Attribute Cancellation Date of the Entity EmployPassProgression

Name

Cancellation Date

Code

EPCancellationDate

Data Type

date

Mandatory

No


Description of Attribute Cancellation Date of the Entity EmployPassProgression

States the cancellation date of the employment pass.
It is usually in the format: DD-MM-YYYY.


Entity Attribute Issue Date of the Entity EmployPassProgression

Card of Attribute Issue Date of the Entity EmployPassProgression

Name

Issue Date

Code

EPIssueDate

Data Type

date

Mandatory

No


Description of Attribute Issue Date of the Entity EmployPassProgression

States the issue date of the employment pass.
It is usually in the format: DD-MM-YYYY.


Entity Attribute FIN No of the Entity EmployPassProgression

Card of Attribute FIN No of the Entity EmployPassProgression

Name

FIN No

Code

EPFIN

Data Type

char(20)

Mandatory

No


Description of Attribute FIN No of the Entity EmployPassProgression

Shows the Foreign Identification Number of the employee's employment pass.


Entity Attribute Remarks of the Entity EmployPassProgression

Card of Attribute Remarks of the Entity EmployPassProgression

Name

Remarks

Code

EPRemarks

Data Type

char(255)

Mandatory

No


Description of Attribute Remarks of the Entity EmployPassProgression

Stores remarks about the employee's employment pass.


Entity Attribute Current of the Entity EmployPassProgression

Card of Attribute Current of the Entity EmployPassProgression

Name

Current

Code

EPCurrent

Data Type

smallint

Mandatory

No


Description of Attribute Current of the Entity EmployPassProgression

Indicates if the employee is currently employed in the company.