eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

TABLE: HRI.MLOG$_HRI_MAP_SUP_WRKFC_AS

Object Details

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

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	60
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MLOG$_HRI_MAP_SUP_WRKFC_AS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	SUPERVISOR_PERSON_ID

Columns

Name	Datatype	Length
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)

Query Text

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;

Dependencies

[top of page]

HRI.MLOG$_HRI_MAP_SUP_WRKFC_AS does not reference any database object

HRI.MLOG$_HRI_MAP_SUP_WRKFC_AS is referenced by following:

APPS: MLOG$_HRI_MAP_SUP_WRKFC_AS