VIEW: HR.PAY_PAYROLL_ACTIONS#

Source

View Text - Preformatted

select PAYROLL_ACTION_ID PAYROLL_ACTION_ID, ACTION_TYPE ACTION_TYPE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CONSOLIDATION_SET_ID CONSOLIDATION_SET_ID, PAYROLL_ID PAYROLL_ID, ORG_PAYMENT_METHOD_ID ORG_PAYMENT_METHOD_ID, PAYMENT_TYPE_ID PAYMENT_TYPE_ID, ACTION_POPULATION_STATUS ACTION_POPULATION_STATUS, ACTION_STATUS ACTION_STATUS, EFFECTIVE_DATE EFFECTIVE_DATE, ACTION_SEQUENCE ACTION_SEQUENCE, CHEQUE_PROCEDURE CHEQUE_PROCEDURE, CHEQUE_REPORT CHEQUE_REPORT, CURRENT_CHUNK_NUMBER CURRENT_CHUNK_NUMBER, CURRENT_TASK CURRENT_TASK, END_CHEQUE_NUMBER END_CHEQUE_NUMBER, LEGISLATIVE_PARAMETERS LEGISLATIVE_PARAMETERS, OVERRIDING_DD_DATE OVERRIDING_DD_DATE, REQUEST_ID REQUEST_ID, START_CHEQUE_NUMBER START_CHEQUE_NUMBER, START_DATE START_DATE, ELEMENT_SET_ID ELEMENT_SET_ID, ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID, DATE_EARNED DATE_EARNED, DISPLAY_RUN_NUMBER DISPLAY_RUN_NUMBER, PAY_ADVICE_DATE PAY_ADVICE_DATE, PAY_ADVICE_MESSAGE PAY_ADVICE_MESSAGE, BACKPAY_SET_ID BACKPAY_SET_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, ATTRIBUTE16 ATTRIBUTE16, ATTRIBUTE17 ATTRIBUTE17, ATTRIBUTE18 ATTRIBUTE18, ATTRIBUTE19 ATTRIBUTE19, ATTRIBUTE20 ATTRIBUTE20, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, TARGET_PAYROLL_ACTION_ID TARGET_PAYROLL_ACTION_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, TIME_PERIOD_ID TIME_PERIOD_ID, REPORT_TYPE REPORT_TYPE, REPORT_QUALIFIER REPORT_QUALIFIER, MAGNETIC_FILE_NAME MAGNETIC_FILE_NAME, REPORT_FILE_NAME REPORT_FILE_NAME, REPORT_CATEGORY REPORT_CATEGORY, RUN_TYPE_ID RUN_TYPE_ID, END_DATE END_DATE, PURGE_PHASE PURGE_PHASE, BALANCE_SET_ID BALANCE_SET_ID, FUTURE_PROCESS_MODE FUTURE_PROCESS_MODE, BATCH_ID BATCH_ID, BATCH_PROCESS_MODE BATCH_PROCESS_MODE, ACTION_PARAMETER_GROUP_ID ACTION_PARAMETER_GROUP_ID, COMMENTS COMMENTS, ELEMENT_TYPE_ID ELEMENT_TYPE_ID, COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID, BALANCE_ADJ_COST_FLAG BALANCE_ADJ_COST_FLAG, RETRO_DEFINITION_ID RETRO_DEFINITION_ID from "HR"."PAY_PAYROLL_ACTIONS"

View Text - HTML Formatted

SELECT PAYROLL_ACTION_ID PAYROLL_ACTION_ID
, ACTION_TYPE ACTION_TYPE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CONSOLIDATION_SET_ID CONSOLIDATION_SET_ID
, PAYROLL_ID PAYROLL_ID
, ORG_PAYMENT_METHOD_ID ORG_PAYMENT_METHOD_ID
, PAYMENT_TYPE_ID PAYMENT_TYPE_ID
, ACTION_POPULATION_STATUS ACTION_POPULATION_STATUS
, ACTION_STATUS ACTION_STATUS
, EFFECTIVE_DATE EFFECTIVE_DATE
, ACTION_SEQUENCE ACTION_SEQUENCE
, CHEQUE_PROCEDURE CHEQUE_PROCEDURE
, CHEQUE_REPORT CHEQUE_REPORT
, CURRENT_CHUNK_NUMBER CURRENT_CHUNK_NUMBER
, CURRENT_TASK CURRENT_TASK
, END_CHEQUE_NUMBER END_CHEQUE_NUMBER
, LEGISLATIVE_PARAMETERS LEGISLATIVE_PARAMETERS
, OVERRIDING_DD_DATE OVERRIDING_DD_DATE
, REQUEST_ID REQUEST_ID
, START_CHEQUE_NUMBER START_CHEQUE_NUMBER
, START_DATE START_DATE
, ELEMENT_SET_ID ELEMENT_SET_ID
, ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID
, DATE_EARNED DATE_EARNED
, DISPLAY_RUN_NUMBER DISPLAY_RUN_NUMBER
, PAY_ADVICE_DATE PAY_ADVICE_DATE
, PAY_ADVICE_MESSAGE PAY_ADVICE_MESSAGE
, BACKPAY_SET_ID BACKPAY_SET_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE16 ATTRIBUTE16
, ATTRIBUTE17 ATTRIBUTE17
, ATTRIBUTE18 ATTRIBUTE18
, ATTRIBUTE19 ATTRIBUTE19
, ATTRIBUTE20 ATTRIBUTE20
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, TARGET_PAYROLL_ACTION_ID TARGET_PAYROLL_ACTION_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, TIME_PERIOD_ID TIME_PERIOD_ID
, REPORT_TYPE REPORT_TYPE
, REPORT_QUALIFIER REPORT_QUALIFIER
, MAGNETIC_FILE_NAME MAGNETIC_FILE_NAME
, REPORT_FILE_NAME REPORT_FILE_NAME
, REPORT_CATEGORY REPORT_CATEGORY
, RUN_TYPE_ID RUN_TYPE_ID
, END_DATE END_DATE
, PURGE_PHASE PURGE_PHASE
, BALANCE_SET_ID BALANCE_SET_ID
, FUTURE_PROCESS_MODE FUTURE_PROCESS_MODE
, BATCH_ID BATCH_ID
, BATCH_PROCESS_MODE BATCH_PROCESS_MODE
, ACTION_PARAMETER_GROUP_ID ACTION_PARAMETER_GROUP_ID
, COMMENTS COMMENTS
, ELEMENT_TYPE_ID ELEMENT_TYPE_ID
, COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID
, BALANCE_ADJ_COST_FLAG BALANCE_ADJ_COST_FLAG
, RETRO_DEFINITION_ID RETRO_DEFINITION_ID
FROM "HR"."PAY_PAYROLL_ACTIONS"