How to Develop a Salary Change Report in HCM Fusion R13

How to Develop a Salary Change Report in HCM Fusion R13
----------------------------------------------------------------------

Lets start with Master Tables, which has Data Elements related to identifying salary.

Table: pay_balance_types
       -> Pass:  BASE_BALANCE_NAME = 'XX_GROSS_SALARY_NPV'
       -> Get :  BALANCE_TYPE_ID -> 300000006261657
     
Table: pay_balance_dimensions:
       -> Pass : base_dimension_name = 'Core Assignment Run'
       -> Get balance_dimension_id -> 300000000809093

Table: pay_defined_balances
       -> Pass [JOIN balance_dimension_id AND BALANCE_TYPE_ID]
       -> Get : defined_balance_id

Table: Pay_run_balances: this table contains person specfic balances for payroll runs
       -> Pass: defined_balance_id : [filter data based on base balance and dimension]
       -> Pass: other parameters like payroll_relationship_id, and pay_rel_action_id
     
--------------
To filter data based on person: Lets start from person details

Table: per_all_people_f : pass person_number -> get person_id

Table: per_all_assignments_f : pass person_id and -> get assignment_id [filter: primary_flag =Y and record is active]

Table: Pay_pay_relationships_dn [pprd]: 1 record: specific to person and non-trx table
       -> Pass: Person_id
       -> Get:  payroll_relationship_id

Table: pay_payroll_rel_actions [ppra] : This table contains details of the individuals processed in a payroll process: more than 1 record for 1 person as its based on payroll ran 
       -> Pass: Payroll_relationship_id
       -> get payroll_action_id -> specif to a person_id
     
Table: pay_payroll_actions
       -> Pass: payroll_action_id
       -> Pass: action_types [Q,R]
       -> you may get multiple records of person should join with pay_time_periods with EARN_TIME_PERIOD_ID
       -> get PAYROLL_ID, EARN_TIME_PERIOD_ID, PAYROLL_ACTION_ID

Table: pay_time_periods     
       -> Pass time_period_id , payroll_action_id

---------------
again come to Table: Pay_run_balances:

-> you have : defined_balance_id
            : payroll_relationship_id
            : payroll_action_id
            : pay_rel_action_id


-> after passing above: you will get balance value for the period.