...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
...
Contributors | ||||||||
---|---|---|---|---|---|---|---|---|
|
Based on SPARCRequest v3.7.0
No.
...
Institution from which the requested service(s) were provided
...
SPARCRequest Step 2 Authorized Users form, required Primary PI
...
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 | Principal Investigator Email | identities.email | SPARCRequest Step 2 Authorized Users form, required Primary PI email SPARCDashboard Authorized User Form, required Primary PI email 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) SPARCDashboard Authorized User Form, required Primary PI SPARC User Profile | 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) SPARCDashboard Authorized User Form, required Primary PI SPARC User Profile | 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) SPARCDashboard Authorized User Form, required Primary PI SPARC User Profile | 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) SPARCDashboard Authorized User Form, required Primary PI SPARC User Profile | TEXT | |||||||
11 | ERA Commons Name | The PI's electronic Research Administration (eRA) commons name giving to the Principal Investigator for the NIH grant management system. | identities.era_commons_name | SPARCRequest Step 2 Authorized Users Add/Edit User Popup Window, ERA Commons Name field SPARCDashboard Authorized User Add/Edit User Popup Window, ERA Commons Name field SPARC User Profile | VARCHAR(255) | |||||||
12 | ORCID | Unique PI First Name | Principal Investigator First Name | identities.last_nameThe PI's unique digital identifier given by the Open Researcher and Contributor ID (ORCID) to help distinguish researchers. | identities.orcid | SPARCRequest Step 2 Authorized Users | form, required Primary PI Add/Edit User Popup Window, ORCID field SPARCDashboard Authorized User | Form, required Primary PIAdd/Edit User Popup Window, ORCID field SPARC User Profile | VARCHARCHAR( | 25519) | ||
13 | Institution | Principal Investigator affiliated institution | professional_organizations.name (org_type = institution)Gender | Sex/gender entered on the PI's profile | identities.gender; identities.gender_other | SPARCRequest Step 2 Authorized Users Add/Edit User Popup Window | , 'sex/gender' field SPARCDashboard Authorized User Add/Edit User Popup Window, 'sex/gender' field SPARC User Profile | TEXT | 8 | College | Principal Investigator affiliated college | professional_organizations.name (org_type = college)VARCHAR(255) |
14 | Age Group | Selected age range entered on the PI's profile | identities.age_group | 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), 'age' field SPARCDashboard Authorized User | Form, required Primary PIAdd/Edit User Popup Window, 'age' field SPARC User Profile | TEXT | 9 | Department | Principal Investigator affiliated department | professional_organizations.name (org_type = department)VARCHAR(255) | |
15 | Hispanic/Latino? | Hispanic heritage entered on the PI's profile | identities.ethnicity | SPARCRequest Step 2 Authorized Users Add/Edit User Popup Window | TEXT | 10 | Division | Principal Investigator affiliated division | professional_organizations.name (org_type = division), 'Hispanic/Latino' field SPARCDashboard Authorized User Add/Edit User Popup Window, 'Hispanic/Latino' field SPARC User Profile | VARCHAR(255) | ||
16 | Race | The racial group entered on the PI's profile | races.name | 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), 'race' field SPARCDashboard Authorized | User Form, required Primary PIUser Add/Edit User Popup Window, 'race' field SPARC User Profile | TEXT |
Excel | ||
---|---|---|
|
...
VARCHAR(255) |