Ilc Users
Table Overview
This table contains 25 columns.
Quick Navigation
- ADMIN_ACCESS_IDS
- ARCHIVED
- AUTH_TOKEN
- AVATAR
- CREATED_AT
- CUSTOMER_ID
- FIRST_NAME
- GO_PEER_ENABLED
- GOOGLE_CLASSROOM_TOKEN
- ID
- IL_GUID
- LAST_NAME
- LAST_VISITED
- MIDDLE_NAME
- PASSWORD_DIGEST
- PASSWORD_RESET_SENT_AT
- PASSWORD_RESET_TOKEN
- PREVENT_USER_CHANGES
- PROFILE
- ROLE
- THEME
- TYPE
- UPDATED_AT
- USERNAME
Column Definitions
ADMIN_ACCESS_IDS
Business Definition
The ADMIN_ACCESS_IDS column stores admin access ids information for users records. Its business purpose is to support users data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate users data for reporting and analysis.
Data Type
ARRAY
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
ARCHIVED
Business Definition
The ARCHIVED column stores archived information for users records. Its business purpose is to provide a flag for conditional logic and filtering in queries and applications. Users and analysts would use this column to filter, join, and aggregate users data for reporting and analysis.
Data Type
BOOLEAN
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
AUTH_TOKEN
Business Definition
The AUTH_TOKEN column stores auth token information for users records. Its business purpose is to support users data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate users data for reporting and analysis.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
AVATAR
Business Definition
The AVATAR column stores avatar information for users records. Its business purpose is to support users data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate users data for reporting and analysis.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
CREATED_AT
Business Definition
The CREATED_AT column stores created at information for users records. Its business purpose is to track the creation timestamp for audit trails and temporal analysis. Users and analysts would use this column to filter, join, and aggregate users data for reporting and analysis.
Data Type
TIMESTAMP_NTZ
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
CUSTOMER_ID
Business Definition
The CUSTOMER_ID column is a foreign key linking each user to their parent customer organization in ILC_CUSTOMERS. Its business purpose is to enforce multi-tenant data isolation and enable customer-level user aggregations. Users and analysts would use this column to segment users by organization, calculate customer-specific user counts, and ensure data security boundaries are maintained.
Data Type
NUMBER
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
Business Definition
The EMAIL column contains the email address for educator users (teachers, admins) serving as their login credential and communication channel. Its business purpose is to enable educator authentication, system notifications, and professional communication. Users and analysts would use this column to identify teachers in reports, validate user accounts, and support communication workflows.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
FIRST_NAME
Business Definition
The FIRST_NAME column stores first name information for users records. Its business purpose is to provide human-readable identification in user interfaces and reports. Users and analysts would use this column to filter, join, and aggregate users data for reporting and analysis.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
GO_PEER_ENABLED
Business Definition
The GO_PEER_ENABLED column stores go peer enabled information for users records. Its business purpose is to provide a flag for conditional logic and filtering in queries and applications. Users and analysts would use this column to filter, join, and aggregate users data for reporting and analysis.
Data Type
BOOLEAN
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
GOOGLE_CLASSROOM_TOKEN
Business Definition
The GOOGLE_CLASSROOM_TOKEN column stores google classroom token information for users records. Its business purpose is to support users data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate users data for reporting and analysis.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
ID
Business Definition
The ID column serves as the primary key uniquely identifying each user (student, teacher, or administrator) in the ILC system. Its business purpose is to enable user tracking across sessions, assignments, and all user activities. Users and analysts would use this column to join user data with classes, schools, assignments, and activity records for comprehensive user behavior analysis.
Data Type
NUMBER
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
IL_GUID
Business Definition
The IL_GUID column stores il guid information for users records. Its business purpose is to support users data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate users data for reporting and analysis.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
LAST_NAME
Business Definition
The LAST_NAME column stores last name information for users records. Its business purpose is to provide human-readable identification in user interfaces and reports. Users and analysts would use this column to filter, join, and aggregate users data for reporting and analysis.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
LAST_VISITED
Business Definition
The LAST_VISITED column stores last visited information for users records. Its business purpose is to support users data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate users data for reporting and analysis.
Data Type
TIMESTAMP_NTZ
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
MIDDLE_NAME
Business Definition
The MIDDLE_NAME column stores middle name information for users records. Its business purpose is to provide human-readable identification in user interfaces and reports. Users and analysts would use this column to filter, join, and aggregate users data for reporting and analysis.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
PASSWORD_DIGEST
Business Definition
The PASSWORD_DIGEST column stores password digest information for users records. Its business purpose is to support users data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate users data for reporting and analysis.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
PASSWORD_RESET_SENT_AT
Business Definition
The PASSWORD_RESET_SENT_AT column stores password reset sent at information for users records. Its business purpose is to support users data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate users data for reporting and analysis.
Data Type
TIMESTAMP_NTZ
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
PASSWORD_RESET_TOKEN
Business Definition
The PASSWORD_RESET_TOKEN column stores password reset token information for users records. Its business purpose is to support users data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate users data for reporting and analysis.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
PREVENT_USER_CHANGES
Business Definition
The PREVENT_USER_CHANGES column stores prevent user changes information for users records. Its business purpose is to provide a flag for conditional logic and filtering in queries and applications. Users and analysts would use this column to filter, join, and aggregate users data for reporting and analysis.
Data Type
BOOLEAN
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
PROFILE
Business Definition
The PROFILE column stores profile information for users records. Its business purpose is to support users data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate users data for reporting and analysis.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
ROLE
Business Definition
The ROLE column defines the user's permission level and access rights using numeric codes (1=Global Admin, 2=Teacher, 4=Site Admin, 5=Student, 6=Author, 7=School Admin, 8=Customer Admin, 10=Customer Viewer). Its business purpose is to enforce role-based access control and enable role-specific feature access. Users and analysts would use this column to segment users by type, calculate teacher-to-student ratios, filter data by user role, and audit system access patterns.
Data Type
NUMBER
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
THEME
Business Definition
The THEME column stores theme information for users records. Its business purpose is to support users data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate users data for reporting and analysis.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
TYPE
Business Definition
The TYPE column stores type information for users records. Its business purpose is to support users data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate users data for reporting and analysis.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
UPDATED_AT
Business Definition
The UPDATED_AT column stores updated at information for users records. Its business purpose is to track the last modification timestamp for audit trails and temporal analysis. Users and analysts would use this column to filter, join, and aggregate users data for reporting and analysis.
Data Type
TIMESTAMP_NTZ
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
USERNAME
Business Definition
The USERNAME column stores the login username for student accounts only (educator users use email for login). Its business purpose is to provide unique student identification within a customer organization for authentication and student activity tracking. Users and analysts would use this column to identify students in reports, troubleshoot login issues, and join with assignment activity data.
Data Type
TEXT
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT