Modified Rate Report Data Dictionary (SPARCRequest v3.11.0)

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)

or

display ‘COST RESET’ if the overridden price was reset to the current pricing.

(admin_rates.admin_cost)/100

or

(admin_rate_changes.cost_reset)

SPARCDashboard Admin Edit, Modified Rate

OR

SPARCDashboard Admin Edit, Modified Rate, Reset rate action

INT(11)

or

INT(1)

7

Modified Rate Date

The service provider overwritten price time stamp.

or

The rate is reset to current pricing map time stamp.

admin_rates.created_at

or

admin_rate_changes.created_at

Automatically generated by SPARC application when modified rate is added or reset to current pricing.

DATETIME

8

By

Service provider who modified the service rate or rest the rate to the current pricing map.

admin_rates.identity_id (identities.first_name identities.last_name)

or

admin_rate_changes.identity_id (identities.first_name identities.last_name)

Pulled from LDAP for the logged-in user

INT (11)