[Home] [Help] [Dependency Information]
Object Name: | SSP_SSP_ENTRIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | SSP.SSP_SSP_ENTRIES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Nonrecurring element entries for the Statutory Sick Pay and SSP
correction elements. Makes viewing these entries easier than by
looking at PAY_ELEMENT_ENTRIES_F because it converts the
associated PAY_ELEMENT_ENTRY_VALUES rows into columns.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REVERSAL_ENTRY | VARCHAR2 | (1) | Flag indicating whether or not this is an entry which corrects another one. | |
ASSIGNMENT_ID | NUMBER | (10) | Yes | Foreign key to PER_ALL_ASSIGNMENTS_F. |
PERSON_ID | NUMBER | (10) | Yes | Foreign key to PER_ALL_PEOPLE_F. |
ELEMENT_LINK_ID | NUMBER | (9) | Yes | Foreign key to PAY_ELEMENT_LINKS_F. |
ELEMENT_ENTRY_ID | NUMBER | (15) | Yes | Primary key from PAY_ELEMENT_ENTRIES_F. |
TARGET_ENTRY_ID | NUMBER | (15) | Foreign key to PAY_ELEMENT_ENTRIES_F (ELEMENT_ENTRY_ID). | |
DATE_FROM | DATE | Start of period covered by this entry. | ||
DATE_TO | DATE | End of period covered by this entry. | ||
AMOUNT | NUMBER | Monetary entitlement to SSP during the covered period. | ||
RATE | NUMBER | SSP rate in force during the covered period. | ||
QUALIFYING_DAYS | NUMBER | The total number of SSP qualifying days during the covered period. | ||
SSP_DAYS_DUE | NUMBER | The number of SSP qualifying days due, less any Waiting Days, within the covered period. | ||
WITHHELD_DAYS | NUMBER | The total number of days within the covered period that are subject to a stoppage of entitlement. | ||
SSP_WEEKS | NUMBER | The fraction of an SSP week that the covered period constitutes. | ||
PIW_ID | NUMBER | (15) | Foreign key to PER_ABSENCE_ATTENDANCES. Derived from PAY_ELEMENT_ENTRIES_F.CREATORTYPE. | |
EFFECTIVE_START_DATE | DATE | Yes | Element entry effective start date. | |
EFFECTIVE_END_DATE | DATE | Yes | Element entry effective end date. | |
ROW_ID | ROWID | (10) | Internal row id. |
Cut, paste (and edit) the following text to query this object:
SELECT REVERSAL_ENTRY
, ASSIGNMENT_ID
, PERSON_ID
, ELEMENT_LINK_ID
, ELEMENT_ENTRY_ID
, TARGET_ENTRY_ID
, DATE_FROM
, DATE_TO
, AMOUNT
, RATE
, QUALIFYING_DAYS
, SSP_DAYS_DUE
, WITHHELD_DAYS
, SSP_WEEKS
, PIW_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, ROW_ID
FROM APPS.SSP_SSP_ENTRIES_V;
|
|
|