Sample CalculationCard.dat file for loading Federal US Tax Withholding Using HDL

-

METADATA|CardComponent|CardSequence|ComponentSequence|AssignmentNumber|DirCardDefinitionName|LegislativeDataGroupName|DirCardCompDefName|EffectiveStartDate|EffectiveEndDate|Context1|Context2|Context3|Context4|Context5|Context6

MERGE|CardComponent|1|1|E100821|Tax Withholding|WK_LDG|Federal Taxes|2019/01/01|||||||
MERGE|CardComponent|1|1|E100821|Tax Withholding|WK_LDG|US Taxation|2019/01/01||300000123773548|||||

METADATA|CardAssociation|CardSequence|EffectiveStartDate|AssignmentNumber|DirCardDefinitionName|LegislativeDataGroupName|TaxReportingUnitName
MERGE|CardAssociation|1|2019/01/01|E100821|Tax Withholding|WK_LDG|WK_US_LE

METADATA|CardAssociationDetail|CardSequence|ComponentSequence|EffectiveStartDate|AssignmentNumber|DirCardDefinitionName|LegislativeDataGroupName|TaxReportingUnitName|DirCardCompDefName
MERGE|CardAssociationDetail|1|1|2019/01/01|E100821|Tax Withholding|WK_LDG|WK_US_LE|US Taxation

METADATA|EnterableCalculationValue|LegislativeDataGroupName|EffectiveStartDate|DirCardDefinitionName|CardSequence|DirCardCompDefName|ComponentSequence|AssignmentNumber|ValueDefinitionName|Value1
MERGE|EnterableCalculationValue|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|US Employee Withholding Certificate User Interface Preference|FULL_ENHANCED
MERGE|EnterableCalculationValue|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Exempt from Federal Income Tax|N
MERGE|EnterableCalculationValue|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|IRS Lock in Date|2019/01/01
MERGE|EnterableCalculationValue|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Exempt from Wage Accumulation|Y
MERGE|EnterableCalculationValue|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Filing Status|2
MERGE|EnterableCalculationValue|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Exempt from Medicare|Y
MERGE|EnterableCalculationValue|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Exempt from Social Security|Y
MERGE|EnterableCalculationValue|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Exempt from Federal Unemployment|Y
MERGE|EnterableCalculationValue|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Additional Tax Amount|40.00
MERGE|EnterableCalculationValue|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Allowances|5
MERGE|EnterableCalculationValue|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Regular Amount|100
MERGE|EnterableCalculationValue|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Regular Rate|101
MERGE|EnterableCalculationValue|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Supplemental Rate|102
MERGE|EnterableCalculationValue|WK_LDG|2019/01/01|Tax Withholding|1|US Taxation|1|E100821|Primary Work Address|300001215317122
MERGE|EnterableCalculationValue|WK_LDG|2019/01/01|Tax Withholding|1|US Taxation|1|E100821|State for Unemployment Calculation|5
MERGE|EnterableCalculationValue|WK_LDG|2019/01/01|Tax Withholding|1|US Taxation|1|E100821|State for Disability Calculation|5
MERGE|EnterableCalculationValue|WK_LDG|2019/01/01|Tax Withholding|1|US Taxation|1|E100821|Cumulative Taxation|Y
MERGE|EnterableCalculationValue|WK_LDG|2019/01/01|Tax Withholding|1|US Taxation|1|E100821|Statutory Employee|Y
METADATA|CalculationCard|LegislativeDataGroupName|DirCardDefinitionName|EffectiveStartDate|EffectiveEndDate|AssignmentNumber|CardSequence
MERGE|CalculationCard|WK_LDG|Tax Withholding|2019/01/01||E100821|1
METADATA|CalculationValueDefinition|LegislativeDataGroupName|EffectiveStartDate|DirCardDefinitionName|CardSequence|DirCardCompDefName|ComponentSequence|AssignmentNumber|ValueDefinitionName
MERGE|CalculationValueDefinition|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|US Employee Withholding Certificate User Interface Preference
MERGE|CalculationValueDefinition|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Exempt from Federal Income Tax
MERGE|CalculationValueDefinition|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|IRS Lock in Date
MERGE|CalculationValueDefinition|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Exempt from Wage Accumulation
MERGE|CalculationValueDefinition|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Filing Status
MERGE|CalculationValueDefinition|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Exempt from Medicare
MERGE|CalculationValueDefinition|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Exempt from Social Security
MERGE|CalculationValueDefinition|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Exempt from Federal Unemployment
MERGE|CalculationValueDefinition|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Additional Tax Amount
MERGE|CalculationValueDefinition|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Allowances
MERGE|CalculationValueDefinition|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Regular Amount
MERGE|CalculationValueDefinition|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Regular Rate
MERGE|CalculationValueDefinition|WK_LDG|2019/01/01|Tax Withholding|1|Federal Taxes|1|E100821|Supplemental Rate
MERGE|CalculationValueDefinition|WK_LDG|2019/01/01|Tax Withholding|1|US Taxation|1|E100821|Primary Work Address
MERGE|CalculationValueDefinition|WK_LDG|2019/01/01|Tax Withholding|1|US Taxation|1|E100821|State for Unemployment Calculation
MERGE|CalculationValueDefinition|WK_LDG|2019/01/01|Tax Withholding|1|US Taxation|1|E100821|State for Disability Calculation
MERGE|CalculationValueDefinition|WK_LDG|2019/01/01|Tax Withholding|1|US Taxation|1|E100821|Cumulative Taxation
MERGE|CalculationValueDefinition|WK_LDG|2019/01/01|Tax Withholding|1|US Taxation|1|E100821|Statutory Employee


Reference: CalculationCard.dat Sample File For Loading W4 Federal US Tax Withholding Using HDL (Doc ID 2592582.1)


Comments

Post a Comment

Popular posts from this blog

Query to get Salary Change details in Fusion HCM

-
 SELECT papf.person_number PERSON_NUMBER, (select full_name from per_person_names_f ppnf where ppnf.person_id = papf.person_id and name_type = 'GLOBAL' and trunc(sysdate) between ppnf.effective_start_date and ppnf.effective_end_date) person_name, ple.name LEGAL_EMPLOYE, (CASE  when cs.SALARY_BASIS_CODE = 'ANNUAL' THEN 'Salary Change'  else  'Hourly Rate Change' end)  ACTION_NAME, to_char(cs_old.salary_amount) OLD_DATA,  to_char(CS.salary_amount) NEW_DATA    ,TO_CHAR(cs.date_from, 'MM/DD/YYYY') EFFECTIVE_DATE    ,  TO_CHAR(cs.creation_date, 'MM/DD/YYYY') CHANGED_DATE    , cs.LAST_UPDATED_BY CHANGED_BY           from  fusion.CMP_SALARY cs,           CMP_SALARY cs_old,   PER_ALL_ASSIGNMENTS_M  PAAM,   PER_ALL_PEOPLE_F PAPF   ,per_legal_employers ple          where 1 = 1    AND PAPF.PERSON_ID = P...
Read more

Oracle Fusion HCM - Enhancements to Summary of Changes and History Sections in Redwood Workforce Structures Pages

-
Image
 The  Summary of Changes  and  History  sections on Redwood  Workforce Structures  pages now display  additional attributes , providing a more detailed view of historical and recent changes to your workforce data. These enhancements apply to the following Redwood pages: Redwood Page New Attributes in Summary of Changes and History Sections Departments Status Divisions Status Disability Organizations Status Enterprise HCM Information Status Jobs Annual Working Duration Scheduling Group Standard Annual Working Duration Standard Working Hours Standard Working Frequency Locations Annual Working Duration Standard Annual Working Duration Standard Working Hours Standard Working Frequency Reporting Establishments Status Worker Unions Status These additional attributes are now visible in both the  Summary of Changes  and  History  sections, enabling users to quickly access and review key data points related to structural and job-related...
Read more

🧾 Streamlining Payroll Operations with Oracle Payroll Activity Center

-
Image
Managing payroll efficiently across global teams has never been more critical—or more complex. Oracle Fusion HCM introduces the  Payroll Activity Center , part of the Redwood user experience, to help payroll teams take control with a centralized, intelligent, and highly actionable interface. Designed with usability and impact in mind, this hub simplifies payroll monitoring, boosts accuracy, and brings AI-powered insight to the forefront. 🌟 What Is the Payroll Activity Center? The  Payroll Activity Center  is an action-focused workspace tailored to payroll professionals. It aggregates relevant applications, displays role-specific KPIs, and provides intuitive navigation through the payroll cycle—all within Oracle’s new Redwood design system. This replaces the older Payroll Dashboard and brings everything you need into a single, streamlined view. 🔑 Key Features Aggregated Applications View relevant payroll applications, flows, and data all in one place. In-Workflow Communi...
Read more