SCC_RULE_STATEMENTPrompt Table: PSPNLDEFN_VW
Prompt Table: PSRECDEFN_VW
Y/N Table Edit
Default Value: N
SCC_RULE_ST_TBL(SQL Table) |
Index Back |
|---|---|
Rules Engine StatementsThis table contains the definition and attributes of statements used in the rules engine. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_RULE_STATEMENT |
Character(40) | VARCHAR2(40) NOT NULL | This field is used to identify the type of statement used in the rules calculation for the Rules Engine |
| 2 | SCC_RULE_STMT_NAME | Character(30) | VARCHAR2(30) NOT NULL | This field is the name of the statement used in the rule engine. |
| 3 | SCC_DESCR | Character(254) | VARCHAR2(254) NOT NULL | This field is a long description field used in Campus Community |
| 4 | SCC_APPCLASSNAME | Character(190) | VARCHAR2(190) NOT NULL | Used to represent an application class as a single string. Usually RTRIM(PACKAGEROOT) + ':' + RTRIM(QUALIFYPATH) + ':' + RTRIM(APPCLASSID) |
| 5 | SCC_RULE_SEC_TITLE | Character(50) | VARCHAR2(50) NOT NULL | This page contains the title used for the secondary search pages for statements used in the rules engine. |
| 6 | PNLNAME | Character(30) | VARCHAR2(30) NOT NULL |
Page Name (see PSPNLDEFN).
Prompt Table: PSPNLDEFN_VW |
| 7 | RECNAME | Character(15) | VARCHAR2(15) NOT NULL |
Record (Table) Name (see PSRECDEFN).
Prompt Table: PSRECDEFN_VW |
| 8 | SCC_RULE_ENCM_STMT | Character(1) | VARCHAR2(1) NOT NULL |
This field is a Y/N field used to identify if a statement is an encompassing statement, which means it has statements encompassed below it, like an IF or FOR statement.
Y/N Table Edit Default Value: N |
| 9 | SCC_ROW_ADD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Created By |
| 10 | SCC_ROW_ADD_DTTM | DateTime(26) | TIMESTAMP | Created |
| 11 | SCC_ROW_UPD_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Updated By |
| 12 | SCC_ROW_UPD_DTTM | DateTime(26) | TIMESTAMP | Last Update Date/Time |