[Home] [Help] [Dependency Information]
Object Name: | HRI_MAP_SUP_WRKFC |
---|---|
Object Type: | TABLE |
Owner: | HRI |
Subobject Name: | |
Status: | VALID |
This table summarizes headcount and salary changes to lowest required dimension levels
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HRI_MAP_SUP_WRKFC_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SUPERVISOR_PERSON_ID
EFFECTIVE_DATE JOB_ID GEO_CITY_CID POW_BAND_SK_FK |
HRI_MAP_SUP_WRKFC_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SUPERVISOR_PERSON_ID
ADMIN_ROW_COUNT |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUPERVISOR_PERSON_ID | NUMBER | |||
EFFECTIVE_DATE | DATE | |||
GEO_COUNTRY_CODE | VARCHAR2 | (70) | ||
GEO_REGION_CODE | VARCHAR2 | (160) | ||
GEO_CITY_CID | VARCHAR2 | (300) | ||
JOB_ID | NUMBER | |||
JOB_FNCTN_CODE | VARCHAR2 | (240) | ||
JOB_FMLY_CODE | VARCHAR2 | (240) | ||
ANL_SLRY_CURRENCY | VARCHAR2 | (30) | ||
ANL_SLRY_ADJUST | NUMBER | |||
HEADCOUNT_ADJUST | NUMBER | |||
FTE_ADJUST | NUMBER | |||
DR_ANL_SLRY_ADJUST | NUMBER | |||
DR_HEADCOUNT_ADJUST | NUMBER | |||
DR_FTE_ADJUST | NUMBER | |||
LEAVING_REASON_CODE | VARCHAR2 | (30) | ||
SEPARATION_CATEGORY | VARCHAR2 | (30) | ||
POW_BAND | NUMBER | |||
PERF_BAND | NUMBER | |||
HEADCOUNT_POW_BAND1_ADJUST | NUMBER | |||
HEADCOUNT_POW_BAND2_ADJUST | NUMBER | |||
HEADCOUNT_POW_BAND3_ADJUST | NUMBER | |||
HEADCOUNT_POW_BAND4_ADJUST | NUMBER | |||
HEADCOUNT_POW_BAND5_ADJUST | NUMBER | |||
HEADCOUNT_PERF_BAND1_ADJUST | NUMBER | |||
HEADCOUNT_PERF_BAND2_ADJUST | NUMBER | |||
HEADCOUNT_PERF_BAND3_ADJUST | NUMBER | |||
HEADCOUNT_PERF_BANDNA_ADJUST | NUMBER | |||
TERM_HEADCOUNT | NUMBER | |||
HIRE_HEADCOUNT | NUMBER | |||
POW_START_DATE_ADJUST | NUMBER | |||
DR_HEADCOUNT_POW_BAND1_ADJUST | NUMBER | |||
DR_HEADCOUNT_POW_BAND2_ADJUST | NUMBER | |||
DR_HEADCOUNT_POW_BAND3_ADJUST | NUMBER | |||
DR_HEADCOUNT_POW_BAND4_ADJUST | NUMBER | |||
DR_HEADCOUNT_POW_BAND5_ADJUST | NUMBER | |||
DR_HEADCOUNT_PERF_BAND1_ADJUST | NUMBER | |||
DR_HEADCOUNT_PERF_BAND2_ADJUST | NUMBER | |||
DR_HEADCOUNT_PERF_BAND3_ADJUST | NUMBER | |||
DR_HEADCOUNT_PERF_BANDNA_ADJUS | NUMBER | |||
DR_TERM_HEADCOUNT | NUMBER | |||
DR_HIRE_HEADCOUNT | NUMBER | |||
DR_POW_START_DATE_ADJUST | NUMBER | |||
PRIMARY_ASG_HDC_CNT_ADJUST | NUMBER | |||
DR_PRIMARY_ASG_HDC_CNT_ADJUST | NUMBER | |||
PRMY_HDC_POW_STRT_DT_ADJUST | NUMBER | |||
DR_PRMY_HDC_POW_STRT_DT_ADJUST | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
CREATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
PRIMARY_ASG_CNT_ADJUST | NUMBER | |||
DR_PRIMARY_ASG_CNT_ADJUST | NUMBER | |||
PRIMARY_POW_STRT_DT_ADJUST | NUMBER | |||
DR_PRIMARY_POW_STRT_DT_ADJUST | NUMBER | |||
ADMIN_ROW_COUNT | NUMBER | |||
PRIMARY_JOB_ROLE_CODE | VARCHAR2 | (30) | ||
WKTH_WKTYP_SK_FK | VARCHAR2 | (240) | ||
WKTH_LVL1_SK_FK | VARCHAR2 | (240) | ||
WKTH_LVL2_SK_FK | VARCHAR2 | (240) | ||
WKTH_WKTYP_CODE | VARCHAR2 | (30) | ||
POW_BAND_SK_FK | NUMBER | |||
GEO_AREA_CODE | VARCHAR2 | (40) | ||
PRIMARY_POW_EXTN_ADJUST | NUMBER | |||
DR_PRIMARY_POW_EXTN_ADJUST | NUMBER | |||
POW_EXTN_CNT_ADJUST | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SUPERVISOR_PERSON_ID
, EFFECTIVE_DATE
, GEO_COUNTRY_CODE
, GEO_REGION_CODE
, GEO_CITY_CID
, JOB_ID
, JOB_FNCTN_CODE
, JOB_FMLY_CODE
, ANL_SLRY_CURRENCY
, ANL_SLRY_ADJUST
, HEADCOUNT_ADJUST
, FTE_ADJUST
, DR_ANL_SLRY_ADJUST
, DR_HEADCOUNT_ADJUST
, DR_FTE_ADJUST
, LEAVING_REASON_CODE
, SEPARATION_CATEGORY
, POW_BAND
, PERF_BAND
, HEADCOUNT_POW_BAND1_ADJUST
, HEADCOUNT_POW_BAND2_ADJUST
, HEADCOUNT_POW_BAND3_ADJUST
, HEADCOUNT_POW_BAND4_ADJUST
, HEADCOUNT_POW_BAND5_ADJUST
, HEADCOUNT_PERF_BAND1_ADJUST
, HEADCOUNT_PERF_BAND2_ADJUST
, HEADCOUNT_PERF_BAND3_ADJUST
, HEADCOUNT_PERF_BANDNA_ADJUST
, TERM_HEADCOUNT
, HIRE_HEADCOUNT
, POW_START_DATE_ADJUST
, DR_HEADCOUNT_POW_BAND1_ADJUST
, DR_HEADCOUNT_POW_BAND2_ADJUST
, DR_HEADCOUNT_POW_BAND3_ADJUST
, DR_HEADCOUNT_POW_BAND4_ADJUST
, DR_HEADCOUNT_POW_BAND5_ADJUST
, DR_HEADCOUNT_PERF_BAND1_ADJUST
, DR_HEADCOUNT_PERF_BAND2_ADJUST
, DR_HEADCOUNT_PERF_BAND3_ADJUST
, DR_HEADCOUNT_PERF_BANDNA_ADJUS
, DR_TERM_HEADCOUNT
, DR_HIRE_HEADCOUNT
, DR_POW_START_DATE_ADJUST
, PRIMARY_ASG_HDC_CNT_ADJUST
, DR_PRIMARY_ASG_HDC_CNT_ADJUST
, PRMY_HDC_POW_STRT_DT_ADJUST
, DR_PRMY_HDC_POW_STRT_DT_ADJUST
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, PRIMARY_ASG_CNT_ADJUST
, DR_PRIMARY_ASG_CNT_ADJUST
, PRIMARY_POW_STRT_DT_ADJUST
, DR_PRIMARY_POW_STRT_DT_ADJUST
, ADMIN_ROW_COUNT
, PRIMARY_JOB_ROLE_CODE
, WKTH_WKTYP_SK_FK
, WKTH_LVL1_SK_FK
, WKTH_LVL2_SK_FK
, WKTH_WKTYP_CODE
, POW_BAND_SK_FK
, GEO_AREA_CODE
, PRIMARY_POW_EXTN_ADJUST
, DR_PRIMARY_POW_EXTN_ADJUST
, POW_EXTN_CNT_ADJUST
FROM HRI.HRI_MAP_SUP_WRKFC;
HRI.HRI_MAP_SUP_WRKFC does not reference any database object
HRI.HRI_MAP_SUP_WRKFC is referenced by following:
|
|
|