Ilc Schools
Table Overview
This table contains 6 columns.
Quick Navigation
Column Definitions
CLEVER_ID
Business Definition
The CLEVER_ID column stores clever id information for schools records. Its business purpose is to link this schools record to related clever data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate schools 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 schools 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 schools 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 foreign key to ilc_customers(id) - customer organization this school belongs to. Its business purpose is to link this schools record to related customer data and maintain relational integrity. Users and analysts would use this column to filter, join, and aggregate schools data for reporting and analysis.
Data Type
NUMBER
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
ID
Business Definition
The ID column primary key - unique school identifier. Its business purpose is to serve as the primary key ensuring unique identification of each schools record and enable referential integrity across related tables. Users and analysts would use this column to filter, join, and aggregate schools data for reporting and analysis.
Data Type
NUMBER
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT
NAME
Business Definition
The NAME column school name. 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 schools 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 schools 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 schools data for reporting and analysis.
Data Type
TIMESTAMP_NTZ
Nullable
Yes
Last Updated
2025-12-15T10:14:44.954064 by MARKDOWN_IMPORT