Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Contributors
showCounttrue
showAnonymoustrue
showLastTimetrue

...

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

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)

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)

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)

TEXT


Excel
name2020-04-22 Unique PI.xlsx

...