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


TABLE: HR.PAY_WC_RATES

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


PAY_WC_RATES holds the actual rates that apply for each Workers
Compensation code in a specific WC fund.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PAY_WC_RATES_PK
  1. ColumnWC_CODE
  2. ColumnFUND_ID
Indexes
Index Type Uniqueness Tablespace Column
PAY_WC_RATES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnWC_CODE
ColumnFUND_ID
PAY_WC_RATES_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PAY_WC_RATES_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnFUND_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_WC_RATES PAY_WC_RATES_FK1 TableHR_ALL_ORGANIZATION_UNITS PAY_WC_RATES BUSINESS_GROUP_ID
PAY_WC_RATES PAY_WC_RATES_FK2 TablePAY_WC_FUNDS PAY_WC_RATES FUND_ID
Columns
Name Datatype Length Mandatory Comments
WC_CODE NUMBER (15) Yes Workers Compensation code within a specific fund. This code is defined by the WC Carrier and applied to specific Jobs.
FUND_ID NUMBER (9) Yes Foreign Key to PAY_WC_FUNDS.
BUSINESS_GROUP_ID NUMBER (15) Yes System generated foreign key to HR_ORGANIZATION_UNITS.
RATE NUMBER (10) Yes Rate for the WC code for the specific fund table.
RATE2 NUMBER (10)
Rate for the second employer component for the corresponding WC code and the specific fund table.
RATE3 NUMBER (10)
Rate for the third employer component for the corresponding WC code and the specific fund table.
RATE_EE NUMBER (10)
Rate for the first employee component for the corresponding WC code and the specific fund table.
RATE_EE2 NUMBER (10)
Rate for the second employee component for the corresponding WC code and the specific fund table.
PERIOD VARCHAR2 (30)
The time period to be used for the corresponding code if the calculation methodis 'Flat Amount per period'.
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.
Query Text

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


SELECT WC_CODE
,      FUND_ID
,      BUSINESS_GROUP_ID
,      RATE
,      RATE2
,      RATE3
,      RATE_EE
,      RATE_EE2
,      PERIOD
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
FROM HR.PAY_WC_RATES;

Dependencies

[top of page]

HR.PAY_WC_RATES does not reference any database object

HR.PAY_WC_RATES is referenced by following:

SchemaHR
ViewPAY_WC_RATES#