View: HR_EDW_WRK_CMPSTN_FCV

View Text

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

Columns