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_MATERNITIES

Object Details

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

Record of a woman's maternities/pregnancies.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: SSP_MATERNITIES_PK

MATERNITY_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
SSP_MATERNITIES_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	MATERNITY_ID
SSP_MATERNITIES_UK1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DUE_DATE PERSON_ID LEAVE_TYPE
SSP_MATERNITIES_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PERSON_ID

Foreign Keys

Table		Foreign Table	Foreign Key Column
SSP_MEDICALS		SSP_MATERNITIES	SSP_MEDICALS MATERNITY_ID
SSP_STOPPAGES		SSP_MATERNITIES	SSP_STOPPAGES MATERNITY_ID

Columns

Name	Datatype	Length	Mandatory	Comments
MATERNITY_ID	NUMBER	(9)	Yes	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		Yes	Date the baby is expected to be born.
PERSON_ID	NUMBER	(10)	Yes	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)	Yes	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)	Yes	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)	Yes	Should SMP be paid in one lump sum, in advance?
LIVE_BIRTH_FLAG	VARCHAR2	(30)	Yes	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)	Yes	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
PARTNER_STAT_PAY_START_DATE	DATE			Partner Statutory Payment start date
PARTNER_RETURN_TO_WORK	DATE			Partner Return to Work Date
PARTNER_DEATH_DATE	DATE			Partner Date of Death

Query Text

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


SELECT MATERNITY_ID
,      OBJECT_VERSION_NUMBER
,      DUE_DATE
,      PERSON_ID
,      START_DATE_MATERNITY_ALLOWANCE
,      NOTIFICATION_OF_BIRTH_DATE
,      UNFIT_FOR_SCHEDULED_RETURN
,      STATED_RETURN_DATE
,      INTEND_TO_RETURN_FLAG
,      START_DATE_WITH_NEW_EMPLOYER
,      SMP_MUST_BE_PAID_BY_DATE
,      PAY_SMP_AS_LUMP_SUM
,      LIVE_BIRTH_FLAG
,      ACTUAL_BIRTH_DATE
,      MPP_START_DATE
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LEAVE_TYPE
,      ADOPTIVE_CHILDS_BIRTH_DATE
,      MATCHING_DATE
,      PLACEMENT_DATE
,      DISRUPTED_PLACEMENT_DATE
,      MAT_INFORMATION_CATEGORY
,      MAT_INFORMATION1
,      MAT_INFORMATION2
,      MAT_INFORMATION3
,      MAT_INFORMATION4
,      MAT_INFORMATION5
,      MAT_INFORMATION6
,      MAT_INFORMATION7
,      MAT_INFORMATION8
,      MAT_INFORMATION9
,      MAT_INFORMATION10
,      MAT_INFORMATION11
,      MAT_INFORMATION12
,      MAT_INFORMATION13
,      MAT_INFORMATION14
,      MAT_INFORMATION15
,      MAT_INFORMATION16
,      MAT_INFORMATION17
,      MAT_INFORMATION18
,      MAT_INFORMATION19
,      MAT_INFORMATION20
,      MAT_INFORMATION21
,      MAT_INFORMATION22
,      MAT_INFORMATION23
,      MAT_INFORMATION24
,      MAT_INFORMATION25
,      MAT_INFORMATION26
,      MAT_INFORMATION27
,      MAT_INFORMATION28
,      MAT_INFORMATION29
,      MAT_INFORMATION30
,      PARTNER_STAT_PAY_START_DATE
,      PARTNER_RETURN_TO_WORK
,      PARTNER_DEATH_DATE
FROM SSP.SSP_MATERNITIES;

Dependencies

[top of page]

SSP.SSP_MATERNITIES does not reference any database object

SSP.SSP_MATERNITIES is referenced by following:

SSP: SSP_MATERNITIES#