Local Navigation

HPVIS Ad hoc Query

Selection of Columns

STEP 2: Select one or more column(s) for your output by clicking on the square box next to the column name. When you are finished selecting columns, click on the "STEP 3: Enter Search Criteria" button at the bottom of this page.

QUERY NAME: Submission Information, TABLE NAME: V_SUBMISSION_EZ
	Administrative Record (AR) Number	A unique seven-digit registration number that is assigned by CBIC to identify each submission item related to a commitment made by a sponsor in the HPV Challenge Program. The commitment, Test Plan, Robust Summary, addendum, related correspondence, Revised Test Plan, and Revised Robust Summary, all submitted by the sponsor, are each assigned an AR Number. (e.g., 456-0001). In addition, an AR Number is assigned to each set of public comments and EPA comments.
	CAS Number	A standardized number assigned by the Chemical Abstracts Service (CAS) to identify a chemical (e.g., 10595-60-5).
	CAS Number without Dashes	The CAS Number without embedded dashes.
	Category ID	Identification of the category, if any, to which this record is associated.
	CBI Associated Data	An indicator specifying that there is associated CBI data related to this submission.
	Chemical Category Name	The name of the chemical category.
	Chemical ID	Identification of the chemical to which this synonym is associated.
	Comment Period End Date	The End Date of the 120-day EPA comment period.
	Comment Period Reason Revised	A text field indicating why the 120-day Comment Period for a Submission Test Plan Package was changed.
	Comment Period Start Date	The Begin Date of the 120-day EPA comment period.
	CSI Comment	If the submission is a CSI, add comments if necessary.
	Data Adequacy Indicator	An EPA-entered characterization of the data adequacy of an endpoint for a submission.
	Date Submission Complete	The date on which OPPT determines that all submission information for a commitment is complete.
	Date Submission Received	The date on which a submission item was stamped as received by EPA.
	HPVIS Create Date	Date record was created.
	HPVIS Create User's ID	User ID of HPVIS user who created record.
	HPVIS Update Date	Date record was updated.
	HPVIS Update User ID	User ID of HPVIS user who updated record.
	Is this the Final Data Submission?	This indicator is a sponsor-set indicator that indicates that this submission is the final submission. The sponsor thinks that no additional data is going to be required to form a complete set of data about this chemical or category.
	Master Registry Number	A unique number identifying the company or consortium.
	Ninth Collective Chemical Index Name	A standardized chemical name taken from the Ninth Collective Index for the CAS Number.
	Original/Revised Indicator	An indicator specifying whether the Robust Summary Package is original or revised.
	Program Flag	Program that the submission is associated with.
	Requires a CSI	The submission is a 'Closed System Intermediate Claim'.
	Status Change Reason	Identifies why the status was changed.
	Submission ID	The submission to which this record is associated.
	Submission Name	The sponsor provided name associated with the submission.
	Submission SN Number	The ID of the case (i.e., all materials associated with submissions) to which this comment is associated.
	Submission Status	The status of a Submission.
	Submission Type	The type of information being submitted.

Jump to main content.