Data Mapping from Payroll to General Ledger when information

Payroll populates the following reference columns in GL_INTERFACE:

  

• reference21 with payroll_action_id of Payroll Transfer to GL process
• reference22 with cost_allocation_keyflex_id of Payroll cost flexfield for this entry
• reference23 with effective date of the Payroll Run this entry is derived from
• reference24 with date_earned of the Payroll Run this entry is derived from
• reference25 with payroll_action_id of Payroll Run this entry is derived from *

 
* is only in 11i

 

So, these are then placed in reference1, reference2, reference3, reference4 and
reference5 in GL_IMPORT_REFERENCES respectively.

 

Using these 5 values, the customer will be able to run sql to derive which
elements, assignment etc (pay run results), the entries in GL were
derived from.

PAY_TRGL_PKG - Procedure to transfer pay costs to General Ledger (pytrangl.pkb)