Skip to content

Ilc Customers

Table Overview

This table contains 32 columns.

Quick Navigation

Column Definitions

AUTH_PREFERENCE

Business Definition

The AUTH_PREFERENCE column stores auth preference information for customers records. Its business purpose is to support customers data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate customers data for reporting and analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

AUTH_PREFERENCE_OPTIONS

Business Definition

The AUTH_PREFERENCE_OPTIONS column stores auth preference options information for customers records. Its business purpose is to support customers data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate customers data for reporting and analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

BYPASS_HOMEPAGE

Business Definition

The BYPASS_HOMEPAGE column stores bypass homepage information for customers 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 customers data for reporting and analysis.

Data Type

BOOLEAN

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 customers 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 customers data for reporting and analysis.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

CREATED_BY

Business Definition

The CREATED_BY column stores created by information for customers records. Its business purpose is to support customers data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate customers data for reporting and analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

CUSTOMER_TYPE

Business Definition

The CUSTOMER_TYPE column stores customer type information for customers records. Its business purpose is to support customers data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate customers data for reporting and analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

GATE_CONTENT

Business Definition

The GATE_CONTENT column stores gate content information for customers 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 customers data for reporting and analysis.

Data Type

BOOLEAN

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 customers 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 customers data for reporting and analysis.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

GOOGLE_CLASSROOM_ENABLED

Business Definition

The GOOGLE_CLASSROOM_ENABLED column stores google classroom enabled information for customers 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 customers data for reporting and analysis.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

HIDE_MENU_OPTIONS_FOR_STUDENTS

Business Definition

The HIDE_MENU_OPTIONS_FOR_STUDENTS column stores hide menu options for students information for customers 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 customers data for reporting and analysis.

Data Type

BOOLEAN

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 customer organization within the ILC system. Its business purpose is to enable referential integrity across all ILC tables and support customer-specific data segmentation. Users and analysts would use this column to join customer information with users, classes, schools, and assignments for multi-tenant analysis and reporting.

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 customers records. Its business purpose is to support customers data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate customers data for reporting and analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

INTERCOM_ENABLED

Business Definition

The INTERCOM_ENABLED column stores intercom enabled information for customers 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 customers data for reporting and analysis.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

LOCALE

Business Definition

The LOCALE column stores locale information for customers records. Its business purpose is to support customers data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate customers data for reporting and analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

Business Definition

The LOGO column stores logo information for customers records. Its business purpose is to support customers data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate customers data for reporting and analysis.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

MAINTENANCE_MODE

Business Definition

The MAINTENANCE_MODE column stores maintenance mode information for customers 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 customers data for reporting and analysis.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

NAME

Business Definition

The NAME column contains the official name of the customer organization (district, school system, or educational institution). Its business purpose is to provide human-readable identification of customers in reports and user interfaces. Users and analysts would use this column to filter and group data by customer organization for comparative analysis and customer-specific reporting.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

OWNER_ID

Business Definition

The OWNER_ID column stores owner id information for customers records. Its business purpose is to link this customers record to related owner data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate customers data for reporting and analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

PENDING_DELETION

Business Definition

The PENDING_DELETION column stores pending deletion information for customers 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 customers data for reporting and analysis.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

PROTECT_FROM_DELETION

Business Definition

The PROTECT_FROM_DELETION column stores protect from deletion information for customers 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 customers data for reporting and analysis.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

QUESTION_BANKS

Business Definition

The QUESTION_BANKS column stores question banks information for customers records. Its business purpose is to support customers data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate customers data for reporting and analysis.

Data Type

ARRAY

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

SESSION_TIMEOUT

Business Definition

The SESSION_TIMEOUT column stores session timeout information for customers records. Its business purpose is to support customers data management and reporting requirements. Users and analysts would use this column to filter, join, and aggregate customers data for reporting and analysis.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

SHOW_PUBLIC_CONTENT

Business Definition

The SHOW_PUBLIC_CONTENT column stores show public content information for customers 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 customers data for reporting and analysis.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

SHOW_STANDARDS

Business Definition

The SHOW_STANDARDS column stores show standards information for customers 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 customers data for reporting and analysis.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

SHOW_STUDENT_STANDARDS

Business Definition

The SHOW_STUDENT_STANDARDS column stores show student standards information for customers 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 customers data for reporting and analysis.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

SITE_TYPE

Business Definition

The SITE_TYPE column categorizes customers by their relationship to ILC using numeric codes (0=Content Internal, 1=Content Partner, 2=Customer, 3=Demo, 4=Internal, 5=Technology Partner, 6=Pilot). Its business purpose is to segment customers for different service levels, feature access, and business reporting. Users and analysts would use this column to filter production customers from demos and internal sites, analyze adoption by customer type, and apply appropriate business rules based on customer classification.

Data Type

NUMBER

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

SPANISH_MATERIALS

Business Definition

The SPANISH_MATERIALS column stores spanish materials information for customers 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 customers data for reporting and analysis.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

STUDENT_FUNCTIONALITY

Business Definition

The STUDENT_FUNCTIONALITY column stores student functionality information for customers 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 customers data for reporting and analysis.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

SUBDOMAIN

Business Definition

The SUBDOMAIN column stores the unique URL subdomain identifier for each customer's ILC site (e.g., 'abc' for 'abc.ilclassroom.com'). Its business purpose is to enable direct site access and track customer-specific web traffic. Users and analysts would use this column to identify customer sites, troubleshoot access issues, and correlate usage patterns with specific customer instances.

Data Type

TEXT

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

TEACHER_ASSESSMENT_COPY_ENABLED

Business Definition

The TEACHER_ASSESSMENT_COPY_ENABLED column stores teacher assessment copy enabled information for customers 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 customers data for reporting and analysis.

Data Type

BOOLEAN

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT

TEACHER_COPY_ENABLED

Business Definition

The TEACHER_COPY_ENABLED column stores teacher copy enabled information for customers 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 customers data for reporting and analysis.

Data Type

BOOLEAN

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 customers 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 customers data for reporting and analysis.

Data Type

TIMESTAMP_NTZ

Nullable

Yes

Last Updated

2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT