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: HR.PAY_PAYROLL_ACTIONS

Object Details

Object Name:	PAY_PAYROLL_ACTIONS
Object Type:	TABLE
Owner:	HR
FND Design Data:	PAY.PAY_PAYROLL_ACTIONS
Subobject Name:
Status:	VALID

PAY_PAYROLL_ACTIONS holds general details about the execution of
payroll processes, including their type and all the parameters passed
to them. It is also used to synchronize the running of parallel
threads: each slave process locks this table before getting the next
chunk number to process. In addition, CURRENT_TASK is used to
indicate to the process if it is currently executing. This prevents
the same payroll action being processed by more than one sub-process
at the same time.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Primary Key: PAY_PAYROLL_ACTIONS_PK

PAYROLL_ACTION_ID

Indexes

Index	Type	Uniqueness	Tablespace	Column
PAY_PAYROLL_ACTIONS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	PAYROLL_ACTION_ID
SYS_IL0000042506C00071$$	LOB	UNIQUE	APPS_TS_TX_DATA
PAY_PAYROLL_ACTIONS_FK1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUSINESS_GROUP_ID
PAY_PAYROLL_ACTIONS_FK5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYMENT_TYPE_ID
PAY_PAYROLL_ACTIONS_FK6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ELEMENT_SET_ID
PAY_PAYROLL_ACTIONS_FK7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ASSIGNMENT_SET_ID
PAY_PAYROLL_ACTIONS_FK8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TIME_PERIOD_ID
PAY_PAYROLL_ACTIONS_FK9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BACKPAY_SET_ID
PAY_PAYROLL_ACTIONS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_PAYMENT_METHOD_ID
PAY_PAYROLL_ACTIONS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	EFFECTIVE_DATE
PAY_PAYROLL_ACTIONS_N50	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CONSOLIDATION_SET_ID EFFECTIVE_DATE PAYROLL_ID
PAY_PAYROLL_ACTIONS_N51	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PAYROLL_ID ACTION_TYPE EFFECTIVE_DATE
PAY_PAYROLL_ACTIONS_N52	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	REPORT_TYPE REPORT_QUALIFIER REPORT_CATEGORY
PAY_PAYROLL_ACTIONS_N53	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BATCH_ID
PAY_PAYROLL_ACTIONS_N54	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTION_TYPE EFFECTIVE_DATE PAYROLL_ID
PAY_PAYROLL_ACTIONS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OVERRIDING_DD_DATE

Foreign Keys

Table	Foreign Table	Foreign Key Column
PAY_PAYROLL_ACTIONS	HR_ALL_ORGANIZATION_UNITS	PAY_PAYROLL_ACTIONS BUSINESS_GROUP_ID
PAY_PAYROLL_ACTIONS	HR_ASSIGNMENT_SETS	PAY_PAYROLL_ACTIONS ASSIGNMENT_SET_ID
PAY_PAYROLL_ACTIONS	PAY_BACKPAY_SETS	PAY_PAYROLL_ACTIONS BACKPAY_SET_ID
PAY_PAYROLL_ACTIONS	PAY_CONSOLIDATION_SETS	PAY_PAYROLL_ACTIONS CONSOLIDATION_SET_ID
PAY_PAYROLL_ACTIONS	PER_TIME_PERIODS	PAY_PAYROLL_ACTIONS TIME_PERIOD_ID
PAY_ZA_ACB_USER_GEN_NOS	PAY_PAYROLL_ACTIONS	PAY_ZA_ACB_USER_GEN_NOS PAYROLL_ACTION_ID

Columns

Name	Datatype	Length	Mandatory	Comments
PAYROLL_ACTION_ID	NUMBER	(9)	Yes	System generated primary key.
ACTION_TYPE	VARCHAR2	(30)	Yes	Type of the payroll action.
BUSINESS_GROUP_ID	NUMBER	(15)	Yes	Foreign key to HR_ORGANIZATION_UNITS.
CONSOLIDATION_SET_ID	NUMBER	(9)		Foreign key to PAY_CONSOLIDATION_SETS.
PAYROLL_ID	NUMBER	(9)		Foreign key to PAY_PAYROLLS.
ORG_PAYMENT_METHOD_ID	NUMBER	(9)		Foreign key to PAY_ORG_PAYMENT_METHODS.
PAYMENT_TYPE_ID	NUMBER	(9)		Foreign key to PAY_PAYMENT_TYPES.
ACTION_POPULATION_STATUS	VARCHAR2	(30)	Yes	Indicates if the insert of assignment actions is complete.
ACTION_STATUS	VARCHAR2	(1)	Yes	Status of the process: Unprocessed, Processing, Error, Complete.
EFFECTIVE_DATE	DATE		Yes	Session date for the event; for payroll run, this is DATE PAID.
ACTION_SEQUENCE	NUMBER	(15)		Absolute sequence number to determine physical order of actions.
CHEQUE_PROCEDURE	VARCHAR2	(30)		Lookup code for PLSQL procedure for ordering cheque/check output.
CHEQUE_REPORT	VARCHAR2	(30)		Lookup code for report run to print out cheques/checks.
CURRENT_CHUNK_NUMBER	NUMBER	(15)		Part of parallelization implementation - current chunk to process.
CURRENT_TASK	VARCHAR2	(30)		Indicates if payroll action is currently executing.
END_CHEQUE_NUMBER	NUMBER	(15)		Optional end of cheque/check number range to be used by the cheque/check writer process.
LEGISLATIVE_PARAMETERS	VARCHAR2	(2000)		Free text in which process and legislation-dependent parameters are held.
OVERRIDING_DD_DATE	DATE			Overriding direct deposit date parameter for magnetic tape process.
REQUEST_ID	NUMBER	(15)		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
START_CHEQUE_NUMBER	NUMBER	(15)		Start number for the cheque/check writer process.
START_DATE	DATE			Optional start date for some payroll actions.
ELEMENT_SET_ID	NUMBER	(9)		Foreign key to PAY_ELEMENT_SETS.
ASSIGNMENT_SET_ID	NUMBER	(15)		Foreign key to HR_ASSIGNMENT_SETS.
DATE_EARNED	DATE			Date Earned value for a payroll run, usually the same value as Date Paid.
DISPLAY_RUN_NUMBER	NUMBER	(10)		Number displayed for payroll runs within a period.
PAY_ADVICE_DATE	DATE			Date to display on pay advices.
PAY_ADVICE_MESSAGE	VARCHAR2	(240)		Message text to print on all associated pay advices.
BACKPAY_SET_ID	NUMBER	(9)		Foreign key to PAY_BACKPAY_SETS.
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.
LAST_UPDATE_DATE	DATE			Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER	(15)		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.
TARGET_PAYROLL_ACTION_ID	NUMBER	(9)		The PAYROLL_ACTION_ID of a QuickPay run.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Yes	System-generated version of row. Increments by one with each update.
TIME_PERIOD_ID	NUMBER	(15)		Foreign key to PER_TIME_PERIODS - the time period in which EFFECTIVE_DATE falls.
REPORT_TYPE	VARCHAR2	(30)		Foreign key to PAY_REPORT_FORMAT_MAPPINGS; used for Archive processes.
REPORT_QUALIFIER	VARCHAR2	(30)		Foreign key to PAY_REPORT_FORMAT_MAPPINGS; used for Archive processes.
MAGNETIC_FILE_NAME	VARCHAR2	(30)		Used for archive processes for the Magnetic file name.
REPORT_FILE_NAME	VARCHAR2	(30)		Used for archive processes.
REPORT_CATEGORY	VARCHAR2	(30)		Foreign key to PAY_REPORT_FORMAT_MAPPINGS; used for Archive processes.
RUN_TYPE_ID	NUMBER	(9)		Foreign key to PAY_RUN_TYPES_F. Identifies the type of run processed.
END_DATE	DATE			End Date of Payroll Action
PURGE_PHASE	NUMBER	(9)		Value of the current purge phase, either 1 or 2.
BALANCE_SET_ID	NUMBER	(9)		Foeign Key to PAY_BALANCE_SETS.
FUTURE_PROCESS_MODE	VARCHAR2	(30)		Used by PAYWSABL to prevent pre-payment of balance adjustments.
BATCH_ID	NUMBER	(15)		Foreign key to PAY_BATCH_HEADERS
BATCH_PROCESS_MODE	VARCHAR2	(30)		Used by Batch Element Entry process.
ACTION_PARAMETER_GROUP_ID	NUMBER	(9)		Foreign key to PAY_ACTION_PARAMETER_GROUPS
COMMENTS	CLOB	(4000)		Comments field
ELEMENT_TYPE_ID	NUMBER	(15)		Foreign key to PAY_ELEMENT_TYPES_F. Used for Balance Adjustments
COST_ALLOCATION_KEYFLEX_ID	NUMBER	(9)		Used by balance_adjustments
BALANCE_ADJ_COST_FLAG	VARCHAR2	(30)		Used by balance adjustments
RETRO_DEFINITION_ID	NUMBER	(9)		Foreign key to PAY_RETRO_DEFINITIONS

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PAYROLL_ACTION_ID
,      ACTION_TYPE
,      BUSINESS_GROUP_ID
,      CONSOLIDATION_SET_ID
,      PAYROLL_ID
,      ORG_PAYMENT_METHOD_ID
,      PAYMENT_TYPE_ID
,      ACTION_POPULATION_STATUS
,      ACTION_STATUS
,      EFFECTIVE_DATE
,      ACTION_SEQUENCE
,      CHEQUE_PROCEDURE
,      CHEQUE_REPORT
,      CURRENT_CHUNK_NUMBER
,      CURRENT_TASK
,      END_CHEQUE_NUMBER
,      LEGISLATIVE_PARAMETERS
,      OVERRIDING_DD_DATE
,      REQUEST_ID
,      START_CHEQUE_NUMBER
,      START_DATE
,      ELEMENT_SET_ID
,      ASSIGNMENT_SET_ID
,      DATE_EARNED
,      DISPLAY_RUN_NUMBER
,      PAY_ADVICE_DATE
,      PAY_ADVICE_MESSAGE
,      BACKPAY_SET_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      TARGET_PAYROLL_ACTION_ID
,      OBJECT_VERSION_NUMBER
,      TIME_PERIOD_ID
,      REPORT_TYPE
,      REPORT_QUALIFIER
,      MAGNETIC_FILE_NAME
,      REPORT_FILE_NAME
,      REPORT_CATEGORY
,      RUN_TYPE_ID
,      END_DATE
,      PURGE_PHASE
,      BALANCE_SET_ID
,      FUTURE_PROCESS_MODE
,      BATCH_ID
,      BATCH_PROCESS_MODE
,      ACTION_PARAMETER_GROUP_ID
,      COMMENTS
,      ELEMENT_TYPE_ID
,      COST_ALLOCATION_KEYFLEX_ID
,      BALANCE_ADJ_COST_FLAG
,      RETRO_DEFINITION_ID
FROM HR.PAY_PAYROLL_ACTIONS;

Dependencies

[top of page]

HR.PAY_PAYROLL_ACTIONS does not reference any database object

HR.PAY_PAYROLL_ACTIONS is referenced by following:

HR: PAY_PAYROLL_ACTIONS#