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]

VIEW: APPS.PER_ES_SOCIAL_SECURITY_V

Object Details

Object Name:	PER_ES_SOCIAL_SECURITY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PER.PER_ES_SOCIAL_SECURITY_V
Subobject Name:
Status:	VALID

View Type

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.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)		ROW ID
ASSIGNMENT_ID	NUMBER	(10)	Yes	Assignment ID
ELEMENT_ENTRY_ID	NUMBER	(15)	Yes	Element Entry ID
ELEMENT_LINK_ID	NUMBER	(9)	Yes	Element Link ID
ELEMENT_TYPE_ID	NUMBER	(9)	Yes	Element Type ID
OBJECT_VERSION_NUMBER	NUMBER			Object Version Number
SOCIAL_SECURITY_IDENTIFIER	VARCHAR2	(60)		Social Security Identifier
EPIGRAPH_CODE_CODE	VARCHAR2	(60)		Epigraph Code Code
EPIGRAPH_CODE	VARCHAR2	(4000)		Epigraph Code
CONTRACT_KEY	VARCHAR2	(60)		Contract Key
REBATE	VARCHAR2	(60)		Rebate Reduction ID
SS_EPIGRAPH_114_CODE	VARCHAR2	(60)		Epigraph 114 Code
SS_EPIGRAPH_114	VARCHAR2	(4000)		Epigraph 114
SS_EPIGRAPH_126_CODE	VARCHAR2	(60)		Epigraph 126 Code
SS_EPIGRAPH_126	VARCHAR2	(4000)		Epigraph 126
CONTRIBUTION_INCREMENT	VARCHAR2	(60)		Contribution Increment
UNEMPLOYMENT_STATUS_CODE	VARCHAR2	(60)		Unemployment Status Code
UNEMPLOYMENT_STATUS	VARCHAR2	(4000)		Unemployment Status
SUPPORT_PROGRAM_CODE	VARCHAR2	(1)		Support Program Code
SUPPORT_PROGRAM	VARCHAR2	(4000)		Support Program
REHIRED_DISABLED_CODE	VARCHAR2	(1)		Rehired Disabled Code
REHIRED_DISABLED	VARCHAR2	(4000)		Rehired Disabled
FIRST_CONTRACTOR_CODE	VARCHAR2	(1)		First Contractor Code
FIRST_CONTRACTOR	VARCHAR2	(4000)		First Contractor
SOCIAL_EXCLUSION_CODE	VARCHAR2	(1)		Social Exclusion Code
SOCIAL_EXCLUSION	VARCHAR2	(4000)		Social Exclusion
UNDER_REPRESENTED_WOMEN_CODE	VARCHAR2	(1)		Under Represented Women Code
UNDER_REPRESENTED_WOMEN	VARCHAR2	(4000)		Under Represented Women
AFTER_CHILDBIRTH_CODE	VARCHAR2	(1)		After Child Birth Code
AFTER_CHILDBIRTH	VARCHAR2	(4000)		After Child Birth
MULTIPLE_EMPLOYMENT_CODE	VARCHAR2	(60)		Multiple Employment Code
MULTIPLE_EMPLOYMENT	VARCHAR2	(4000)		Multiple Employment
SUPPORTING_LAW	VARCHAR2	(60)		Supporting Law
SUPPORTING_LAW_DATE_FULL	VARCHAR2	(60)		Supporting Law Date
REBATE_REDUCTION_DATE_FULL	VARCHAR2	(60)		Rebate Reduction Date
SPECIAL_RELATIONSHIP_DATE_FULL	VARCHAR2	(60)		Special Relationship Date
WORK_CENTER_CAC_CODE	VARCHAR2	(60)		Work Center CAC Code
WORK_CENTER_CAC	VARCHAR2	(4000)		Work Center CAC
EFFECTIVE_START_DATE	DATE		Yes	Effective Start Date
EFFECTIVE_END_DATE	DATE		Yes	Effective End Date
ROW_ID1	ROWID	(10)		RowID1
ELEMENT_ENTRY_ID1	NUMBER	(15)	Yes	Element Entry ID1
ELEMENT_LINK_ID1	NUMBER	(9)	Yes	Element Link ID1
ELEMENT_TYPE_ID1	NUMBER	(9)	Yes	Element Type ID1
OBJECT_VERSION_NUMBER1	NUMBER			Object Version Number1
MULTIPLE_EMPLOYMENT_PERCENT	VARCHAR2	(60)		Multiple Employment Percent
AUTHORIZATION_NUMBER	VARCHAR2	(60)		Authorization Number
NON_INDUSTRIAL_RISK	VARCHAR2	(60)		Non Industrial Risk
WAGE_MAINTENANCE_FUND	VARCHAR2	(60)		Wage Maintenance Fund
MAXIMUM_CONTRIBUTION	VARCHAR2	(60)		Maximum Contribution
MINIMUM_CONTRIBUTION	VARCHAR2	(60)		Minimum Contribution
SPECIAL_RELATIONSHIP_TYPE_CODE	VARCHAR2	(60)		Special Relationship Type Code
SPECIAL_RELATIONSHIP_TYPE	VARCHAR2	(4000)		Special Relation Type
TRANSFERRED_CONTRACT_FLAG_CODE	VARCHAR2	(1)		Transferred Contract Flag Code
TRANSFERRED_CONTRACT_FLAG	VARCHAR2	(4000)		Transferred Contract Flag
RETIREMENT_AGE_REDUCTION	VARCHAR2	(60)		Retirement Age Reduction

Query Text

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


SELECT ROW_ID
,      ASSIGNMENT_ID
,      ELEMENT_ENTRY_ID
,      ELEMENT_LINK_ID
,      ELEMENT_TYPE_ID
,      OBJECT_VERSION_NUMBER
,      SOCIAL_SECURITY_IDENTIFIER
,      EPIGRAPH_CODE_CODE
,      EPIGRAPH_CODE
,      CONTRACT_KEY
,      REBATE
,      SS_EPIGRAPH_114_CODE
,      SS_EPIGRAPH_114
,      SS_EPIGRAPH_126_CODE
,      SS_EPIGRAPH_126
,      CONTRIBUTION_INCREMENT
,      UNEMPLOYMENT_STATUS_CODE
,      UNEMPLOYMENT_STATUS
,      SUPPORT_PROGRAM_CODE
,      SUPPORT_PROGRAM
,      REHIRED_DISABLED_CODE
,      REHIRED_DISABLED
,      FIRST_CONTRACTOR_CODE
,      FIRST_CONTRACTOR
,      SOCIAL_EXCLUSION_CODE
,      SOCIAL_EXCLUSION
,      UNDER_REPRESENTED_WOMEN_CODE
,      UNDER_REPRESENTED_WOMEN
,      AFTER_CHILDBIRTH_CODE
,      AFTER_CHILDBIRTH
,      MULTIPLE_EMPLOYMENT_CODE
,      MULTIPLE_EMPLOYMENT
,      SUPPORTING_LAW
,      SUPPORTING_LAW_DATE_FULL
,      REBATE_REDUCTION_DATE_FULL
,      SPECIAL_RELATIONSHIP_DATE_FULL
,      WORK_CENTER_CAC_CODE
,      WORK_CENTER_CAC
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ROW_ID1
,      ELEMENT_ENTRY_ID1
,      ELEMENT_LINK_ID1
,      ELEMENT_TYPE_ID1
,      OBJECT_VERSION_NUMBER1
,      MULTIPLE_EMPLOYMENT_PERCENT
,      AUTHORIZATION_NUMBER
,      NON_INDUSTRIAL_RISK
,      WAGE_MAINTENANCE_FUND
,      MAXIMUM_CONTRIBUTION
,      MINIMUM_CONTRIBUTION
,      SPECIAL_RELATIONSHIP_TYPE_CODE
,      SPECIAL_RELATIONSHIP_TYPE
,      TRANSFERRED_CONTRACT_FLAG_CODE
,      TRANSFERRED_CONTRACT_FLAG
,      RETIREMENT_AGE_REDUCTION
FROM APPS.PER_ES_SOCIAL_SECURITY_V;

Dependencies

[top of page]

APPS.PER_ES_SOCIAL_SECURITY_V references the following:

APPS: FND_SESSIONS; HR_GENERAL - show dependent code; PAY_ELEMENT_ENTRIES_F; PAY_ELEMENT_ENTRY_VALUES_F; PAY_ELEMENT_LINKS_F; PAY_ELEMENT_TYPES_F; PAY_INPUT_VALUES_F

APPS.PER_ES_SOCIAL_SECURITY_V is referenced by following:

PUBLIC: PER_ES_SOCIAL_SECURITY_V