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

TABLE: HR.PAY_SHADOW_GU_BAL_EXCLUSIONS

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


Models PAY_GROSSUP_BAL_EXCLUSIONS_F in the Element Template Shadow Schema


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Primary Key: PAY_SHADOW_GU_BAL_EXCLUSION_PK
  1. ColumnGROSSUP_BALANCES_ID
  2. ColumnZD_EDITION_NAME
Indexes
Index Type Uniqueness Tablespace Column
PAY_SHADOW_GU_BAL_EXCLUSION_PK NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnGROSSUP_BALANCES_ID
ColumnZD_EDITION_NAME
PAY_SHAD_GU_BAL_EXCLUSION_FK1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnSOURCE_ID
PAY_SHAD_GU_BAL_EXCLUSION_FK2 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnBALANCE_TYPE_ID
PAY_SHAD_GU_BAL_EXCLUSION_FK3 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnEXCLUSION_RULE_ID
Columns
Name Datatype Length Mandatory Comments
GROSSUP_BALANCES_ID NUMBER (15) Yes Primary Key for PAY_SHADOW_GU_BAL_EXCLUSIONS
SOURCE_ID NUMBER (9) Yes Foreign Key to PAY_SHADOW_ELEMENT_TYPES
SOURCE_TYPE VARCHAR2 (30) Yes Should always be 'ET' for 'Element Type'
BALANCE_TYPE_NAME VARCHAR2 (80)
Name of a seeded Balance Type
BALANCE_TYPE_ID NUMBER (9)
Foreign Key to PAY_SHADOW_BALANCE_TYPES
EXCLUSION_RULE_ID NUMBER (9)
Exclusion rule for this grossup balance exclusion
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).
CREATION_DATE DATE

Standard who column - date when this row was created.
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT GROSSUP_BALANCES_ID
,      SOURCE_ID
,      SOURCE_TYPE
,      BALANCE_TYPE_NAME
,      BALANCE_TYPE_ID
,      EXCLUSION_RULE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      OBJECT_VERSION_NUMBER
,      ZD_EDITION_NAME
FROM HR.PAY_SHADOW_GU_BAL_EXCLUSIONS;

Dependencies

[top of page]

HR.PAY_SHADOW_GU_BAL_EXCLUSIONS does not reference any database object

HR.PAY_SHADOW_GU_BAL_EXCLUSIONS is referenced by following:

SchemaHR
ViewPAY_SHADOW_GU_BAL_EXCLUSIONS#