Cycles Available as of November 13,
2009:
Snapshot:
Monthly cycles from
July 2000 through preliminary October 2009, October final cycles from October 1989
through October 2008 (excluding October 1991 and 1995)
Note:
All snapshots cycles are placed in the ALL table once the cycle is considered
final. The only table which contains preliminary data is the CURRENT
table (e.g, Per_Snap_Curr).
Listing
of all Snapshot cycles available, with some comments pertinent to specific
cycles
Fiscal
Year: Complete
Fiscal year cycles from final June 1998 through final June 2009; current FY is October 2009
Note:
Previous fiscal year cycles are placed in the ALL table once the cycle
is considered final. Current FY data is available in the Per_FY_Current
table and is updated monthly.
Listing
of all Fiscal year cycles available, with some comments pertinent to
specific cycles
Fiscal
Year Summary Table:
Complete Fiscal year cycles from final June 2003 through final June
2009; current FY Summary table is October
2009
Note:
Previous fiscal year cycles are placed in the ALL table once the cycle
is considered final. Current FY data is available in the Per_FY_Current_Summary
table and is updated monthly. The Fiscal Year Summary Table is summarized
at a higher level of detail than the Fiscal Year table, and does not
contain as many data elements.
Listing
of all Fiscal year summary cycles available, with some comments pertinent
to specific cycles
Fiscal
Year/Financial Attribute View:
Fiscal year cycles from final June 1998 through final June 2005
Note:
Previous fiscal year cycles are combined with financial attribute data
once the cycle is considered final. The Fiscal Year/Financial
Attribute Table is only updated when the fiscal year is final.
Due to the fact that the tables are joined by account and fund number,
FY records with no matching account or fund in the financial attribute
table are not included in this view.
Listing
of all Fiscal year/financial attribute cycles available, with some comments pertinent
to specific cycles
Dependent
Data:
Monthly cycles from July 2000 through October 2009
Note:
All Dependent cycles are placed in the ALL table once the cycle is final.
The only table which contains preliminary data is the CURRENT
table (e.g, Per_Snap_Curr_Dependent)
Listing
of all Dependent data cycles available, with some comments pertinent
to specific cycles
Title Code/Rates Data:
Note: Title code data is updated each month, or more frequently upon
request of the HR&B Compensation unit. We do not store title code
data for each month in separate tables or cycles. Rates are
effective as of the date of the extract from TCS, unless otherwise
noted.
Appointment
data in the Snapshot and Fiscal Year tables is matched to TCS each month
when the database is built, so it reflects the Title Code attributes
(such as CTO, Salary Range Maximum, Title Unit code TCS, etc.) that were
in effect at the time.
|
Last
Updated |
Comments |
|
November 12, 2009 |
TCS data is always the most recent
data in the Title Code System at the time of the last extract. |
Address
Data:
Note:
Address data is updated each month with the most recent address data
we have received for employees whose records are included in the current
fiscal year file. We do not store address data for each month in separate
tables. There are views which combine address data with snapshot data
from various months; the address data is the most current that we have
for each employee, regardless of which cycle of snapshot data is used.
|
Cycle
|
Comments
|
|
October
2009
|
Check Eff_Date in the Address table to see which cycle is
current at any given time.
Email address was first added to this table for January 2004
cycle.
|
