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_YEAR_END_PAYROLLS

Object Details

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

PAY_GB_YEAR_END_PAYROLLS is an extraction table that holds payroll
information for the UK End of Year (EOY) process. Details are
extracted from the PAY_ALL_PAYROLLS_F table and associated Soft Coded
Flex, Organization Flex and Time Period rows that are used in the Year
End Extract and reported on the magnetic tape submission.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Primary Key: PAY_GB_YEAR_END_PAYROLLS_PK

PAYROLL_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_GB_YEAR_END_PAYROLLS_PK	NORMAL	UNIQUE	APPS_TS_ARCHIVE	PAYROLL_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
PAY_GB_YEAR_END_ASSIGNMENTS		PAY_GB_YEAR_END_PAYROLLS	PAY_GB_YEAR_END_ASSIGNMENTS PAYROLL_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PAYROLL_ID	NUMBER	(15)	Yes	Foreign key to PAY_ALL_PAYROLLS_F.
BUSINESS_GROUP_ID	NUMBER	(15)		Foreign key to HR_ORGANIZATION_UNITS.
ECON	VARCHAR2	(9)		Employers contracted out number.
EMPLOYERS_ADDRESS_LINE	VARCHAR2	(60)		Employers statutory reporting address.
EMPLOYERS_NAME	VARCHAR2	(36)		Employers statutory reporting name.
END_PREVIOUS_YEAR	DATE			End date of the last period of the previous year.
END_YEAR	DATE			End date of the last period in the year for this payroll.
MAX_PERIOD_NUMBER	NUMBER	(2)		Highest period number for the payroll, identifies week 53.
PAYROLL_NAME	VARCHAR2	(80)		Name of the payroll.
PERIOD_TYPE	VARCHAR2	(30)		Foreign key to PER_TIME_PERIOD_TYPES.
PERMIT_NUMBER	VARCHAR2	(12)		Permit number issued by the DSS for use on the year end magnetic media.
SMP_COMPENSATION	NUMBER	(10)		Amount of NIC compensation (recoverable amount) on SMP for this Payroll and Year.
SMP_RECOVERED	NUMBER	(10)		Amount of SMP recovered for the payroll in the year.
SSP_RECOVERED	NUMBER	(10)		Amount of SSP recovered for the payroll in the year.
START_PREVIOUS_YEAR	DATE			Start date of the first period for the previous year.
START_YEAR	DATE			Start date of the first period in the year for this payroll.
TAX_DISTRICT_NAME	VARCHAR2	(40)		Name of the tax district.
TAX_DISTRICT_REFERENCE	NUMBER	(3)		Inspector of Taxes reference code.
TAX_REFERENCE_NUMBER	VARCHAR2	(7)		Unique reference number allocated to employer by the Inspector of Taxes.
TAX_YEAR	NUMBER	(4)		Calendar year in which the specific Financial year ends.

Query Text

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


SELECT PAYROLL_ID
,      BUSINESS_GROUP_ID
,      ECON
,      EMPLOYERS_ADDRESS_LINE
,      EMPLOYERS_NAME
,      END_PREVIOUS_YEAR
,      END_YEAR
,      MAX_PERIOD_NUMBER
,      PAYROLL_NAME
,      PERIOD_TYPE
,      PERMIT_NUMBER
,      SMP_COMPENSATION
,      SMP_RECOVERED
,      SSP_RECOVERED
,      START_PREVIOUS_YEAR
,      START_YEAR
,      TAX_DISTRICT_NAME
,      TAX_DISTRICT_REFERENCE
,      TAX_REFERENCE_NUMBER
,      TAX_YEAR
FROM HR.PAY_GB_YEAR_END_PAYROLLS;

Dependencies

[top of page]

HR.PAY_GB_YEAR_END_PAYROLLS does not reference any database object

HR.PAY_GB_YEAR_END_PAYROLLS is referenced by following:

APPS: PAY_GB_YEAR_END_PAYROLLS
PUBLIC: PAY_GB_YEAR_END_PAYROLLS