CS_RULE_EXP

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
2	CS_RULE_ID	Character(20)	VARCHAR2(20) NOT NULL	t
3	EFFDT	Date(10)	DATE	Effective Date Default Value: %date
4	SEQ_NBR	Number(15,0)	DECIMAL(15) NOT NULL	Sequence Number
5	OPEN_BRCKT	Character(2)	VARCHAR2(2) NOT NULL	Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific data 01=( 02=(( 03=((( 04=((((
6	CS_BIND_VAR	Character(30)	VARCHAR2(30) NOT NULL	Bind Variable Prompt Table: CS_BINDS_VW2
7	COMPARE_OPERATOR	Character(3)	VARCHAR2(3) NOT NULL	Compare Operator BTW=Between EQ== EX=Exist GE=>= GT=> LE=<= LK=Like LT=< NBW=Not Between NE=<> NEX=Not Exist NLK=Not Like Prompt Table: CS_COMP_OPR_VW
8	VALUE_NBR	Signed Number(33,8)	DECIMAL(31,8) NOT NULL	Numeric Value
9	VALUE_INTEGER	Signed Number(24,0)	DECIMAL(23) NOT NULL	Interger
10	VALUE_CHAR	Character(254)	VARCHAR2(254) NOT NULL	VALUE CHARACTER
11	VALUE_DATE	Date(10)	DATE	VALUE DATE
12	VALUE_DTTM	DateTime(26)	TIMESTAMP	DateTime Value
13	CLOSE_BRCKT	Character(2)	VARCHAR2(2) NOT NULL	Represents SQL parentheses syntax for purposes of precedence when the user is creating node specific dat 01=) 02=)) 03=))) 04=))))
14	AND_OR_TXT	Character(3)	VARCHAR2(3) NOT NULL	Represents 'AND' or 'OR' SQL operator syntax when the user is creating node specific data selection criteria wi AND=AND OR=OR
15	ADVANCED_FLG	Character(1)	VARCHAR2(1) NOT NULL	Advanced/Complex Rule
16	SORT_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Sort Sequence Number