[Home] [Help] [Dependency Information]
Object Name: | PAY_ELEMENT_TYPES_F_DFV |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
CONTEXT_VALUE | VARCHAR2 | (30) | ||
ALLOWANCE | VARCHAR2 | (150) | ||
PRIMARY_BALANCE | VARCHAR2 | (150) | ||
DISPLAY_SOE_LEAVE_TAKEN | VARCHAR2 | (150) | ||
TERM_ELIGIBILITY_YEARS | VARCHAR2 | (150) | ||
UNION_FEES_PRIMARY_BALANCE | VARCHAR2 | (150) | ||
CATEGORY | VARCHAR2 | (150) | ||
HOURS_BALANCE | VARCHAR2 | (150) | ||
TAX_PROCESSING_TYPE | VARCHAR2 | (150) | ||
ROE_ALLOCATION_BY | VARCHAR2 | (150) | ||
YEAR_END_FORM | VARCHAR2 | (150) | ||
FEDERAL_FOOTNOTE | VARCHAR2 | (150) | ||
PROVINCIAL_FOOTNOTE | VARCHAR2 | (150) | ||
REGULAR_EARNINGS_ADJUSTMENT | VARCHAR2 | (150) | ||
LIABILITY | VARCHAR2 | (150) | ||
REGISTRATION_NUMBER | VARCHAR2 | (150) | ||
PRIORITY_CLASSIFICATION | VARCHAR2 | (150) | ||
INSUFFICIENT_FUNDS_TYPE | VARCHAR2 | (150) | ||
PROCESSING_RUN_TYPE | VARCHAR2 | (150) | ||
PERIOD_TYPE | VARCHAR2 | (150) | ||
ACCRUED_BALANCE | VARCHAR2 | (150) | ||
ARREARS_BALANCE | VARCHAR2 | (150) | ||
NOT_TAKEN_BALANCE | VARCHAR2 | (150) | ||
ADDITIONAL_AMOUNT_BALANCE | VARCHAR2 | (150) | ||
REPLACEMENT_AMOUNT_BALANCE | VARCHAR2 | (150) | ||
FEE_BALANCE | VARCHAR2 | (150) | ||
BENEFIT_GIVEN | VARCHAR2 | (150) | ||
BENEFIT_TYPE | VARCHAR2 | (150) | ||
GROUP_NAME | VARCHAR2 | (150) | ||
BASE_UNITS | VARCHAR2 | (150) | ||
EARLIEST_START_OF_ASPPP | VARCHAR2 | (150) | ||
QUALIFYING_WEEK | VARCHAR2 | (150) | ||
CONTINUOUS_EMPLOYMENT_PERIOD | VARCHAR2 | (150) | ||
MAXIMUM_ASPPP_WEEK | VARCHAR2 | (150) | ||
MAXIMUM_ASPPP_WEEK_MUM_DEATH | VARCHAR2 | (150) | ||
ASPP_RATE | VARCHAR2 | (150) | ||
RECOVERY_RATE | VARCHAR2 | (150) | ||
STANDARD_RATE | VARCHAR2 | (150) | ||
LATEST_END_OF_APL | VARCHAR2 | (150) | ||
MINIMUM_APL_WEEK | VARCHAR2 | (150) | ||
MAXIMUM_APL_WEEK | VARCHAR2 | (150) | ||
MAXIMUM_APL_WEEK_MOTHER_DEATH | VARCHAR2 | (150) | ||
EARLIEST_START_ASPPP_MUM_DEATH | VARCHAR2 | (150) | ||
ASPP_NOTICE_REQUIREMENT | VARCHAR2 | (150) | ||
ASPP_NOTICE_REQUIREMENT_CHANGE | VARCHAR2 | (150) | ||
DISRUPTED_PLACEMENT_WEEK | VARCHAR2 | (150) | ||
DEATH_OF_CHILD_WEEK | VARCHAR2 | (150) | ||
EARLIEST_START_OF_APP | VARCHAR2 | (150) | ||
MAXIMUM_APP_WEEKS | VARCHAR2 | (150) | ||
SAP_RATE | VARCHAR2 | (150) | ||
DISRUPTED_PLACEMENT_WEEKS | VARCHAR2 | (150) | ||
EARLIEST_START_OF_MPP | VARCHAR2 | (150) | ||
MAXIMUM_MPP_WEEKS | VARCHAR2 | (150) | ||
COMPULSORY_LEAVE_WEEKS | VARCHAR2 | (150) | ||
MPP_NOTICE_REQUIREMENT | VARCHAR2 | (150) | ||
NOTICE_OF_BIRTH_REQUIREMENT | VARCHAR2 | (150) | ||
EARLIEST_SMP_EVIDENCE | VARCHAR2 | (150) | ||
HIGHER_SMP_RATE | VARCHAR2 | (150) | ||
LOWER_SMP_RATE | VARCHAR2 | (150) | ||
LATEST_SMP_EVIDENCE | VARCHAR2 | (150) | ||
EXTENDED_SMP_EVIDENCE | VARCHAR2 | (150) | ||
WEEKS_AT_HIGHER_RATE | VARCHAR2 | (150) | ||
STILLBIRTH_THRESHOLD_WEEK | VARCHAR2 | (150) | ||
STANDARD_SMP_RATE | VARCHAR2 | (150) | ||
EARLIEST_START_OF_PPP | VARCHAR2 | (150) | ||
MAXIMUM_PPP_WEEK | VARCHAR2 | (150) | ||
SPP_RATE | VARCHAR2 | (150) | ||
LATEST_END_OF_PPP | VARCHAR2 | (150) | ||
MAXIMUM_PPP_WEEKS | VARCHAR2 | (150) | ||
MAXIMUM_SSP_PERIOD | VARCHAR2 | (150) | ||
MAXIMUM_AGE | VARCHAR2 | (150) | ||
LINKING_PERIOD_DAYS | VARCHAR2 | (150) | ||
WAITING_DAYS | VARCHAR2 | (150) | ||
PIW_THRESHOLD | VARCHAR2 | (150) | ||
MAXIMUM_LINKED_PIW_YEARS | VARCHAR2 | (150) | ||
PERCENTAGE_THRESHOLD | VARCHAR2 | (150) | ||
ALLOWANCE_NAME | VARCHAR2 | (150) | ||
ALLOWANCE_CATEGORY | VARCHAR2 | (150) | ||
EXEMPTION_AMOUNT | VARCHAR2 | (150) | ||
NATURE_OF_EXPENSE | VARCHAR2 | (150) | ||
PERQUISITE_NAME | VARCHAR2 | (150) | ||
TAXABLE | VARCHAR2 | (150) | ||
INCLUDES_REST_DAYS | VARCHAR2 | (150) | ||
EXPENSE_TYPE | VARCHAR2 | (150) | ||
TAX_CATEGORY | VARCHAR2 | (150) | ||
INCLUDE_IN_OT_BASE | VARCHAR2 | (150) | ||
FLSA_HOURS | VARCHAR2 | (150) | ||
SPECIAL_INPUTS_ELEMENT | VARCHAR2 | (150) | ||
SPECIAL_FEATURES_ELEMENT | VARCHAR2 | (150) | ||
REDUCE_REGULAR | VARCHAR2 | (150) | ||
CALCULATION_TYPE | VARCHAR2 | (150) | ||
SUPP_TAX_CATEGORY | VARCHAR2 | (150) | ||
EARNINGS | VARCHAR2 | (150) | ||
OVERRIDE_REGULAR | VARCHAR2 | (150) | ||
VERIFICATION_ELEMENT | VARCHAR2 | (150) | ||
JURISDICTION | VARCHAR2 | (150) | ||
BENEFITS_CARRIER | VARCHAR2 | (150) | ||
PARTIAL_EE_CONTRIBUTIONS | VARCHAR2 | (150) | ||
UPGRADE_STATUS | VARCHAR2 | (150) | ||
PAYROLL_TABLE | VARCHAR2 | (150) | ||
ROW_TYPE | VARCHAR2 | (150) | ||
PAYMIX_CATEGORY | VARCHAR2 | (150) | ||
TOWARD_BOND_PURCHASE | VARCHAR2 | (150) | ||
CALCULATION_ELEMENT | VARCHAR2 | (150) | ||
VOL_DEDNS_AT_WRIT | VARCHAR2 | (150) | ||
PAYMENT_CATEGORY | VARCHAR2 | (150) | ||
ABLE_BALANCE | VARCHAR2 | (150) | ||
ACCRUAL | VARCHAR2 | (150) | ||
GROSS_BALANCE | VARCHAR2 | (150) | ||
SUBJECT_BALANCE | VARCHAR2 | (150) | ||
PRETAX_BALANCE | VARCHAR2 | (150) | ||
SUBJECT_WHABLE | VARCHAR2 | (150) | ||
SUBJECT_NOT_WHABLE | VARCHAR2 | (150) | ||
EXCESS_BALANCE | VARCHAR2 | (150) | ||
TAXABLE_BALANCE | VARCHAR2 | (150) | ||
EXEMPT_BALANCE | VARCHAR2 | (150) | ||
EE_OR_ER_CONTR_BALANCE | VARCHAR2 | (150) | ||
ACCRUALS_BALANCE | VARCHAR2 | (150) | ||
CONCATENATED_SEGMENTS | VARCHAR2 | (3050) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, CONTEXT_VALUE
, ALLOWANCE
, PRIMARY_BALANCE
, DISPLAY_SOE_LEAVE_TAKEN
, 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_ASPPP
, QUALIFYING_WEEK
, CONTINUOUS_EMPLOYMENT_PERIOD
, MAXIMUM_ASPPP_WEEK
, MAXIMUM_ASPPP_WEEK_MUM_DEATH
, ASPP_RATE
, RECOVERY_RATE
, STANDARD_RATE
, LATEST_END_OF_APL
, MINIMUM_APL_WEEK
, MAXIMUM_APL_WEEK
, MAXIMUM_APL_WEEK_MOTHER_DEATH
, EARLIEST_START_ASPPP_MUM_DEATH
, ASPP_NOTICE_REQUIREMENT
, ASPP_NOTICE_REQUIREMENT_CHANGE
, DISRUPTED_PLACEMENT_WEEK
, DEATH_OF_CHILD_WEEK
, EARLIEST_START_OF_APP
, MAXIMUM_APP_WEEKS
, SAP_RATE
, DISRUPTED_PLACEMENT_WEEKS
, EARLIEST_START_OF_MPP
, 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
, UPGRADE_STATUS
, 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
, ACCRUALS_BALANCE
, CONCATENATED_SEGMENTS
FROM APPS.PAY_ELEMENT_TYPES_F_DFV;
APPS.PAY_ELEMENT_TYPES_F_DFV is not referenced by any database object
|
|
|