January 10, 2007 at 8:24 am
i need help on this
Three Tables are as follows
GE_Transaction , GE_Claim , GE_Reserve.
Columns in GE_Transaction are as follows
PolicyNumber
CodeNumber
ProductType
TreatyID
Columns in GE_Claim are as follows
PolicyNumber
CodeNumber
EffectiveDate
LossDate
TreatyID
Columns in GE_Reserve are as follows
PolicyNumber
CodeNumber
WaiverofPremium
TreatyID
The TWo BusinessRules are as follows :
First BusinessRule
when TreatyID = 2 AND ProductType in GE_Transaction Table is " P2 "
and when
EffectiveDate <= '06/30/02 And LossDate <= '06/30/02' in the GE_cLAIM Table
Only in this case Waiverof Premium which exists in GE_Reserve Table will be Valued at 50%
second BusinessRule
when TreatyID = 2 AND ProductType in GE_Transaction Table is " P2 "
and when
EffectiveDate <= '06/30/02 And LossDate > '06/30/02' in the GE_cLAIM Table
Only in this case Waiverof Premium which exists in GE_Reserve Table will be Valued at 25%
Note:
Need of creating a temp table first and then store the results from the above business rule in it.
January 10, 2007 at 8:52 am
Hmmm... I'm not sure I follow you.
First, you did not mention datatypes of the columns, primary keys and other useful info about data contained in them. Second, you did not describe relations between these 3 tables (how these tables can be joined together).
Well, and then the rules ... I can understand the conditions, but what "Waiverofpremium will be valued at ..%" means? Do you want to write this info somewhere, or just display it with a query? Or does it mean that some column should be updated to hold x% of the original value?
Is the "Note" the actual requirement(=it must be done this way), or is it just some casual remark how someone thinks it could be done?
Please, try to supply the missing info about data structure and explain better what you would like to do, and what would you like to hear from us.
January 10, 2007 at 11:16 am
1. What have YOU come up with so far?
2. Why is there a requirement for a temporary table?
3. The way this is worded, especially the part about requiring a temporary table, makes this sound like schoolwork.
-SQLBill
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply