Informal Views

Informal Series View: Informal Series

View name: rpt.informal_series

Type: Record

Description: Informal Series Core Information

Field	Data Type	Notes
informal_series_id	integer
informal_series_name	character varying(50)
service_id	integer	References service_id in rpt.service

Informal Series View: Informal Series Profile

View name: rpt.informal_series_profile

Type: Profile

Description: Informal Series Detail Information

Field	Data Type	Notes
informal_series_id	integer	References informal_series_id in rpt.informal_series
informal_series_name	character varying(50)
service_id	integer	References service_id in rpt.service
informal_series_start_date	date
informal_series_end_date	date
informal_series_status_id	integer
informal_series_status	character varying(30)
informal_series_is_secure	boolean

Informal Series View: Informal Series Workers

View name: rpt.informal_series_workers

Type: Cross Reference

Description: Informal Series Workers

Field	Data Type	Notes
informal_series_id	integer	References informal_series_id in rpt.informal_series
worker_id	integer	References worker_id in rpt.worker
informal_series_worker_is_primary	boolean
informal_series_worker_is_attending	boolean

Informal Series View: Informal Series Rostered Individuals

View name: rpt.informal_series_rostered_individuals

Type: Cross Reference

Description: Informal Series Rostered Individuals

Field	Data Type	Notes
informal_series_id	integer	References informal_series_id in rpt.informal_series
individual_id	integer	References individual_id in rpt.individual

Informal Series View: Informal Series Documents

View name: rpt.informal_series_documents

Type: Cross Reference

Description: Informal Series Documents

Field	Data Type	Notes
informal_series_id	integer	References informal_series_id in rpt.informal_series
document_id	integer	References document_id in rpt.document

Informal Series View: Informal Series Referrals

View name: rpt.informal_series_referrals

Type: Cross Reference

Description: Informal Series Referrals

Field	Data Type	Notes
informal_series_id	integer	References informal_series_id in rpt.informal_series
referral_id	integer	References referral_id in rpt.referral

Views and Standard Views