This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage, Big Business. Small Business. All Business., CDM Advantage, .comference, ConText®, Des40®, Easy*Query, Easy*SQL®, Education Objects, EMM Advantage, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist, Hyper*SQL, instantOracle, "Internet Business Intelligence - Insight for Everyone", iSQL*Plus, JInitiator, NLS*Workbench®, Object Marketplace, ODP Pulse, ODP Techwire, OLA, On Oracle, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer, Oracle® Expert, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile, Oracle Names®, Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i, Oracle9i, PC Express®, Personal Express®, PJM Advantage, PL/SQL, Pro*Ada®, Pro*C, Pro*C/C++, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit, ProREXX, Report Card, Secure Access 2.0, Secure Network Services®, Security Without Compromise, SellingPoint®, SQL*Plus®, Tutor are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.
Description: | Calculations of average weekly earnings for the purposes of determining entitlement to SSP/SMP. |
---|
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.
Index | Type | Tablespace | Column |
---|---|---|---|
SSP_EARNINGS_CALCULATIONS_PK | UNIQUE | APPS_TS_TX_IDX | EARNINGS_CALCULATIONS_ID |
SSP_EARNINGS_CALCULATIONS_UK1 | UNIQUE | APPS_TS_TX_IDX |
PERSON_ID
EFFECTIVE_DATE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
EARNINGS_CALCULATIONS_ID | NUMBER | (9) | Y | 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) | Y | Foreign key to PER_PEOPLE_F. |
EFFECTIVE_DATE | DATE | Y | The end date of the period for which the average earnings amount was calculated. | |
AVERAGE_EARNINGS_AMOUNT | NUMBER | (10) | Y | Average weekly earnings figure for a period ending on the effective date. |
USER_ENTERED | VARCHAR2 | (30) | Y | 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. |
SSP.SSP_EARNINGS_CALCULATIONS does not reference any database object
SSP.SSP_EARNINGS_CALCULATIONS is referenced by following:
Description: | Record of a woman's maternities/pregnancies. |
---|
Foreign Key Column | Foreign Table |
---|---|
SSP_MEDICALS.MATERNITY_ID | SSP_MATERNITIES |
SSP_STOPPAGES.MATERNITY_ID | SSP_MATERNITIES |
Record of a woman's maternities/pregnancies.
Index | Type | Tablespace | Column |
---|---|---|---|
SSP_MATERNITIES_PK | UNIQUE | APPS_TS_TX_IDX | MATERNITY_ID |
SSP_MATERNITIES_UK1 | UNIQUE | APPS_TS_TX_IDX |
DUE_DATE
PERSON_ID LEAVE_TYPE |
SSP_MATERNITIES_FK1 | NONUNIQUE | APPS_TS_TX_IDX | PERSON_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MATERNITY_ID | NUMBER | (9) | Y | System-generated primary key |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Version number of the row. This is incremented by one for each update. | |
DUE_DATE | DATE | Y | Date the baby is expected to be born. | |
PERSON_ID | NUMBER | (10) | Y | Foreign key to PER_PEOPLE_F. |
START_DATE_MATERNITY_ALLOWANCE | DATE | Date on which the woman first received Statutory Maternity Allowance from the Department of Social Security. | ||
NOTIFICATION_OF_BIRTH_DATE | DATE | Date on which the woman notified the company of the actual birth of her child. | ||
UNFIT_FOR_SCHEDULED_RETURN | VARCHAR2 | (30) | Y | Is the woman medically unfit to return to work on her stated return date? |
STATED_RETURN_DATE | DATE | Date the woman intends to return to work after maternity leave. | ||
INTEND_TO_RETURN_FLAG | VARCHAR2 | (30) | Y | Does the woman intend to return to work after her maternity leave? |
START_DATE_WITH_NEW_EMPLOYER | DATE | Date the employee started work with a new employer who did not employ her in her Qualifying Week. | ||
SMP_MUST_BE_PAID_BY_DATE | DATE | Date by which SMP must be paid, to comply with any legal ruling or adjudication of dispute. | ||
PAY_SMP_AS_LUMP_SUM | VARCHAR2 | (30) | Y | Should SMP be paid in one lump sum, in advance? |
LIVE_BIRTH_FLAG | VARCHAR2 | (30) | Y | Was the baby born alive, even for a moment? |
ACTUAL_BIRTH_DATE | DATE | Date the baby was actually born (or stillborn). | ||
MPP_START_DATE | DATE | Date the Maternity Pay Period starts. | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield column | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield column | |
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 | |
LEAVE_TYPE | VARCHAR2 | (2) | Y | The type of statutory leave - Maternity, Adoption or Paternity |
ADOPTIVE_CHILDS_BIRTH_DATE | DATE | Date the adopted child was actually born. | ||
MATCHING_DATE | DATE | Date the adopted child was matched. | ||
PLACEMENT_DATE | DATE | Date the adopted child was placed. | ||
DISRUPTED_PLACEMENT_DATE | DATE | Date the placement was disrupted. | ||
MAT_INFORMATION_CATEGORY | VARCHAR2 | (30) | Developer descriptive flexfield structure defining column | |
MAT_INFORMATION1 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION2 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION3 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION4 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION5 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION6 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION7 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION8 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION9 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION10 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION11 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION12 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION13 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION14 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION15 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION16 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION17 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION18 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION19 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION20 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION21 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION22 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION23 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION24 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION25 | VARCHAR2 | (240) | Developer descriptive flexfield column | |
MAT_INFORMATION26 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION27 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION28 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION29 | VARCHAR2 | (150) | Developer descriptive flexfield column | |
MAT_INFORMATION30 | VARCHAR2 | (150) | Developer descriptive flexfield column |
SSP.SSP_MATERNITIES does not reference any database object
SSP.SSP_MATERNITIES is referenced by following:
Description: | Medical reports of sickness or evidence of maternity for a person. |
---|
Foreign Key Column | Foreign Table |
---|---|
SSP_MEDICALS.MATERNITY_ID | SSP_MATERNITIES |
Medical reports for a person. The medical report may relate to
a maternity (for example evidence of pregnancy for the purposes
of Statutory Maternity Pay), or to an absence due to sickness.
There may be multiple evidence records for a given sickness
absence or maternity, but only one of these records may be
'current'. This is so that the system can identify the record
which is regarded as authoritative. All other records are
superseded by the current record.
Index | Type | Tablespace | Column |
---|---|---|---|
SSP_MEDICALS_PK | UNIQUE | APPS_TS_TX_IDX | MEDICAL_ID |
SSP_MEDICALS_UK1 | UNIQUE | APPS_TS_TX_IDX |
ABSENCE_ATTENDANCE_ID
MATERNITY_ID EVIDENCE_DATE EVIDENCE_SOURCE |
SSP_MEDICALS_FK2 | NONUNIQUE | APPS_TS_TX_IDX | MATERNITY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MEDICAL_ID | NUMBER | (9) | Y | System-generated primary key |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Version number of row. Increments by one with each update. | |
EVIDENCE_DATE | DATE | Y | Date the evidence document was signed. | |
EVIDENCE_SOURCE | VARCHAR2 | (80) | Y | Where did the evidence come from? (Eg Doctor, midwife, osteopath). |
ABSENCE_ATTENDANCE_ID | NUMBER | (9) | Foreign key to PER_ABSENCE_ATTENDANCES. | |
MATERNITY_ID | NUMBER | (9) | Foreign key to SSP_MATERNITIES. | |
MEDICAL_TYPE | VARCHAR2 | (70) | Y | Type of medical record (ie maternity evidence or Sick Note). |
SELF_CERTIFICATE | VARCHAR2 | (30) | Flag to indicate self-certified sickness evidence. | |
PREDICTED_FITNESS_DATE | DATE | Date the person is expected to be fit for work again (Sick Notes only). | ||
EVIDENCE_STATUS | VARCHAR2 | (30) | Y | Current or superseded evidence record? |
EVIDENCE_DETAILS | VARCHAR2 | (2000) | Textual details of the medical evidence. | |
ACCEPT_LATE_EVIDENCE_FLAG | VARCHAR2 | (30) | Was the reason for late evidence acceptable? | |
REASON_FOR_LATE_EVIDENCE | VARCHAR2 | (2000) | Reason why the medical evidence was received late. | |
EVIDENCE_RECEIVED_DATE | DATE | Y | Date the evidence was received by the company. | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure defining column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE16 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE17 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE18 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE19 | VARCHAR2 | (150) | Descriptive flexfield column. | |
ATTRIBUTE20 | VARCHAR2 | (150) | Descriptive flexfield column. | |
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. |
SSP.SSP_MEDICALS does not reference any database object
SSP.SSP_MEDICALS is referenced by following:
Description: | Periods of non-entitlement to a given element. |
---|
Foreign Key Column | Foreign Table |
---|---|
SSP_STOPPAGES.MATERNITY_ID | SSP_MATERNITIES |
SSP_STOPPAGES.REASON_ID | SSP_WITHHOLDING_REASONS |
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.
Index | Type | Tablespace | Column |
---|---|---|---|
SSP_STOPPAGES_PK | UNIQUE | APPS_TS_TX_IDX | STOPPAGE_ID |
SSP_STOPPAGES_FK1 | NONUNIQUE | APPS_TS_TX_IDX | MATERNITY_ID |
SSP_STOPPAGES_FK2 | NONUNIQUE | APPS_TS_TX_IDX | REASON_ID |
SSP_STOPPAGES_FK3 | NONUNIQUE | APPS_TS_TX_IDX | ABSENCE_ATTENDANCE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
STOPPAGE_ID | NUMBER | (9) | Y | 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) | Y | Foreign key to SSP_WITHHOLDING_REASONS. |
USER_ENTERED | VARCHAR2 | (30) | Y | Was this stoppage entered by the user or by the system? |
OVERRIDE_STOPPAGE | VARCHAR2 | (30) | Y | Are stoppages for the same reason as this one to be ignored by the system? |
EMPLOYEE_NOTIFIED | VARCHAR2 | (30) | Y | Has the employee been notified of this stoppage? |
WITHHOLD_FROM | DATE | Y | 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. |
SSP.SSP_STOPPAGES does not reference any database object
SSP.SSP_STOPPAGES is referenced by following:
Description: | For internal Oracle use only. |
---|
This table is populated by database ROW triggers on various tables
concerned with SSP. The row will contain either a PIW_id or
a maternity_id of a PIW/maternity that will be affected by the
triggering change.
The table is read by the STATEMENT level trigger on those same tables,
and the 'locked' column is set to 'Y' while the SSP/SMP is
recalculated for that row. This is because the statement level
triggers which cause it to be read may be fired recursively. Thus, we
can ensure that we only read rows which have not been read by a higher
level triggering statement.
The only reason for this table is that we cannot directly call the
recalculation processes directly from database row triggers because
of the 'mutating table restriction' (see Oracle Application
Developers' Guide).
Note that this table is for temporary data ONLY and should never have
committed data in it. After the recalculation processes have
completed, the rows are deleted.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MATERNITY_ID | NUMBER | Foreign key to SSP_MATERNITIES. | ||
PIW_ID | NUMBER | Foreign key to PER_ABSENCE_ATTENDANCES (ABSENCE_ATTENDANCE_ID). | ||
LOCKED | VARCHAR2 | (30) | Indicates that this row has been selected for processing. | |
P_DELETING | VARCHAR2 | (1) | Indicates whether the database mode is delete or not |
SSP.SSP_TEMP_AFFECTED_ROWS does not reference any database object
SSP.SSP_TEMP_AFFECTED_ROWS is referenced by following:
Description: | Reasons for withholding payment of a specified element. |
---|
Foreign Key Column | Foreign Table |
---|---|
SSP_STOPPAGES.REASON_ID | SSP_WITHHOLDING_REASONS |
Reasons for withholding payment of a specified element.
Index | Type | Tablespace | Column |
---|---|---|---|
SSP_WITHHOLDING_REASONS_UK1 | UNIQUE | APPS_TS_TX_IDX |
REASON
ELEMENT_TYPE_ID BUSINESS_GROUP_ID LEGISLATION_CODE |
SSP_WITHOLDING_REASONS_PK | UNIQUE | APPS_TS_TX_IDX | REASON_ID |
SSP_WITHHOLDING_REASONS_FK1 | NONUNIQUE | APPS_TS_TX_IDX | ELEMENT_TYPE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REASON_ID | NUMBER | (9) | Y | System-generated primary key. |
OBJECT_VERSION_NUMBER | NUMBER | (9) | Version number of the row. Increments by one with each update. | |
REASON | VARCHAR2 | (30) | Y | Short description of the withholding reason. |
EXPLANATION | VARCHAR2 | (2000) | Full explanation of the withholding reason. | |
WITHHOLD_TEMPORARILY | VARCHAR2 | (30) | Y | Can this withholding reason be used for temporarily withholding payment? |
BUSINESS_GROUP_ID | NUMBER | (15) | Foreign key to HR_ORGANIZATION_UNITS (ORGANIZATION_ID). | |
LEGISLATION_CODE | VARCHAR2 | (30) | Legislation to which this data belongs. | |
ELEMENT_TYPE_ID | NUMBER | (9) | Y | Foreign key to PAY_ELEMENT_TYPES_F. |
CREATION_DATE | DATE | Standard AOL who columns. | ||
CREATED_BY | NUMBER | (15) | Standard AOL who columns. | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard AOL who columns. | |
LAST_UPDATE_DATE | DATE | Standard AOL who columns. | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard AOL who columns. |
SSP.SSP_WITHHOLDING_REASONS does not reference any database object
SSP.SSP_WITHHOLDING_REASONS is referenced by following:
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) | Y | Foreign key to PER_ALL_ASSIGNMENTS_F. |
PERSON_ID | NUMBER | (10) | Y | 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) | Y | Primary key from PAY_ELEMENT_ENTRIES_F. |
EFFECTIVE_START_DATE | DATE | Y | Element entry effective start date. | |
EFFECTIVE_END_DATE | DATE | Y | 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. |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MATERNITY_ID | NUMBER | (9) | Y | SSP_MATERNITIES.MATERNITY_ID |
DUE_DATE | DATE | Y | SSP_MATERNITIES.DUE_DATE | |
MPP_START_DATE | DATE | SSP_MATERNITIES.MPP_START_DATE | ||
MPP_END_DATE | DATE | The actual end date of the Maternity Pay Period (based on the woman's absence record). | ||
EWC | DATE | The Expected Week of Confinement. | ||
QW | DATE | The Qualifying Week. | ||
ACTUAL_BIRTH_DATE | DATE | SSP_MATERNITIES.ACTUAL_BIRTH_DATE | ||
PAY_SMP_AS_LUMP_SUM | VARCHAR2 | (30) | Y | SSP_MATERNITIES.PAY_SMP_AS_LUMP_SUM |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
MATERNITY_ID | NUMBER | (9) | Y | |
PERSON_ID | NUMBER | (10) | Y | |
DUE_DATE | DATE | Y | ||
MPP_START_DATE | DATE | |||
EWC | DATE | Expected Week of Confinement. | ||
EARLIEST_MPP_START | DATE | The earliest date on which the Maternity Pay Period would normally be allowed to start. | ||
QW | DATE | Qualifying Week. | ||
CONT_EMP_START | DATE | The date from which the employee would normally have to be continuously employed to qualify for SMP. | ||
PAY_SMP_AS_LUMP_SUM | VARCHAR2 | (30) | Y | |
SMP_MUST_BE_PAID_BY_DATE | DATE | |||
START_DATE_WITH_NEW_EMPLOYER | DATE | |||
START_DATE_MATERNITY_ALLOWANCE | DATE | |||
NOTIFICATION_OF_BIRTH_DATE | DATE | |||
LIVE_BIRTH_FLAG | VARCHAR2 | (30) | Y | |
ACTUAL_BIRTH_DATE | DATE | |||
STATED_RETURN_DATE | DATE | |||
INTEND_TO_RETURN_FLAG | VARCHAR2 | (30) | Y | |
UNFIT_FOR_SCHEDULED_RETURN | VARCHAR2 | (30) | Y | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
ATTRIBUTE16 | VARCHAR2 | (150) | ||
ATTRIBUTE17 | VARCHAR2 | (150) | ||
ATTRIBUTE18 | VARCHAR2 | (150) | ||
ATTRIBUTE19 | VARCHAR2 | (150) | ||
ATTRIBUTE20 | VARCHAR2 | (150) | ||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
LEAVE_TYPE | VARCHAR2 | (2) | ||
MATCHING_DATE | DATE | |||
PLACEMENT_DATE | DATE | |||
DISRUPTED_PLACEMENT_DATE | DATE | |||
MAT_INFORMATION_CATEGORY | VARCHAR2 | (30) | ||
MAT_INFORMATION1 | VARCHAR2 | (150) | ||
MAT_INFORMATION2 | VARCHAR2 | (150) | ||
MAT_INFORMATION3 | VARCHAR2 | (150) | ||
MAT_INFORMATION4 | VARCHAR2 | (150) | ||
MAT_INFORMATION5 | VARCHAR2 | (150) | ||
MAT_INFORMATION6 | VARCHAR2 | (150) | ||
MAT_INFORMATION7 | VARCHAR2 | (150) | ||
MAT_INFORMATION8 | VARCHAR2 | (150) | ||
MAT_INFORMATION9 | VARCHAR2 | (150) | ||
MAT_INFORMATION10 | VARCHAR2 | (150) | ||
MAT_INFORMATION11 | VARCHAR2 | (150) | ||
MAT_INFORMATION12 | VARCHAR2 | (150) | ||
MAT_INFORMATION13 | VARCHAR2 | (150) | ||
MAT_INFORMATION14 | VARCHAR2 | (150) | ||
MAT_INFORMATION15 | VARCHAR2 | (150) | ||
MAT_INFORMATION16 | VARCHAR2 | (150) | ||
MAT_INFORMATION17 | VARCHAR2 | (150) | ||
MAT_INFORMATION18 | VARCHAR2 | (150) | ||
MAT_INFORMATION19 | VARCHAR2 | (150) | ||
MAT_INFORMATION20 | VARCHAR2 | (150) | ||
MAT_INFORMATION21 | VARCHAR2 | (150) | ||
MAT_INFORMATION22 | VARCHAR2 | (150) | ||
MAT_INFORMATION23 | VARCHAR2 | (150) | ||
MAT_INFORMATION24 | VARCHAR2 | (150) | ||
MAT_INFORMATION25 | VARCHAR2 | (240) | ||
MAT_INFORMATION26 | VARCHAR2 | (150) | ||
MAT_INFORMATION27 | VARCHAR2 | (150) | ||
MAT_INFORMATION28 | VARCHAR2 | (150) | ||
MAT_INFORMATION29 | VARCHAR2 | (150) | ||
MAT_INFORMATION30 | VARCHAR2 | (150) |
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) | Y | Foreign key to PER_ALL_ASSIGNMENTS_F. |
PERSON_ID | NUMBER | (10) | Y | Foreign key to PER_ALL_PEOPLE_F. |
ELEMENT_LINK_ID | NUMBER | (9) | Y | Foreign key to PAY_ELEMENT_LINKS_F. |
ELEMENT_ENTRY_ID | NUMBER | (15) | Y | 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 | Y | Element entry effective start date. | |
EFFECTIVE_END_DATE | DATE | Y | Element entry effective end date. | |
ROW_ID | ROWID | (10) | Internal row id. |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
REASON | VARCHAR2 | (30) | Y | |
STOPPAGE_ID | NUMBER | (9) | Y | |
OBJECT_VERSION_NUMBER | NUMBER | (9) | ||
ABSENCE_ATTENDANCE_ID | NUMBER | (9) | ||
MATERNITY_ID | NUMBER | (9) | ||
REASON_ID | NUMBER | (9) | Y | |
USER_ENTERED | VARCHAR2 | (30) | Y | |
OVERRIDE_STOPPAGE | VARCHAR2 | (30) | Y | |
EMPLOYEE_NOTIFIED | VARCHAR2 | (30) | Y | |
WITHHOLD_FROM | DATE | Y | ||
WITHHOLD_TO | DATE | |||
CREATED_BY | NUMBER | (15) | ||
CREATION_DATE | DATE | |||
LAST_UPDATE_DATE | DATE | |||
LAST_UPDATED_BY | NUMBER | (15) | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
ROW_ID | ROWID | (10) |
|
|
Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |