Site View

Site View: Site

View name: rpt.site

Type: Record

Description: Site Core Information

Field	Data Type	Notes
site_id	integer
site_name	character varying(30)

Site View: Site Profile

View name: rpt.site_profile

Type: Profile

Description: Site Detail Information

Field	Data Type	Notes
site_id	integer
site_name	character varying(30)
parent_site_id	integer	References site_id in rpt.site
site_is_active	boolean
site_text_1	character varying(100)
site_text_2	character varying(100)
site_drop_down_1_id	integer
site_drop_down_1	character varying(100)
site_drop_down_2_id	integer
site_drop_down_2	character varying(100)
site_drop_down_3_id	integer
site_drop_down_3	character varying(100)
site_drop_down_4_id	integer
site_drop_down_4	character varying(100)
site_drop_down_5_id	integer
site_drop_down_5	character varying(100)
site_drop_down_6_id	integer
site_drop_down_6	character varying(100)
site_drop_down_7_id	integer
site_drop_down_7	character varying(100)
site_drop_down_8_id	integer
site_drop_down_8	character varying(100)
site_memo_1	text
site_memo_2	text

Views and Standard Views