SCC_RULE_STM3VW (SQL View)	Index Back
Rules Engine Statements This view is used for generating reports on the rules engine using BI Publisher

SCC_RULE_STM3VW

(SQL View)

Rules Engine Statements

This view is used for generating reports on the rules engine using BI Publisher

SELECT A.SCC_RULE_ID , A.SCC_RULE_VERSION , A.SCC_RULE_SEQNUM , A.SCC_RULE_ORDER , A.SCC_RULE_STATEMENT , B.SCC_RULE_STMT_NAME , A.SCC_RULE_CATEGORY , C.SCC_RULE_CAT_NAME , A.SCC_RULE_CP_ID , D.SCC_RULE_NAME , A.SCC_RULE_GROUP_ID , F.SCC_RULE_GROUP_NM , A.SCC_RULE_STMT_ENT , E.SCC_ENTITY_NAME , A.SCC_RULE_INDENT_LV , A.SCC_RULE_PARENTSEQ , A.SCC_RULE_STMT_STTS , X.XLATLONGNAME , A.SCC_RULE_IMM_CHILD , A.SCC_RULE_OVRDDESCR , A.SCC_RULE_STMTDESCR , A.SCC_RULE_DESCRHTML FROM PS_SCC_RULE_STMT A LEFT OUTER JOIN PS_SCC_RULE_CAT C ON C.SCC_RULE_CATEGORY = A.SCC_RULE_CATEGORY LEFT OUTER JOIN PS_SCC_RULE_HDR D ON D.SCC_RULE_ID = A.SCC_RULE_CP_ID LEFT OUTER JOIN PS_SCC_ENTITY_REG E ON E.SCC_ENTITY_ID = A.SCC_RULE_STMT_ENT LEFT OUTER JOIN PS_SCC_RULEGR_HDR F ON F.SCC_RULE_GROUP_ID = A.SCC_RULE_GROUP_ID ,PS_SCC_RULE_ST_TBL B ,PSXLATITEM X WHERE A.SCC_RULE_STATEMENT = B.SCC_RULE_STATEMENT AND X.FIELDNAME = 'SCC_RULE_STMT_STTS' AND X.FIELDVALUE = A.SCC_RULE_STMT_STTS AND X.EFFDT = ( SELECT MAX(X1.EFFDT) FROM PSXLATITEM X1 WHERE X1.FIELDNAME = X.FIELDNAME AND X1.FIELDVALUE = X.FIELDVALUE AND X1.EFFDT <= %CurrentDateIn AND X1.EFF_STATUS = 'A')

Parent record: SCC_RULE_HDR3VW

# 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.
Default Value: 1

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_RULE_ORDER Number(4,0) SMALLINT NOT NULL This field is used to identify the order of the rows in the rules engine setup for the Rules Engine

5 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

6 SCC_RULE_STMT_NAME Character(30) VARCHAR2(30) NOT NULL This field is the name of the statement used in the rule 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_RULE_CP_ID Character(40) VARCHAR2(40) NOT NULL This field is the Rule ID for rules used in the Rules Engine

10 SCC_RULE_NAME Character(80) VARCHAR2(80) NOT NULL This field contains the name of the rule used in the Rules Engine

11 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

12 SCC_RULE_GROUP_NM Character(80) VARCHAR2(80) NOT NULL This field contains the name of the rule used in the Rules Engine

13 SCC_RULE_STMT_ENT Character(40) VARCHAR2(40) NOT NULL This field is used to assign entities when using for-each statements in the rules engine.

14 SCC_ENTITY_NAME Character(30) VARCHAR2(30) NOT NULL Entitiy Name

15 SCC_RULE_INDENT_LV Signed Number(4,0) DECIMAL(3) NOT NULL This field will track the indention level of the rules for nested statements such as IF and FOR EACH in the rules engine statements.

16 SCC_RULE_PARENTSEQ Number(3,0) SMALLINT NOT NULL this field is used to track the parent row in the statement display table for nested statements such as IF and FOR EACH.

17 SCC_RULE_STMT_STTS Character(1) VARCHAR2(1) NOT NULL This field holds the staus value for the statement in the rules engine
A=Active
I=Inactive
Default Value: A

18 SCC_RULE_SST_DESCR Character(30) VARCHAR2(30) NOT NULL This field is used for the rules engine report for the statement status description

19 SCC_RULE_IMM_CHILD Character(1) VARCHAR2(1) NOT NULL This is a Y/N field used to identify if a for each statement in the rules engine should only process the immediate child entities.
Y/N Table Edit
Default Value: N

20 SCC_RULE_OVRDDESCR Character(1) VARCHAR2(1) NOT NULL This is a Y/N field is used to identify if a auto-generated description for the rules engine statements should be overridden.
Y/N Table Edit
Default Value: N

21 SCC_RULE_STMTDESCR Long Character(2000) VARCHAR2(2000) This field contains the description of the statement to show to user on the rules engine main page.

22 SCC_RULE_DESCRHTML Long Character CLOB This field contains the description of the statement to show to user on the rules engine main page.

#	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. Default Value: 1
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_RULE_ORDER	Number(4,0)	SMALLINT NOT NULL	This field is used to identify the order of the rows in the rules engine setup for the Rules Engine
5	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
6	SCC_RULE_STMT_NAME	Character(30)	VARCHAR2(30) NOT NULL	This field is the name of the statement used in the rule 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_RULE_CP_ID	Character(40)	VARCHAR2(40) NOT NULL	This field is the Rule ID for rules used in the Rules Engine
10	SCC_RULE_NAME	Character(80)	VARCHAR2(80) NOT NULL	This field contains the name of the rule used in the Rules Engine
11	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
12	SCC_RULE_GROUP_NM	Character(80)	VARCHAR2(80) NOT NULL	This field contains the name of the rule used in the Rules Engine
13	SCC_RULE_STMT_ENT	Character(40)	VARCHAR2(40) NOT NULL	This field is used to assign entities when using for-each statements in the rules engine.
14	SCC_ENTITY_NAME	Character(30)	VARCHAR2(30) NOT NULL	Entitiy Name
15	SCC_RULE_INDENT_LV	Signed Number(4,0)	DECIMAL(3) NOT NULL	This field will track the indention level of the rules for nested statements such as IF and FOR EACH in the rules engine statements.
16	SCC_RULE_PARENTSEQ	Number(3,0)	SMALLINT NOT NULL	this field is used to track the parent row in the statement display table for nested statements such as IF and FOR EACH.
17	SCC_RULE_STMT_STTS	Character(1)	VARCHAR2(1) NOT NULL	This field holds the staus value for the statement in the rules engine A=Active I=Inactive Default Value: A
18	SCC_RULE_SST_DESCR	Character(30)	VARCHAR2(30) NOT NULL	This field is used for the rules engine report for the statement status description
19	SCC_RULE_IMM_CHILD	Character(1)	VARCHAR2(1) NOT NULL	This is a Y/N field used to identify if a for each statement in the rules engine should only process the immediate child entities. Y/N Table Edit Default Value: N
20	SCC_RULE_OVRDDESCR	Character(1)	VARCHAR2(1) NOT NULL	This is a Y/N field is used to identify if a auto-generated description for the rules engine statements should be overridden. Y/N Table Edit Default Value: N
21	SCC_RULE_STMTDESCR	Long Character(2000)	VARCHAR2(2000)	This field contains the description of the statement to show to user on the rules engine main page.
22	SCC_RULE_DESCRHTML	Long Character	CLOB	This field contains the description of the statement to show to user on the rules engine main page.