HXT Person/Assignment Table List

➜ Back to Library
Description
Categories: BI Publisher
Application: Time and Labor
Source: Person/Assignment Table List (XML)
Short Name: HXT957I_XML
DB package: HXT_HXT957I_XMLP_PKG

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select ASS.PERSON_ID PERSON_ID2 , STA.USER_STATUS, ASS.EFFECTIVE_START_DATE, ASS.EFFECTIVE_END_DATE, ASS.ASSIGNMENT_NUMBER, PAY.PAYROLL_ID, AEIV.HXT_AUTOGEN_HOURS_YN, PAY.PAYROLL_NAME, AEIV.HXT_EARNING_POLICY, AEIV.HXT_SHIFT_DIFFERENTIAL_POLICY, AEIV.HXT_HOUR_DEDUCTION_POLICY, AEIV.HXT_ROTATION_PLAN
from PER_ASSIGNMENTS_F ASS, HXT_PER_AEI_DDF_V AEIV, PER_ASSIGNMENT_STATUS_TYPES STA, PAY_PAYROLLS_F PAY
where ASS.ASSIGNMENT_STATUS_TYPE_ID = STA.ASSIGNMENT_STATUS_TYPE_ID
AND ASS.PAYROLL_ID = PAY.PAYROLL_ID
AND ASS.ASSIGNMENT_ID = AEIV.ASSIGNMENT_ID
AND ASS.EFFECTIVE_END_DATE BETWEEN PAY.EFFECTIVE_START_DATE AND PAY.EFFECTIVE_END_DATE 
 and ASS.PERSON_ID=:PERSON_ID_1
Download
 
Related Blitz Reports
HXT OTLR Missing Timecard HXT Periodic Late Clock-In HXT Organization Variance Calc HXT Actual and Rounded Time Punch HXT Earning Variance Calculation HXT Location Variance Calculation PAY Tax Payments Listing PQP OSS HRMS Comparison PER Employee Assignments
Blitz Report™

Blitz Report™ provides multiple benefits: