Position hierarchy

This hierarchy represents the open positions available. For common attributes, it can be built using the structure used in Employee. The attributes and relationships in the following figure represent the Position hierarchy.

Attribute	Description	Example
Position	Can be vacant or occupied; one or more employees can be assigned to a position. A copy of L_EMP_TITLE can be used as a lookup table.	Programmer, head of marketing
Job Open Reason	Reason related to a job opening; parent of Job Code.	New, backfill, backfill from transfer
Transfer Out	Name of transferred employee, if position is open due to transfer.	John Smith
Job Close Reason	Reason related to a job closing; parent of Job Code.	Transfer, obsolete
Transfer In	Name of transferred employee, if position is closed due to transfer.	John Smith
Job Code	When a position is vacant, a job code is associated with it; when the recruitment starts, an open date is also established.	1234, 4567
Job Department	Department in which the vacant position corresponding to the job code is open; parent of Job Code.	Finance, marketing
Job Location	Location where the vacant position corresponding to the job code is open; parent of Job Code.	New York, Washington, Boston
Job Clearance	Clearance necessary to perform the duties of the vacant position corresponding to the job code; parent of Job Code.	Secret, top secret
Job Work Experience	Number of years of experience necessary to perform the duties of the vacant position corresponding to the job code; parent of Job Code.	2, 5, and so on.
Job Open Date	Date on which the position advertisement begins. The attribute's relationship is one to one with Job Code.	12/12/02
Job Close Date	Date on which the position advertisement is ended (when the position becomes obsolete or is filled). The attribute's relationship is one to one with Job Code.	1/1/03

The detailed definition of each attribute in the MicroStrategy metadata listed previously is shown in the following tables.

Job Code

Form	Form Expression	Lookup Table	Other Tables
ID	JOB_CODE_ID	L_JOB_CODE	F_POSITION

 

Children	Parents	Relationship Type	Table
None	Job Clearance	Many-to-one	L_JOB_CODE
None	Job Close Reason	Many-to-one	L_JOB_CODE
None	Job Close Date	One-to-one	L_JOB_CODE
None	Job Open Date	One-to-one	L_JOB_CODE
None	Job Open Reason	Many-to-one	L_JOB_CODE
None	Job Department	Many-to-one	L_JOB_CODE
None	Job Location	Many-to-one	L_JOB_CODE
None	Position	Many-to-one	L_JOB_CODE
None	Job Work Experience	Many-to-one	L_JOB_CODE

Job Clearance

Form	Form Expression	Lookup Table	Other Tables
ID	EMP_CLEARANCE_ID JOB_CLEARANCE_ID	L_JOB_CLEARANCE L_JOB_CODE	None
DESC	EMP_CLEARANCE_ DESC	L_JOB_CLEARANCE	None

 

Children	Parents	Relationship Type	Table
Job Code	Job Clearance	One-to-many	L_JOB_CODE

Job Close Date

Form	Form Expression	Lookup Table	Other Tables
ID	JOB_CLOSE_DATE	L_JOB_CODE	None

 

Children	Parents	Relationship Type	Table
Job Code	None	One-to-one	L_JOB_CODE

Job Open Date

Form	Form Expression	Lookup Table	Other Tables
ID	JOB_OPEN_DATE	L_JOB_CODE	None

 

Children	Parents	Relationship Type	Table
Job Code	None	One-to-one	L_JOB_CODE

Job Department

Form	Form Expression	Lookup Table	Other Tables
ID	JOB_DPTM_ID, EMP_DPTM_ID	L_JOB_CODE L_JOB_DPTM	None
DESC	EMP_DPTM_DESC	L_JOB_DPTM	None

 

Children	Parents	Relationship Type	Table
Job Code	None	One-to-many	L_JOB_CODE

Job Location

Form	Form Expression	Lookup Table	Other Tables
ID	JOB_LOCATION_ID, EMP_LOCATION_ID	L_JOB_CODE L_JOB_LOCATION	None
DESC	EMP_LOCATION_DESC	L_JOB_LOCATION	None

 

Children	Parents	Relationship Type	Table
Job Code	None	One-to-many	L_JOB_CODE

Job Work Experience

Form	Form Expression	Lookup Table	Other Tables
ID	JOB_WORK_EXP	L_JOB_CODE	None

 

Children	Parents	Relationship Type	Table
Job Code	None	One-to-many	L_JOB_CODE

Position

Form	Form Expression	Lookup Table	Other Tables
ID	POSITION_ID	L_POSITION	L_JOB_CODE
DESC	POSITION_DESC	L_POSITION	None

 

Children	Parents	Relationship Type	Table
Job Code	None	One-to-many	L_JOB_CODE

Job Open Reason

Form	Form Expression	Lookup Table	Other Tables
ID	JOB_OPEN_RSN_ ID	L_JOB_OPEN_RSN	L_JOB_CODE
DESC	JOB_OPEN_RSN_ DESC	L_JOB_OPEN_RSN	None

 

Children	Parents	Relationship Type	Table
Job Code	None	One-to-many	L_JOB_CODE

Job Close Reason

Form	Form Expression	Lookup Table	Other Tables
ID	JOB_CLOSE_RSN_ ID	L_JOB_CLOSE_RSN	L_JOB_CODE
DESC	JOB_CLOSE_RSN_ DESC	L_JOB_CLOSE_RSN	None

 

Children	Parents	Relationship Type	Table
Job Code	None	One-to-many	L_JOB_CODE