Employment Primary Status Attributes
You can set the primary status for work relationships, work terms, and assignments by setting their status in the PER_PERIODS_OF_SERVICE and PER_ALL_ASSIGNMENTS_M tables.
This table describes the primary status attribute available on the PER_PERIODS_OF_SERVICE table.
Primary Status Attribute Name |
Description |
---|---|
PRIMARY_FLAG |
A worker can have multiple work relationships, but only one must be identified as primary. If you want to make the work relationship as primary, then set this attribute to Y. If there's only one work relationship, then it will be primary by default. The PER_PERIODS_OF_SERVICE table is not effective dated. Therefore, when there is a primary status change in the work relationship, the value of the PRIMARY_FLAG is updated to reflect the latest primary status. If you want to track the history of the primary status change at the work relationship level, see the PRIMARY_WORK_RELATION_FLAG in the PER_ALL_ASSIGNMENTS_M table. |
This table describes the four primary status attributes available on the PER_ALL_ASSIGNMENTS_M table.
Primary Status Attribute Name |
Description |
---|---|
PRIMARY_WORK_RELATION_FLAG |
A worker can have multiple work relationships, but only one must be identified as primary. If you want to make the work relationship as primary, then set this attribute to Y at the work relationship level. If there's only one work relationship, then it will be primary by default and the primary status is set in the work terms and assignment also. |
PRIMARY_WORK_TERMS_FLAG |
For two-tier employment models, you don't have to identify the primary set of work terms as long as you can identify the primary assignment. In two-tier employment models, this attribute is set to Y in the employment terms record for the corresponding primary assignment. This primary status is only set in the work terms. |
PRIMARY_ASSIGNMENT_FLAG |
A worker can have multiple assignments, but only one must be identified as primary. If you want to make the worker assignment as primary, then set this attribute to Y at the assignment level. If there's only one assignment, then it will be primary by default and the primary status is set in the assignment also. |
PRIMARY_FLAG |
This overall primary attribute is an application controlled attribute and is set to Y for the primary assignment of the worker's primary work relationship. This primary status is set at the assignment. |
Let's take a look at an example to understand how the primary status options work.
Vijay Singh is hired on 1-Jan-2010 and he has only one work relationship and assignment record. Therefore, all the primary attributes are set to Y at the respective levels.
In the table, the prefix E denotes employee assignment and ET denotes employee work terms.
Start Date |
Work Relationship |
Assignment Number |
Primary Work Relationship |
Primary Work Terms |
Primary Assignment |
Primary |
---|---|---|---|---|---|---|
1-Jan-2010 |
WR1 |
E100 |
Y |
N |
Y |
Y |
1-Jan-2010 |
WR1 |
ET100 |
Y |
Y |
N |
N |
An additional nonprimary assignment is added on 1-Jan-2011. The additional assignment is added to the same work relationship, therefore, the work relationship will continue to be primary for the newly added assignment. The PRIMARY_FLAG, PRIMARY_WORK_TERMS_FLAG, and PRIMARY_ASSIGNMENT_FLAG flags will be set to N because the newly added assignment is nonprimary and the employment model is two-tier.
Start Date |
Work Relationship |
Assignment Number |
Primary Work Relationship |
Primary Work Terms |
Primary Assignment |
Primary |
---|---|---|---|---|---|---|
1-Jan-2010 |
WR1 |
E100 |
Y |
N |
Y |
Y |
1-Jan-2010 |
WR1 |
ET100 |
Y |
Y |
N |
N |
1-Jan-2011 |
WR1 |
E100-2 |
Y |
N |
N |
N |
1-Jan-2011 |
WR1 |
ET100-2 |
Y |
N |
N |
N |
A nonprimary work relationship is added on 1-Jan-2012. Therefore, the PRIMARY_WORK_RELATION_FLAG will be set to N because of the newly added nonprimary work relationship. The PRIMARY_ASSIGNMENT_FLAG and PRIMARY_WORK_TERMS_FLAG will be set to Y because there's only one assignment for the newly added work relationship. The PRIMARY_FLAG will be set to N as the assignment is part of the nonprimary work relationship.
Start Date |
Work Relationship |
Assignment Number |
Primary Work Relationship |
Primary Work Terms |
Primary Assignment |
Primary |
---|---|---|---|---|---|---|
1-Jan-2010 |
WR1 |
E100 |
Y |
N |
Y |
Y |
1-Jan-2010 |
WR1 |
ET100 |
Y |
Y |
N |
N |
1-Jan-2011 |
WR1 |
E100-2 |
Y |
N |
N |
N |
1-Jan-2011 |
WR1 |
ET100-2 |
Y |
N |
N |
N |
1-Jan-2012 |
WR2 |
E100-3 |
N |
N |
Y |
N |
1-Jan-2012 |
WR2 |
ET100-3 |
N |
Y |
N |
N |