SCC_RULE_STMT

#	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_CATEGORY	Character(40)	VARCHAR2(40) NOT NULL	Rule Category for the Rules Engine
7	SCC_RULE_CP_ID	Character(40)	VARCHAR2(40) NOT NULL	This field is the Rule ID for rules used in the Rules Engine
8	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
9	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.
10	SCC_RULE_VAR_NAME	Character(30)	VARCHAR2(30) NOT NULL	This field is the name of the variable used by the Rules Engine
11	SCC_RULE_VAR_NAME2	Character(30)	VARCHAR2(30) NOT NULL	This field is the name of the variable used by the Rules Engine
12	SCC_RULE_LIST_ROPT	Character(1)	VARCHAR2(1) NOT NULL	This field is used to identify which method a user wants to delete a list value in the rules engine 1=End of the List 2=Front of the List 3=Position in the List
13	SCC_RULE_SORT_ORDR	Character(1)	VARCHAR2(1) NOT NULL	This field is used to identify if a sort key is to be sorted in ascending or descending mode. 1=Ascending 2=Descending
14	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.
15	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.
16	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
17	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
18	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
19	SCC_RULE_LOOP_CNTL	Character(1)	VARCHAR2(1) NOT NULL	This field is used to control the for each loop by using either a list of entities or a variable list. 1=Entity Processing 2=List Variable
20	SCC_ROW_ADD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Created By
21	SCC_ROW_ADD_DTTM	DateTime(26)	TIMESTAMP	Created
22	SCC_ROW_UPD_OPRID	Character(30)	VARCHAR2(30) NOT NULL	Updated By
23	SCC_ROW_UPD_DTTM	DateTime(26)	TIMESTAMP	Last Update Date/Time
24	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.
25	SCC_RULE_DESCRHTML	Long Character	CLOB	This field contains the description of the statement to show to user on the rules engine main page.