Entity JobHistory

Description of Entity JobHistory

This entity stores the employee's job history outside the company.


List of all Dependencies of the Entity JobHistory

Name

Code

Class Name

Relation_370161

Relation_370161

Reference

Relation_373254

Relation_373254

Reference

Relation_401046

Relation_401046

Reference

Relation_423955

Relation_423955

Reference

Relation_464831

Relation_464831

Reference


List of Attributes of the Entity JobHistory

Name

Code

PersonalSysId

PersonalSysId

Start Date

EmployedDate

Cessation Date

CessationDate

Name

CompanyName

Job Title

JobTitle

Start Salary

StartSalary

End Salary

EndSalary

Salary Type

SalaryType

Reason for Leaving

ReasonLeaving

Is NS

IsNS


Entity Attribute PersonalSysId of the Entity JobHistory

Card of Attribute PersonalSysId of the Entity JobHistory

Name

PersonalSysId

Code

PersonalSysId

Data Type

integer

Mandatory

Yes


Description of Attribute PersonalSysId of the Entity JobHistory

This attribute is the system generated identifier. It is blind to the user. It also holds the primary key for the Personal table.


Entity Attribute Start Date of the Entity JobHistory

Card of Attribute Start Date of the Entity JobHistory

Name

Start Date

Code

EmployedDate

Data Type

date

Mandatory

Yes


Description of Attribute Start Date of the Entity JobHistory

Shows when the employee started work. This is also the primary key for the JobHistory table.
It is in the format: DD-MM-YYYY.


Entity Attribute Cessation Date of the Entity JobHistory

Card of Attribute Cessation Date of the Entity JobHistory

Name

Cessation Date

Code

CessationDate

Data Type

date

Mandatory

No


Description of Attribute Cessation Date of the Entity JobHistory

Shows the date the employee discontinues his service and leaves the company. This can be due to resignation, termination etc.
It is usually in the format: DD-MM-YYYY.


Entity Attribute Name of the Entity JobHistory

Card of Attribute Name of the Entity JobHistory

Name

Name

Code

CompanyName

Data Type

char(100)

Mandatory

No


Description of Attribute Name of the Entity JobHistory

Stores the name of the company.
Example: Sage Software Asia Pte. Ltd.


Entity Attribute Job Title of the Entity JobHistory

Card of Attribute Job Title of the Entity JobHistory

Name

Job Title

Code

JobTitle

Data Type

char(50)

Mandatory

No


Description of Attribute Job Title of the Entity JobHistory

Holds the job title of the employee.


Entity Attribute Start Salary of the Entity JobHistory

Card of Attribute Start Salary of the Entity JobHistory

Name

Start Salary

Code

StartSalary

Data Type

double

Mandatory

No


Description of Attribute Start Salary of the Entity JobHistory

Shows the start salary of the employee.


Entity Attribute End Salary of the Entity JobHistory

Card of Attribute End Salary of the Entity JobHistory

Name

End Salary

Code

EndSalary

Data Type

double

Mandatory

No


Description of Attribute End Salary of the Entity JobHistory

Shows the end salary of the employee.


Entity Attribute Salary Type of the Entity JobHistory

Card of Attribute Salary Type of the Entity JobHistory

Name

Salary Type

Code

SalaryType

Data Type

char(20)

Mandatory

No


Description of Attribute Salary Type of the Entity JobHistory

Shows the type of salary.
Example: Daily Rated / Hourly Rated / Monthly Rated


Entity Attribute Reason for Leaving of the Entity JobHistory

Card of Attribute Reason for Leaving of the Entity JobHistory

Name

Reason for Leaving

Code

ReasonLeaving

Data Type

char(100)

Mandatory

No


Description of Attribute Reason for Leaving of the Entity JobHistory

States the reason for leaving.


Entity Attribute Is NS of the Entity JobHistory

Card of Attribute Is NS of the Entity JobHistory

Name

Is NS

Code

IsNS

Data Type

smallint

Mandatory

No


Description of Attribute Is NS of the Entity JobHistory

Indicates if the employee is out for National Service (NS).


Previous
Home
Next