PS_Common_Code (ver6.1.0.2)
This state reporting table contains state common look up codes, such as Lunch status, Parent/Guardian education level, etc.
Note: This table was first made available with the release of SR100115.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Alt_Report_Code | 6.1.0.2 | Varchar2(50) | The alternate code used in state reporting. |
Category | 6.1.0.2 | Varchar2(50) | The category to which the code belongs, such as Lunch Status. Required. |
Code | 6.1.0.2 | Varchar2(30) | The value of the code. Required. |
Created_By | 6.1.0.2 | Varchar2(30) | The name of the person who created the record. Defaults to the user. |
Created_TS | 6.1.0.2 | Timestamp(6) | The date and time the record was created. Defaults to the system date. |
Default_Value | 6.1.0.2 | Number(2) | 1 indicates default code value for the category |
Description | 6.1.0.2 | Varchar2(400) | The description of the code. Required. |
Effective_Enddate | 6.1.0.2 | Date | The date when this code expires. Defaults to 09/09/9999. |
Effective_Startdate | 6.1.0.2 | Date | The date when this code is effective. Defaults to system date. |
Last_Modified_By | 6.1.0.2 | Varchar2(30) | The name of person who modified the record. Defaults to the user. |
Last_Modified_TS | 6.1.0.2 | Timestamp(6) | The date and time the record was modified. Defaults to the system date. |
ParentCategoryID | 9.0.1 | Number(11) | The internal number for the associated PS_Common_Code record. First available in State Reporting Installer 15.7.0. |
Ps_Common_Code_ID | 6.1.0.2 | Number(11) | Unique identifier for this table. Required. |
Ps_Group | 6.1.0.2 | Varchar2(30) | The group to which this code belongs. For states, this is the state ID, such as CA, NE, etc. Required. |
SortOrder | 6.1.0.2 | Number(3) | The order in which the code appear for this category. Starts with 1. |