Readme
Updated 12 hours ago
‧ Indexed 4 hours ago
Payments Received for DCA Fines and Fees
Payments received from businesses for DCA fines and fees such as violations and license application fees.
Columns
| Name | Socrata field name | Column name in sgr mount | Data type | Description |
|---|---|---|---|---|
| PAYMENT DATE | payment_date | payment_date | Text | Date when the payment was applied to the record. |
| RECORD ID | record_id | record_id | Text | An identification number assigned by DCA for internal tracking purposes |
| TRANSACTION TYPE | transaction_type | transaction_type | Text | The type of transaction indicating whether payment was received, refunded, or voided. |
| BUSINESS NAME | business_name | business_name | Text | Primary business or Individual name. |
| FEE TYPE | fee_type | fee_type | Text | The code associated with the DCA fine or fee. |
| PAYMENT AMOUNT | payment_amount | payment_amount | Number | Dollar amount of the payment received. |
| INDUSTRY | industry | industry | Text | The category that describes the business. |
| FEE DESCRIPTION | fee_description | fee_description | Text | The description associated with the DCA fine or fee. |
| RECORD DYPE | record_dype | record_dype | Text | The type of record used by DCA to track internal operations. |
| FEE SEQUENCE ID | fee_sequence_id | fee_sequence_id | Number | The unique system-generated identification number for the DCA fine or fee. |
| BUSINESS NAME2 | business_name2 | business_name2 | Text | If applicable, the Doing-Business-As (DBA), or trade name. |
Upstream Metadata