Forum Stats

  • 3,851,424 Users
  • 2,263,974 Discussions
  • 7,904,702 Comments

Discussions

We are trying to extract the override cost center details from one of Assignment DFF through seeded

3228252
3228252 Member Posts: 1
edited Jun 1, 2020 3:39AM in HCM Cloud Service

We are trying to extract the override cost center details from one of Assignment DFF through seeded Payroll Interface for ADP Global Payroll HCM extract, but not returning any data.

Here is fast formula for your reference.

/*Default DBI*/

DEFAULT FOR DATA_ELEMENTS IS EMPTY_TEXT_TEXT

DEFAULT FOR PER_ASG_ATTRIBUTE7 IS 'X'

/*Input parameters*/

INPUTS ARE DATA_ELEMENTS (TEXT_TEXT)

/*================== Local Variables =====================*/

L_Context_date (date) = GET_CONTEXT(EFFECTIVE_DATE,TO_DATE('1951/01/01 00:00:00'))

l_asg_id    = 0

rule_value= ' '

IF DATA_ELEMENTS.EXISTS('Payroll Assignment Id') THEN

(

l_asg_id    = TO_NUMBER(DATA_ELEMENTS['Payroll Assignment Id'])

     CHANGE_CONTEXTS(EFFECTIVE_DATE = L_Context_date,HR_ASSIGNMENT_ID = l_asg_id )

        (

rule_value = PER_ASG_ATTRIBUTE7  

)

)

rule_value = TRIM(rule_value)