Table: lodging_per_diem_detail

Previous: lodging_detail

Unanet Data Model

Next: manager_approval_status

Columns

		Column Name	Data Type	Default Value	References Table	Foreign Key Name
1.	PK	expense_data_key	decimal(15)		expense_data	fk_lodging_per_diem_detail1
2.		country_state_name	varchar(45)
3.		city_county_name	varchar(45)
4.		rate	decimal(15,3)	((0.000))
5.		prorated_rate	decimal(15,3)	((0.000))
6.		special_situation	char(1)	('N')
7.		nights_charged	int	((1))
8.		daily_room_rate	decimal(15,3)	((0.000))
9.		daily_room_tax	decimal(15,3)	((0.000))

Foreign Keys

Column	References		Foreign Key Name
	Table	Column
expense_data_key	expense_data	expense_data_key	fk_lodging_per_diem_detail1

Check Constraints

Name	Definition
cc_lpdd_special_situation	([special_situation]='N' OR [special_situation]='Y')

Indices

Index Name	Unique	Column Name	Asc Or Desc
pk_lodging_per_diem_detail	true	expense_data_key	Asc