[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PAY_CA_PMED_ACCOUNTS |
|---|---|
| Object Type: | TABLE |
| Owner: | HR |
| FND Design Data: |  PAY.PAY_CA_PMED_ACCOUNTS
|
| Subobject Name: | |
| Status: | VALID |
This table stores the PMED account number of the Organization
of type (Provincial Medical Carrier) for Canada. All wages subject
to the Provincial Medical (PMED) taxes are captured and reported
on this account number. There is an account number per Provincial
Authority (Provincial Medical Carrier).
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORGANIZATION_ID | NUMBER | (15) | Yes | Organization Id. Foreign Key to HR_ALL_ORGANIZATION_UNITS |
| SOURCE_ID | NUMBER | (9) | Yes | Internal unique code for Provincial Medical account number. This is generated from PAY_WCI_RATES_S. |
| ACCOUNT_NUMBER | VARCHAR2 | (30) | Yes | Provincial Medical account number. |
| ENABLED | VARCHAR2 | (1) | Yes | Enabled flag. |
| DESCRIPTION | VARCHAR2 | (120) | Description of account number | |
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Business Group Identifier. Foreign Key to HR_ALL_ORGANIZATION_UNITS |
| 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 column. | |
| ATTRIBUTE22 | VARCHAR2 | (150) | Descriptive Flexfield column. | |
| ATTRIBUTE23 | VARCHAR2 | (150) | Descriptive Flexfield column. | |
| ATTRIBUTE24 | VARCHAR2 | (150) | Descriptive Flexfield column. | |
| ATTRIBUTE25 | VARCHAR2 | (150) | Descriptive Flexfield column. | |
| 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. | |
| CREATED_BY | NUMBER | (30) | 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. | ||
| LAST_UPDATED_BY | NUMBER | (30) | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
| LAST_UPDATE_LOGIN | NUMBER | (30) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
| LAST_UPDATE_DATE | DATE | Standard Who column - date when a user last updated this row. | ||
| OBJECT_VERSION_NUMBER | NUMBER | (30) | Yes | Object Version Number |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, SOURCE_ID
, ACCOUNT_NUMBER
, ENABLED
, DESCRIPTION
, BUSINESS_GROUP_ID
, 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
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, OBJECT_VERSION_NUMBER
FROM HR.PAY_CA_PMED_ACCOUNTS;
HR.PAY_CA_PMED_ACCOUNTS does not reference any database object
HR.PAY_CA_PMED_ACCOUNTS is referenced by following:
HR
PAY_CA_PMED_ACCOUNTS#
|
|
|
|