Edata – occwebapp 2.1.0

The Office of Cancer Centers (OCC) of the National Cancer Institute (NCI) is responsible for overseeing a portfolio of Cancer Center Support Grants (CCSG) that support cancer research at NCI-designated Cancer Centers across the U.S. Learn ms sql server The Centers program was established by the 1971 National Cancer Act and serves as a major platform for advancing NCI initiatives.

The CCSG Data Tables itemize the Center’s formal Research Programs, Shared Resources, base of funded research projects, patient information, clin¬ical research protocols, and current and requested budgets. Sql server uses The primary reason for standardized Data Tables is to ensure consistency and thoroughness during the peer review of competing applications. Sql server 20 Additionally, the Data Tables are used to assess center progress, generate reports, and produce benchmark data on the Centers program.


Each year, 60 days prior to the award anniversary date, the Centers are required to send an electronic copy of the Data Tables (1-4) in Excel format directly to the OCC. Sql server user group Per NIH policy, T2 applications serve as the progress report for the fiscal year in which the application is newly funded. T sql sql server Although no separate RPPR need be submitted 60 days prior to the start date of the newly funded award, eData 1-4 must still be submitted at that time.

The data submitted by all NCI-designated Cancer Centers are verified for consistency and imported into the OCC SQL-Server database. Sql server definition In addition, the aggregate Data Tables, detailed data and reports are presented on the OCC website, and the OCC intranet OCCiNet.gov respectively. Or en sql server The figure 1-1 shows the overview of the input and output (I/O) of the Data tables:

The purpose of the CCSG Electronic Data Guide, herein referred to as eData Guide, is to present a description and standard format for the submission of electronic data. Go sql server This format will allow Centers’ data to be processed and shared in a uniform and consistent matter. Who manufactures sql server The eData Guide seeks to accomplish the following:

This eData Guide is meant as a specific guide for the eData submission, and describes each of the data table’s field columns at a granular level with significant technical detail. Sql server stored procedure It identifies each data column, definition, type and its usage; it also includes example(s) for each of the data tables. Sql server 2008 express The CCSG Data Guide should be consulted in order to derive background information regarding the purpose of each Data Table and to prepare the Data Tables that accompany Type 1 and Type 2 competitive applications.

As a step toward improving web interactivity, the existing OCC website has been redesigned to a more dynamic or database-driven website. As sql server The centralized database that supports this enhanced website application is where all the tables, views, stored procedures, user defined functions, and triggers are created.

Tables are commonly referred to as entities in the database. Database sql server 2008 Data columns (fields) are commonly referred to as attributes for a particular table. When in sql server In OCC the underscore character will not be used in a table name or column name. Ms sql server download Furthermore, all tables in the OCC databases will begin with an uppercase letter followed by a series of upper and lowercase letters. Sql server 2008 r2 express edition Meaningful table names have been chosen to identify the overall purpose of the database tables (e.g., P30Partner).

Note the distinction between a blank space and a NULL value. Sql server and or A blank space is a character string while a NULL is an unknown value. Sql server 2008 wiki If the data is not available or applicable, use NULL by leaving the column empty.

Fixed-length, non-Unicode string data. Sql server release history n defines the string length and must be a value from 1 through 8,000. Sql 2012 server It is used for data that are a mixture of numbers and letters (alphanumeric data).

The fiscal year for which the Data Tables are being submitted; it can be from October 1 of the prior year through September 30 of the year being funded. Sql server trigger (e.g., 2014)

For research program with multiple leaders, please add seven additional fields per additional leader, for instance, LastNameN, FirstNameN, MiddleNameN, DegreeN1, DegreeN2, DegreeN3, isNewN. Sql server security N is a numeric value that is great than 1.

The annual period for which the Data Tables are being submitted; it can be from October 1 of the prior year through September 30 of the year being described. Sql 2000 server (e.g., 2014)

Note that Research Programs are peer-reviewed components of the CCSG. Sql server 2000 enterprise manager Therefore, they cannot be added or deleted during a non-competing (Type 5) year without prior approval from the NCI’s Office of Cancer Centers (OCC). What is sql server database If your Center is considering a change in Programs during a non-competing year, please contact your Program Officer.

For shared resources with multiple leaders, please add seven additional fields per additional leader, for instance, LastNameN, FirstNameN, MiddleNameN, DegreeN1, DegreeN2, DegreeN3, isNewN. Sql server 2008 versions N is a numeric value that is great than 1.

The annual period for which the Data Tables are being submitted; it can be from October 1 of the prior year through September 30 of the year being described. Sql server express 2014 (e.g., 2014)

Note that Shared Resources are peer-reviewed components of the CCSG. Sql server 2012 advanced services Therefore, they cannot be added or deleted during a non-competing (Type 5) year without prior approval from the NCI’s Office of Cancer Centers (OCC). Sql server 2012 express with tools If your Center is considering a change in Shared Resources during a non-competing year, please contact your Program Officer.

For multi-PI or multi-investigator grants, please add three additional fields per additional leader, for instance, LastNameN, FirstNameN, MiddleNameN. Sql server express edition 2012 N is a numeric value that is great than 1.

The annual period for which the Data Tables are being submitted; it can be from October 1 of the prior year through September 30 of the year being described. Sql server express commercial use (e.g., 2014)

According to NIH’s definition ( Multiple Principal Investitgators FAQ page) multiple PIs have equal authority for the grant or contract and are jointly responsible for the scientific and technical direction of the project.

For the purpose of Data Table 2A (DT2A), multiple investigators refer to the investigators of the sub-projects for grants such as SPORE, P50, P01 and so on. Different versions of sql server These investigators may not be recognized in the NIH grants system as PIs; however we’re still identifying them in DT2A.

Indicate whether the Projects that are awarded by NCI, NIH, or organizations with peer-review funding systems as listed on the OCC website; use “Y” for yes and “N” for no.

Commonly referred to as the application number or grant number. Sql server editions This unique identification number for the grant is composed of the type code, activity code, Institute code, serial number, support year, and/or suffix code (e.g., 1R01CA059736-01)

Annual Costs that can be identified specifically with a particular sponsored project, other institutional activity, or that can be directly assigned to such activities relatively easily with a high degree of accuracy (e.g., 1560000)

Estimate, using a method of the Centers devising, the cancer relevant portion of a project and report the funding. Sql server express edition 2008 Be prepared to defend this estimate in peer-review. Sql server express edition 2008 r2 For grants that are 100% cancer-relevant (such as all NCI grants), this will be identical with the Annual Project Direct Costs. Sql server 2000 developer edition Do not include a comma (,) or a dollar sign ($) in the figure.

List the total number of projects and the sum of direct and total costs for each major funding agency category as follows: NCI, other NIH, other Peer and Non Peer-Reviewed (Industry-sponsored and Other).

The annual period for which the Data Tables are being submitted; it can be from October 1 of the prior year through September 30 of the year being described. For sql server (e.g., 2014)

For the 12-month period as defined by the Cancer Center, create one record for reportable cancers and use the following column names and definitions for clarity and uniformity.

Submit separate Data Table 3 tables for each consortium partner and/or affiliated institution ( e.g., pediatric hospital) that is a formal component of the Cancer Center but maintains a separate cancer registry. Sql database server Do not include loosely affiliated community partners.

The annual period for which the Data Tables are being submitted; it can be from October 1 of the prior year through September 30 of the year being described. Sql server compact edition (e.g., 2014)

Reportable Cancers. Sql server migration Malignancies with an International Classification of Diseases for Oncology (ICD) behavior code of 2 or 3 should be reported, in accordance with the established requirements of registry standard setting organizations. Sql server express server name Please refer to the ICD Codes on the OCC website: Grants & Funding page.

Newly registered patients are those patients seen face-to-face and recorded in the Cancer Center’s Cancer Registry for the first time for that diagnosis during the reporting period. Why sql server They include inpatients and outpatients who:

• are newly diagnosed and/or receiving first course of treatment at the Cancer Center, i.e., equivalent to American College of Surgeons-defined analytic case codes 00 – 22

• have recurrent or persistent disease and are referred to the Cancer Center for evaluation and treatment, i.e., equivalent to American College of Surgeons-defined non-analytic code 32.

The annual period for which the Data Tables are being submitted; it can be from October 1 of the prior year through September 30 of the year being described. Sql server 2008 (e.g., 2014)

The specific name of the financial sponsor for the clinical research study. Ms sql server enterprise For institutionally sponsored trials or studies, list the name of the applicable funding agencies, ( e.g., NCI, NYU)

The primary anatomic cancer site(s) ( i.e., breast, ovary) the clinical research study focuses on. And sql server If the clinical research study is broadly applicable to a number of potential anatomic sites, enter the term “multiple” in this column.

The National Clinical Trial Number is a unique number issued by the National Library of Medicine to identify a study (i.e., NCT00009876); If it is not applicable, use the ProtocolID

The unique identifier for the study. Sql server 2008 developer edition List the common protocol number that the trial is known under nationally, if one exists. Sql server last version For other trials that do not have an NCT number or a common protocol number that the trial is known under nationally, use an internal protocol identification or IRB number.

An alphanumeric Program Code that identifies the Research Program affiliated with the clinical research study as defined by the Center in Data Tables 1B and 2A. Sql server latest For clinical research studies that span more than one Research Program, include both Program Codes in this column.

The official start date (activation) of a trial determined as follows 1) the date of activation noted in an official clinical trial activation announcement or 2) date of first patient accrual if the trial in question did not have a formal activation announcement.

For Interventional studies acceptable phases include: pilot, feasibility, 0, I, II, III, IV, or combinations ( e.g., “Pilot/Feasibility”, “I/II”). Msft sql server For epidemiologic, cancer control/behavioral, observational, ancillary, correlative or other biological studies, indicate “N/A”

The total targeted accrual for the entire study. Build sql server For both single-site and multi-site trials initiated at your Center, indicate the total number of participants needed for the entire study. Uses of sql server For multi-site trials that your Center participates in but did not initiate, leave this column empty.

The targeted accrual for your Center. Sql server express analysis services For single-site and multi-site trials initiated at your Center, indicate the total number of participants your Center is expected to accrue for the study.

Provide the number of participants accrued to this clinical research study during the identified 12-month reporting period study your Cancer Center and its formal Consortium Partners.

Provide the number of participants accrued to this clinical research study to date at your Cancer Center and its formal Consortium Partners. Sql server express 2008 This number is a cumulative figure, not an annual total.

Provide the number of participants accrued to this clinical research study during the identified 12-month reporting period at all hospitals, treatment facilities, and/ or research facilities that are not a formal part of the Cancer Center (e.g., nearby community hospitals or other Centers that are participating in multi-site trials led by your Cancer Center).

Provide the number of participants accrued in the clinical research study to date at all hospitals, treatment facilities, and/ or research facilities that are not a formal part of the Cancer Center (e.g., nearby community hospitals or other Centers that are participating in multi-site trials led by your Cancer Center).

banner