PS_Common_Code_Config (ver10.1.4)
This state reporting table contains information about which codes in the PS_Common_Code table are enabled for user management. The combination of Category and PS_Group columns forms a natural foreign key to the PS_Common_Code table (same named columns). However, this relation is not enforced by a constraint.
Note: This table was first made available with the release of SR170331.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
Add_Code_Permission | 10.1.4 | Number(1,0) | The boolean value indicating whether adding new codes is allowed for the user. |
Category | 10.1.4 | Varchar2(50) | The category to which the code belongs, such as Lunch Status. Required. |
Code_Alt_Rpt_Code_Permission | 10.1.4 | Number(1,0) | The boolean value indicating whether user is allowed to modify the alternate report code. |
Code_Default_Value_Permission | 10.1.4 | Number(1,0) | The boolean value indicating whether user is allowed to modify the default value. |
Code_Description_Permission | 10.1.4 | Number(1,0) | The boolean value indicating whether user is allowed to modify the code description. |
Code_Effective_Date_Permission | 10.1.4 | Number(1,0) | The boolean value indicating whether user is allowed to modify the effective dates. |
Code_Parent_Cat_Permission | 10.1.4 | Number(1,0) | The boolean value indicating whether user is allowed to modify the parent category. |
Code_Sort_Order_Permission | 10.1.4 | Number(1,0) | The boolean value indicating whether user is allowed to modify the sort order. |
Code_Value_Permission | 10.1.4 | Number(1,0) | The boolean value indicating whether user is allowed to modify the code value. |
Description | 10.1.4 | Varchar2(400) | The description of the code. Required. |
| Multi_Default_Allowed | 10.1.4 | Number(1,0) | The boolean value indicating whether more than one default value is allowed (e.g., mult-select boxes). |
Ps_Common_Code_ConfigID | 10.1.4 | Number(11) | Unique identifier for this table. Required. |
Ps_Group | 10.1.4 | Varchar2(30) | The group to which this code belongs. For states, this is the state ID, such as CA, NE, etc. Required. |
UI_Permission | 10.1.4 | Number(1,0) | The boolean value indicating whether the code set identified by group and category is enabled for user management. |
WhenCreated | 10.1.4 | Timestamp(6) | Date and time the record was created. Defaults to system date. Required. |
WhenModified | 10.1.4 | Timestamp(6) | Date and time the record was modified. Defaults to system date. Required. |
WhoCreated | 10.1.4 | Varchar2(100) | The user login that created the record. Defaults to database user. Required. |
WhoModified | 10.1.4 | Varchar2(100) | The user login that modified the record. Defaults to database user. Required. |