[Home] [Help]
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
Name |
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 |
USER_MEASURE1 |
USER_MEASURE2 |
USER_MEASURE3 |
USER_MEASURE4 |
USER_MEASURE5 |
USER_ATTRIBUTE1 |
USER_ATTRIBUTE2 |
USER_ATTRIBUTE3 |
USER_ATTRIBUTE4 |
USER_ATTRIBUTE5 |
USER_ATTRIBUTE6 |
USER_ATTRIBUTE7 |
USER_ATTRIBUTE8 |
USER_ATTRIBUTE9 |
USER_ATTRIBUTE10 |
USER_ATTRIBUTE11 |
USER_ATTRIBUTE12 |
USER_ATTRIBUTE13 |
USER_ATTRIBUTE14 |
USER_ATTRIBUTE15 |
USER_FK1 |
USER_FK2 |
USER_FK3 |
USER_FK4 |
USER_FK5 |