[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 20 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_GB_TAX_CODE_INTERFACE_N1 | NORMAL | NONUNIQUE | APPS_TS_INTERFACE | REQUEST_ID |
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 |
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;
HR.PAY_GB_TAX_CODE_INTERFACE does not reference any database object
HR.PAY_GB_TAX_CODE_INTERFACE is referenced by following:
|
|
|