rale Table: Lessee/Co-Lessee Employment

Database Reference

rale Table: Lessee/Co-Lessee Employment

Parent Table

Name	Description
ral	Lessee/Co-Lessee

Indexes

Name	Segment 1	Segment 2
rale_idx0	les_s	unique_l

Columns
Name	Description	Datatype ¿?	Allow Null
les_s	Lessee number
unique_l	Record number (value is always 1)
	Record modification stamp
d_emp1_ref_stat_s	Employer 1 reference status date
d_emp2_ref_stat_s	Employer 2 reference status date
d_pemp_ref_stat_s	Previous employer reference status date
d_emp1_lst_mod_s	Employer 1 last modification date
d_emp2_lst_mod_s	Employer 2 last modification date
d_pemp_lst_mod_s	Previous employer last modification date
emp1_ref_stat_s	Employer 1 reference status
emp2_ref_stat_s	Employer 2 reference status
pemp_ref_stat_s	Previous employer reference status
emp1_nam_s	Employer 1 name
emp1_cont_s	Employer 1 contact
emp1_cont_title_s	Employer 1 contact title
emp1_add_s	Employer 1 address
emp1_add2_s	Employer 1 address 2
emp1_cty_s	Employer 1 city
emp1_st_s	Employer 1 state
emp1_zip_s	Employer 1 zip code
emp1_phn_s	Employer 1 phone
emp1_position_s	Employer 1 position
emp1_lst_mod_init_s	Employer 1 last modification initials
emp2_nam_s	Employer 2 name
emp2_cont_s	Employer 2 contact
emp2_cont_title_s	Employer 2 contact title
emp2_add_s	Employer 2 address
emp2_add2_s	Employer 2 address 2
emp2_cty_s	Employer 2 city
emp2_st_s	Employer 2 state
emp2_zip_s	Employer 2 zip code
emp2_phn_s	Employer 2 phone
emp2_position_s	Employer 2 position
emp2_lst_mod_init_s	Employer 2 last modification initials
pemp_nam_s	Previous employer name
pemp_cont_s	Previous employer contact
pemp_cont_title_s	Previous employer contact title
pemp_add_s	Previous employer address
pemp_add2_s	Previous employer address 2
pemp_cty_s	Previous employer city
pemp_st_s	Previous employer state
pemp_zip_s	Previous employer zip code
pemp_phn_s	Previous employer phone
pemp_position_s	Previous employer position
pemp_lst_mod_init_s	Previous employer last modification initials
emp1_yrs_l	Employer 1 years employed
emp1_mon_l	Employer 1 months employed
emp2_yrs_l	Employer 2 years employed
emp2_mon_l	Employer 2 months employed
pemp_yrs_l	Previous employer years employed
pemp_mon_l	Previous employer months employed
emp1_salary_d	Employer 1 monthly salary
emp2_salary_d	Employer 2 monthly salary