SSR_RSLT_RULE

(SQL View)
 Index Back

Result Type Rule


SELECT rh.SCC_RULE_ID , rh.SCC_RULE_NAME , rt.SSR_PE_RULE_TYPE , rt.DESCR , rt.SCC_RULE_GROUP_ID , rg.SCC_RULE_GROUP_NM , gc.SCC_RULE_CATEGORY , rc.SCC_RULE_CAT_NAME , rh.SCC_ENTITY_ID , en.SCC_ENTITY_NAME FROM PS_SSR_RULETYP_TBL rt , PS_SCC_RULEGR_HDR rg , PS_SCC_RULE_CAT_RG gc , PS_SCC_RULE_CAT rc , PS_SCC_RULE_HDR rh LEFT OUTER JOIN PS_SCC_ENTITY_PT en ON rh.SCC_ENTITY_ID = en.SCC_ENTITY_ID WHERE rt.SSR_RTYPE_USE_APT = '20' AND rt.SCC_RULE_GROUP_ID = rg.SCC_RULE_GROUP_ID AND rg.SCC_RULE_VERSION = ( SELECT MAX(rg1.SCC_RULE_VERSION) FROM PS_SCC_RULEGR_HDR rg1 WHERE rg1.SCC_RULE_GROUP_ID = rg.SCC_RULE_GROUP_ID) AND rg.SCC_RULE_STATUS = '2' AND rg.SCC_RULE_GROUP_ID = gc.SCC_RULE_GROUP_ID AND gc.SCC_RULE_CATEGORY = 'SCC_RULE_CAT_20130211055805' AND gc.SCC_RULE_CATEGORY = rc.SCC_RULE_CATEGORY AND rc.SCC_RULE_CATEGORY = rh.SCC_RULE_CATEGORY AND rh.SCC_RULE_GROUP_ID = rt.SCC_RULE_GROUP_ID AND rh.SCC_RULE_VERSION = ( SELECT MAX(rh1.SCC_RULE_VERSION) FROM PS_SCC_RULE_HDR rh1 WHERE rh1.SCC_RULE_ID = rh.SCC_RULE_ID) AND rh.SCC_RULE_STATUS = '2'

# 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_NAME Character(80) VARCHAR2(80) NOT NULL This field contains the name of the rule used in the Rules Engine
3 SSR_PE_RULE_TYPE Character(20) VARCHAR2(20) NOT NULL Rule Type
CALC=Grade Calculation
NAG=Enrollment Audit
PGRS=Progression
PREC=Pre-Condition
RETK=Retake
4 SSR_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used to hold a description in student records. This field is mixed case.
5 SCC_RULE_GROUP_ID Character(40) VARCHAR2(40) NOT NULL This field is the Rule Group ID for rule groups used in the Rules Engine

Prompt Table: SCC_RULEGR3VW

6 SCC_RULE_GROUP_NM Character(80) VARCHAR2(80) NOT NULL This field contains the name of the rule used in the Rules Engine
7 SCC_RULE_CATEGORY Character(40) VARCHAR2(40) NOT NULL Rule Category for the Rules Engine
8 SCC_RULE_CAT_NAME Character(30) VARCHAR2(30) NOT NULL Rule Name for the Rules Engine
9 SCC_ENTITY_ID Character(40) VARCHAR2(40) NOT NULL Entitiy ID
10 SCC_ENTITY_NAME Character(30) VARCHAR2(30) NOT NULL Entitiy Name