[Home] [Help] [Dependency Information]
Object Name: | PAY_WC_FUNDS |
---|---|
Object Type: | TABLE |
Owner: | HR |
FND Design Data: | PAY.PAY_WC_FUNDS |
Subobject Name: | |
Status: | VALID |
PAY_WC_FUNDS holds definitions of the Workers Compensation fund tables
offered by specific carriers for specific states. Fund tables may be
defined for each state, or for specific locations in each state.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
PAY_WC_FUNDS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | FUND_ID |
PAY_WC_FUNDS_U50 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CARRIER_ID
STATE_CODE LOCATION_ID |
SYS_IL0000043490C00014$$ | LOB | UNIQUE | APPS_TS_TX_DATA | |
PAY_WC_FUNDS_FK1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | BUSINESS_GROUP_ID |
PAY_WC_FUNDS_FK2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | CARRIER_ID |
PAY_WC_FUNDS_FK3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | LOCATION_ID |
PAY_WC_FUNDS_FK4 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | STATE_CODE |
Table | |
Foreign Table | Foreign Key Column | PAY_WC_FUNDS | HR_ALL_ORGANIZATION_UNITS | PAY_WC_FUNDS BUSINESS_GROUP_ID | PAY_WC_FUNDS | HR_ALL_ORGANIZATION_UNITS | PAY_WC_FUNDS CARRIER_ID | PAY_WC_FUNDS | HR_LOCATIONS_ALL | PAY_WC_FUNDS LOCATION_ID | PAY_WC_RATES | PAY_WC_FUNDS | PAY_WC_RATES FUND_ID |
---|
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
FUND_ID | NUMBER | (9) | Yes | System generated primary key for WC Funds. |
BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign key to HR_ORGANIZATION_UNITS. |
CARRIER_ID | NUMBER | (15) | Yes | Foreign Key to HR_ORGANIZATION_UNITS. |
LOCATION_ID | NUMBER | (15) | Foreign key to HR_LOCATIONS. | |
STATE_CODE | VARCHAR2 | (2) | Yes | Foreign key to PAY_STATE_RULES. |
CALCULATION_METHOD | VARCHAR2 | (100) | Calculation method for the first employer and employee components of | |
CALCULATION_METHOD2 | VARCHAR2 | (100) | Calculation method for the second employer and employee components of | |
CALCULATION_METHOD3 | VARCHAR2 | (100) | Calculation method for the third employer component ofworkers compensation. | |
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. | ||
COMMENTS | CLOB | (4000) | General remark regarding this fund. |
Cut, paste (and edit) the following text to query this object:
SELECT FUND_ID
, BUSINESS_GROUP_ID
, CARRIER_ID
, LOCATION_ID
, STATE_CODE
, CALCULATION_METHOD
, CALCULATION_METHOD2
, CALCULATION_METHOD3
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, COMMENTS
FROM HR.PAY_WC_FUNDS;
HR.PAY_WC_FUNDS does not reference any database object
HR.PAY_WC_FUNDS is referenced by following:
|
|
|