VIEW: HR.PAY_ZA_TAX_REGISTERS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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