Contributors |
---|
showCount | true |
---|
showAnonymous | true |
---|
showLastTime | true |
---|
|
No.
| Column Name | Description | Database Name | Source | Type |
---|
1 | Institution | Institution |
where service being providedCatalog Institution level | VarcharVarcharfrom 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 |
the level of organization that the program belongs to | Provider/ Program/Core Column | 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 |
the level of organization that the service belongs to | Program from which the requested service(s) were provided | organizations.name (services.organization_id |
Provider/ Program/Core Column | Varchar, 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 | Step 2 Authorized Users; One Primary PI is required on each protocol. |
VarcharVARCHAR(255) |
6 | Unique PI First Name | Principal Investigator |
Firstt First Name | identities.last_name | Step 2 Authorized Users; One Primary PI is required on each protocol. |
VarcharVARCHAR(255) |
7 | Institution | Principal Investigator |
Institutionaffiliated 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. |
VarcharVARCHAR(255) |
8 | College | Principal Investigator |
College affiliated 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. |
VarcharVARCHAR(255) |
9 | Department | Principal Investigator |
Department affiliated 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. |
VarcharVARCHAR(255) |
10 | Division | Principal Investigator |
Division affiliated 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