PlatformProduct (Ver 22.5.0)
The table stores metadata about of-interest products registered with the SIS. This is a system reference table.
Column Name | Initial Version | Data Type | Description |
|---|---|---|---|
| ID | 22.5.0 | NUMBER(19,0) | Unique identifier for this table. Required. |
| IsEnabled | 22.5.0 | NUMBER(1,0) | Product is enabled or not. Required. Valid values are 1=Enabled, 0=Disabled |
| OrganizationID | 22.5.0 | VARCHAR2(256 CHAR) | Organization Id configured in auth0 for the specific district. Required. |
| ProductLinkURL | 22.6.0 | VARCHAR2(256 CHAR) | URL of the product. Optional. |
| ProductName | 22.5.0 | VARCHAR2(256 CHAR) | Name of the product. Required. |
| WhenCreated | 22.5.0 | TIMESTAMP(6) | The date and time the record was created. Defaults to system date. Required. |
| WhenModified | 22.5.0 | TIMESTAMP(6) | The date and time the record was modified. Defaults to system date. Required. |
| WhoCreated | 22.5.0 | VARCHAR2(100 CHAR) | The name of the person who created the record. Defaults to the user. Required. |
| WhoModified | 22.5.0 | VARCHAR2(100 CHAR) | The name of the person who modified the record. Defaults to the user. Required. |