Corporate Contracts & Grants Data Warehouse Tables
|
|
|
Corporate Contracts & Grants Data Warehouse Tables |
| Sybase
IQ View Name / WebFOCUS Reporting Object Name |
Records | Data Included | Known Problems |
|
CGX_Award |
One record for each contract or grant awarded to any UC location from fiscal year 2001 onward. Data for prior years is incomplete because awards inactive for five years used to be purged yearly. | Summary information: project title, type of award, beginning and end date, amount, principal investigators, sponsor, account and fund, etc. | |
|
CGX_Award_FYR_QTR |
One record for each award, each active fiscal quarter from fiscal year 2001 onward. Data for prior years is incomplete because awards inactive for five years used to be purged yearly. | Quarterly information: new amount, new beginning and end date, plus all the summary data through a join with CGX_Award | |
|
CGX_Proposal |
One record for each contract or grant proposal to any UC location from fiscal year 2005 onward. Data for prior years is incomplete because proposals inactive for one year used to be purged yearly. | Summary information: project title, type of award, cost, duration, principal investigators, sponsor, account, etc. | |
|
CGX_Proposal_FYR_QTR |
One record for each proposal, each active fiscal quarter from fiscal year 2005 onward. Data for prior years is incomplete because awards inactive for one year used to be purged yearly. | Quarterly information: new amount, plus all the summary data through a join with CGX_Proposal |
If you have questions about the Corporate Contracts & Grants Data Warehouse, contact Dominique Pfaff at 510-987-0394