[Home] [Help] [Dependency Information]
Object Name: | PAY_MX_ISR_TAX_FORMAT37_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LEGAL_EMPLOYER_ID | NUMBER | |||
PAYROLL_ACTION_ID | NUMBER | (9) | Yes | |
EFFECTIVE_DATE | DATE | |||
PERSON_ID | VARCHAR2 | (30) | ||
FISCAL_YEAR_REPORTING | VARCHAR2 | (240) | ||
ER_RFC_ID | VARCHAR2 | (240) | ||
ER_LEGAL_NAME | VARCHAR2 | (240) | ||
ER_LEGAL_REP_NAMES | VARCHAR2 | (240) | ||
ER_LEGAL_REP_RFC_ID | VARCHAR2 | (240) | ||
ER_LEGAL_REP_CURP | VARCHAR2 | (240) | ||
ER_TAX_SUBSIDY_PCT | VARCHAR2 | (240) | ||
PATERNAL_LAST_NAME | VARCHAR2 | (240) | ||
MATERNAL_LAST_NAME | VARCHAR2 | (240) | ||
NAMES | VARCHAR2 | (240) | ||
CURP | VARCHAR2 | (240) | ||
RFC_ID | VARCHAR2 | (240) | ||
START_MONTH | VARCHAR2 | (240) | ||
END_MONTH | VARCHAR2 | (240) | ||
SENIORITY | VARCHAR2 | (240) | ||
ANNUAL_TAX_CALC_FLAG | VARCHAR2 | (240) | ||
UNION_WORKER_FLAG | VARCHAR2 | (240) | ||
ECONOMIC_ZONE | VARCHAR2 | (240) | ||
TAX_SUBSIDY_PCT | VARCHAR2 | (240) | ||
SUBSIDY_PORTION_APPLIED | VARCHAR2 | (240) | ||
OTHER_ER_RFC1 | VARCHAR2 | (240) | ||
OTHER_ER_RFC2 | VARCHAR2 | (240) | ||
OTHER_ER_RFC3 | VARCHAR2 | (240) | ||
OTHER_ER_RFC4 | VARCHAR2 | (240) | ||
OTHER_ER_RFC5 | VARCHAR2 | (240) | ||
OTHER_ER_RFC6 | VARCHAR2 | (240) | ||
OTHER_ER_RFC7 | VARCHAR2 | (240) | ||
OTHER_ER_RFC8 | VARCHAR2 | (240) | ||
OTHER_ER_RFC9 | VARCHAR2 | (240) | ||
OTHER_ER_RFC10 | VARCHAR2 | (240) | ||
STATE_ID | VARCHAR2 | (240) | ||
RATE_1991_IND | VARCHAR2 | (240) | ||
RATE_FISCAL_YEAR_IND | VARCHAR2 | (240) | ||
TOT_EARNING_ASSI_CONCEPTS | NUMBER | |||
EMPLOYEE_STATE_TAX_WITHHELD | NUMBER | |||
TOT_EXEMPT_EARNINGS | NUMBER | |||
TOT_NON_CUMULATIVE_EARNINGS | NUMBER | |||
TOT_CUMULATIVE_EARNINGS | NUMBER | |||
ISR_CALCULATED | NUMBER | |||
ISR_CREDITABLE_SUBSIDY | NUMBER | |||
ISR_NON_CREDITABLE_SUBSIDY | NUMBER | |||
CREDITABLE_SUBSIDY_FRACTIONIII | NUMBER | |||
CREDITABLE_SUBSIDY_FRACTIONIV | NUMBER | |||
ISR_ON_CUMULATIVE_EARNINGS | NUMBER | |||
ISR_ON_NON_CUMULATIVE_EARNINGS | NUMBER | |||
TAX_ON_INCOME_FISCAL_YEAR | NUMBER | |||
ISR_TAX_WITHHELD | NUMBER | |||
RET_EARNINGS_IN_ONE_PYMNT | NUMBER | |||
RET_EARNINGS_IN_PART_PYMNT | NUMBER | |||
RET_DAILY_EARNINGS_IN_PYMNT | NUMBER | |||
RET_PERIOD_EARNINGS | NUMBER | |||
RET_EARNINGS_DAYS | NUMBER | |||
RET_EXEMPT_EARNINGS | NUMBER | |||
RET_TAXABLE_EARNINGS | NUMBER | |||
RET_CUMULATIVE_EARNINGS | NUMBER | |||
RET_NON_CUMULATIVE_EARNINGS | NUMBER | |||
ISR_WITHHELD_FOR_RET_EARNINGS | NUMBER | |||
AMENDS | NUMBER | |||
ISR_EXEMPT_FOR_AMENDS | NUMBER | |||
ISR_SUBJECT_FOR_AMENDS | NUMBER | |||
LAST_MTH_ORD_SAL | NUMBER | |||
LAST_MTH_ORD_SAL_WITHHELD | NUMBER | |||
NON_CUMULATIVE_AMENDS | NUMBER | |||
ISR_WITHHELD_FOR_AMENDS | NUMBER | |||
ASSIMILATED_EARNINGS | NUMBER | |||
ISR_WITHHELD_FOR_ASSI_EARNINGS | NUMBER | |||
STK_OPTIONS_VESTING_VALUE | NUMBER | |||
STK_OPTIONS_GRANT_PRICE | NUMBER | |||
STK_OPTIONS_CUML_INCOME | NUMBER | |||
STK_OPTIONS_TAX_WITHHELD | NUMBER | |||
ISR_EXEMPT_FOR_FIXED_EARNINGS | NUMBER | |||
ISR_SUBJECT_FOR_FIXED_EARNINGS | NUMBER | |||
ISR_EXEMPT_FOR_XMAS_BONUS | NUMBER | |||
ISR_SUBJECT_FOR_XMAS_BONUS | NUMBER | |||
ISR_EXEMPT_FOR_TRAVEL_EXP | NUMBER | |||
ISR_SUBJECT_FOR_TRAVEL_EXP | NUMBER | |||
ISR_EXEMPT_FOR_OVERTIME | NUMBER | |||
ISR_SUBJECT_FOR_OVERTIME | NUMBER | |||
ISR_EXEMPT_FOR_VAC_PREMIUM | NUMBER | |||
ISR_SUBJECT_FOR_VAC_PREMIUM | NUMBER | |||
ISR_EXEMPT_FOR_DOM_PREMIUM | NUMBER | |||
ISR_SUBJECT_FOR_DOM_PREMIUM | NUMBER | |||
ISR_EXEMPT_FOR_PROFIT_SHARING | NUMBER | |||
ISR_SUBJECT_FOR_PROFIT_SHARING | NUMBER | |||
ISR_EXEMPT_FOR_HEALTHCARE_REI | NUMBER | |||
ISR_SUBJECT_FOR_HEALTHCARE_REI | NUMBER | |||
ISR_EXEMPT_FOR_SAVINGS_FUND | NUMBER | |||
ISR_SUBJECT_FOR_SAVINGS_FUND | NUMBER | |||
ISR_EXEMPT_FOR_SAVINGS_BOX | NUMBER | |||
ISR_SUBJECT_FOR_SAVINGS_BOX | NUMBER | |||
ISR_EXEMPT_FOR_PANTRY_COUPONS | NUMBER | |||
ISR_SUBJECT_FOR_PANTRY_COUPONS | NUMBER | |||
ISR_EXEMPT_FOR_FUNERAL_AID | NUMBER | |||
ISR_SUBJECT_FOR_FUNERAL_AID | NUMBER | |||
ISR_EXEMPT_FOR_WR_PD_BY_ER | NUMBER | |||
ISR_SUBJECT_FOR_WR_PD_BY_ER | NUMBER | |||
ISR_EXEMPT_FOR_PUN_INCENTIVE | NUMBER | |||
ISR_SUBJECT_FOR_PUN_INCENTIVE | NUMBER | |||
ISR_EXEMPT_FOR_LIFE_INS_PRE | NUMBER | |||
ISR_SUBJECT_FOR_LIFE_INS_PRE | NUMBER | |||
ISR_EXEMPT_FOR_MAJOR_MED_INS | NUMBER | |||
ISR_SUBJECT_FOR_MAJOR_MED_INS | NUMBER | |||
ISR_EXEMPT_FOR_REST_COUPONS | NUMBER | |||
ISR_SUBJECT_FOR_REST_COUPONS | NUMBER | |||
ISR_EXEMPT_FOR_GAS_COUPONS | NUMBER | |||
ISR_SUBJECT_FOR_GAS_COUPONS | NUMBER | |||
ISR_EXEMPT_FOR_UNI_COUPONS | NUMBER | |||
ISR_SUBJECT_FOR_UNI_COUPONS | NUMBER | |||
ISR_EXEMPT_FOR_RENTAL_AID | NUMBER | |||
ISR_SUBJECT_FOR_RENTAL_AID | NUMBER | |||
ISR_EXEMPT_FOR_EDU_AID | NUMBER | |||
ISR_SUBJECT_FOR_EDU_AID | NUMBER | |||
ISR_EXEMPT_FOR_GLASSES_AID | NUMBER | |||
ISR_SUBJECT_FOR_GLASSES_AID | NUMBER | |||
ISR_EXEMPT_FOR_TRANS_AID | NUMBER | |||
ISR_SUBJECT_FOR_TRANS_AID | NUMBER | |||
ISR_EXEMPT_FOR_UNION_PD_BY_ER | NUMBER | |||
ISR_SUBJECT_FOR_UNION_PD_BY_ER | NUMBER | |||
ISR_EXEMPT_FOR_DISAB_SUBSIDY | NUMBER | |||
ISR_SUBJECT_FOR_DISAB_SUBSIDY | NUMBER | |||
ISR_EXEMPT_FOR_CHILD_SCHOLAR | NUMBER | |||
ISR_SUBJECT_FOR_CHILD_SCHOLAR | NUMBER | |||
PREV_ER_EARNINGS | VARCHAR2 | (240) | ||
PREV_ER_EXEMPT_EARNINGS | VARCHAR2 | (240) | ||
ISR_EXEMPT_OTHER_INCOME | NUMBER | |||
ISR_SUBJECT_OTHER_INCOME | NUMBER | |||
TOTAL_SUBJECT_EARNINGS | NUMBER | |||
TOTAL_EXEMPT_EARNINGS | NUMBER | |||
TAX_WITHHELD_IN_FISCAL_YEAR | NUMBER | |||
PREV_ER_ISR_WITHHELD | VARCHAR2 | (240) | ||
CURRENT_FY_ARREARS | NUMBER | |||
PREV_FY_ARREARS | NUMBER | |||
CREDIT_TO_SALARY | NUMBER | |||
CREDIT_TO_SALARY_PAID | NUMBER | |||
SOCIAL_FORESIGHT_EARNINGS | NUMBER | |||
ISR_EXEMPT_FOR_SOC_FORESIGHT | NUMBER | |||
AID_FOR_PANTRY_AND_FOOD | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT LEGAL_EMPLOYER_ID
, PAYROLL_ACTION_ID
, EFFECTIVE_DATE
, PERSON_ID
, FISCAL_YEAR_REPORTING
, ER_RFC_ID
, ER_LEGAL_NAME
, ER_LEGAL_REP_NAMES
, ER_LEGAL_REP_RFC_ID
, ER_LEGAL_REP_CURP
, ER_TAX_SUBSIDY_PCT
, PATERNAL_LAST_NAME
, MATERNAL_LAST_NAME
, NAMES
, CURP
, RFC_ID
, START_MONTH
, END_MONTH
, SENIORITY
, ANNUAL_TAX_CALC_FLAG
, UNION_WORKER_FLAG
, ECONOMIC_ZONE
, TAX_SUBSIDY_PCT
, SUBSIDY_PORTION_APPLIED
, OTHER_ER_RFC1
, OTHER_ER_RFC2
, OTHER_ER_RFC3
, OTHER_ER_RFC4
, OTHER_ER_RFC5
, OTHER_ER_RFC6
, OTHER_ER_RFC7
, OTHER_ER_RFC8
, OTHER_ER_RFC9
, OTHER_ER_RFC10
, STATE_ID
, RATE_1991_IND
, RATE_FISCAL_YEAR_IND
, TOT_EARNING_ASSI_CONCEPTS
, EMPLOYEE_STATE_TAX_WITHHELD
, TOT_EXEMPT_EARNINGS
, TOT_NON_CUMULATIVE_EARNINGS
, TOT_CUMULATIVE_EARNINGS
, ISR_CALCULATED
, ISR_CREDITABLE_SUBSIDY
, ISR_NON_CREDITABLE_SUBSIDY
, CREDITABLE_SUBSIDY_FRACTIONIII
, CREDITABLE_SUBSIDY_FRACTIONIV
, ISR_ON_CUMULATIVE_EARNINGS
, ISR_ON_NON_CUMULATIVE_EARNINGS
, TAX_ON_INCOME_FISCAL_YEAR
, ISR_TAX_WITHHELD
, RET_EARNINGS_IN_ONE_PYMNT
, RET_EARNINGS_IN_PART_PYMNT
, RET_DAILY_EARNINGS_IN_PYMNT
, RET_PERIOD_EARNINGS
, RET_EARNINGS_DAYS
, RET_EXEMPT_EARNINGS
, RET_TAXABLE_EARNINGS
, RET_CUMULATIVE_EARNINGS
, RET_NON_CUMULATIVE_EARNINGS
, ISR_WITHHELD_FOR_RET_EARNINGS
, AMENDS
, ISR_EXEMPT_FOR_AMENDS
, ISR_SUBJECT_FOR_AMENDS
, LAST_MTH_ORD_SAL
, LAST_MTH_ORD_SAL_WITHHELD
, NON_CUMULATIVE_AMENDS
, ISR_WITHHELD_FOR_AMENDS
, ASSIMILATED_EARNINGS
, ISR_WITHHELD_FOR_ASSI_EARNINGS
, STK_OPTIONS_VESTING_VALUE
, STK_OPTIONS_GRANT_PRICE
, STK_OPTIONS_CUML_INCOME
, STK_OPTIONS_TAX_WITHHELD
, ISR_EXEMPT_FOR_FIXED_EARNINGS
, ISR_SUBJECT_FOR_FIXED_EARNINGS
, ISR_EXEMPT_FOR_XMAS_BONUS
, ISR_SUBJECT_FOR_XMAS_BONUS
, ISR_EXEMPT_FOR_TRAVEL_EXP
, ISR_SUBJECT_FOR_TRAVEL_EXP
, ISR_EXEMPT_FOR_OVERTIME
, ISR_SUBJECT_FOR_OVERTIME
, ISR_EXEMPT_FOR_VAC_PREMIUM
, ISR_SUBJECT_FOR_VAC_PREMIUM
, ISR_EXEMPT_FOR_DOM_PREMIUM
, ISR_SUBJECT_FOR_DOM_PREMIUM
, ISR_EXEMPT_FOR_PROFIT_SHARING
, ISR_SUBJECT_FOR_PROFIT_SHARING
, ISR_EXEMPT_FOR_HEALTHCARE_REI
, ISR_SUBJECT_FOR_HEALTHCARE_REI
, ISR_EXEMPT_FOR_SAVINGS_FUND
, ISR_SUBJECT_FOR_SAVINGS_FUND
, ISR_EXEMPT_FOR_SAVINGS_BOX
, ISR_SUBJECT_FOR_SAVINGS_BOX
, ISR_EXEMPT_FOR_PANTRY_COUPONS
, ISR_SUBJECT_FOR_PANTRY_COUPONS
, ISR_EXEMPT_FOR_FUNERAL_AID
, ISR_SUBJECT_FOR_FUNERAL_AID
, ISR_EXEMPT_FOR_WR_PD_BY_ER
, ISR_SUBJECT_FOR_WR_PD_BY_ER
, ISR_EXEMPT_FOR_PUN_INCENTIVE
, ISR_SUBJECT_FOR_PUN_INCENTIVE
, ISR_EXEMPT_FOR_LIFE_INS_PRE
, ISR_SUBJECT_FOR_LIFE_INS_PRE
, ISR_EXEMPT_FOR_MAJOR_MED_INS
, ISR_SUBJECT_FOR_MAJOR_MED_INS
, ISR_EXEMPT_FOR_REST_COUPONS
, ISR_SUBJECT_FOR_REST_COUPONS
, ISR_EXEMPT_FOR_GAS_COUPONS
, ISR_SUBJECT_FOR_GAS_COUPONS
, ISR_EXEMPT_FOR_UNI_COUPONS
, ISR_SUBJECT_FOR_UNI_COUPONS
, ISR_EXEMPT_FOR_RENTAL_AID
, ISR_SUBJECT_FOR_RENTAL_AID
, ISR_EXEMPT_FOR_EDU_AID
, ISR_SUBJECT_FOR_EDU_AID
, ISR_EXEMPT_FOR_GLASSES_AID
, ISR_SUBJECT_FOR_GLASSES_AID
, ISR_EXEMPT_FOR_TRANS_AID
, ISR_SUBJECT_FOR_TRANS_AID
, ISR_EXEMPT_FOR_UNION_PD_BY_ER
, ISR_SUBJECT_FOR_UNION_PD_BY_ER
, ISR_EXEMPT_FOR_DISAB_SUBSIDY
, ISR_SUBJECT_FOR_DISAB_SUBSIDY
, ISR_EXEMPT_FOR_CHILD_SCHOLAR
, ISR_SUBJECT_FOR_CHILD_SCHOLAR
, PREV_ER_EARNINGS
, PREV_ER_EXEMPT_EARNINGS
, ISR_EXEMPT_OTHER_INCOME
, ISR_SUBJECT_OTHER_INCOME
, TOTAL_SUBJECT_EARNINGS
, TOTAL_EXEMPT_EARNINGS
, TAX_WITHHELD_IN_FISCAL_YEAR
, PREV_ER_ISR_WITHHELD
, CURRENT_FY_ARREARS
, PREV_FY_ARREARS
, CREDIT_TO_SALARY
, CREDIT_TO_SALARY_PAID
, SOCIAL_FORESIGHT_EARNINGS
, ISR_EXEMPT_FOR_SOC_FORESIGHT
, AID_FOR_PANTRY_AND_FOOD
FROM APPS.PAY_MX_ISR_TAX_FORMAT37_V;
|
|
|