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.HRI_MB_ASGN_EVENTS_CT

Object Details

Object Name:	HRI_MB_ASGN_EVENTS_CT
Object Type:	TABLE
Owner:	HRI
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

Storage Details

Tablespace:	APPS_TS_SUMMARY
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HRI_MB_ASGN_EVENTS_CT_U1	NORMAL	UNIQUE	APPS_TS_SUMMARY	EVENT_ID
HRI_MB_ASGN_EVENTS_CT_U2	NORMAL	UNIQUE	APPS_TS_SUMMARY	ASSIGNMENT_ID EFFECTIVE_CHANGE_DATE EFFECTIVE_CHANGE_END_DATE
HRI_MB_ASGN_EVENTS_CT_N1	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PERSON_ID EFFECTIVE_CHANGE_DATE EFFECTIVE_CHANGE_END_DATE
HRI_MB_ASGN_EVENTS_CT_N10	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	PRSNTYP_SK_FK
HRI_MB_ASGN_EVENTS_CT_N2	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORGANIZATION_ID
HRI_MB_ASGN_EVENTS_CT_N3	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ORGANIZATION_PRV_ID
HRI_MB_ASGN_EVENTS_CT_N4	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SUPERVISOR_ID EFFECTIVE_CHANGE_DATE EFFECTIVE_CHANGE_END_DATE
HRI_MB_ASGN_EVENTS_CT_N5	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	SUPERVISOR_PRV_ID
HRI_MB_ASGN_EVENTS_CT_N6	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	JOB_ID EFFECTIVE_CHANGE_DATE EFFECTIVE_CHANGE_END_DATE
HRI_MB_ASGN_EVENTS_CT_N7	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	POW_START_DATE
HRI_MB_ASGN_EVENTS_CT_N8	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	ASSIGNMENT_ID WORKER_TERM_NXT_IND
HRI_MB_ASGN_EVENTS_CT_N9	NORMAL	NONUNIQUE	APPS_TS_SUMMARY	LOCATION_ID

Columns

Name	Datatype	Length	Mandatory
EVENT_ID	NUMBER		Yes
EFFECTIVE_CHANGE_DATE	DATE		Yes
EFFECTIVE_CHANGE_END_DATE	DATE		Yes
ASSIGNMENT_ID	NUMBER		Yes
PERSON_ID	NUMBER		Yes
GRADE_ID	NUMBER
GRADE_PRV_ID	NUMBER
JOB_ID	NUMBER
JOB_PRV_ID	NUMBER
LOCATION_ID	NUMBER
LOCATION_PRV_ID	NUMBER
ORGANIZATION_ID	NUMBER
ORGANIZATION_PRV_ID	NUMBER
SUPERVISOR_ID	NUMBER
SUPERVISOR_PRV_ID	NUMBER
POSITION_ID	NUMBER
POSITION_PRV_ID	NUMBER
PRIMARY_FLAG	VARCHAR2	(30)
PRIMARY_FLAG_PRV	VARCHAR2	(30)
CHANGE_REASON_CODE	VARCHAR2	(30)
LEAVING_REASON_CODE	VARCHAR2	(30)
FTE	NUMBER
FTE_PRV	NUMBER
HEADCOUNT	NUMBER
HEADCOUNT_PRV	NUMBER
ANL_SLRY	NUMBER
ANL_SLRY_PRV	NUMBER
ANL_SLRY_CURRENCY	VARCHAR2	(30)
ANL_SLRY_CURRENCY_PRV	VARCHAR2	(30)
PAY_PROPOSAL_ID	NUMBER
ASG_RTRSPCTV_STRT_EVENT_IND	NUMBER
ASSIGNMENT_CHANGE_IND	NUMBER
SALARY_CHANGE_IND	NUMBER
HEADCOUNT_GAIN_IND	NUMBER
HEADCOUNT_LOSS_IND	NUMBER
FTE_GAIN_IND	NUMBER
FTE_LOSS_IND	NUMBER
CONTINGENT_IND	NUMBER
EMPLOYEE_IND	NUMBER
GRADE_CHANGE_IND	NUMBER
JOB_CHANGE_IND	NUMBER
POSITION_CHANGE_IND	NUMBER
LOCATION_CHANGE_IND	NUMBER
ORGANIZATION_CHANGE_IND	NUMBER
SUPERVISOR_CHANGE_IND	NUMBER
SUPERVISOR_CHANGE_NXT_IND	NUMBER
WORKER_HIRE_IND	NUMBER
TERM_VOLUNTARY_IND	NUMBER
TERM_VOLUNTARY_NXT_IND	NUMBER
TERM_INVOLUNTARY_IND	NUMBER
TERM_INVOLUNTARY_NXT_IND	NUMBER
WORKER_TERM_IND	NUMBER
WORKER_TERM_NXT_IND	NUMBER
START_ASG_SSPNSN_IND	NUMBER
END_ASG_SSPNSN_IND	NUMBER
POST_HIRE_ASGN_START_IND	NUMBER
PRE_SPRTN_ASGN_END_IND	NUMBER
PRE_SPRTN_ASGN_END_NXT_IND	NUMBER
POW_DAYS_ON_EVENT_DATE	NUMBER
EFFECTIVE_CHANGE_DATE_PRV	DATE
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
LAST_UPDATE_LOGIN	NUMBER
CREATED_BY	NUMBER
CREATION_DATE	DATE
SEPARATION_CATEGORY	VARCHAR2	(30)
SEPARATION_CATEGORY_NXT	VARCHAR2	(30)
POW_MONTHS_ON_EVENT_DATE	NUMBER
POW_START_DATE	DATE
POW_BAND	NUMBER
POW_BAND_PRV	NUMBER
POW_BAND_CHANGE_IND	NUMBER
POW_BAND1_IND	NUMBER
POW_BAND2_IND	NUMBER
POW_BAND3_IND	NUMBER
POW_BAND4_IND	NUMBER
POW_BAND5_IND	NUMBER
PERF_NRMLSD_RATING	NUMBER
PERF_NRMLSD_RATING_PRV	NUMBER
PERFORMANCE_REVIEW_ID	NUMBER
PERF_REVIEW_TYPE_CD	VARCHAR2	(30)
PERFORMANCE_RATING_CD	VARCHAR2	(30)
PERF_BAND	NUMBER
PERF_BAND_PRV	NUMBER
PERF_RATING_CHANGE_IND	NUMBER
PERF_BAND_CHANGE_IND	NUMBER
PERF_BAND1_IND	NUMBER
PERF_BAND2_IND	NUMBER
PERF_BAND3_IND	NUMBER
PERF_BANDNA_IND	NUMBER
PERSON_TYPE_ID	NUMBER
USED_FOR_SUMMARIZATION	VARCHAR2	(30)
POW_START_DATE_ADJ	DATE
POW_BAND_SK_FK	NUMBER
POW_BAND_PRV_SK_FK	NUMBER
PRSNTYP_SK_FK	NUMBER
SUMMARIZATION_RQD_IND	NUMBER
SUMMARIZATION_RQD_CHNG_IND	NUMBER
SUMMARIZATION_RQD_CHNG_NXT_IND	NUMBER
POW_EXTN_STRT_DT	DATE
B	VARCHAR2	(240)
BUSINESS_GROUP_ID	NUMBER
ASG_TYPE_CODE	VARCHAR2	(30)
PROMOTION_IND	NUMBER
DAYS_SINCE_LAST_PRMTN	NUMBER
MONTHS_SINCE_LAST_PRMTN	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EVENT_ID
,      EFFECTIVE_CHANGE_DATE
,      EFFECTIVE_CHANGE_END_DATE
,      ASSIGNMENT_ID
,      PERSON_ID
,      GRADE_ID
,      GRADE_PRV_ID
,      JOB_ID
,      JOB_PRV_ID
,      LOCATION_ID
,      LOCATION_PRV_ID
,      ORGANIZATION_ID
,      ORGANIZATION_PRV_ID
,      SUPERVISOR_ID
,      SUPERVISOR_PRV_ID
,      POSITION_ID
,      POSITION_PRV_ID
,      PRIMARY_FLAG
,      PRIMARY_FLAG_PRV
,      CHANGE_REASON_CODE
,      LEAVING_REASON_CODE
,      FTE
,      FTE_PRV
,      HEADCOUNT
,      HEADCOUNT_PRV
,      ANL_SLRY
,      ANL_SLRY_PRV
,      ANL_SLRY_CURRENCY
,      ANL_SLRY_CURRENCY_PRV
,      PAY_PROPOSAL_ID
,      ASG_RTRSPCTV_STRT_EVENT_IND
,      ASSIGNMENT_CHANGE_IND
,      SALARY_CHANGE_IND
,      HEADCOUNT_GAIN_IND
,      HEADCOUNT_LOSS_IND
,      FTE_GAIN_IND
,      FTE_LOSS_IND
,      CONTINGENT_IND
,      EMPLOYEE_IND
,      GRADE_CHANGE_IND
,      JOB_CHANGE_IND
,      POSITION_CHANGE_IND
,      LOCATION_CHANGE_IND
,      ORGANIZATION_CHANGE_IND
,      SUPERVISOR_CHANGE_IND
,      SUPERVISOR_CHANGE_NXT_IND
,      WORKER_HIRE_IND
,      TERM_VOLUNTARY_IND
,      TERM_VOLUNTARY_NXT_IND
,      TERM_INVOLUNTARY_IND
,      TERM_INVOLUNTARY_NXT_IND
,      WORKER_TERM_IND
,      WORKER_TERM_NXT_IND
,      START_ASG_SSPNSN_IND
,      END_ASG_SSPNSN_IND
,      POST_HIRE_ASGN_START_IND
,      PRE_SPRTN_ASGN_END_IND
,      PRE_SPRTN_ASGN_END_NXT_IND
,      POW_DAYS_ON_EVENT_DATE
,      EFFECTIVE_CHANGE_DATE_PRV
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      SEPARATION_CATEGORY
,      SEPARATION_CATEGORY_NXT
,      POW_MONTHS_ON_EVENT_DATE
,      POW_START_DATE
,      POW_BAND
,      POW_BAND_PRV
,      POW_BAND_CHANGE_IND
,      POW_BAND1_IND
,      POW_BAND2_IND
,      POW_BAND3_IND
,      POW_BAND4_IND
,      POW_BAND5_IND
,      PERF_NRMLSD_RATING
,      PERF_NRMLSD_RATING_PRV
,      PERFORMANCE_REVIEW_ID
,      PERF_REVIEW_TYPE_CD
,      PERFORMANCE_RATING_CD
,      PERF_BAND
,      PERF_BAND_PRV
,      PERF_RATING_CHANGE_IND
,      PERF_BAND_CHANGE_IND
,      PERF_BAND1_IND
,      PERF_BAND2_IND
,      PERF_BAND3_IND
,      PERF_BANDNA_IND
,      PERSON_TYPE_ID
,      USED_FOR_SUMMARIZATION
,      POW_START_DATE_ADJ
,      POW_BAND_SK_FK
,      POW_BAND_PRV_SK_FK
,      PRSNTYP_SK_FK
,      SUMMARIZATION_RQD_IND
,      SUMMARIZATION_RQD_CHNG_IND
,      SUMMARIZATION_RQD_CHNG_NXT_IND
,      POW_EXTN_STRT_DT
,      B
,      BUSINESS_GROUP_ID
,      ASG_TYPE_CODE
,      PROMOTION_IND
,      DAYS_SINCE_LAST_PRMTN
,      MONTHS_SINCE_LAST_PRMTN
FROM HRI.HRI_MB_ASGN_EVENTS_CT;

Dependencies

[top of page]

HRI.HRI_MB_ASGN_EVENTS_CT does not reference any database object

HRI.HRI_MB_ASGN_EVENTS_CT is referenced by following:

APPS: HRI_MB_ASGN_EVENTS_CT; HRI_MB_ASGN_EVENTS_CT_WHO