1. Tables and Views for Project Management
  2. PJC_PAYROLL_PER_ASSIGNMENT_V

PJC_PAYROLL_PER_ASSIGNMENT_V

Details

  • Schema: FUSION

  • Object owner: PJC

  • Object type: VIEW

Columns

Name

PERSON_ID

ASSIGNMENT_ID

START_DATE_ACTIVE

END_DATE_ACTIVE

Query

SQL_Statement

SELECT

PERSON_ID,

ASSIGNMENT_ID,

START_DATE_ACTIVE,

END_DATE_ACTIVE

FROM

pjc_alloc_rules_all

WHERE ld_version_status = 'A'

AND type IN ( 'ASE', 'ASG' )