el_lookup_terms
This lookup table resolves an Term GUID to an Term name.
GUID will be stored as a foreign key on the Person record.
el_lookup_terms
11 rows
| Column | Description | Data Type |
|---|---|---|
| updated_at | Date and time of the last update to the Term. | TIMESTAMP_NTZ |
| guid | Unique identifier for the Term. | VARCHAR |
| name | Name of the Term. | VARCHAR |
| start_date | Start date of the Term. | TIMESTAMP_NTZ |
| code | Code associated with the Term. | VARCHAR |
| academic_year_start_date | Calculated start date of the academic year based on the earliest Term associated with the academic year. | TIMESTAMP_NTZ |
| academic_year | Academic year associated with the Term. | VARCHAR |
| src | All properties of the Term object. | VARIANT |
| active | Flag indicating whether the Term is active. | BOOLEAN |
| end_date | End date of the Term. | TIMESTAMP_NTZ |
| subdom | Partner institution instance identifier. | VARCHAR |
Was this page helpful?