Gen, 6 (ver3.6.1)
This table serves as a catchall table containing a variety of information, such as look up tables.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Cat | 3.6.1 | Varchar(15) | The category the element belongs to. These are the options: Blank, wc, per, stdconv, att, logtype, stdconvscale, cit, access, styles, groups, feetype, storedsearch, training, printers, ethnicity, hsn, coursegroups, dailyatt, activity, subtype, pgfield, consequence, teachergroups, nextschools, exitcodes, specprog, dailymembtypes, ipadminallow. Indexed. |
Custom | 3.6.1 | CLOB | This field holds all the gen custom fields and their values. |
Date_Value | 3.6.1 | Date | The value of the item stored in a date field. For reporting this would be the build date. Note: Renamed in ver5.2.0. Formerly known as Date. |
Date2 | 3.6.1 | Date | The value of the item stored in a date field. For reporting this would be the response date. |
DCID | 4.0.4 | Number(10,0) | Unique identifier for this table. Indexed. Required. |
ID | 3.6.1 | Number(10,0) | Sequential number generated by the application, but uniqueness in the table is not guaranteed. Indexed. |
Log | 3.6.1 | CLOB | Log of what this record, such as GPA calculation methods or report Builds. |
Name | 3.6.1 | Varchar(50) | The name of the item. Indexed. |
PowerLink | 3.6.1 | Varchar(40) | How PowerLink will read this item. |
PowerLinkSpan | 3.6.1 | Varchar(60) | How PowerLink will read this item in Spanish. |
PSGUID | 7.8.0 | Varchar(50) | If used, a unique identifier for the row. Currently applicable to multi-tenant, Schoolnet, and Pearson SuccessNet/Pearson SuccessNet Plus. |
SchoolID | 3.6.1 | Number(10,0) | The School_Number of the associated Schools record. |
SortOrder | 3.6.1 | Number(10,0) | For multi item lists where should this one be displayed. Sorted numerically lowest to highest. |
Time1 | 3.6.1 | Number(10,0) | The value of the item stored in a date field. For reporting this would be the build time. |
Time2 | 3.6.1 | Number(10,0) | The value of the item stored in a date field. For reporting this would be the response time. |
Value | 23.1.0 | Varchar(100) | The value of the item stored in an alpha field. |
Value2 | 3.6.1 | Varchar(40) | The value of the item stored in an alpha field. |
ValueLi | 3.6.1 | Number(10,0) | The value of the item stored in a long integer field. |
ValueLi2 | 3.6.1 | Number(10,0) | The value of the item stored in a long integer field. |
ValueLi3 | 3.6.1 | Number(10,0) | The value of the item stored in a long integer field. |
ValueLi4 | 3.6.1 | Number(10,0) | The value of the item stored in a long integer field. Currently this is used for Excused Attendance code for a particular school. |
ValueR | 3.6.1 | Float | The value of the item stored in a real number field. |
ValueR2 | 3.6.1 | Float | The value of the item stored in a real number field. |
ValueT | 3.6.1 | CLOB | The value of the item stored in a text field. |
ValueT2 | 3.6.1 | CLOB | The value of the item stored in a text field. |
Value_X | 3.7.0 | BLOB | The value of the item stored in a BLOB field. |
YearID | 4.0.0 | Number(10,0) | A number representing which year the term belongs to, such as 13 for 2003-2004. The number is equal to the ID of the year term divided by 100. Maintained in the Terms table. Indexed. |
SpedIndicator | 3.6.1 | Number(10,0) | Used to indicate for reporting if you need SPED kids. True=Yes SPED Kids False=No SPED kids. |