staff_payment_statement_lines


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
statement_id VARCHAR 36 null
staff_payment_statements.id fk_sps_line_statement C
source_type VARCHAR 20 null
encounter_id VARCHAR 36 √ null
claim_id VARCHAR 36 √ null
service_date DATE 10 √ null
client_id VARCHAR 36 √ null
case_id VARCHAR 36 √ null
payer_id VARCHAR 36 √ null
event_type_id VARCHAR 36 √ null
cpt_code_id VARCHAR 36 √ null
service_code VARCHAR 20 √ null
units DECIMAL 10,2 √ null
hours DECIMAL 10,2 √ null
user_rate_id VARCHAR 36 √ null
rate DECIMAL 10,2 √ null
rate_interval VARCHAR 20 √ null
amount DECIMAL 12,2 null
basis_description VARCHAR 255 √ null
manual_concept_id VARCHAR 36 √ null
authorization_ref VARCHAR 255 √ null
created_at DATETIME 19 null
updated_at DATETIME 19 √ null
created_by VARCHAR 255 √ null
updated_by VARCHAR 255 √ null
non_billed BIT 1 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_sps_line_client Performance Asc client_id
idx_sps_line_encounter Performance Asc encounter_id
idx_sps_line_statement Performance Asc statement_id

Relationships

Close relationships within degrees of separation