Database – 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 |