Skip to main content
Planview Customer Success Center

Where are fixed fee schedule items stored in the database?

Both fixed fees and fixed fee schedule items are stored in the same database table "FixedFeeSchedule" and thus share all the fields (name/deliverable, billable, billing date ...).

To differentiate, there are two extra columns:

  • ScheduleItem:  0 for a fixed fee, 1 for a fixed fee schedule item
  • ParentFixedFeeId: The '0000...' GUID for a fixed fee, the FixedFeeId of the parent fixed fee for a schedule item.