SPARCRequest Wiki

Modified Rate Report Data Dictionary (SPARCRequest v3.12.1)

By Prathik Harikrishnan
2 min

No.

Column Name

Description

Database Name

Source

Type

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)

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 reset 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)

 

Sample Report

<style><!--table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";}@page { mso-header-data:""; mso-footer-data:""; margin:0.75in 0.25in 0.75in 0.25in; mso-header-margin:0.3in; mso-footer-margin:0.3in; mso-page-orientation:Landscape; }tr {mso-height-source:auto; mso-ruby-visibility:none;}col {mso-width-source:auto; mso-ruby-visibility:none;}br {mso-data-placement:same-cell;}ruby {ruby-align:left;}.style0 { mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:11pt; font-weight:400; font-style:normal; font-family:"Arial","serif"; border:none; mso-protection:locked visible; mso-style-name:Normal; mso-style-id:0;}.font0 { color:#000000; font-size:11pt; font-weight:400; font-style:normal; font-family:"Arial","serif"; }.font1 { color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; }td {mso-style-parent:style0; mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:11pt; font-weight:400; font-style:normal; font-family:"Arial","serif"; border:none; mso-protection:locked visible; mso-ignore:padding;}.style0 { text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; font-size:11pt; font-weight:400; font-style:normal; font-family:"Arial","serif"; mso-protection:locked visible; mso-style-name:"Normal"; }.style1 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style2 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style3 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style4 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style5 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style6 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style7 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style8 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style9 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style10 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style11 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style12 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style13 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.style14 { text-align:general; vertical-align:middle; white-space:nowrap; background:auto; mso-pattern:auto; color:#000000; font-size:10pt; font-weight:400; font-style:normal; font-family:"Arial","sans-serif"; mso-protection:locked visible; }.x15 { mso-style-parent:style0; mso-number-format:General; text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; font-size:11pt; font-weight:400; font-style:normal; font-family:"Arial","serif"; mso-protection:locked visible; }.x16 { mso-style-parent:style0; mso-number-format:"M\/d\/yyyy"; text-align:general; vertical-align:bottom; white-space:nowrap; background:auto; mso-pattern:auto; font-size:11pt; font-weight:400; font-style:normal; font-family:"Arial","serif"; mso-protection:locked visible; }.x17 { mso-style-parent:style0; mso-number-format:General; text-align:general; vertical-align:bottom; white-space:normal;word-wrap:break-word; background:auto; mso-pattern:auto; font-size:11pt; font-weight:400; font-style:normal; font-family:"Arial","serif"; mso-protection:locked visible; }--></style><div class="cells-worksheet" data-sheet-number="0" data-sheet-name="Data"><table border="0" cellpadding="0" cellspacing="0" style="border-collapse:collapse;table-layout:fixed;width:1215pt"> <colgroup> <col class="x17" style="mso-width-source:userset;background:none;width:272px"></col> <col class="x17" style="mso-width-source:userset;background:none;width:253px"></col> <col style="mso-width-source:userset;width:105px"></col> <col class="x17" style="mso-width-source:userset;background:none;width:359px"></col> <col style="mso-width-source:userset;width:132px"></col> <col style="mso-width-source:userset;width:141px"></col> <col style="mso-width-source:userset;width:156px"></col> <col style="mso-width-source:userset;width:203px"></col> </colgroup> <tbody> <tr style="mso-height-source:userset;height:14pt" id="r0"> <td class="x17" style="height:14pt;width:204pt">Report Generated:</td> <td class="x17" style="width:189.75pt">2023-08-07</td> <td style="width:78.75pt"></td> <td class="x17" style="width:269.25pt"></td> <td style="width:99pt"></td> <td style="width:105.75pt"></td> <td style="width:117pt"></td> <td style="width:152.25pt"></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r1"> <td class="x17" style="height:14pt"># of Records:</td> <td class="x17" style="text-align:right">18</td> <td></td> <td class="x17"></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r2"> <td class="x17" style="height:14pt"></td> <td class="x17"></td> <td></td> <td class="x17"></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r3"> <td class="x17" style="height:14pt">Report Parameters</td> <td class="x17"></td> <td></td> <td class="x17"></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r4"> <td class="x17" style="height:14pt">Type:</td> <td class="x17">Modified Rate</td> <td></td> <td class="x17"></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr style="mso-height-source:userset;height:28pt" id="r5"> <td class="x17" style="height:28pt">Admin Rate Changes Date Of Change From:</td> <td class="x17">07/01/2023</td> <td></td> <td class="x17"></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr style="mso-height-source:userset;height:28pt" id="r6"> <td class="x17" style="height:28pt">Admin Rate Changes Date Of Change To:</td> <td class="x17">08/07/2023</td> <td></td> <td class="x17"></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r7"> <td class="x17" style="height:14pt"></td> <td class="x17"></td> <td></td> <td class="x17"></td> <td></td> <td></td> <td></td> <td></td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r8"> <td class="x17" style="height:14pt"><a name="_FilterDatabase"><span style="font-size:11pt;color:#000000;font-weight:400;text-decoration:none;text-line-through:none;font-family:&quot;Arial&quot;">SRID</span></a></td> <td class="x17">Request Organization</td> <td>Status</td> <td class="x17">Service Name</td> <td>Service Rate</td> <td>Modified Rate</td> <td>Modified Rate Date</td> <td>By</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r9"> <td class="x17" style="height:14pt">23403-0001</td> <td class="x17">Research Nexus</td> <td>Submitted</td> <td class="x17">Assay - Adiponectin</td> <td style="text-align:right">1000</td> <td style="text-align:right">1200</td> <td class="x16" style="text-align:right">7/18/2023</td> <td>Brigette White</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r10"> <td class="x17" style="height:14pt">23403-0001</td> <td class="x17">Research Nexus</td> <td>Submitted</td> <td class="x17">Assay - Adiponectin</td> <td style="text-align:right">1000</td> <td>COST RESET</td> <td class="x16" style="text-align:right">7/18/2023</td> <td>Brigette White</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r11"> <td class="x17" style="height:14pt">23403-0001</td> <td class="x17">Research Nexus</td> <td>Submitted</td> <td class="x17">Assay - Adiponectin</td> <td style="text-align:right">1000</td> <td style="text-align:right">200</td> <td class="x16" style="text-align:right">7/18/2023</td> <td>Brigette White</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r12"> <td class="x17" style="height:14pt">23403-0001</td> <td class="x17">Research Nexus</td> <td>Submitted</td> <td class="x17">Assay - Adiponectin</td> <td style="text-align:right">1000</td> <td>COST RESET</td> <td class="x16" style="text-align:right">7/18/2023</td> <td>Brigette White</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r13"> <td class="x17" style="height:14pt">23403-0001</td> <td class="x17">Research Nexus</td> <td>Submitted</td> <td class="x17">Assay - Adiponectin</td> <td style="text-align:right">1000</td> <td style="text-align:right">500</td> <td class="x16" style="text-align:right">7/18/2023</td> <td>Brigette White</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r14"> <td class="x17" style="height:14pt">23403-0001</td> <td class="x17">Research Nexus</td> <td>Submitted</td> <td class="x17">Assay - Adiponectin</td> <td style="text-align:right">1000</td> <td>COST RESET</td> <td class="x16" style="text-align:right">7/18/2023</td> <td>Brigette White</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r15"> <td class="x17" style="height:14pt">23403-0001</td> <td class="x17">Research Nexus</td> <td>Submitted</td> <td class="x17">Assay - Adiponectin</td> <td style="text-align:right">1000</td> <td style="text-align:right">500</td> <td class="x16" style="text-align:right">7/18/2023</td> <td>Brigette White</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r16"> <td class="x17" style="height:14pt">23403-0001</td> <td class="x17">Research Nexus</td> <td>Submitted</td> <td class="x17">DNA/RNA Isolation (Dual): FFPE Tissue QIAcube</td> <td style="text-align:right">20</td> <td style="text-align:right">100</td> <td class="x16" style="text-align:right">7/18/2023</td> <td>Brigette White</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r17"> <td class="x17" style="height:14pt">23403-0001</td> <td class="x17">Research Nexus</td> <td>Submitted</td> <td class="x17">DNA/RNA Isolation (Dual): FFPE Tissue QIAcube</td> <td style="text-align:right">20</td> <td>COST RESET</td> <td class="x16" style="text-align:right">7/18/2023</td> <td>Brigette White</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r18"> <td class="x17" style="height:14pt">23403-0001</td> <td class="x17">Research Nexus</td> <td>Submitted</td> <td class="x17">DNA/RNA Isolation (Dual): FFPE Tissue QIAcube</td> <td style="text-align:right">20</td> <td style="text-align:right">3</td> <td class="x16" style="text-align:right">7/18/2023</td> <td>Brigette White</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r19"> <td class="x17" style="height:14pt">23403-0001</td> <td class="x17">Research Nexus</td> <td>Submitted</td> <td class="x17">DNA/RNA Isolation (Dual): FFPE Tissue QIAcube</td> <td style="text-align:right">20</td> <td>COST RESET</td> <td class="x16" style="text-align:right">7/18/2023</td> <td>Brigette White</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r20"> <td class="x17" style="height:14pt">23403-0001</td> <td class="x17">Research Nexus</td> <td>Submitted</td> <td class="x17">DNA/RNA Isolation (Dual): FFPE Tissue QIAcube</td> <td style="text-align:right">20</td> <td style="text-align:right">5</td> <td class="x16" style="text-align:right">7/18/2023</td> <td>Brigette White</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r21"> <td class="x17" style="height:14pt">23403-0001</td> <td class="x17">Research Nexus</td> <td>Submitted</td> <td class="x17">DNA/RNA Isolation (Dual): FFPE Tissue QIAcube</td> <td style="text-align:right">20</td> <td>COST RESET</td> <td class="x16" style="text-align:right">7/18/2023</td> <td>Brigette White</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r22"> <td class="x17" style="height:14pt">23403-0001</td> <td class="x17">Research Nexus</td> <td>Submitted</td> <td class="x17">DNA/RNA Isolation (Dual): FFPE Tissue QIAcube</td> <td style="text-align:right">20</td> <td style="text-align:right">100</td> <td class="x16" style="text-align:right">7/18/2023</td> <td>Brigette White</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r23"> <td class="x17" style="height:14pt">23401-0009</td> <td class="x17">Research Nexus</td> <td>Submitted</td> <td class="x17">Nursing Time- Protocol Level</td> <td style="text-align:right">100</td> <td style="text-align:right">5</td> <td class="x16" style="text-align:right">7/14/2023</td> <td>Brigette White</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r24"> <td class="x17" style="height:14pt">23401-0009</td> <td class="x17">Research Nexus</td> <td>Submitted</td> <td class="x17">Nursing Time- Protocol Level</td> <td style="text-align:right">100</td> <td>COST RESET</td> <td class="x16" style="text-align:right">7/14/2023</td> <td>Brigette White</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r25"> <td class="x17" style="height:14pt">23401-0009</td> <td class="x17">Research Nexus</td> <td>Submitted</td> <td class="x17">Nursing Time- Protocol Level</td> <td style="text-align:right">100</td> <td style="text-align:right">5</td> <td class="x16" style="text-align:right">7/14/2023</td> <td>Brigette White</td> </tr> <tr style="mso-height-source:userset;height:14pt" id="r26"> <td class="x17" style="height:14pt">23401-0009</td> <td class="x17">Research Nexus</td> <td>Submitted</td> <td class="x17">Nursing Time- Protocol Level</td> <td style="text-align:right">100</td> <td>COST RESET</td> <td class="x16" style="text-align:right">7/14/2023</td> <td>Brigette White</td> </tr> <tr style="display:none"> <td style="width:204pt"></td> <td style="width:189.75pt"></td> <td style="width:78.75pt"></td> <td style="width:269.25pt"></td> <td style="width:99pt"></td> <td style="width:105.75pt"></td> <td style="width:117pt"></td> <td style="width:152.25pt"></td> </tr> </tbody></table></div>

 

Related content

Copyright © 2011-2020 MUSC Foundation for Research Development