| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| issue_id | int8 | 19 | null |
|
|
System generated sequence number to uniquely identify an ISSUE |
|||||||||||||||||
| issu_type | varchar | 10 | null |
|
|
||||||||||||||||||
| legacy_issue_nbr | varchar | 10 | √ | null |
|
|
LEGACY ISSUE NBR is the characters used to identify an ISSUE in the legacy ATS application system, where NBR is an abbreviation for number. For example: 10011-1 or 20200 |
||||||||||||||||
| filed_by_pog_id | int8 | 19 | null |
|
|
PERSON ORGANIZATION ID is the system generated unique identifier for PERSON ORGANIZATION. |
|||||||||||||||||
| local_gov_pog_id | int8 | 19 | null |
|
|
PERSON ORGANIZATION ID is the system generated unique identifier for PERSON ORGANIZATION. |
|||||||||||||||||
| received_date | timestamp | 29,6 | null |
|
|
RECEIVED DATE is a time the ISSUE was received by the Commission. |
|||||||||||||||||
| description | varchar | 4000 | null |
|
|
DESCRIPTION isan attribute further extending the definition of the ISSUE. |
|||||||||||||||||
| inquiry_code | varchar | 10 | √ | null |
|
|
User supplied value to uniquely identify an ISSUE CODE |
||||||||||||||||
| complaint_code | varchar | 10 | √ | null |
|
|
User supplied value to uniquely identify an COMPLAINT CODE |
||||||||||||||||
| swo_issued_by | varchar | 50 | √ | null |
|
|
Description of who issued the stop work order |
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| oats_issues_pkey | Primary key | Asc | issue_id |
| oats_issu_cmpc_fk_i | Performance | Asc | complaint_code |
| oats_issu_inqc_fk_i | Performance | Asc | inquiry_code |
| oats_issu_pog_fk2_i | Performance | Asc | filed_by_pog_id |
| oats_issu_pog_fk_i | Performance | Asc | local_gov_pog_id |
| Constraint Name | Constraint |
|---|---|
| avcon_1238100890_swo_c_000 | ((swo_complied_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])) |
| avcon_1238100890_remed_000 | ((remediation_required_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])) |
| avcon_1238100890_recom_000 | ((recommend_land_remediation_ind)::text = ANY ((ARRAY['Y'::character varying, 'N'::character varying])::text[])) |
| oats_issu_chk | ((((issu_type)::text = 'CMP'::text) AND (inquiry_code IS NULL) AND (complaint_code IS NOT NULL)) OR (((issu_type)::text = 'INQ'::text) AND (inquiry_code IS NOT NULL) AND (complaint_code IS NULL) AND (swo_issued_by IS NULL) AND (swo_issued_by IS NULL) AND (swo_issued_date IS NULL) AND (swo_terms IS NULL) AND (swo_review_requested_date IS NULL) AND (swo_ceo_review_date IS NULL) AND (swo_ceo_review_description IS NULL) AND (swo_ceo_review_result IS NULL) AND (swo_complied_ind IS NULL) AND (recommend_fine_amt IS NULL) AND (recommend_land_remediation_ind IS NULL) AND (ceo_hearing_date IS NULL) AND (ceo_decision_date IS NULL) AND (fine_amt IS NULL) AND (fine_due_date IS NULL) AND (fine_received_date IS NULL) AND (remediation_required_ind IS NULL) AND (remediation_due_date IS NULL) AND (remediation_completion_date IS NULL))) |
| avcon_1238100890_issu__000 | ((issu_type)::text = ANY ((ARRAY['INQ'::character varying, 'CMP'::character varying])::text[])) |
