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: SSP.SSP_EARNINGS_CALCULATIONS

Object Details

Object Name:	SSP_EARNINGS_CALCULATIONS
Object Type:	TABLE
Owner:	SSP
FND Design Data:	SSP.SSP_EARNINGS_CALCULATIONS
Subobject Name:
Status:	VALID

Calculations of average weekly earnings for the purposes
of determining entitlement to SSP and SMP. Oracle Payroll
users will have this table maintained automatically, though
they may update the earnings figures that are derived by
the system. Users who have not installed Oracle Payroll
must enter the earnings figures themselves.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: SSP_EARNINGS_CALCULATIONS_PK

EARNINGS_CALCULATIONS_ID

Unique Key: SSP_EARNINGS_CALCULATIONS_UK1

PERSON_ID
EFFECTIVE_DATE

Indexes

Index	Type	Uniqueness	Tablespace	Column
SSP_EARNINGS_CALCULATIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	EARNINGS_CALCULATIONS_ID
SSP_EARNINGS_CALCULATIONS_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PERSON_ID EFFECTIVE_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
EARNINGS_CALCULATIONS_ID	NUMBER	(9)	Yes	System-generated primary key
OBJECT_VERSION_NUMBER	NUMBER	(9)		Version number of row. This is incremented by one for each upate.
PERSON_ID	NUMBER	(10)	Yes	Foreign key to PER_PEOPLE_F.
EFFECTIVE_DATE	DATE		Yes	The end date of the period for which the average earnings amount was calculated.
AVERAGE_EARNINGS_AMOUNT	NUMBER	(10)	Yes	Average weekly earnings figure for a period ending on the effective date.
USER_ENTERED	VARCHAR2	(30)	Yes	Did the system generate this figure, or was it user-entered?
PAYMENT_PERIODS	NUMBER	(9)		Stores the number of periods over which earnings have been derived. If USER_ENTERED is Y then this should be null.
CREATED_BY	NUMBER	(15)		Standard AOL who column.
CREATION_DATE	DATE			Standard AOL who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard AOL who column.
LAST_UPDATE_DATE	DATE			Standard AOL who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard AOL who column.

Query Text

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


SELECT EARNINGS_CALCULATIONS_ID
,      OBJECT_VERSION_NUMBER
,      PERSON_ID
,      EFFECTIVE_DATE
,      AVERAGE_EARNINGS_AMOUNT
,      USER_ENTERED
,      PAYMENT_PERIODS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM SSP.SSP_EARNINGS_CALCULATIONS;

Dependencies

[top of page]

SSP.SSP_EARNINGS_CALCULATIONS does not reference any database object

SSP.SSP_EARNINGS_CALCULATIONS is referenced by following:

APPS: SSP_EARNINGS_CALCULATIONS; SSP_EARNINGS_CALCULATIONS_WHO; SSP_ERN_T1; SSP_ERN_T2