/
SPARC Account Report Data Dictionary (SPARCRequest v3.12.1)

SPARCRequest Wiki

SPARC Account Report Data Dictionary (SPARCRequest v3.12.1)

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)









Copyright © 2011-2020 MUSC Foundation for Research Development