eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PAY_MX_ISR_TAX_FORMAT37_V

Object Details

Object Name:	PAY_MX_ISR_TAX_FORMAT37_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory
LEGAL_EMPLOYER_ID	NUMBER
PAYROLL_ACTION_ID	NUMBER	(9)	Yes
ASSIGNMENT_ACTION_ID	NUMBER	(15)	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)
VOLUNTARY_CONTRIBUTIONS_EE	NUMBER
VOLUNTARY_CONTRIBUTIONS_ER	NUMBER
VOLUNTARY_CONTRIBUTIONS_TOTAL	NUMBER
TOT_DED_VOL_CONTRIBUTION	NUMBER
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
ISR_SUBSIDY_FOR_EMP	NUMBER
ISR_SUBSIDY_FOR_EMP_PAID	NUMBER
ISR_TAX_TO_CHARGE	NUMBER

Query Text

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


SELECT LEGAL_EMPLOYER_ID
,      PAYROLL_ACTION_ID
,      ASSIGNMENT_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
,      VOLUNTARY_CONTRIBUTIONS_EE
,      VOLUNTARY_CONTRIBUTIONS_ER
,      VOLUNTARY_CONTRIBUTIONS_TOTAL
,      TOT_DED_VOL_CONTRIBUTION
,      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
,      ISR_SUBSIDY_FOR_EMP
,      ISR_SUBSIDY_FOR_EMP_PAID
,      ISR_TAX_TO_CHARGE
FROM APPS.PAY_MX_ISR_TAX_FORMAT37_V;