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_STOPPAGES

Object Details

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

Stoppages of entitlement to a given element, for a specified period
and reason. These stoppages will be used to amend the element entries
which would be created for the element so that no payment may be
made for the stopped period. For example, Statutory Sick Pay may
be withheld from the date the recipient enters legal custody.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: SSP_STOPPAGES_PK

STOPPAGE_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
SSP_STOPPAGES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	STOPPAGE_ID
SSP_STOPPAGES_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	MATERNITY_ID
SSP_STOPPAGES_FK2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REASON_ID
SSP_STOPPAGES_FK3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ABSENCE_ATTENDANCE_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
SSP_STOPPAGES		SSP_MATERNITIES	SSP_STOPPAGES MATERNITY_ID
SSP_STOPPAGES		SSP_WITHHOLDING_REASONS	SSP_STOPPAGES REASON_ID

Columns

Name	Datatype	Length	Mandatory	Comments
STOPPAGE_ID	NUMBER	(9)	Yes	System-generated primary key.
OBJECT_VERSION_NUMBER	NUMBER	(9)		Version number of the row. Increments by one with each update.
ABSENCE_ATTENDANCE_ID	NUMBER	(9)		Foreign key to PER_ABSENCE_ATTENDANCES. This column and maternity_id are mutually exclusive.
MATERNITY_ID	NUMBER	(9)		Foreign key to SSP_MATERNITIES. This column and absence_attendance_id are mutually exclusive.
REASON_ID	NUMBER	(9)	Yes	Foreign key to SSP_WITHHOLDING_REASONS.
USER_ENTERED	VARCHAR2	(30)	Yes	Was this stoppage entered by the user or by the system?
OVERRIDE_STOPPAGE	VARCHAR2	(30)	Yes	Are stoppages for the same reason as this one to be ignored by the system?
EMPLOYEE_NOTIFIED	VARCHAR2	(30)	Yes	Has the employee been notified of this stoppage?
WITHHOLD_FROM	DATE		Yes	Date from which payment is to be withheld.
WITHHOLD_TO	DATE			Date to which payment is to be withheld.
CREATION_DATE	DATE			Standard AOL who column.
CREATED_BY	NUMBER	(15)		Standard AOL who column.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard AOL who column.
LAST_UPDATE_DATE	DATE			Standard AOL who column.
LAST_UPDATED_BY	NUMBER	(15)		Standard AOL who column.

Query Text

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


SELECT STOPPAGE_ID
,      OBJECT_VERSION_NUMBER
,      ABSENCE_ATTENDANCE_ID
,      MATERNITY_ID
,      REASON_ID
,      USER_ENTERED
,      OVERRIDE_STOPPAGE
,      EMPLOYEE_NOTIFIED
,      WITHHOLD_FROM
,      WITHHOLD_TO
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
FROM SSP.SSP_STOPPAGES;

Dependencies

[top of page]

SSP.SSP_STOPPAGES does not reference any database object

SSP.SSP_STOPPAGES is referenced by following:

APPS: SSP_STOPPAGES; SSP_STOPPAGES_WHO; SSP_STP_T1; SSP_STP_T2