rale Table: Lessee/Co-Lessee Employment

Database Reference Sybase DBMS

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