CodeSet (ver12.0.0)
This is a general-purpose table for storing code sets used in various parts of PowerSchool.
Note: This table is for internal use only and is designed to be flexible enough so that other projects may use it to store code sets.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| AlternateCode1 | 12.0.0 | Varchar2(40) | The primary alternate code value as defined by PowerSchool or the user. Optional. |
| AlternateCode2 | 12.0.0 | Varchar2(40) | The secondary alternate code value as defined by PowerSchool or the user. Optional. |
| ChangeValidation | 20.4.0 | Varchar2(256) | The name of a PowerQuery that validates changes and/or deletions of records in this codeset. Optional. |
| Code | 12.0.0 | Varchar2(40) | The code value that is stored in the database, such as Home and Work for phone types and M and F for gender types. Indexed with the CodeType column. Required |
| CodeOrigin | 12.0.0 | Varchar2(40) | Indicates the organization (PowerSchool or the user) that defined the code. Required. |
| CodeSetID | 12.0.0 | Number(16,0) | Unique sequential number generated by the application. Indexed. Required. |
CodeType | 12.0.0 | Varchar2(20) | A code that describes the group of values. Indexed with DisplayValue column. Required. |
| Description | 12.0.0 | Varchar2(2000) | Description of the code set. Optional. |
| DisplayValue | 12.0.0 | Varchar2(100) | The value that displays in the codeset dropdowns, such as Home and Work for phone types and Male and Female for gender types. If the value is null the Code field value is used for display. Optional |
| EffectiveEndDate | 12.0.0 | Date | The date the code is no longer valid. Optional. |
| EffectiveStartDate | 12.0.0 | Date | The date the code becomes valid. Optional. |
ExcludeFromStateReporting | 12.1.0 | Number(1,0) | Indicates whether a code set item is excluded from State Reporting. Valid values: 1=True, 0=False. Default 0. Required. |
| IsDeletable | 12.0.0 | Number(1,0) | Indicates whether or not administrators can delete the code values. Valid values: 1=True, 0=False. Default 1. Required. |
| IsModifiable | 12.0.0 | Number(1,0) | Indicates whether or not administrators can modify the code values. Valid values: 1=True, 0=False. Default 1. Required. |
| IsVisible | 12.0.0 | Number(1,0) | Indicates whether or not administrators can view the values code. Valid values: 1=True, 0=False. Default 1. Required. |
| OriginalCodeType | 12.1.0 | Varchar2(20) | Does not appear on any PowerSchool pages. Used to hold the value of CodeSet.CodeType when retiring (effectively deleting) a code set item for historical tracking. |
| ParentCodeSetID | 12.0.0 | Number(16,0) | Reference to the Parent Code Set ID. Indexed. Null indicates this is a CodeSet Category. |
| ReportedValue | 12.0.0 | Varchar(40) | Value that can be exported into other systems. Optional. |
| UIDisplayOrder | 12.0.0 | Number(4,0) | The order by which the code values display in the application. Optional. |
| WhenCreated | 12.0.0 | Timestamp(6) | The date and time the record was created. Defaults to system date. Required. |
| WhenModified | 12.0.0 | Timestamp(6) | The date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 12.0.0 | Varchar2(100) | The name of the person who created the record. Defaults to user. Required. |
WhoModified | 12.0.0 | Varchar2(100) | The name of person who modified the record. Defaults to user. Required. |