eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HR.PAY_GB_TAX_CODE_INTERFACE

Object Details

Object Name:	PAY_GB_TAX_CODE_INTERFACE
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_GB_TAX_CODE_INTERFACE
Subobject Name:
Status:	VALID

PAY_GB_TAX_CODE_INTERFACE is an interface table for the Start of Year
(SOY) processing the UK. Taxcode amendments are distributed to
employers on magnetic tape by the Tax Office and the
PAY_GB_TAX_CODE_INTERFACE table is used to load the amendments for
processing. The SOY process then updates the PAYE details elements
with the details and clears the interface table.

Storage Details

Tablespace:	APPS_TS_INTERFACE
PCT Free:	20
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_GB_TAX_CODE_INTERFACE_N1	NORMAL	NONUNIQUE	APPS_TS_INTERFACE	REQUEST_ID

Columns

Name	Datatype	Length	Mandatory	Comments
DISTRICT_NUMBER	NUMBER	(3)	Yes	Tax district number.
EMPLOYER_REFERENCE	VARCHAR2	(10)	Yes	Employers reference for a PAYE scheme.
NATIONAL_INSURANCE_NUMBER	VARCHAR2	(10)	Yes	Employees reference (National Insurance number).
TAX_CODE	VARCHAR2	(7)	Yes	New tax code.
NON_CUMULATIVE_FLAG	VARCHAR2	(1)		Indicates whether the tax code is cumulative, where Y = non-cumulative and null = cumulative.
EMPLOYEE_NAME	VARCHAR2	(28)		Employee name, given as surname, title, initials and/or forenames.
WORKS_NUMBER	VARCHAR2	(20)		Works reference number.
PROCESSED_FLAG	VARCHAR2	(1)		Indicates whether the tax code amendments have been processed, where null = Unprocessed, P = Processed, R = Rejected.
EFFECTIVE_DATE	DATE			Effective_Date
DATE_OF_MESSAGE	DATE			Date the P6 message was sent
ISSUE_DATE	DATE			Date the P6 was issued
TOT_PAY_PREV_EMP	NUMBER	(15)		Total Pay from previous employer
TOT_TAX_PREV_EMP	NUMBER	(15)		Total Tax paid in previous employment
FORM_TYPE	VARCHAR2	(10)		Form Type issue by Inland Revenue
REQUEST_ID	NUMBER	(15)		Concurrent Program Request ID

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DISTRICT_NUMBER
,      EMPLOYER_REFERENCE
,      NATIONAL_INSURANCE_NUMBER
,      TAX_CODE
,      NON_CUMULATIVE_FLAG
,      EMPLOYEE_NAME
,      WORKS_NUMBER
,      PROCESSED_FLAG
,      EFFECTIVE_DATE
,      DATE_OF_MESSAGE
,      ISSUE_DATE
,      TOT_PAY_PREV_EMP
,      TOT_TAX_PREV_EMP
,      FORM_TYPE
,      REQUEST_ID
FROM HR.PAY_GB_TAX_CODE_INTERFACE;

Dependencies

[top of page]

HR.PAY_GB_TAX_CODE_INTERFACE does not reference any database object

HR.PAY_GB_TAX_CODE_INTERFACE is referenced by following:

APPS: PAY_GB_TAX_CODE_INTERFACE
PUBLIC: PAY_GB_TAX_CODE_INTERFACE