[Home] [Help] [Dependency Information]

VIEW: APPS.PAY_ELEMENT_TYPES_F_DFV

Object Details

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      CONTEXT_VALUE
,      ALLOWANCE
,      PRIMARY_BALANCE
,      TERM_ELIGIBILITY_YEARS
,      UNION_FEES_PRIMARY_BALANCE
,      CATEGORY
,      HOURS_BALANCE
,      TAX_PROCESSING_TYPE
,      ROE_ALLOCATION_BY
,      YEAR_END_FORM
,      FEDERAL_FOOTNOTE
,      PROVINCIAL_FOOTNOTE
,      REGULAR_EARNINGS_ADJUSTMENT
,      LIABILITY
,      REGISTRATION_NUMBER
,      PRIORITY_CLASSIFICATION
,      INSUFFICIENT_FUNDS_TYPE
,      PROCESSING_RUN_TYPE
,      PERIOD_TYPE
,      ACCRUED_BALANCE
,      ARREARS_BALANCE
,      NOT_TAKEN_BALANCE
,      ADDITIONAL_AMOUNT_BALANCE
,      REPLACEMENT_AMOUNT_BALANCE
,      FEE_BALANCE
,      BENEFIT_GIVEN
,      BENEFIT_TYPE
,      GROUP_NAME
,      BASE_UNITS
,      EARLIEST_START_OF_APP
,      CONTINUOUS_EMPLOYMENT_PERIOD
,      MAXIMUM_APP_WEEKS
,      SAP_RATE
,      RECOVERY_RATE
,      STANDARD_RATE
,      DISRUPTED_PLACEMENT_WEEKS
,      EARLIEST_START_OF_MPP
,      QUALIFYING_WEEK
,      MAXIMUM_MPP_WEEKS
,      COMPULSORY_LEAVE_WEEKS
,      MPP_NOTICE_REQUIREMENT
,      NOTICE_OF_BIRTH_REQUIREMENT
,      EARLIEST_SMP_EVIDENCE
,      HIGHER_SMP_RATE
,      LOWER_SMP_RATE
,      LATEST_SMP_EVIDENCE
,      EXTENDED_SMP_EVIDENCE
,      WEEKS_AT_HIGHER_RATE
,      STILLBIRTH_THRESHOLD_WEEK
,      STANDARD_SMP_RATE
,      EARLIEST_START_OF_PPP
,      MAXIMUM_PPP_WEEK
,      SPP_RATE
,      LATEST_END_OF_PPP
,      MAXIMUM_PPP_WEEKS
,      MAXIMUM_SSP_PERIOD
,      MAXIMUM_AGE
,      LINKING_PERIOD_DAYS
,      WAITING_DAYS
,      PIW_THRESHOLD
,      MAXIMUM_LINKED_PIW_YEARS
,      PERCENTAGE_THRESHOLD
,      ALLOWANCE_NAME
,      ALLOWANCE_CATEGORY
,      EXEMPTION_AMOUNT
,      NATURE_OF_EXPENSE
,      PERQUISITE_NAME
,      TAXABLE
,      INCLUDES_REST_DAYS
,      EXPENSE_TYPE
,      TAX_CATEGORY
,      INCLUDE_IN_OT_BASE
,      FLSA_HOURS
,      SPECIAL_INPUTS_ELEMENT
,      SPECIAL_FEATURES_ELEMENT
,      REDUCE_REGULAR
,      CALCULATION_TYPE
,      SUPP_TAX_CATEGORY
,      EARNINGS
,      OVERRIDE_REGULAR
,      VERIFICATION_ELEMENT
,      JURISDICTION
,      BENEFITS_CARRIER
,      PARTIAL_EE_CONTRIBUTIONS
,      PAYROLL_TABLE
,      ROW_TYPE
,      PAYMIX_CATEGORY
,      TOWARD_BOND_PURCHASE
,      CALCULATION_ELEMENT
,      VOL_DEDNS_AT_WRIT
,      PAYMENT_CATEGORY
,      ABLE_BALANCE
,      ACCRUAL
,      GROSS_BALANCE
,      SUBJECT_BALANCE
,      PRETAX_BALANCE
,      SUBJECT_WHABLE
,      SUBJECT_NOT_WHABLE
,      EXCESS_BALANCE
,      TAXABLE_BALANCE
,      EXEMPT_BALANCE
,      EE_OR_ER_CONTR_BALANCE
,      CONCATENATED_SEGMENTS
FROM APPS.PAY_ELEMENT_TYPES_F_DFV;

Dependencies

[top of page]

APPS

PAY_ELEMENT_TYPES_F

PUBLIC

PAY_ELEMENT_TYPES_F_DFV