Table: per_diem_rate

Previous: per_diem_mie_breakdown

Unanet Data Model

Next: person

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	per_diem_rate_key	decimal(15)
2.		country_state_name	varchar(45)
3.		city_county_name	varchar(45)
4.		effective_date	datetime
5.		expiration_date	datetime
6.		season_start_date	datetime
7.		season_end_date	datetime
8.		lodging_rate	decimal(15,3)
9.		meals_rate	decimal(15,3)
10.		incidentals_rate	decimal(15,3)
11.		enabled	char(1)	('Y')
12.		oconus_indicator	char(1)	('N')

Check Constraints

Name	Definition
cc_pdr_effective_date	([effective_date]>='1900-01-01' AND [effective_date]<='2099-12-31')
cc_pdr_expiration_date	([expiration_date]>='1900-01-01' AND [expiration_date]<='2099-12-31')
cc_pdr_oconus_indicator	([oconus_indicator]='N' OR [oconus_indicator]='Y')
cc_pdr_season_end_date	([season_end_date]>='1900-01-01' AND [season_end_date]<='2099-12-31')
cc_pdr_season_start_date	([season_start_date]>='1900-01-01' AND [season_start_date]<='2099-12-31')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_per_diem_rate	true	per_diem_rate_key	Asc
idx_per_diem_rate1	false	country_state_name	Asc
		city_county_name