Table: HR_S_US_CITY_GEOCODES | Oracle EBS ETRM Search

This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to US midified geocodes while data upload is in progress.

HR.HR_H2PI_US_MODIFIED_GEOCODES·Explore PER module →

Table: HR_S_US_ZIP_CODES 12.1.1 standalone

owner HR·PER - Human Resources·5 columns

Valid zip code ranges for VERTEX cities, used to validate US addresses.

HR.HR_S_US_ZIP_CODES·Explore PER module →

Table: HR_S_US_CITY_SCHOOL_DSTS 12.2.2 standalone

owner HR·PER - Human Resources·5 columns

HR.HR_S_US_CITY_SCHOOL_DSTS·Explore PER module →

Table: HR_S_US_CITY_SCHOOL_DSTS 12.1.1 standalone

owner HR·PER - Human Resources·5 columns

HR.HR_S_US_CITY_SCHOOL_DSTS·Explore PER module →

View: HR_H2PI_US_CITY_NAMES_V 12.2.2

PER - Human Resources·5 columns

Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for US city names

APPS.HR_H2PI_US_CITY_NAMES_V·↳ PAY_US_CITY_NAMES·Explore PER module →

Table: HR_S_US_CITY_GEOCODES 12.1.1 standalone

owner HR·PER - Human Resources·3 columns

HR.HR_S_US_CITY_GEOCODES·Explore PER module →

Table: HR_H2PI_US_CITY_NAMES 12.1.1 standalone

owner HR·PER - Human Resources·8 columns

HR.HR_H2PI_US_CITY_NAMES·Explore PER module →

View: HR_H2PI_US_MODIFIED_GEOCODES_V 12.1.1

PER - Human Resources·8 columns

Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for US midfied geocodes

APPS.HR_H2PI_US_MODIFIED_GEOCODES_V·↳ PAY_US_MODIFIED_GEOCODES·Explore PER module →

View: HR_H2PI_US_MODIFIED_GEOCODES_V 12.2.2

PER - Human Resources·8 columns

Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for US midfied geocodes

APPS.HR_H2PI_US_MODIFIED_GEOCODES_V·↳ PAY_US_MODIFIED_GEOCODES·Explore PER module →

View: HR_H2PI_COUNTY_TAX_RULES_V 12.2.2

PER - Human Resources·21 columns

Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for US county tax rules

APPS.HR_H2PI_COUNTY_TAX_RULES_V·↳ HR_H2PI_ASSIGNMENTS_V·↳ PAY_US_EMP_COUNTY_TAX_RULES_F·Explore PER module →

View: HR_H2PI_CITY_TAX_RULES_V 12.2.2

PER - Human Resources·22 columns

Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for US City Tax Rules

APPS.HR_H2PI_CITY_TAX_RULES_V·↳ HR_H2PI_ASSIGNMENTS_V·↳ PAY_US_EMP_CITY_TAX_RULES_F·Explore PER module →

Table: HR_H2PI_US_MODIFIED_GEOCODES 12.1.1 standalone

owner HR·PER - Human Resources·11 columns

This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to US midified geocodes while data upload is in progress.

HR.HR_H2PI_US_MODIFIED_GEOCODES·Explore PER module →

Table: HR_S_US_CITY_NAMES 12.1.1 standalone

owner HR·PER - Human Resources·11 columns

US cities and their VERTEX geocodes, used to validate US addresses.

HR.HR_S_US_CITY_NAMES·Explore PER module →

Table: HR_H2PI_CITY_TAX_RULES 12.2.2 standalone

owner HR·PER - Human Resources·24 columns

This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to us employees city tax rules while data upload is in progress.

HR.HR_H2PI_CITY_TAX_RULES·Explore PER module →

View: HR_H2PI_CITY_TAX_RULES_V 12.1.1

PER - Human Resources·22 columns

Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for US City Tax Rules

APPS.HR_H2PI_CITY_TAX_RULES_V·↳ HR_H2PI_ASSIGNMENTS_V·↳ PAY_US_EMP_CITY_TAX_RULES_F·Explore PER module →

Table: HR_H2PI_COUNTY_TAX_RULES 12.2.2 standalone

owner HR·PER - Human Resources·23 columns

This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to us employee county tax rules while data upload is in progress.

HR.HR_H2PI_COUNTY_TAX_RULES·Explore PER module →

Table: HR_H2PI_CITY_TAX_RULES 12.1.1 standalone

owner HR·PER - Human Resources·24 columns

This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to us employees city tax rules while data upload is in progress.

HR.HR_H2PI_CITY_TAX_RULES·Explore PER module →

View: HR_H2PI_COUNTY_TAX_RULES_V 12.1.1

PER - Human Resources·21 columns

Contains data related to Oracle HR to Oracle Payroll Interface (H2PI) for US county tax rules

APPS.HR_H2PI_COUNTY_TAX_RULES_V·↳ HR_H2PI_ASSIGNMENTS_V·↳ PAY_US_EMP_COUNTY_TAX_RULES_F·Explore PER module →

Table: HR_H2PI_COUNTY_TAX_RULES 12.1.1 standalone

owner HR·PER - Human Resources·23 columns

This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to us employee county tax rules while data upload is in progress.

HR.HR_H2PI_COUNTY_TAX_RULES·Explore PER module →

View: HR_ADP_CITY_TAX_V 12.2.2

PER - Human Resources·34 columns

ADP payroll interface view

APPS.HR_ADP_CITY_TAX_V·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·↳ HR_ALL_ORGANIZATION_UNITS·Explore PER module →

View: HR_ADP_CITY_TAX_V 12.1.1

PER - Human Resources·34 columns

ADP payroll interface view

APPS.HR_ADP_CITY_TAX_V·↳ FND_GLOBAL·↳ HR_ADP·↳ HR_ADP_EMP_REF_V·Explore PER module →

View: HR_CERIDIAN_SECONDARY_STATE_V 12.1.1

PER - Human Resources·17 columns

Ceridian Source 100 payroll interface view