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.
----------------------------------------------------------------------------------------------------------------

Return    Next