1. Tables and Views for Project Management
  2. PJC_XLA_PAYROLL_RUN_V

PJC_XLA_PAYROLL_RUN_V

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: VIEW

Columns

Name

RUN_ID

PAYROLL_ID

PAYROLL_NAME

PAYROLL_REL_ACTION_ID

COST_ACTION_TYPE

COST_ID

COST_ALLOCATION_KEYFLEX_ID

COST_ACTION_ID

RUN_ACTION_ID

Query

SQL_Statement

SELECT run_id,

PAYROLL_ID ,

PAYROLL_NAME PAYROLL_NAME,

PAYROLL_REL_ACTION_ID PAYROLL_REL_ACTION_ID,

COST_ACTION_TYPE COST_ACTION_TYPE,

COST_ID COST_ID,

COST_ALLOCATION_KEYFLEX_ID COST_ALLOCATION_KEYFLEX_ID,

COST_ACTION_ID COST_ACTION_ID,

RUN_ACTION_ID RUN_ACTION_ID

FROM PJC_ALLOC_RUNS_ALL