Modeling advice for hiring application scenario
2 posters
Page 1 of 1
Modeling advice for hiring application scenario
I need suggestions in modeling the below scenario based on the business rules mentioned below. Our Online application is primarily focused towards candidate sourcing and screening process.
Below is the hiring manager view, where he specifies how many positions he/she is looking to open. As soon as he puts a value greater than zero in either of the positions mentioned below, a new requisition ID should be created with a date on which the requisition is created. For e.g.; the hiring manager puts in the value of 2 under service Clerks, then the requisition ID of 101 and 102 are created and assigned to each of the applicants who are applying for the Service clerk position.
Business Rules -
Below are the two tables that I started with –
Applicant – User applying for open positions.
Requisition – A new requisition is created each time the Hiring manager creates an open position.
Hiring Manager view - For store 2345, Hiring manager created 2 openings for Service clerk, 1 opening for photo and 3 in Cosmetics
Store – 2345
Current Openings
Service Clerks 2 Photo 1 Cosmetics 3
Applicant –
Application ID Position Name Requisition ID
1 Service Clerk 101, 102
2 Service Clerk 101,102
3 Service Clerk 101,102
Requisition -
Requisition ID Requisition
Date End Date
101 12/18/2012 12/20/2012
102 12/18/2012 null
Below is the hiring manager view, where he specifies how many positions he/she is looking to open. As soon as he puts a value greater than zero in either of the positions mentioned below, a new requisition ID should be created with a date on which the requisition is created. For e.g.; the hiring manager puts in the value of 2 under service Clerks, then the requisition ID of 101 and 102 are created and assigned to each of the applicants who are applying for the Service clerk position.
Business Rules -
- If one of the two positions is closed, then the value in the Service Clerk (positions) should decrement to 1.
- If the hiring manager initially consider to open two full time positions and later he changed his mind to fill 4 part time candidates instead of 2, then 2 new requisition id’s should be created e.g.; 103, 104 and these should get assigned to all the applicants who are applying for the Service clerk position.
- By mistake if the hiring manager updated the no of Service clerk positions to 6 instead of 4 part time and save the data. Then there should be some means to obstruct the requisition ID creation automatically. How should we restrict this scenario?
Below are the two tables that I started with –
Applicant – User applying for open positions.
Requisition – A new requisition is created each time the Hiring manager creates an open position.
Hiring Manager view - For store 2345, Hiring manager created 2 openings for Service clerk, 1 opening for photo and 3 in Cosmetics
Store – 2345
Current Openings
Service Clerks 2 Photo 1 Cosmetics 3
Applicant –
Application ID Position Name Requisition ID
1 Service Clerk 101, 102
2 Service Clerk 101,102
3 Service Clerk 101,102
Requisition -
Requisition ID Requisition
Date End Date
101 12/18/2012 12/20/2012
102 12/18/2012 null
satishjayan- Posts : 4
Join date : 2012-12-18
Re: Modeling advice for hiring application scenario
While I would enjoy modeling your scenario, your question is posted in the wrong forum. You need an application database, not a reporting database. In no case should you build a dimensional model.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Application DB Modeling
I understand that. However, I don't see any good forum to address application modeling suggestions. Thought I should try here. Please assist me in providing your advice.
satishjayan- Posts : 4
Join date : 2012-12-18
Re: Modeling advice for hiring application scenario
Well, it is a slow day. :-)
You need a position table. Then a Position Requisition table. Applicants apply for positions, not requisitions, so you need an Applicant Position table as well. See if that helps your thought process.
You need a position table. Then a Position Requisition table. Applicants apply for positions, not requisitions, so you need an Applicant Position table as well. See if that helps your thought process.
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Similar topics
» Advice on Dimensional Modeling
» Modeling advice for Dimension Table
» Modeling - Dimension/Fact - Need advice please
» Advice needed on modeling Partnership Dimension
» Advice on modeling actual versus worst / standard / best
» Modeling advice for Dimension Table
» Modeling - Dimension/Fact - Need advice please
» Advice needed on modeling Partnership Dimension
» Advice on modeling actual versus worst / standard / best
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|