institution_user

Pipelined Data Sets > Banno Operation and Transaction > institution_user

Column name	Description	Mode	Type	Length
user_id	Unique identifier for the institution user. Primary key.	NULLABLE	STRING
institution_id	The unique identifier for the institution this user belongs to.	NULLABLE	STRING
first_name	User's first name.	NULLABLE	STRING
middle_initial	User's middle initial (single character).	NULLABLE	STRING
last_name	User's last name.	NULLABLE	STRING
email	User's email address. Must be unique across all institution users.	NULLABLE	STRING
active	Whether the user account is active. False indicates deactivated account.	NULLABLE	BOOLEAN
phone	User's primary phone number.	NULLABLE	STRING
image_url	URL to the user's profile image.	NULLABLE	STRING
reset_token	Token used for password reset functionality. NULL when no reset is in progress.	NULLABLE	STRING
administrator	Whether the user has administrator privileges. Defaults to false.	NULLABLE	BOOLEAN
reset_token_created_time	Timestamp when the reset token was created. NULL when no reset token exists.	NULLABLE	TIMESTAMP
login_attempts	Number of failed login attempts. Used for account lockout security. Defaults to 0.	NULLABLE	INTEGER
locale	User's preferred locale/language setting (e.g., 'en_US', 'es_MX').	NULLABLE	STRING
timezone	User's timezone preference (e.g., 'America/Chicago', 'America/New_York').	NULLABLE	STRING
job_title	User's job title or position within the institution.	NULLABLE	STRING
cell_phone	User's mobile/cell phone number.	NULLABLE	STRING

Have a Question?

Have a how-to question? Seeing a weird error? Get help on StackOverflow.
Register for the Developer Office Hours where we answer technical Q&A from the audience.

Please ignore this field

Did this page help you?

Last updated Wed May 13 2026