VIEW: PA.PA_PAY_EXTERNAL_INTERFACE#

Source

View Text - Preformatted

select BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PAYROLL_NAME PAYROLL_NAME, TIME_PERIOD_START_DATE TIME_PERIOD_START_DATE, TIME_PERIOD_END_DATE TIME_PERIOD_END_DATE, PERSON_ID PERSON_ID, ASSIGNMENT_ID ASSIGNMENT_ID, PAY_SOURCE_ORGANIZATION_ID PAY_SOURCE_ORGANIZATION_ID, PAY_SOURCE_PROJECT_ID PAY_SOURCE_PROJECT_ID, PAY_SOURCE_TASK_ID PAY_SOURCE_TASK_ID, PAY_ELEMENT_TYPE_CODE PAY_ELEMENT_TYPE_CODE, PAY_CURRENCY_CODE PAY_CURRENCY_CODE, PAY_AMOUNT PAY_AMOUNT, PAYROLL_BATCH_ID PAYROLL_BATCH_ID, TRANSFER_STATUS_FLAG TRANSFER_STATUS_FLAG, TRANSFER_REJECTION_CODE TRANSFER_REJECTION_CODE, RETRO_PERIOD_START_DATE RETRO_PERIOD_START_DATE, RETRO_PERIOD_END_DATE RETRO_PERIOD_END_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID from "PA"."PA_PAY_EXTERNAL_INTERFACE"

View Text - HTML Formatted

SELECT BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PAYROLL_NAME PAYROLL_NAME
, TIME_PERIOD_START_DATE TIME_PERIOD_START_DATE
, TIME_PERIOD_END_DATE TIME_PERIOD_END_DATE
, PERSON_ID PERSON_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, PAY_SOURCE_ORGANIZATION_ID PAY_SOURCE_ORGANIZATION_ID
, PAY_SOURCE_PROJECT_ID PAY_SOURCE_PROJECT_ID
, PAY_SOURCE_TASK_ID PAY_SOURCE_TASK_ID
, PAY_ELEMENT_TYPE_CODE PAY_ELEMENT_TYPE_CODE
, PAY_CURRENCY_CODE PAY_CURRENCY_CODE
, PAY_AMOUNT PAY_AMOUNT
, PAYROLL_BATCH_ID PAYROLL_BATCH_ID
, TRANSFER_STATUS_FLAG TRANSFER_STATUS_FLAG
, TRANSFER_REJECTION_CODE TRANSFER_REJECTION_CODE
, RETRO_PERIOD_START_DATE RETRO_PERIOD_START_DATE
, RETRO_PERIOD_END_DATE RETRO_PERIOD_END_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
FROM "PA"."PA_PAY_EXTERNAL_INTERFACE"