Results for “prev_sep_pay”
18 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
PAY_KR_SEP_TAX_V is a reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the Payroll (PAY) product family and is designed specifically for the Korean localization of Oracle Payroll. The view consolidates separation (termination) tax data for employees together with their associated person address information, producing a single denormalized result set suitable for statutory Korean separation tax reporting and downstream integrations.
The view is built on top of the helper view PAY_KR_SEP_TAX_WO_ADDR_V (the "without address" separation tax view) and enriches each row with a formatted person address assembled from PER_ADDRESSES. Its role is to surface the fields required by Korean tax and severance reporting forms, including business place details, corporation identifiers, tax office information, employee name and national identifier, nationality, and hiring and leaving dates.
Underlying Base Objects
The view is defined as a join between PAY_KR_SEP_TAX_WO_ADDR_V (aliased SEP) and the PER_ADDRESSES synonym (aliased PAD). The join is an outer join keyed on PERSON_ID, restricted to ADDRESS_TYPE = 'KR_C' and STYLE = 'KR', with the effective date of the separation row falling between PAD.DATE_FROM and NVL(PAD.DATE_TO, SEP.EFFECTIVE_DATE). This date-range predicate ensures the address valid at the time of separation is returned.
The PERSON_ADDRESS column is not read directly from PER_ADDRESSES storage. Instead it is derived by concatenating PAY_KR_SEP_FORM_PKG.GET_KR_D_ADDRESS_LINE1(PAD.ADD_INFORMATION17) with PAD.ADDRESS_LINE2, applying localization-specific formatting logic for the first address line.
The documented ETRM reference also lists HR_GENERAL, HR_PERSON_NAME, HR_SECURITY, and PAY_KR_REPORT_PKG among the referenced base objects, reflecting the security, name, and report logic that the underlying separation tax view depends upon.
Key Columns
- BUSINESS_GROUP_ID, PAYROLL_ID, ASSIGNMENT_ID, ASSIGNMENT_ACTION_ID, PAYROLL_ACTION_ID — core payroll context identifying the organization, payroll, assignment, and action that generated the separation record.
- EFFECTIVE_DATE, DATE_EARNED, XEFFECTIVE_DATE — dates governing the separation event and tax earning period.
- RUN_TYPE_ID, RUN_TYPE_NAME, TAX_UNIT_ID — the payroll run classification and tax reporting unit.
- PREV_ELEMENT_ENTRY_ID, PREV_BP_NUMBER, PREV_BP_NAME, PREV_SEP_PAY, PREV_SEP_INS, PREV_SP_SEP_ALW, PREV_SP_NON_TAX_AMT — prior-period separation pay, insurance, allowances, and non-taxable amounts carried forward from earlier reporting.
- BP_NUMBER, CORP_NAME, CORP_REPRESENTATIVE_NAME, CORP_NUMBER, BP_ADDRESS, TAX_OFFICE_NAME — business place and corporation identifiers used on Korean statutory tax forms.
- LAST_NAME, FIRST_NAME, NATIONAL_IDENTIFIER, NATIONALITY — employee identification data.
- PERSON_ADDRESS — the derived concatenated Korean address string.
- HIRING_DATE, LEAVING_DATE, PREV_FIRST_HIRING_DATE, PREV_LAST_LEAVING_DATE, ACTUAL_TERMINATION_DATE — employment and termination dates.
- COUNTRY_CODE, COUNTRY, PERSON_ID — country context and the key link back to the person.
Common Use Cases and Queries
The view is typically queried for Korean separation tax reports, audit extracts, and reconciliation of severance payment data against address and corporation information. A representative query selects separation records for a payroll period with address details:
SELECT PERSON_ID, LAST_NAME, FIRST_NAME, PERSON_ADDRESS, NATIONAL_IDENTIFIER FROM PAY_KR_SEP_TAX_V WHERE BUSINESS_GROUP_ID = :p_bg_id AND EFFECTIVE_DATE BETWEEN :p_start AND :p_end;- Joining back to PER_ADDRESSES is unnecessary because PERSON_ADDRESS is already resolved, simplifying report SQL.
- Filtering by TAX_UNIT_ID supports reconciliation per tax reporting unit, while PREV_* columns allow comparison of prior and current separation amounts.
Because PERSON_ADDRESS is produced through an outer join, rows without a matching KR_C/KR address still return, with PERSON_ADDRESS null. Consumers should account for this when formatting statutory output.
-
View: PAY_KR_SEP_TAX_V 12.1.1
APPS.PAY_KR_SEP_TAX_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PAY module →
-
View: PAY_KR_SEP_TAX_V 12.2.2
APPS.PAY_KR_SEP_TAX_V·↳ HR_GENERAL·↳ HR_PERSON_NAME·↳ HR_SECURITY·Explore PAY module →
-
APPS.PAY_KR_SEP_TAX_WO_ADDR_V·↳ FND_TERRITORIES_VL·↳ HR_GENERAL·↳ HR_LOCATIONS·Explore PAY module →
-
APPS.PAY_KR_SEP_TAX_WO_ADDR_V·↳ FND_TERRITORIES_VL·↳ HR_GENERAL·↳ HR_LOCATIONS·Explore PAY module →
-
This view returns Result of Separation Pay Tax based on assignment_action_id.
APPS.PAY_KR_SEP_RESULT_TAX_V·↳ HR_GENERAL·↳ PAY_ACTION_INTERLOCKS·↳ PAY_ASSIGNMENT_ACTIONS·Explore PAY module →
-
This view returns Result of Separation Pay Tax based on assignment_action_id.
APPS.PAY_KR_SEP_RESULT_TAX_V·↳ PAY_ACTION_INTERLOCKS·↳ PAY_ASSIGNMENT_ACTIONS·↳ PAY_KR_REPORT_PKG·Explore PAY module →
-
VIEW: APPS.PAY_KR_SEP_TAX_V 12.1.1
-
VIEW: APPS.PAY_KR_SEP_TAX_V 12.2.2
-
eTRM - PAY Tables and Views 12.2.2
Temporary table used to hold invalid location addresses.
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.