eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PSP.PSP_ENC_CONTROLS

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

PSP.PSP_ENC_CONTROLS does not reference any database object

PSP.PSP_ENC_CONTROLS is referenced by following:

APPS: PSP_ENC_CONTROLS; PSP_ENC_CONTROLS_WHO