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


TABLE: HR.PAY_US_EMP_FED_TAX_RULES_F

Object Details
Object Name: PAY_US_EMP_FED_TAX_RULES_F
Object Type: TABLE
Owner: HR
FND Design Data: TablePAY.PAY_US_EMP_FED_TAX_RULES_F
Subobject Name:
Status: VALID


PAY_US_EMP_FED_TAX_RULES_F is the DateTracked table that holds US
Federal level tax details for specific employee assignments.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PAY_US_EMP_FED_TAX_RULES_PK
  1. ColumnEMP_FED_TAX_RULE_ID
  2. ColumnEFFECTIVE_START_DATE
  3. ColumnEFFECTIVE_END_DATE
Indexes
Index Type Uniqueness Tablespace Column
PAY_US_EMP_FED_TAX_RULES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnEMP_FED_TAX_RULE_ID
ColumnEFFECTIVE_START_DATE
ColumnEFFECTIVE_END_DATE
PAY_US_EMP_FED_TAX_RULES_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_ID
PAY_US_EMP_FED_TAX_RULES_N2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSUI_STATE_CODE
PAY_US_EMP_FED_TAX_RULES_N3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_US_EMP_FED_TAX_RULES_F PAY_US_EMP_FED_TAX_RULES_FK2 TableHR_ALL_ORGANIZATION_UNITS PAY_US_EMP_FED_TAX_RULES_F BUSINESS_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
EMP_FED_TAX_RULE_ID NUMBER (9) Yes System-generated primary key column.
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
ASSIGNMENT_ID NUMBER (10) Yes Foreign key to PER_ASSIGNMENTS.
SUI_STATE_CODE VARCHAR2 (2) Yes Foreign key to PAY_STATE_RULES.
SUI_JURISDICTION_CODE VARCHAR2 (11) Yes Format XX-YYY-ZZZZ: XX - State, YYY - County, ZZZZ - City.
BUSINESS_GROUP_ID NUMBER (15) Yes Foreign key to HR_ORGANIZATION_UNITS.
ADDITIONAL_WA_AMOUNT NUMBER (11) Yes The extra W4 withholding allowance amount.
FILING_STATUS_CODE VARCHAR2 (30) Yes The W4 filing status code.
FIT_OVERRIDE_AMOUNT NUMBER (11) Yes Federal income tax override amount.
FIT_OVERRIDE_RATE NUMBER (6) Yes Federal income tax override rate (%).
WITHHOLDING_ALLOWANCES NUMBER (3) Yes W4 withholding allowance amount.
CUMULATIVE_TAXATION VARCHAR2 (30)
Cumulative taxation flag - Y if cumulative, N if not.
EIC_FILING_STATUS_CODE VARCHAR2 (30)
EIC filing status code.
FIT_ADDITIONAL_TAX NUMBER (11) Yes Federal Income Tax additional tax.
FIT_EXEMPT VARCHAR2 (30)
Federal income tax exemption flag - Y if exempt, N if not.
FUTA_TAX_EXEMPT VARCHAR2 (30)
FUTA exemption flag - Y if exempt, N if not.
MEDICARE_TAX_EXEMPT VARCHAR2 (30)
MEDICARE exemption flag - Y if exempt, N if not.
SS_TAX_EXEMPT VARCHAR2 (30)
SS exemption flag - Y if exempt, N if not.
STATUTORY_EMPLOYEE VARCHAR2 (30)
Statutory employee flag - Y if statutory employee, N if not.
W2_FILED_YEAR NUMBER (4)
The year W2 was filed.
SUPP_TAX_OVERRIDE_RATE NUMBER (6)
Supplemental override rate.
EXCESSIVE_WA_REJECT_DATE DATE

The allowances reject date.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
OBJECT_VERSION_NUMBER NUMBER (9) Yes System-generated version of row. Increments by one with each update.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE21 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE22 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE23 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE24 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE25 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE26 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE27 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE28 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE29 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE30 VARCHAR2 (150)
Descriptive flexfield column.
FED_INFORMATION_CATEGORY VARCHAR2 (30)
Developer descriptive flexfield structure definition column.
FED_INFORMATION1 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION2 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION3 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION4 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION5 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION6 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION7 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION8 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION9 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION10 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION11 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION12 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION13 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION14 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION15 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION16 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION17 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION18 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION19 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION20 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION21 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION22 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION23 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION24 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION25 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION26 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION27 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION28 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION29 VARCHAR2 (150)
Developer descriptive flexfield column.
FED_INFORMATION30 VARCHAR2 (150)
Developer descriptive flexfield column.
WAGE_EXEMPT VARCHAR2 (30)
Wage exempt flag, 'Y' if exempt.
Query Text

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


SELECT EMP_FED_TAX_RULE_ID
,      EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      ASSIGNMENT_ID
,      SUI_STATE_CODE
,      SUI_JURISDICTION_CODE
,      BUSINESS_GROUP_ID
,      ADDITIONAL_WA_AMOUNT
,      FILING_STATUS_CODE
,      FIT_OVERRIDE_AMOUNT
,      FIT_OVERRIDE_RATE
,      WITHHOLDING_ALLOWANCES
,      CUMULATIVE_TAXATION
,      EIC_FILING_STATUS_CODE
,      FIT_ADDITIONAL_TAX
,      FIT_EXEMPT
,      FUTA_TAX_EXEMPT
,      MEDICARE_TAX_EXEMPT
,      SS_TAX_EXEMPT
,      STATUTORY_EMPLOYEE
,      W2_FILED_YEAR
,      SUPP_TAX_OVERRIDE_RATE
,      EXCESSIVE_WA_REJECT_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      OBJECT_VERSION_NUMBER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      ATTRIBUTE21
,      ATTRIBUTE22
,      ATTRIBUTE23
,      ATTRIBUTE24
,      ATTRIBUTE25
,      ATTRIBUTE26
,      ATTRIBUTE27
,      ATTRIBUTE28
,      ATTRIBUTE29
,      ATTRIBUTE30
,      FED_INFORMATION_CATEGORY
,      FED_INFORMATION1
,      FED_INFORMATION2
,      FED_INFORMATION3
,      FED_INFORMATION4
,      FED_INFORMATION5
,      FED_INFORMATION6
,      FED_INFORMATION7
,      FED_INFORMATION8
,      FED_INFORMATION9
,      FED_INFORMATION10
,      FED_INFORMATION11
,      FED_INFORMATION12
,      FED_INFORMATION13
,      FED_INFORMATION14
,      FED_INFORMATION15
,      FED_INFORMATION16
,      FED_INFORMATION17
,      FED_INFORMATION18
,      FED_INFORMATION19
,      FED_INFORMATION20
,      FED_INFORMATION21
,      FED_INFORMATION22
,      FED_INFORMATION23
,      FED_INFORMATION24
,      FED_INFORMATION25
,      FED_INFORMATION26
,      FED_INFORMATION27
,      FED_INFORMATION28
,      FED_INFORMATION29
,      FED_INFORMATION30
,      WAGE_EXEMPT
FROM HR.PAY_US_EMP_FED_TAX_RULES_F;

Dependencies

[top of page]

HR.PAY_US_EMP_FED_TAX_RULES_F does not reference any database object

HR.PAY_US_EMP_FED_TAX_RULES_F is referenced by following:

SchemaHR
ViewPAY_US_EMP_FED_TAX_RULES_F#