CST_PUBFIELDRULE (ver 15.5.1)
This table is a standalone table and stores information and rules pertaining to whether a profile should consume/process specific transactions. This table is available for all states/provinces and may or may not be utilized for your state/province.
Column Name | Version | Data Type | Description |
|---|---|---|---|
ID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBFIELDRULE record to which the record is associated. Required. (Default – Next value in CST_PUBFIELDRULE_SQ sequence) |
CST_PUBPROFILEID | 15.5.1 | NUMBER(19,0) | The internal ID for the CST_PUBPROFILE record to which the record is associated. Required. |
PSTABLENAME | 15.5.1 | VARCHAR2(30) | The name of the PowerSchool table that we want to have a rule. Required. |
IDENTITYCOLUMNNAME | 15.5.1 | VARCHAR2(30) | The name of the identity column in the PowerSchool table we want to have a rule. Required. |
TRANSPROCPACKAGE | 15.5.1 | VARCHAR2(30) | The name of the package that will process the transactions. Required. |
TRANSPROC | 15.5.1 | VARCHAR2(30) | The name of the procedure that will be called to process the transactions. Required. |
ACTIVE | 15.5.1 | NUMBER(1,0) | A flag used to specify if the field rule is enabled/active or disabled/inactive. (i.e. 0-Inactive, 1-Active) (Default 1-Active) |