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: TablePAY.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: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PAY_PAYROLL_ACTIONS_PK
  1. ColumnPAYROLL_ACTION_ID
Indexes
Index Type Uniqueness Tablespace Column
PAY_PAYROLL_ACTIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYROLL_ACTION_ID
SYS_IL0000042506C00071$$ LOB UNIQUE TablespaceAPPS_TS_TX_DATA
PAY_PAYROLL_ACTIONS_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBUSINESS_GROUP_ID
PAY_PAYROLL_ACTIONS_FK5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYMENT_TYPE_ID
PAY_PAYROLL_ACTIONS_FK6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnELEMENT_SET_ID
PAY_PAYROLL_ACTIONS_FK7 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnASSIGNMENT_SET_ID
PAY_PAYROLL_ACTIONS_FK8 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnTIME_PERIOD_ID
PAY_PAYROLL_ACTIONS_FK9 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBACKPAY_SET_ID
PAY_PAYROLL_ACTIONS_N4 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnORG_PAYMENT_METHOD_ID
PAY_PAYROLL_ACTIONS_N5 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEFFECTIVE_DATE
PAY_PAYROLL_ACTIONS_N50 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnCONSOLIDATION_SET_ID
ColumnEFFECTIVE_DATE
ColumnPAYROLL_ID
PAY_PAYROLL_ACTIONS_N51 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnPAYROLL_ID
ColumnACTION_TYPE
ColumnEFFECTIVE_DATE
PAY_PAYROLL_ACTIONS_N52 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnREPORT_TYPE
ColumnREPORT_QUALIFIER
ColumnREPORT_CATEGORY
PAY_PAYROLL_ACTIONS_N53 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBATCH_ID
PAY_PAYROLL_ACTIONS_N54 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnACTION_TYPE
ColumnEFFECTIVE_DATE
ColumnPAYROLL_ID
PAY_PAYROLL_ACTIONS_N6 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnOVERRIDING_DD_DATE
Foreign Keys
Table
Foreign Table Foreign Key Column
PAY_PAYROLL_ACTIONS PAY_PAYROLL_ACTIONS_FK1 TableHR_ALL_ORGANIZATION_UNITS PAY_PAYROLL_ACTIONS BUSINESS_GROUP_ID
PAY_PAYROLL_ACTIONS PAY_PAYROLL_ACTIONS_FK7 TableHR_ASSIGNMENT_SETS PAY_PAYROLL_ACTIONS ASSIGNMENT_SET_ID
PAY_PAYROLL_ACTIONS PAY_PAYROLL_ACTIONS_FK9 TablePAY_BACKPAY_SETS PAY_PAYROLL_ACTIONS BACKPAY_SET_ID
PAY_PAYROLL_ACTIONS PAY_PAYROLL_ACTIONS_FK2 TablePAY_CONSOLIDATION_SETS PAY_PAYROLL_ACTIONS CONSOLIDATION_SET_ID
PAY_PAYROLL_ACTIONS PAY_PAYROLL_ACTIONS_FK8 TablePER_TIME_PERIODS PAY_PAYROLL_ACTIONS TIME_PERIOD_ID
TablePAY_ZA_ACB_USER_GEN_NOS PAY_ZA_ACB_USER_GEN_NOS_FK1 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:

SchemaHR
ViewPAY_PAYROLL_ACTIONS#