RPC_LHSRHS_RULE

#	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.
2	RULE_ID	Character(8)	VARCHAR2(8) NOT NULL	Field used for storing rule id information
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	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
6	START_DATE	Date(10)	DATE	Start Date for Gen Standing PO
7	END_DATE	Date(10)	DATE	End date field to store an end date.
8	RULE_SEVERITY	Character(3)	VARCHAR2(3) NOT NULL	Field used for storing rule severity information ERR=Error WRN=Warning
9	RULE_SCOPE	Character(4)	VARCHAR2(4) NOT NULL	Field used for storing rule scope information CNTR=Contract DPAR=Direct Parent EXTS=External Service INST=Instance OCNT=Other Contract OCST=Other Customer PLAY=Play SCST=Same Customer
10	RULE_COMM_BEHAV	Character(3)	VARCHAR2(3) NOT NULL	Field used for storing Rule Commitment Behaviour CRT=Create EXT=Extend RNW=Renew
11	RULE_COMM_MNDT	Character(1)	VARCHAR2(1) NOT NULL	Field used for storing Rule Commitment Mandatory
12	RULE_LHS_DFN_LONG	Long Character	CLOB	Field used for storing left hand side rule definition in long format