SCC_RULE_RC_BCR

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	OPRID	Character(30)	VARCHAR2(30) NOT NULL	A user's ID (see PSOPRDEFN).
2	RUN_CNTL_ID	Character(30)	VARCHAR2(30) NOT NULL	Run Control ID
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_CONNECTOR	Character(3)	VARCHAR2(3) NOT NULL	This field is the connector value used in defining rules in the Rules Engine AND=And OR=Or
6	SCC_PROP_NAME	Character(50)	VARCHAR2(50) NOT NULL	Property Name Prompt Table: SCC_ENT_PROP_VW
7	SCC_RULE_OPERATOR	Character(2)	VARCHAR2(2) NOT NULL	This field is the operator used in the defintion of rules in the Rules Engine <=Less Than <==Less Than or Equal To <>=Not Equal ==Equal >=Greater Than >==Greater Than or Equal To AD=As Of Date EX=Exists IN=In LI=Like NE=Not Exists NI=Not In NL=Not Like SF=First Effective Sequence SL=Last Effective Sequence Default Value: =
8	SCC_RULE_FLEX_TYP1	Character(2)	VARCHAR2(2) NOT NULL	This field is used to identify the type of object for the following value in the rules engine 10=Text 20=Number 30=Datetime 40=Date 50=Time 55=True/False 60=Entity 65=Data Set 70=Property 75=Data Set Property 80=Variable
9	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
10	SCC_RULE_PARENS	Character(5)	VARCHAR2(5) NOT NULL	This field is used to hold the parenthesis values used in processing rules for the Rules Engine