SCC_RULE_DS_DVW

(SQL View)
 Index Back

Rules Engine Data Set Details

This view is used to track the data set property values on default values for variables in the rules engine.

SELECT ' ' ,' ' ,' ' ,' ' ,' ' FROM PS_INSTALLATION

  • Parent record: SCC_RULE_DS_HDR

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SCC_PROP_NAME Character(50) VARCHAR2(50) NOT NULL Property Name
    2 SCC_PROP_DEFAULT Character(254) VARCHAR2(254) NOT NULL Property Default
    3 SCC_LOV_UID Character(40) VARCHAR2(40) NOT NULL LOV Unique ID
    4 SCC_PROP_LABEL Character(50) VARCHAR2(50) NOT NULL Label
    5 SCC_PROP_TYPE Character(2) VARCHAR2(2) NOT NULL Property Type
    10=String
    20=Number
    30=Datetime
    40=Date
    50=Time