...
| Contributors | ||||||
|---|---|---|---|---|---|---|
|
No. | Column Name | Description | Database Name | Source | Type |
|---|---|---|---|---|---|
| 1 | Institution | Institution where service being provided | Catalog Institution level | 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 | Core | ||||
| 5 | 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) |
| 56 | 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) |
| 67 | 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) |
| 78 | 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) |
| 89 | 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) |
| 910 | 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) |