Unique PI Report Data Dictionary

Last Updated On:

No.	Column Name	Description	Database Name	Source	Type
1	Institution				Varchar(255)
2	Provider	the level of organization that the program belongs to		Provider/ Program/Core Column	Varchar(255)
3	Program	the level of organization that the service belongs to	services.organization_id	Provider/ Program/Core Column	Varchar(255)
4	Unique PI Last Name	Principal Investigator Last Name	identities.last_name	Step 2 Authorized Users; One Primary PI is required on each protocol.	Varchar(255)
5	Unique PI First Name	Principal Investigator Firstt Name	identities.last_name	Step 2 Authorized Users; One Primary PI is required on each protocol.	Varchar(255)
6	Institution	Principal Investigator Institution	professional_organizations.name (org_type = institution)	Step 2 Authorized Users Add/Edit User Popup Window; Affiliation only needs to be filled in once, and will be shared across SPARC.	Varchar(255)
7	College	Principal Investigator College	professional_organizations.name (org_type = college)	Step 2 Authorized Users Add/Edit User Popup Window; Affiliation only needs to be filled in once, and will be shared across SPARC.	Varchar(255)
8	Department	Principal Investigator Department	professional_organizations.name (org_type = department)	Step 2 Authorized Users Add/Edit User Popup Window; Affiliation only needs to be filled in once, and will be shared across SPARC.	Varchar(255)
9	Division	Principal Investigator Division	professional_organizations.name (org_type = division)	Step 2 Authorized Users Add/Edit User Popup Window; Affiliation only needs to be filled in once, and will be shared across SPARC.	Varchar(255)