ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F0083869E053B46B63588994 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 Y HXT HXT957I_XML AR HXT قائمة جداول الأشخاص/التعيينات Application: الوقت والعمالة Source: قائمة جداول الأشخاص/التعيينات (XML) Short Name: HXT957I_XML DB package: HXT_HXT957I_XMLP_PKG D HXT Personen/Stellen - Tabelle Application: Time and Labor Source: Personen/Stellen - Tabelle (XML) Short Name: HXT957I_XML DB package: HXT_HXT957I_XMLP_PKG F HXT Données de la table des personnes/affectations Application: Time and Labor Source: Données de la table des personnes/affectations (XML) Short Name: HXT957I_XML DB package: HXT_HXT957I_XMLP_PKG US HXT Person/Assignment Table List Application: Time and Labor Source: Person/Assignment Table List (XML) Short Name: HXT957I_XML DB package: HXT_HXT957I_XMLP_PKG ZHS HXT 人员/分配表 Application: 时间和人工管理系统 Source: 人员/分配表 (XML) Short Name: HXT957I_XML DB package: HXT_HXT957I_XMLP_PKG BI Publisher :p_1 :p_conc_request_id :person_id_1