DBA Data[Home] [Help] [Dependency Information]

VIEW: HR.PAY_ZA_TAX_REGISTERS#

Object Details
Object Name: PAY_ZA_TAX_REGISTERS#
Object Type: VIEW
Owner: HR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
TAX_REGISTER_ID NUMBER
Yes
FULL_NAME VARCHAR2 (240)
FIRST_NAME VARCHAR2 (20)
LAST_NAME VARCHAR2 (40)
MIDDLE_NAMES VARCHAR2 (60)
EMPLOYEE_NUMBER VARCHAR2 (30)
PERSON_ID NUMBER (9)
DATE_OF_BIRTH DATE

AGE NUMBER

TAX_REFERENCE_NO VARCHAR2 (150)
ASSIGNMENT_ID NUMBER (9)
ASSIGNMENT_ACTION_ID NUMBER (15)
ASSIGNMENT_NUMBER VARCHAR2 (30)
ASSIGNMENT_START_DATE DATE

HIRE_DATE DATE

ASSIGNMENT_END_DATE DATE

REG_PAYMENT_DATE DATE

END_DATE DATE

TERMINATION_DATE DATE

TIME_PERIOD_ID NUMBER (15)
LOCATION_CODE VARCHAR2 (20)
BAL_NAME VARCHAR2 (80)
BAL_CODE NUMBER

TOT_PTD NUMBER

TOT_MTD NUMBER

TOT_YTD NUMBER

CMPY_TAX_REFERENCE_NO VARCHAR2 (150)
TAX_STATUS VARCHAR2 (60)
TAX_DIRECTIVE_VALUE VARCHAR2 (60)
DAYS_WORKED NUMBER

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# references the following:

SchemaHR
TablePAY_ZA_TAX_REGISTERS
HR.PAY_ZA_TAX_REGISTERS# is referenced by following:

SchemaAPPS
SynonymPAY_ZA_TAX_REGISTERS