RB_RULE_DFN_TBL (SQL Table)	Index Back
Rules common information Table stored common information for all rules types.

RB_RULE_DFN_TBL

(SQL Table)

Rules common information

Table stored common information for all rules types.

Related Language Record: RB_RULE_DFN_LNG

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETID Character(5) VARCHAR2(5) NOT NULL This field is used to store the value of SetID on various setup tables.
Default Value: OPR_DEF_TBL_RB.SETID

2 RULE_ID Character(8) VARCHAR2(8) NOT NULL Field used for storing rule id information
Default Value: NEXT

3 RULE_TYPE Character(4) VARCHAR2(4) NOT NULL Field used for storing rule type information
BAR=Brings and Removes
BOC=Brings On Creation
CAIN=Commercial Attrs. Incompatible
CATR=Commercial Attrs. Restriction
CCVR=Commitment Covering
CEG=Commercial Eligibility
CIN=Commercial Incompatibility
CPRE=Commercial Prerequisite
CRF=Commercial Relies From
CRO=Commercial Relies On
CTRG=Commitment Triggering
FAIN=Functional Attrs. Incompatible
FIN=Functional Incompatibility
FRF=Functional Relies From
FRO=Functional Relies On

4 RULE_STATUS Character(3) VARCHAR2(3) NOT NULL Field used for storing rule status information
ACT=Active
INA=Inactive

5 RULE_SEVERITY Character(3) VARCHAR2(3) NOT NULL Field used for storing rule severity information
ERR=Error
WRN=Warning

6 RULE_EXCEPTION Long Character CLOB Field used for storing rule exception information

7 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

8 START_DATE Date(10) DATE Start Date for Gen Standing PO

9 END_DATE Date(10) DATE End date field to store an end date.

10 ROW_ADDED_DTTM DateTime(26) TIMESTAMP This is a datetime field for record creation.

11 ROW_ADDED_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who added the row.

12 ROW_LASTMANT_DTTM DateTime(26) TIMESTAMP The date and time that the row was last updated.

13 ROW_LASTMANT_OPRID Character(30) VARCHAR2(30) NOT NULL ID of user who last modified the row.

14 SYNCID Number(10,0) DECIMAL(10) NOT NULL The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.

15 SYNCDTTM DateTime(26) TIMESTAMP Synchronization Last Update Date Time

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETID	Character(5)	VARCHAR2(5) NOT NULL	This field is used to store the value of SetID on various setup tables. Default Value: OPR_DEF_TBL_RB.SETID
2	RULE_ID	Character(8)	VARCHAR2(8) NOT NULL	Field used for storing rule id information Default Value: NEXT
3	RULE_TYPE	Character(4)	VARCHAR2(4) NOT NULL	Field used for storing rule type information BAR=Brings and Removes BOC=Brings On Creation CAIN=Commercial Attrs. Incompatible CATR=Commercial Attrs. Restriction CCVR=Commitment Covering CEG=Commercial Eligibility CIN=Commercial Incompatibility CPRE=Commercial Prerequisite CRF=Commercial Relies From CRO=Commercial Relies On CTRG=Commitment Triggering FAIN=Functional Attrs. Incompatible FIN=Functional Incompatibility FRF=Functional Relies From FRO=Functional Relies On
4	RULE_STATUS	Character(3)	VARCHAR2(3) NOT NULL	Field used for storing rule status information ACT=Active INA=Inactive
5	RULE_SEVERITY	Character(3)	VARCHAR2(3) NOT NULL	Field used for storing rule severity information ERR=Error WRN=Warning
6	RULE_EXCEPTION	Long Character	CLOB	Field used for storing rule exception information
7	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
8	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
9	END_DATE	Date(10)	DATE	End date field to store an end date.
10	ROW_ADDED_DTTM	DateTime(26)	TIMESTAMP	This is a datetime field for record creation.
11	ROW_ADDED_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who added the row.
12	ROW_LASTMANT_DTTM	DateTime(26)	TIMESTAMP	The date and time that the row was last updated.
13	ROW_LASTMANT_OPRID	Character(30)	VARCHAR2(30) NOT NULL	ID of user who last modified the row.
14	SYNCID	Number(10,0)	DECIMAL(10) NOT NULL	The Synchronization ID field stores a value generated by the sync processor. The value is used to identify the type of object that the sync processor is about to handle.
15	SYNCDTTM	DateTime(26)	TIMESTAMP	Synchronization Last Update Date Time