1. Tables and Views for HCM
  2. PAY_ALL_PAYROLL_ACTIONS_V

PAY_ALL_PAYROLL_ACTIONS_V

Details

  • Schema: FUSION

  • Object owner: PAY

  • Object type: VIEW

Columns

Name

ACTION_STORAGE

PAYROLL_ACTION_ID

ACTION_STATUS

ACTION_TYPE

LEGISLATIVE_DATA_GROUP_ID

ENTERPRISE_ID

LEGISLATION_CODE

ACTION_POPULATION_STATUS

CURRENT_CHUNK_NUMBER

DISPLAY_RUN_NUMBER

PAY_REQUEST_ID

ACTION_SEQUENCE

ACTION_PARAMETER_GROUP_ID

START_DATE

END_DATE

EFFECTIVE_DATE

PAYROLL_ID

CONSOLIDATION_SET_ID

ELEMENT_SET_ID

DATE_EARNED

RUN_TYPE_ID

ASSIGNMENT_SET_ID

PAYMENT_TYPE_ID

EARN_TIME_PERIOD_ID

DEDN_TIME_PERIOD_ID

BATCH_PROCESS_MODE

LEGISLATIVE_PARAMETERS

RETRO_DEFINITION_ID

FUTURE_PROCESS_MODE

COSTING_PROCESS_MODE

TARGET_PAYROLL_ACTION_ID

CREATOR_ID

CREATOR_TYPE

CURRENT_TASK

ORG_PAYMENT_METHOD_ID

PARENT_ORG_PAY_METHOD_ID

START_CHEQUE_NUMBER

END_CHEQUE_NUMBER

OVERRIDING_DD_DATE

REPORT_CATEGORY_ID

CHEQUE_PROCEDURE

REPORT_FORMAT_MAPPING_ID

EFT_FILE_REFERENCE

EFT_EXPIRY_DATE

BIP_JOB_ID

INTERFACE_TYPE_ID

PAYMENT_REASON

FILE_NAME

PARAMETER1

PARAMETER2

PARAMETER3

PARAMETER4

PARAMETER5

PROCESS_EVENT_ID

EVENT_ACTION_ID

PAY_PAYEE_TYPE

EXPEDITE_FLAG

EXPIRE_ID

PROCESS_PHASE

OVERRIDE_DATE

OBJECT_VERSION_NUMBER

LAST_UPDATE_DATE

CREATION_DATE

LAST_UPDATE_LOGIN

LAST_UPDATED_BY

CREATED_BY

Query

SQL_Statement

SELECT 'PERM' ACTION_STORAGE,

PAYROLL_ACTION_ID,

ACTION_STATUS,

ACTION_TYPE,

LEGISLATIVE_DATA_GROUP_ID,

ENTERPRISE_ID,

LEGISLATION_CODE,

ACTION_POPULATION_STATUS,

CURRENT_CHUNK_NUMBER,

DISPLAY_RUN_NUMBER,

PAY_REQUEST_ID,

ACTION_SEQUENCE,

ACTION_PARAMETER_GROUP_ID,

START_DATE,

END_DATE,

EFFECTIVE_DATE,

PAYROLL_ID,

CONSOLIDATION_SET_ID,

ELEMENT_SET_ID,

DATE_EARNED,

RUN_TYPE_ID,

ASSIGNMENT_SET_ID,

PAYMENT_TYPE_ID,

EARN_TIME_PERIOD_ID,

DEDN_TIME_PERIOD_ID,

BATCH_PROCESS_MODE,

LEGISLATIVE_PARAMETERS,

RETRO_DEFINITION_ID,

FUTURE_PROCESS_MODE,

COSTING_PROCESS_MODE,

TARGET_PAYROLL_ACTION_ID,

CREATOR_ID,

CREATOR_TYPE,

CURRENT_TASK,

ORG_PAYMENT_METHOD_ID,

PARENT_ORG_PAY_METHOD_ID,

START_CHEQUE_NUMBER,

END_CHEQUE_NUMBER,

OVERRIDING_DD_DATE,

REPORT_CATEGORY_ID,

CHEQUE_PROCEDURE,

REPORT_FORMAT_MAPPING_ID,

EFT_FILE_REFERENCE,

EFT_EXPIRY_DATE,

BIP_JOB_ID,

INTERFACE_TYPE_ID,

PAYMENT_REASON,

FILE_NAME,

PARAMETER1,

PARAMETER2,

PARAMETER3,

PARAMETER4,

PARAMETER5,

PROCESS_EVENT_ID,

EVENT_ACTION_ID,

PAY_PAYEE_TYPE,

EXPEDITE_FLAG,

EXPIRE_ID,

PROCESS_PHASE,

OVERRIDE_DATE,

OBJECT_VERSION_NUMBER,

LAST_UPDATE_DATE,

CREATION_DATE,

LAST_UPDATE_LOGIN,

LAST_UPDATED_BY,

CREATED_BY

FROM

pay_payroll_actions

UNION ALL

SELECT 'TEMP',

PAYROLL_ACTION_ID,

ACTION_STATUS,

ACTION_TYPE,

LEGISLATIVE_DATA_GROUP_ID,

ENTERPRISE_ID,

LEGISLATION_CODE,

ACTION_POPULATION_STATUS,

CURRENT_CHUNK_NUMBER,

null,

PAY_REQUEST_ID,

ACTION_SEQUENCE,

ACTION_PARAMETER_GROUP_ID,

START_DATE,

END_DATE,

EFFECTIVE_DATE,

PAYROLL_ID,

CONSOLIDATION_SET_ID,

null,

null,

null,

null,

null,

null,

null,

null,

LEGISLATIVE_PARAMETERS,

null,

null,

null,

TARGET_PAYROLL_ACTION_ID,

null,

null,

CURRENT_TASK,

null,

null,

null,

null,

null,

null,

null,

null,

null,

null,

null,

null,

null,

null,

PARAMETER1,

PARAMETER2,

PARAMETER3,

PARAMETER4,

PARAMETER5,

PROCESS_EVENT_ID,

EVENT_ACTION_ID,

null,

null,

null,

null,

null,

OBJECT_VERSION_NUMBER,

LAST_UPDATE_DATE,

CREATION_DATE,

LAST_UPDATE_LOGIN,

LAST_UPDATED_BY,

CREATED_BY

FROM

pay_temp_payroll_actions