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: HR.PER_ZA_EMPLOYMENT_EQUITY

Object Details

Object Name:	PER_ZA_EMPLOYMENT_EQUITY
Object Type:	TABLE
Owner:	HR
FND Design Data:	PER.PER_ZA_EMPLOYMENT_EQUITY
Subobject Name:
Status:	VALID

Temporary table for Employment Equity Reporting

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
REPORT_ID	VARCHAR2	(4)	Yes	Report id
LEVEL_CAT	VARCHAR2	(150)		Category or Level
MA	NUMBER	(15)		African Males in Employment Equity Report or Average Salary of the top 5 earners per Occupational Category or Level in Income Differential Statement
MC	NUMBER	(15)		Colored Males in Employment Equity Report or Average Salary of the 5 lowest earners per Occupational Category or Level in Income
MI	NUMBER	(15)		Indian Males
MW	NUMBER	(15)		White Males
FA	NUMBER	(15)		African Females
FC	NUMBER	(15)		Colored Females
FI	NUMBER	(15)		Indian Females
FW	NUMBER	(15)		White Females
LEVEL_CAT_CODE	VARCHAR2	(10)		Category or Level Code
BUSINESS_GROUP_ID	NUMBER	(15)		Business Group ID
LEGAL_ENTITY_ID	NUMBER	(15)		Legal Entity ID
LEGAL_ENTITY	VARCHAR2	(150)		Legal Entity
DISABILITY	VARCHAR2	(1)		Disability
EMPLOYMENT_TYPE	VARCHAR2	(20)		Employment Type
TOTAL	NUMBER	(20)		Total
REPORTING_DATE	DATE			Reporting Date

Query Text

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


SELECT REPORT_ID
,      LEVEL_CAT
,      MA
,      MC
,      MI
,      MW
,      FA
,      FC
,      FI
,      FW
,      LEVEL_CAT_CODE
,      BUSINESS_GROUP_ID
,      LEGAL_ENTITY_ID
,      LEGAL_ENTITY
,      DISABILITY
,      EMPLOYMENT_TYPE
,      TOTAL
,      REPORTING_DATE
FROM HR.PER_ZA_EMPLOYMENT_EQUITY;

Dependencies

[top of page]

HR.PER_ZA_EMPLOYMENT_EQUITY does not reference any database object

HR.PER_ZA_EMPLOYMENT_EQUITY is referenced by following:

APPS: PER_ZA_EMPLOYMENT_EQUITY
PUBLIC: PER_ZA_EMPLOYMENT_EQUITY