| Info | ||||
|---|---|---|---|---|
| ||||
...
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) |