Abstract: A system is provided that implements a point-in-time query. The system selects a point-in-time query type from one or more point-in-time query types. The system further retrieves metadata that includes structured query language information based on the selected point-in-time query type. The system further creates a point-in-time query for a data source based on the retrieved metadata, where the point-in-time query is a query that is based on a date and/or time. The system further compiles the point-in-time query. The system further executes the point-in-time query on the data source; where the executing of the point-in-time query creates a case series.

Abstract: A system is provided that identifies a cohort. The system retrieves metadata that includes information about one or more data fields of a data source. The system further creates a query for the data source based on the retrieved metadata. The system further compiles the query and executes the query on the data source. By executing the query on the data source, the system creates a case series. The system further generates a report based on the case series.

Abstract: A system is provided that integrates a case series repository with one or more software applications. The system receives a case series, where the case series includes one or more adverse event cases, and the system further receives a case revision, where the case revision includes case revision information. The system further stores the case series and the case revision within a case series repository using a case series data model. The system further associates the case revision with the case series using the case series data model. The system further retrieves the case series and the associated case revision using a case series programming interface.

Abstract: A system is provided that implements a point-in-time query. The system selects a point-in-time query type from one or more point-in-time query types. The system further retrieves metadata that includes structured query language information based on the selected point-in-time query type. The system further creates a point-in-time query for a data source based on the retrieved metadata, where the point-in-time query is a query that is based on a date and/or time. The system further compiles the point-in-time query. The system further executes the point-in-time query on the data source; where the executing of the point-in-time query creates a case series.