Payroll
Discussion List
-
SQL query to retrieve earnings and deductionsSummary SQL query to retrieve earnings and deductionsContent Hi Experts, I'm designing a balance extract that needs to fetch pension deductions 403. To create the data g…Aloka Bhattacharya 2.8K views 7 comments 2 points Most recent by Shubham Kadam Reporting and Analytics for HCM -
Looking for report that shows state from tax jurisdictions cardSummary: We have run our first payrolls with USOPTE and are running into a case with tax jurisdiction cards having the wrong state in a particular circumstance. We want …Dana Lockwood 11 views 2 comments 0 points Most recent by Dana Lockwood Reporting and Analytics for HCM -
26A-Payslip VBS Options - How to hide the text "No items to display"Summary: 26A-Payslip VBS Options - How to hide the text "No items to display" Content (please ensure you mask any confidential information): 26A Payslip view has the tab… -
SQL query to get the result of Recalculate Payroll for Retroactive ChangesSummary: SQL query to get the result of Recalculate Payroll for Retroactive Changes Content (please ensure you mask any confidential information): Hi Team, Greetings! Ca…Parag Hiremath 13 views 0 comments 0 points Started by Parag Hiremath Reporting and Analytics for HCM -
Query to fetch Run Result Element Entries & Balances for particular time periodSummary: We have a requirement to pull element entries & balances from Run Results for the particular time period. I have written the below query but which is giving mul…Manoharan 10K views 12 comments 0 points Most recent by Anusha Bhat-Oracle Reporting and Analytics for HCM
-
HCM Extract userentity for column COMPONENT_NAME PAY_DIR_CARD_COMP_DEFS_TLHi, We need user entity to get the details of COMPONENT_NAME column from PAY_DIR_CARD_COMP_DEFS_TL table. Can anyone suggest on the UE to use, we tried to find the UE bu…
-
What table to query for Individual Balance adjustments in PayrollSummary: Hi, I am looking for the table in OTBI that can be used to query any manually keyed Individual Balance Adjustments. If anyone has an SQL, it would also be great…Bonnie Lafferty 373 views 4 comments 0 points Most recent by Parag Hiremath Reporting and Analytics for HCM