customer_employer_entity - Customer Employer Entity

This holds employer information for customers, as well as payroll information.

Column

Data Type

Column Info

Value Notes

Other

id

int(11)

The id of the entity

company_name

varchar(255)

Company name for company/flooring customer

title

varchar(255)

The name/title of the entity instance

phone

char(20)

Phone number

income

decimal(10,2)

Customer income

income_frequency

char(100)

Frequency code of customer income

customerEmployer.incomeFrequency.*

hire_date

date

Date customer was hired

pay_date

date

Date of next paycheck for the customer

pay_date_frequency

char(100)

Frequency code for customer's paycheck

customerEmployer.payDateFrequency.*

address_id

int(11)

ID of associated address

created

timestamp

Timestamp of when the entity was created

lastUpdated

timestamp

Timestamp of when the entity was last updated

active

tinyint(4)

Whether or not the entity is active

1 - yes, 0 - no

deleted

tinyint(4)

Whether or not the entity was deleted

1 - yes, 0 - no


How did we do?


Powered by HelpDocs (opens in a new tab)