[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | PSP_ENC_CONTROLS |
|---|---|
| Object Type: | TABLE |
| Owner: | PSP |
| FND Design Data: |  PSP.PSP_ENC_CONTROLS
|
| Subobject Name: | |
| Status: | VALID |
PSP_ENC_CONTROLS stores one record for each time period batch.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| PSP_ENC_CONTROLS_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 ENC_CONTROL_ID
|
| PSP_ENC_CONTROLS_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
PAYROLL_ACTION_ID
ENC_CONTROL_ID
|
| PSP_ENC_CONTROLS_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
TIME_PERIOD_ID
PAYROLL_ID
BUSINESS_GROUP_ID
|
| PSP_ENC_CONTROLS_N2 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
PAYROLL_ACTION_ID
ACTION_CODE
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ENC_CONTROL_ID | NUMBER | (9) | Yes | System-generated primary key for encumbrance control identifier |
| PAYROLL_ID | NUMBER | (9) | Yes | Foreign key to PAY_PAYROLLS_F |
| SET_OF_BOOKS_ID | NUMBER | (15) | Yes | Foreign key to GL_SETS_OF_BOOKS |
| TIME_PERIOD_ID | NUMBER | (15) | Yes | Foreign key to PER_TIME_PERIODS. Time period in which EFFECTIVE_DATE falls. |
| GL_ENC_PERIOD_EXT_VALUE | VARCHAR2 | (1) | Extension beyond default encumbrance period for General Ledger | |
| OGM_ENC_PERIOD_EXT_VALUE | VARCHAR2 | (1) | Extension beyond default encumbrance period for Grants Accounting | |
| ENCUMBRANCE_DATE | DATE | Yes | Encumbrance date | |
| CI_SUMMARIZATION_OPTION | VARCHAR2 | (1) | Charging instruction base summarization option | |
| TIME_SUMMARIZATION_OPTION | VARCHAR2 | (1) | Time-based summarization option | |
| NUMBER_OF_DR | NUMBER | Total number of debit transactions for this batch | ||
| NUMBER_OF_CR | NUMBER | Total number of credit transactions for this batch | ||
| TOTAL_DR_AMOUNT | NUMBER | Total debit amount for this batch | ||
| TOTAL_CR_AMOUNT | NUMBER | Total credit amount for this batch | ||
| GL_DR_AMOUNT | NUMBER | Total debit amount transferred to General Ledger | ||
| GL_CR_AMOUNT | NUMBER | Total credit amount transferred to General Ledger | ||
| OGM_DR_AMOUNT | NUMBER | Total debit amount transferred to Grants Accounting | ||
| OGM_CR_AMOUNT | NUMBER | Total credit amount transferred to Grants Accounting | ||
| ACTION_CODE | VARCHAR2 | (2) | Yes | Status of encumbrance process. N indicates new, P indicates summarized lines and L indicates liquidated lines. |
| 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 |
| CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
| CREATION_DATE | DATE | Yes | Standard Who column | |
| RUN_ID | NUMBER | (10) | Summarize and Transfer process identifier | |
| BATCH_NAME | VARCHAR2 | (30) | Yes | User defined batch name |
| SUMM_GL_DR_AMOUNT | NUMBER | Summarization of General Ledger debit amount | ||
| SUMM_GL_CR_AMOUNT | NUMBER | Summarization of General Ledger credit amount | ||
| SUMM_OGM_DR_AMOUNT | NUMBER | Summarization of Grants Accounting debit amount | ||
| SUMM_OGM_CR_AMOUNT | NUMBER | Summarization of Grants Accounting credit amount | ||
| BUSINESS_GROUP_ID | NUMBER | (15) | Yes | Foreign key to HR_ALL_ORGANIZATION_UNITS |
| ACTION_TYPE | VARCHAR2 | (1) | Yes | Type of Encumbrance lines. N indicates New and U indicates Update. |
| GL_PHASE | VARCHAR2 | (30) | Used by the Encumbrance processes to keep track of the phase | |
| GMS_PHASE | VARCHAR2 | (30) | Used by the Encumbrance processes to keep track of the phase | |
| ARCHIVE_FLAG | VARCHAR2 | (1) | Flag to indicate whether data is archived. Null by default and Y if archived | |
| LIQUIDATE_REQUEST_ID | NUMBER | (15) | Liquidate Request Id | |
| PAYROLL_ACTION_ID | NUMBER | Payroll Action Id | ||
| UOM | VARCHAR2 | (1) | Unit of Measure |
Cut, paste (and edit) the following text to query this object:
SELECT ENC_CONTROL_ID
, PAYROLL_ID
, SET_OF_BOOKS_ID
, TIME_PERIOD_ID
, GL_ENC_PERIOD_EXT_VALUE
, OGM_ENC_PERIOD_EXT_VALUE
, ENCUMBRANCE_DATE
, CI_SUMMARIZATION_OPTION
, TIME_SUMMARIZATION_OPTION
, NUMBER_OF_DR
, NUMBER_OF_CR
, TOTAL_DR_AMOUNT
, TOTAL_CR_AMOUNT
, GL_DR_AMOUNT
, GL_CR_AMOUNT
, OGM_DR_AMOUNT
, OGM_CR_AMOUNT
, ACTION_CODE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, RUN_ID
, BATCH_NAME
, SUMM_GL_DR_AMOUNT
, SUMM_GL_CR_AMOUNT
, SUMM_OGM_DR_AMOUNT
, SUMM_OGM_CR_AMOUNT
, BUSINESS_GROUP_ID
, ACTION_TYPE
, GL_PHASE
, GMS_PHASE
, ARCHIVE_FLAG
, LIQUIDATE_REQUEST_ID
, PAYROLL_ACTION_ID
, UOM
FROM PSP.PSP_ENC_CONTROLS;
PSP.PSP_ENC_CONTROLS does not reference any database object
PSP.PSP_ENC_CONTROLS is referenced by following:
PSP
PSP_ENC_CONTROLS#
|
|
|
|