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_ASSIGNMENTS

Object Details

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

PAY_GB_YEAR_END_ASSIGNMENTS holds assignment information for the UK
End of Year (EOY) process. It stores information about the
assignments reported with the current balances for the assignments.
If an assignment has moved between PAYE schemes during the financial
year, a separate row is included with the balances at the time of
transfer.

Storage Details

Tablespace:	APPS_TS_ARCHIVE
PCT Free:	10
PCT Used:

Primary Key: PAY_GB_YEAR_END_ASSIGNMENT_PK

ASSIGNMENT_ID
EFFECTIVE_END_DATE

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_GB_YEAR_END_ASSIGNMENT_PK	NORMAL	UNIQUE	APPS_TS_ARCHIVE	ASSIGNMENT_ID EFFECTIVE_END_DATE
PAY_GB_YEAR_END_ASSIGNMENT_FK1	NORMAL	NONUNIQUE	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
PAY_GB_YEAR_END_VALUES		PAY_GB_YEAR_END_ASSIGNMENTS	PAY_GB_YEAR_END_VALUES ASSIGNMENT_ID PAY_GB_YEAR_END_VALUES EFFECTIVE_END_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
ASSIGNMENT_ID	NUMBER	(10)	Yes	System-generated primary key column.
EFFECTIVE_END_DATE	DATE		Yes	Effective end date for a specific assignment in the financial year.
PAYROLL_ID	NUMBER	(15)	Yes	Foreign key to PAY_GB_YEAR_END_PAYROLLS.
ASSIGNMENT_NUMBER	VARCHAR2	(14)		Employee assignment number.
CHUNK_NUMBER	NUMBER	(9)		Number used to group events into chunks for parallelization.
DATE_OF_BIRTH	DATE			Date of birth.
DIRECTOR_INDICATOR	VARCHAR2	(1)		Indicates whether a person has been a company director during the financial year, where D = director and null = employee
EFFECTIVE_START_DATE	DATE			Effective start date for the assignment. If it starts before the start of the financial year, the entry is null.
EOY_PRIMARY_FLAG	VARCHAR2	(1)		Indicates whether the assignment shows the NI balances for a person with multiple assignments, where Y = report NI.
EXPENSE_CHECK_SEND_TO_ADDRESS	VARCHAR2	(1)		O(office),H(home),Null flag indicates distribution for the P60.
EXTRACT_DATE	DATE			Date the extract was run.
FIRST_NAME	VARCHAR2	(16)		First name of employee.
GROSS_PAY	NUMBER	(9)		Gross pay from balance GROSS_PAY_ASG_TD_YTD.
LAST_ASG_ACTION_ID	NUMBER	(15)		Assignment action identifier of the latest action for the assignment.
LAST_EFFECTIVE_DATE	DATE			Effective date of the latest action for the assignment.
LAST_NAME	VARCHAR2	(20)		Last name of employee .
LOCATION_ID	NUMBER	(9)		Foreign key to HR_LOCATIONS.
MIDDLE_NAME	VARCHAR2	(7)		Middle name of employee.
MULTIPLE_ASG_FLAG	VARCHAR2	(1)		Indicates whether a person has multiple payroll assignments.
NATIONAL_INSURANCE_NUMBER	VARCHAR2	(9)		National identifier for the person.
ORGANIZATION_ID	NUMBER	(9)		Foreign key to HR_ORGANIZATION_UNITS.
PENSIONER_INDICATOR	VARCHAR2	(1)		Indicates whether a person is an employee or pensioner, where P = pensioner and null = employee.
PEOPLE_GROUP_ID	NUMBER	(15)		Foreign key to PAY_PEOPLE_GROUPS.
PERSON_ID	NUMBER	(10)		Foreign key to PER_PEOPLE.
PREVIOUS_TAXABLE_PAY	NUMBER	(9)		Previous taxable pay amount (taken from result PAYE_DETAILS_PAY_PREVIOUS).
PREVIOUS_TAX_PAID	NUMBER	(9)		Previous tax paid amount (taken from result PAYE_DETAILS_TAX_PREVIOUS).
PREVIOUS_YEAR_ASG_ACTION_ID	NUMBER	(15)		Assignment action identifier of the latest action in the previous year.
PREVIOUS_YEAR_EFFECTIVE_DATE	DATE			Effective date of the latest action in the previous year.
REQUEST_ID	NUMBER	(12)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
SEX	VARCHAR2	(1)		Identifies gender of person, where M = male and F = female.
SMP	NUMBER	(9)		Total SMP amount paid (taken from balance SMP_TOTAL_ASG_TD_YTD).
SSP	NUMBER	(9)		Total SSP amount paid (taken from balance SSP_TOTAL_ASG_TD_YTD).
SUPERANNUATION_PAID	NUMBER	(9)		Total amount of superannuation paid (taken from balance SUPERANNUATION_TOTAL_ASG_TD_YTD).
SUPERANNUATION_REFUND	VARCHAR2	(1)		Indicates whether superannuation was refunded, where R = refund and null = deduction.
TAXABLE_PAY	NUMBER	(9)		Total amount of taxable pay (taken from balance TAXABLE_PAY_ASG_TD_YTD).
TAX_CODE	VARCHAR2	(5)		Tax code for the latest tax calculation.
TAX_PAID	NUMBER			Total tax paid (taken from balance PAYE_ASG_TD_YTD).
TAX_REFUND	VARCHAR2	(1)		Indicates whether tax has been refunded, where R = refunded and null = deduction).
TAX_RUN_RESULT_ID	NUMBER	(15)		Run result that last updated PAYE this year.
TERMINATION_DATE	DATE			Actual termination date or the tax reference transfer date, if the employee has changed tax districts during the year.
TITLE	VARCHAR2	(30)		Employees title
START_OF_EMP	DATE			Start date of employment
TERMINATION_TYPE	VARCHAR2	(1)		Indicates the type of termination, where R = tax reference transfer and L = leaver.
W1_M1_INDICATOR	VARCHAR2	(1)		Indicates tax basis, if cumulative then null, if non-cumulative, then either W for weekly basis or M for Monthly.
WEEK_53_INDICATOR	VARCHAR2	(1)		3(53), 4(54), 6(56) , null(other) max. period no. in the year.
WIDOWS_AND_ORPHANS	NUMBER	(9)		Balance value from WIDOWS_AND_ORPHANS_ASG_TD_YTD.
ADDRESS_LINE1	VARCHAR2	(60)		Employees primary address line 1
ADDRESS_LINE2	VARCHAR2	(60)		Employees primary address line 2
ADDRESS_LINE3	VARCHAR2	(60)		Employees primary address line 3
TOWN_OR_CITY	VARCHAR2	(30)		Employees primary address town or city
COUNTY	VARCHAR2	(27)		Employess primary address county
POSTAL_CODE	VARCHAR2	(8)		Employees primary address postcode

Query Text

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


SELECT ASSIGNMENT_ID
,      EFFECTIVE_END_DATE
,      PAYROLL_ID
,      ASSIGNMENT_NUMBER
,      CHUNK_NUMBER
,      DATE_OF_BIRTH
,      DIRECTOR_INDICATOR
,      EFFECTIVE_START_DATE
,      EOY_PRIMARY_FLAG
,      EXPENSE_CHECK_SEND_TO_ADDRESS
,      EXTRACT_DATE
,      FIRST_NAME
,      GROSS_PAY
,      LAST_ASG_ACTION_ID
,      LAST_EFFECTIVE_DATE
,      LAST_NAME
,      LOCATION_ID
,      MIDDLE_NAME
,      MULTIPLE_ASG_FLAG
,      NATIONAL_INSURANCE_NUMBER
,      ORGANIZATION_ID
,      PENSIONER_INDICATOR
,      PEOPLE_GROUP_ID
,      PERSON_ID
,      PREVIOUS_TAXABLE_PAY
,      PREVIOUS_TAX_PAID
,      PREVIOUS_YEAR_ASG_ACTION_ID
,      PREVIOUS_YEAR_EFFECTIVE_DATE
,      REQUEST_ID
,      SEX
,      SMP
,      SSP
,      SUPERANNUATION_PAID
,      SUPERANNUATION_REFUND
,      TAXABLE_PAY
,      TAX_CODE
,      TAX_PAID
,      TAX_REFUND
,      TAX_RUN_RESULT_ID
,      TERMINATION_DATE
,      TITLE
,      START_OF_EMP
,      TERMINATION_TYPE
,      W1_M1_INDICATOR
,      WEEK_53_INDICATOR
,      WIDOWS_AND_ORPHANS
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      TOWN_OR_CITY
,      COUNTY
,      POSTAL_CODE
FROM HR.PAY_GB_YEAR_END_ASSIGNMENTS;

Dependencies

[top of page]

HR.PAY_GB_YEAR_END_ASSIGNMENTS does not reference any database object

HR.PAY_GB_YEAR_END_ASSIGNMENTS is referenced by following:

APPS: PAY_GB_YEAR_END_ASSIGNMENTS
PUBLIC: PAY_GB_YEAR_END_ASSIGNMENTS