SCC_RULE_STATEMENTPrompt Table: PSPNLDEFN_VW
Prompt Table: PSRECDEFN_VW
Y/N Table Edit
Default Value: N
SCC_RULE_ST_VW2(SQL View) |
Index Back |
|---|---|
Rules Engine StatementsThis table contains the definition and attributes of statements used in the rules engine. |
| SELECT SCC_RULE_STATEMENT , SCC_RULE_STMT_NAME , SCC_DESCR , SCC_APPCLASSNAME , SCC_RULE_SEC_TITLE , PNLNAME , RECNAME , SCC_RULE_ENCM_STMT FROM PS_SCC_RULE_ST_TBL |
| # | 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 |