Based on SPARCRequest v3.7.0
No. | Column Name | Description | Database Name | Source | Type |
|---|---|---|---|---|---|
| 1 | Institution | Institution from which the requested service(s) were provided | organizations.name (services.organization_id, organizations.type = institution) | SPARCCatalog service form, the parent institution to which a service belong | VARCHAR(255) |
| 2 | Provider | Provider from which the requested service(s) were provided | organizations.name (services.organization_id, organizations.type = provider) | SPARCCatalog service form, the parent provider to which a service belong | VARCHAR(255) |
| 3 | Program | Program from which the requested service(s) were provided | organizations.name (services.organization_id, organizations.type = program) | SPARCCatalog service form, the parent program to which a service belong | VARCHAR(255) |
| 4 | Core | Core from which the requested service(s) were provided | organizations.name (services.organization_id, organizations.type = core) | SPARCCatalog service form, the parent core to which a service belong | VARCHAR(255) |
| 5 | Unique PI Last Name | Principal Investigator Last Name | identities.last_name | SPARCRequest Step 2 Authorized Users form, required Primary PI SPARCDashboard Authorized Users Form, required Primary PI SPARC User Profile | VARCHAR(255) |
| 6 | Unique PI First Name | Principal Investigator First Name | identities.last_name | SPARCRequest Step 2 Authorized Users form, required Primary PI SPARCDashboard Authorized User Form, required Primary PI SPARC User Profile | VARCHAR(255) |
| 7 | Institution | Principal Investigator affiliated institution | professional_organizations.name (org_type = institution) | SPARCRequest Step 2 Authorized Users Add/Edit User Popup Window (Affiliation dropdown lists are logic-driven and only needs to be filled in once; it is shared across SPARC) | TEXT |
| 8 | College | Principal Investigator affiliated college | professional_organizations.name (org_type = college) | SPARCRequest Step 2 Authorized Users Add/Edit User Popup Window (Affiliation dropdown lists are logic-driven and only needs to be filled in once; it is shared across SPARC) | TEXT |
| 9 | Department | Principal Investigator affiliated department | professional_organizations.name (org_type = department) | SPARCRequest Step 2 Authorized Users Add/Edit User Popup Window (Affiliation dropdown lists are logic-driven and only needs to be filled in once; it is shared across SPARC) | TEXT |
| 10 | Division | Principal Investigator affiliated division | professional_organizations.name (org_type = division) | SPARCRequest Step 2 Authorized Users Add/Edit User Popup Window (Affiliation dropdown lists are logic-driven and only needs to be filled in once; it is shared across SPARC) | TEXT |