EmploymentStatus Table

EmploymentStatus is a static table listing possible employment statuses values for end-users.

Table 1. Database columns for EmploymentStatus table

Database Column

Details
EmploymentStatusID

Type: integer. Key. Generated ID

A unique identifier for each EmploymentStatus. Possible values and the corresponding default strings are:

  • 1 = Employee
  • 2 = Consultant
  • 3 = Temporary
  • 4 = Part time
  • 5 = Casual.
ResourceName

Type: text (max 256 characters). Key

The unique name of the localizable resource string representing an employment status. Foreign key to the ComplianceResourceString table.
DefaultValue

Type: text (max 100 characters)

The text to display if the employment status resource string has no translation.