Monday, June 30, 2008

How is the primary job determined?

The JOB_INDICATOR code on the PS_JOB table is used to indicate if the job is the employee's primary job or not. Some ASU employees have more than one job at ASU. An employee's primary job record in the PS_JOB table has a "P" in the JOB_INDICATOR code. Other jobs on PS_JOB table for the employee have either an "N" or an "S".

The current logic for setting the JOB_INDICATOR is:

If there is only one job for the employee, that is the primary job. If the employee has multiple jobs, the primary job is the job with the highest annual salary that is not terminated or retired (PS_JOB.EMPL_STATUS = R or T). If there is more than one job with the same annual salary, then the job with the lowest PS_JOB.EMPL_RCD is be set to be the primary job.

What is the difference between N and S?

Currently, non-primary jobs are assigned a job indicator code = N. In the past, non-primary jobs were assigned a job indicator code = S. There were some challenges with early versions of the job indicator assignment program. When the current version of the program was rolled out on June 11, 2008, it was decided not to fix historical records but to begin anew with a different coding structure.