decision

-1 rows


Description

As a CEEB Compliance Coordinator or Officer, I need to be able to capture decision information to ensure that all information necessary in the decision making process can be captured in the complaint.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
decision_guid uuid 2147483647 case_management.uuid_generate_v4()
action.decision_guid fk_action__decision_guid R

Unique identifier for the decision
case_file_guid uuid 2147483647 null
case_file.case_file_guid fk_decision__case_file_guid R

Assoiciates the decision record to an existing case file
schedule_sector_xref_guid uuid 2147483647 null
schedule_sector_xref.schedule_sector_xref_guid fk_decision__schedule_sector_xref_guid R

Defines the combination of a WDR_SCHEDULE_CODE and a SECTOR_CATEGORY_CODE
discharge_code varchar 10 null
discharge_code.discharge_code fk_decision__discharge_code R

The discharge code related to a decision
rationale_text varchar 4000 √ null

The rationale code related to a CEEB decision
inspection_number int4 10 √ null

The NRIS inspection number for a CEEB decision
lead_agency_code varchar 10 √ null
agency_code.agency_code fk_decision__lead_agency_code R
non_compliance_decision_matrix_code varchar 10 √ null
non_compliance_decision_matrix_code.non_compliance_decision_matrix_code fk_decision__ncdm_code R
active_ind bool 1 null

A boolean indicator to determine if the case management action is active.
create_user_id varchar 32 null

The id of the user that created the case management action.
create_utc_timestamp timestamp 29,6 null

The timestamp when the case management action was created. The timestamp is stored in UTC with no Offset.
update_user_id varchar 32 null

The id of the user that updated the case management action.
update_utc_timestamp timestamp 29,6 null

The timestamp when the case management action was updated. The timestamp is stored in UTC with no Offset.

Indexes

Constraint Name Type Sort Column(s)
PK_decision_guid Primary key Asc decision_guid

Relationships

Close relationships within degrees of separation