| Description |
Column |
Datatype |
| Lessee number
|
les_s |
char (9) |
| Record number
|
unique_l |
integer |
| Sybase timestamp
|
timestamp |
timestamp |
| Employer 1 reference status date
|
d_emp1_ref_stat_s |
datetime |
| Employer 2 reference status date
|
d_emp2_ref_stat_s |
datetime |
| Previous employer reference status date
|
d_pemp_ref_stat_s |
datetime |
| Employer 1 last modification date
|
d_emp1_lst_mod_s |
datetime |
| Employer 2 last modification date
|
d_emp2_lst_mod_s |
datetime |
| Previous employer last modification date
|
d_pemp_lst_mod_s |
datetime |
| Employer 1 reference status
|
emp1_ref_stat_s |
char (4) |
| Employer 2 reference status
|
emp2_ref_stat_s |
char (4) |
| Previous employer reference status
|
pemp_ref_stat_s |
char (4) |
| Employer 1 name
|
emp1_nam_s |
char (36) |
| Employer 1 contact
|
emp1_cont_s |
char (25) |
| Employer 1 contact title
|
emp1_cont_title_s |
char (25) |
| Employer 1 address
|
emp1_add_s |
char (36) |
| Employer 1 address 2
|
emp1_add2_s |
char (36) |
| Employer 1 city
|
emp1_cty_s |
char (25) |
| Employer 1 state
|
emp1_st_s |
char (2) |
| Employer 1 zip code
|
emp1_zip_s |
char (9) |
| Employer 1 phone
|
emp1_phn_s |
char (10) |
| Employer 1 position
|
emp1_position_s |
char (25) |
| Employer 1 last modification initials
|
emp1_lst_mod_init_s |
char (3) |
| Employer 2 name
|
emp2_nam_s |
char (36) |
| Employer 2 contact
|
emp2_cont_s |
char (25) |
| Employer 2 contact title
|
emp2_cont_title_s |
char (25) |
| Employer 2 address
|
emp2_add_s |
char (36) |
| Employer 2 address 2
|
emp2_add2_s |
char (36) |
| Employer 2 city
|
emp2_cty_s |
char (25) |
| Employer 2 state
|
emp2_st_s |
char (2) |
| Employer 2 zip code
|
emp2_zip_s |
char (9) |
| Employer 2 phone
|
emp2_phn_s |
char (10) |
| Employer 2 position
|
emp2_position_s |
char (25) |
| Employer 2 last modification initials
|
emp2_lst_mod_init_s |
char (3) |
| Previous employer name
|
pemp_nam_s |
char (36) |
| Previous employer contact
|
pemp_cont_s |
char (25) |
| Previous employer contact title
|
pemp_cont_title_s |
char (25) |
| Previous employer address
|
pemp_add_s |
char (36) |
| Previous employer address 2
|
pemp_add2_s |
char (36) |
| Previous employer city
|
pemp_cty_s |
char (25) |
| Previous employer state
|
pemp_st_s |
char (2) |
| Previous employer zip code
|
pemp_zip_s |
char (9) |
| Previous employer phone
|
pemp_phn_s |
char (10) |
| Previous employer position
|
pemp_position_s |
char (25) |
| Previous employer last modification initials
|
pemp_lst_mod_init_s |
char (3) |
| Employer 1 years employed
|
emp1_yrs_l |
integer |
| Employer 1 months employed
|
emp1_mon_l |
integer |
| Employer 2 years employed
|
emp2_yrs_l |
integer |
| Employer 2 months employed
|
emp2_mon_l |
integer |
| Previous employer years employed
|
pemp_yrs_l |
integer |
| Previous employer months employed
|
pemp_mon_l |
integer |
| Employer 1 monthly salary
|
emp1_salary_d |
double precision |
| Employer 2 monthly salary
|
emp2_salary_d |
double precision |