SBIR Policy Directive 2012
Appendix VIII--Annual Report Database [Updated 8/6/12]
Appendix VIII--Annual Report Database
----------------------------------------------------------------------------------------------------------------
Reporting Public
Annual report field name mechanism Collection frequency data Type
----------------------------------------------------------------------------------------------------------------
agency code.................... XML or manual Annually............... Y int(11).
upload to Tech-
Net.
Program........................ XML or manual Annually............... Y char(4).
upload to Tech-
Net.
Year........................... XML or manual Annually............... Y char(4).
upload to Tech-
Net.
reporting unit................. XML or manual Annually............... Y varchar(255).
upload to Tech-
Net.
submitted by................... XML or manual Annually............... Y varchar(100).
upload to Tech-
Net.
phone number................... XML or manual Annually............... Y varchar(255).
upload to Tech-
Net.
Agency Extramural Budget....... XML or manual Annually............... Y varchar(100).
upload to Tech-
Net.
Agency SBIR Budget............. XML or manual Annually............... Y varchar(100).
upload to Tech-
Net.
Number of Solicitations XML or manual Annually............... Y int(6).
Released. upload to Tech-
Net.
Number of Research Topics in XML or manual Annually............... Y.
Solicitations. upload to Tech-
Net.
Number of Phase I Proposals XML or manual Annually............... Y int(6).
Received. upload to Tech-
Net.
Total Phase I Awards........... XML or manual Annually............... Y int(6).
upload to Tech-
Net.
Number of Phase I Proposals XML or manual Annually............... Y int(6).
Received from HubZone upload to Tech-
Applicants. Net.
Number of Phase I Proposals XML or manual Annually............... Y int(6).
Received from Minority/ upload to Tech-
Disadvantaged. Net.
Number of Phase I Proposals XML or manual Annually............... Y int(6).
Received from Women Applicants. upload to Tech-
Net.
Total Phase I Dollars Awarded XML or manual Annually............... Y varchar(25).
($). upload to Tech-
Net.
Minority/Disadvantaged Phase I XML or manual Annually............... Y int(6).
Awards. upload to Tech-
Net.
Minority/Disadvantaged Phase I XML or manual Annually............... Y varchar(25).
Dollars Awarded ($). upload to Tech-
Net.
HUBZone Phase I Awards......... XML or manual Annually............... Y int(6).
upload to Tech-
Net.
HUBZone Phase I Dollars Awarded XML or manual Annually............... Y int(6).
($). upload to Tech-
Net.
phase1 hubzone dollars XML or manual Annually............... Y varchar(25).
obligated. upload to Tech-
Net.
phase1 manufacturing awards.... XML or manual Annually............... Y int(6).
upload to Tech-
Net.
phase1 manufacturing dollars XML or manual Annually............... Y varchar(25).
obligated. upload to Tech-
Net.
Number of Phase II Proposals XML or manual Annually............... Y int(6).
Received. upload to Tech-
Net.
[[Page 46854]]
Number of Phase II Proposals XML or manual Annually............... Y int(6).
Received from HubZone upload to Tech-
Applicants. Net.
Number of Phase II Proposals XML or manual Annually............... Y int(6).
Received from Minority/ upload to Tech-
Disadvantaged. Net.
Number of Phase II Proposals XML or manual Annually............... Y int(6).
Received from Women Applicants. upload to Tech-
Net.
Total Phase II Awards.......... XML or manual Annually............... Y int(6).
upload to Tech-
Net.
Total Phase II Dollars Awarded XML or manual Annually............... Y varchar(25).
($). upload to Tech-
Net.
Minority/Disadvantaged Phase II XML or manual Annually............... Y int(6).
Awards. upload to Tech-
Net.
Minority/Disadvantaged Phase II XML or manual Annually............... Y varchar(25).
Dollars Awarded ($). upload to Tech-
Net.
HUBZone Phase II Awards........ XML or manual Annually............... Y int(6).
upload to Tech-
Net.
HUBZone Phase II Dollars XML or manual Annually............... Y int(6).
Awarded ($). upload to Tech-
Net.
phase2 hubzone dollars XML or manual Annually............... Y varchar(25).
obligated. upload to Tech-
Net.
phase2 manufacturing awards.... XML or manual Annually............... Y int(6).
upload to Tech-
Net.
phase2 manufacturing dollars XML or manual Annually............... Y varchar(25).
obligated. upload to Tech-
Net.
new phase2 with dollars XML or manual Annually............... Y int(6).
obligated. upload to Tech-
Net.
new phase2 dollars obligated... XML or manual Annually............... Y varchar(25).
upload to Tech-
Net.
old phase2 with dollars XML or manual Annually............... Y int(6).
obligated. upload to Tech-
Net.
old phase2 dollars obligated... XML or manual Annually............... Y varchar(25).
upload to Tech-
Net.
number amount modified......... XML or manual Annually............... Y int(6).
upload to Tech-
Net.
amount modified................ XML or manual Annually............... Y varchar(25).
upload to Tech-
Net.
agency obligations............. XML or manual Annually............... Y varchar(50).
upload to Tech-
Net.
phase1 success rate............ XML or manual Annually............... Y varchar(3).
upload to Tech-
Net.
phase2 success rate............ XML or manual Annually............... Y varchar(3).
upload to Tech-
Net.
overall success rate........... XML or manual Annually............... Y varchar(3).
upload to Tech-
Net.
The percentage of new Phase I XML or manual Annually............... Y varchar(3).
awards where difference upload to Tech-
between Solicitation Close Net.
Date and Proposal Award Date
is less than 180 days
(Proposal Award Date--
Solicitation Close Date).
The average of the number of XML or manual Annually............... Y varchar(50).
days between Solicitation upload to Tech-
Close Date and Proposal Award Net.
Date for all the new Phase I
awards (Proposal Award Date--
Solicitation Close Date).
The average of the number of XML or manual Annually............... Y varchar(50).
days between the Contract End upload to Tech-
Date for the related Phase I Net.
award and the Proposal Award
Date for all the new Phase II
awards (P2 Proposal Award
Date--P1 Contract End Date).
The average number of days XML or manual Annually............... Y varchar(50).
between Proposal Selection upload to Tech-
Date and Proposal Award Date Net.
for all the new Phase II
awards (Proposal Award Date--
Proposal Selection Date).
The percentage of new Phase II XML or manual Annually............... Y varchar(3).
awards where the number of upload to Tech-
days between Proposal Net.
Selection Date and Proposal
Award Date was less than 60
(Proposal Award Date--Proposal
Selection Date).
sbcname changed................ XML or manual Annually............... Y text.
upload to Tech-
Net.
one proposal per solicitation.. XML or manual Annually............... Y text.
upload to Tech-
Net.
more than 15 awards............ XML or manual Annually............... Y text.
upload to Tech-
Net.
justification.................. XML or manual Annually............... Y text.
upload to Tech-
Net.
submitted...................... XML or manual Annually............... Y timestamp.
upload to Tech-
Net.
confirmed--by--uid............. XML or manual Annually............... Y int(10) unsigned.
upload to Tech-
Net.
XML or manual Annually............... Y .......................
upload to Tech-
Net.
================================
Annual Report calculations based on above fields
----------------------------------------------------------------------------------------------------------------
Dollars Obligated.............. XML or manual Annually............... Y .......................
upload to Tech-
Net.
Percent of SBIR to Extramural XML or manual Annually............... Y .......................
Budget. upload to Tech-
Net.
Deficit/Surplus................ XML or manual Annually............... Y .......................
upload to Tech-
Net.
Exceeding award size threshold XML or manual Annually............... Y .......................
of 150%. upload to Tech-
Net.
Award cross btwn SBIR and STTR XML or manual Annually............... Y .......................
programs. upload to Tech-
Net.
XML or manual Annually............... Y .......................
upload to Tech-
Net.
----------------------------------------------------------------------------------------------------------------
Additions to Annual Report
----------------------------------------------------------------------------------------------------------------
tracking compliance grievance.. XML or manual Annually............... Y .......................
upload to Tech-
Net.
grievance tracking for data XML or manual Annually............... Y .......................
rights. upload to Tech-
Net.
[[Page 46855]]
track deficit/surplus of XML or manual Annually............... Y .......................
budgets, esp. VC, etc. backed. upload to Tech-
Net.
Track data at component level.. XML or manual Annually............... Y .......................
upload to Tech-
Net.
----------------------------------------------------------------------------------------------------------------
|