Personnel Data Warehouse Table Descriptions: Dep/Campus/Lab Domain
Note: the Dependent file views only include employee-level data from the Snapshot database. There is currently no Dependent table view that also includes appointment and distribution data.
| Table Name | When to Use |
| Per_Snap_Curr_Dependent | Use this when you need dependent data from the most current monthly cycle. This table includes some employee data, so you may be able to use this without joining to the Per Snap Curr Empl table. |
| Per_Snap All_Dependent |
Use this when you need dependent data from previous cycles. This table includes some employee data, so you may be able to use this without joining to the Per Snap Curr Empl table. The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000). |
| Per_CmpLab_Dep_Curr | Use this when you need dependent data from the most current monthly cycle, and the Dependent tables above do not have enough Employee level data to meet your needs. |
| Per_CmpLab_Dep_All |
Use this when you need dependent data from previous cycles, and the Dependent tables above do not have enough Employee level data to meet your needs. The Effective Date (Eff Date) must be selected to extract data from the proper cycle (e.g., OCT2000). |
Last Updated: April 9, 2003
Return to Personnel Data Warehouse Home Page