Base View idvTFPeriod

Description

This view exposes the rows in TFPeriod that represent time ledger and fees ledger periods.

Type = Base view present to support commonality, not normally intended for end user use

 

Columns

LedgerType 1 for Fees, 3 for Time
Year The year part of the period
Number The period number within the year
StartDate Period start date
EndDate Period end date
Status

The period status

  • A = Available for general posting
  • C = Closed, cannot be posted to
  • R = In reconciliation
  • P = Not yet posted to (time ledger only)


WhoCreated The internal identifier of the staff member who created the object
WhenCreated When the object was created
WhoLoggedStatus The internal identifier of the staff member who logged the latest status change to the object
WhenStatusLogged When the latest status change to the object actually happened

 

This view is directly inherited by the following views: