[Home] [Help] [Dependency Information]
Object Name: | SSP_SMP_ENTRIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | SSP.SSP_SMP_ENTRIES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Nonrecurring element entries for SMP and SMP correction elements.
This view denormalises the element entry information for the entries
created by the Statutory Sick Pay/Statutory Maternity Pay application.
It shows at a glance the element entries, including entry values, for
the predefined Statutory Maternity Pay elements.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSIGNMENT_ID | NUMBER | (10) | Yes | Foreign key to PER_ALL_ASSIGNMENTS_F. |
PERSON_ID | NUMBER | (10) | Yes | Foreign key to PER_ALL_PEOPLE_F. |
REVERSAL_ENTRY | VARCHAR2 | (1) | Flag to indicate if this entry is a reversal of another SMP entry. | |
DATE_FROM | DATE | Start of the SMP period which this entry covers. | ||
DATE_TO | DATE | End of the SMP period which this entry covers. | ||
AMOUNT | NUMBER | Monetary amount of entitlement to SMP for the covered period. | ||
RATE | VARCHAR2 | (60) | Rate band at which this entry was calculated. | |
RECOVERABLE_AMOUNT | NUMBER | The amount of SMP entitlement which is recoverable from the government. | ||
ELEMENT_ENTRY_ID | NUMBER | (15) | Yes | Primary key from PAY_ELEMENT_ENTRIES_F. |
EFFECTIVE_START_DATE | DATE | Yes | Element entry effective start date. | |
EFFECTIVE_END_DATE | DATE | Yes | Element entry effective end date. | |
MATERNITY_ID | NUMBER | (15) | Foreign key to SSP_MATERNITIES. Derived from Element Entry creator Id. | |
ROW_ID | ROWID | (10) | Internal row id. |
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_ID
, PERSON_ID
, REVERSAL_ENTRY
, DATE_FROM
, DATE_TO
, AMOUNT
, RATE
, RECOVERABLE_AMOUNT
, ELEMENT_ENTRY_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, MATERNITY_ID
, ROW_ID
FROM APPS.SSP_SMP_ENTRIES_V;
|
|
|