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_PAYROLL_CONTROLS

Object Details

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.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

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

Columns

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

Query Text

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;

Dependencies

[top of page]

PSP.PSP_PAYROLL_CONTROLS does not reference any database object

PSP.PSP_PAYROLL_CONTROLS is referenced by following:

APPS: PSP_PAYROLL_CONTROLS; PSP_PAYROLL_CONTROLS_WHO