How can I derive the Position ID?
The payroll extract derives the Position ID from the Company Code, Assignment Number, and Assignment Status.
If Assignment Status = Active-No Payroll, the application doesn't either display or store the Position ID.
This is how the Position ID is derived:
-
Characters 1 to 3 => Company Code (Say 'T24').
-
Characters 4 to 9 => File ID (say 786, if the file ID is less than 6 digit, then pad with leading zeros).
-
10 => 'N' if the assignment status is Active- no payroll else blank.
-
The derived Position ID in this case is T24000786N.