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_PREVIOUS_EMPLOYERS1_DFV

Object Details

Object Name:	PER_PREVIOUS_EMPLOYERS1_DFV
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
ROW_ID	ROWID	(10)
CONTEXT_VALUE	VARCHAR2	(30)
TERMINATION_REASON	VARCHAR2	(150)
TRANSFER_DATE	DATE
SECTOR___DEPARTMENT_NAME	VARCHAR2	(150)
PAID_FROM_ANY_OTHER_SECTOR	VARCHAR2	(150)
EMPLOYEE_APPROVAL	VARCHAR2	(150)
APPROVAL_DATE	DATE
SICKNESS_HOLIDAY_TAKEN	VARCHAR2	(150)
DESIGNATION	VARCHAR2	(150)
ANNUAL_SALARY	NUMBER
PF_NUMBER	VARCHAR2	(150)
PF_ESTABLISHMENT_CODE	VARCHAR2	(150)
EPF_NUMBER	VARCHAR2	(150)
EMPLOYER_CLASSIFICATION	VARCHAR2	(150)
LTC_AVAILED_CRNT_BLOCK	NUMBER
LEAVE_ENCASHMENT_AMOUNT	NUMBER
GRATUITY_AMOUNT	NUMBER
RETRENCHMENT_AMOUNT	NUMBER
VRS_AMOUNT	NUMBER
GROSS_EARNINGS_IN_CTY	NUMBER
SUPERANNUATION_IN_CTY	NUMBER
PF_DEDUCTION_IN_CTY	NUMBER
ENT_ALLOWANCE_IN_CTY	NUMBER
EXEMP_80GG_IN_CTY	NUMBER
PROFFESIONAL_TAX_PAID_IN_CTY	NUMBER
TDS_IN_CTY	NUMBER
SC_IN_CTY	NUMBER
CESS_IN_CTY	NUMBER
SEC_AND_HE_CESS_IN_CTY	NUMBER
MEDICAL_REIMBURSE_IN_CTY	NUMBER
EXEMP_80CCD_IN_CTY	NUMBER
EXEMP_CGHS_IN_CTY	NUMBER
TAX_YEAR	NUMBER
EMPLOYER_NAME_KANA	VARCHAR2	(150)
EMPLOYER_ADDRESS_KANA	VARCHAR2	(150)
EMPLOYMENT_INCOME	NUMBER
SI_PREMS	NUMBER
MUTUAL_AID_PREM	NUMBER
WITHHOLDING_TAX	NUMBER
CHILD_MINDER_ALREADY_TAKEN	NUMBER
HOLIDAY_TAKEN	NUMBER
DIRECTION_NUMBER	VARCHAR2	(150)
TELEPHONE	VARCHAR2	(150)
MOBILE	VARCHAR2	(150)
FAX	VARCHAR2	(150)
E_MAIL	VARCHAR2	(150)
ADDITIONAL_CONTACT_INFORMATION	VARCHAR2	(150)
REFERENCES	VARCHAR2	(150)
UNINTERRUPTED_SERVICE_RECORD	VARCHAR2	(150)
TOTAL_SERVICE_RECORD	VARCHAR2	(150)
CONCATENATED_SEGMENTS	VARCHAR2	(3654)

Query Text

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


SELECT ROW_ID
,      CONTEXT_VALUE
,      TERMINATION_REASON
,      TRANSFER_DATE
,      SECTOR___DEPARTMENT_NAME
,      PAID_FROM_ANY_OTHER_SECTOR
,      EMPLOYEE_APPROVAL
,      APPROVAL_DATE
,      SICKNESS_HOLIDAY_TAKEN
,      DESIGNATION
,      ANNUAL_SALARY
,      PF_NUMBER
,      PF_ESTABLISHMENT_CODE
,      EPF_NUMBER
,      EMPLOYER_CLASSIFICATION
,      LTC_AVAILED_CRNT_BLOCK
,      LEAVE_ENCASHMENT_AMOUNT
,      GRATUITY_AMOUNT
,      RETRENCHMENT_AMOUNT
,      VRS_AMOUNT
,      GROSS_EARNINGS_IN_CTY
,      SUPERANNUATION_IN_CTY
,      PF_DEDUCTION_IN_CTY
,      ENT_ALLOWANCE_IN_CTY
,      EXEMP_80GG_IN_CTY
,      PROFFESIONAL_TAX_PAID_IN_CTY
,      TDS_IN_CTY
,      SC_IN_CTY
,      CESS_IN_CTY
,      SEC_AND_HE_CESS_IN_CTY
,      MEDICAL_REIMBURSE_IN_CTY
,      EXEMP_80CCD_IN_CTY
,      EXEMP_CGHS_IN_CTY
,      TAX_YEAR
,      EMPLOYER_NAME_KANA
,      EMPLOYER_ADDRESS_KANA
,      EMPLOYMENT_INCOME
,      SI_PREMS
,      MUTUAL_AID_PREM
,      WITHHOLDING_TAX
,      CHILD_MINDER_ALREADY_TAKEN
,      HOLIDAY_TAKEN
,      DIRECTION_NUMBER
,      TELEPHONE
,      MOBILE
,      FAX
,      E_MAIL
,      ADDITIONAL_CONTACT_INFORMATION
,      REFERENCES
,      UNINTERRUPTED_SERVICE_RECORD
,      TOTAL_SERVICE_RECORD
,      CONCATENATED_SEGMENTS
FROM APPS.PER_PREVIOUS_EMPLOYERS1_DFV;

Dependencies

[top of page]

APPS.PER_PREVIOUS_EMPLOYERS1_DFV references the following:

APPS: FND_NUMBER - show dependent code; PER_PREVIOUS_EMPLOYERS

APPS.PER_PREVIOUS_EMPLOYERS1_DFV is not referenced by any database object