[Home] [Help] [Dependency Information]
Object Name: | MLOG$_HRI_MAP_SUP_WRKFC_AS |
---|---|
Object Type: | TABLE |
Owner: | HRI |
Subobject Name: | |
Status: | VALID |
snapshot log for master table HRI.HRI_MAP_SUP_WRKFC_ASG
Tablespace: | APPS_TS_SUMMARY |
---|---|
PCT Free: | 60 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
MLOG$_HRI_MAP_SUP_WRKFC_AS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SUPERVISOR_PERSON_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ANL_SLRY_CURRENCY | VARCHAR2 | (30) | ||
ANL_SLRY_VALUE | NUMBER | |||
ASSIGNMENT_ID | NUMBER | |||
DIRECT_IND | NUMBER | |||
DIRECT_SUPERVISOR_PERSON_ID | NUMBER | |||
EFFECTIVE_DATE | DATE | |||
FTE_VALUE | NUMBER | |||
GEO_AREA_CODE | VARCHAR2 | (40) | ||
GEO_CITY_CID | VARCHAR2 | (300) | ||
GEO_COUNTRY_CODE | VARCHAR2 | (70) | ||
GEO_REGION_CODE | VARCHAR2 | (160) | ||
HEADCOUNT_VALUE | NUMBER | |||
JOB_FMLY_CODE | VARCHAR2 | (240) | ||
JOB_FNCTN_CODE | VARCHAR2 | (240) | ||
JOB_ID | NUMBER | |||
LEAVING_REASON_CODE | VARCHAR2 | (30) | ||
LOCATION_ID | NUMBER | |||
METRIC_ADJUST_MULTIPLIER | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
PERF_BAND | NUMBER | |||
PERSON_ID | NUMBER | |||
POST_HIRE_ASGN_START_IND | NUMBER | |||
POW_BAND_SK_FK | NUMBER | |||
POW_EXTN_DAYS_JULIAN | NUMBER | |||
POW_START_DATE | DATE | |||
POW_VALUE_DAYS_JULIAN | NUMBER | |||
PRE_SPRTN_ASGN_END_IND | NUMBER | |||
PRIMARY_ASG_WITH_HDC_IND | NUMBER | |||
PRIMARY_FLAG_IND | NUMBER | |||
PRIMARY_JOB_ROLE_CODE | VARCHAR2 | (30) | ||
SEPARATION_CATEGORY | VARCHAR2 | (30) | ||
SUMMARIZATION_RQD_CHNG_IND | NUMBER | |||
SUMMARIZATION_RQD_IND | NUMBER | |||
SUPERVISOR_PERSON_ID | NUMBER | |||
TERM_INVOLUNTARY_IND | NUMBER | |||
TERM_VOLUNTARY_IND | NUMBER | |||
TRANSFER_IN_IND | NUMBER | |||
TRANSFER_OUT_IND | NUMBER | |||
WKTH_LVL1_SK_FK | VARCHAR2 | (40) | ||
WKTH_LVL2_SK_FK | VARCHAR2 | (40) | ||
WKTH_WKTYP_CODE | VARCHAR2 | (30) | ||
WKTH_WKTYP_SK_FK | VARCHAR2 | (40) | ||
WORKER_HIRE_IND | NUMBER | |||
WORKER_TERM_IND | NUMBER | |||
M_ROW$$ | VARCHAR2 | (255) | ||
SEQUENCE$$ | NUMBER | |||
SNAPTIME$$ | DATE | |||
DMLTYPE$$ | VARCHAR2 | (1) | ||
OLD_NEW$$ | VARCHAR2 | (1) | ||
CHANGE_VECTOR$$ | RAW | (255) |
Cut, paste (and edit) the following text to query this object:
SELECT ANL_SLRY_CURRENCY
, ANL_SLRY_VALUE
, ASSIGNMENT_ID
, DIRECT_IND
, DIRECT_SUPERVISOR_PERSON_ID
, EFFECTIVE_DATE
, FTE_VALUE
, GEO_AREA_CODE
, GEO_CITY_CID
, GEO_COUNTRY_CODE
, GEO_REGION_CODE
, HEADCOUNT_VALUE
, JOB_FMLY_CODE
, JOB_FNCTN_CODE
, JOB_ID
, LEAVING_REASON_CODE
, LOCATION_ID
, METRIC_ADJUST_MULTIPLIER
, ORGANIZATION_ID
, PERF_BAND
, PERSON_ID
, POST_HIRE_ASGN_START_IND
, POW_BAND_SK_FK
, POW_EXTN_DAYS_JULIAN
, POW_START_DATE
, POW_VALUE_DAYS_JULIAN
, PRE_SPRTN_ASGN_END_IND
, PRIMARY_ASG_WITH_HDC_IND
, PRIMARY_FLAG_IND
, PRIMARY_JOB_ROLE_CODE
, SEPARATION_CATEGORY
, SUMMARIZATION_RQD_CHNG_IND
, SUMMARIZATION_RQD_IND
, SUPERVISOR_PERSON_ID
, TERM_INVOLUNTARY_IND
, TERM_VOLUNTARY_IND
, TRANSFER_IN_IND
, TRANSFER_OUT_IND
, WKTH_LVL1_SK_FK
, WKTH_LVL2_SK_FK
, WKTH_WKTYP_CODE
, WKTH_WKTYP_SK_FK
, WORKER_HIRE_IND
, WORKER_TERM_IND
, M_ROW$$
, SEQUENCE$$
, SNAPTIME$$
, DMLTYPE$$
, OLD_NEW$$
, CHANGE_VECTOR$$
FROM HRI.MLOG$_HRI_MAP_SUP_WRKFC_AS;
HRI.MLOG$_HRI_MAP_SUP_WRKFC_AS does not reference any database object
HRI.MLOG$_HRI_MAP_SUP_WRKFC_AS is referenced by following:
|
|
|