[Home] [Help] [Dependency Information]
Object Name: | PER_PREVIOUS_EMPLOYERS1_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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) |
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;
APPS.PER_PREVIOUS_EMPLOYERS1_DFV is not referenced by any database object
|
|
|