AB_CODE_VALUE
This table stores mapping codes from Alberta.
Column Name | Version | Data Type | Description |
|---|---|---|---|
AB_Code_ValueID | 13.0.0 | NUMBER(19,0) | Primary Key |
| Class_Name | 13.0.0 | Varchar2(60) | Identifies the name for a group of code values. |
| Code_Text | 13.0.0 | Varchar2(100) | Uniquely identifies a code value within a group of code values. |
| Description | 13.0.0 | Varchar2(1000) | The description of the code value. |
| Display_SEQ | 13.0.0 | NUMBER(19,0) | Indicates the position this record appears in the address list in ascending order. |
| Effect_School_Year | 13.0.0 | NUMBER(4,0) | The school year that this code is valid. |
| Expiry_School_Year | 13.0.0 | NUMBER(4,0) | The school year that this code becomes invalid. |
| PASI_CoreVersion | 13.0.0 | NUMBER(19,0) | Unique number allowing easy identification of when an entity has changed. |
| Short_Desc | 13.0.0 | Varchar2(250) | The short description of the code value. |
| WhenCreated | 13.0.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. |
| WhoModified | 13.0.0 | Varchar2(100) | The name of the person who modified the record. Defaults to the user. |
| WhenModified | 13.0.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. |