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: TablePAY.PAY_ZA_TAX_REGISTERS
Subobject Name:
Status: VALID


PAY_ZA_TAX_REGISTERS is used for the South African Tax Register Report.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
PAY_ZA_TAX_REGISTERS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAX_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:

SchemaHR
ViewPAY_ZA_TAX_REGISTERS#