Based on v3.9.0
No. | Column Name | Description | Database Name | Source | Type |
|---|---|---|---|---|---|
1 | SRID | System generated protocol ID and request ID from SPARCRequest | protocols.id - sub_service_requests.ssr_id | Automatically generated by SPARC application. | BIGINT(20) |
2 | Request Organization | The service provider | sub_service_requests.organization_id (organizations.name) | Set up in SPARCCatalog as split/notify | VARCHAR(255) |
3 | Status | Communication indicator which displays progress, determined by service provider workflow | sub_service_requests.status | SPARCDashboard Admin Edit page Status dropdown menu | VARCHAR(255) |
4 | Service Name | The name of the procedure or study level activity | line_items.service_id (services.name) | SPARCCatalog | VARCHAR(255) |
5 | Service Rate | The fee associated to the procedure or study level activity, logic-driven by funding source. | (pricing_maps.federal_rate)/100 or (pricing_maps.corporate_rate)/100 or (pricing_maps.member_rate)/100 or (pricing_maps.other_rate)/100 | SPARCCatalog Pricing section on the service form | DECIMAL |
6 | Modified Rate | The service provider determined cost (override pricing) | (admin_rates.admin_cost)/100 | SPARCDashboard Admin Edit, Modified Rate | INT(11) |
7 | Modified Rate Date | The service provider overwritten price time stamp. | admin_rates.created_at | Automatically generated by SPARC application when modified rate is added. | DATETIME |
8 | By | Service provider who modified the service rate | admin_rates.identity_id (identities.first_name identities.last_name) | Pulled from LDAP for the logged-in user | VARCHAR (255) |