[Home] [Help]
View: EDW_ORGA_ORG_LCV
| Product: | HRI - Human Resources Intelligence (Obsolete) |
|---|
| Description: | EDW_ORGA_ORG_LCV is the collection view for Organization level of Organization dimension |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT ORGANIZATION_PK
, OPERATING_UNIT_FK
, ORG_TREE1_LVL1_FK
, NAME
, ORGANIZATION_DP
, DATE_FROM
, DATE_TO
, BUSINESS_GROUP
, ORG_INT_EXT_FLAG
, ORG_TYPE
, ORG_CODE
, ORG_PRIM_CST_MTHD
, INSTANCE
, ORGANIZATION_ID
, LEVEL_NAME
, PERSON_MANAGER_ID
, PERSON_MANAGER_FK
, PERSON_MANAGER_FK_KEY
, ORG_CAT1
, ORG_CAT2
, ORG_CAT3
, ORG_CAT4
, ORG_CAT5
, ORG_CAT6
, ORG_CAT7
, ORG_CAT8
, ORG_CAT9
, ORG_CAT10
, ORG_CAT11
, ORG_CAT12
, ORG_CAT13
, ORG_CAT14
, ORG_CAT15
, LAST_UPDATE_DATE
, CREATION_DATE
, NULL
, NULL
, NULL
, NULL
, NULL
FROM EDWBV_ORGA_ORG_LCV
Columns
| Name |
| ORGANIZATION_PK |
| OPERATING_UNIT_FK |
| ORG_TREE1_LVL1_FK |
| NAME |
| ORGANIZATION_DP |
| DATE_FROM |
| DATE_TO |
| BUSINESS_GROUP |
| ORG_INT_EXT_FLAG |
| ORG_TYPE |
| ORG_CODE |
| ORG_PRIM_CST_MTHD |
| INSTANCE |
| ORGANIZATION_ID |
| LEVEL_NAME |
| PERSON_MANAGER_ID |
| PERSON_MANAGER_FK |
| PERSON_MANAGER_FK_KEY |
| ORG_CAT1 |
| ORG_CAT2 |
| ORG_CAT3 |
| ORG_CAT4 |
| ORG_CAT5 |
| ORG_CAT6 |
| ORG_CAT7 |
| ORG_CAT8 |
| ORG_CAT9 |
| ORG_CAT10 |
| ORG_CAT11 |
| ORG_CAT12 |
| ORG_CAT13 |
| ORG_CAT14 |
| ORG_CAT15 |
| LAST_UPDATE_DATE |
| CREATION_DATE |
| USER_ATTRIBUTE1 |
| USER_ATTRIBUTE2 |
| USER_ATTRIBUTE3 |
| USER_ATTRIBUTE4 |
| USER_ATTRIBUTE5 |