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

TABLE: HR.PAY_GB_SOY_OUTPUTS

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


PAY_GB_SOY_OUTPUTS is a temporary table for the GB Start of Year (SOY)
process outputs. It is populated by the SOY process data, and
includes errors or warnings relating to the update processes. This
table is redundant if you write to multiple files concurrently from
PLSQL.


Storage Details
Tablespace: TablespaceAPPS_TS_INTERFACE
PCT Free: 20
PCT Used:
Primary Key: PAY_GB_SOY_OUTPUTS_PK
  1. ColumnREQUEST_ID
  2. ColumnTYPE
  3. ColumnLINE_NO
Indexes
Index Type Uniqueness Tablespace Column
PAY_GB_SOY_OUTPUTS_PK NORMAL UNIQUE TablespaceAPPS_TS_INTERFACE ColumnREQUEST_ID
ColumnTYPE
ColumnLINE_NO
Columns
Name Datatype Length Mandatory Comments
TYPE VARCHAR2 (30) Yes Type of report for the outputs.
LINE_NO NUMBER
Yes Line number within the appropriate SOY report output.
TEXT VARCHAR2 (132)
Free format text for SOY report.
REQUEST_ID NUMBER (15) Yes Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
Query Text

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


SELECT TYPE
,      LINE_NO
,      TEXT
,      REQUEST_ID
FROM HR.PAY_GB_SOY_OUTPUTS;

Dependencies

[top of page]

HR.PAY_GB_SOY_OUTPUTS does not reference any database object

HR.PAY_GB_SOY_OUTPUTS is referenced by following:

SchemaAPPS
SynonymPAY_GB_SOY_OUTPUTS
SchemaPUBLIC
SynonymPAY_GB_SOY_OUTPUTS