SPARC Account Report Data Dictionary (SPARCRequest v3.13.0)

Report of user accounts, with option to include Active/Approved and Deactivated statuses.

No.	Column Name	Description	Database Name	Source	Type

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