[Home] [Help] [Dependency Information]
Object Name: | HRI_MAP_SUP_WRKFC_ASG |
---|---|
Object Type: | TABLE |
Owner: | HRI |
FND Design Data: | HRI.HRI_MAP_SUP_WRKFC_ASG |
Subobject Name: | |
Status: | VALID |
This table contain assignment and supervisor changes attributed up to supervisors over time
Tablespace: | |
---|---|
PCT Free: | |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
HRI_MAP_SUP_WRKFC_ASG_N1 | NORMAL | NONUNIQUE |
SUPERVISOR_PERSON_ID
EFFECTIVE_END_DATE EFFECTIVE_DATE JOB_FMLY_CODE JOB_FNCTN_CODE GEO_COUNTRY_CODE POW_BAND PERF_BAND | |
HRI_MAP_SUP_WRKFC_ASG_N4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
ASSIGNMENT_ID
EVTS_EFFECTIVE_END_DATE |
HRI_MAP_SUP_WRKFC_ASG_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
SUB_ASSIGNMENT_ID
SUPH_EFFECTIVE_END_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SUPERVISOR_PERSON_ID | NUMBER | |||
DIRECT_SUPERVISOR_PERSON_ID | NUMBER | |||
EFFECTIVE_DATE | DATE | |||
POW_START_DATE | DATE | |||
EVENT_ID | NUMBER | |||
PERSON_ID | NUMBER | |||
ASSIGNMENT_ID | NUMBER | |||
LOCATION_ID | NUMBER | |||
JOB_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
POSITION_ID | NUMBER | |||
GRADE_ID | NUMBER | |||
JOB_FMLY_CODE | VARCHAR2 | (240) | ||
JOB_FNCTN_CODE | VARCHAR2 | (240) | ||
GEO_AREA_CODE | VARCHAR2 | (40) | ||
GEO_COUNTRY_CODE | VARCHAR2 | (70) | ||
GEO_REGION_CODE | VARCHAR2 | (160) | ||
GEO_CITY_CID | VARCHAR2 | (300) | ||
LEAVING_REASON_CODE | VARCHAR2 | (30) | ||
SEPARATION_CATEGORY | VARCHAR2 | (30) | ||
POW_BAND | NUMBER | |||
PERF_BAND | NUMBER | |||
ANL_SLRY_CURRENCY | VARCHAR2 | (30) | ||
ANL_SLRY_VALUE | NUMBER | |||
HEADCOUNT_VALUE | NUMBER | |||
FTE_VALUE | NUMBER | |||
WORKER_HIRE_IND | NUMBER | |||
POST_HIRE_ASGN_START_IND | NUMBER | |||
WORKER_TERM_IND | NUMBER | |||
TERM_VOLUNTARY_IND | NUMBER | |||
TERM_INVOLUNTARY_IND | NUMBER | |||
PRE_SPRTN_ASGN_END_IND | NUMBER | |||
TRANSFER_IN_IND | NUMBER | |||
TRANSFER_OUT_IND | NUMBER | |||
POW_BAND1_IND | NUMBER | |||
POW_BAND2_IND | NUMBER | |||
POW_BAND3_IND | NUMBER | |||
POW_BAND4_IND | NUMBER | |||
POW_BAND5_IND | NUMBER | |||
PERF_BAND1_IND | NUMBER | |||
PERF_BAND2_IND | NUMBER | |||
PERF_BAND3_IND | NUMBER | |||
PERF_BANDNA_IND | NUMBER | |||
DIRECT_IND | NUMBER | |||
METRIC_ADJUST_MULTIPLIER | NUMBER | |||
SUPERVISOR_LEVEL | NUMBER | |||
ADMIN_ROW_TYPE | VARCHAR2 | (19) | ||
ADMIN_EVTS_ROWID | ROWID | (10) | ||
ADMIN_SUPH_ROWID | ROWID | (10) | ||
ADMIN_JOBH_ROWID | ROWID | (10) | ||
ADMIN_GEOH_ROWID | ROWID | (10) | ||
EVTS_EFFECTIVE_END_DATE | DATE | |||
SUPH_EFFECTIVE_END_DATE | DATE | |||
PRIMARY_FLAG_IND | NUMBER | |||
PRIMARY_ASG_WITH_HDC_IND | NUMBER | |||
EFFECTIVE_END_DATE | DATE | |||
SUB_ASSIGNMENT_ID | NUMBER | |||
POW_VALUE_DAYS_JULIAN | NUMBER | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | |||
LAST_UPDATE_LOGIN | NUMBER | |||
CREATED_BY | NUMBER | |||
CREATION_DATE | DATE | |||
SUMMARIZATION_RQD_IND | NUMBER | |||
SUMMARIZATION_RQD_CHNG_IND | NUMBER | |||
PRIMARY_JOB_ROLE_CODE | VARCHAR2 | (30) | ||
WKTH_WKTYP_SK_FK | VARCHAR2 | (40) | ||
WKTH_LVL1_SK_FK | VARCHAR2 | (40) | ||
WKTH_LVL2_SK_FK | VARCHAR2 | (40) | ||
WKTH_WKTYP_CODE | VARCHAR2 | (30) | ||
POW_BAND_SK_FK | NUMBER | |||
POW_EXTN_DAYS_JULIAN | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT SUPERVISOR_PERSON_ID
, DIRECT_SUPERVISOR_PERSON_ID
, EFFECTIVE_DATE
, POW_START_DATE
, EVENT_ID
, PERSON_ID
, ASSIGNMENT_ID
, LOCATION_ID
, JOB_ID
, ORGANIZATION_ID
, POSITION_ID
, GRADE_ID
, JOB_FMLY_CODE
, JOB_FNCTN_CODE
, GEO_AREA_CODE
, GEO_COUNTRY_CODE
, GEO_REGION_CODE
, GEO_CITY_CID
, LEAVING_REASON_CODE
, SEPARATION_CATEGORY
, POW_BAND
, PERF_BAND
, ANL_SLRY_CURRENCY
, ANL_SLRY_VALUE
, HEADCOUNT_VALUE
, FTE_VALUE
, WORKER_HIRE_IND
, POST_HIRE_ASGN_START_IND
, WORKER_TERM_IND
, TERM_VOLUNTARY_IND
, TERM_INVOLUNTARY_IND
, PRE_SPRTN_ASGN_END_IND
, TRANSFER_IN_IND
, TRANSFER_OUT_IND
, POW_BAND1_IND
, POW_BAND2_IND
, POW_BAND3_IND
, POW_BAND4_IND
, POW_BAND5_IND
, PERF_BAND1_IND
, PERF_BAND2_IND
, PERF_BAND3_IND
, PERF_BANDNA_IND
, DIRECT_IND
, METRIC_ADJUST_MULTIPLIER
, SUPERVISOR_LEVEL
, ADMIN_ROW_TYPE
, ADMIN_EVTS_ROWID
, ADMIN_SUPH_ROWID
, ADMIN_JOBH_ROWID
, ADMIN_GEOH_ROWID
, EVTS_EFFECTIVE_END_DATE
, SUPH_EFFECTIVE_END_DATE
, PRIMARY_FLAG_IND
, PRIMARY_ASG_WITH_HDC_IND
, EFFECTIVE_END_DATE
, SUB_ASSIGNMENT_ID
, POW_VALUE_DAYS_JULIAN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, SUMMARIZATION_RQD_IND
, SUMMARIZATION_RQD_CHNG_IND
, PRIMARY_JOB_ROLE_CODE
, WKTH_WKTYP_SK_FK
, WKTH_LVL1_SK_FK
, WKTH_LVL2_SK_FK
, WKTH_WKTYP_CODE
, POW_BAND_SK_FK
, POW_EXTN_DAYS_JULIAN
FROM HRI.HRI_MAP_SUP_WRKFC_ASG;
HRI.HRI_MAP_SUP_WRKFC_ASG does not reference any database object
HRI.HRI_MAP_SUP_WRKFC_ASG is referenced by following:
|
|
|