Payment and Payment Schedule

sourav.guha at 16h42
26
Nov
2010
Payment and Payment Schedule

Hi,

I'm trying to model a DW for a Payment model from a transactional DB. I have 3 tables of Payment, Payment Schedule and Payment Instrument. I have to keep the history of all of them. Payment schedule can be "Onetime Real Time", "Onetime Future Dated", "Recurring". Once the Payment Due Date is reached it post the payment in the Payment Table and a new record is created in the Payment Schedule and the old recor

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Modelling a payment schedule
I'm creating a DW that will contain data on financial securities such as bonds and loans. These securities are associated with payment schedules. For example, a bond could pay quarterly, while a mortage would usually pay monthly (sometimes biweekly). The
data as an attribute on a dimension or a key on the fact table
Hi, I am in the process of trying to model a mortgage (origination/servicing) data mart. For requirements all I was given at this point is a spreadsheet of attributes. My plan was to try and pull out dimensions and metrics from the list and then have a
GPTCash4.me Payment Proof
1st Payment
SHBUX - Instant Payment
Standard Member Instantly 1 x Paid
MoneyBUX Instant Payment
Update 3rd Instant Payment
Forums from same category
See also
more_less
Informations

3 Replies For the topic :
"Payment and Payment Schedule"

This topic has been viewed 1132 times.

Last message :
26/11/2010 at 16h42 by "sourav.guha"