[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PSP_PAYROLL_CONTROLS |
|---|---|
| Object Type: | TABLE |
| Owner: | PSP |
| FND Design Data: |  PSP.PSP_PAYROLL_CONTROLS
|
| Subobject Name: | |
| Status: | VALID |
PSP_PAYROLL_CONTROLS contains common information and statuses for all
the payroll transactions imported from Oracle Payroll or non-Oracle payroll transactions.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PSP_PAYROLL_CONTROLS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 PAYROLL_CONTROL_ID
|
| PSP_PAYROLL_CONTROLS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PAYROLL_ID
|
| PSP_PAYROLL_CONTROLS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
BATCH_NAME
|
| PSP_PAYROLL_CONTROLS_N5 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TIME_PERIOD_ID
CURRENCY_CODE
|
| PSP_PAYROLL_CONTROLS_U2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
SOURCE_TYPE
PAYROLL_SOURCE_CODE
TIME_PERIOD_ID
BATCH_NAME
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PAYROLL_CONTROL_ID | NUMBER | (10) | Yes | System-generated primary key for Payroll controls |
| PAYROLL_ACTION_ID | NUMBER | (9) | Yes | Foreign key to PAY_PAYROLL_ACTIONS |
| PAYROLL_ID | NUMBER | (9) | Yes | Foreign key to PAY_PAYROLLS_F |
| NUMBER_OF_CR | NUMBER | Total number of credit transations for specified payroll | ||
| NUMBER_OF_DR | NUMBER | Total number of debit transactions for specified payroll | ||
| TOTAL_DR_AMOUNT | NUMBER | Total debit amount for specified payroll sublines | ||
| TOTAL_CR_AMOUNT | NUMBER | Total credit amount for specified payroll | ||
| SUBLINES_DR_AMOUNT | NUMBER | Total sublines debit amount | ||
| SUBLINES_CR_AMOUNT | NUMBER | Total sublines credit amount | ||
| DIST_DR_AMOUNT | NUMBER | Total debit amount distributed for specified payroll | ||
| DIST_CR_AMOUNT | NUMBER | Total credit amount distributed for specified payroll | ||
| OGM_DR_AMOUNT | NUMBER | Total debit amount transferred to Grants Accounting for specified payroll | ||
| OGM_CR_AMOUNT | NUMBER | Total credit amount transferred to Grants Accounting for specified payroll | ||
| GL_DR_AMOUNT | NUMBER | Total debit amount transferred to General Ledger for specified payroll | ||
| GL_CR_AMOUNT | NUMBER | Total credit amount transferred to General Ledger for specified payroll | ||
| PAYROLL_SOURCE_CODE | VARCHAR2 | (30) | Yes | User-defined payroll source code |
| RUN_ID | NUMBER | (10) | Summarize and Transfer process identifier | |
| TIME_PERIOD_ID | NUMBER | (15) | Yes | Foreign key to PER_TIME_PERIODS |
| BATCH_NAME | VARCHAR2 | (30) | User-defined batch name for Non-Oracle Payroll transactions. NULL for Oracle Payroll transactions. Adjustment batch name for adjustment transactions. | |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Foreign key to GL_SETS_OF_BOOKS |
| SOURCE_TYPE | VARCHAR2 | (1) | Yes | Predefined source types. Values are O for Oracle, N for Non-Oracle, P for Pregenerated, E for Encumbrance, and A for Adjustment. |
| PHASE | VARCHAR2 | (30) | Status indicators used by Summarize and Transfer process for recovery | |
| STATUS_CODE | VARCHAR2 | (1) | Yes | Status of the control batch. Values are C for Created, N for New, P for Processed and Transferred, and I for In-process Error. |
| GL_POSTING_OVERRIDE_DATE | DATE | General Ledger override date | ||
| GMS_POSTING_OVERRIDE_DATE | DATE | For future use | ||
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign key to HR_ALL_ORGANIZATION_UNITS |
| GL_PHASE | VARCHAR2 | (30) | Internal statuses used by the Summarize and Transfer processes to keep track of the phase | |
| GMS_PHASE | VARCHAR2 | (30) | Internal statuses used by the Summarize and Transfer processes to keep track of the phase | |
| ADJ_SUM_BATCH_NAME | VARCHAR2 | (30) | Summary Batch name for adjustments. | |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard Who column |
| ARCHIVE_FLAG | VARCHAR2 | (1) | Flag to indicate whether data is archived. Null by default and Y if archived | |
| CURRENCY_CODE | VARCHAR2 | (15) | Currency Code | |
| EXCHANGE_RATE_TYPE | VARCHAR2 | (30) | Exchange Rate Type | |
| CDL_PAYROLL_ACTION_ID | NUMBER | (9) | Corresponding CDL payroll action id | |
| PARENT_PAYROLL_CONTROL_ID | NUMBER | (15) | Parent Payroll Control id |
Cut, paste (and edit) the following text to query this object:
SELECT PAYROLL_CONTROL_ID
, PAYROLL_ACTION_ID
, PAYROLL_ID
, NUMBER_OF_CR
, NUMBER_OF_DR
, TOTAL_DR_AMOUNT
, TOTAL_CR_AMOUNT
, SUBLINES_DR_AMOUNT
, SUBLINES_CR_AMOUNT
, DIST_DR_AMOUNT
, DIST_CR_AMOUNT
, OGM_DR_AMOUNT
, OGM_CR_AMOUNT
, GL_DR_AMOUNT
, GL_CR_AMOUNT
, PAYROLL_SOURCE_CODE
, RUN_ID
, TIME_PERIOD_ID
, BATCH_NAME
, SET_OF_BOOKS_ID
, SOURCE_TYPE
, PHASE
, STATUS_CODE
, GL_POSTING_OVERRIDE_DATE
, GMS_POSTING_OVERRIDE_DATE
, BUSINESS_GROUP_ID
, GL_PHASE
, GMS_PHASE
, ADJ_SUM_BATCH_NAME
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, ARCHIVE_FLAG
, CURRENCY_CODE
, EXCHANGE_RATE_TYPE
, CDL_PAYROLL_ACTION_ID
, PARENT_PAYROLL_CONTROL_ID
FROM PSP.PSP_PAYROLL_CONTROLS;
PSP.PSP_PAYROLL_CONTROLS does not reference any database object
PSP.PSP_PAYROLL_CONTROLS is referenced by following:
PSP
PSP_PAYROLL_CONTROLS#
|
|
|
|