Table Descriptions:

Table Name Use
Fin_Curr_Summary Use this when you need summary financial data from the most current monthly cycle.
Fin_All_Summary Use this when you need summary financial data from multiple or past cycles.
Fin_Curr_Object Use this when you need financial data at the object code level of detail from the most current monthly cycle.
Fin_All_Object Use this when you need financial data at the object code level of detail from multiple or past cycles.
Fin_Curr_Adjustments Use this when you need to review financial adjustments from the most current monthly cycle.
Fin_All_Adjustments Use this when you need to review financial adjustments from multiple or past cycles.
Fin_All_Budget Use this when you need summary budget data from the current or past budget cycles.
Fin_All_Budget_Trans Use this when you need to review budget transactions from the current or past budget cycles.
Fin_All_Asset Use this when you need annual plant asset data.
Stf_Payroll Use this when you need summary Payroll data from the current or past budget cycles.
Stf_Payroll_by_Account Use this when you need to review Payroll detail information from the current or past budget cycles.
Stf_Payroll_Provision_Title Use this when you need to review Provision detail information from the current or past budget cycles.
Stf_Payroll_Title_Rate Use this when you need to review Title Code information for the current or past budget cycles.
Stf_Provision Use this when you need summary Provision data from the current or past budget cycles.
Stf_Provision_by_Account Use this when you need to review Provision detail information from the current or past budget cycles.
Stf_Title_Code Use this when you need to review Title Code information for the current or past budget cycles.

 

October 11, 2007