SCC_RULE_IDSCC_RULE_VERSIONSCC_RULE_SEQNUMSCC_ENTITY_IDSCC_PROP_NAME10=String
20=Number
30=Datetime
40=Date
50=Time
SCC_RULE_EDSDTV(SQL View) |
Index Back |
|---|---|
Rules Engine EDS ViewThis view is created to show all the properties for a data set to be used in the rules engine tester. |
| SELECT ' ' , 0 , 0 , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' , ' ' FROM PS_SCC_RULE_HDR |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SCC_RULE_ID |
Character(40) | VARCHAR2(40) NOT NULL | This field is the Rule ID for rules used in the Rules Engine |
| 2 | SCC_RULE_VERSION |
Number(3,0) | SMALLINT NOT NULL | This field is the version of a rule or rule group in the rules engine. |
| 3 | SCC_RULE_SEQNUM |
Number(4,0) | SMALLINT NOT NULL | This field is a sequence number used to create a unqiue key in the Rules Engine setup |
| 4 | SCC_ENTITY_ID |
Character(40) | VARCHAR2(40) NOT NULL | Entitiy ID |
| 5 | SCC_PROP_NAME |
Character(50) | VARCHAR2(50) NOT NULL | Property Name |
| 6 | FIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 7 | SCC_PROP_LABEL | Character(50) | VARCHAR2(50) NOT NULL | Label |
| 8 | SCC_PROP_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Property Type
10=String 20=Number 30=Datetime 40=Date 50=Time |
| 9 | SCC_LOV_UID | Character(40) | VARCHAR2(40) NOT NULL | LOV Unique ID |
| 10 | SCC_RULE_FLEX_OBJ | Character(91) | VARCHAR2(91) NOT NULL | This field is the value of the used in the processing of rules for the Rules Engine |