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_ZA_TAX_REGISTERS

Object Details

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

PAY_ZA_TAX_REGISTERS is used for the South African Tax Register Report.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_ZA_TAX_REGISTERS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TAX_REGISTER_ID

Columns

Name	Datatype	Length	Mandatory	Comments
TAX_REGISTER_ID	NUMBER		Yes	Tax Register ID
FULL_NAME	VARCHAR2	(240)		Full name
FIRST_NAME	VARCHAR2	(20)		First name
LAST_NAME	VARCHAR2	(40)		Last name
MIDDLE_NAMES	VARCHAR2	(60)		Middle names
EMPLOYEE_NUMBER	VARCHAR2	(30)		Employee Number
PERSON_ID	NUMBER	(9)		Person ID
DATE_OF_BIRTH	DATE			Date of birth
AGE	NUMBER			Age
TAX_REFERENCE_NO	VARCHAR2	(150)		Tax reference number
ASSIGNMENT_ID	NUMBER	(9)		Assignment ID
ASSIGNMENT_ACTION_ID	NUMBER	(15)		Assignment action ID
ASSIGNMENT_NUMBER	VARCHAR2	(30)		Assignment number
ASSIGNMENT_START_DATE	DATE			Assignment start date
HIRE_DATE	DATE			Hire date
ASSIGNMENT_END_DATE	DATE			Assignment end date
REG_PAYMENT_DATE	DATE			Regular Payment Date
END_DATE	DATE			End date
TERMINATION_DATE	DATE			Termination date
TIME_PERIOD_ID	NUMBER	(15)		Payroll Period ID
LOCATION_CODE	VARCHAR2	(20)		Location Code
BAL_NAME	VARCHAR2	(80)		Balance Name
BAL_CODE	NUMBER			Balance Code
TOT_PTD	NUMBER			Total PTD amount
TOT_MTD	NUMBER			Total MTD amount
TOT_YTD	NUMBER			Total YTD amount
CMPY_TAX_REFERENCE_NO	VARCHAR2	(150)		Cmpy Tax Reference No
TAX_STATUS	VARCHAR2	(60)		Tax Status
TAX_DIRECTIVE_VALUE	VARCHAR2	(60)		Tax Directive Value
DAYS_WORKED	NUMBER			Days Worked

Query Text

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


SELECT TAX_REGISTER_ID
,      FULL_NAME
,      FIRST_NAME
,      LAST_NAME
,      MIDDLE_NAMES
,      EMPLOYEE_NUMBER
,      PERSON_ID
,      DATE_OF_BIRTH
,      AGE
,      TAX_REFERENCE_NO
,      ASSIGNMENT_ID
,      ASSIGNMENT_ACTION_ID
,      ASSIGNMENT_NUMBER
,      ASSIGNMENT_START_DATE
,      HIRE_DATE
,      ASSIGNMENT_END_DATE
,      REG_PAYMENT_DATE
,      END_DATE
,      TERMINATION_DATE
,      TIME_PERIOD_ID
,      LOCATION_CODE
,      BAL_NAME
,      BAL_CODE
,      TOT_PTD
,      TOT_MTD
,      TOT_YTD
,      CMPY_TAX_REFERENCE_NO
,      TAX_STATUS
,      TAX_DIRECTIVE_VALUE
,      DAYS_WORKED
FROM HR.PAY_ZA_TAX_REGISTERS;

Dependencies

[top of page]

HR.PAY_ZA_TAX_REGISTERS does not reference any database object

HR.PAY_ZA_TAX_REGISTERS is referenced by following:

APPS: PAY_ZA_TAX_REGISTERS
PUBLIC: PAY_ZA_TAX_REGISTERS