SPARCRequest Wiki

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 15 Next »


No.


Column NameDescriptionDatabase NameSourceType
1Institution

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 belongVARCHAR(255)
2ProviderProvider from which the requested service(s) were providedorganizations.name (services.organization_id,  organizations.type = provider)SPARCCatalog service form, the parent provider to which a service belongVARCHAR(255)
3ProgramProgram from which the requested service(s) were providedorganizations.name (services.organization_id,  organizations.type = program)SPARCCatalog service form, the parent program to which a service belongVARCHAR(255)
4CoreCore from which the requested service(s) were providedorganizations.name (services.organization_id,  organizations.type = core)SPARCCatalog service form, the parent core to which a service belongVARCHAR(255)
5Unique PI Last NamePrincipal Investigator Last Nameidentities.last_name

SPARCRequest Step 2 Authorized Users form, required Primary PI 

SPARCDashboard Authorized Users Form, required Primary PI

SPARC User Profile

VARCHAR(255)
6Unique PI First NamePrincipal Investigator First Nameidentities.last_name

SPARCRequest Step 2 Authorized Users form, required Primary PI 

SPARCDashboard Authorized User Form, required Primary PI

SPARC User Profile

VARCHAR(255)
7EmailPrincipal Investigator Emailidentities.email

SPARCRequest Step 2 Authorized Users form, required Primary PI email

SPARCDashboard Authorized User Form, required Primary PI email

SPARC User Profile

VARCHAR(255)
7InstitutionPrincipal Investigator affiliated institutionprofessional_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
8CollegePrincipal Investigator affiliated collegeprofessional_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
9DepartmentPrincipal Investigator affiliated departmentprofessional_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
10DivisionPrincipal Investigator affiliated divisionprofessional_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
11ERA Commons NameThe 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)
12ORCIDThe 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 Add/Edit User Popup Window, ORCID field

SPARCDashboard Authorized User Add/Edit User Popup Window, ORCID field

SPARC User Profile

CHAR(19)
13GenderSex/gender entered on the PI's profileidentities.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

VARCHAR(255)
14Age GroupSelected age range entered on the PI's profileidentities.age_group

SPARCRequest Step 2 Authorized Users Add/Edit User Popup Window, 'age' field

SPARCDashboard Authorized User Add/Edit User Popup Window, 'age' field

SPARC User Profile

VARCHAR(255)
15Hispanic/Latino?Hispanic heritage entered on the PI's profile identities.ethnicity

SPARCRequest Step 2 Authorized Users Add/Edit User Popup Window, 'Hispanic/Latino' field

SPARCDashboard Authorized User Add/Edit User Popup Window, 'Hispanic/Latino' field

SPARC User Profile

VARCHAR(255)
16RaceThe racial group entered on the PI's profileraces.name

SPARCRequest Step 2 Authorized Users Add/Edit User Popup Window, 'race' field

SPARCDashboard Authorized User Add/Edit User Popup Window, 'race' field

SPARC User Profile

VARCHAR(255)
  • No labels