SPARCRequest Wiki
SPARC Account Report Data Dictionary (SPARCRequest v3.12.1)
No. | Column Name | Description | Database Name | Source | Type |
---|---|---|---|---|---|
1 | Last Name | Account holder's last name | identities.last_name | LDAP/ADFS directory or Outside User Account Profile | VARCHAR(255) |
2 | First Name | Account holder's first name | identities.first_name | LDAP/ADFS directory or Outside User Account Profile | VARCHAR(255) |
3 | Account holder's email address | identities.email | LDAP/ADFS directory or Outside User Account Profile | VARCHAR(255) | |
4 | Institution | Account holder's affiliated institution | professional_organizations.name (professional_organizations.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 Users Form, required Primary PI SPARC User Profile | TEXT |
5 | College | Account holder's affiliated college | professional_organizations.name (professional_organizations.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 Users Form, required Primary PI SPARC User Profile | TEXT |
6 | Department | Account holder's affiliated department | professional_organizations.name (professional_organizations.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 Users Form, required Primary PI SPARC User Profile | TEXT |
7 | Division | Account holder's affiliated division | professional_organizations.name. (professional_organizations.org_type = division) | SPARCRequest Step 2 Authorized Users Add/Edit User Popup Window; Affiliation only needs to be filled in once and will be shared across SPARC. SPARCDashboard Authorized Users. Division can also be entered/edited from Profiles page Division dropdown menu. | TEXT |
8 | Account Created Date | Date on which the user account was created | identities.created_at | Date stamp when a user account is pulled in from searching or adding | DATETIME |
9 | ID | Unique user account ID from SPARC | identities.id | SPARC system generated unique ID | BIGINT(20) |
10 | LDAP_UID | Account holder's User ID from the LDAP directory | identities.ldap_uid | LDAP directory | VARCHAR(255) |
11 | Approved/Activated? | Status of the Account creation submission | identities.approved | Account approval email (Approve button), and/or user search/adding | TINYINT(1) |
12 | Overlord? | Designation of Overlord rights for the account holder | identities.catalog_overlord | Manually setup from database | TINYINT(1) |
Copyright © 2011-2020 MUSC Foundation for Research Development