[Home] [Help] [Dependency Information]
Object Name: | PAY_ELEMENT_ENTRIES_F_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CONTEXT_VALUE | VARCHAR2 | (30) | ||
REDUNDANCY_PAYMENT | VARCHAR2 | (150) | ||
COMPENSATION | VARCHAR2 | (150) | ||
GOLDEN_HANDSHAKE | VARCHAR2 | (150) | ||
SALARY_IN_LIEU_OF_NOTICE | VARCHAR2 | (150) | ||
UNUSED_SICK_LEAVE | VARCHAR2 | (150) | ||
UNUSED_RDO | VARCHAR2 | (150) | ||
OTHER | VARCHAR2 | (150) | ||
LAST_UPDATE_DATE | DATE | |||
ATTACHMENT_PRIORITY | VARCHAR2 | (150) | ||
ATTACHABLE_EARNINGS_RULE | VARCHAR2 | (150) | ||
PRORATE_ON_INSUFFICIENT_FUNDS | VARCHAR2 | (150) | ||
DATE_SERVED | DATE | |||
DEDUCTION_TYPE | VARCHAR2 | (150) | ||
DEDUCTION_BASIS | VARCHAR2 | (150) | ||
DEDUCTION_PERCENTAGE | NUMBER | |||
DEDUCTION_AMOUNT_PER_RUN | NUMBER | |||
DEDUCTION_CAP_PERIOD | NUMBER | |||
DEDUCTION_CAP_MONTH | NUMBER | |||
DEDUCTION_TERMINATION_RULE | VARCHAR2 | (150) | ||
DEDUCTION_TOTAL_OWED | NUMBER | |||
DURATION__NO_OF_WEEKS_MONTHS_ | NUMBER | |||
FEE_FIRST_DEDUCTION_AMT | NUMBER | |||
FEE_BASIS | VARCHAR2 | (150) | ||
FEE_PERCENTAGE | NUMBER | |||
FEE_AMOUNT_PER_RUN | NUMBER | |||
FEE_CAP_PERIOD | NUMBER | |||
FEE_CAP_MONTH | NUMBER | |||
EXEMPTION_BASIS | VARCHAR2 | (150) | ||
EXEMPTION_PERCENTAGE | NUMBER | |||
EXEMPTION_MINIMUM_AMT | NUMBER | |||
EXEMPTION_MAXIMUM_AMT | NUMBER | |||
OVERRIDE_CONTRIBUTION_AREA | VARCHAR2 | (150) | ||
EE_PERCENT_OR_FIXED | VARCHAR2 | (150) | ||
EE_RATE_OR_FIXED_AMOUNT | NUMBER | |||
ER_PERCENT_OR_FIXED | VARCHAR2 | (150) | ||
ER_RATE_OR_FIXED_AMOUNT | NUMBER | |||
EE_CONT_BASE_METHOD | VARCHAR2 | (150) | ||
EE_FIXED_AMOUNT | NUMBER | |||
ER_CONT_BASE_METHOD | VARCHAR2 | (150) | ||
ER_FIXED_AMOUNT | NUMBER | |||
CONTRIBUTION_KEY | NUMBER | |||
HEALTH_ORG_ID | NUMBER | |||
PENSION_ORG_ID | NUMBER | |||
UNEMPLOYMENT_ORG_ID | NUMBER | |||
SPECIAL_CARE_ORG_ID | NUMBER | |||
OCCUPATION_KEY | NUMBER | |||
PEOPLE_GROUP_KEY | NUMBER | |||
LEGAL_AREA_CODE | VARCHAR2 | (150) | ||
HEALTH_INSURANCE_NUMBER | VARCHAR2 | (150) | ||
PRIVATE_HEALTH_PROVIDER_ORG_ID | NUMBER | |||
PRIVATE_HEALTH_CONTRIBUTION | NUMBER | |||
VOLUNTARY_PENSION_PROV_ID | NUMBER | |||
VOLUNTARY_PENSION_CONTR | NUMBER | |||
CONTRIBUTION_TRANSFER_BY_CODE | VARCHAR2 | (150) | ||
SPECIAL_CARE_CONTRIBUTION | NUMBER | |||
PRIVATELY_INSURED_FLAG | VARCHAR2 | (150) | ||
VOLUNTARY_PENSION_NUMBER | NUMBER | |||
ADD_INSURANCE_PROVIDER | NUMBER | |||
ADD_INS_MEMSHIP_NUMBER | VARCHAR2 | (150) | ||
ADD_INS_STATUS | VARCHAR2 | (150) | ||
ADD_INS_START_DATE | DATE | |||
ADD_INS_END_DATE | DATE | |||
ADD_INS_END_REASON | NUMBER | |||
JOB_KEY_CODE | NUMBER | |||
FORM_NUMBER | VARCHAR2 | (150) | ||
EXEMPTION_ISSUE_DATE | DATE | |||
VALID_FROM | DATE | |||
VALID_TO | DATE | |||
TAX_FREE_RENUMERATION | NUMBER | |||
TAX_CARD_NUMBER | VARCHAR2 | (150) | ||
TAX_YEAR | NUMBER | |||
ISSUE_DATE | DATE | |||
CARD_ISSUER | VARCHAR2 | (150) | ||
TAX_CARD_LOCATION | VARCHAR2 | (150) | ||
TAX_STATUS | VARCHAR2 | (150) | ||
TAX_TABLE | VARCHAR2 | (150) | ||
TAX_CLASS | VARCHAR2 | (150) | ||
NO_OF_CHILDREN | NUMBER | |||
YEARLY_TAX_FREE_INCOME | NUMBER | |||
MONTHLY_TAX_FREE_INCOME | NUMBER | |||
ADDITIONAL_YEAR_TAXABLE_INCOME | NUMBER | |||
YEARLY_INCOME_TAX_CALC_FLAG | VARCHAR2 | (150) | ||
CHAMBER_CONTRIBUTION | VARCHAR2 | (150) | ||
PENSIONERS_TAX_FLA | VARCHAR2 | (150) | ||
ADDITIONAL_MTH_TAXABLE_INCOME | NUMBER | |||
EMPLOYEE_CHURCH_CODE | VARCHAR2 | (150) | ||
SPOUSE_CHURCH_CODE | VARCHAR2 | (150) | ||
BUNDESLAND_CHURCH | VARCHAR2 | (150) | ||
YEARLY_CHURCH_TAX_FLAG | VARCHAR2 | (150) | ||
MAX_CHURCH_TAX_FLAG | VARCHAR2 | (150) | ||
UPDATED | VARCHAR2 | (150) | ||
TAX_OFFICE_ORG_ID | NUMBER | |||
ORIGINATING_CPAM_INFORMATION | VARCHAR2 | (150) | ||
ORIGINATING_ABSENCE | VARCHAR2 | (150) | ||
OVERTIME_SCHEME | VARCHAR2 | (150) | ||
BONIFICATION_METHOD | VARCHAR2 | (150) | ||
MAJORATION_METHOD | VARCHAR2 | (150) | ||
REGULARISATION_START_DATE | DATE | |||
PENSION_CATEGORY | VARCHAR2 | (150) | ||
ARRCO_PROVIDER | VARCHAR2 | (150) | ||
ARRCO_IDENTIFICATION_NUMBER | NUMBER | |||
AGIRC_PROVIDER | VARCHAR2 | (150) | ||
AGIRC_IDENTIFICATION_NUMBER | NUMBER | |||
OPTIONAL_ACCESSORIES_FITTED | NUMBER | |||
PRICE_OF_ACCESSORIES_ADDED_AFT | NUMBER | |||
CAPITAL_CONTRIBUTIONS_MADE | NUMBER | |||
PRIVATE_USE_PAYMENTS | NUMBER | |||
ENGINE_CC_FOR_FUEL_CHARGE | NUMBER | |||
MILEAGE_BAND | VARCHAR2 | (150) | ||
BENEFIT_CHARGE | NUMBER | |||
AGE_DISCOUNT | NUMBER | |||
TOTAL_DAYS_UNAVAILABLE | NUMBER | |||
UNAVAILABLE_VALUE | NUMBER | |||
FUEL_BENEFIT | VARCHAR2 | (150) | ||
BENEFIT_PERCENTAGE | NUMBER | |||
STANDARD_DISCOUNT | NUMBER | |||
ADDITIONAL_DISCOUNT | NUMBER | |||
ACCESSORIES | NUMBER | |||
ENGINE_CC | NUMBER | |||
CAR_BENEFIT_FULL_YEAR | NUMBER | |||
CAR_UNAVAILABLE_VALUE | NUMBER | |||
STANDARD_DISCOUNT_PERCENTAGE | NUMBER | |||
ADDITIONAL_DISCOUNT_PERCENTAGE | NUMBER | |||
DATE_FREE_FUEL_WITHDRAWN | DATE | |||
FREE_FUEL_REINSTATED | VARCHAR2 | (150) | ||
ADDITIONAL_WITHDRAWN_FUEL_DAYS | NUMBER | |||
FUEL_BENEFIT_FULL_YEAR | NUMBER | |||
FUEL_BENEFIT_UNAVAILABLE_VALUE | NUMBER | |||
VALID_BENEFIT_END_DATE | VARCHAR2 | (150) | ||
OFFICIAL_RATE_OF_INTEREST | NUMBER | |||
ANNUAL_INTEREST_VALUE | NUMBER | |||
INTEREST_VALUE | NUMBER | |||
CALCULATION_METHOD | VARCHAR2 | (150) | ||
UNAVAILABLE_DATE_FROM_C | DATE | |||
UNAVAILABLE_DATE_TO_C | DATE | |||
DAYS_UNAVAILABLE_C | NUMBER | |||
UNAVAILABLE_DATE_FROM_D | DATE | |||
UNAVAILABLE_DATE_TO_D | DATE | |||
DAYS_UNAVAILABLE_D | NUMBER | |||
SECTION_198_CLAIM_INDICATOR | VARCHAR2 | (150) | ||
NOTES | VARCHAR2 | (150) | ||
TOTAL_DAYS_NO_FUEL_BENEFIT | VARCHAR2 | (150) | ||
SHARED_VAN_FUEL_REDUCTION | VARCHAR2 | (150) | ||
P6_ISSUE_DATE | DATE | |||
P6_MESSAGE_DATE | DATE | |||
ADDRESS_ID | VARCHAR2 | (150) | ||
SCHEME_ID | VARCHAR2 | (150) | ||
INTEREST_CALC_FROM_DATE_1 | DATE | |||
INTEREST_CALC_TO_DATE_1 | DATE | |||
INTEREST_CALCULATION_BASE_1 | NUMBER | |||
INTEREST_RATE_1 | NUMBER | |||
INTEREST_CALC_FROM_DATE_2 | DATE | |||
INTEREST_CALC_TO_DATE_2 | DATE | |||
INTEREST_CALCULATION_BASE2 | NUMBER | |||
INTEREST_RATE_2 | NUMBER | |||
INTEREST_CALC_FROM_DATE_3 | DATE | |||
INTEREST_CALC_TO_DATE_3 | DATE | |||
INTEREST_CALCULATION_BASE_3 | NUMBER | |||
INTEREST_RATE_3 | NUMBER | |||
INTEREST_CALC_FROM_DATE_4 | DATE | |||
INTEREST_CALC_TO_DATE_4 | DATE | |||
INTEREST_CALCULATION_BASE_4 | NUMBER | |||
INTEREST_RATE_4 | NUMBER | |||
INTEREST_CALC_FROM_DATE_5 | DATE | |||
INTEREST_CALC_TO_DATE_5 | DATE | |||
INTEREST_CALCULATION_BASE_5 | NUMBER | |||
INTEREST_RATE_5 | NUMBER | |||
PREVIOUS_CASE_NUMBER | VARCHAR2 | (150) | ||
COURT_ORDER_ORIGIN | VARCHAR2 | (150) | ||
COMMENTS | VARCHAR2 | (150) | ||
REFERENCE_NUMBER | VARCHAR2 | (150) | ||
DEDUCTION_AUTHORITY | VARCHAR2 | (150) | ||
TOTAL_DEDUCTION_AMOUNT | NUMBER | |||
START_DATE | DATE | |||
END_DATE | DATE | |||
PAYSLIP_INFORMATION | VARCHAR2 | (150) | ||
FIPS_CODE | VARCHAR2 | (150) | ||
MEDICAL_SUPPORT_INDICATOR | VARCHAR2 | (150) | ||
DOCUMENT_NUMBER | VARCHAR2 | (150) | ||
OVRRIDE_GARN_EX_DI_PCT | NUMBER | |||
OVRRIDE_GARN_EX_DI_PCT_ARR | NUMBER | |||
OVRRIDE_GARN_EX_DI_PCT_DEP | NUMBER | |||
OVRRIDE_GARN_EX_DI_PCT_DEP_ARR | NUMBER | |||
OVRD_GARN_MAX_WTHLDNG_DURATION | NUMBER | |||
INITIAL_FEE_FLAG | VARCHAR2 | (150) | ||
EE_OR_SPOUSE_BLIND___AGE____65 | NUMBER | |||
CONCATENATED_SEGMENTS | VARCHAR2 | (3654) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CONTEXT_VALUE
, REDUNDANCY_PAYMENT
, COMPENSATION
, GOLDEN_HANDSHAKE
, SALARY_IN_LIEU_OF_NOTICE
, UNUSED_SICK_LEAVE
, UNUSED_RDO
, OTHER
, LAST_UPDATE_DATE
, ATTACHMENT_PRIORITY
, ATTACHABLE_EARNINGS_RULE
, PRORATE_ON_INSUFFICIENT_FUNDS
, DATE_SERVED
, DEDUCTION_TYPE
, DEDUCTION_BASIS
, DEDUCTION_PERCENTAGE
, DEDUCTION_AMOUNT_PER_RUN
, DEDUCTION_CAP_PERIOD
, DEDUCTION_CAP_MONTH
, DEDUCTION_TERMINATION_RULE
, DEDUCTION_TOTAL_OWED
, DURATION__NO_OF_WEEKS_MONTHS_
, FEE_FIRST_DEDUCTION_AMT
, FEE_BASIS
, FEE_PERCENTAGE
, FEE_AMOUNT_PER_RUN
, FEE_CAP_PERIOD
, FEE_CAP_MONTH
, EXEMPTION_BASIS
, EXEMPTION_PERCENTAGE
, EXEMPTION_MINIMUM_AMT
, EXEMPTION_MAXIMUM_AMT
, OVERRIDE_CONTRIBUTION_AREA
, EE_PERCENT_OR_FIXED
, EE_RATE_OR_FIXED_AMOUNT
, ER_PERCENT_OR_FIXED
, ER_RATE_OR_FIXED_AMOUNT
, EE_CONT_BASE_METHOD
, EE_FIXED_AMOUNT
, ER_CONT_BASE_METHOD
, ER_FIXED_AMOUNT
, CONTRIBUTION_KEY
, HEALTH_ORG_ID
, PENSION_ORG_ID
, UNEMPLOYMENT_ORG_ID
, SPECIAL_CARE_ORG_ID
, OCCUPATION_KEY
, PEOPLE_GROUP_KEY
, LEGAL_AREA_CODE
, HEALTH_INSURANCE_NUMBER
, PRIVATE_HEALTH_PROVIDER_ORG_ID
, PRIVATE_HEALTH_CONTRIBUTION
, VOLUNTARY_PENSION_PROV_ID
, VOLUNTARY_PENSION_CONTR
, CONTRIBUTION_TRANSFER_BY_CODE
, SPECIAL_CARE_CONTRIBUTION
, PRIVATELY_INSURED_FLAG
, VOLUNTARY_PENSION_NUMBER
, ADD_INSURANCE_PROVIDER
, ADD_INS_MEMSHIP_NUMBER
, ADD_INS_STATUS
, ADD_INS_START_DATE
, ADD_INS_END_DATE
, ADD_INS_END_REASON
, JOB_KEY_CODE
, FORM_NUMBER
, EXEMPTION_ISSUE_DATE
, VALID_FROM
, VALID_TO
, TAX_FREE_RENUMERATION
, TAX_CARD_NUMBER
, TAX_YEAR
, ISSUE_DATE
, CARD_ISSUER
, TAX_CARD_LOCATION
, TAX_STATUS
, TAX_TABLE
, TAX_CLASS
, NO_OF_CHILDREN
, YEARLY_TAX_FREE_INCOME
, MONTHLY_TAX_FREE_INCOME
, ADDITIONAL_YEAR_TAXABLE_INCOME
, YEARLY_INCOME_TAX_CALC_FLAG
, CHAMBER_CONTRIBUTION
, PENSIONERS_TAX_FLA
, ADDITIONAL_MTH_TAXABLE_INCOME
, EMPLOYEE_CHURCH_CODE
, SPOUSE_CHURCH_CODE
, BUNDESLAND_CHURCH
, YEARLY_CHURCH_TAX_FLAG
, MAX_CHURCH_TAX_FLAG
, UPDATED
, TAX_OFFICE_ORG_ID
, ORIGINATING_CPAM_INFORMATION
, ORIGINATING_ABSENCE
, OVERTIME_SCHEME
, BONIFICATION_METHOD
, MAJORATION_METHOD
, REGULARISATION_START_DATE
, PENSION_CATEGORY
, ARRCO_PROVIDER
, ARRCO_IDENTIFICATION_NUMBER
, AGIRC_PROVIDER
, AGIRC_IDENTIFICATION_NUMBER
, OPTIONAL_ACCESSORIES_FITTED
, PRICE_OF_ACCESSORIES_ADDED_AFT
, CAPITAL_CONTRIBUTIONS_MADE
, PRIVATE_USE_PAYMENTS
, ENGINE_CC_FOR_FUEL_CHARGE
, MILEAGE_BAND
, BENEFIT_CHARGE
, AGE_DISCOUNT
, TOTAL_DAYS_UNAVAILABLE
, UNAVAILABLE_VALUE
, FUEL_BENEFIT
, BENEFIT_PERCENTAGE
, STANDARD_DISCOUNT
, ADDITIONAL_DISCOUNT
, ACCESSORIES
, ENGINE_CC
, CAR_BENEFIT_FULL_YEAR
, CAR_UNAVAILABLE_VALUE
, STANDARD_DISCOUNT_PERCENTAGE
, ADDITIONAL_DISCOUNT_PERCENTAGE
, DATE_FREE_FUEL_WITHDRAWN
, FREE_FUEL_REINSTATED
, ADDITIONAL_WITHDRAWN_FUEL_DAYS
, FUEL_BENEFIT_FULL_YEAR
, FUEL_BENEFIT_UNAVAILABLE_VALUE
, VALID_BENEFIT_END_DATE
, OFFICIAL_RATE_OF_INTEREST
, ANNUAL_INTEREST_VALUE
, INTEREST_VALUE
, CALCULATION_METHOD
, UNAVAILABLE_DATE_FROM_C
, UNAVAILABLE_DATE_TO_C
, DAYS_UNAVAILABLE_C
, UNAVAILABLE_DATE_FROM_D
, UNAVAILABLE_DATE_TO_D
, DAYS_UNAVAILABLE_D
, SECTION_198_CLAIM_INDICATOR
, NOTES
, TOTAL_DAYS_NO_FUEL_BENEFIT
, SHARED_VAN_FUEL_REDUCTION
, P6_ISSUE_DATE
, P6_MESSAGE_DATE
, ADDRESS_ID
, SCHEME_ID
, INTEREST_CALC_FROM_DATE_1
, INTEREST_CALC_TO_DATE_1
, INTEREST_CALCULATION_BASE_1
, INTEREST_RATE_1
, INTEREST_CALC_FROM_DATE_2
, INTEREST_CALC_TO_DATE_2
, INTEREST_CALCULATION_BASE2
, INTEREST_RATE_2
, INTEREST_CALC_FROM_DATE_3
, INTEREST_CALC_TO_DATE_3
, INTEREST_CALCULATION_BASE_3
, INTEREST_RATE_3
, INTEREST_CALC_FROM_DATE_4
, INTEREST_CALC_TO_DATE_4
, INTEREST_CALCULATION_BASE_4
, INTEREST_RATE_4
, INTEREST_CALC_FROM_DATE_5
, INTEREST_CALC_TO_DATE_5
, INTEREST_CALCULATION_BASE_5
, INTEREST_RATE_5
, PREVIOUS_CASE_NUMBER
, COURT_ORDER_ORIGIN
, COMMENTS
, REFERENCE_NUMBER
, DEDUCTION_AUTHORITY
, TOTAL_DEDUCTION_AMOUNT
, START_DATE
, END_DATE
, PAYSLIP_INFORMATION
, FIPS_CODE
, MEDICAL_SUPPORT_INDICATOR
, DOCUMENT_NUMBER
, OVRRIDE_GARN_EX_DI_PCT
, OVRRIDE_GARN_EX_DI_PCT_ARR
, OVRRIDE_GARN_EX_DI_PCT_DEP
, OVRRIDE_GARN_EX_DI_PCT_DEP_ARR
, OVRD_GARN_MAX_WTHLDNG_DURATION
, INITIAL_FEE_FLAG
, EE_OR_SPOUSE_BLIND___AGE____65
, CONCATENATED_SEGMENTS
FROM APPS.PAY_ELEMENT_ENTRIES_F_DFV;
APPS.PAY_ELEMENT_ENTRIES_F_DFV is not referenced by any database object
|
|
|