VIEW: HR.PAY_GB_YEAR_END_ASSIGNMENTS#

Source

View Text - Preformatted

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

View Text - HTML Formatted

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