Data Model for Recruiting
2 posters
Page 1 of 1
Data Model for Recruiting
I am working on a data model for recruiting and had some questions.
I am currently planning to have an accumulating snapshot fact table for candidates, updating the fact table as they hit milestones in their candidacy. What would be the best way to handle a candidate reapplying, or applying for multiple roles at once? I'll have a role dimension and a date applied dimension, so will that be enough to handle both reapplications and multiple role applications? Should I also have a transaction fact table at the level of a candidate's status per search per date applied?
As a candidate goes through the process, they get evaluated at various stages for a variety of things (thinking qualities, culture fit, etc) that vary based on the search. I was planning on capturing that in a separate transaction fact table with the role, date applied, and candidate info, in addition to a couple other dimensions. Does that make sense? I think that would allow me to drill across both fact tables.
I am currently planning to have an accumulating snapshot fact table for candidates, updating the fact table as they hit milestones in their candidacy. What would be the best way to handle a candidate reapplying, or applying for multiple roles at once? I'll have a role dimension and a date applied dimension, so will that be enough to handle both reapplications and multiple role applications? Should I also have a transaction fact table at the level of a candidate's status per search per date applied?
As a candidate goes through the process, they get evaluated at various stages for a variety of things (thinking qualities, culture fit, etc) that vary based on the search. I was planning on capturing that in a separate transaction fact table with the role, date applied, and candidate info, in addition to a couple other dimensions. Does that make sense? I think that would allow me to drill across both fact tables.
RecruitingDW- Posts : 1
Join date : 2015-11-26
Re: Data Model for Recruiting
A good recruiting system will not allow a person reapply a job which he already applied for ( unless that job opening was closed and opened again). So check with that application admin about reapplying. Your Accum fact table should be driven from the transaction fact table. You are in good position if you have those 2 fact tables.
zoom- Posts : 97
Join date : 2010-08-23
Location : Chicago

» Tracking of historical data using SCD2 in a non-dimensional data model
» data model architecture for economic forecast data
» Canonical Data Model for Data warehouse
» Model Data
» Data Model
» data model architecture for economic forecast data
» Canonical Data Model for Data warehouse
» Model Data
» Data Model
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|