Database – Customer Employer Entity (customer_employer_entity)
Description
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 |