Table: payroll

Previous: payment_term Unanet Data Model Next: per_diem_mie_breakdown
Columns
  Column Name Data Type Default
Value		 References
Table		 Foreign Key
Name
1. PK person_key decimal(15)   person fk_payroll1
2.   marital_status char(1)      
3.   fed_exemptions decimal(5)      
4.   sui_tax_code varchar(10)      
5.   state_worked_in varchar(2)      
6.   immigration_status varchar(5)      
7.   rate_change_date datetime      
8.   hire_date datetime      
9.   rate_change decimal(10,2)      
10.   eeo_code varchar(20)      
11.   medical_plan varchar(50)      
Foreign Keys
Column References Foreign Key Name
Table Column
person_key person person_key fk_payroll1
Indices
Index Name Unique Column Name Asc Or Desc
pk_payroll true person_key Asc