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

TABLE: HR.PAY_ZA_TYS_PROCESSES

Object Details
Object Name: PAY_ZA_TYS_PROCESSES
Object Type: TABLE
Owner: HR
FND Design Data: TablePAY.PAY_ZA_TYS_PROCESSES
Subobject Name:
Status: VALID


PAY_ZA_TYS_PROCESSES stored information about each Tax Year Start Process that was run to ensure that the process will not be run for the same payroll and tax year, and to ensure that a rollback on the process will not occur if the specific payroll / tax year combination was not run.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PAY_ZA_TYS_PROCESSES_PK
  1. ColumnTYSP_ID
Unique Key: PAY_ZA_TYS_PROCESSES_UK1
  1. ColumnTAX_YEAR
  2. ColumnPAYROLL_ID
  3. ColumnCONSOLIDATION_SET_ID
Indexes
Index Type Uniqueness Tablespace Column
PAY_ZA_TYS_PROCESSES_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTYSP_ID
PAY_ZA_TYS_PROCESSES_UK1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnTAX_YEAR
ColumnPAYROLL_ID
ColumnCONSOLIDATION_SET_ID
Columns
Name Datatype Length Mandatory Comments
TYSP_ID NUMBER (9) Yes Tax year start process ID
PAYROLL_ID NUMBER (9) Yes Payroll ID
CONSOLIDATION_SET_ID NUMBER (9) Yes Consolidation Set ID
TAX_YEAR NUMBER (4) Yes Current Tax Year
Query Text

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


SELECT TYSP_ID
,      PAYROLL_ID
,      CONSOLIDATION_SET_ID
,      TAX_YEAR
FROM HR.PAY_ZA_TYS_PROCESSES;

Dependencies

[top of page]

HR.PAY_ZA_TYS_PROCESSES does not reference any database object

HR.PAY_ZA_TYS_PROCESSES is referenced by following:

SchemaAPPS
SynonymPAY_ZA_TYS_PROCESSES
SchemaPUBLIC
SynonymPAY_ZA_TYS_PROCESSES