VIEW: APPS.HR_EDW_WRK_CMPSTN_FCV

Source

View Text - Preformatted

SELECT composition_pk ,age_band_fk ,service_band_fk ,assignment_fk ,currency_fk ,geography_fk ,grade_fk ,instance_fk ,job_fk ,organization_fk ,person_fk ,person_type_fk ,position_fk ,time_fk ,asg_assignment_id ,asg_business_group_id ,asg_grade_id ,asg_job_id ,asg_location_id ,asg_organization_id ,asg_person_id ,asg_position_id ,snapshot_date ,assignment_start_date ,date_of_birth ,last_update_date ,creation_date ,composition_headcount ,composition_fte ,lwst_grd_slry ,hghst_grd_slry ,crrncy_cnvrsn_rate ,crnt_annlzed_slry ,crnt_annlzed_slry_bc ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null ,null FROM hr_edwbv_wrk_cmpstn_fcv

View Text - HTML Formatted

SELECT COMPOSITION_PK
, AGE_BAND_FK
, SERVICE_BAND_FK
, ASSIGNMENT_FK
, CURRENCY_FK
, GEOGRAPHY_FK
, GRADE_FK
, INSTANCE_FK
, JOB_FK
, ORGANIZATION_FK
, PERSON_FK
, PERSON_TYPE_FK
, POSITION_FK
, TIME_FK
, ASG_ASSIGNMENT_ID
, ASG_BUSINESS_GROUP_ID
, ASG_GRADE_ID
, ASG_JOB_ID
, ASG_LOCATION_ID
, ASG_ORGANIZATION_ID
, ASG_PERSON_ID
, ASG_POSITION_ID
, SNAPSHOT_DATE
, ASSIGNMENT_START_DATE
, DATE_OF_BIRTH
, LAST_UPDATE_DATE
, CREATION_DATE
, COMPOSITION_HEADCOUNT
, COMPOSITION_FTE
, LWST_GRD_SLRY
, HGHST_GRD_SLRY
, CRRNCY_CNVRSN_RATE
, CRNT_ANNLZED_SLRY
, CRNT_ANNLZED_SLRY_BC
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM HR_EDWBV_WRK_CMPSTN_FCV