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: TablePER.PER_ZA_EMPLOYMENT_EQUITY
Subobject Name:
Status: VALID


Temporary table for Employment Equity Reporting


Storage Details
Tablespace: TablespaceAPPS_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:

SchemaAPPS
SynonymPER_ZA_EMPLOYMENT_EQUITY
SchemaPUBLIC
SynonymPER_ZA_EMPLOYMENT_EQUITY