RPC_COMC_DURAVW

(SQL View)
 Index Back

Commitment Triggering Rule

Record used for storing commitment products

SELECT a.SETID , a.RULE_ID , a.PRODUCT_ID , a.REL_RULE_ID , a.RB_DURA_OPT_ID , a.RB_DURA_OPT_VALUE , a.SELECTED_FLAG , a.UNIT_OF_MEASURE FROM PS_RB_RL_DUOPT_TBL a , PS_RB_RULE_DFN_TBL b WHERE a.SETID = b.SETID AND a.REL_RULE_ID = b.RULE_ID AND b.RULE_STATUS = 'ACT' AND a.SELECTED_FLAG = 'Y'

# 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 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
4 REL_RULE_ID Character(8) VARCHAR2(8) NOT NULL Field used for storing related rule id information
5 RB_DURA_OPT_ID Number(3,0) SMALLINT NOT NULL Filed used for storing Duration Option id value
6 RB_DURA_OPT_VALUE Number(3,0) SMALLINT NOT NULL Field used for storing Duration Option Value
7 SELECTED_FLAG Character(1) VARCHAR2(1) NOT NULL Selected Flag
N=NO
Y=YES

Y/N Table Edit

8 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
CS=Case
EA=Each
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage