staff_payment_statements


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
manual_payment_concepts.statement_id fk_manual_concept_statement C
staff_payment_statement_lines.statement_id fk_sps_line_statement C
staff_payment_statement_payments.statement_id fk_sps_payment_statement C
staff_payment_statement_status_history.statement_id fk_sps_history_statement C
reference VARCHAR 40 null
provider_user_id VARCHAR 36 null
provider_company_id VARCHAR 36 √ null
location_business_line_id VARCHAR 36 null
period_start DATE 10 null
period_end DATE 10 null
issue_date DATE 10 √ null
source VARCHAR 20 null
aggregation_strategy VARCHAR 20 √ null
status VARCHAR 20 GENERATED
hold_reason VARCHAR 255 √ null
total_days INT 10 √ null
total_hours DECIMAL 10,2 √ null
total_units DECIMAL 10,2 √ null
total_amount DECIMAL 12,2 0.00
DECIMAL 12,2 0.00
notes TEXT 65535 √ null
created_at DATETIME 19 null
updated_at DATETIME 19 √ null
created_by VARCHAR 255 √ null
updated_by VARCHAR 255 √ null
business_timezone VARCHAR 64 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_sps_location_period Performance Asc/Asc/Asc location_business_line_id + period_start + period_end
idx_sps_location_provider Performance Asc/Asc location_business_line_id + provider_user_id
idx_sps_status Performance Asc status
uq_sps_reference Must be unique Asc/Asc location_business_line_id + reference

Relationships

Close relationships within degrees of separation