Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - HXC Tables and Views

TABLE - HXC.HXC_ALIAS_DEFINITIONS
TABLE - HXC.HXC_ALIAS_DEFINITIONS_TL
TABLE - HXC.HXC_ALIAS_TYPES
TABLE - HXC.HXC_ALIAS_TYPE_COMPONENTS
TABLE - HXC.HXC_ALIAS_VALUES
TABLE - HXC.HXC_ALIAS_VALUES_TL
TABLE - HXC.HXC_APPROVAL_COMPS
TABLE - HXC.HXC_APPROVAL_PERIOD_COMPS
TABLE - HXC.HXC_APPROVAL_PERIOD_SETS
TABLE - HXC.HXC_APPROVAL_STYLES
TABLE - HXC.HXC_APP_COMP_NOTIFICATIONS
TABLE - HXC.HXC_APP_COMP_NOTIF_USAGES
TABLE - HXC.HXC_APP_PERIOD_SUMMARY
TABLE - HXC.HXC_APP_PERIOD_SUMMARY_AR
TABLE - HXC.HXC_AP_DETAIL_LINKS
TABLE - HXC.HXC_AP_DETAIL_LINKS_AR
TABLE - HXC.HXC_ARCHIVE_TEMP
TABLE - HXC.HXC_AR_DETAIL_LOG
TABLE - HXC.HXC_AR_TC_IDS_TEMP
TABLE - HXC.HXC_AR_TRANS_TEMP
TABLE - HXC.HXC_BEE_PREF_ADJ_LINES
TABLE - HXC.HXC_BLD_BLK_INFO_TYPES
TABLE - HXC.HXC_BLD_BLK_INFO_TYPE_USAGES
TABLE - HXC.HXC_DATA_APP_RULE_USAGES
TABLE - HXC.HXC_DATA_SETS
TABLE - HXC.HXC_DATA_SET_DETAILS
TABLE - HXC.HXC_DEBUG
TABLE - HXC.HXC_DEBUG_TEXT
TABLE - HXC.HXC_DEPOSIT_PROCESSES
TABLE - HXC.HXC_ENTITY_GROUPS
TABLE - HXC.HXC_ENTITY_GROUP_COMPS
TABLE - HXC.HXC_ERRORS
TABLE - HXC.HXC_LATEST_DETAILS
TABLE - HXC.HXC_LAYOUTS
TABLE - HXC.HXC_LAYOUTS_TL
TABLE - HXC.HXC_LAYOUT_COMPONENTS
TABLE - HXC.HXC_LAYOUT_COMP_DEFINITIONS
TABLE - HXC.HXC_LAYOUT_COMP_PROMPTS
TABLE - HXC.HXC_LAYOUT_COMP_QUALIFIERS
TABLE - HXC.HXC_LAYOUT_COMP_QUAL_RULES
TABLE - HXC.HXC_LOCKER_TYPES
TABLE - HXC.HXC_LOCKING_RULES
TABLE - HXC.HXC_LOCKS
TABLE - HXC.HXC_MAPPINGS
TABLE - HXC.HXC_MAPPING_COMPONENTS
TABLE - HXC.HXC_MAPPING_COMP_USAGES
TABLE - HXC.HXC_PREF_DEFINITIONS
TABLE - HXC.HXC_PREF_HIERARCHIES
TABLE - HXC.HXC_RECURRING_PERIODS
TABLE - HXC.HXC_RESOURCE_RULES
TABLE - HXC.HXC_RETRIEVAL_PROCESSES
TABLE - HXC.HXC_RETRIEVAL_RANGES
TABLE - HXC.HXC_RETRIEVAL_RANGE_RESOURCES
TABLE - HXC.HXC_RETRIEVAL_RULES
TABLE - HXC.HXC_RETRIEVAL_RULE_COMPS
TABLE - HXC.HXC_RPT_LAYOUT_COMP_QUERIES
TABLE - HXC.HXC_RPT_TC_AUDIT
TABLE - HXC.HXC_RPT_TC_DETAILS_ALL
TABLE - HXC.HXC_RPT_TC_HIST_LOG
TABLE - HXC.HXC_RPT_TC_RESOURCE_TEMP
TABLE - HXC.HXC_RPT_VO_ALL
TABLE - HXC.HXC_SEEDDATA_BY_LEVEL
TABLE - HXC.HXC_TCD_TMP_RPT
TABLE - HXC.HXC_TC_AP_LINKS
TABLE - HXC.HXC_TC_AP_LINKS_AR
TABLE - HXC.HXC_TEMPLATE_SUMMARY
TABLE - HXC.HXC_TEMP_TIMECARDS
TABLE - HXC.HXC_TEMP_TIMECARD_CHUNKS
TABLE - HXC.HXC_TIMECARD_SUMMARY
TABLE - HXC.HXC_TIME_ATTRIBUTES
TABLE - HXC.HXC_TIME_ATTRIBUTES_AR
TABLE - HXC.HXC_TIME_ATTRIBUTES_BK
TABLE - HXC.HXC_TIME_ATTRIBUTES_EFC
TABLE - HXC.HXC_TIME_ATTRIBUTE_USAGES
TABLE - HXC.HXC_TIME_ATTRIBUTE_USAGES_AR
TABLE - HXC.HXC_TIME_ATTRIBUTE_USAGES_BK
TABLE - HXC.HXC_TIME_BUILDING_BLOCKS
TABLE - HXC.HXC_TIME_BUILDING_BLOCKS_AR
TABLE - HXC.HXC_TIME_CATEGORIES
TABLE - HXC.HXC_TIME_CATEGORY_COMPS
TABLE - HXC.HXC_TIME_CATEGORY_COMP_SQL
TABLE - HXC.HXC_TIME_ENTRY_RULES
TABLE - HXC.HXC_TIME_RECIPIENTS
TABLE - HXC.HXC_TIME_SOURCES
TABLE - HXC.HXC_TK_DETAIL_TEMP
TABLE - HXC.HXC_TK_GROUPS
TABLE - HXC.HXC_TK_GROUP_QUERIES
TABLE - HXC.HXC_TK_GROUP_QUERY_CRITERIA
TABLE - HXC.HXC_TK_TIMEKEEPER_SUBMITS
TABLE - HXC.HXC_TRANSACTIONS
TABLE - HXC.HXC_TRANSACTIONS_AR
TABLE - HXC.HXC_TRANSACTION_DETAILS
TABLE - HXC.HXC_TRANSACTION_DETAILS_AR
VIEW - APPS.HXC_ALIAS_DEFINITIONS_V
VIEW - APPS.HXC_ALIAS_TYPES_V
VIEW - APPS.HXC_ALIAS_TYPE_COMPONENTS_V
VIEW - APPS.HXC_ALIAS_VALUES_V
VIEW - APPS.HXC_APPLICATION_PERIODS_V
VIEW - APPS.HXC_APPLICATION_SETS_V
VIEW - APPS.HXC_APPLICATION_SET_COMPS_V
VIEW - APPS.HXC_APPL_PERIOD_DETAILS_V
VIEW - APPS.HXC_APPROVAL_COMPS_V
VIEW - APPS.HXC_APPROVAL_DETAILS_V
VIEW - APPS.HXC_APPROVAL_PERIOD_COMPS_V
VIEW - APPS.HXC_APPROVAL_STYLES_V
VIEW - APPS.HXC_APPR_REJECTION_COMMENTS_V
VIEW - APPS.HXC_APP_PERIOD_TOTAL_TIME_V
VIEW - APPS.HXC_BASE_PA_ONLINE_PROJECTS_V
VIEW - APPS.HXC_BASE_PA_ONLINE_TASKS_V
VIEW - APPS.HXC_DATA_APP_RULE_USAGES_V
VIEW - APPS.HXC_LAYOUTS_VL
VIEW - APPS.HXC_LAYOUT_COMPONENTS_V
VIEW - APPS.HXC_LAYOUT_COMP_MESSAGES_V
VIEW - APPS.HXC_LAYOUT_COMP_PROMPTS_V
VIEW - APPS.HXC_LOOKUPS
VIEW - APPS.HXC_MAPPINGS_V
VIEW - APPS.HXC_MAPPING_ATTRIBUTES_V
VIEW - APPS.HXC_MAPPING_COMPONENTS_V
VIEW - APPS.HXC_MAPPING_COMP_USAGES_V
VIEW - APPS.HXC_OVERRIDE_APPROVER_V
VIEW - APPS.HXC_PREF_HIERARCHIES_V
VIEW - APPS.HXC_PUBLIC_TEMPLATE_LIST_V
VIEW - APPS.HXC_RECURRING_PERIODS_V
VIEW - APPS.HXC_RESOURCE_ALL_ELIG_PREF_V
VIEW - APPS.HXC_RESOURCE_ELIG_PREF_V
VIEW - APPS.HXC_RESOURCE_INFORMATION_V
VIEW - APPS.HXC_RESOURCE_PERSONAL_PREF_V
VIEW - APPS.HXC_RESOURCE_PREF_V
VIEW - APPS.HXC_RESOURCE_RULES_PERSON_V
VIEW - APPS.HXC_RESOURCE_RULES_V
VIEW - APPS.HXC_RESOURCE_TEMPLATES_V
VIEW - APPS.HXC_RESOURCE_TIMECARDS_V
VIEW - APPS.HXC_RESOURCE_TIMECARD_DETAIL_V
VIEW - APPS.HXC_RESOURCE_TOTAL_TIME_V
VIEW - APPS.HXC_RETRIEVAL_RULES_V
VIEW - APPS.HXC_RETRIEVAL_RULE_COMPS_V
VIEW - APPS.HXC_RETRIEVAL_RULE_GROUPS_V
VIEW - APPS.HXC_RETRIEVAL_RULE_GRP_COMPS_V
VIEW - APPS.HXC_RETVL_DEPST_PROCESSES_V
VIEW - APPS.HXC_STATIC_TIMECARD_INFO_V
VIEW - APPS.HXC_TC_AUDIT_SUMMARY
VIEW - APPS.HXC_TEMPLATE_SET_V
VIEW - APPS.HXC_TIMECARDS_V
VIEW - APPS.HXC_TIMECARD_ATTRIBUTES_V
VIEW - APPS.HXC_TIMECARD_AUDIT_SUMMARY
VIEW - APPS.HXC_TIMECARD_DAYS_V
VIEW - APPS.HXC_TIMECARD_DETAILS_V
VIEW - APPS.HXC_TIMECARD_DETAIL_HOURS_V
VIEW - APPS.HXC_TIMECARD_HOURS_V
VIEW - APPS.HXC_TIMECARD_PERIODS_DB_V
VIEW - APPS.HXC_TIMECARD_PERIODS_V
VIEW - APPS.HXC_TIMECARD_TEMPLATES_V
VIEW - APPS.HXC_TIME_CATEGORIES_V
VIEW - APPS.HXC_TIME_CATEGORY_COMPS_V
VIEW - APPS.HXC_TIME_ENTRY_RULES_V
VIEW - APPS.HXC_TIME_ENTRY_RULE_COMPS_V
VIEW - APPS.HXC_TIME_ENTRY_RULE_GROUPS_V
VIEW - APPS.HXC_TK_GROUPS_V
VIEW - APPS.HXC_TK_GROUP_QUERY_CRITERIA_V
VIEW - APPS.HXC_TK_PAY_LOCATIONS

Table: HXC_ALIAS_DEFINITIONS

Description: Alternate Name Definitions
Primary Key: HXC_ALIAS_DEFINITIONS_PK
  1. ALIAS_DEFINITION_ID
Primary Key: HXC_ALIAS_DEFINITIONS_UK1
  1. ALIAS_DEFINITION_NAME
  2. BUSINESS_GROUP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_ALIAS_VALUES.ALIAS_DEFINITION_ID HXC_ALIAS_DEFINITIONS
Comments

HXC_ALIAS_DEFINITIONS holds the alternate name definitions used on the Self-Service Timecard screen. This definition is associated with a field on the timecard for which the alternate name is applied.

Indexes
Index Type Tablespace Column
HXC_ALIAS_DEFINITIONS_PK UNIQUE APPS_TS_TX_IDX ALIAS_DEFINITION_ID
HXC_ALIAS_DEFINITIONS_UK1 UNIQUE APPS_TS_TX_IDX ALIAS_DEFINITION_NAME
BUSINESS_GROUP_ID
HXC_ALIAS_DEFINITIONS_FK1 NONUNIQUE APPS_TS_TX_IDX BUSINESS_GROUP_ID
HXC_ALIAS_DEFINITIONS_FK2 NONUNIQUE APPS_TS_TX_IDX ALIAS_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE VARCHAR2 (30)
The legislation to which the alias definition applies
ALIAS_DEFINITION_ID NUMBER (15) Y Primary Key from the associated sequence
ALIAS_CONTEXT_CODE VARCHAR2 (30)
Associated Descriptive Flexfield Context
DESCRIPTION VARCHAR2 (240)
User-defined description of definition
ALIAS_DEFINITION_NAME VARCHAR2 (80) Y Name
TIMECARD_FIELD VARCHAR2 (80)
Associated field on the Timecard
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.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
ALIAS_TYPE_ID NUMBER (15) Y Primary Key from associated sequence

[top of page]

HXC.HXC_ALIAS_DEFINITIONS does not reference any database object

HXC.HXC_ALIAS_DEFINITIONS is referenced by following:

APPS
SYNONYM - HXC_ALIAS_DEFINITIONS
TRIGGER - HXC_ALIAS_DEFINITIONS_WHO

[top of page]

Table: HXC_ALIAS_DEFINITIONS_TL

Description: Translated Alternate Name Definitions
Primary Key: HXC_ALIAS_DEFINITIONS_TL_PK
  1. ALIAS_DEFINITION_ID
  2. LANGUAGE
Comments

HXC_ALIAS_DEFINITIONS_TL holds the translated alternate name definitions used on the Self-Service Timecard screen.

Indexes
Index Type Tablespace Column
HXC_ALIAS_DEFINITIONS_TL_PK UNIQUE APPS_TS_TX_IDX ALIAS_DEFINITION_ID
LANGUAGE
HXC_ALIAS_DEFINITIONS_TL_N2 NONUNIQUE APPS_TS_TX_IDX LANGUAGE
ALIAS_DEFINITION_NAME
Columns
Name Datatype Length Mandatory Comments
ALIAS_DEFINITION_ID NUMBER (15) Y Foreign Key to HXC_ALIAS_DEFINITIONS
ALIAS_DEFINITION_NAME VARCHAR2 (80) Y Translated Name of the Alternate Name Definition
DESCRIPTION VARCHAR2 (240)
Translated Description
LANGUAGE VARCHAR2 (4) Y Defined Language
SOURCE_LANG VARCHAR2 (4) Y Actual Language
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.
PROMPT VARCHAR2 (240)
Defined the prompt of the alias. This prompt will be use in the rendering of the timekeeper PUI.

[top of page]

HXC.HXC_ALIAS_DEFINITIONS_TL does not reference any database object

HXC.HXC_ALIAS_DEFINITIONS_TL is referenced by following:

APPS
TRIGGER - HXC_ALIAS_DEFINITION041259_WHO
SYNONYM - HXC_ALIAS_DEFINITIONS_TL

[top of page]

Table: HXC_ALIAS_TYPES

Description: HXC_ALIAS_TYPES holds the alternate name types. These types could be based on a DDF context defintion or a value set.
Primary Key: HXC_ALIAS_TYPES_PK
  1. ALIAS_TYPE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_ALIAS_TYPE_COMPONENTS.ALIAS_TYPE_ID HXC_ALIAS_TYPES
Comments

HXC_ALIAS_TYPES holds the alternate name types. These types could be based on a DDF context defintion or a value set.

Indexes
Index Type Tablespace Column
HXC_ALIAS_TYPES_PK UNIQUE APPS_TS_TX_IDX ALIAS_TYPE_ID
HXC_ALIAS_TYPES_UK1 UNIQUE APPS_TS_TX_IDX ALIAS_TYPE
REFERENCE_OBJECT
Columns
Name Datatype Length Mandatory Comments
ALIAS_TYPE_ID NUMBER (15) Y Primary Key from associated sequence
ALIAS_TYPE VARCHAR2 (30) Y Type of the Alternate Name -> DYNAMIC or STATIC
REFERENCE_OBJECT VARCHAR2 (150) Y Object Used by the type. If the type is static then the reference object will contained the alias context code of the DDF. It the type is Dynamic, the reference object will contained a value set id
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.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number

[top of page]

HXC.HXC_ALIAS_TYPES does not reference any database object

HXC.HXC_ALIAS_TYPES is referenced by following:

APPS
SYNONYM - HXC_ALIAS_TYPES
TRIGGER - HXC_ALIAS_TYPES_WHO

[top of page]

Table: HXC_ALIAS_TYPE_COMPONENTS

Description: HXC_ALIAS_TYPE_COMPONENTS holds the alternate name type component. These component are link to an alternate name type but also to a mapping definition.
Primary Key: HXC_ALIAS_TYPE_COMPONENTS_PK
  1. ALIAS_TYPE_COMPONENT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_ALIAS_TYPE_COMPONENTS.ALIAS_TYPE_ID HXC_ALIAS_TYPES
HXC_ALIAS_TYPE_COMPONENTS.MAPPING_COMPONENT_ID HXC_MAPPING_COMPONENTS
Comments

HXC_ALIAS_TYPES holds the alternate name types components. These type components could be based on COLUMN, COLUMN_ID, VALUE or ATTRIBUTE.

Indexes
Index Type Tablespace Column
HXC_ALIAS_TYPE_COMPONENTS_PK UNIQUE APPS_TS_TX_IDX ALIAS_TYPE_COMPONENT_ID
HXC_ALIAS_TYPE_COMPONENTS_FK1 NONUNIQUE APPS_TS_TX_IDX ALIAS_TYPE_ID
HXC_ALIAS_TYPE_COMPONENTS_FK2 NONUNIQUE APPS_TS_TX_IDX MAPPING_COMPONENT_ID
Columns
Name Datatype Length Mandatory Comments
ALIAS_TYPE_COMPONENT_ID NUMBER (15) Y Primary Key from associated sequence
COMPONENT_NAME VARCHAR2 (240) Y Name of the component
COMPONENT_TYPE VARCHAR2 (80) Y Type of the component -> COLUMN_ID or COLUMN or ATTRIBUTE
MAPPING_COMPONENT_ID NUMBER (15) Y Foreign Key for HXC_MAPPING_COMPONENTS table
ALIAS_TYPE_ID NUMBER (15) Y Foreign Key for HXC_ALIAS_TYPE table
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.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number

[top of page]

HXC.HXC_ALIAS_TYPE_COMPONENTS does not reference any database object

HXC.HXC_ALIAS_TYPE_COMPONENTS is referenced by following:

APPS
SYNONYM - HXC_ALIAS_TYPE_COMPONENTS
TRIGGER - HXC_ALIAS_TYPE_COMPONENTS_WHO

[top of page]

Table: HXC_ALIAS_VALUES

Description: Alternate name components
Primary Key: HXC_ALIAS_VALUES_PK
  1. ALIAS_VALUE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_ALIAS_VALUES.ALIAS_DEFINITION_ID HXC_ALIAS_DEFINITIONS
Comments

HXC_ALIAS_VALUES holds the alternate name components that belong to a particular alternate name definition. These components appear in the List of Values for the associated field on the selef-service timecard.

Indexes
Index Type Tablespace Column
HXC_ALIAS_VALUES_PK UNIQUE APPS_TS_TX_IDX ALIAS_VALUE_ID
HXC_ALIAS_VALUES_FK1 NONUNIQUE APPS_TS_TX_IDX ALIAS_DEFINITION_ID
Columns
Name Datatype Length Mandatory Comments
ALIAS_VALUE_ID NUMBER (15) Y Primary Key from associated sequence
ALIAS_VALUE_NAME VARCHAR2 (80) Y Name of component
DATE_FROM DATE
Y Start Date
DATE_TO DATE

End Date
ALIAS_DEFINITION_ID NUMBER (15) Y Foreign Key to parent table HXC_ALIAS_DEFINITIONS
ENABLED_FLAG VARCHAR2 (9) Y Enabled = Y means this component will be displayed to user
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
ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE30 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.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number

[top of page]

HXC.HXC_ALIAS_VALUES does not reference any database object

HXC.HXC_ALIAS_VALUES is referenced by following:

APPS
SYNONYM - HXC_ALIAS_VALUES
TRIGGER - HXC_ALIAS_VALUES_WHO

[top of page]

Table: HXC_ALIAS_VALUES_TL

Description: Translated Alternate name components
Primary Key: HXC_ALIAS_VALUES_TL_PK
  1. ALIAS_VALUE_ID
  2. LANGUAGE
Comments

HXC_ALIAS_VALUES_TL holds the translated alternate name components that belong to a particular alternate name definition. These components appear in the List of Values for the associated field on the selef-service timecard.

Indexes
Index Type Tablespace Column
HXC_ALIAS_VALUES_TL_PK UNIQUE APPS_TS_TX_IDX ALIAS_VALUE_ID
LANGUAGE
HXC_ALIAS_VALUES_TL_N2 NONUNIQUE APPS_TS_TX_IDX LANGUAGE
ALIAS_VALUE_NAME
HXC_ALIAS_VALUES_TL_N3 NONUNIQUE APPS_TS_TX_IDX SYS_NC00010$
Columns
Name Datatype Length Mandatory Comments
ALIAS_VALUE_ID NUMBER (15) Y Foreign Key to HXC_ALIAS_VALUES
ALIAS_VALUE_NAME VARCHAR2 (80) Y Translated Name of the Alternate Name Component
LANGUAGE VARCHAR2 (4) Y Defined Language
SOURCE_LANG VARCHAR2 (4) Y Actual Language
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.

[top of page]

HXC.HXC_ALIAS_VALUES_TL does not reference any database object

HXC.HXC_ALIAS_VALUES_TL is referenced by following:

APPS
SYNONYM - HXC_ALIAS_VALUES_TL
TRIGGER - HXC_ALIAS_VALUES_TL041240_WHO

[top of page]

Table: HXC_APPROVAL_COMPS

Description: Approval Components
Primary Key: HXC_APPROVAL_COMPS_PK
  1. APPROVAL_COMP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_APPROVAL_COMPS.APPROVAL_STYLE_ID HXC_APPROVAL_STYLES
HXC_APPROVAL_COMPS.TIME_RECIPIENT_ID HXC_TIME_RECIPIENTS
Comments

HXC_APPROVAL_COMPONENTS holds the individual components of an Approval Style. These components determine whether or not approval or re-approval is required, based on the Approval
Style associated with modified Time information.

Indexes
Index Type Tablespace Column
HXC_APPROVAL_COMPS_PK UNIQUE APPS_TS_TX_IDX APPROVAL_COMP_ID
HXC_APPROVAL_COMPS_FK1 NONUNIQUE APPS_TS_TX_IDX APPROVAL_STYLE_ID
HXC_APPROVAL_COMPS_FK2 NONUNIQUE APPS_TS_TX_IDX TIME_RECIPIENT_ID
Columns
Name Datatype Length Mandatory Comments
APPROVAL_COMP_ID NUMBER (15) Y Primary Key from sequence
APPROVAL_STYLE_ID NUMBER (15) Y Foreign Key to HXC_APPROVAL_STYLES
TIME_RECIPIENT_ID NUMBER (15) Y Foreign Key to HXC_TIME_RECIPIENTS.
APPROVAL_MECHANISM VARCHAR2 (30) Y Indicates the mehanism used for approval.
APPROVAL_MECHANISM_ID NUMBER (15)
An implicit Foreign Key which may be required to complete the definition of the Approval Mechanism.
WF_ITEM_TYPE VARCHAR2 (8)
The type of the Workflow associated with the Apporval Component.
WF_NAME VARCHAR2 (30)
The name of the Workflow associated with the Approval Component.
START_DATE DATE
Y The start date of the Approval Component.
END_DATE DATE
Y The end date of the Approval Component.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
APPROVAL_ORDER NUMBER (15)
Indicates the sequencing of the Approval Compnent within the Approval Style.
TIME_CATEGORY_ID NUMBER (15)
Time category Id for which the approval style is defined
PARENT_COMP_ID NUMBER (15)
Parent Approval Component Id
PARENT_COMP_OVN NUMBER (9)
Parent Component Object version number
RUN_RECIPIENT_EXTENSIONS VARCHAR2 (1)
Run Recipient Extensions

[top of page]

HXC.HXC_APPROVAL_COMPS does not reference any database object

HXC.HXC_APPROVAL_COMPS is referenced by following:

APPS
SYNONYM - HXC_APPROVAL_COMPS
TRIGGER - HXC_APPROVAL_COMPS_WHO

[top of page]

Table: HXC_APPROVAL_PERIOD_COMPS

Description: Approval Period Components
Primary Key: HXC_APPROVAL_PERIOD_COMPS_PK
  1. APPROVAL_PERIOD_COMP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_APPROVAL_PERIOD_COMPS.APPROVAL_PERIOD_SET_ID HXC_APPROVAL_PERIOD_SETS
HXC_APPROVAL_PERIOD_COMPS.RECURRING_PERIOD_ID HXC_RECURRING_PERIODS
HXC_APPROVAL_PERIOD_COMPS.TIME_RECIPIENT_ID HXC_TIME_RECIPIENTS
Comments

HXC_APPROVAL_PERIOD_COMPS hold details of the Recipient Applications belonging to an Approval Period Set.

Indexes
Index Type Tablespace Column
HXC_APPROVAL_PERIOD_COMPS_PK UNIQUE APPS_TS_TX_IDX APPROVAL_PERIOD_COMP_ID
HXC_APPROVAL_PERIOD_COMPS_FK1 NONUNIQUE APPS_TS_TX_IDX APPROVAL_PERIOD_SET_ID
HXC_APPROVAL_PERIOD_COMPS_FK2 NONUNIQUE APPS_TS_TX_IDX RECURRING_PERIOD_ID
HXC_APPROVAL_PERIOD_COMPS_FK3 NONUNIQUE APPS_TS_TX_IDX TIME_RECIPIENT_ID
Columns
Name Datatype Length Mandatory Comments
APPROVAL_PERIOD_COMP_ID NUMBER (15) Y Primary Key from sequence
TIME_RECIPIENT_ID NUMBER (15) Y Foreign Key to HXC_TIME_RECIPIENTS.
RECURRING_PERIOD_ID NUMBER (15) Y Foreign Key to HXC_RECURRING_PERIODS.
APPROVAL_PERIOD_SET_ID NUMBER (15) Y Foreign Key to HXC_APPROVAL_PERIOD_SETS.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

HXC.HXC_APPROVAL_PERIOD_COMPS does not reference any database object

HXC.HXC_APPROVAL_PERIOD_COMPS is referenced by following:

APPS
SYNONYM - HXC_APPROVAL_PERIOD_COMPS
TRIGGER - HXC_APPROVAL_PERIOD_COMPS_WHO

[top of page]

Table: HXC_APPROVAL_PERIOD_SETS

Description: Approval Period Sets
Primary Key: HXC_APPROVAL_PERIOD_SETS_PK
  1. APPROVAL_PERIOD_SET_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_APPROVAL_PERIOD_COMPS.APPROVAL_PERIOD_SET_ID HXC_APPROVAL_PERIOD_SETS
Comments

HXC_APPROVAL_PERIOD_SETS groups together the Recurring Periods from HXC_RECURRING_PERIODS that are used by a Recipient Application.

Indexes
Index Type Tablespace Column
HXC_APPROVAL_PERIOD_SETS_PK UNIQUE APPS_TS_TX_IDX APPROVAL_PERIOD_SET_ID
HXC_APPROVAL_PERIOD_SETS_UK1 UNIQUE APPS_TS_TX_IDX NAME
Columns
Name Datatype Length Mandatory Comments
APPROVAL_PERIOD_SET_ID NUMBER (15) Y Primary Key from sequence
NAME VARCHAR2 (80) Y Name of the Approval Period Set.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

HXC.HXC_APPROVAL_PERIOD_SETS does not reference any database object

HXC.HXC_APPROVAL_PERIOD_SETS is referenced by following:

APPS
SYNONYM - HXC_APPROVAL_PERIOD_SETS
TRIGGER - HXC_APPROVAL_PERIOD_SETS_WHO

[top of page]

Table: HXC_APPROVAL_STYLES

Description: Approval Styles
Primary Key: HXC_APPROVAL_STYLES_PK
  1. APPROVAL_STYLE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_APPROVAL_COMPS.APPROVAL_STYLE_ID HXC_APPROVAL_STYLES
HXC_DATA_APP_RULE_USAGES.APPROVAL_STYLE_ID HXC_APPROVAL_STYLES
HXC_TIME_BUILDING_BLOCKS.APPROVAL_STYLE_ID HXC_APPROVAL_STYLES
Comments

HXC_APPROVAL_STYLES holds descriptions of the Approval Styles defined in the Time Store.

Indexes
Index Type Tablespace Column
HXC_APPROVAL_STYLES_PK UNIQUE APPS_TS_TX_IDX APPROVAL_STYLE_ID
HXC_APPROVAL_STYLES_UK1 UNIQUE APPS_TS_TX_IDX NAME
BUSINESS_GROUP_ID
HXC_APPROVAL_STYLES_FK1 NONUNIQUE APPS_TS_TX_IDX BUSINESS_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE VARCHAR2 (30)
The legislation to which the approval style applies
APPROVAL_STYLE_ID NUMBER (15) Y Primary Key from sequence
NAME VARCHAR2 (80) Y Name of the Approval Style.
DESCRIPTION VARCHAR2 (2000)
Description of the Approval Style.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
RUN_RECIPIENT_EXTENSIONS VARCHAR2 (1)
Run Recipient Extensions
ADMIN_ROLE VARCHAR2 (320)
Admin Role
ERROR_ADMIN_ROLE VARCHAR2 (320)
Error Admin Role

[top of page]

HXC.HXC_APPROVAL_STYLES does not reference any database object

HXC.HXC_APPROVAL_STYLES is referenced by following:

APPS
SYNONYM - HXC_APPROVAL_STYLES
TRIGGER - HXC_APPROVAL_STYLES_WHO

[top of page]

Table: HXC_APP_COMP_NOTIFICATIONS

Description: HXC_APP_COMP_NOTIFICATIONS
Primary Key: HXC_APP_COMP_NOTIFICATIONS_PK
  1. COMP_NOTIFICATION_ID
  2. OBJECT_VERSION_NUMBER
Comments

HXC_APP_COMP_NOTIFICATIONS table contains the component notification details, which include number of retries and timeout values

Indexes
Index Type Tablespace Column
HXC_APP_COMP_NOTIFICATIONS_PK UNIQUE APPS_TS_TX_IDX COMP_NOTIFICATION_ID
OBJECT_VERSION_NUMBER
Columns
Name Datatype Length Mandatory Comments
COMP_NOTIFICATION_ID NUMBER (15) Y Comp Notification ID
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
NOTIFICATION_NUMBER_RETRIES NUMBER (3) Y Notification Number Retries
NOTIFICATION_TIMEOUT_VALUE NUMBER (6) Y Notification Timeout Value
NOTIFICATION_ACTION_CODE VARCHAR2 (30) Y Notification Action Code
NOTIFICATION_RECIPIENT_CODE VARCHAR2 (30) Y Notification Recipient Code
CREATED_BY NUMBER (15)
Standard who column
CREATION_DATE DATE

Standard Who column - creation date
LAST_UPDATED_BY NUMBER (15)
Standard Who column - last updated by
LAST_UPDATE_DATE DATE

Standard Who column - last updated date
LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column - last updated login

[top of page]

HXC.HXC_APP_COMP_NOTIFICATIONS does not reference any database object

HXC.HXC_APP_COMP_NOTIFICATIONS is referenced by following:

APPS
SYNONYM - HXC_APP_COMP_NOTIFICATIONS
TRIGGER - HXC_APP_COMP_NOTIFICATIONS_WHO

[top of page]

Table: HXC_APP_COMP_NOTIF_USAGES

Description: Application Component Notification Usage Table
Comments

HXC_APP_COMP_NOTIF_USAGES table contains intersection entity between the approval components table and HXC_APP_COMP_NOTIFICATIONS table

Indexes
Index Type Tablespace Column
HXC_APP_COMP_NOTIF_USAGES_N1 NONUNIQUE APPS_TS_TX_IDX APPROVAL_COMP_ID
APPROVAL_COMP_OVN
HXC_APP_COMP_NOTIF_USAGES_N2 NONUNIQUE APPS_TS_TX_IDX COMP_NOTIFICATION_ID
COMP_NOTIFICATION_OVN
Columns
Name Datatype Length Mandatory Comments
APPROVAL_COMP_ID NUMBER (15) Y Approval Component ID
APPROVAL_COMP_OVN NUMBER (9)
Approval Component Object Version Number
COMP_NOTIFICATION_ID NUMBER (15) Y Component Notification ID
COMP_NOTIFICATION_OVN NUMBER (9) Y Component Notification Object Version Number
ENABLED_FLAG VARCHAR2 (1) Y Enabled Flag

[top of page]

HXC.HXC_APP_COMP_NOTIF_USAGES does not reference any database object

HXC.HXC_APP_COMP_NOTIF_USAGES is referenced by following:

APPS
SYNONYM - HXC_APP_COMP_NOTIF_USAGES

[top of page]

Table: HXC_APP_PERIOD_SUMMARY

Description: Application period summary table
Comments

The HXC_APP_PERIOD_SUMMARY table denormalizes information about application period scope building blocks from the HXC_TIME_BUILDING_BLOCKS table. Further, it stores information for and is used by the entry level approval functionality.

Indexes
Index Type Tablespace Column
HXC_APP_PERIOD_SUMMARY_PK UNIQUE APPS_TS_TX_IDX APPLICATION_PERIOD_ID
HXC_APP_PERIOD_SUMMARY_N1 NONUNIQUE APPS_TS_TX_IDX RESOURCE_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_PERIOD_ID NUMBER
Y The application period id
APPLICATION_PERIOD_OVN NUMBER
Y The application period object version number
APPROVAL_STATUS VARCHAR2 (30) Y The approval status
TIME_RECIPIENT_ID NUMBER
Y The time recipient id
TIME_CATEGORY_ID NUMBER

The time category id
START_TIME DATE
Y The start time of the approval period
STOP_TIME DATE
Y The stop time of the approval period
RESOURCE_ID NUMBER
Y The resource id
RECIPIENT_SEQUENCE NUMBER

The sequence of time recipients
CATEGORY_SEQUENCE NUMBER

The sequence of categories (within a time recipient)
CREATION_DATE DATE
Y The creation date of the approval period.
NOTIFICATION_STATUS VARCHAR2 (30) Y The status of the associated notification
APPROVER_ID NUMBER

The approver id
APPROVAL_COMP_ID NUMBER

The approval component id which caused the generation of this application period
APPROVAL_ITEM_TYPE VARCHAR2 (8)
Item Type corresponding to Notification
APPROVAL_PROCESS_NAME VARCHAR2 (30)
Notification Process
APPROVAL_ITEM_KEY VARCHAR2 (240)
Item Key Corresponding to Notification
DATA_SET_ID NUMBER (15)
Data Set Id

[top of page]

HXC.HXC_APP_PERIOD_SUMMARY does not reference any database object

HXC.HXC_APP_PERIOD_SUMMARY is referenced by following:

APPS
SYNONYM - HXC_APP_PERIOD_SUMMARY

[top of page]

Table: HXC_APP_PERIOD_SUMMARY_AR

Description: Application period summary archive table
Comments

The HXC_APP_PERIOD_SUMMARY_AR table holds the archived entries of HXC_APP_PERIOD_SUMMARY.

Indexes
Index Type Tablespace Column
HXC_APP_PERIOD_SUMMARY_AR_PK UNIQUE APPS_TS_ARCHIVE APPLICATION_PERIOD_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_PERIOD_ID NUMBER
Y The application period id
APPLICATION_PERIOD_OVN NUMBER
Y The application period object version number
APPROVAL_STATUS VARCHAR2 (30) Y The approval status
TIME_RECIPIENT_ID NUMBER
Y The time recipient id
TIME_CATEGORY_ID NUMBER

The time category id
START_TIME DATE
Y The start time of the approval period
STOP_TIME DATE
Y The stop time of the approval period
RESOURCE_ID NUMBER
Y The resource id
RECIPIENT_SEQUENCE NUMBER

The sequence of time recipients
CATEGORY_SEQUENCE NUMBER

The sequence of categories (within a time recipient)
CREATION_DATE DATE
Y The creation date of the approval period.
NOTIFICATION_STATUS VARCHAR2 (30) Y The status of the associated notification
APPROVER_ID NUMBER

The approver id
APPROVAL_COMP_ID NUMBER

The approval component id which caused the generation of this application period
APPROVAL_ITEM_TYPE VARCHAR2 (8)
Item Type corresponding to Notification
APPROVAL_PROCESS_NAME VARCHAR2 (30)
Notification Process
APPROVAL_ITEM_KEY VARCHAR2 (240)
Item Key Corresponding to Notification
DATA_SET_ID NUMBER (15)
Data Set Id

[top of page]

HXC.HXC_APP_PERIOD_SUMMARY_AR does not reference any database object

HXC.HXC_APP_PERIOD_SUMMARY_AR is referenced by following:

APPS
SYNONYM - HXC_APP_PERIOD_SUMMARY_AR

[top of page]

Table: HXC_AP_DETAIL_LINKS

Description: Application period detail links
Comments

The HXC_AP_DETAIL_LINKS table stores the sets of detail entries within a particular application period scope approval block. I.e. it is a fast mechanism to show the approver which entries they should be approving.

Indexes
Index Type Tablespace Column
HXC_AP_DETAIL_LINKS_PK UNIQUE APPS_TS_TX_IDX APPLICATION_PERIOD_ID
TIME_BUILDING_BLOCK_ID
HXC_AP_DETAIL_LINKS_N1 NONUNIQUE APPS_TS_TX_IDX TIME_BUILDING_BLOCK_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_PERIOD_ID NUMBER
Y The application period id
TIME_BUILDING_BLOCK_ID NUMBER
Y The detail time building block id in the HXC_TIME_BUILDING_BLOCKS table
TIME_BUILDING_BLOCK_OVN NUMBER
Y The object version number of the time building block in the HXC_TIME_BUILDING_BLOCKS table.

[top of page]

HXC.HXC_AP_DETAIL_LINKS does not reference any database object

HXC.HXC_AP_DETAIL_LINKS is referenced by following:

APPS
SYNONYM - HXC_AP_DETAIL_LINKS

[top of page]

Table: HXC_AP_DETAIL_LINKS_AR

Description: Application period detail links archive table
Comments

The HXC_AP_DETAIL_LINKS_AR table stores the sets of detail entries within a particular application period scope approval block. I.e. it is a fast mechanism to show the approver which entries they should be approving.

Indexes
Index Type Tablespace Column
HXC_AP_DETAIL_LINKS_AR_PK UNIQUE APPS_TS_ARCHIVE APPLICATION_PERIOD_ID
TIME_BUILDING_BLOCK_ID
HXC_AP_DETAIL_LINKS_AR_FK1 NONUNIQUE APPS_TS_ARCHIVE TIME_BUILDING_BLOCK_ID
Columns
Name Datatype Length Mandatory Comments
APPLICATION_PERIOD_ID NUMBER
Y The application period id
TIME_BUILDING_BLOCK_ID NUMBER
Y The detail time building block id in the HXC_TIME_BUILDING_BLOCKS table
TIME_BUILDING_BLOCK_OVN NUMBER
Y The object version number of the time building block in the HXC_TIME_BUILDING_BLOCKS table.

[top of page]

HXC.HXC_AP_DETAIL_LINKS_AR does not reference any database object

HXC.HXC_AP_DETAIL_LINKS_AR is referenced by following:

APPS
SYNONYM - HXC_AP_DETAIL_LINKS_AR

[top of page]

Table: HXC_ARCHIVE_TEMP

Description:
Comments
Primary Key: HXC_ARCHIVE_TEMP_PK
  1. DETAIL_ID
Indexes
Index Type Tablespace Column
HXC_ARCHIVE_TEMP_PK UNIQUE DETAIL_ID
HXC_ARCHIVE_TEMP_FK1 NONUNIQUE MASTER_ID
HXC_ARCHIVE_TEMP_FK2 NONUNIQUE THREAD_ID
Columns
Name Datatype Length Mandatory Comments
DETAIL_ID NUMBER (22) Y
MASTER_ID NUMBER (22)
REF_ROWID VARCHAR2 (20)
THREAD_ID NUMBER (22)

[top of page]

HXC.HXC_ARCHIVE_TEMP does not reference any database object

HXC.HXC_ARCHIVE_TEMP is referenced by following:

APPS
SYNONYM - HXC_ARCHIVE_TEMP

[top of page]

Table: HXC_AR_DETAIL_LOG

Description: For Multi-threaded A&R
Comments

For Multi-threaded A&R

Indexes
Index Type Tablespace Column
HXC_AR_DETAIL_LOG_FK NONUNIQUE APPS_TS_TX_IDX TIME_BUILDING_BLOCK_ID
Columns
Name Datatype Length Mandatory Comments
TIME_BUILDING_BLOCK_ID NUMBER (15)
Detail time building block id
OBJECT_VERSION_NUMBER NUMBER (15)
Detail OVN
PROCESS_TYPE VARCHAR2 (30)
Archive or Restore
THREAD_ID NUMBER (15)
Thread number
CHUNK_NUMBER NUMBER (15)
Chunk Number

[top of page]

HXC.HXC_AR_DETAIL_LOG does not reference any database object

HXC.HXC_AR_DETAIL_LOG is referenced by following:

APPS
SYNONYM - HXC_AR_DETAIL_LOG

[top of page]

Table: HXC_AR_TC_IDS_TEMP

Description: For Multi-threaded A&R
Primary Key: HXC_AR_TC_IDS_TEMP_PK
  1. TIME_BUILDING_BLOCK_ID
  2. OBJECT_VERSION_NUMBER
Comments

For Multi-threaded A&R

Indexes
Index Type Tablespace Column
HXC_AR_TC_IDS_TEMP_PK UNIQUE APPS_TS_TX_IDX TIME_BUILDING_BLOCK_ID
OBJECT_VERSION_NUMBER
Columns
Name Datatype Length Mandatory Comments
TIME_BUILDING_BLOCK_ID NUMBER (15) Y Time building block id
TYPE VARCHAR2 (30) Y type
MEASURE NUMBER (22)
measure
UNIT_OF_MEASURE VARCHAR2 (30)
UOM
START_TIME DATE

TC start time
STOP_TIME DATE

TC stop time
PARENT_BUILDING_BLOCK_ID NUMBER (15)
Parent bb id
PARENT_BUILDING_BLOCK_OVN NUMBER (9)
Parent bb ovn
SCOPE VARCHAR2 (30) Y Scope
OBJECT_VERSION_NUMBER NUMBER (9) Y OVN
CREATED_BY NUMBER (15)
Created by
CREATION_DATE DATE

Creation date
LAST_UPDATED_BY NUMBER (15)
WHO
LAST_UPDATE_DATE DATE

WHEN
LAST_UPDATE_LOGIN NUMBER (15)
Who
APPROVAL_STATUS VARCHAR2 (30) Y Approval Status
RESOURCE_ID NUMBER (15)
Resource Id
RESOURCE_TYPE VARCHAR2 (30)
Resource Type
APPROVAL_STYLE_ID NUMBER (15)
Not used
DATE_FROM DATE
Y Date from
DATE_TO DATE
Y Date To
COMMENT_TEXT VARCHAR2 (2000)
Comments
APPLICATION_SET_ID NUMBER (15)
Application Set
DATA_SET_ID NUMBER (15)
Data Set Id
TRANSLATION_DISPLAY_KEY VARCHAR2 (240)
Translation Display Key

[top of page]

HXC.HXC_AR_TC_IDS_TEMP does not reference any database object

HXC.HXC_AR_TC_IDS_TEMP is referenced by following:

APPS
SYNONYM - HXC_AR_TC_IDS_TEMP
TRIGGER - HXC_AR_TC_IDS_TEMP_WHO

[top of page]

Table: HXC_AR_TRANS_TEMP

Description: For Multi-threaded A&R
Comments

For Multi-threaded A&R

Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER (15)
Transacton Id
DATA_SET_ID NUMBER (15)
Data set Id
THREAD_ID NUMBER (15)
Thread Number
TRANS_ROWID VARCHAR2 (20)
Rowid

[top of page]

HXC.HXC_AR_TRANS_TEMP does not reference any database object

HXC.HXC_AR_TRANS_TEMP is referenced by following:

APPS
SYNONYM - HXC_AR_TRANS_TEMP

[top of page]

Table: HXC_BEE_PREF_ADJ_LINES

Description: Temp table for Xfer time from OTL to BEE
Comments

Stores the details which were once transferred to BEE/OTLR and now picked up for transfer again to OTLR/BEE because of a preference change.

Columns
Name Datatype Length Mandatory Comments
TIMECARD_ID NUMBER (15)
Time_building_block_id of timecard scope.
TIMECARD_OVN NUMBER (15)
OVN of the timecard
RESOURCE_ID NUMBER (15)
Resource id
DETAIL_BB_ID NUMBER (15)
time_building_block_id, of detail scope
DETAIL_BB_OVN NUMBER (15)
ovn of detail time_building_block_id
DATE_EARNED DATE

effective date for the earning
BATCH_SOURCE VARCHAR2 (15)
OTM or Time Store
TYPE VARCHAR2 (30)
type
SCOPE VARCHAR2 (30)
scope
HOURS NUMBER

hours measure
START_TIME DATE

detail start_time
STOP_TIME DATE

detail stop_time
RESOURCE_TYPE VARCHAR2 (30)
from hxc_time_building_blocks, for this detail building block, OVN
UOM VARCHAR2 (30)
from hxc_time_building_blocks, for this detail building block, OVN
CHANGED VARCHAR2 (1)
from hxc_time_building_blocks, for this detail building block, OVN
DELETED VARCHAR2 (1)
from hxc_time_building_blocks, for this detail building block, OVN
COMMENT_TEXT VARCHAR2 (2000)
from hxc_time_building_blocks, for this detail building block, OVN
PARENT_BB_ID NUMBER (15)
from hxc_time_building_blocks, for this detail building block, OVN

[top of page]

HXC.HXC_BEE_PREF_ADJ_LINES does not reference any database object

HXC.HXC_BEE_PREF_ADJ_LINES is referenced by following:

APPS
SYNONYM - HXC_BEE_PREF_ADJ_LINES

[top of page]

Table: HXC_BLD_BLK_INFO_TYPES

Description: Build Block Information Types
Primary Key: HXC_BUILD_BLK_INFO_TYPES_PK
  1. BLD_BLK_INFO_TYPE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_BLD_BLK_INFO_TYPE_USAGES.BLD_BLK_INFO_TYPE_ID HXC_BLD_BLK_INFO_TYPES
HXC_MAPPING_COMPONENTS.BLD_BLK_INFO_TYPE_ID HXC_BLD_BLK_INFO_TYPES
Comments

HXC_BLD_BLK_INFO_TYPES holds the definitions of the information types used to group together the attributes of Time Building Blocks.

Indexes
Index Type Tablespace Column
HXC_BUILD_BLK_INFO_TYPES_PK UNIQUE APPS_TS_TX_IDX BLD_BLK_INFO_TYPE_ID
HXC_BLD_BLK_INFO_TYPES_FK1 NONUNIQUE APPS_TS_TX_IDX BLD_BLK_INFO_TYPE
Columns
Name Datatype Length Mandatory Comments
BLD_BLK_INFO_TYPE_ID NUMBER (15) Y Primary Key from sequence
LEGISLATION_CODE VARCHAR2 (30)
Foreign Key to FND_TERRITORIES.
DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2 (80)
Name of the Descriptive FlexField associated with this Information Type.
BLD_BLK_INFO_TYPE VARCHAR2 (80)
The name of the Information Type.
MULTIPLE_OCCURENCES_FLAG VARCHAR2 (1)
Indicates whether or not multiple occurences of the same Information Type are allowed.
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
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
ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flexfield Column

[top of page]

HXC.HXC_BLD_BLK_INFO_TYPES does not reference any database object

HXC.HXC_BLD_BLK_INFO_TYPES is referenced by following:

APPS
SYNONYM - HXC_BLD_BLK_INFO_TYPES
TRIGGER - HXC_BLD_BLK_INFO_TYPES_WHO

[top of page]

Table: HXC_BLD_BLK_INFO_TYPE_USAGES

Description: Build Block Information Type Usages
Primary Key: HXC_BLD_BLK_INFO_TYPE_USAGE_PK
  1. BLD_BLK_INFO_TYPE_USAGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_BLD_BLK_INFO_TYPE_USAGES.BLD_BLK_INFO_TYPE_ID HXC_BLD_BLK_INFO_TYPES
Comments

HXC_BLD_BLK_INFO_TYPE_USAGES groups together Time Building Block Information Types into a specific category.

Indexes
Index Type Tablespace Column
HXC_BLD_BLK_INFO_TYPE_USAGE_PK UNIQUE APPS_TS_TX_IDX BLD_BLK_INFO_TYPE_USAGE_ID
HXC_BLD_BLK_INFO_TYPE_USGS_FK1 NONUNIQUE APPS_TS_TX_IDX BLD_BLK_INFO_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
BLD_BLK_INFO_TYPE_USAGE_ID NUMBER (15) Y Primary Key from sequence
BUILDING_BLOCK_CATEGORY VARCHAR2 (80)
Name of the Building Block Category.
BLD_BLK_INFO_TYPE_ID NUMBER (15) Y Foreign Key to HXC_BLD_BLK_INFO_TYPES.
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
OBJECT_VERSION_NUMBER NUMBER

Object Version Number

[top of page]

HXC.HXC_BLD_BLK_INFO_TYPE_USAGES does not reference any database object

HXC.HXC_BLD_BLK_INFO_TYPE_USAGES is referenced by following:

APPS
SYNONYM - HXC_BLD_BLK_INFO_TYPE_USAGES
TRIGGER - HXC_BLD_BLK_INFO_TYPE_USAG_WHO

[top of page]

Table: HXC_DATA_APP_RULE_USAGES

Description: Data Approval Rule Usages
Primary Key: HXC_DATA_APP_RULE_USAGES_PK
  1. DATA_APP_RULE_USAGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_DATA_APP_RULE_USAGES.TIME_ENTRY_RULE_ID HXC_TIME_ENTRY_RULES
HXC_DATA_APP_RULE_USAGES.APPROVAL_STYLE_ID HXC_APPROVAL_STYLES
HXC_DATA_APP_RULE_USAGES.TIME_RECIPIENT_ID HXC_TIME_RECIPIENTS
Comments

HXC_DATA_APP_RULE_USAGES associates Approval Rules with a defined Approval Style. If the Approval Rules determine that approval is required, the HXC_APPROVAL_COMPONENTS table will be consulted to determine which approval mechanism will be used.

Indexes
Index Type Tablespace Column
HXC_DATA_APP_RULE_USAGES_PK UNIQUE APPS_TS_TX_IDX DATA_APP_RULE_USAGE_ID
HXC_DATA_APP_RULE_USAGES_FK1 NONUNIQUE APPS_TS_TX_IDX TIME_ENTRY_RULE_ID
HXC_DATA_APP_RULE_USAGES_FK2 NONUNIQUE APPS_TS_TX_IDX APPROVAL_STYLE_ID
HXC_DATA_APP_RULE_USAGES_FK3 NONUNIQUE APPS_TS_TX_IDX TIME_RECIPIENT_ID
Columns
Name Datatype Length Mandatory Comments
DATA_APP_RULE_USAGE_ID NUMBER (15) Y Primary Key from sequence
APPROVAL_STYLE_ID NUMBER (15) Y Foreign Key to HXC_APPROVAL_STYLES.
TIME_ENTRY_RULE_ID NUMBER (15) Y Foreign Key to HXC_TIME_ENTRY_RULES.
TIME_RECIPIENT_ID NUMBER (15) Y Foreign Key to HXC_TIME_RECIPIENTS.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

HXC.HXC_DATA_APP_RULE_USAGES does not reference any database object

HXC.HXC_DATA_APP_RULE_USAGES is referenced by following:

APPS
SYNONYM - HXC_DATA_APP_RULE_USAGES
TRIGGER - HXC_DATA_APP_RULE_USAGES_WHO

[top of page]

Table: HXC_DATA_SETS

Description: HXC_DATA_SETS
Comments

Used to mark the data in otl tables as per the date range

Indexes
Index Type Tablespace Column
HXC_DATA_SETS_PK UNIQUE APPS_TS_TX_IDX DATA_SET_ID
Columns
Name Datatype Length Mandatory Comments
DATA_SET_ID NUMBER (15) Y Primary Key
DATA_SET_NAME VARCHAR2 (80) Y Name for the data set
DESCRIPTION VARCHAR2 (150)
Description for the data set
START_DATE DATE
Y Start date of the data set range
END_DATE DATE
Y End date of the data set range
DATA_SET_MODE VARCHAR2 (10) Y Type of the backup mechanism used
STATUS VARCHAR2 (20) Y Staus of the data set, online or offline
CREATED_BY NUMBER (15)
Standard who column- who created the record
CREATION_DATE DATE

Standard who column - date when this row was created
LAST_UPDATED_BY NUMBER (15)
Standard who column - user id who updated the record
LAST_UPDATE_DATE DATE

Standard who column - date when this row was last updated
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - login id of last update
VALIDATION_STATUS VARCHAR2 (1)
Validation Status of the Data Set

[top of page]

HXC.HXC_DATA_SETS does not reference any database object

HXC.HXC_DATA_SETS is referenced by following:

APPS
SYNONYM - HXC_DATA_SETS
TRIGGER - HXC_DATA_SETS_WHO

[top of page]

Table: HXC_DATA_SET_DETAILS

Description: HXC_DATA_SET_DETAILS
Comments

Used to store the count of records archived in each table for each data set.

Indexes
Index Type Tablespace Column
HXC_DATA_SET_ID_PK UNIQUE APPS_TS_TX_IDX DATA_SET_ID
Columns
Name Datatype Length Mandatory Comments
DATA_SET_ID NUMBER (15) Y Data Set Id
TABLE_NAME VARCHAR2 (30) Y Name of the table which is archived
ROW_COUNT NUMBER (10)
Number of rows archived for the given table
SCOPE VARCHAR2 (30)
Scope
CREATED_BY NUMBER (15)
Standard who column- who created the record
CREATION_DATE DATE

Standard who column - date when this row was created
LAST_UPDATED_BY NUMBER (15)
Standard who column - user id who updated the record
LAST_UPDATE_DATE DATE

Standard who column - date when this row was last updated
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - login id of last update

[top of page]

HXC.HXC_DATA_SET_DETAILS does not reference any database object

HXC.HXC_DATA_SET_DETAILS is referenced by following:

APPS
SYNONYM - HXC_DATA_SET_DETAILS
TRIGGER - HXC_DATA_SET_DETAILS_WHO

[top of page]

Table: HXC_DEBUG

Description: Debug
Comments

HXC_DEBUG is used to control the use of hr_utility.trace for a process - the trace allows for a process to be debugged.

Columns
Name Datatype Length Mandatory Comments
PROCESS VARCHAR2 (30)
The name of the Process for which Debug Information is present
DEBUG_DATE DATE

The Date on which the debug row was inserted

[top of page]

HXC.HXC_DEBUG does not reference any database object

HXC.HXC_DEBUG is referenced by following:

APPS
SYNONYM - HXC_DEBUG

[top of page]

Table: HXC_DEBUG_TEXT

Description: Debug Text
Comments

HXC_DEBUG_TEXT is a generic table that stores debug information from a particular process.

Columns
Name Datatype Length Mandatory Comments
PROCESS VARCHAR2 (30)
The name of the Process for which Debug Information is present
TYPE VARCHAR2 (15)
The Type of Debug Information
TEXT LONG (0)
Debug Information text

[top of page]

HXC.HXC_DEBUG_TEXT does not reference any database object

HXC.HXC_DEBUG_TEXT is referenced by following:

APPS
SYNONYM - HXC_DEBUG_TEXT

[top of page]

Table: HXC_DEPOSIT_PROCESSES

Description: Deposit Processes
Primary Key: HXC_DEPOSIT_PROCESSES_PK
  1. DEPOSIT_PROCESS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_DEPOSIT_PROCESSES.TIME_SOURCE_ID HXC_TIME_SOURCES
HXC_DEPOSIT_PROCESSES.MAPPING_ID HXC_MAPPINGS
Comments

HXC_DEPOSIT_PROCESSES holds descriptions of the Deposit Processes defined in the Time Store. Every source of Time Information which can deposit data in the Time Store must do so through a defined Deposit Process.

Indexes
Index Type Tablespace Column
HXC_DEPOSIT_PROCESSES_PK UNIQUE APPS_TS_TX_IDX DEPOSIT_PROCESS_ID
HXC_DEPOSIT_PROCESSES_FK1 NONUNIQUE APPS_TS_TX_IDX TIME_SOURCE_ID
Columns
Name Datatype Length Mandatory Comments
DEPOSIT_PROCESS_ID NUMBER (15) Y Primary Key from sequence
NAME VARCHAR2 (80) Y Name of the Deposit Process.
TIME_SOURCE_ID NUMBER (15) Y Foreign Key to HXC_TIME_SOURCES.
MAPPING_ID NUMBER
Y Foreign Key to HXC_MAPPINGS.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

HXC.HXC_DEPOSIT_PROCESSES does not reference any database object

HXC.HXC_DEPOSIT_PROCESSES is referenced by following:

APPS
SYNONYM - HXC_DEPOSIT_PROCESSES
TRIGGER - HXC_DEPOSIT_PROCESSES_WHO

[top of page]

Table: HXC_ENTITY_GROUPS

Description: Entity Groups
Primary Key: HXC_ENTITY_GROUPS_PK
  1. ENTITY_GROUP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_ENTITY_GROUP_COMPS.ENTITY_GROUP_ID HXC_ENTITY_GROUPS
Comments

HXC_ENTITY_GROUPS - groups together entities as identified in the HXC_ENTITY_GROUP_COMPS

Indexes
Index Type Tablespace Column
HXC_ENTITY_GROUPS_PK UNIQUE APPS_TS_TX_IDX ENTITY_GROUP_ID
HXC_ENTITY_GROUPS_UK1 UNIQUE APPS_TS_TX_IDX ENTITY_TYPE
NAME
BUSINESS_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
ENTITY_GROUP_ID NUMBER (15) Y Primary Key from sequence
NAME VARCHAR2 (80) Y Name of entity group
ENTITY_TYPE VARCHAR2 (30) Y Entity type, from hr_lookups with DATA_APPROVAL, DEPOSIT_PROCESS and RETRIEVAL_PROCESS values.
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
DESCRIPTION VARCHAR2 (150)
Entity Group Description
BUSINESS_GROUP_ID NUMBER (15)
Business Group Id
LEGISLATION_CODE VARCHAR2 (30)
Legislation Code

[top of page]

HXC.HXC_ENTITY_GROUPS does not reference any database object

HXC.HXC_ENTITY_GROUPS is referenced by following:

APPS
SYNONYM - HXC_ENTITY_GROUPS
TRIGGER - HXC_ENTITY_GROUPS_WHO

[top of page]

Table: HXC_ENTITY_GROUP_COMPS

Description: Entity Group Components
Primary Key: HXC_ENTITY_GROUP_COMPS_PK
  1. ENTITY_GROUP_COMP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_ENTITY_GROUP_COMPS.ENTITY_GROUP_ID HXC_ENTITY_GROUPS
Comments

HXC_ENTITY_GROUP_COMPS - Identifies the components in an hxc_entity_group. The entity is identified by the identity type

Indexes
Index Type Tablespace Column
HXC_ENTITY_GROUP_COMPS_PK UNIQUE APPS_TS_TX_IDX ENTITY_GROUP_COMP_ID
HXC_ENTITY_GROUP_COMPS_FK1 NONUNIQUE APPS_TS_TX_IDX ENTITY_GROUP_ID
HXC_ENTITY_GROUP_COMPS_N1 NONUNIQUE APPS_TS_TX_IDX ENTITY_ID
HXC_ENTITY_GROUP_COMPS_N2 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE1
HXC_ENTITY_GROUP_COMPS_N3 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE2
Columns
Name Datatype Length Mandatory Comments
ENTITY_GROUP_COMP_ID NUMBER (15) Y Primary Key from Sequence
ENTITY_GROUP_ID NUMBER (15) Y Foreign Key to hxc_entity_groups
ENTITY_ID NUMBER (15) Y The entity which is used in the grouping. Foreign key to HXC_TIME_ENTRY_RULES or HXC_TIME_RECIPIENTS or HXC_RETRIEVAL_RULES
ENTITY_TYPE VARCHAR2 (30) Y The type associted with the entity_id, based on hr_lookups with valid value of TIME_ENTRY_RULES, RETRIEVAL_RULES and TIME_RECIPIENTS
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
ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flexfield Column
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

HXC.HXC_ENTITY_GROUP_COMPS does not reference any database object

HXC.HXC_ENTITY_GROUP_COMPS is referenced by following:

APPS
SYNONYM - HXC_ENTITY_GROUP_COMPS
TRIGGER - HXC_ENTITY_GROUP_COMPS_WHO

[top of page]

Table: HXC_ERRORS

Description: hxc_errors
Primary Key: HXC_ERRORS_PK
  1. ERROR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_ERRORS.TIME_BUILDING_BLOCK_ID
HXC_ERRORS.TIME_BUILDING_BLOCK_OVN 		HXC_TIME_BUILDING_BLOCKS
HXC_ERRORS.TIME_ATTRIBUTE_ID HXC_TIME_ATTRIBUTES
Comments

HXC_ERRORS stores information about the errors attached to a timecard.

Indexes
Index Type Tablespace Column
HXC_ERRORS_PK UNIQUE APPS_TS_TX_IDX ERROR_ID
HXC_ERRORS_N1 NONUNIQUE APPS_TS_TX_IDX TIME_BUILDING_BLOCK_ID
TIME_BUILDING_BLOCK_OVN
Columns
Name Datatype Length Mandatory Comments
ERROR_ID NUMBER (15) Y Primary Key
TRANSACTION_DETAIL_ID NUMBER (15) Y Foreign Key with hxc_transaction_details table
TIME_BUILDING_BLOCK_ID NUMBER (15) Y Foreign Key with HXC_TIME_BUILING_BLOCKS table
TIME_BUILDING_BLOCK_OVN NUMBER (9) Y Foreign Key with HXC_TIME_BUILING_BLOCKS table
TIME_ATTRIBUTE_ID NUMBER (15)
Foreign Key with HXC_TIME_ATTRIBUTES table
TIME_ATTRIBUTE_OVN NUMBER (9)
Foreign Key with HXC_TIME_ATTRIBUTES table
MESSAGE_NAME VARCHAR2 (30)
Contain the message name
MESSAGE_LEVEL VARCHAR2 (30)
Contain the message level
MESSAGE_FIELD VARCHAR2 (80)
Contain the message field
MESSAGE_TOKENS VARCHAR2 (4000)
Contain the message tokens
APPLICATION_SHORT_NAME VARCHAR2 (50)
Contain the application short name of the message
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
DATE_FROM DATE

Effective Start Date
DATE_TO DATE

Effective End Date

[top of page]

HXC.HXC_ERRORS does not reference any database object

HXC.HXC_ERRORS is referenced by following:

APPS
SYNONYM - HXC_ERRORS
TRIGGER - HXC_ERRORS_WHO

[top of page]

Table: HXC_LATEST_DETAILS

Description: Summary table containing the latest version of a DETAIL scope building block
Comments

Summary table containing the latest version of a DETAIL scope building block

Indexes
Index Type Tablespace Column
HXC_LATEST_DETAILS_FK UNIQUE APPS_TS_TX_IDX TIME_BUILDING_BLOCK_ID
HXC_LASTEST_DETAILS_N3 NONUNIQUE APPS_TS_TX_IDX RESOURCE_ID
LAST_UPDATE_DATE
START_TIME
STOP_TIME
HXC_LATEST_DETAILS_N1 NONUNIQUE APPS_TS_TX_IDX RESOURCE_ID
START_TIME
STOP_TIME
HXC_LATEST_DETAILS_N2 NONUNIQUE APPS_TS_TX_IDX LAST_UPDATE_DATE
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER (15) Y Resource id denormalised from the HXC_TIME_BUILDING_BLOCKS table for this time building block id
TIME_BUILDING_BLOCK_ID NUMBER (15) Y Time building block id
OBJECT_VERSION_NUMBER NUMBER (9) Y Latest object version number of the time building block
APPROVAL_STATUS VARCHAR2 (30) Y Latest approval status denormalised from the HXC_TIME_BUILDING_BLOCKS table for this time building block id
START_TIME DATE
Y The DAY start time this time building block is associated with
STOP_TIME DATE
Y The DAY stop time this time building block is associated with
APPLICATION_SET_ID NUMBER (15)
The application set id of this time building block
LAST_UPDATE_DATE DATE
Y Last Update Date denormalised from the HXC_TIME_BUILDING_BLOCKS table for this time building block id
RESOURCE_TYPE VARCHAR2 (30)
Resource Type denormalised from the HXC_TIME_BUILDING_BLOCKS table for this time building block id
COMMENT_TEXT VARCHAR2 (2000)
Comment Text denormalised from the HXC_TIME_BUILDING_BLOCKS table for this time building block id

[top of page]

HXC.HXC_LATEST_DETAILS does not reference any database object

HXC.HXC_LATEST_DETAILS is referenced by following:

APPS
SYNONYM - HXC_LATEST_DETAILS

[top of page]

Table: HXC_LAYOUTS

Description: Layouts
Primary Key: HXC_LAYOUTS_PK
  1. LAYOUT_ID
Primary Key: HXC_LAYOUTS_UK1
  1. APPLICATION_ID
  2. LAYOUT_NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_LAYOUTS_TL.LAYOUT_ID HXC_LAYOUTS
HXC_LAYOUT_COMPONENTS.LAYOUT_ID HXC_LAYOUTS
Comments

HXC_LAYOUTS stores information about an instance of a UI configuration used in the Self-service timecard.

Indexes
Index Type Tablespace Column
HXC_LAYOUTS_PK UNIQUE APPS_TS_TX_IDX LAYOUT_ID
HXC_LAYOUTS_UK1 UNIQUE APPS_TS_TX_IDX APPLICATION_ID
LAYOUT_NAME
Columns
Name Datatype Length Mandatory Comments
LAYOUT_ID NUMBER (15) Y System generated primary key from HR_LAYOUTS_S.
LAYOUT_NAME VARCHAR2 (30) Y Developer Key for the layout name
APPLICATION_ID NUMBER (15) Y The application owning this layout
LAYOUT_TYPE VARCHAR2 (30) Y The type of layout, determined by lookup.
MODIFIER_LEVEL VARCHAR2 (30)
Indicates the scope of the layout.
MODIFIER_VALUE VARCHAR2 (240)
The value associated with this modifier level
TOP_LEVEL_REGION_CODE VARCHAR2 (30)
The top level AK region associted with this page.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
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.

[top of page]

HXC.HXC_LAYOUTS does not reference any database object

HXC.HXC_LAYOUTS is referenced by following:

APPS
SYNONYM - HXC_LAYOUTS
TRIGGER - HXC_LAYOUTS_WHO

[top of page]

Table: HXC_LAYOUTS_TL

Description: Translated Layouts
Primary Key: HXC_LAYOUTS_TL_PK
  1. LANGUAGE
  2. LAYOUT_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_LAYOUTS_TL.LAYOUT_ID HXC_LAYOUTS
Comments

HXC_LAYOUTS_TL stores the translated display names for layouts.

Indexes
Index Type Tablespace Column
HXC_LAYOUTS_TL_PK UNIQUE APPS_TS_TX_IDX LANGUAGE
LAYOUT_ID
HXC_LAYOUTS_TL_FK1 NONUNIQUE APPS_TS_TX_IDX LAYOUT_ID
Columns
Name Datatype Length Mandatory Comments
LAYOUT_ID NUMBER (15) Y Foreign Key to HXC_LAYOUTS
DISPLAY_LAYOUT_NAME VARCHAR2 (240) Y Translated Layout Name
LANGUAGE VARCHAR2 (4) Y Defined Language
SOURCE_LANG VARCHAR2 (4) Y Actual Language
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.

[top of page]

HXC.HXC_LAYOUTS_TL does not reference any database object

HXC.HXC_LAYOUTS_TL is referenced by following:

APPS
SYNONYM - HXC_LAYOUTS_TL
TRIGGER - HXC_LAYOUTS_TL041257_WHO

[top of page]

Table: HXC_LAYOUT_COMPONENTS

Description: Layout Components
Primary Key: HXC_LAYOUT_COMPONENTS_PK
  1. LAYOUT_COMPONENT_ID
Primary Key: HXC_LAYOUT_COMPONENTS_UK1
  1. COMPONENT_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_LAYOUT_COMPONENTS.LAYOUT_ID HXC_LAYOUTS
HXC_LAYOUT_COMPONENTS.PARENT_COMPONENT_ID HXC_LAYOUT_COMPONENTS
HXC_LAYOUT_COMPONENTS.LAYOUT_COMP_DEFINITION_ID HXC_LAYOUT_COMP_DEFINITIONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_LAYOUT_COMPONENTS.PARENT_COMPONENT_ID HXC_LAYOUT_COMPONENTS
HXC_LAYOUT_COMP_PROMPTS.LAYOUT_COMPONENT_ID HXC_LAYOUT_COMPONENTS
HXC_LAYOUT_COMP_QUALIFIERS.LAYOUT_COMPONENT_ID HXC_LAYOUT_COMPONENTS
Comments

HXC_LAYOUT_COMPONENTS stores the set of UI components associated with an OTL timecard, or in genera,l a Self-Service screen

Indexes
Index Type Tablespace Column
HXC_LAYOUT_COMPONENTS_PK UNIQUE APPS_TS_TX_IDX LAYOUT_COMPONENT_ID
HXC_LAYOUT_COMPONENTS_FK1 NONUNIQUE APPS_TS_TX_IDX LAYOUT_ID
HXC_LAYOUT_COMPONENTS_FK2 NONUNIQUE APPS_TS_TX_IDX PARENT_COMPONENT_ID
HXC_LAYOUT_COMPONENTS_FK3 NONUNIQUE APPS_TS_TX_IDX LAYOUT_COMP_DEFINITION_ID
Columns
Name Datatype Length Mandatory Comments
LAYOUT_COMPONENT_ID NUMBER (15) Y System generated primary key
LAYOUT_ID NUMBER (15) Y Foreign key to HXC_LAYOUTS.
LAYOUT_COMP_DEFINITION_ID NUMBER (15) Y Foreign key to HXC_LAYOUT_COMP_DEFINITIONS.
PARENT_COMPONENT_ID NUMBER (15)
Self Referential column, effectively specifies the scope of the UI component
COMPONENT_NAME VARCHAR2 (240)
Name given to the component configuration.
COMPONENT_VALUE VARCHAR2 (240)
Component value
SEQUENCE NUMBER (9) Y Sequence for the UI components comprising the layout.
NAME_VALUE_STRING VARCHAR2 (2000)
Parameters available to the UI administrator.
REGION_CODE VARCHAR2 (30)
AK region code associated with the UI components.
REGION_CODE_APP_ID NUMBER (15)
Region application id, associated with the region code. This forms a primary key to AK_REGIONS
ATTRIBUTE_CODE VARCHAR2 (30)
Attribute code
ATTRIBUTE_CODE_APP_ID NUMBER (15)
Application associted with the attribute code.
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).
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
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.
COMPONENT_ALIAS VARCHAR2 (240)
Component Alias
PARENT_BEAN VARCHAR2 (240)
Parent Bean
ATTRIBUTE1 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (240)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (240)
Descriptive flexfield segment

[top of page]

HXC.HXC_LAYOUT_COMPONENTS does not reference any database object

HXC.HXC_LAYOUT_COMPONENTS is referenced by following:

APPS
SYNONYM - HXC_LAYOUT_COMPONENTS
TRIGGER - HXC_LAYOUT_COMPONENTS_WHO

[top of page]

Table: HXC_LAYOUT_COMP_DEFINITIONS

Description: Layout Component Definitions
Primary Key: HXC_LAYOUT_COMP_DEFINITIONS_PK
  1. LAYOUT_COMP_DEFINITION_ID
Primary Key: HXC_LAYOUT_COMP_DEFINITIONS_UK
  1. COMPONENT_TYPE
  2. RENDER_TYPE
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_LAYOUT_COMPONENTS.LAYOUT_COMP_DEFINITION_ID HXC_LAYOUT_COMP_DEFINITIONS
Comments

HXC_LAYOUT_COMP_DEFINITIONS holds the definitions of the set of UI components that can be associated with a UI layout.

Indexes
Index Type Tablespace Column
HXC_LAYOUT_COMP_DEFINITIONS_PK UNIQUE APPS_TS_TX_IDX LAYOUT_COMP_DEFINITION_ID
HXC_LAYOUT_COMP_DEFINITIONS_UK UNIQUE APPS_TS_TX_IDX COMPONENT_TYPE
RENDER_TYPE
Columns
Name Datatype Length Mandatory Comments
LAYOUT_COMP_DEFINITION_ID NUMBER (15) Y System generated primary key
COMPONENT_TYPE VARCHAR2 (30)
Type of UI component
COMPONENT_CLASS VARCHAR2 (240) Y Java class associated with the UI component
RENDER_TYPE VARCHAR2 (30) Y Rendering Type
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
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.

[top of page]

HXC.HXC_LAYOUT_COMP_DEFINITIONS does not reference any database object

HXC.HXC_LAYOUT_COMP_DEFINITIONS is referenced by following:

APPS
SYNONYM - HXC_LAYOUT_COMP_DEFINITIONS
TRIGGER - HXC_LAYOUT_COMP_DEFINITION_WHO

[top of page]

Table: HXC_LAYOUT_COMP_PROMPTS

Description: Layout Component Prompts
Primary Key: HXC_LAYOUT_COMP_PROMPTS_PK
  1. LAYOUT_COMP_PROMPT_ID
Primary Key: HXC_LAYOUT_COMP_PROMPTS_UK1
  1. LAYOUT_COMPONENT_ID
  2. PROMPT_ALIAS
  3. PROMPT_TYPE
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_LAYOUT_COMP_PROMPTS.LAYOUT_COMPONENT_ID HXC_LAYOUT_COMPONENTS
Comments

HXC_LAYOUT_COMP_PROMPTS stores the set of prompts to the UI components included in the UI layout.

Indexes
Index Type Tablespace Column
HXC_LAYOUT_COMP_PROMPTS_PK UNIQUE APPS_TS_TX_IDX LAYOUT_COMP_PROMPT_ID
HXC_LAYOUT_COMP_PROMPTS_UK1 UNIQUE APPS_TS_TX_IDX LAYOUT_COMPONENT_ID
PROMPT_ALIAS
PROMPT_TYPE
Columns
Name Datatype Length Mandatory Comments
LAYOUT_COMP_PROMPT_ID NUMBER (15) Y System generated primary key
LAYOUT_COMPONENT_ID NUMBER (15) Y Foreign key to HXC_LAYOUT_COMPONENTS
PROMPT_ALIAS VARCHAR2 (80) Y Prompt Alias
PROMPT_TYPE VARCHAR2 (30) Y Prompt Type
REGION_CODE VARCHAR2 (30)
Region Code
REGION_APPLICATION_ID NUMBER (15)
The application associted with the region code
ATTRIBUTE_CODE VARCHAR2 (30) Y Attribute Code
ATTRIBUTE_APPLICATION_ID NUMBER (15) Y The application associted with the attribute
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
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.

[top of page]

HXC.HXC_LAYOUT_COMP_PROMPTS does not reference any database object

HXC.HXC_LAYOUT_COMP_PROMPTS is referenced by following:

APPS
SYNONYM - HXC_LAYOUT_COMP_PROMPTS
TRIGGER - HXC_LAYOUT_COMP_PROMPTS_WHO

[top of page]

Table: HXC_LAYOUT_COMP_QUALIFIERS

Description: Layout Component Qualifiers
Primary Key: HXC_LAYOUT_COMP_QUALIFIERS_PK
  1. LAYOUT_COMP_QUALIFIER_ID
Primary Key: HXC_LAYOUT_COMP_QUALIFIERS_UK1
  1. QUALIFIER_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_LAYOUT_COMP_QUALIFIERS.LAYOUT_COMPONENT_ID HXC_LAYOUT_COMPONENTS
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_LAYOUT_COMP_QUAL_RULES.LAYOUT_COMP_QUALIFIER_ID HXC_LAYOUT_COMP_QUALIFIERS
Comments

HXC_LAYOUT_COMP_QUALIFIERS stores the set of qualifiers to the UI components included in the UI layout.

Indexes
Index Type Tablespace Column
HXC_LAYOUT_COMP_QUALIFIERS_PK UNIQUE APPS_TS_TX_IDX LAYOUT_COMP_QUALIFIER_ID
HXC_LAYOUT_COMP_QUALIFIERS_FK1 NONUNIQUE APPS_TS_TX_IDX LAYOUT_COMPONENT_ID
Columns
Name Datatype Length Mandatory Comments
LAYOUT_COMP_QUALIFIER_ID NUMBER (15) Y System generated primary key
QUALIFIER_NAME VARCHAR2 (240) Y Qualifier name
QUALIFIER_ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield context
QUALIFIER_ATTRIBUTE1 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE2 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE3 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE4 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE5 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE6 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE7 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE8 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE9 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE10 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE11 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE12 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE13 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE14 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE15 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE16 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE17 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE18 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE19 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE20 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE21 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE22 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE23 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE24 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE25 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE26 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE27 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE28 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE29 VARCHAR2 (240)
Descriptive Flexfield Column
QUALIFIER_ATTRIBUTE30 VARCHAR2 (240)
Descriptive Flexfield Column
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
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.
LAYOUT_COMPONENT_ID NUMBER
Y Foreign key to HXC_LAYOUT_COMPONENTS

[top of page]

HXC.HXC_LAYOUT_COMP_QUALIFIERS does not reference any database object

HXC.HXC_LAYOUT_COMP_QUALIFIERS is referenced by following:

APPS
SYNONYM - HXC_LAYOUT_COMP_QUALIFIERS
TRIGGER - HXC_LAYOUT_COMP_QUALIFIERS_WHO

[top of page]

Table: HXC_LAYOUT_COMP_QUAL_RULES

Description: Layout Component Qualifier Rules
Primary Key: HXC_LAYOUT_COMP_QUAL_RULES_PK
  1. LAYOUT_COMP_QUAL_RULE_ID
Primary Key: HXC_LAYOUT_COMP_QUAL_RULES_UK1
  1. RULE_NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_LAYOUT_COMP_QUAL_RULES.LAYOUT_COMP_QUALIFIER_ID HXC_LAYOUT_COMP_QUALIFIERS
Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Columns
Name Datatype Length Mandatory Comments
LAYOUT_COMP_QUAL_RULE_ID NUMBER (15) Y System generated primary key
RULE_NAME VARCHAR2 (240) Y Developer key for the layout name
RULE_TYPE VARCHAR2 (30) Y Rule type: (S) SQL statement, (O) OTL Preference, (P) Profile, (F) Fastformula.
RULE_DETAIL VARCHAR2 (2000)
Rule detail
RULE_VALUE VARCHAR2 (2000)
The value to which the rule must evaluate to for a true result. r O and P rule types only.
LAYOUT_COMP_QUALIFIER_ID NUMBER (15) Y Foreign key to HXC_LAYOUT_COMP_QUALIFIERS
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
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.

[top of page]

HXC.HXC_LAYOUT_COMP_QUAL_RULES does not reference any database object

HXC.HXC_LAYOUT_COMP_QUAL_RULES is referenced by following:

APPS
SYNONYM - HXC_LAYOUT_COMP_QUAL_RULES
TRIGGER - HXC_LAYOUT_COMP_QUAL_RULES_WHO

[top of page]

Table: HXC_LOCKER_TYPES

Description: HXC_LOCKER_TYPES holds the locker type components.
Primary Key: HXC_LOCKER_TYPES_PK
  1. LOCKER_TYPE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_LOCKING_RULES.LOCKER_TYPE_OWNER_ID HXC_LOCKER_TYPES
HXC_LOCKING_RULES.LOCKER_TYPE_REQUESTOR_ID HXC_LOCKER_TYPES
HXC_LOCKS.LOCKER_TYPE_ID HXC_LOCKER_TYPES
Comments

HXC_LOCKER_TYPES holds the locker types. These types are linked to different process type..

Indexes
Index Type Tablespace Column
HXC_LOCKER_TYPES_PK UNIQUE APPS_TS_SEED LOCKER_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
LOCKER_TYPE_ID NUMBER (15) Y Primary Key from associated sequence
LOCKER_TYPE VARCHAR2 (80) Y Lock Type : Self-service, pui or plsql
PROCESS_TYPE VARCHAR2 (80) Y Process Type: Timecard Action, Timecard View, Approval Action, Timekeeper Action, Retrieval Action and Deposit Action
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

HXC.HXC_LOCKER_TYPES does not reference any database object

HXC.HXC_LOCKER_TYPES is referenced by following:

APPS
SYNONYM - HXC_LOCKER_TYPES
TRIGGER - HXC_LOCKER_TYPES_WHO

[top of page]

Table: HXC_LOCKING_RULES

Description: HXC_LOCKING_RULES holds the locking rules components.
Primary Key: HXC_LOCKING_RULES_PK
  1. LOCKER_TYPE_OWNER_ID
  2. LOCKER_TYPE_REQUESTOR_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_LOCKING_RULES.LOCKER_TYPE_OWNER_ID HXC_LOCKER_TYPES
HXC_LOCKING_RULES.LOCKER_TYPE_REQUESTOR_ID HXC_LOCKER_TYPES
Comments

HXC_LOCKING_RULES holds the locking rules components. For a locker type owner and a locker type requestor this table tells if the lock can be granted.

Indexes
Index Type Tablespace Column
HXC_LOCKING_RULES_PK UNIQUE APPS_TS_SEED LOCKER_TYPE_OWNER_ID
LOCKER_TYPE_REQUESTOR_ID
HXC_LOCKING_RULES_FK2 NONUNIQUE APPS_TS_SEED LOCKER_TYPE_REQUESTOR_ID
Columns
Name Datatype Length Mandatory Comments
LOCKER_TYPE_OWNER_ID NUMBER (15) Y Primary Key from hxc_locker_types reference
LOCKER_TYPE_REQUESTOR_ID NUMBER (15) Y Primary Key from hxc_locker_types reference
GRANT_LOCK VARCHAR2 (1)
Grant Lock tells if the lock can be granted
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

HXC.HXC_LOCKING_RULES does not reference any database object

HXC.HXC_LOCKING_RULES is referenced by following:

APPS
SYNONYM - HXC_LOCKING_RULES
TRIGGER - HXC_LOCKING_RULES_WHO

[top of page]

Table: HXC_LOCKS

Description: HXC_LOCKS holds the locks components.
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_LOCKS.LOCKER_TYPE_ID HXC_LOCKER_TYPES
HXC_LOCKS.TIME_BUILDING_BLOCK_ID
HXC_LOCKS.TIME_BUILDING_BLOCK_OVN 		HXC_TIME_BUILDING_BLOCKS
Comments

HXC_LOCKS holds the locks components.

Indexes
Index Type Tablespace Column
HXC_LOCKS_FK1 NONUNIQUE APPS_TS_TX_IDX LOCKER_TYPE_ID
HXC_LOCKS_FK2 NONUNIQUE APPS_TS_TX_IDX TIME_BUILDING_BLOCK_ID
TIME_BUILDING_BLOCK_OVN
HXC_LOCKS_N1 NONUNIQUE APPS_TS_TX_IDX RESOURCE_ID
START_TIME
STOP_TIME
HXC_LOCKS_N2 NONUNIQUE APPS_TS_TX_IDX TRANSACTION_LOCK_ID
LOCKER_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
LOCKER_TYPE_ID NUMBER (15) Y Reference to hxc_locker_types pk.
RESOURCE_ID NUMBER (15)
Resource id of the lock
START_TIME DATE

Start Time of the lock
STOP_TIME DATE

Stop Time of the lock.
TIME_BUILDING_BLOCK_ID NUMBER (15)
Time building block id of the lock
TIME_BUILDING_BLOCK_OVN NUMBER (15)
Time building block ovn
TRANSACTION_LOCK_ID NUMBER (15)
Transaction Lock Id
LOCK_DATE DATE

Date of the lock
PROCESS_ID NUMBER (15)
This column stores the process locker id
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE21 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE22 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE23 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE24 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE25 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE26 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE27 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE28 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE29 VARCHAR2 (80)
Descriptive flexfield segment
ATTRIBUTE30 VARCHAR2 (80)
Descriptive flexfield segment

[top of page]

HXC.HXC_LOCKS does not reference any database object

HXC.HXC_LOCKS is referenced by following:

APPS
SYNONYM - HXC_LOCKS

[top of page]

Table: HXC_MAPPINGS

Description: Mappings
Primary Key: HXC_MAPPINGS_PK
  1. MAPPING_ID
Primary Key: HXC_MAPPINGS_UK1
  1. NAME
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_DEPOSIT_PROCESSES.MAPPING_ID HXC_MAPPINGS
HXC_MAPPING_COMP_USAGES.MAPPING_ID HXC_MAPPINGS
HXC_RETRIEVAL_PROCESSES.MAPPING_ID HXC_MAPPINGS
HXC_TIME_ENTRY_RULES.MAPPING_ID HXC_MAPPINGS
Comments

HXC_MAPPINGS holds descriptions of the groups of Mapping Components used to identify the relationship between types of Time Information and their storage location within the Time Store.

Indexes
Index Type Tablespace Column
HXC_MAPPINGS_PK UNIQUE APPS_TS_TX_IDX MAPPING_ID
HXC_MAPPINGS_UK1 UNIQUE APPS_TS_TX_IDX NAME
Columns
Name Datatype Length Mandatory Comments
MAPPING_ID NUMBER (15) Y Primary Key from Sequence
NAME VARCHAR2 (80)
Name for the group of Mapping Components.
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

HXC.HXC_MAPPINGS does not reference any database object

HXC.HXC_MAPPINGS is referenced by following:

APPS
SYNONYM - HXC_MAPPINGS
TRIGGER - HXC_MAPPINGS_WHO

[top of page]

Table: HXC_MAPPING_COMPONENTS

Description: Mapping Components
Primary Key: HXC_MAPPING_COMPONENTS_PK
  1. MAPPING_COMPONENT_ID
Primary Key: HXC_MAPPING_COMPONENTS_UK1
  1. NAME
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_MAPPING_COMPONENTS.BLD_BLK_INFO_TYPE_ID HXC_BLD_BLK_INFO_TYPES
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_ALIAS_TYPE_COMPONENTS.MAPPING_COMPONENT_ID HXC_MAPPING_COMPONENTS
HXC_MAPPING_COMP_USAGES.MAPPING_COMPONENT_ID HXC_MAPPING_COMPONENTS
Comments

HXC_MAPPING_COMPONENTS holds information describing in which columns in HXC_TIME_ATTRIBUTES individual attributes of Time Information are stored.

Indexes
Index Type Tablespace Column
HXC_MAPPING_COMPONENTS_PK UNIQUE APPS_TS_TX_IDX MAPPING_COMPONENT_ID
HXC_MAPPING_COMPONENTS_UK1 UNIQUE APPS_TS_TX_IDX NAME
HXC_MAPPING_COMPONENTS_FK1 NONUNIQUE APPS_TS_TX_IDX BLD_BLK_INFO_TYPE_ID
Columns
Name Datatype Length Mandatory Comments
MAPPING_COMPONENT_ID NUMBER (15) Y Primary Key from sequence
FIELD_NAME VARCHAR2 (80)
Name of the Attribute.
NAME VARCHAR2 (80)
Descriptive user name for the Mapping Component.
BLD_BLK_INFO_TYPE_ID NUMBER (15) Y Foreign Key to HXC_BLD_BLK_INFO_TYPES.
SEGMENT VARCHAR2 (80)
The Name of the Descriptive FlexField segment to which the Attribute is mapped.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

HXC.HXC_MAPPING_COMPONENTS does not reference any database object

HXC.HXC_MAPPING_COMPONENTS is referenced by following:

APPS
SYNONYM - HXC_MAPPING_COMPONENTS
TRIGGER - HXC_MAPPING_COMPONENTS_WHO

[top of page]

Table: HXC_MAPPING_COMP_USAGES

Description: Mapping Component Usages
Primary Key: HXC_MAPPING_COMP_USAGES_PK
  1. MAPPING_COMP_USAGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_MAPPING_COMP_USAGES.MAPPING_COMPONENT_ID HXC_MAPPING_COMPONENTS
HXC_MAPPING_COMP_USAGES.MAPPING_ID HXC_MAPPINGS
Comments

HXC_MAPPING_COMP_USAGES groups together Mapping Components and associates them with rows in HXC_MAPPINGS.

Indexes
Index Type Tablespace Column
HXC_MAPPING_COMP_USAGES_PK UNIQUE APPS_TS_TX_IDX MAPPING_COMP_USAGE_ID
HXC_MAPPING_COMP_USAGES_FK1 NONUNIQUE APPS_TS_TX_IDX MAPPING_COMPONENT_ID
HXC_MAPPING_COMP_USAGES_FK2 NONUNIQUE APPS_TS_TX_IDX MAPPING_ID
Columns
Name Datatype Length Mandatory Comments
MAPPING_COMP_USAGE_ID NUMBER (15) Y Primary Key from sequence
MAPPING_COMPONENT_ID NUMBER (15)
Foreign Key to HXC_MAPPING_COMPONENTS.
MAPPING_ID NUMBER (15)
Foreign Key to HXC_MAPPINGS.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

HXC.HXC_MAPPING_COMP_USAGES does not reference any database object

HXC.HXC_MAPPING_COMP_USAGES is referenced by following:

APPS
SYNONYM - HXC_MAPPING_COMP_USAGES
TRIGGER - HXC_MAPPING_COMP_USAGES_WHO

[top of page]

Table: HXC_PREF_DEFINITIONS

Description: Preference Definitions
Primary Key: HXC_PREF_DEFINITIONS_PK
  1. PREF_DEFINITION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_PREF_HIERARCHIES.PREF_DEFINITION_ID HXC_PREF_DEFINITIONS
Comments

HXC_PREF_DEFINITIONS describes the preferences that can be set for the Time Store or for the Oracle Time Capture Self-Service application.

Indexes
Index Type Tablespace Column
HXC_PREF_DEFINITIONS_PK UNIQUE APPS_TS_TX_IDX PREF_DEFINITION_ID
HXC_PREF_DEFINITIONS_FK1 NONUNIQUE APPS_TS_TX_IDX CODE
Columns
Name Datatype Length Mandatory Comments
PREF_DEFINITION_ID NUMBER (15) Y Primary Key from sequence
CODE VARCHAR2 (30) Y Unique Name for the Preference which also serves as the context for the Preference FlexField.
DESCRIPTIVE_FLEXFIELD_NAME VARCHAR2 (80) Y The Name of the Descriptive FlexField to which the Preference belongs.
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number

[top of page]

HXC.HXC_PREF_DEFINITIONS does not reference any database object

HXC.HXC_PREF_DEFINITIONS is referenced by following:

APPS
SYNONYM - HXC_PREF_DEFINITIONS
TRIGGER - HXC_PREF_DEFINITIONS_WHO

[top of page]

Table: HXC_PREF_HIERARCHIES

Description: Preference Hierarchies
Primary Key: HXC_PREF_HIERARCHIES_PK
  1. PREF_HIERARCHY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_PREF_HIERARCHIES.PARENT_PREF_HIERARCHY_ID HXC_PREF_HIERARCHIES
HXC_PREF_HIERARCHIES.PREF_DEFINITION_ID HXC_PREF_DEFINITIONS
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_PREF_HIERARCHIES.PARENT_PREF_HIERARCHY_ID HXC_PREF_HIERARCHIES
HXC_RESOURCE_RULES.PREF_HIERARCHY_ID HXC_PREF_HIERARCHIES
Comments

HXC_PREF_HIERARCHIES allows Preference Definitions to be grouped together in structured hierarchies. These Preference Hierarchies can then be assigned to users as required.

Indexes
Index Type Tablespace Column
HXC_PREF_HIERARCHIES_PK UNIQUE APPS_TS_TX_IDX PREF_HIERARCHY_ID
HXC_PREF_HIERARCHIES_FK1 NONUNIQUE APPS_TS_TX_IDX PARENT_PREF_HIERARCHY_ID
HXC_PREF_HIERARCHIES_FK2 NONUNIQUE APPS_TS_TX_IDX PREF_DEFINITION_ID
HXC_PREF_HIERARCHIES_FK3 NONUNIQUE APPS_TS_TX_IDX BUSINESS_GROUP_ID
HXC_PREF_HIERARCHIES_N1 NONUNIQUE APPS_TS_TX_IDX TOP_LEVEL_PARENT_ID
HXC_PREF_HIERARCHIES_N2 NONUNIQUE APPS_TS_TX_IDX NAME
Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE VARCHAR2 (30)
The legislation to which the pref hierarchies applies
PREF_HIERARCHY_ID NUMBER (15) Y Primary Key from Sequence
TYPE VARCHAR2 (30)
Indicates whether this row is a ROOT, LEAF or NODE in the Hierarchy.
NAME VARCHAR2 (80) Y Descriptive Name of the node.
PARENT_PREF_HIERARCHY_ID NUMBER (15)
A reference to another row in HXC_PREF_HIERARCHIES.
EDIT_ALLOWED VARCHAR2 (9) Y Indicates whether or not a user is allowed to edit the Preference.
DISPLAYED VARCHAR2 (9) Y Indicates whether or not the Preference is displayed to the user.
PREF_DEFINITION_ID NUMBER (15)
Foreign Key to HXC_PREF_DEFINITIONS.
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
ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flexfield Column
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
ORIG_PREF_HIERARCHY_ID NUMBER (15)
Used to manipulate Preference Hierarchy
ORIG_PARENT_HIERARCHY_ID NUMBER (15)
Used to manipulate Preference Hierarchy
TOP_LEVEL_PARENT_ID NUMBER (15)
Used to store the Top Level Parent Id
CODE VARCHAR2 (30)
Used to store the Code

[top of page]

HXC.HXC_PREF_HIERARCHIES does not reference any database object

HXC.HXC_PREF_HIERARCHIES is referenced by following:

APPS
SYNONYM - HXC_PREF_HIERARCHIES
TRIGGER - HXC_PREF_HIERARCHIES_WHO

[top of page]

Table: HXC_RECURRING_PERIODS

Description: Recurring Periods
Primary Key: HXC_RECURRING_PERIODS_PK
  1. RECURRING_PERIOD_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_APPROVAL_PERIOD_COMPS.RECURRING_PERIOD_ID HXC_RECURRING_PERIODS
Comments

HXC_RECURRING_PERIODS holds the definitions of any Recurring Periods required by the Time Store.

Indexes
Index Type Tablespace Column
HXC_RECURRING_PERIODS_PK UNIQUE APPS_TS_TX_IDX RECURRING_PERIOD_ID
Columns
Name Datatype Length Mandatory Comments
RECURRING_PERIOD_ID NUMBER (15) Y Primary Key from Sequence
NAME VARCHAR2 (80) Y Name of the Recurring Period.
START_DATE DATE
Y Start date of the Recurring Period.
END_DATE DATE

End date of the Recurring Period.
PERIOD_TYPE VARCHAR2 (80)
Indicates the type of Time Period.
DURATION_IN_DAYS NUMBER (10)
The number of days in the Recurring Period.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

HXC.HXC_RECURRING_PERIODS does not reference any database object

HXC.HXC_RECURRING_PERIODS is referenced by following:

APPS
SYNONYM - HXC_RECURRING_PERIODS
TRIGGER - HXC_RECURRING_PERIODS_WHO

[top of page]

Table: HXC_RESOURCE_RULES

Description: Resource Rules
Primary Key: HXC_RESOURCE_RULES_PK
  1. RESOURCE_RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_RESOURCE_RULES.PREF_HIERARCHY_ID HXC_PREF_HIERARCHIES
Comments

HXC_RESOURCE_RULES holds information detailing how Preference Hierarchies are associated with Resources. Eligibility is based on criteria relevant to the Resource Type.

Indexes
Index Type Tablespace Column
HXC_RESOURCE_RULES_PK UNIQUE APPS_TS_TX_IDX RESOURCE_RULE_ID
HXC_RESOURCE_RULES_FK1 NONUNIQUE APPS_TS_TX_IDX PREF_HIERARCHY_ID
HXC_RESOURCE_RULES_FK2 NONUNIQUE APPS_TS_TX_IDX BUSINESS_GROUP_ID
HXC_RESOURCE_RULES_FK3 NONUNIQUE APPS_TS_TX_IDX ELIGIBILITY_CRITERIA_ID
Columns
Name Datatype Length Mandatory Comments
LEGISLATION_CODE VARCHAR2 (30)
The legislation to which the resource rule applies
RESOURCE_RULE_ID NUMBER (15) Y Primary Key from a sequence
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ORGANIZATION_UNITS.
NAME VARCHAR2 (80) Y Name of the Resource Rule.
ELIGIBILITY_CRITERIA_TYPE VARCHAR2 (30) Y The type of entity associated with the eligibility rule.
ELIGIBILITY_CRITERIA_ID VARCHAR2 (60)
Implicit Foreign Key to the entity determining eligibility.
PREF_HIERARCHY_ID NUMBER (15) Y Foreign Key to HXC_PREFERENCIES_HIERARCHIES.
RULE_EVALUATION_ORDER NUMBER (9) Y Sequence of evaluation in the case of multiple rules.
RESOURCE_TYPE VARCHAR2 (30) Y The type of Resource that the rule applies to.
START_DATE DATE

The start date of the period for which the rule is active.
END_DATE DATE

The end date of the period for which the rule is active.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

HXC.HXC_RESOURCE_RULES does not reference any database object

HXC.HXC_RESOURCE_RULES is referenced by following:

APPS
SYNONYM - HXC_RESOURCE_RULES
TRIGGER - HXC_RESOURCE_RULES_WHO

[top of page]

Table: HXC_RETRIEVAL_PROCESSES

Description: Retrieval Processes
Primary Key: HXC_RETRIEVAL_PROCESSES_PK
  1. RETRIEVAL_PROCESS_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_RETRIEVAL_PROCESSES.TIME_RECIPIENT_ID HXC_TIME_RECIPIENTS
HXC_RETRIEVAL_PROCESSES.MAPPING_ID HXC_MAPPINGS
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_RETRIEVAL_RULES.RETRIEVAL_PROCESS_ID HXC_RETRIEVAL_PROCESSES
Comments

HXC_RETRIEVAL_PROCESSES describes a process used by a Recipient Application to retrieve data from the Time Store. A Recipient Application must have at least one defined Retrieval Process in order to retrieve data.

Indexes
Index Type Tablespace Column
HXC_RETRIEVAL_PROCESSES_PK UNIQUE APPS_TS_TX_IDX RETRIEVAL_PROCESS_ID
HXC_RETRIEVAL_PROCESSES_FK1 NONUNIQUE APPS_TS_TX_IDX TIME_RECIPIENT_ID
Columns
Name Datatype Length Mandatory Comments
RETRIEVAL_PROCESS_ID NUMBER (15) Y Primary Key from sequence
TIME_RECIPIENT_ID NUMBER (15) Y Foreign Key to HXC_TIME_RECIPIENTS.
NAME VARCHAR2 (80) Y Name of the Retrieval Process.
MAPPING_ID NUMBER
Y Foreign Key to HXC_MAPPINGS.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

HXC.HXC_RETRIEVAL_PROCESSES does not reference any database object

HXC.HXC_RETRIEVAL_PROCESSES is referenced by following:

APPS
SYNONYM - HXC_RETRIEVAL_PROCESSES
TRIGGER - HXC_RETRIEVAL_PROCESSES_WHO

[top of page]

Table: HXC_RETRIEVAL_RANGES

Description: Retrieval Ranges
Primary Key: HXC_RETRIEVAL_RANGES_PK
  1. RETRIEVAL_RANGE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_RETRIEVAL_RANGE_RESOURCES.RETRIEVAL_RANGE_ID HXC_RETRIEVAL_RANGES
Comments

HXC_RETRIEVAL_RANGES table is used to support multiple concurrent Transaction Import Processes

Indexes
Index Type Tablespace Column
HXC_RETRIEVAL_RANGES_PK UNIQUE APPS_TS_INTERFACE RETRIEVAL_RANGE_ID
HXC_RETRIEVAL_RANGES_FK1 NONUNIQUE APPS_TS_INTERFACE TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
RETRIEVAL_RANGE_ID NUMBER (15) Y Primary Key from Sequence
RETRIEVAL_PROCESS_ID NUMBER (15) Y Retreival Application Process Id
RANGE_START NUMBER (9) Y Starting Resource id for the chunk
RANGE_STOP NUMBER (9) Y Ending Resource id for the Chunk
SEQ NUMBER (9) Y Sequence
TRANSACTION_ID NUMBER (15)
Foreign key to HXC_TRANSACTIONS table
WHERE_CLAUSE VARCHAR2 (2000)
Additional where clause
CREATED_BY NUMBER (15)
Standard WHO column
CREATION_DATE DATE

Standard WHO column
LAST_UPDATED_BY NUMBER (15)
Standard WHO column
LAST_UPDATE_DATE DATE

Standard WHO column
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
CONC_REQUEST_ID NUMBER (15)
Concurrent Request ID of the retrieval processing this range
UNIQUE_PARAMS VARCHAR2 (2000)
Unique paramters of the recipient application retrieval

[top of page]

HXC.HXC_RETRIEVAL_RANGES does not reference any database object

HXC.HXC_RETRIEVAL_RANGES is referenced by following:

APPS
SYNONYM - HXC_RETRIEVAL_RANGES
TRIGGER - HXC_RETRIEVAL_RANGES_WHO

[top of page]

Table: HXC_RETRIEVAL_RANGE_RESOURCES

Description: Contains resources for each HXC_RETRIEVAL_RANGE.
Primary Key: HXC_RETRIEVAL_RANGE_RESOURCE_P
  1. RETRIEVAL_RANGE_ID
  2. RESOURCE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_RETRIEVAL_RANGE_RESOURCES.RETRIEVAL_RANGE_ID HXC_RETRIEVAL_RANGES
Comments

Contains resources for each HXC_RETRIEVAL_RANGE.

Indexes
Index Type Tablespace Column
HXC_RETRIEVAL_RANGE_RES_FK NONUNIQUE APPS_TS_INTERFACE RETRIEVAL_RANGE_ID
RESOURCE_ID
Columns
Name Datatype Length Mandatory Comments
RETRIEVAL_RANGE_ID NUMBER (15) Y Foreign key to HXC_RETRIEVAL_RANGES
RESOURCE_ID NUMBER (15) Y The resource id to be processed

[top of page]

HXC.HXC_RETRIEVAL_RANGE_RESOURCES does not reference any database object

HXC.HXC_RETRIEVAL_RANGE_RESOURCES is referenced by following:

APPS
SYNONYM - HXC_RETRIEVAL_RANGE_RESOURCES

[top of page]

Table: HXC_RETRIEVAL_RULES

Description: Retrieval Rules
Primary Key: HXC_RETRIEVAL_RULES_PK
  1. RETRIEVAL_RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_RETRIEVAL_RULES.RETRIEVAL_PROCESS_ID HXC_RETRIEVAL_PROCESSES
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_RETRIEVAL_RULE_COMPS.RETRIEVAL_RULE_ID HXC_RETRIEVAL_RULES
Comments

HXC_RETRIEVAL_RULES describes the Rules which determine which data should be transferred to a Recipient Application via a defined Retrieval Process.

Indexes
Index Type Tablespace Column
HXC_RETRIEVAL_RULES_PK UNIQUE APPS_TS_TX_IDX RETRIEVAL_RULE_ID
HXC_RETRIEVAL_RULES_UK1 UNIQUE APPS_TS_TX_IDX NAME
HXC_RETRIEVAL_RULES_FK1 NONUNIQUE APPS_TS_TX_IDX RETRIEVAL_PROCESS_ID
Columns
Name Datatype Length Mandatory Comments
RETRIEVAL_RULE_ID NUMBER (15) Y Primary Key from Sequence
RETRIEVAL_PROCESS_ID NUMBER (15) Y Foreign Key to HXC_RETRIEVAL_PROCESSES.
NAME VARCHAR2 (80) Y Name of rule.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

HXC.HXC_RETRIEVAL_RULES does not reference any database object

HXC.HXC_RETRIEVAL_RULES is referenced by following:

APPS
SYNONYM - HXC_RETRIEVAL_RULES
TRIGGER - HXC_RETRIEVAL_RULES_WHO

[top of page]

Table: HXC_RETRIEVAL_RULE_COMPS

Description: Retrieval Rule Components
Primary Key: HXC_RETRIEVAL_RULE_COMPS_PK
  1. RETRIEVAL_RULE_COMP_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_RETRIEVAL_RULE_COMPS.RETRIEVAL_RULE_ID HXC_RETRIEVAL_RULES
HXC_RETRIEVAL_RULE_COMPS.TIME_RECIPIENT_ID HXC_TIME_RECIPIENTS
Comments

HXC_RETRIEVAL_RULE_COMPS holds the individual Rule Components which make up a defined set of Rules. Each Rule Component describes the status that is required of Recipient Application data in order for it to be retrieved via the associated Retrieval Process.

Indexes
Index Type Tablespace Column
HXC_RETRIEVAL_RULE_COMPS_PK UNIQUE APPS_TS_TX_IDX RETRIEVAL_RULE_COMP_ID
HXC_RETRIEVAL_RULE_COMPS_FK1 NONUNIQUE APPS_TS_TX_IDX RETRIEVAL_RULE_ID
HXC_RETRIEVAL_RULE_COMPS_FK2 NONUNIQUE APPS_TS_TX_IDX TIME_RECIPIENT_ID
Columns
Name Datatype Length Mandatory Comments
RETRIEVAL_RULE_COMP_ID NUMBER (15) Y Primary Key from sequence
RETRIEVAL_RULE_ID NUMBER (15) Y Foreign Key to HXC_RETRIEVAL_RULES.
STATUS VARCHAR2 (30) Y Status of Time Information to which Rule Component applies.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
TIME_RECIPIENT_ID NUMBER (15) Y Foreign Key to HXC_TIME_RECIPIENTS.

[top of page]

HXC.HXC_RETRIEVAL_RULE_COMPS does not reference any database object

HXC.HXC_RETRIEVAL_RULE_COMPS is referenced by following:

APPS
SYNONYM - HXC_RETRIEVAL_RULE_COMPS
TRIGGER - HXC_RETRIEVAL_RULE_COMPS_WHO

[top of page]

Table: HXC_RPT_LAYOUT_COMP_QUERIES

Description: Layout components and the queries associated for translation
Primary Key: HXC_RPT_LAYOUT_COMP_QUERIES_PK
  1. LAYOUT_COMPONENT_ID
Comments

Holds all the user enterable layout_component_ids and the queries associated with them to translate the ids stored to the display values

Indexes
Index Type Tablespace Column
HXC_RPT_LAYOUT_COMP_QUERIES_PK UNIQUE APPS_TS_TX_IDX LAYOUT_COMPONENT_ID
HXC_RPT_LAYOUT_COMP_QUERIES_UK UNIQUE APPS_TS_TX_IDX LAYOUT_ID
ATTRIBUTE
Columns
Name Datatype Length Mandatory Comments
LAYOUT_ID NUMBER (15)
Layout_id
LAYOUT_COMPONENT_ID NUMBER (15) Y Layout_component_id
QUERY VARCHAR2 (4000)
The query for translating id to display_value
ATTRIBUTE VARCHAR2 (15)
Column this layout_component corresponds to in HXC_RPT_TC_DETAILS_ALL
COMPONENT_NAME VARCHAR2 (50)
Display name for the component

[top of page]

HXC.HXC_RPT_LAYOUT_COMP_QUERIES does not reference any database object

HXC.HXC_RPT_LAYOUT_COMP_QUERIES is referenced by following:

APPS
SYNONYM - HXC_RPT_LAYOUT_COMP_QUERIES

[top of page]

Table: HXC_RPT_TC_AUDIT

Description: Temp table for Timecard Audit Trail report
Comments

Temporary table used for holding and reporting Timecard Audit Data.

Columns
Name Datatype Length Mandatory Comments
TIME_ENTRY_DATE DATE

Date for which time is entered for
ATTRIBUTE_INFO VARCHAR2 (1500)
List of User Entered fields from the timecard
HOURS NUMBER

Hours recorded for these attributes
ACTION VARCHAR2 (30)
Kind of action - new,edit,delete etc.
ACTION_DATE DATE

creation date
ACTION_BY VARCHAR2 (400)
action by
COMMENTS VARCHAR2 (2000)
comments
REASONS VARCHAR2 (150)
Reasons
TRANSACTION_ID NUMBER (22)
Transaction_id for deposit
DETAIL_BB_ID NUMBER

detail building_block_id
DETAIL_BB_OVN NUMBER

OVN of detail bb id
TC_BB_ID NUMBER

timecard_id
TC_BB_OVN NUMBER

timecard_ovn
ACTION_TYPE VARCHAR2 (30)
Action type - timecard level or detail level
RESOURCE_ID NUMBER (15)
Person id
TC_START_TIME DATE

timecard start time
TC_STOP_TIME DATE

timecard stop time
ACTION_BY_PERSON VARCHAR2 (240)
Action_by's full_name
CLA_REASON VARCHAR2 (310)
CLA reason
RESOURCE_NAME VARCHAR2 (300)
Full_name of resource_id
START_STOP_TIME VARCHAR2 (30)
time, if entered in timecard with a start_stop time instead of hours

[top of page]

HXC.HXC_RPT_TC_AUDIT does not reference any database object

HXC.HXC_RPT_TC_AUDIT is referenced by following:

APPS
SYNONYM - HXC_RPT_TC_AUDIT

[top of page]

Table: HXC_RPT_TC_DETAILS_ALL

Description: Detail table for all detail information, for reporting
Primary Key: HXC_RPT_TC_DETAILS_PK
  1. DETAIL_BB_ID
  2. DETAIL_BB_OVN
Comments

Master table for all detail, day and timecard level information from time building blocks and time attributes, created to hold all the above information as a snapshot of the timecards, to be used for reporting.

Indexes
Index Type Tablespace Column
HXC_RPT_TC_DETAILS_PK UNIQUE APPS_TS_TX_IDX DETAIL_BB_ID
DETAIL_BB_OVN
HXC_RPT_TC_DETAILS_FK1 NONUNIQUE APPS_TS_TX_IDX RESOURCE_ID
TC_START_TIME
TC_STOP_TIME
HXC_RPT_TC_DETAILS_FK2 NONUNIQUE APPS_TS_TX_IDX TC_BB_ID
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER (15)
Person/resource_id
TC_START_TIME DATE

timecard start time
TC_STOP_TIME DATE

timecard stop time
TC_BB_ID NUMBER (15)
timecard's time_building_block_id
TC_BB_OVN NUMBER (15)
timecard's OVN
DAY_BB_ID NUMBER (15)
day's time_building_block_id
DAY_BB_OVN NUMBER (15)
day's OVN
DAY_START_TIME DATE

day's start_time
DAY_STOP_TIME DATE

day's stop_time
DETAIL_BB_ID NUMBER (15) Y detail's time_building_block_id
DETAIL_BB_OVN NUMBER (15) Y detail's OVN
LAYOUT_ID NUMBER (15)
layout id for the timecard
TRANSACTION_ID NUMBER (22)
transaction_id for DEPOSIT
TRANSACTION_DETAIL_ID NUMBER (15)
transaction_detail_id for DEPOSIT
REQUEST_ID VARCHAR2 (30)
Concurrent request id
CREATION_DATE DATE

from hxc_time_building_blocks
LAST_UPDATE_DATE DATE

from hxc_time_building_blocks
DATE_FROM DATE

from hxc_time_building_blocks
DATE_TO DATE

from hxc_time_building_blocks
DAY_DATE_TO DATE

from hxc_time_building_blocks, from DAY scope
DETAIL_COMMENTS VARCHAR2 (2000)
from hxc_time_building_blocks, DETAIL scope
TC_COMMENTS VARCHAR2 (2000)
from hxc_time_building_blocks, TIMECARD scope
HOURS_MEASURE NUMBER

from hxc_time_building_blocks, DETAIL scope
ATTRIBUTE1 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE2 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE3 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE4 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE5 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE6 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE7 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE8 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE9 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE10 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE11 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE12 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE13 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE14 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE15 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE16 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE17 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE18 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE19 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE20 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE21 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE22 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE23 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE24 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE25 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE26 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE27 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE28 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE29 VARCHAR2 (150)
Layout attribute(component)
ATTRIBUTE30 VARCHAR2 (150)
Layout attribute(component)
CREATED_BY NUMBER (15)
Standard who, from hxc_time_building_blocks
LAST_UPDATED_BY NUMBER (15)
Standard who, from hxc_time_building_blocks
CLA_REASON VARCHAR2 (150)
Translated CLA reason
CLA_COMMENTS VARCHAR2 (150)
CLA comments
CLA_TYPE VARCHAR2 (150)
LATE or CHANGE
CREATED_BY_USER VARCHAR2 (400)
Username of created_by
LAST_UPDATED_BY_USER VARCHAR2 (400)
Username of last_updated_by
RESOURCE_NAME VARCHAR2 (300)
full_name of resource_id
STATUS VARCHAR2 (30)
from hxc_time_building_blocks

[top of page]

HXC.HXC_RPT_TC_DETAILS_ALL does not reference any database object

HXC.HXC_RPT_TC_DETAILS_ALL is referenced by following:

APPS
SYNONYM - HXC_RPT_TC_DETAILS_ALL

[top of page]

Table: HXC_RPT_TC_HIST_LOG

Description: Log of all timecard snapshots created
Primary Key: HXC_RPT_TC_HIST_LOG_PK
  1. RESOURCE_ID
  2. TC_START_TIME
  3. TC_STOP_TIME
Comments

History of all timecard snapshots that are created in HXC_RPT_TC_DETAILS_ALL and the last time and request id that created the snapshot.

Indexes
Index Type Tablespace Column
HXC_RPT_TC_HIST_LOG_PK UNIQUE APPS_TS_TX_IDX RESOURCE_ID
TC_START_TIME
TC_STOP_TIME
HXC_RPT_TC_HIST_LOG_FK1 NONUNIQUE APPS_TS_TX_IDX REQUEST_ID
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER (15) Y Person/resource_id
TC_START_TIME DATE
Y timecard start time
TC_STOP_TIME DATE
Y timecard stop date
HISTORY_TILL_DATE DATE

Date when snapshot was created.
REQUEST_ID VARCHAR2 (30)
Concurrent request id for the snapshot job

[top of page]

HXC.HXC_RPT_TC_HIST_LOG does not reference any database object

HXC.HXC_RPT_TC_HIST_LOG is referenced by following:

APPS
SYNONYM - HXC_RPT_TC_HIST_LOG

[top of page]

Table: HXC_RPT_TC_RESOURCE_TEMP

Description: HXC_RPT_TC_RESOURCE_TEMP
Comments

Temp table to hold the timecard level info for active resources while loading the timecard snapshot for reporting

Indexes
Index Type Tablespace Column
HXC_RPT_TC_RESOURCE_TEMP_FK1 NONUNIQUE APPS_TS_TX_IDX LAYOUT_ID
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER (15)
Resource_id
TC_START_TIME DATE

TC_START_TIME
TC_STOP_TIME DATE

TC_STOP_TIME
TC_BB_ID NUMBER (15)
TC_BB_ID
LAYOUT_ID NUMBER (15)
Layout Id
ALIAS_DEFINITION_ID NUMBER (15)
Alias_Definition_id
REQUEST_ID VARCHAR2 (30)
Request_id
HISTORY_FROM_DATE DATE

History_from_date
TC_COMMENTS VARCHAR2 (2000)
Tc_comments
RESOURCE_NAME VARCHAR2 (300)
Resource_name

[top of page]

HXC.HXC_RPT_TC_RESOURCE_TEMP does not reference any database object

HXC.HXC_RPT_TC_RESOURCE_TEMP is referenced by following:

APPS
SYNONYM - HXC_RPT_TC_RESOURCE_TEMP

[top of page]

Table: HXC_RPT_VO_ALL

Description: Master list of all seeded VOs and queries associated
Comments

Stores all the seeded VOs and the queries to be used for translating the ids stored to the display names

Columns
Name Datatype Length Mandatory Comments
VO_NAME VARCHAR2 (200)
Name of the VO
VO_QUERY VARCHAR2 (4000)
VO query
LAST_UPDATED_BY NUMBER (15)
Standard WHO
LAST_UPDATE_DATE DATE

Standard WHEN

[top of page]

HXC.HXC_RPT_VO_ALL does not reference any database object

HXC.HXC_RPT_VO_ALL is referenced by following:

APPS
SYNONYM - HXC_RPT_VO_ALL

[top of page]

Table: HXC_SEEDDATA_BY_LEVEL

Description: Seed Data Level
Primary Key: HXC_SEEDDATA_BY_LEVEL_PK
  1. OBJECT_ID
  2. OBJECT_TYPE
Comments

The HXC_SEEDDATA_BY_LEVEL table stores the information about seed data and the OTL Code level from which the seed data is valid.

Indexes
Index Type Tablespace Column
HXC_SEEDDATA_BY_LEVEL_PK UNIQUE APPS_TS_TX_IDX OBJECT_ID
OBJECT_TYPE
Columns
Name Datatype Length Mandatory Comments
OBJECT_ID NUMBER (15) Y Object_id of the seed data
OBJECT_TYPE VARCHAR2 (30) Y Object_type of the seed data
HXC_REQUIRED VARCHAR2 (30) Y Level of HXC required for the seed data to be shown
OWNER_APPLICATION_ID NUMBER (15) Y Owner application id of the seed data
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

HXC.HXC_SEEDDATA_BY_LEVEL does not reference any database object

HXC.HXC_SEEDDATA_BY_LEVEL is referenced by following:

APPS
SYNONYM - HXC_SEEDDATA_BY_LEVEL
TRIGGER - HXC_SEEDDATA_BY_LEVEL_WHO

[top of page]

Table: HXC_TCD_TMP_RPT

Description: Reference table for Timecard Dashboard
Comments

Reference table for Timecard Dashboard

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER (15)
Resource ID
REC_PERIOD_ID NUMBER (15)
Recurring Period ID selected on Timecard Dashboard
PERIOD_START_DATE DATE

Start Date of Timecard Period selected on Timecard Dashboard
PERIOD_END_DATE DATE

End Date of Timecard Period selected on Timecard Dashboard
SUPERVISOR_ID NUMBER (15)
Supervisor in Hierarchy selected on Timecard Dashboard
LOCATION_ID NUMBER (15)
Location ID selected on Timecard Dashboard
ORGANIZATION_ID NUMBER (15)
Organization ID selected on Timecard Dashboard
SEL_SUPERVISOR_ID NUMBER (15)
Supervisor ID for the selected summary link on Timecard Dashboard
SEL_TC_STATUS VARCHAR2 (20)
Timecard Status for the selected summary link on Timecard Dashboard
RPT_STATUS VARCHAR2 (20)
Status of Timecard Dashboard Report
PERSON_TYPE VARCHAR2 (30)
Person Type on Timecard Dashboard Report
PERSON_NAME VARCHAR2 (240)
Person Name on Timecard Dashboard Report
PERSON_NUMBER NUMBER (15)
Person Number on Timecard Dashboard Report
APPROVAL_STATUS VARCHAR2 (20)
Timecard Status on Timecard Dashboard Report
SUPERVISOR VARCHAR2 (240)
Supervisor on Timecard Dashboard Report
ORGANIZATION VARCHAR2 (240)
Organization on Timecard Dashboard Report
LOCATION VARCHAR2 (240)
Location on Timecard Dashboard Report
PAYROLL VARCHAR2 (240)
Payroll on Timecard Dashboard Report
APPLICATION VARCHAR2 (240)
Recipient Application
TC_START_DATE DATE

Timecard Start Date on Timecard Dashboard Report
TC_END_DATE DATE

Timecard End Date on Timecard Dashboard Report
LAST_MODIFIED_BY VARCHAR2 (100)
Last Modified User
LAST_MODIFIED_DATE DATE

Last Modified Date

[top of page]

HXC.HXC_TCD_TMP_RPT does not reference any database object

HXC.HXC_TCD_TMP_RPT is referenced by following:

APPS
SYNONYM - HXC_TCD_TMP_RPT

[top of page]

Table: HXC_TC_AP_LINKS

Description: Timecard Application Period Links
Comments

The HXC_TC_AP_LINKS table links the application period building blocks to the timecard building blocks, such that for entry level approval it is performant to associate the application periods with a particular timecard.

Indexes
Index Type Tablespace Column
HXC_TC_AP_LINKS_PK UNIQUE APPS_TS_TX_IDX TIMECARD_ID
APPLICATION_PERIOD_ID
HXC_TC_AP_LINKS_N1 NONUNIQUE APPS_TS_TX_IDX APPLICATION_PERIOD_ID
Columns
Name Datatype Length Mandatory Comments
TIMECARD_ID NUMBER
Y The timecard id
APPLICATION_PERIOD_ID NUMBER
Y The application period id

[top of page]

HXC.HXC_TC_AP_LINKS does not reference any database object

HXC.HXC_TC_AP_LINKS is referenced by following:

APPS
SYNONYM - HXC_TC_AP_LINKS

[top of page]

Table: HXC_TC_AP_LINKS_AR

Description: Timecard Application Period Links Archive table
Comments

The HXC_TC_AP_LINKS_AR table links the application period building blocks to the timecard building blocks, such that for entry level approval it is performant to associate the application periods with a particular timecard

Indexes
Index Type Tablespace Column
HXC_TC_AP_LINKS_AR_PK UNIQUE APPS_TS_ARCHIVE TIMECARD_ID
APPLICATION_PERIOD_ID
HXC_TC_AP_LINKS_AR_FK1 NONUNIQUE APPS_TS_ARCHIVE APPLICATION_PERIOD_ID
Columns
Name Datatype Length Mandatory Comments
TIMECARD_ID NUMBER
Y The timecard id
APPLICATION_PERIOD_ID NUMBER
Y The application period id

[top of page]

HXC.HXC_TC_AP_LINKS_AR does not reference any database object

HXC.HXC_TC_AP_LINKS_AR is referenced by following:

APPS
SYNONYM - HXC_TC_AP_LINKS_AR

[top of page]

Table: HXC_TEMPLATE_SUMMARY

Description: Template Summary Table
Comments

HXC_TEMPLATE_SUMMARY table stores Timecard Template summary information

Indexes
Index Type Tablespace Column
HXC_TEMPLATE_SUMMARY_PK UNIQUE APPS_TS_TX_IDX TEMPLATE_ID
HXC_TEMPLATE_SUMMARY_FK1 NONUNIQUE APPS_TS_TX_IDX RESOURCE_ID
HXC_TEMPLATE_SUMMARY_FK2 NONUNIQUE APPS_TS_TX_IDX LAYOUT_ID
Columns
Name Datatype Length Mandatory Comments
TEMPLATE_ID NUMBER (15) Y Template Id
TEMPLATE_OVN NUMBER (9) Y Template Object Version Number
TEMPLATE_NAME VARCHAR2 (150) Y Template Name
DESCRIPTION VARCHAR2 (150)
Template Description
TEMPLATE_TYPE VARCHAR2 (150)
Template Type
RECORDED_HOURS NUMBER

Recorded Hours
LAYOUT_ID NUMBER (15)
Layout Id
RESOURCE_ID NUMBER (15) Y Resource Id
LAST_UPDATED_BY_RESOURCE_ID NUMBER (15) Y Last updated by resource Id
RECURRING_PERIOD_ID NUMBER (15)
Recurring period Id
BUSINESS_GROUP_ID NUMBER (15) Y Business Group Id
START_TIME DATE

Start Time
STOP_TIME DATE

Stop Time

[top of page]

HXC.HXC_TEMPLATE_SUMMARY does not reference any database object

HXC.HXC_TEMPLATE_SUMMARY is referenced by following:

APPS
SYNONYM - HXC_TEMPLATE_SUMMARY

[top of page]

Table: HXC_TEMP_TIMECARDS

Description: Temporary Timecards for Summary Migration
Comments

The HXC_TEMP_TIMECARDS table holds timecards temporarily for the 'Run Timecard Migration' and 'Worker Timecard Migration' concurrent programs.

Columns
Name Datatype Length Mandatory Comments
WORKER_ID NUMBER (15)
Indicates the Concurrent Request Id of the Worker Concurrent program
SCOPE VARCHAR2 (30)
Indicates the Scope of the Building Block.
TIME_BUILDING_BLOCK_ID NUMBER (15)
The timecard id
OBJECT_VERSION_NUMBER NUMBER (9)
The object version number of the timecard
PROCESSED VARCHAR2 (1)
Flag to indicate if the timecard has been processed

[top of page]

HXC.HXC_TEMP_TIMECARDS does not reference any database object

HXC.HXC_TEMP_TIMECARDS is referenced by following:

APPS
SYNONYM - HXC_TEMP_TIMECARDS

[top of page]

Table: HXC_TEMP_TIMECARD_CHUNKS

Description: Temporary Storage for Archiving and Restoring Timecards
Comments
Indexes
Index Type Tablespace Column
HXC_TEMP_TIMECARD_CHUNKS_FK1 NONUNIQUE SCOPE
Columns
Name Datatype Length Mandatory Comments
DATA_SET_ID NUMBER (15)
ID NUMBER (15)
REF_ROWID VARCHAR2 (20)
REF_OVN NUMBER (15)
DAY_START_TIME DATE

DAY_STOP_TIME DATE

THREAD_ID NUMBER (15)
SCOPE VARCHAR2 (20)

[top of page]

HXC.HXC_TEMP_TIMECARD_CHUNKS does not reference any database object

HXC.HXC_TEMP_TIMECARD_CHUNKS is referenced by following:

APPS
SYNONYM - HXC_TEMP_TIMECARD_CHUNKS

[top of page]

Table: HXC_TIMECARD_SUMMARY

Description: Timecard summary
Comments

The HXC_TIMECARD_SUMMARY table denormalizes data about timecards for performance purposees. It also enables the entry level approval functionality.

Indexes
Index Type Tablespace Column
HXC_TIMECARD_SUMMARY_PK UNIQUE APPS_TS_TX_IDX TIMECARD_ID
HXC_TIMECARD_SUMMARY_FK1 NONUNIQUE APPS_TS_TX_IDX RESOURCE_ID
START_TIME
HXC_TIMECARD_SUMMARY_N1 NONUNIQUE APPS_TS_TX_IDX DATA_SET_ID
Columns
Name Datatype Length Mandatory Comments
TIMECARD_ID NUMBER
Y The timecard id
TIMECARD_OVN NUMBER
Y The object version number of the timecard.
APPROVAL_STATUS VARCHAR2 (30) Y The timecard approval status
RESOURCE_ID NUMBER
Y The resource id of this timecard.
START_TIME DATE
Y The start time of the timecard
STOP_TIME DATE
Y The stop time of the timecard
RECORDED_HOURS NUMBER
Y The total number of hours in the timecard.
HAS_REASONS VARCHAR2 (1) Y Whether change and late audit reasons are associated with the timecard.
SUBMISSION_DATE DATE

The submission date of the timecard.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Standard flexfield column
ATTRIBUTE1 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE2 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE3 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE4 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE5 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE6 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE7 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE8 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE9 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE10 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE11 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE12 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE13 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE14 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE15 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE16 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE17 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE18 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE19 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE20 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE21 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE22 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE23 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE24 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE25 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE26 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE27 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE28 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE29 VARCHAR2 (150)
Standard flexfield column
ATTRIBUTE30 VARCHAR2 (150)
Standard flexfield column
APPROVAL_ITEM_TYPE VARCHAR2 (8)
Item Type for The Approval Process of the Timecard
APPROVAL_PROCESS_NAME VARCHAR2 (30)
Workflow Process name
APPROVAL_ITEM_KEY VARCHAR2 (240)
Approval Item Key
TK_AUDIT_ITEM_TYPE VARCHAR2 (8)
Audit Timekeeper Item Type
TK_AUDIT_PROCESS_NAME VARCHAR2 (30)
Timekeeper Audit Process
TK_AUDIT_ITEM_KEY VARCHAR2 (240)
Timekeeper Audit Item Key
DATA_SET_ID NUMBER (15)
Data Set Id

[top of page]

HXC.HXC_TIMECARD_SUMMARY does not reference any database object

HXC.HXC_TIMECARD_SUMMARY is referenced by following:

APPS
SYNONYM - HXC_TIMECARD_SUMMARY

[top of page]

Table: HXC_TIME_ATTRIBUTES

Description: Time Attributes - attributes for a building block
Primary Key: HXC_TIME_ATTRIBUTES_PK
  1. TIME_ATTRIBUTE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_ERRORS.TIME_ATTRIBUTE_ID HXC_TIME_ATTRIBUTES
HXC_TIME_ATTRIBUTE_USAGES.TIME_ATTRIBUTE_ID HXC_TIME_ATTRIBUTES
Comments

HXC_TIME_ATTRIBUTES holds the attribution for Time Building Blocks.

Indexes
Index Type Tablespace Column
HXC_TIME_ATTRIBUTES_PK UNIQUE APPS_TS_TX_IDX TIME_ATTRIBUTE_ID
HXC_TIME_ATTRIBUTES_F2 NONUNIQUE APPS_TS_TX_IDX SYS_NC00037$
HXC_TIME_ATTRIBUTES_FK1 NONUNIQUE APPS_TS_TX_IDX BLD_BLK_INFO_TYPE_ID
HXC_TIME_ATTRIBUTES_FK2 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE_CATEGORY
HXC_TIME_ATTRIBUTES_FK3 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE1
HXC_TIME_ATTRIBUTES_FK4 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE2
HXC_TIME_ATTRIBUTES_FK5 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE3
HXC_TIME_ATTRIBUTES_N1 NONUNIQUE APPS_TS_TX_IDX DATA_SET_ID
Columns
Name Datatype Length Mandatory Comments
TIME_ATTRIBUTE_ID NUMBER (15) Y Primary Key from sequence
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
ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flexfield Column
BLD_BLK_INFO_TYPE_ID NUMBER (30) Y Foreign Key to HXC_BLD_BLK_INFO_TYPES.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
CONSOLIDATED_FLAG VARCHAR2 (1)
Consolidated Flag
DATA_SET_ID NUMBER (15)
Data set id

[top of page]

HXC.HXC_TIME_ATTRIBUTES does not reference any database object

HXC.HXC_TIME_ATTRIBUTES is referenced by following:

APPS
SYNONYM - HXC_TIME_ATTRIBUTES

[top of page]

Table: HXC_TIME_ATTRIBUTES_AR

Description: Time Attributes Archive
Comments

HXC_TIME_ATTRIBUTES_ AR holds the archived entries of HXC_TIME_ATTRIBUTES.

Indexes
Index Type Tablespace Column
HXC_TIME_ATTRIBUTES_AR_PK UNIQUE APPS_TS_TX_IDX TIME_ATTRIBUTE_ID
Columns
Name Datatype Length Mandatory Comments
TIME_ATTRIBUTE_ID NUMBER (15) Y Primary Key from sequence
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
ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flexfield Column
BLD_BLK_INFO_TYPE_ID NUMBER (30) Y Foreign Key to HXC_BLD_BLK_INFO_TYPES.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
CONSOLIDATED_FLAG VARCHAR2 (1)
Consolidated Flag
DATA_SET_ID NUMBER (15)
Data set id

[top of page]

HXC.HXC_TIME_ATTRIBUTES_AR does not reference any database object

HXC.HXC_TIME_ATTRIBUTES_AR is referenced by following:

APPS
SYNONYM - HXC_TIME_ATTRIBUTES_AR

[top of page]

Table: HXC_TIME_ATTRIBUTES_BK

Description: Backup of HXC_TIME_ATTRIBUTES during consolidation
Comments

HXC_TIME_ATTRIBUTES holds the attribution for Time Building Blocks.

Indexes
Index Type Tablespace Column
HXC_TIME_ATTRIBUTES_BK_PK UNIQUE APPS_TS_TX_IDX TIME_ATTRIBUTE_ID
HXC_TIME_ATTRIBUTES_BK_FK2 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE_CATEGORY
HXC_TIME_ATTRIBUTES_BK_FK3 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE1
HXC_TIME_ATTRIBUTES_BK_FK4 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE2
HXC_TIME_ATTRIBUTES_BK_FK5 NONUNIQUE APPS_TS_TX_IDX ATTRIBUTE3
Columns
Name Datatype Length Mandatory Comments
TIME_ATTRIBUTE_ID NUMBER (15) Y Primary Key from sequence
PROCESS_ID NUMBER (20)
Concurrent Request Id
SEQNO NUMBER (15)
Sequence Number
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
ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flexfield Column
BLD_BLK_INFO_TYPE_ID NUMBER (30) Y Foreign Key to HXC_BLD_BLK_INFO_TYPES.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
CONSOLIDATED_FLAG VARCHAR2 (1)
Consolidated Flag
DATA_SET_ID NUMBER (15)
Data set id

[top of page]

HXC.HXC_TIME_ATTRIBUTES_BK does not reference any database object

HXC.HXC_TIME_ATTRIBUTES_BK is referenced by following:

APPS
SYNONYM - HXC_TIME_ATTRIBUTES_BK

[top of page]

Table: HXC_TIME_ATTRIBUTES_EFC

Description: EFC Shadow Table for hxc_time_attributes
Primary Key: HXC_TIME_ATTRIBUTES_EFC_PK
  1. TIME_ATTRIBUTE_ID
  2. EFC_ACTION_ID
Comments

This is the EFC Shadow Table for hxc_time_attributes - EFC is Euro as a Functional Currency. Money amounts in hxc_time_attributes can be converted to Euro (by a process) if their currency is a Euro convertible currency - the data before it is converted is backed up in HXC_TIME_ATTRIBUTES_EFC so a history is available.

Indexes
Index Type Tablespace Column
HXC_TIME_ATTRIBUTES_EFC_PK UNIQUE APPS_TS_NOLOGGING TIME_ATTRIBUTE_ID
EFC_ACTION_ID
Columns
Name Datatype Length Mandatory Comments
TIME_ATTRIBUTE_ID NUMBER (15) Y Foreign Key to HXC_TIME_ATTRIBUTES
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 corresponding to hxc_time_attributes
ATTRIBUTE17 VARCHAR2 (150)
Descriptive Flexfield Column corresponding to hxc_time_attributes
ATTRIBUTE18 VARCHAR2 (150)
Descriptive Flexfield Column corresponding to hxc_time_attributes
ATTRIBUTE19 VARCHAR2 (150)
Descriptive Flexfield Column corresponding to hxc_time_attributes
ATTRIBUTE20 VARCHAR2 (150)
Descriptive Flexfield Column corresponding to hxc_time_attributes
ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield Column corresponding to hxc_time_attributes
ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield Column corresponding to hxc_time_attributes
ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield Column corresponding to hxc_time_attributes
ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield Column corresponding to hxc_time_attributes
ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield Column corresponding to hxc_time_attributes
ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flexfield Column corresponding to hxc_time_attributes
ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flexfield Column corresponding to hxc_time_attributes
ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flexfield Column corresponding to hxc_time_attributes
ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flexfield Column corresponding to hxc_time_attributes
ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flexfield Column corresponding to hxc_time_attributes
EFC_ACTION_ID NUMBER (15) Y Foreign Key to HR_EFC_ACTIONS
CURRENCY_CODE VARCHAR2 (30)
The Currency of the money amounts before conversion

[top of page]

HXC.HXC_TIME_ATTRIBUTES_EFC does not reference any database object

HXC.HXC_TIME_ATTRIBUTES_EFC is referenced by following:

APPS
SYNONYM - HXC_TIME_ATTRIBUTES_EFC

[top of page]

Table: HXC_TIME_ATTRIBUTE_USAGES

Description: Time Attribute Usages
Primary Key: HXC_TIME_ATTRIBUTE_USAGES_PK
  1. TIME_ATTRIBUTE_USAGE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_TIME_ATTRIBUTE_USAGES.TIME_ATTRIBUTE_ID HXC_TIME_ATTRIBUTES
HXC_TIME_ATTRIBUTE_USAGES.TIME_BUILDING_BLOCK_ID
HXC_TIME_ATTRIBUTE_USAGES.TIME_BUILDING_BLOCK_OVN 		HXC_TIME_BUILDING_BLOCKS
Comments

HXC_TIME_ATTRIBUTE_USAGES associates Time Attributes with Time Building Blocks.

Indexes
Index Type Tablespace Column
HXC_TIME_ATTRIBUTE_USAGES_PK UNIQUE APPS_TS_TX_IDX TIME_ATTRIBUTE_USAGE_ID
HXC_TIME_ATTRIBUTE_USAGES_FK1 NONUNIQUE APPS_TS_TX_IDX TIME_ATTRIBUTE_ID
HXC_TIME_ATTRIBUTE_USAGES_FK2 NONUNIQUE APPS_TS_TX_IDX TIME_BUILDING_BLOCK_ID
TIME_BUILDING_BLOCK_OVN
HXC_TIME_ATTRIBUTE_USAGES_N1 NONUNIQUE APPS_TS_TX_IDX DATA_SET_ID
Columns
Name Datatype Length Mandatory Comments
TIME_ATTRIBUTE_USAGE_ID NUMBER (15) Y Primary Key from a sequence
TIME_ATTRIBUTE_ID NUMBER (15)
Foreign Key to HXC_TIME_ATTRIBUTES.
TIME_BUILDING_BLOCK_ID NUMBER (15)
Foreign Key to HXC_TIME_BUILDING_BLOCKS.
CREATED_BY VARCHAR2 (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.
LAST_UPDATED_BY VARCHAR2 (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN VARCHAR2 (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
TIME_BUILDING_BLOCK_OVN NUMBER (9)
Foreign Key to hxc_time_building_blocks OVN
DATA_SET_ID NUMBER (15)
Data set id

[top of page]

HXC.HXC_TIME_ATTRIBUTE_USAGES does not reference any database object

HXC.HXC_TIME_ATTRIBUTE_USAGES is referenced by following:

APPS
SYNONYM - HXC_TIME_ATTRIBUTE_USAGES

[top of page]

Table: HXC_TIME_ATTRIBUTE_USAGES_AR

Description: Time Attribute Usages Archive
Comments

HXC_TIME_ATTRIBUTE_USAGES_AR holds the archived entries of HXC_TIME_ATTRIBUTE_USAGES.

Indexes
Index Type Tablespace Column
HXC_TIME_ATTR_USAGES_AR_PK UNIQUE APPS_TS_ARCHIVE TIME_ATTRIBUTE_USAGE_ID
HXC_TIME_ATTR_USAGES_AR_FK1 NONUNIQUE APPS_TS_ARCHIVE TIME_ATTRIBUTE_ID
HXC_TIME_ATTR_USAGES_AR_FK2 NONUNIQUE APPS_TS_ARCHIVE TIME_BUILDING_BLOCK_ID
TIME_BUILDING_BLOCK_OVN
Columns
Name Datatype Length Mandatory Comments
TIME_ATTRIBUTE_USAGE_ID NUMBER (15) Y Primary Key from a sequence
TIME_ATTRIBUTE_ID NUMBER (15)
Foreign Key to HXC_TIME_ATTRIBUTES.
TIME_BUILDING_BLOCK_ID NUMBER (15)
Foreign Key to HXC_TIME_BUILDING_BLOCKS.
CREATED_BY VARCHAR2 (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.
LAST_UPDATED_BY VARCHAR2 (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN VARCHAR2 (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
TIME_BUILDING_BLOCK_OVN NUMBER (9)
Foreign Key to hxc_time_building_blocks OVN
DATA_SET_ID NUMBER (15)
Data set id

[top of page]

HXC.HXC_TIME_ATTRIBUTE_USAGES_AR does not reference any database object

HXC.HXC_TIME_ATTRIBUTE_USAGES_AR is referenced by following:

APPS
SYNONYM - HXC_TIME_ATTRIBUTE_USAGES_AR

[top of page]

Table: HXC_TIME_ATTRIBUTE_USAGES_BK

Description: Time Attribute Usages
Comments

HXC_TIME_ATTRIBUTE_USAGES associates Time Attributes with Time Building Blocks.

Indexes
Index Type Tablespace Column
HXC_TIME_ATTRB_USAGES_BK_FK2 NONUNIQUE APPS_TS_TX_IDX TIME_BUILDING_BLOCK_ID
TIME_BUILDING_BLOCK_OVN
HXC_TIME_ATTRB_USAGES_BK_FK3 NONUNIQUE APPS_TS_TX_IDX PROCESS_ID
SEQNO
HXC_TIME_ATTRB_USAGES_BK_N1 NONUNIQUE APPS_TS_TX_IDX TIME_ATTRIBUTE_USAGE_ID
HXC_TIME_ATTR_USAGES_BK_FK1 NONUNIQUE APPS_TS_TX_IDX TIME_ATTRIBUTE_ID
Columns
Name Datatype Length Mandatory Comments
TIME_ATTRIBUTE_USAGE_ID NUMBER (15) Y Primary Key from a sequence
TIME_ATTRIBUTE_ID NUMBER (15)
Foreign Key to HXC_TIME_ATTRIBUTES.
TIME_BUILDING_BLOCK_ID NUMBER (15)
Foreign Key to HXC_TIME_BUILDING_BLOCKS.
CREATED_BY VARCHAR2 (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.
LAST_UPDATED_BY VARCHAR2 (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN VARCHAR2 (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
OBJECT_VERSION_NUMBER NUMBER

Object Version Number
TIME_BUILDING_BLOCK_OVN NUMBER (9)
Foreign Key to hxc_time_building_blocks OVN
DATA_SET_ID NUMBER (15)
Data set id
PROCESS_ID NUMBER (20) Y Concurrent request Id
SEQNO NUMBER (15)
Sequence Number

[top of page]

HXC.HXC_TIME_ATTRIBUTE_USAGES_BK does not reference any database object

HXC.HXC_TIME_ATTRIBUTE_USAGES_BK is referenced by following:

APPS
SYNONYM - HXC_TIME_ATTRIBUTE_USAGES_BK

[top of page]

Table: HXC_TIME_BUILDING_BLOCKS

Description: Time Building Blocks
Primary Key: HXC_TIME_BUILDING_BLOCKS_PK
  1. TIME_BUILDING_BLOCK_ID
  2. OBJECT_VERSION_NUMBER
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_TIME_BUILDING_BLOCKS.APPROVAL_STYLE_ID HXC_APPROVAL_STYLES
HXC_TIME_BUILDING_BLOCKS.PARENT_BUILDING_BLOCK_ID
HXC_TIME_BUILDING_BLOCKS.PARENT_BUILDING_BLOCK_OVN 		HXC_TIME_BUILDING_BLOCKS
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_ERRORS.TIME_BUILDING_BLOCK_ID
HXC_ERRORS.TIME_BUILDING_BLOCK_OVN 		HXC_TIME_BUILDING_BLOCKS
HXC_LOCKS.TIME_BUILDING_BLOCK_ID
HXC_LOCKS.TIME_BUILDING_BLOCK_OVN 		HXC_TIME_BUILDING_BLOCKS
HXC_TIME_ATTRIBUTE_USAGES.TIME_BUILDING_BLOCK_ID
HXC_TIME_ATTRIBUTE_USAGES.TIME_BUILDING_BLOCK_OVN 		HXC_TIME_BUILDING_BLOCKS
HXC_TIME_BUILDING_BLOCKS.PARENT_BUILDING_BLOCK_ID
HXC_TIME_BUILDING_BLOCKS.PARENT_BUILDING_BLOCK_OVN 		HXC_TIME_BUILDING_BLOCKS
HXC_TRANSACTION_DETAILS.TIME_BUILDING_BLOCK_ID
HXC_TRANSACTION_DETAILS.TIME_BUILDING_BLOCK_OVN 		HXC_TIME_BUILDING_BLOCKS
Comments

HXC_TIME_BUILDING_BLOCKS stores the Building Blocks that make up timecard definitions.

Indexes
Index Type Tablespace Column
HXC_TIME_BUILDING_BLOCKS_PK UNIQUE APPS_TS_TX_IDX TIME_BUILDING_BLOCK_ID
OBJECT_VERSION_NUMBER
HXC_TIME_BUILDING_BLOCKS_FK1 NONUNIQUE APPS_TS_TX_IDX APPROVAL_STYLE_ID
HXC_TIME_BUILDING_BLOCKS_FK2 NONUNIQUE APPS_TS_TX_IDX RESOURCE_ID
SCOPE
START_TIME
STOP_TIME
HXC_TIME_BUILDING_BLOCKS_FK3 NONUNIQUE APPS_TS_TX_IDX PARENT_BUILDING_BLOCK_ID
PARENT_BUILDING_BLOCK_OVN
HXC_TIME_BUILDING_BLOCKS_N1 NONUNIQUE APPS_TS_TX_IDX SCOPE
HXC_TIME_BUILDING_BLOCKS_N2 NONUNIQUE APPS_TS_TX_IDX DATA_SET_ID
Columns
Name Datatype Length Mandatory Comments
TIME_BUILDING_BLOCK_ID NUMBER (15) Y Primary Key from Sequence
TYPE VARCHAR2 (30) Y Indicates the Type of the Building Block.
MEASURE NUMBER

The numerical magnitude of UNIT_OF_MEASURE.
UNIT_OF_MEASURE VARCHAR2 (30)
The unit of measure that forms the basis of this Building Block.
START_TIME DATE

Start time of Building Block.
STOP_TIME DATE

End time of Building Block.
PARENT_BUILDING_BLOCK_ID NUMBER (15)
Self-referential Key.
PARENT_BUILDING_BLOCK_OVN NUMBER (9)
Self-referential Key.
SCOPE VARCHAR2 (30) Y Indicates the Scope of the Building Block.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
APPROVAL_STATUS VARCHAR2 (30) Y Indicates the Approval Status of the Building Block.
RESOURCE_ID NUMBER (15)
Implicit Foreign Key based on Resource Type.
RESOURCE_TYPE VARCHAR2 (30)
The type of Resource associated with the Building Block.
APPROVAL_STYLE_ID NUMBER (15)
Foreign Key to HXC_APPROVAL_STYLES.
DATE_FROM DATE
Y Start date of row.
DATE_TO DATE
Y End date of row.
COMMENT_TEXT VARCHAR2 (2000)
Comment text.
APPLICATION_SET_ID NUMBER (15)
Indicates the Application Set ID attached with building block
DATA_SET_ID NUMBER (15)
Data Set Id
TRANSLATION_DISPLAY_KEY VARCHAR2 (240)
Holds middle tier display key information.

[top of page]

HXC.HXC_TIME_BUILDING_BLOCKS does not reference any database object

HXC.HXC_TIME_BUILDING_BLOCKS is referenced by following:

APPS
SYNONYM - HXC_TIME_BUILDING_BLOCKS
TRIGGER - HXC_TIME_BUILDING_BLOCKS_WHO

[top of page]

Table: HXC_TIME_BUILDING_BLOCKS_AR

Description: Time Building Blocks Archive
Comments

HXC_TIME_BUILDING_BLOCKS_AR holds the archived entries of HXC_TIME_BUILDING_BLOCKS.

Indexes
Index Type Tablespace Column
HXC_TIME_BUILDING_BLOCKS_AR_PK UNIQUE APPS_TS_ARCHIVE TIME_BUILDING_BLOCK_ID
OBJECT_VERSION_NUMBER
HXC_TIME_BLDNG_BLOCKS_AR_FK2 NONUNIQUE APPS_TS_ARCHIVE SCOPE
DATA_SET_ID
HXC_TIME_BLDNG_BLOCKS_AR_FK3 NONUNIQUE APPS_TS_ARCHIVE PARENT_BUILDING_BLOCK_ID
PARENT_BUILDING_BLOCK_OVN
HXC_TIME_BLDNG_BLOCKS_AR_FK4 NONUNIQUE APPS_TS_ARCHIVE SCOPE
STOP_TIME
HXC_TIME_BLDNG_BLOCKS_AR_FK5 NONUNIQUE APPS_TS_ARCHIVE DATA_SET_ID
SCOPE
Columns
Name Datatype Length Mandatory Comments
TIME_BUILDING_BLOCK_ID NUMBER (15) Y Primary Key from Sequence
TYPE VARCHAR2 (30) Y Indicates the Type of the Building Block.
MEASURE NUMBER

The numerical magnitude of UNIT_OF_MEASURE.
UNIT_OF_MEASURE VARCHAR2 (30)
The unit of measure that forms the basis of this Building Block.
START_TIME DATE

Start time of Building Block.
STOP_TIME DATE

End time of Building Block.
PARENT_BUILDING_BLOCK_ID NUMBER (15)
Self-referential Key.
PARENT_BUILDING_BLOCK_OVN NUMBER (9)
Self-referential Key.
SCOPE VARCHAR2 (30) Y Indicates the Scope of the Building Block.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
APPROVAL_STATUS VARCHAR2 (30) Y Indicates the Approval Status of the Building Block.
RESOURCE_ID NUMBER (15)
Implicit Foreign Key based on Resource Type.
RESOURCE_TYPE VARCHAR2 (30)
The type of Resource associated with the Building Block.
APPROVAL_STYLE_ID NUMBER (15)
Foreign Key to HXC_APPROVAL_STYLES.
DATE_FROM DATE
Y Start date of row.
DATE_TO DATE
Y End date of row.
COMMENT_TEXT VARCHAR2 (2000)
Comment text.
APPLICATION_SET_ID NUMBER (15)
Indicates the Application Set ID attached with building block
DATA_SET_ID NUMBER (15)
Data Set Id
TRANSLATION_DISPLAY_KEY VARCHAR2 (240)
Backup of middle tier display key information.

[top of page]

HXC.HXC_TIME_BUILDING_BLOCKS_AR does not reference any database object

HXC.HXC_TIME_BUILDING_BLOCKS_AR is referenced by following:

APPS
SYNONYM - HXC_TIME_BUILDING_BLOCKS_AR
TRIGGER - HXC_TIME_BUILDING_BLOCKS_A_WHO

[top of page]

Table: HXC_TIME_CATEGORIES

Description: Time Categories
Primary Key: HXC_TIME_CATEGORIES_PK
  1. TIME_CATEGORY_ID
  2. OBJECT_VERSION_NUMBER
Comments

HXC_TIME_CATEGORIES stores the different categories of time (like Regular, Premium, etc). Time categories are used to differentiate the number of hours entered on a timecard.

Indexes
Index Type Tablespace Column
HXC_TIME_CATEGORIES_PK UNIQUE APPS_TS_TX_IDX TIME_CATEGORY_ID
OBJECT_VERSION_NUMBER
HXC_TIME_CATEGORIES_UK1 UNIQUE APPS_TS_TX_IDX TIME_CATEGORY_NAME
Columns
Name Datatype Length Mandatory Comments
TIME_CATEGORY_ID NUMBER (15) Y Primary Key from sequence
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
TIME_CATEGORY_NAME VARCHAR2 (90) Y Name of the Category
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
TIME_SQL LONG (0)
Dynamic SQL string used to restrict on time category
OPERATOR VARCHAR2 (30)
Operator used for linking Time Categories
DESCRIPTION VARCHAR2 (240)
Time Category Description
DISPLAY VARCHAR2 (1)
Time Category Display Flag

[top of page]

HXC.HXC_TIME_CATEGORIES does not reference any database object

HXC.HXC_TIME_CATEGORIES is referenced by following:

APPS
SYNONYM - HXC_TIME_CATEGORIES
TRIGGER - HXC_TIME_CATEGORIES_WHO

[top of page]

Table: HXC_TIME_CATEGORY_COMPS

Description: Time Category Components
Primary Key: HXC_TIME_CATEGORY_COMPS_PK
  1. TIME_CATEGORY_COMP_ID
  2. OBJECT_VERSION_NUMBER
Comments

HXC_TIME_CATEGORY_COMPS stores the components of a time category. Time categories are used to differentiate the number of hours entered on a timecard.

Indexes
Index Type Tablespace Column
HXC_TIME_CATEGORY_COMPS_PK UNIQUE APPS_TS_TX_IDX TIME_CATEGORY_COMP_ID
OBJECT_VERSION_NUMBER
HXC_TIME_CATEGORY_COMPS_FK1 NONUNIQUE APPS_TS_TX_IDX TIME_CATEGORY_ID
COMPONENT_TYPE_ID
HXC_TIME_CATEGORY_COMPS_FK2 NONUNIQUE APPS_TS_TX_IDX TIME_CATEGORY_ID
REF_TIME_CATEGORY_ID
Columns
Name Datatype Length Mandatory Comments
TIME_CATEGORY_COMP_ID NUMBER (15) Y Primary Key from sequence
OBJECT_VERSION_NUMBER NUMBER (15) Y Object Version Number
TIME_CATEGORY_ID NUMBER (15) Y Foreign Key to HXC_TIME_CATEGORIES
REF_TIME_CATEGORY_ID NUMBER (15)
Self-Referencing Foreign Key to HXC_TIME_CATEGORIES
MAPPING_COMPONENT_ID NUMBER (15)
Mapping Component Id
FLEX_VALUE_SET_ID NUMBER (15)
Foreign Key to FND_FLEX_VALUE_SETS
VALUE_ID VARCHAR2 (150)
ID Based on the Flex Value Set chosen
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
SPECIFY_VALUE VARCHAR2 (1)
Specify Value Flag
COMPONENT_TYPE_ID NUMBER (15)
Foreign Key to HXC_MAPPING_COMPONENTS
IS_NULL VARCHAR2 (1)
Indicates if a Time Category Component is specific to a value or not.
EQUAL_TO VARCHAR2 (1)
Equal To Flag
TYPE VARCHAR2 (10)
Time Category Component Type

[top of page]

HXC.HXC_TIME_CATEGORY_COMPS does not reference any database object

HXC.HXC_TIME_CATEGORY_COMPS is referenced by following:

APPS
SYNONYM - HXC_TIME_CATEGORY_COMPS
TRIGGER - HXC_TIME_CATEGORY_COMPS_WHO

[top of page]

Table: HXC_TIME_CATEGORY_COMP_SQL

Description: Time Category Component SQLs Table
Comments

HXC_TIME_CATEGORY_COMPS_SQL stores the time category rules as SQL. These rules are defined for the time category components that are defined in HXC_TIME_CATEGORY_COMPS

Indexes
Index Type Tablespace Column
SYS_IL0000401793C00003$$ UNIQUE APPS_TS_TX_DATA
HXC_TIME_CATEGORY_COMP_SQL_FK1 NONUNIQUE APPS_TS_TX_IDX TIME_CATEGORY_COMP_ID
Columns
Name Datatype Length Mandatory Comments
TIME_CATEGORY_COMP_SQL_ID NUMBER (15) Y Time Category Component SQL Id
TIME_CATEGORY_COMP_ID NUMBER (15) Y Time Category Component Id
SQL_STRING CLOB (4000)
SQL Query String

[top of page]

HXC.HXC_TIME_CATEGORY_COMP_SQL does not reference any database object

HXC.HXC_TIME_CATEGORY_COMP_SQL is referenced by following:

APPS
SYNONYM - HXC_TIME_CATEGORY_COMP_SQL

[top of page]

Table: HXC_TIME_ENTRY_RULES

Description: Time Entry Rules
Primary Key: HXC_TIME_ENTRY_RULES_PK
  1. TIME_ENTRY_RULE_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_TIME_ENTRY_RULES.MAPPING_ID HXC_MAPPINGS
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_DATA_APP_RULE_USAGES.TIME_ENTRY_RULE_ID HXC_TIME_ENTRY_RULES
Comments

HXC_TIME_ENTRY_RULES stores the time entry rules which are used in the approvals process and on submission of a timecard - these rules allow for specific processing to take place - for example, they can be used to auto approve all timecards with less that 40 total hours.

Indexes
Index Type Tablespace Column
HXC_TIME_ENTRY_RULES_PK UNIQUE APPS_TS_TX_IDX TIME_ENTRY_RULE_ID
HXC_TIME_ENTRY_RULES_FK1 NONUNIQUE APPS_TS_TX_IDX MAPPING_ID
HXC_TIME_ENTRY_RULES_FK2 NONUNIQUE APPS_TS_TX_IDX BUSINESS_GROUP_ID
HXC_TIME_ENTRY_RULES_N1 NONUNIQUE APPS_TS_TX_IDX NAME
Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_ID NUMBER (15)
Foreign key to HR_ORGANIZATION_UNITS.
LEGISLATION_CODE VARCHAR2 (30)
The legislation to which the time entry rule applies
TIME_ENTRY_RULE_ID NUMBER (15) Y Primary Key from a sequence
NAME VARCHAR2 (80) Y Name of Time Entry Rule
RULE_USAGE VARCHAR2 (30) Y Usage of the Time Entry Rule based on lookup type HXC_APPROVAL_RULE_USAGE
FORMULA_ID NUMBER (9)
Foreign Key to FF_FORMULAS_F
DESCRIPTION VARCHAR2 (2000)
User-Defined Description of Time Entry Rule
START_DATE DATE
Y Start Date
END_DATE DATE

End Date
MAPPING_ID NUMBER (15)
Foreign Key to HXC_MAPPINGS
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
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
ATTRIBUTE21 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE22 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE23 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE24 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE25 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE26 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE27 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE28 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE29 VARCHAR2 (150)
Descriptive Flexfield Column
ATTRIBUTE30 VARCHAR2 (150)
Descriptive Flexfield Column

[top of page]

HXC.HXC_TIME_ENTRY_RULES does not reference any database object

HXC.HXC_TIME_ENTRY_RULES is referenced by following:

APPS
SYNONYM - HXC_TIME_ENTRY_RULES
TRIGGER - HXC_TIME_ENTRY_RULES_WHO

[top of page]

Table: HXC_TIME_RECIPIENTS

Description: Time Recipients
Primary Key: HXC_TIME_RECIPIENTS_PK
  1. TIME_RECIPIENT_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_APPROVAL_COMPS.TIME_RECIPIENT_ID HXC_TIME_RECIPIENTS
HXC_APPROVAL_PERIOD_COMPS.TIME_RECIPIENT_ID HXC_TIME_RECIPIENTS
HXC_DATA_APP_RULE_USAGES.TIME_RECIPIENT_ID HXC_TIME_RECIPIENTS
HXC_RETRIEVAL_PROCESSES.TIME_RECIPIENT_ID HXC_TIME_RECIPIENTS
HXC_RETRIEVAL_RULE_COMPS.TIME_RECIPIENT_ID HXC_TIME_RECIPIENTS
Comments

HXC_TIME_RECIPIENTS holds details of the Recipient Applications that are registered to use the Time Store.

Indexes
Index Type Tablespace Column
HXC_TIME_RECIPIENTS_PK UNIQUE APPS_TS_SEED TIME_RECIPIENT_ID
Columns
Name Datatype Length Mandatory Comments
TIME_RECIPIENT_ID NUMBER (15) Y Primary Key from sequence
NAME VARCHAR2 (80) Y Name of the Recipient Application.
APPLICATION_ID NUMBER (15)
Foreign Key to FND_APPLICATION.
APPL_DYNAMIC_TEMPLATE_PROCESS VARCHAR2 (2000)
Package.procedure used to implement a dynamic template selected on the timecard screen
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
APPLICATION_RETRIEVAL_FUNCTION VARCHAR2 (2000)
Package.procedure to obtain application mapping
APPLICATION_UPDATE_PROCESS VARCHAR2 (2000)
Package.procedure for application specific updates to time data
APPL_VALIDATION_PROCESS VARCHAR2 (2000)
Package.procedure to application specific validation
APPLICATION_PERIOD_FUNCTION VARCHAR2 (2000)
Package.procedure to support application specific time periods
EXTENSION_FUNCTION1 VARCHAR2 (2000)
Package.procedure to support client hooks
EXTENSION_FUNCTION2 VARCHAR2 (2000)
Package.procedure to support client hooks

[top of page]

HXC.HXC_TIME_RECIPIENTS does not reference any database object

HXC.HXC_TIME_RECIPIENTS is referenced by following:

APPS
SYNONYM - HXC_TIME_RECIPIENTS
TRIGGER - HXC_TIME_RECIPIENTS_WHO

[top of page]

Table: HXC_TIME_SOURCES

Description: Time Sources
Primary Key: HXC_TIME_SOURCES_PK
  1. TIME_SOURCE_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_DEPOSIT_PROCESSES.TIME_SOURCE_ID HXC_TIME_SOURCES
Comments

HXC_TIME_SOURCES holds details of applications or devices that are registered to deposit data into the Time Store.

Indexes
Index Type Tablespace Column
HXC_TIME_SOURCES_PK UNIQUE APPS_TS_SEED TIME_SOURCE_ID
Columns
Name Datatype Length Mandatory Comments
TIME_SOURCE_ID NUMBER (15) Y Primary Key from sequence
NAME VARCHAR2 (80) Y Name of Time Source.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

HXC.HXC_TIME_SOURCES does not reference any database object

HXC.HXC_TIME_SOURCES is referenced by following:

APPS
SYNONYM - HXC_TIME_SOURCES
TRIGGER - HXC_TIME_SOURCES_WHO

[top of page]

Table: HXC_TK_DETAIL_TEMP

Description:
Comments
Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER

TIMECARD_ID NUMBER

DETAILID NUMBER

COMMENT_TEXT VARCHAR2 (2000)
DFF_CATG VARCHAR2 (80)
DETAIL_ACTION VARCHAR2 (80)
DFF_ATTR1 VARCHAR2 (150)
DFF_ATTR2 VARCHAR2 (150)
DFF_ATTR3 VARCHAR2 (150)
DFF_ATTR4 VARCHAR2 (150)
DFF_ATTR5 VARCHAR2 (150)
DFF_ATTR6 VARCHAR2 (150)
DFF_ATTR7 VARCHAR2 (150)
DFF_ATTR8 VARCHAR2 (150)
DFF_ATTR9 VARCHAR2 (150)
DFF_ATTR10 VARCHAR2 (150)
DFF_ATTR11 VARCHAR2 (150)
DFF_ATTR12 VARCHAR2 (150)
DFF_ATTR13 VARCHAR2 (150)
DFF_ATTR14 VARCHAR2 (150)
DFF_ATTR15 VARCHAR2 (150)
DFF_ATTR16 VARCHAR2 (150)
DFF_ATTR17 VARCHAR2 (150)
DFF_ATTR18 VARCHAR2 (150)
DFF_ATTR19 VARCHAR2 (150)
DFF_ATTR20 VARCHAR2 (150)
DFF_ATTR21 VARCHAR2 (150)
DFF_ATTR22 VARCHAR2 (150)
DFF_ATTR23 VARCHAR2 (150)
DFF_ATTR24 VARCHAR2 (150)
DFF_ATTR25 VARCHAR2 (150)
DFF_ATTR26 VARCHAR2 (150)
DFF_ATTR27 VARCHAR2 (150)
DFF_ATTR28 VARCHAR2 (150)
DFF_ATTR29 VARCHAR2 (150)
DFF_ATTR30 VARCHAR2 (150)
DFF_OLDATTR1 VARCHAR2 (150)
DFF_OLDATTR2 VARCHAR2 (150)
DFF_OLDATTR3 VARCHAR2 (150)
DFF_OLDATTR4 VARCHAR2 (150)
DFF_OLDATTR5 VARCHAR2 (150)
DFF_OLDATTR6 VARCHAR2 (150)
DFF_OLDATTR7 VARCHAR2 (150)
DFF_OLDATTR8 VARCHAR2 (150)
DFF_OLDATTR9 VARCHAR2 (150)
DFF_OLDATTR10 VARCHAR2 (150)
DFF_OLDATTR11 VARCHAR2 (150)
DFF_OLDATTR12 VARCHAR2 (150)
DFF_OLDATTR13 VARCHAR2 (150)
DFF_OLDATTR14 VARCHAR2 (150)
DFF_OLDATTR15 VARCHAR2 (150)
DFF_OLDATTR16 VARCHAR2 (150)
DFF_OLDATTR17 VARCHAR2 (150)
DFF_OLDATTR18 VARCHAR2 (150)
DFF_OLDATTR19 VARCHAR2 (150)
DFF_OLDATTR20 VARCHAR2 (150)
DFF_OLDATTR21 VARCHAR2 (150)
DFF_OLDATTR22 VARCHAR2 (150)
DFF_OLDATTR23 VARCHAR2 (150)
DFF_OLDATTR24 VARCHAR2 (150)
DFF_OLDATTR25 VARCHAR2 (150)
DFF_OLDATTR26 VARCHAR2 (150)
DFF_OLDATTR27 VARCHAR2 (150)
DFF_OLDATTR28 VARCHAR2 (150)
DFF_OLDATTR29 VARCHAR2 (150)
DFF_OLDATTR30 VARCHAR2 (150)
DFF_OLDCATG VARCHAR2 (80)
CHANGE_REASON VARCHAR2 (150)
CHANGE_COMMENT VARCHAR2 (150)
LATE_REASON VARCHAR2 (150)
LATE_COMMENT VARCHAR2 (150)
LATE_CHANGE VARCHAR2 (20)
DESC_FLEX VARCHAR2 (1000)
ATTRIBUTE_CATEGORY VARCHAR2 (150)
AUDIT_DATETIME VARCHAR2 (80)
AUDIT_HISTORY VARCHAR2 (150)
DISP_INDEX VARCHAR2 (100)
OLD_CHANGE_REASON VARCHAR2 (150)
OLD_CHANGE_COMMENT VARCHAR2 (150)
OLD_LATE_REASON VARCHAR2 (150)
OLD_LATE_COMMENT VARCHAR2 (150)
OLD_AUDIT_HISTORY VARCHAR2 (150)
OLD_LATE_CHANGE VARCHAR2 (20)
OLD_AUDIT_DATETIME VARCHAR2 (80)

[top of page]

HXC.HXC_TK_DETAIL_TEMP does not reference any database object

HXC.HXC_TK_DETAIL_TEMP is referenced by following:

APPS
SYNONYM - HXC_TK_DETAIL_TEMP

[top of page]

Table: HXC_TK_GROUPS

Description: Timekeeper Groups
Primary Key: HXC_TK_GROUPS_PK
  1. TK_GROUP_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_TK_GROUP_QUERIES.TK_GROUP_ID HXC_TK_GROUPS
Comments

Timekeeper Groups for use in the timekeeper form

Indexes
Index Type Tablespace Column
HXC_TK_GROUPS_PK UNIQUE APPS_TS_TX_IDX TK_GROUP_ID
HXC_TK_GROUPS_N1 NONUNIQUE APPS_TS_TX_IDX TK_RESOURCE_ID
HXC_TK_GROUPS_N2 NONUNIQUE APPS_TS_TX_IDX BUSINESS_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
TK_GROUP_ID NUMBER (15) Y Primary Key
TK_GROUP_NAME VARCHAR2 (80) Y Timekeeper Group Name
TK_RESOURCE_ID NUMBER (15) Y The resource id (person id) of the timekeeper
OBJECT_VERSION_NUMBER NUMBER (9) Y object version number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
BUSINESS_GROUP_ID NUMBER (15)
Stores the Business Group Id

[top of page]

HXC.HXC_TK_GROUPS does not reference any database object

HXC.HXC_TK_GROUPS is referenced by following:

APPS
SYNONYM - HXC_TK_GROUPS
TRIGGER - HXC_TK_GROUPS_WHO

[top of page]

Table: HXC_TK_GROUP_QUERIES

Description: Timekeeper Group Queries
Primary Key: HXC_TK_GROUP_QUERY_PK
  1. TK_GROUP_QUERY_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_TK_GROUP_QUERIES.TK_GROUP_ID HXC_TK_GROUPS
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_TK_GROUP_QUERY_CRITERIA.TK_GROUP_QUERY_ID HXC_TK_GROUP_QUERIES
Comments

Stores the timekeeper group queries used to define the timekeeper group

Indexes
Index Type Tablespace Column
HXC_TK_GROUP_QUERY_PK UNIQUE APPS_TS_TX_IDX TK_GROUP_QUERY_ID
HXC_TK_GROUP_QUERY_FK1 NONUNIQUE APPS_TS_TX_IDX TK_GROUP_ID
Columns
Name Datatype Length Mandatory Comments
TK_GROUP_QUERY_ID NUMBER (15) Y Primary Key
GROUP_QUERY_NAME VARCHAR2 (30) Y Timekeeper group query name
TK_GROUP_ID NUMBER (15) Y Foreign key to Timekeeper Groups
INCLUDE_EXCLUDE VARCHAR2 (1) Y Include or Exclude the criteria from this query in the group. 'I' for Include, 'E' for Exclude.
SYSTEM_USER VARCHAR2 (1) Y Is this a Sytem generated or User defined query? 'S' for System and 'U' for User.
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

HXC.HXC_TK_GROUP_QUERIES does not reference any database object

HXC.HXC_TK_GROUP_QUERIES is referenced by following:

APPS
SYNONYM - HXC_TK_GROUP_QUERIES
TRIGGER - HXC_TK_GROUP_QUERIES_WHO

[top of page]

Table: HXC_TK_GROUP_QUERY_CRITERIA

Description: Timekeeper Group Query Criteria
Primary Key: HXC_TK_GROUP_QUERY_CRITERIA_PK
  1. TK_GROUP_QUERY_CRITERIA_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_TK_GROUP_QUERY_CRITERIA.TK_GROUP_QUERY_ID HXC_TK_GROUP_QUERIES
Comments

The criteria which make up each timekeeper group query for the timekeeper groups.

Indexes
Index Type Tablespace Column
HXC_TK_GRP_QUERY_CRITERIA_PK UNIQUE APPS_TS_TX_IDX TK_GROUP_QUERY_CRITERIA_ID
HXC_TK_GRP_QUERY_CRITERIA_FK1 NONUNIQUE APPS_TS_TX_IDX TK_GROUP_QUERY_ID
HXC_TK_GRP_QUERY_CRITERIA_N1 NONUNIQUE APPS_TS_TX_IDX CRITERIA_ID
Columns
Name Datatype Length Mandatory Comments
TK_GROUP_QUERY_CRITERIA_ID NUMBER (15) Y Primary Key
TK_GROUP_QUERY_ID NUMBER (15) Y Foreign Key to Timekeeper Group Queries
CRITERIA_TYPE VARCHAR2 (30) Y The type of criteria specified in the Criteria Id, for example, 'PERSON' would mean a person is stored in Criteria Id
CRITERIA_ID NUMBER (15) Y The unique identifier of the entity specified in Criteria Type
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

HXC.HXC_TK_GROUP_QUERY_CRITERIA does not reference any database object

HXC.HXC_TK_GROUP_QUERY_CRITERIA is referenced by following:

APPS
SYNONYM - HXC_TK_GROUP_QUERY_CRITERIA
TRIGGER - HXC_TK_GROUP_QUERY_CRITERI_WHO

[top of page]

Table: HXC_TK_TIMEKEEPER_SUBMITS

Description: TimeKeeper Submits Table
Comments

Used to store information regarding Timekeeper Submit Data

Columns
Name Datatype Length Mandatory Comments
SUBMISSION_ID NUMBER
Y Stores the Submission Id, Autogenerated by sequence
RESOURCE_ID NUMBER
Y Stores the Person Id

[top of page]

HXC.HXC_TK_TIMEKEEPER_SUBMITS does not reference any database object

HXC.HXC_TK_TIMEKEEPER_SUBMITS is referenced by following:

APPS
SYNONYM - HXC_TK_TIMEKEEPER_SUBMITS

[top of page]

Table: HXC_TRANSACTIONS

Description: Transactions
Primary Key: HXC_TRANSACTIONS_PK
  1. TRANSACTION_ID
Foreign Keys to this table:
Foreign Key Column Foreign Table
HXC_TRANSACTION_DETAILS.TRANSACTION_ID HXC_TRANSACTIONS
Comments

HXC_TRANSACTIONS records details of the execution of a Deposit or Retrieval Process in the Time Store.

Indexes
Index Type Tablespace Column
HXC_TRANSACTIONS_PK UNIQUE APPS_TS_TX_IDX TRANSACTION_ID
HXC_TRANSACTIONS_N2 NONUNIQUE APPS_TS_TX_IDX DATA_SET_ID
HXC_TRANSACTIONS_N3 NONUNIQUE APPS_TS_TX_IDX TYPE
TRANSACTION_PROCESS_ID
STATUS
TRANSACTION_ID
HXC_TRANSACTION_N1 NONUNIQUE APPS_TS_TX_IDX STATUS
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER (15) Y Primary Key from sequence
TRANSACTION_PROCESS_ID NUMBER (15)
Implicit Foreign Key to HXC_DEPOSIT_PROCESSES or HXC_RETRIEVAL_PROCESSES.
TRANSACTION_DATE DATE
Y Date of transaction.
TYPE VARCHAR2 (30) Y Indicates whether the Transaction was a Deposit or a Retrieval.
STATUS VARCHAR2 (30)
Indicates whether or not the Transaction was successful.
TRANSACTION_CODE VARCHAR2 (30)
User defined unique identifier for the transaction
EXCEPTION_DESCRIPTION VARCHAR2 (2000)
Indicates any error raised by the Process.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
DATA_SET_ID NUMBER (15)
Data Set Id

[top of page]

HXC.HXC_TRANSACTIONS does not reference any database object

HXC.HXC_TRANSACTIONS is referenced by following:

APPS
SYNONYM - HXC_TRANSACTIONS
TRIGGER - HXC_TRANSACTIONS_WHO

[top of page]

Table: HXC_TRANSACTIONS_AR

Description: Transactions Archive
Comments

HXC_TRANSACTIONS_AR holds the archived entries of HXC_TRANSACTIONS.

Indexes
Index Type Tablespace Column
HXC_TRANSACTIONS_AR_PK UNIQUE APPS_TS_ARCHIVE TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER (15) Y Primary Key from sequence
TRANSACTION_PROCESS_ID NUMBER (15)
Implicit Foreign Key to HXC_DEPOSIT_PROCESSES or HXC_RETRIEVAL_PROCESSES.
TRANSACTION_DATE DATE
Y Date of transaction.
TYPE VARCHAR2 (30) Y Indicates whether the Transaction was a Deposit or a Retrieval.
STATUS VARCHAR2 (30)
Indicates whether or not the Transaction was successful.
TRANSACTION_CODE VARCHAR2 (30)
User defined unique identifier for the transaction
EXCEPTION_DESCRIPTION VARCHAR2 (2000)
Indicates any error raised by the Process.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
DATA_SET_ID NUMBER (15)
Data Set Id

[top of page]

HXC.HXC_TRANSACTIONS_AR does not reference any database object

HXC.HXC_TRANSACTIONS_AR is referenced by following:

APPS
SYNONYM - HXC_TRANSACTIONS_AR
TRIGGER - HXC_TRANSACTIONS_AR_WHO

[top of page]

Table: HXC_TRANSACTION_DETAILS

Description: Transaction Details
Primary Key: HXC_TRANSACTION_DETAILS_PK
  1. TRANSACTION_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column Foreign Table
HXC_TRANSACTION_DETAILS.TIME_BUILDING_BLOCK_ID
HXC_TRANSACTION_DETAILS.TIME_BUILDING_BLOCK_OVN 		HXC_TIME_BUILDING_BLOCKS
HXC_TRANSACTION_DETAILS.TRANSACTION_ID HXC_TRANSACTIONS
Comments

HXC_TRANSACTION_DETAILS holds details of the Time Building Blocks that were involved in a Transaction.

Indexes
Index Type Tablespace Column
HXC_TRANSACTION_DETAILS_PK UNIQUE APPS_TS_TX_IDX TRANSACTION_DETAIL_ID
HXC_TRANSACTION_DETAILS_FK1 NONUNIQUE APPS_TS_TX_IDX TIME_BUILDING_BLOCK_ID
TIME_BUILDING_BLOCK_OVN
HXC_TRANSACTION_DETAILS_FK2 NONUNIQUE APPS_TS_TX_IDX TRANSACTION_ID
HXC_TRANSACTION_DETAILS_N1 NONUNIQUE APPS_TS_TX_IDX DATA_SET_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_DETAIL_ID NUMBER (15) Y Primary Key from sequence
TIME_BUILDING_BLOCK_ID NUMBER (15) Y Foreign Key to HXC_TIME_BUILDING_BLOCKS.
TRANSACTION_ID NUMBER (15) Y Foreign Key to HXC_TRANSACTIONS.
STATUS VARCHAR2 (30)
Indicates whether or not the Building Block was successfully deposited or retrieved.
EXCEPTION_DESCRIPTION VARCHAR2 (2000)
Indicates any error related to the Transaction on the Building Block.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
TIME_BUILDING_BLOCK_OVN NUMBER (9)
The Object Version Number of the Time Building Block row - together with TIME_BUILDING_BLOCK_ID uniquely identifies a row in hxc_time_building_blocks
DATA_SET_ID NUMBER (15)
Data Set Id

[top of page]

HXC.HXC_TRANSACTION_DETAILS does not reference any database object

HXC.HXC_TRANSACTION_DETAILS is referenced by following:

APPS
SYNONYM - HXC_TRANSACTION_DETAILS
TRIGGER - HXC_TRANSACTION_DETAILS_WHO

[top of page]

Table: HXC_TRANSACTION_DETAILS_AR

Description: Transaction Details Archive
Comments

HXC_TRANSACTION_DETAILS_AR holds the archived entries of HXC_TRANSACTION_DETAILS.

Indexes
Index Type Tablespace Column
HXC_TRANS_DETAILS_AR_PK UNIQUE APPS_TS_ARCHIVE TRANSACTION_DETAIL_ID
HXC_TRANS_DETAILS_AR_FK1 NONUNIQUE APPS_TS_ARCHIVE TIME_BUILDING_BLOCK_ID
TIME_BUILDING_BLOCK_OVN
HXC_TRANS_DETAILS_AR_FK2 NONUNIQUE APPS_TS_ARCHIVE TRANSACTION_ID
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_DETAIL_ID NUMBER (15) Y Primary Key from sequence
TIME_BUILDING_BLOCK_ID NUMBER (15) Y Foreign Key to HXC_TIME_BUILDING_BLOCKS.
TRANSACTION_ID NUMBER (15) Y Foreign Key to HXC_TRANSACTIONS.
STATUS VARCHAR2 (30)
Indicates whether or not the Building Block was successfully deposited or retrieved.
EXCEPTION_DESCRIPTION VARCHAR2 (2000)
Indicates any error related to the Transaction on the Building Block.
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
TIME_BUILDING_BLOCK_OVN NUMBER (9)
The Object Version Number of the Time Building Block row - together with TIME_BUILDING_BLOCK_ID uniquely identifies a row in hxc_time_building_blocks
DATA_SET_ID NUMBER (15)
Data Set Id

[top of page]

HXC.HXC_TRANSACTION_DETAILS_AR does not reference any database object

HXC.HXC_TRANSACTION_DETAILS_AR is referenced by following:

APPS
SYNONYM - HXC_TRANSACTION_DETAILS_AR
TRIGGER - HXC_TRANSACTION_DETAILS_AR_WHO

[top of page]

View: HXC_ALIAS_DEFINITIONS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ALIAS_DEFINITION_ID NUMBER (15)
ALIAS_DEFINITION_NAME VARCHAR2 (80)
ALIAS_CONTEXT_NAME VARCHAR2 (80)
ALIAS_CONTEXT_CODE VARCHAR2 (30)
BUSINESS_GROUP_ID NUMBER (15)
LEGISLATION_CODE VARCHAR2 (30)
DESCRIPTION VARCHAR2 (240)
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.
OBJECT_VERSION_NUMBER NUMBER (9)
ALIAS_TYPE VARCHAR2 (30)
ALIAS_TYPE_ID NUMBER (15)
PROMPT VARCHAR2 (240)

[top of page]

APPS.HXC_ALIAS_DEFINITIONS_V references the following:

APPS
VIEW - FND_DESCR_FLEX_CONTEXTS_VL
SYNONYM - FND_FLEX_VALUE_SETS
SYNONYM - HXC_ALIAS_DEFINITIONS
SYNONYM - HXC_ALIAS_DEFINITIONS_TL
SYNONYM - HXC_ALIAS_TYPES

APPS.HXC_ALIAS_DEFINITIONS_V is not referenced by any database object

[top of page]

View: HXC_ALIAS_TYPES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ALIAS_TYPE_ID NUMBER (15)
ALIAS_TYPE VARCHAR2 (30)
REFERENCE_OBJECT VARCHAR2 (150)
D_REFERENCE_OBJECT_NAME VARCHAR2 (80)
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (9)
MEANING VARCHAR2 (4000)

[top of page]

APPS.HXC_ALIAS_TYPES_V references the following:

APPS
VIEW - FND_DESCR_FLEX_CONTEXTS_VL
SYNONYM - FND_FLEX_VALUE_SETS
PACKAGE - HR_BIS
SYNONYM - HXC_ALIAS_TYPES

APPS.HXC_ALIAS_TYPES_V is not referenced by any database object

[top of page]

View: HXC_ALIAS_TYPE_COMPONENTS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ALIAS_TYPE_COMPONENT_ID NUMBER (15) Y
COMPONENT_NAME VARCHAR2 (240) Y
COMPONENT_TYPE VARCHAR2 (80) Y
MAPPING_COMPONENT_ID NUMBER (15) Y
MAPPING_COMPONENT_NAME VARCHAR2 (80)
ALIAS_TYPE_ID NUMBER (15) Y
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
CREATED_BY NUMBER (15)
CREATION_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (9)

[top of page]

APPS.HXC_ALIAS_TYPE_COMPONENTS_V references the following:

APPS
SYNONYM - HXC_ALIAS_TYPE_COMPONENTS
SYNONYM - HXC_MAPPING_COMPONENTS

APPS.HXC_ALIAS_TYPE_COMPONENTS_V is not referenced by any database object

[top of page]

View: HXC_ALIAS_VALUES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ALIAS_VALUE_ID NUMBER (15) Y
ALIAS_VALUE_NAME VARCHAR2 (80) Y
DATE_FROM DATE
Y
DATE_TO DATE

ALIAS_DEFINITION_ID NUMBER (15) Y
ENABLED_FLAG VARCHAR2 (9) Y
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)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
ATTRIBUTE21 VARCHAR2 (150)
ATTRIBUTE22 VARCHAR2 (150)
ATTRIBUTE23 VARCHAR2 (150)
ATTRIBUTE24 VARCHAR2 (150)
ATTRIBUTE25 VARCHAR2 (150)
ATTRIBUTE26 VARCHAR2 (150)
ATTRIBUTE27 VARCHAR2 (150)
ATTRIBUTE28 VARCHAR2 (150)
ATTRIBUTE29 VARCHAR2 (150)
ATTRIBUTE30 VARCHAR2 (150)
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.
OBJECT_VERSION_NUMBER NUMBER (9)

[top of page]

APPS.HXC_ALIAS_VALUES_V references the following:

APPS
SYNONYM - HXC_ALIAS_VALUES
SYNONYM - HXC_ALIAS_VALUES_TL

APPS.HXC_ALIAS_VALUES_V is not referenced by any database object

[top of page]

View: HXC_APPLICATION_PERIODS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
TIME_BUILDING_BLOCK_ID NUMBER (15) Y
OBJECT_VERSION_NUMBER NUMBER (9) Y
START_TIME DATE

STOP_TIME DATE

TYPE VARCHAR2 (30) Y
MEASURE NUMBER

UNIT_OF_MEASURE VARCHAR2 (30)
PARENT_BUILDING_BLOCK_ID NUMBER (15)
PARENT_BUILDING_BLOCK_OVN NUMBER (9)
SCOPE VARCHAR2 (30) Y
APPROVAL_STYLE_ID NUMBER (15)
APPROVAL_STATUS VARCHAR2 (30) Y
RESOURCE_TYPE VARCHAR2 (30)
RESOURCE_ID NUMBER (15)
COMMENT_TEXT VARCHAR2 (150)
APPLICATION VARCHAR2 (150)
ITEMKEY VARCHAR2 (150)
NOTIFY VARCHAR2 (150)
APPROVER_STATUS VARCHAR2 (150)
SUBMITTED_OVN NUMBER (9) Y
SUBMISSION_DATE DATE

[top of page]

APPS.HXC_APPLICATION_PERIODS_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - HXC_TIME_ATTRIBUTES
SYNONYM - HXC_TIME_ATTRIBUTE_USAGES
SYNONYM - HXC_TIME_BUILDING_BLOCKS
APPS.HXC_APPLICATION_PERIODS_V is referenced by following:

APPS
VIEW - HXC_APPROVAL_DETAILS_V

[top of page]

View: HXC_APPLICATION_SETS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
APPLICATION_SET_ID NUMBER (15) Y
APPLICATION_SET_NAME VARCHAR2 (80) Y
OBJECT_VERSION_NUMBER NUMBER

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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

APPS.HXC_APPLICATION_SETS_V references the following:

APPS
SYNONYM - HXC_ENTITY_GROUPS
APPS.HXC_APPLICATION_SETS_V is referenced by following:

APPS
PACKAGE BODY - HXC_APPROVAL_WF_PKG
PACKAGE BODY - HXC_APS_UPLOAD_PKG
PACKAGE BODY - HXC_ASC_UPLOAD_PKG
PACKAGE BODY - HXC_DATA_SET
PACKAGE BODY - HXC_GENERIC_RETRIEVAL_UTILS
PACKAGE BODY - HXC_HPH_UPLOAD_PKG
PACKAGE BODY - HXC_SETUP_VALIDATION_PKG
PACKAGE BODY - HXC_TIMECARD_APPROVAL
PACKAGE BODY - HXT_HXC_RETRIEVAL_PROCESS

[top of page]

View: HXC_APPLICATION_SET_COMPS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
APPLICATION_SET_COMP_ID NUMBER (15) Y
APPLICATION_SET_ID NUMBER (15) Y
TIME_RECIPIENT_ID NUMBER (15) Y
TIME_RECIPIENT_NAME VARCHAR2 (80) Y
OBJECT_VERSION_NUMBER NUMBER

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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

APPS.HXC_APPLICATION_SET_COMPS_V references the following:

APPS
SYNONYM - HXC_ENTITY_GROUP_COMPS
SYNONYM - HXC_TIME_RECIPIENTS
APPS.HXC_APPLICATION_SET_COMPS_V is referenced by following:

APPS
PACKAGE BODY - HXC_APPLICATION_SET_COMP_API
PACKAGE BODY - HXC_APPROVAL_WF_PKG
PACKAGE BODY - HXC_APP_ATTRIBUTE_UTILS
PACKAGE BODY - HXC_ASC_UPLOAD_PKG
PACKAGE BODY - HXC_DATA_SET
PACKAGE BODY - HXC_ELP_UTILS
PACKAGE BODY - HXC_GENERIC_RETRIEVAL_PKG
PACKAGE BODY - HXC_GENERIC_RETRIEVAL_UTILS
PACKAGE BODY - HXC_HTR_BUS
PACKAGE BODY - HXC_SELF_SERVICE_TIMECARD
PACKAGE BODY - HXC_SELF_SERVICE_TIME_DEPOSIT
PACKAGE BODY - HXC_SETUP_VALIDATION_PKG
PACKAGE BODY - HXC_TCSUMMARY_MIGRATE
PACKAGE BODY - HXC_TIMECARD_APPROVAL
PACKAGE BODY - HXC_TIMECARD_VALIDATION
PACKAGE BODY - HXT_HXC_RETRIEVAL_PROCESS

[top of page]

View: HXC_APPL_PERIOD_DETAILS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
APPLICATION_PERIOD_ID NUMBER (15) Y
RESOURCE_ID NUMBER (15)
APPROVAL_STATUS VARCHAR2 (30) Y
TIMECARD_ID NUMBER (15) Y
TIMECARD_START_TIME DATE

TIMECARD_STOP_TIME DATE

TIMECARD_STATUS VARCHAR2 (30) Y
TIME_RECIPIENT_ID VARCHAR2 (150)

[top of page]

APPS.HXC_APPL_PERIOD_DETAILS_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - HXC_TIME_ATTRIBUTES
SYNONYM - HXC_TIME_ATTRIBUTE_USAGES
SYNONYM - HXC_TIME_BUILDING_BLOCKS

APPS.HXC_APPL_PERIOD_DETAILS_V is not referenced by any database object

[top of page]

View: HXC_APPROVAL_COMPS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
APPROVAL_COMP_ID NUMBER (15)
APPROVAL_STYLE_ID NUMBER (15)
STYLE_NAME VARCHAR2 (80)
TIME_RECIPIENT_ID NUMBER (15)
APPLICATION VARCHAR2 (80)
APPROVAL_MECHANISM VARCHAR2 (30)
TYPE VARCHAR2 (80)
APPROVAL_MECHANISM_ID NUMBER (15)
IDENTIFIER VARCHAR2 (240)
SEQUENCE NUMBER (15)
START_DATE DATE

END_DATE DATE

WF_ITEM_TYPE VARCHAR2 (8)
WF_NAME VARCHAR2 (30)
OBJECT_VERSION_NUMBER NUMBER (9)
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
TIME_CATEGORY_NAME VARCHAR2 (90)
Time category Name
TIME_CATEGORY_ID NUMBER (15)
Time Category Id
PARENT_COMP_ID NUMBER (15)
Approval component id of parent
PARENT_COMP_OVN NUMBER (9)
Object Version Number of Parent
RUN_RECIPIENT_EXTENSIONS VARCHAR2 (1)

[top of page]

APPS.HXC_APPROVAL_COMPS_V references the following:

APPS
SYNONYM - FF_FORMULAS_F
SYNONYM - FF_FORMULA_TYPES
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - HR_STANDARD_LOOKUPS
SYNONYM - HXC_APPROVAL_COMPS
SYNONYM - HXC_APPROVAL_STYLES
SYNONYM - HXC_TIME_CATEGORIES
SYNONYM - HXC_TIME_RECIPIENTS
VIEW - PER_PEOPLE_X
VIEW - WF_ACTIVITIES_VL

APPS.HXC_APPROVAL_COMPS_V is not referenced by any database object

[top of page]

View: HXC_APPROVAL_DETAILS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
APRV_TIMECARD_ID NUMBER (15) Y
APRV_TIMECARD_OVN NUMBER (9) Y
APRV_RESOURCE_ID NUMBER (15)
APRV_APPROVAL_STATUS VARCHAR2 (30) Y
DETAIL_MEASURE NUMBER

DETAIL_COMMENT_TEXT VARCHAR2 (2000)
DETAIL_PROJECT_NUMBER VARCHAR2 (150)
DETAIL_TASK_NUMBER VARCHAR2 (150)
DETAIL_EXPENDITURE_TYPE VARCHAR2 (150)
DETAIL_HOURS_TYPE VARCHAR2 (20)
TCRD_START_TIME DATE

TCRD_STOP_TIME DATE

TCRD_APPROVAL_STATUS VARCHAR2 (4000)
TCRD_COMMENT_TEXT VARCHAR2 (2000)
TCRD_SUBMISSION_DATE DATE
Y
TCRD_RESOURCE_ID NUMBER (15)
TCRD_RESOURCE_TYPE VARCHAR2 (30)
EMPLOYEE_NAME VARCHAR2 (240)
APRV_TIME_RECIPIENT_ID VARCHAR2 (150)

[top of page]

APPS.HXC_APPROVAL_DETAILS_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - HXC_APPLICATION_PERIODS_V
VIEW - HXC_MAPPING_ATTRIBUTES_V
VIEW - HXC_TIMECARDS_V
VIEW - HXC_TIMECARD_DAYS_V
VIEW - HXC_TIMECARD_DETAILS_V
VIEW - PER_PEOPLE_F

APPS.HXC_APPROVAL_DETAILS_V is not referenced by any database object

[top of page]

View: HXC_APPROVAL_PERIOD_COMPS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
APPROVAL_PERIOD_COMP_ID NUMBER (15) Y
APPROVAL_PERIOD_SET_ID NUMBER (15) Y
TIME_RECIPIENT_ID NUMBER (15) Y
TIME_RECIPIENT_NAME VARCHAR2 (80) Y
RECURRING_PERIOD_ID NUMBER (15) Y
RECURRING_PERIOD_NAME VARCHAR2 (80) Y
OBJECT_VERSION_NUMBER NUMBER (9)
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

APPS.HXC_APPROVAL_PERIOD_COMPS_V references the following:

APPS
SYNONYM - HXC_APPROVAL_PERIOD_COMPS
SYNONYM - HXC_RECURRING_PERIODS
SYNONYM - HXC_TIME_RECIPIENTS
APPS.HXC_APPROVAL_PERIOD_COMPS_V is referenced by following:

APPS
PACKAGE BODY - HXC_APC_UPLOAD_PKG

[top of page]

View: HXC_APPROVAL_STYLES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
BUSINESS_GROUP_ID NUMBER (15)
Business Group Id
LEGISLATION_CODE VARCHAR2 (30)
Legislation Code
APPROVAL_STYLE_ID NUMBER (15) Y Approval Style Id
NAME VARCHAR2 (80) Y Approval Style Name
DESCRIPTION VARCHAR2 (2000)
Description of Approval Style
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version Number of Approval Style
RUN_RECIPIENT_EXTENSIONS VARCHAR2 (1)
Run Recipient Extensions
ADMIN_ROLE VARCHAR2 (320)
Admin Role
ERROR_ADMIN_ROLE VARCHAR2 (320)
Error Admin Role
TIMEOUTS_ENABLED VARCHAR2 (4000)
Timeout Enabled Flag
NUMBER_RETRIES NUMBER

Number of retries if any.
APPROVER_TIMEOUT NUMBER

Approver Timeout Value
PREPARER_TIMEOUT NUMBER

Preparer Timeout Value
ADMIN_TIMEOUT NUMBER

Admin Timeout Value
NOTIFY_SUPERVISOR VARCHAR2 (4000)
Notify Supervisor Flag
NOTIFY_WORKER_ON_SUBMIT VARCHAR2 (4000)
Notify Worker On Submit Flag
NOTIFY_WORKER_ON_AA VARCHAR2 (4000)
Notify Worker On AA Flag
NOTIFY_PREPARER_APPROVED VARCHAR2 (4000)
Notify Preparer Approved Flag
NOTIFY_PREPARER_REJECTED VARCHAR2 (4000)
Notify Prepare on Rejected Flag
NOTIFY_PREPARER_TRANSFER VARCHAR2 (4000)
Notify Preparer on Transfer Flag
CREATED_BY NUMBER (15)
Created By
CREATION_DATE DATE

Creation Date
LAST_UPDATED_BY NUMBER (15)
Last Updated By
LAST_UPDATE_DATE DATE

Last Updated Date
LAST_UPDATE_LOGIN NUMBER (15)
Last Updated Login

[top of page]

APPS.HXC_APPROVAL_STYLES_V references the following:

APPS
SYNONYM - HXC_APPROVAL_STYLES
PACKAGE - HXC_NOTIFICATION_HELPER
APPS.HXC_APPROVAL_STYLES_V is referenced by following:

APPS
PACKAGE BODY - HXC_NOTIFICATION_HELPER

[top of page]

View: HXC_APPR_REJECTION_COMMENTS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER
Y
START_TIME DATE
Y
STOP_TIME DATE
Y
COMMENT_TEXT VARCHAR2 (2000)
TIMECARD_ID NUMBER
Y
TIMECARD_OVN NUMBER
Y

[top of page]

APPS.HXC_APPR_REJECTION_COMMENTS_V references the following:

APPS
SYNONYM - HXC_APP_PERIOD_SUMMARY
SYNONYM - HXC_TC_AP_LINKS
SYNONYM - HXC_TIMECARD_SUMMARY
SYNONYM - HXC_TIME_BUILDING_BLOCKS

APPS.HXC_APPR_REJECTION_COMMENTS_V is not referenced by any database object

[top of page]

View: HXC_APP_PERIOD_TOTAL_TIME_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER (15) Y Timecard time building block id
RESOURCE_ID NUMBER (15)
Resource id
DAY_ID NUMBER (15) Y DAY scope time building block id
DETAIL_ID NUMBER (15) Y DETAIL scope time building block id
STATUS_CODE VARCHAR2 (30) Y Approval Status of the TIMECARD scope time building block
STATUS_NAME VARCHAR2 (80)
Meaning of the Status Code
START_DATE DATE

Start Time of the DAY
STOP_DATE DATE

Start Time of the DAY
HOURS_WORKED NUMBER

Sum of the DETAIL hours for the TIMECARD
APPLICATION_PERIOD_ID NUMBER
Y Application Period ID

[top of page]

APPS.HXC_APP_PERIOD_TOTAL_TIME_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - HXC_AP_DETAIL_LINKS
SYNONYM - HXC_TIME_BUILDING_BLOCKS
PACKAGE - HXC_TIME_CATEGORY_UTILS_PKG
APPS.HXC_APP_PERIOD_TOTAL_TIME_V is referenced by following:

APPS
PACKAGE BODY - HXC_TIME_CATEGORY_UTILS_PKG

[top of page]

View: HXC_BASE_PA_ONLINE_PROJECTS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
PROJECT_NUMBER VARCHAR2 (25) Y
PROJECT_NAME VARCHAR2 (30) Y
PROJECT_ID NUMBER (15) Y
START_DATE DATE

COMPLETION_DATE DATE

CARRYING_OUT_ORGANIZATION_ID NUMBER (15) Y
PROJECT_DETAILS VARCHAR2 (58)

[top of page]

APPS.HXC_BASE_PA_ONLINE_PROJECTS_V references the following:

APPS
SYNONYM - PA_PROJECTS_ALL
APPS.HXC_BASE_PA_ONLINE_PROJECTS_V is referenced by following:

APPS
VIEW - HXC_TIMECARD_AUDIT_SUMMARY

[top of page]

View: HXC_BASE_PA_ONLINE_TASKS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TASK_NUMBER VARCHAR2 (25) Y
TASK_NAME VARCHAR2 (20) Y
TASK_ID NUMBER (15) Y
BILLABLE_FLAG VARCHAR2 (1)
PROJECT_ID NUMBER (15) Y
START_DATE DATE

COMPLETION_DATE DATE

CHARGEABLE_FLAG VARCHAR2 (1)
TASK_DETAILS VARCHAR2 (46)

[top of page]

APPS.HXC_BASE_PA_ONLINE_TASKS_V references the following:

APPS
SYNONYM - PA_TASKS
APPS.HXC_BASE_PA_ONLINE_TASKS_V is referenced by following:

APPS
VIEW - HXC_TIMECARD_AUDIT_SUMMARY

[top of page]

View: HXC_DATA_APP_RULE_USAGES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
DATA_APP_RULE_USAGE_ID NUMBER (15) Y
APPROVAL_STYLE_ID NUMBER (15) Y
APPROVAL_STYLE_NAME VARCHAR2 (80) Y
TIME_ENTRY_RULE_ID NUMBER (15) Y
RULE VARCHAR2 (80) Y
TIME_RECIPIENT_ID NUMBER (15) Y
APPLICATION VARCHAR2 (80)
OBJECT_VERSION_NUMBER NUMBER (9)
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

APPS.HXC_DATA_APP_RULE_USAGES_V references the following:

APPS
SYNONYM - HXC_APPROVAL_STYLES
SYNONYM - HXC_DATA_APP_RULE_USAGES
SYNONYM - HXC_TIME_ENTRY_RULES
SYNONYM - HXC_TIME_RECIPIENTS

APPS.HXC_DATA_APP_RULE_USAGES_V is not referenced by any database object

[top of page]

View: HXC_LAYOUTS_VL

Comments
View Type

MultiLingual view (a language resolved view of the data.)

Columns
Name Datatype Length Mandatory Comments
LAYOUT_ID NUMBER (15) Y
LAYOUT_NAME VARCHAR2 (30) Y
DISPLAY_LAYOUT_NAME VARCHAR2 (240) Y
APPLICATION_ID NUMBER (15) Y
LAYOUT_TYPE VARCHAR2 (30) Y
MODIFIER_LEVEL VARCHAR2 (30)
MODIFIER_VALUE VARCHAR2 (240)
TOP_LEVEL_REGION_CODE VARCHAR2 (30)
OBJECT_VERSION_NUMBER NUMBER (9) Y
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.

[top of page]

APPS.HXC_LAYOUTS_VL references the following:

APPS
SYNONYM - HXC_LAYOUTS
SYNONYM - HXC_LAYOUTS_TL

APPS.HXC_LAYOUTS_VL is not referenced by any database object

[top of page]

View: HXC_LAYOUT_COMPONENTS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
LAYOUT_COMPONENT_ID NUMBER (15) Y
LAYOUT_ID NUMBER (15) Y
PARENT_COMPONENT_ID NUMBER (15)
COMPONENT_NAME VARCHAR2 (240)
COMPONENT_VALUE VARCHAR2 (240)
SEQUENCE NUMBER (9) Y
NAME_VALUE_STRING VARCHAR2 (2000)
COMPONENT_TYPE VARCHAR2 (30)
COMPONENT_CLASS VARCHAR2 (240) Y
RENDER_TYPE VARCHAR2 (30) Y
LABEL VARCHAR2 (80)
DESCRIPTION VARCHAR2 (2000)
CSS_CLASS VARCHAR2 (80)
COMPONENT_ALIAS VARCHAR2 (240)
PARENT_BEAN VARCHAR2 (240)
ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
QUALIFIER_NAME VARCHAR2 (240)
QUALIFIER_ATTRIBUTE_CATEGORY VARCHAR2 (30)
QUALIFIER_ATTRIBUTE1 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE2 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE3 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE4 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE5 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE6 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE7 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE8 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE9 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE10 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE11 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE12 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE13 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE14 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE15 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE16 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE17 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE18 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE19 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE20 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE21 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE22 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE23 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE24 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE25 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE26 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE27 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE28 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE29 VARCHAR2 (240)
QUALIFIER_ATTRIBUTE30 VARCHAR2 (240)

[top of page]

APPS.HXC_LAYOUT_COMPONENTS_V references the following:

APPS
SYNONYM - AK_REGION_ITEMS
SYNONYM - AK_REGION_ITEMS_TL
SYNONYM - HXC_LAYOUT_COMPONENTS
SYNONYM - HXC_LAYOUT_COMP_DEFINITIONS
SYNONYM - HXC_LAYOUT_COMP_QUALIFIERS
APPS.HXC_LAYOUT_COMPONENTS_V is referenced by following:

APPS
PACKAGE BODY - HXC_ALIAS_UTILITY

[top of page]

View: HXC_LAYOUT_COMP_MESSAGES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
LAYOUT_COMP_PROMPT_ID NUMBER (15) Y
LAYOUT_COMPONENT_ID NUMBER (15) Y
PROMPT_ALIAS VARCHAR2 (80) Y
MESSAGE_TEXT VARCHAR2 (2000) Y
MESSAGE_NAME VARCHAR2 (30) Y

[top of page]

APPS.HXC_LAYOUT_COMP_MESSAGES_V references the following:

APPS
SYNONYM - FND_NEW_MESSAGES
SYNONYM - HXC_LAYOUT_COMP_PROMPTS

APPS.HXC_LAYOUT_COMP_MESSAGES_V is not referenced by any database object

[top of page]

View: HXC_LAYOUT_COMP_PROMPTS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
LAYOUT_COMP_PROMPT_ID NUMBER (15) Y
LAYOUT_COMPONENT_ID NUMBER (15) Y
PROMPT_ALIAS VARCHAR2 (80) Y
LABEL VARCHAR2 (80)
DESCRIPTION VARCHAR2 (2000)
CSS_CLASS VARCHAR2 (80)

[top of page]

APPS.HXC_LAYOUT_COMP_PROMPTS_V references the following:

APPS
VIEW - AK_REGION_ITEMS_VL
SYNONYM - HXC_LAYOUT_COMP_PROMPTS

APPS.HXC_LAYOUT_COMP_PROMPTS_V is not referenced by any database object

[top of page]

View: HXC_LOOKUPS

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
LOOKUP_TYPE VARCHAR2 (30) Y
LOOKUP_CODE VARCHAR2 (30) Y
MEANING VARCHAR2 (80) Y
DESCRIPTION VARCHAR2 (240)
ENABLED_FLAG VARCHAR2 (1) Y
START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

[top of page]

APPS.HXC_LOOKUPS references the following:

APPS
SYNONYM - FND_APPLICATION
PACKAGE - FND_GLOBAL
SYNONYM - FND_LOOKUP_TYPES
SYNONYM - FND_LOOKUP_VALUES
APPS.HXC_LOOKUPS is referenced by following:

APPS
PACKAGE BODY - HXC_HXCMISTC_XMLP_PKG
VIEW - HXC_TIME_ENTRY_RULES_V

[top of page]

View: HXC_MAPPINGS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
MAPPING_ID NUMBER (15) Y
NAME VARCHAR2 (80)
OBJECT_VERSION_NUMBER NUMBER

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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

APPS.HXC_MAPPINGS_V references the following:

APPS
SYNONYM - HXC_MAPPINGS

APPS.HXC_MAPPINGS_V is not referenced by any database object

[top of page]

View: HXC_MAPPING_ATTRIBUTES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
BLD_BLK_INFO_TYPE_ID NUMBER (15) Y
MAP VARCHAR2 (80)
NAME VARCHAR2 (80)
FIELD_NAME VARCHAR2 (80)
SEGMENT VARCHAR2 (80)
CONTEXT VARCHAR2 (80)

[top of page]

APPS.HXC_MAPPING_ATTRIBUTES_V references the following:

APPS
SYNONYM - HXC_BLD_BLK_INFO_TYPES
SYNONYM - HXC_MAPPINGS
SYNONYM - HXC_MAPPING_COMPONENTS
SYNONYM - HXC_MAPPING_COMP_USAGES
APPS.HXC_MAPPING_ATTRIBUTES_V is referenced by following:

APPS
VIEW - HXC_APPROVAL_DETAILS_V
PACKAGE BODY - HXC_APPROVAL_UTILITIES
VIEW - HXC_RESOURCE_TIMECARD_DETAIL_V
PACKAGE BODY - HXC_TIMECARD_ATTRIBUTES_PKG
VIEW - HXC_TIMECARD_ATTRIBUTES_V
VIEW - HXC_TIMECARD_DETAIL_HOURS_V
PACKAGE BODY - HXC_TIMECARD_HOURS_PKG
PACKAGE BODY - HXC_TIMECARD_SEARCH_PKG

[top of page]

View: HXC_MAPPING_COMPONENTS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
MAPPING_COMPONENT_ID NUMBER (15) Y
NAME VARCHAR2 (80)
FIELD_NAME VARCHAR2 (80)
BLD_BLK_INFO_TYPE_ID NUMBER (15) Y
BUILDING_BLOCK_CATEGORY VARCHAR2 (80)
BLD_BLK_INFO_TYPE VARCHAR2 (80)
SEGMENT VARCHAR2 (80)
END_USER_COLUMN_NAME VARCHAR2 (30)
ENABLED_FLAG VARCHAR2 (1)
OBJECT_VERSION_NUMBER NUMBER (9)
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

APPS.HXC_MAPPING_COMPONENTS_V references the following:

APPS
SYNONYM - FND_DESCR_FLEX_COLUMN_USAGES
SYNONYM - HXC_BLD_BLK_INFO_TYPES
SYNONYM - HXC_BLD_BLK_INFO_TYPE_USAGES
SYNONYM - HXC_MAPPING_COMPONENTS
APPS.HXC_MAPPING_COMPONENTS_V is referenced by following:

APPS
VIEW - HXC_MAPPING_COMP_USAGES_V
PACKAGE BODY - HXC_MAPPING_UTILITIES
PACKAGE BODY - HXC_MPC_UPLOAD_PKG
PACKAGE BODY - HXC_PROJ_MANAGER_APPROVAL_PKG
VIEW - HXC_TIME_CATEGORY_COMPS_V

[top of page]

View: HXC_MAPPING_COMP_USAGES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
MAPPING_COMP_USAGE_ID NUMBER (15) Y
MAPPING_ID NUMBER (15)
MAPPING_COMPONENT_ID NUMBER (15)
NAME VARCHAR2 (80)
FIELD_NAME VARCHAR2 (80)
BUILDING_BLOCK_CATEGORY VARCHAR2 (80)
BLD_BLK_INFO_TYPE VARCHAR2 (80)
SEGMENT VARCHAR2 (80)
END_USER_COLUMN_NAME VARCHAR2 (30)
OBJECT_VERSION_NUMBER NUMBER (9)
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

APPS.HXC_MAPPING_COMP_USAGES_V references the following:

APPS
VIEW - HXC_MAPPING_COMPONENTS_V
SYNONYM - HXC_MAPPING_COMP_USAGES

APPS.HXC_MAPPING_COMP_USAGES_V is not referenced by any database object

[top of page]

View: HXC_OVERRIDE_APPROVER_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
APPROVER_NAME VARCHAR2 (240)
Approve Name - Full name from per_people_f
PERSON_ID NUMBER (10) Y Person Id from Per_people_f
PERSON_NUMBER VARCHAR2 (30)
Employee Number or Npw Number from per_people_f
LAST_NAME VARCHAR2 (150) Y Last Name from per_people_f
FIRST_NAME VARCHAR2 (150)
First Name from per_people_f
EMAIL_ADDRESS VARCHAR2 (240)
Email address from per_people_f

[top of page]

APPS.HXC_OVERRIDE_APPROVER_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PER_ASSIGNMENTS_F
SYNONYM - PER_ASSIGNMENT_STATUS_TYPES
VIEW - PER_PEOPLE_F

APPS.HXC_OVERRIDE_APPROVER_V is not referenced by any database object

[top of page]

View: HXC_PREF_HIERARCHIES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PREF_HIERARCHY_ID NUMBER (15) Y
TYPE VARCHAR2 (30)
PREF_HIERARCHY VARCHAR2 (80) Y
BUSINESS_GROUP_ID NUMBER (15)
LEGISLATION_CODE VARCHAR2 (30)
EDIT_ALLOWED VARCHAR2 (9) Y
DISPLAYED VARCHAR2 (9) Y
PARENT_PREF_HIERARCHY_ID NUMBER (15)
PARENT_PREF_HIERARCHY VARCHAR2 (80)
PREF_DEFINITION_ID NUMBER (15)
PREFERENCE_NAME VARCHAR2 (80)
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)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
ATTRIBUTE21 VARCHAR2 (150)
ATTRIBUTE22 VARCHAR2 (150)
ATTRIBUTE23 VARCHAR2 (150)
ATTRIBUTE24 VARCHAR2 (150)
ATTRIBUTE25 VARCHAR2 (150)
ATTRIBUTE26 VARCHAR2 (150)
ATTRIBUTE27 VARCHAR2 (150)
ATTRIBUTE28 VARCHAR2 (150)
ATTRIBUTE29 VARCHAR2 (150)
ATTRIBUTE30 VARCHAR2 (150)
ORIG_PREF_HIERARCHY_ID NUMBER (15)
ORIG_PARENT_HIERARCHY_ID NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (9)
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
TOP_LEVEL_PARENT_ID NUMBER (15)
CODE VARCHAR2 (30)

[top of page]

APPS.HXC_PREF_HIERARCHIES_V references the following:

APPS
VIEW - FND_DESCR_FLEX_CONTEXTS_VL
SYNONYM - HXC_PREF_DEFINITIONS
SYNONYM - HXC_PREF_HIERARCHIES
APPS.HXC_PREF_HIERARCHIES_V is referenced by following:

APPS
PACKAGE BODY - HXC_PUBLIC_TEMP_GROUP_COMP_API

[top of page]

View: HXC_PUBLIC_TEMPLATE_LIST_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TEMPLATE_ID NUMBER (15) Y Public Template Id
TEMPLATE_NAME VARCHAR2 (150) Y Public Template Name
DESCRIPTION VARCHAR2 (150)
Public Template Description
DISPLAY_LAYOUT_NAME VARCHAR2 (240) Y Display Layout Name
RECURRING_PERIOD_NAME VARCHAR2 (80) Y Public Template Recurring Period Name
RECORDED_HOURS NUMBER

Recorded Hours
CREATED_BY_NAME VARCHAR2 (240)
Created By
LAST_UPDATE_BY_NAME VARCHAR2 (240)
Last Updated By
BUSINESS_GROUP_ID NUMBER (15) Y Business Group Id
START_TIME DATE

Start Time
STOP_TIME DATE

Stop Time

[top of page]

APPS.HXC_PUBLIC_TEMPLATE_LIST_V references the following:

APPS
SYNONYM - HXC_LAYOUTS_TL
SYNONYM - HXC_RECURRING_PERIODS
SYNONYM - HXC_TEMPLATE_SUMMARY
SYNONYM - PER_ALL_PEOPLE_F

APPS.HXC_PUBLIC_TEMPLATE_LIST_V is not referenced by any database object

[top of page]

View: HXC_RECURRING_PERIODS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
RECURRING_PERIOD_ID NUMBER (15) Y
NAME VARCHAR2 (80) Y
PERIOD_TYPE VARCHAR2 (80)
MEANING VARCHAR2 (80)
DURATION_IN_DAYS NUMBER (10)
START_DATE DATE
Y
END_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (9)
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

APPS.HXC_RECURRING_PERIODS_V references the following:

APPS
SYNONYM - HXC_RECURRING_PERIODS

APPS.HXC_RECURRING_PERIODS_V is not referenced by any database object

[top of page]

View: HXC_RESOURCE_ALL_ELIG_PREF_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER (10) Y
RULE_EVALUATION_ORDER NUMBER (9) Y
RULE_NAME VARCHAR2 (80) Y
BUSINESS_GROUP_ID NUMBER (15)
LEGISLATION_CODE VARCHAR2 (30)
PREFERENCE_ID NUMBER (15) Y
PREFERENCE_CODE VARCHAR2 (30) Y
PREFERENCE_NAME VARCHAR2 (80) Y
EDIT_ALLOWED VARCHAR2 (9) Y
DISPLAYED VARCHAR2 (9) Y
HIERARCHY_NAME VARCHAR2 (80) Y
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)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
ATTRIBUTE21 VARCHAR2 (150)
ATTRIBUTE22 VARCHAR2 (150)
ATTRIBUTE23 VARCHAR2 (150)
ATTRIBUTE24 VARCHAR2 (150)
ATTRIBUTE25 VARCHAR2 (150)
ATTRIBUTE26 VARCHAR2 (150)
ATTRIBUTE27 VARCHAR2 (150)
ATTRIBUTE28 VARCHAR2 (150)
ATTRIBUTE29 VARCHAR2 (150)
ATTRIBUTE30 VARCHAR2 (150)

[top of page]

APPS.HXC_RESOURCE_ALL_ELIG_PREF_V references the following:

APPS
VIEW - FND_DESCR_FLEX_CONTEXTS_VL
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - HXC_PREF_DEFINITIONS
SYNONYM - HXC_PREF_HIERARCHIES
SYNONYM - HXC_RESOURCE_RULES
PACKAGE - HXC_RESOURCE_RULES_UTILS
VIEW - PER_ASSIGNMENTS_F
VIEW - PER_PEOPLE_F
APPS.HXC_RESOURCE_ALL_ELIG_PREF_V is referenced by following:

APPS
VIEW - HXC_RESOURCE_ELIG_PREF_V

[top of page]

View: HXC_RESOURCE_ELIG_PREF_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER (10) Y
RULE_EVALUATION_ORDER NUMBER (9) Y
RULE_NAME VARCHAR2 (80) Y
BUSINESS_GROUP_ID NUMBER (15)
LEGISLATION_CODE VARCHAR2 (30)
PREFERENCE_ID NUMBER (15) Y
PREFERENCE_CODE VARCHAR2 (30) Y
PREFERENCE_NAME VARCHAR2 (80) Y
EDIT_ALLOWED VARCHAR2 (9) Y
DISPLAYED VARCHAR2 (9) Y
HIERARCHY_NAME VARCHAR2 (80) Y
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)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
ATTRIBUTE21 VARCHAR2 (150)
ATTRIBUTE22 VARCHAR2 (150)
ATTRIBUTE23 VARCHAR2 (150)
ATTRIBUTE24 VARCHAR2 (150)
ATTRIBUTE25 VARCHAR2 (150)
ATTRIBUTE26 VARCHAR2 (150)
ATTRIBUTE27 VARCHAR2 (150)
ATTRIBUTE28 VARCHAR2 (150)
ATTRIBUTE29 VARCHAR2 (150)
ATTRIBUTE30 VARCHAR2 (150)

[top of page]

APPS.HXC_RESOURCE_ELIG_PREF_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - HXC_RESOURCE_ALL_ELIG_PREF_V
PACKAGE - HXC_RESOURCE_RULES_UTILS
APPS.HXC_RESOURCE_ELIG_PREF_V is referenced by following:

APPS
VIEW - HXC_RESOURCE_PREF_V

[top of page]

View: HXC_RESOURCE_INFORMATION_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER (10) Y
RESOURCE_DISPLAY_LABEL VARCHAR2 (240)
RESOURCE_NUMBER VARCHAR2 (30)
NATIONAL_IDENTIFIER VARCHAR2 (30)
HIRE_DATE DATE

JOB_TITLE VARCHAR2 (700)
ORGANIZATION_NAME VARCHAR2 (240) Y
SUPERVISOR_NAME VARCHAR2 (240)
SUPERVISOR_NUMBER VARCHAR2 (30)
PER_INFORMATION_CATEGORY VARCHAR2 (30)
PER_INFORMATION1 VARCHAR2 (150)
PER_INFORMATION2 VARCHAR2 (150)
PER_INFORMATION3 VARCHAR2 (150)
PER_INFORMATION4 VARCHAR2 (150)
PER_INFORMATION5 VARCHAR2 (150)
PER_INFORMATION6 VARCHAR2 (150)
PER_INFORMATION7 VARCHAR2 (150)
PER_INFORMATION8 VARCHAR2 (150)
PER_INFORMATION9 VARCHAR2 (150)
PER_INFORMATION10 VARCHAR2 (150)
PER_INFORMATION11 VARCHAR2 (150)
PER_INFORMATION12 VARCHAR2 (150)
PER_INFORMATION13 VARCHAR2 (150)
PER_INFORMATION14 VARCHAR2 (150)
PER_INFORMATION15 VARCHAR2 (150)
PER_INFORMATION16 VARCHAR2 (150)
PER_INFORMATION17 VARCHAR2 (150)
PER_INFORMATION18 VARCHAR2 (150)
PER_INFORMATION19 VARCHAR2 (150)
PER_INFORMATION20 VARCHAR2 (150)
PER_INFORMATION21 VARCHAR2 (150)
PER_INFORMATION22 VARCHAR2 (150)
PER_INFORMATION23 VARCHAR2 (150)
PER_INFORMATION24 VARCHAR2 (150)
PER_INFORMATION25 VARCHAR2 (150)
PER_INFORMATION26 VARCHAR2 (150)
PER_INFORMATION27 VARCHAR2 (150)
PER_INFORMATION28 VARCHAR2 (150)
PER_INFORMATION29 VARCHAR2 (150)
PER_INFORMATION30 VARCHAR2 (150)
OFFICE VARCHAR2 (45)
INTERNAL_LOCATION VARCHAR2 (45)
MAILSTOP VARCHAR2 (45)
AVAILABILITY_SCHEDULE VARCHAR2 (80)
FULLTIME_AVAILABILITY NUMBER (5)
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)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
ATTRIBUTE21 VARCHAR2 (150)
ATTRIBUTE22 VARCHAR2 (150)
ATTRIBUTE23 VARCHAR2 (150)
ATTRIBUTE24 VARCHAR2 (150)
ATTRIBUTE25 VARCHAR2 (150)
ATTRIBUTE26 VARCHAR2 (150)
ATTRIBUTE27 VARCHAR2 (150)
ATTRIBUTE28 VARCHAR2 (150)
ATTRIBUTE29 VARCHAR2 (150)
ATTRIBUTE30 VARCHAR2 (150)
GRADE_NAME VARCHAR2 (240)
ASSIGNMENT_LOCATION VARCHAR2 (60)
ASSIGNMENT_PEOPLE_GROUP VARCHAR2 (240)
ASSIGNMENT_POSITION VARCHAR2 (240)
ASSIGNMENT_PAYROLL VARCHAR2 (80)
ASSIGNMENT_STATUS VARCHAR2 (80) Y
ASSIGNMENT_NUMBER VARCHAR2 (30)
EMPLOYMENT_CATEGORY VARCHAR2 (30)
NORMAL_HOURS NUMBER (22)
NORMAL_HOURS_FREQUENCY VARCHAR2 (80)
NORMAL_START_TIME VARCHAR2 (5)
NORMAL_FINISH_TIME VARCHAR2 (5)
SOFT_CODED_KEYFLEX1 VARCHAR2 (60)
SOFT_CODED_KEYFLEX2 VARCHAR2 (60)
SOFT_CODED_KEYFLEX3 VARCHAR2 (60)
SOFT_CODED_KEYFLEX4 VARCHAR2 (60)
SOFT_CODED_KEYFLEX5 VARCHAR2 (60)
SOFT_CODED_KEYFLEX6 VARCHAR2 (60)
SOFT_CODED_KEYFLEX7 VARCHAR2 (60)
SOFT_CODED_KEYFLEX8 VARCHAR2 (60)
SOFT_CODED_KEYFLEX9 VARCHAR2 (60)
SOFT_CODED_KEYFLEX10 VARCHAR2 (60)
SOFT_CODED_KEYFLEX11 VARCHAR2 (60)
SOFT_CODED_KEYFLEX12 VARCHAR2 (60)
SOFT_CODED_KEYFLEX13 VARCHAR2 (60)
SOFT_CODED_KEYFLEX14 VARCHAR2 (60)
SOFT_CODED_KEYFLEX15 VARCHAR2 (60)
SOFT_CODED_KEYFLEX16 VARCHAR2 (60)
SOFT_CODED_KEYFLEX17 VARCHAR2 (60)
SOFT_CODED_KEYFLEX18 VARCHAR2 (60)
SOFT_CODED_KEYFLEX19 VARCHAR2 (60)
SOFT_CODED_KEYFLEX20 VARCHAR2 (60)
SOFT_CODED_KEYFLEX21 VARCHAR2 (60)
SOFT_CODED_KEYFLEX22 VARCHAR2 (60)
SOFT_CODED_KEYFLEX23 VARCHAR2 (60)
SOFT_CODED_KEYFLEX24 VARCHAR2 (60)
SOFT_CODED_KEYFLEX25 VARCHAR2 (60)
SOFT_CODED_KEYFLEX26 VARCHAR2 (60)
SOFT_CODED_KEYFLEX27 VARCHAR2 (60)
SOFT_CODED_KEYFLEX28 VARCHAR2 (60)
SOFT_CODED_KEYFLEX29 VARCHAR2 (60)
SOFT_CODED_KEYFLEX30 VARCHAR2 (60)
BARGAINING_UNIT_CODE VARCHAR2 (30)
SALARY_BASIS VARCHAR2 (30)
COLLECTIVE_AGREEMENT VARCHAR2 (80)
AGREEMENT_GRADE1 VARCHAR2 (150)
AGREEMENT_GRADE2 VARCHAR2 (150)
AGREEMENT_GRADE3 VARCHAR2 (150)
AGREEMENT_GRADE4 VARCHAR2 (150)
AGREEMENT_GRADE5 VARCHAR2 (150)
AGREEMENT_GRADE6 VARCHAR2 (150)
AGREEMENT_GRADE7 VARCHAR2 (150)
AGREEMENT_GRADE8 VARCHAR2 (150)
AGREEMENT_GRADE9 VARCHAR2 (150)
AGREEMENT_GRADE10 VARCHAR2 (150)
AGREEMENT_GRADE11 VARCHAR2 (150)
AGREEMENT_GRADE12 VARCHAR2 (150)
AGREEMENT_GRADE13 VARCHAR2 (150)
AGREEMENT_GRADE14 VARCHAR2 (150)
AGREEMENT_GRADE15 VARCHAR2 (150)
AGREEMENT_GRADE16 VARCHAR2 (150)
AGREEMENT_GRADE17 VARCHAR2 (150)
AGREEMENT_GRADE18 VARCHAR2 (150)
AGREEMENT_GRADE19 VARCHAR2 (150)
AGREEMENT_GRADE20 VARCHAR2 (150)
COST_ALLOCATION1 VARCHAR2 (60)
COST_ALLOCATION2 VARCHAR2 (60)
COST_ALLOCATION3 VARCHAR2 (60)
COST_ALLOCATION4 VARCHAR2 (60)
COST_ALLOCATION5 VARCHAR2 (60)
COST_ALLOCATION6 VARCHAR2 (60)
COST_ALLOCATION7 VARCHAR2 (60)
COST_ALLOCATION8 VARCHAR2 (60)
COST_ALLOCATION9 VARCHAR2 (60)
COST_ALLOCATION10 VARCHAR2 (60)
COST_ALLOCATION11 VARCHAR2 (60)
COST_ALLOCATION12 VARCHAR2 (60)
COST_ALLOCATION13 VARCHAR2 (60)
COST_ALLOCATION14 VARCHAR2 (60)
COST_ALLOCATION15 VARCHAR2 (60)
COST_ALLOCATION16 VARCHAR2 (60)
COST_ALLOCATION17 VARCHAR2 (60)
COST_ALLOCATION18 VARCHAR2 (60)
COST_ALLOCATION19 VARCHAR2 (60)
COST_ALLOCATION20 VARCHAR2 (60)
COST_ALLOCATION21 VARCHAR2 (60)
COST_ALLOCATION22 VARCHAR2 (60)
COST_ALLOCATION23 VARCHAR2 (60)
COST_ALLOCATION24 VARCHAR2 (60)
COST_ALLOCATION25 VARCHAR2 (60)
COST_ALLOCATION26 VARCHAR2 (60)
COST_ALLOCATION27 VARCHAR2 (60)
COST_ALLOCATION28 VARCHAR2 (60)
COST_ALLOCATION29 VARCHAR2 (60)
COST_ALLOCATION30 VARCHAR2 (60)
JOB_DFF_ATTRIBUTE1 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE2 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE3 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE4 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE5 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE6 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE7 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE8 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE9 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE10 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE11 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE12 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE13 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE14 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE15 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE16 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE17 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE18 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE19 VARCHAR2 (150)
JOB_DFF_ATTRIBUTE20 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE1 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE2 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE3 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE4 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE5 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE6 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE7 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE8 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE9 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE10 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE11 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE12 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE13 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE14 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE15 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE16 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE17 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE18 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE19 VARCHAR2 (150)
POSITION_DFF_ATTRIBUTE20 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE1 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE2 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE3 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE4 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE5 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE6 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE7 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE8 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE9 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE10 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE11 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE12 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE13 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE14 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE15 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE16 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE17 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE18 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE19 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE20 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE21 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE22 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE23 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE24 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE25 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE26 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE27 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE28 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE29 VARCHAR2 (150)
ASSIGNMENT_ATTRIBUTE30 VARCHAR2 (150)
PAYROLL_PERIOD_START_DATE DATE

PAYROLL_PERIOD_END_DATE DATE

[top of page]

APPS.HXC_RESOURCE_INFORMATION_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOCATIONS
VIEW - HR_LOOKUPS
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
SYNONYM - HR_SOFT_CODING_KEYFLEX
SYNONYM - PAY_COST_ALLOCATIONS_F
SYNONYM - PAY_COST_ALLOCATION_KEYFLEX
VIEW - PAY_PAYROLLS
SYNONYM - PAY_PEOPLE_GROUPS
VIEW - PER_ASSIGNMENTS_F
VIEW - PER_ASSIGNMENT_STATUS_TYPES_V
SYNONYM - PER_CAGR_GRADES_DEF
SYNONYM - PER_COLLECTIVE_AGREEMENTS
SYNONYM - PER_GRADES
SYNONYM - PER_JOBS
SYNONYM - PER_PAY_BASES
VIEW - PER_PEOPLE_F
SYNONYM - PER_PERIODS_OF_SERVICE
VIEW - PER_POSITIONS
SYNONYM - PER_TIME_PERIODS

APPS.HXC_RESOURCE_INFORMATION_V is not referenced by any database object

[top of page]

View: HXC_RESOURCE_PERSONAL_PREF_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER (10) Y
RULE_EVALUATION_ORDER NUMBER (9) Y
RULE_NAME VARCHAR2 (80) Y
PREFERENCE_ID NUMBER (15) Y
PREFERENCE_CODE VARCHAR2 (30) Y
EDIT_ALLOWED VARCHAR2 (9) Y
DISPLAYED VARCHAR2 (9) Y
HIERARCHY_NAME VARCHAR2 (80) Y
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)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
ATTRIBUTE21 VARCHAR2 (150)
ATTRIBUTE22 VARCHAR2 (150)
ATTRIBUTE23 VARCHAR2 (150)
ATTRIBUTE24 VARCHAR2 (150)
ATTRIBUTE25 VARCHAR2 (150)
ATTRIBUTE26 VARCHAR2 (150)
ATTRIBUTE27 VARCHAR2 (150)
ATTRIBUTE28 VARCHAR2 (150)
ATTRIBUTE29 VARCHAR2 (150)
ATTRIBUTE30 VARCHAR2 (150)

[top of page]

APPS.HXC_RESOURCE_PERSONAL_PREF_V references the following:

APPS
SYNONYM - FND_USER
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - HXC_PREF_DEFINITIONS
SYNONYM - HXC_PREF_HIERARCHIES
SYNONYM - HXC_RESOURCE_RULES
VIEW - PER_ASSIGNMENTS_F
APPS.HXC_RESOURCE_PERSONAL_PREF_V is referenced by following:

APPS
VIEW - HXC_RESOURCE_PREF_V

[top of page]

View: HXC_RESOURCE_PREF_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER (10) Y
RULE_EVALUATION_ORDER NUMBER

RULE_NAME VARCHAR2 (80)
BUSINESS_GROUP_ID NUMBER (15)
PREFERENCE_ID NUMBER (15) Y
PREFERENCE_CODE VARCHAR2 (30) Y
EDIT_ALLOWED VARCHAR2 (9) Y
DISPLAYED VARCHAR2 (9) Y
HIERARCHY_NAME VARCHAR2 (80) Y
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)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
ATTRIBUTE21 VARCHAR2 (150)
ATTRIBUTE22 VARCHAR2 (150)
ATTRIBUTE23 VARCHAR2 (150)
ATTRIBUTE24 VARCHAR2 (150)
ATTRIBUTE25 VARCHAR2 (150)
ATTRIBUTE26 VARCHAR2 (150)
ATTRIBUTE27 VARCHAR2 (150)
ATTRIBUTE28 VARCHAR2 (150)
ATTRIBUTE29 VARCHAR2 (150)
ATTRIBUTE30 VARCHAR2 (150)

[top of page]

APPS.HXC_RESOURCE_PREF_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - HXC_RESOURCE_ELIG_PREF_V
VIEW - HXC_RESOURCE_PERSONAL_PREF_V
PACKAGE - HXC_RESOURCE_RULES_UTILS

APPS.HXC_RESOURCE_PREF_V is not referenced by any database object

[top of page]

View: HXC_RESOURCE_RULES_PERSON_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
RESOURCE_RULE_ID NUMBER (15)
NAME VARCHAR2 (80)
BUSINESS_GROUP_ID NUMBER (15)
LEGISLATION_CODE VARCHAR2 (30)
PERSON_ID NUMBER (10)
PERSON_NAME VARCHAR2 (240)
ELIGIBILITY_CRITERIA_TYPE VARCHAR2 (30)
MEANING VARCHAR2 (4000)
ELIGIBILITY_CRITERIA_ID VARCHAR2 (60)
ELIGIBILITY_CRITERIA VARCHAR2 (4000)
PREF_HIERARCHY_ID NUMBER (15)
PREF_HIERARCHY_NAME VARCHAR2 (80)
RULE_EVALUATION_ORDER NUMBER (9)
RESOURCE_TYPE VARCHAR2 (30)
START_DATE DATE

END_DATE DATE

EFFECTIVE_START_DATE DATE

EFFECTIVE_END_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (9)
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

APPS.HXC_RESOURCE_RULES_PERSON_V references the following:

APPS
PACKAGE - FND_DATE
PACKAGE - FND_GLOBAL
VIEW - FND_RESPONSIBILITY_VL
SYNONYM - FND_USER
VIEW - FND_USER_RESP_GROUPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOCATIONS
VIEW - HR_LOOKUPS
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - HR_STANDARD_LOOKUPS
PACKAGE - HXC_PREFERENCE_EVALUATION
SYNONYM - HXC_PREF_HIERARCHIES
SYNONYM - HXC_RESOURCE_RULES
PACKAGE - HXC_RESOURCE_RULES_UTILS
VIEW - PAY_PAYROLLS_F
SYNONYM - PAY_PEOPLE_GROUPS
VIEW - PER_ASSIGNMENTS_F
VIEW - PER_BUSINESS_GROUPS
SYNONYM - PER_JOBS
SYNONYM - PER_ORGANIZATION_STRUCTURES
SYNONYM - PER_ORG_STRUCTURE_ELEMENTS
VIEW - PER_PEOPLE_F
VIEW - PER_PEOPLE_X
SYNONYM - PER_PERSON_TYPES
SYNONYM - PER_PERSON_TYPES_TL
SYNONYM - PER_PERSON_TYPE_USAGES_F
VIEW - PER_POSITIONS

APPS.HXC_RESOURCE_RULES_PERSON_V is not referenced by any database object

[top of page]

View: HXC_RESOURCE_RULES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
RESOURCE_RULE_ID NUMBER (15)
NAME VARCHAR2 (80)
BUSINESS_GROUP_ID NUMBER (15)
LEGISLATION_CODE VARCHAR2 (30)
ELIGIBILITY_CRITERIA_TYPE VARCHAR2 (30)
MEANING VARCHAR2 (4000)
ELIGIBILITY_CRITERIA_ID VARCHAR2 (60)
ELIGIBILITY_CRITERIA VARCHAR2 (4000)
PREF_HIERARCHY_ID NUMBER (15)
PREF_HIERARCHY_NAME VARCHAR2 (80)
RULE_EVALUATION_ORDER NUMBER (9)
RESOURCE_TYPE VARCHAR2 (30)
START_DATE DATE

END_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (9)
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

APPS.HXC_RESOURCE_RULES_V references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_RESPONSIBILITY_TL
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOCATIONS
VIEW - HR_LOOKUPS
VIEW - HR_ORGANIZATION_UNITS
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - HR_STANDARD_LOOKUPS
SYNONYM - HXC_PREF_HIERARCHIES
SYNONYM - HXC_RESOURCE_RULES
PACKAGE - HXC_RESOURCE_RULES_UTILS
VIEW - PAY_PAYROLLS_F
SYNONYM - PAY_PEOPLE_GROUPS
VIEW - PER_ASSIGNMENTS_F
VIEW - PER_BUSINESS_GROUPS
SYNONYM - PER_JOBS_TL
SYNONYM - PER_ORGANIZATION_STRUCTURES
VIEW - PER_PEOPLE_X
SYNONYM - PER_PERSON_TYPES
SYNONYM - PER_PERSON_TYPES_TL
VIEW - PER_POSITIONS

APPS.HXC_RESOURCE_RULES_V is not referenced by any database object

[top of page]

View: HXC_RESOURCE_TEMPLATES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TEMPLATE_ID NUMBER (15) Y
RESOURCE_ID NUMBER (15) Y
START_TIME DATE

STOP_TIME DATE

TEMPLATE_NAME VARCHAR2 (150) Y
TEMPLATE_TYPE VARCHAR2 (150)
TOTAL_HOURS NUMBER

[top of page]

APPS.HXC_RESOURCE_TEMPLATES_V references the following:

APPS
SYNONYM - HXC_TEMPLATE_SUMMARY

APPS.HXC_RESOURCE_TEMPLATES_V is not referenced by any database object

[top of page]

View: HXC_RESOURCE_TIMECARDS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TIMECARD_ID NUMBER
Y
TIMECARD_OVN NUMBER
Y
RESOURCE_ID NUMBER
Y
STATUS_CODE VARCHAR2 (30) Y
STATUS_NAME VARCHAR2 (80)
PERIOD_STARTS DATE
Y
PERIOD_ENDS DATE
Y
HOURS_WORKED NUMBER
Y
SUBMISSION_DATE DATE

TIMECARD_COMMENT VARCHAR2 (2000)
REASON_INFO VARCHAR2 (1) Y
DATA_SET_STATUS VARCHAR2 (8)
OFFLINE_EXISTS VARCHAR2 (17)

[top of page]

APPS.HXC_RESOURCE_TIMECARDS_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - HXC_DATA_SETS
SYNONYM - HXC_TIMECARD_SUMMARY
SYNONYM - HXC_TIME_BUILDING_BLOCKS
PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HXC_RESOURCE_TIMECARDS_V is not referenced by any database object

[top of page]

View: HXC_RESOURCE_TIMECARD_DETAIL_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TIMECARD_ID NUMBER (15) Y
OBJECT_VERSION NUMBER (9) Y
PARENT_TIMECARD_ID NUMBER (15)
PARENT_OBJECT_VERSION NUMBER (9)
RESOURCE_ID NUMBER (15)
SCOPE VARCHAR2 (30) Y
ATTRIBUTE_ID VARCHAR2 (150)
MAP VARCHAR2 (80)
FIELD_NAME VARCHAR2 (80)

[top of page]

APPS.HXC_RESOURCE_TIMECARD_DETAIL_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HXC_MAPPING_ATTRIBUTES_V
VIEW - HXC_TIMECARD_DETAILS_V

APPS.HXC_RESOURCE_TIMECARD_DETAIL_V is not referenced by any database object

[top of page]

View: HXC_RESOURCE_TOTAL_TIME_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TIME_ID NUMBER (15) Y
RESOURCE_ID NUMBER (15)
DAY_ID NUMBER (15) Y
DETAIL_ID NUMBER (15) Y
STATUS_CODE VARCHAR2 (30) Y
STATUS_NAME VARCHAR2 (80)
START_DATE DATE

STOP_DATE DATE

HOURS_WORKED NUMBER

[top of page]

APPS.HXC_RESOURCE_TOTAL_TIME_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - HXC_TIME_BUILDING_BLOCKS
PACKAGE - HXC_TIME_CATEGORY_UTILS_PKG

APPS.HXC_RESOURCE_TOTAL_TIME_V is not referenced by any database object

[top of page]

View: HXC_RETRIEVAL_RULES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
RETRIEVAL_RULE_ID NUMBER (15) Y
RETRIEVAL_RULE_NAME VARCHAR2 (80) Y
RETRIEVAL_PROCESS_ID NUMBER (15) Y
RETRIEVAL_PROCESS_NAME VARCHAR2 (80)
OBJECT_VERSION_NUMBER NUMBER (9)
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

APPS.HXC_RETRIEVAL_RULES_V references the following:

APPS
SYNONYM - HXC_RETRIEVAL_PROCESSES
SYNONYM - HXC_RETRIEVAL_RULES
APPS.HXC_RETRIEVAL_RULES_V is referenced by following:

APPS
PACKAGE BODY - HXC_RET_RULE_GRP_COMP_API

[top of page]

View: HXC_RETRIEVAL_RULE_COMPS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
RETRIEVAL_RULE_COMP_ID NUMBER (15) Y
RETRIEVAL_RULE_ID NUMBER (15) Y
STATUS VARCHAR2 (30) Y
MEANING VARCHAR2 (80) Y
TIME_RECIPIENT_ID NUMBER (15) Y
TIME_RECIPIENT VARCHAR2 (80) Y
OBJECT_VERSION_NUMBER NUMBER (9)
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

APPS.HXC_RETRIEVAL_RULE_COMPS_V references the following:

APPS
VIEW - HR_STANDARD_LOOKUPS
SYNONYM - HXC_RETRIEVAL_RULE_COMPS
SYNONYM - HXC_TIME_RECIPIENTS

APPS.HXC_RETRIEVAL_RULE_COMPS_V is not referenced by any database object

[top of page]

View: HXC_RETRIEVAL_RULE_GROUPS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
RETRIEVAL_RULE_GROUP_ID NUMBER (15) Y
RETRIEVAL_RULE_GROUP_NAME VARCHAR2 (80) Y
OBJECT_VERSION_NUMBER NUMBER

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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

APPS.HXC_RETRIEVAL_RULE_GROUPS_V references the following:

APPS
SYNONYM - HXC_ENTITY_GROUPS
APPS.HXC_RETRIEVAL_RULE_GROUPS_V is referenced by following:

APPS
PACKAGE BODY - HXC_GENERIC_RETRIEVAL_UTILS
PACKAGE BODY - HXC_HPH_UPLOAD_PKG
PACKAGE BODY - HXC_RET_RULE_GRP_COMP_API
PACKAGE BODY - HXC_RRC_UPLOAD_PKG
PACKAGE BODY - HXC_RRG_UPLOAD_PKG
PACKAGE BODY - HXC_SETUP_VALIDATION_PKG

[top of page]

View: HXC_RETRIEVAL_RULE_GRP_COMPS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
RETRIEVAL_RULE_GROUP_COMP_ID NUMBER (15) Y
RETRIEVAL_RULE_GROUP_ID NUMBER (15) Y
RETRIEVAL_RULE_ID NUMBER (15) Y
RETRIEVAL_RULE_NAME VARCHAR2 (80) Y
RETRIEVAL_PROCESS_NAME VARCHAR2 (80) Y
RETRIEVAL_PROCESS_ID NUMBER (15) Y
OBJECT_VERSION_NUMBER NUMBER

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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

APPS.HXC_RETRIEVAL_RULE_GRP_COMPS_V references the following:

APPS
SYNONYM - HXC_ENTITY_GROUP_COMPS
SYNONYM - HXC_RETRIEVAL_PROCESSES
SYNONYM - HXC_RETRIEVAL_RULES
APPS.HXC_RETRIEVAL_RULE_GRP_COMPS_V is referenced by following:

APPS
PACKAGE BODY - HXC_GENERIC_RETRIEVAL_UTILS
PACKAGE BODY - HXC_RET_RULE_GRP_COMP_API
PACKAGE BODY - HXC_RRC_UPLOAD_PKG
PACKAGE BODY - HXC_SETUP_VALIDATION_PKG

[top of page]

View: HXC_RETVL_DEPST_PROCESSES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
PROCESS_TYPE NUMBER

PROCESS_ID NUMBER (15)
PROCESS_NAME VARCHAR2 (80)
TIME_APPLICATION_ID NUMBER (15)
TIME_APPLICATION VARCHAR2 (80)
MAPPING_ID NUMBER

MAPPING VARCHAR2 (80)
OBJECT_VERSION_NUMBER NUMBER (9)
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

APPS.HXC_RETVL_DEPST_PROCESSES_V references the following:

APPS
SYNONYM - HXC_DEPOSIT_PROCESSES
SYNONYM - HXC_MAPPINGS
SYNONYM - HXC_RETRIEVAL_PROCESSES
SYNONYM - HXC_TIME_RECIPIENTS
SYNONYM - HXC_TIME_SOURCES

APPS.HXC_RETVL_DEPST_PROCESSES_V is not referenced by any database object

[top of page]

View: HXC_STATIC_TIMECARD_INFO_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
RESOURCE_ID NUMBER (10) Y
RESOURCE_FULL_NAME VARCHAR2 (240)
RESOURCE_NUMBER VARCHAR2 (30)

[top of page]

APPS.HXC_STATIC_TIMECARD_INFO_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_SECURITY
VIEW - PER_PEOPLE_F

APPS.HXC_STATIC_TIMECARD_INFO_V is not referenced by any database object

[top of page]

View: HXC_TC_AUDIT_SUMMARY

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TIME_ATTRIBUTE_ID NUMBER (15) Y Time Attribute Id
DETAIL_BUILDING_BLOCK_ID NUMBER (15)
Detail Building Block Id
BLD_BLK_INFO_TYPE VARCHAR2 (80)
Bld Blk Info Type
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Attribute Category
ATTRIBUTE1 VARCHAR2 (150)
Attribute1
ATTRIBUTE2 VARCHAR2 (150)
Attribute2
ATTRIBUTE3 VARCHAR2 (150)
Attribute3
ATTRIBUTE4 VARCHAR2 (150)
Attribute4
ATTRIBUTE5 VARCHAR2 (150)
Attribute5
ATTRIBUTE6 VARCHAR2 (150)
Attribute6
ATTRIBUTE7 VARCHAR2 (150)
Attribute7
ATTRIBUTE8 VARCHAR2 (150)
Attribute8
ATTRIBUTE9 VARCHAR2 (150)
Attribute9
ATTRIBUTE10 VARCHAR2 (150)
Attribute10
ATTRIBUTE11 VARCHAR2 (150)
Attribute11
ATTRIBUTE12 VARCHAR2 (150)
Attribute12
ATTRIBUTE13 VARCHAR2 (150)
Attribute13
ATTRIBUTE14 VARCHAR2 (150)
Attribute14
ATTRIBUTE15 VARCHAR2 (150)
Attribute15
ATTRIBUTE16 VARCHAR2 (150)
Attribute16
ATTRIBUTE17 VARCHAR2 (150)
Attribute17
ATTRIBUTE18 VARCHAR2 (150)
Attribute18
ATTRIBUTE19 VARCHAR2 (150)
Attribute19
ATTRIBUTE20 VARCHAR2 (150)
Attribute20
ATTRIBUTE21 VARCHAR2 (150)
Attribute21
ATTRIBUTE22 VARCHAR2 (150)
Attribute22
ATTRIBUTE23 VARCHAR2 (150)
Attribute23
ATTRIBUTE24 VARCHAR2 (150)
Attribute24
ATTRIBUTE25 VARCHAR2 (150)
Attribute25
ATTRIBUTE26 VARCHAR2 (150)
Attribute26
ATTRIBUTE27 VARCHAR2 (150)
Attribute27
ATTRIBUTE28 VARCHAR2 (150)
Attribute28
ATTRIBUTE29 VARCHAR2 (150)
Attribute29
ATTRIBUTE30 VARCHAR2 (150)
Attribute30
DETAIL_TBB_OVN NUMBER (9)
Detail Tbb Ovn
TIMECARD_ID NUMBER (15)
Timecard Id
MEASURE NUMBER

Measure
DATE_FROM DATE
Y Date From
START_TIME DATE

Start Time
APPLICATION_PERIOD_ID NUMBER

Application Period Id
NEW CHAR (1)
New
CHANGED CHAR (1)
Changed

[top of page]

APPS.HXC_TC_AUDIT_SUMMARY references the following:

APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_LOOKUP_VALUES
SYNONYM - HXC_APP_PERIOD_SUMMARY
SYNONYM - HXC_BLD_BLK_INFO_TYPES
SYNONYM - HXC_TC_AP_LINKS
SYNONYM - HXC_TIME_ATTRIBUTES
SYNONYM - HXC_TIME_ATTRIBUTE_USAGES
SYNONYM - HXC_TIME_BUILDING_BLOCKS

APPS.HXC_TC_AUDIT_SUMMARY is not referenced by any database object

[top of page]

View: HXC_TEMPLATE_SET_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
NAME VARCHAR2 (150)
CODE VARCHAR2 (38)

[top of page]

APPS.HXC_TEMPLATE_SET_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - HXC_TEMPLATE_SUMMARY

APPS.HXC_TEMPLATE_SET_V is not referenced by any database object

[top of page]

View: HXC_TIMECARDS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TCRD_TIME_BUILDING_BLOCK_ID NUMBER (15) Y
TCRD_OBJECT_VERSION_NUMBER NUMBER (9) Y
TCRD_START_TIME DATE

TCRD_STOP_TIME DATE

TCRD_PARENT_BUILDING_BLOCK_ID NUMBER (15)
TCRD_PARENT_BUILDING_BLOCK_OVN NUMBER (9)
TCRD_APPROVAL_STATUS VARCHAR2 (30) Y
TCRD_RESOURCE_ID NUMBER (15)
TCRD_COMMENT_TEXT VARCHAR2 (2000)
TCRD_SUBMISSION_DATE DATE
Y
TCRD_RESOURCE_TYPE VARCHAR2 (30)

[top of page]

APPS.HXC_TIMECARDS_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - HXC_TIME_BUILDING_BLOCKS
APPS.HXC_TIMECARDS_V is referenced by following:

APPS
VIEW - HXC_APPROVAL_DETAILS_V

[top of page]

View: HXC_TIMECARD_ATTRIBUTES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
DETAIL_ID NUMBER (15) Y
DETAIL_OVN NUMBER (9) Y
PARENT_ID NUMBER (15)
PARENT_OVN NUMBER (9)
PROJECT_NUMBER VARCHAR2 (150)
TASK_NUMBER VARCHAR2 (150)
EXPENDITURE_TYPE VARCHAR2 (150)
HOURS_TYPE_ID VARCHAR2 (20)

[top of page]

APPS.HXC_TIMECARD_ATTRIBUTES_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HXC_MAPPING_ATTRIBUTES_V
VIEW - HXC_TIMECARD_DETAILS_V

APPS.HXC_TIMECARD_ATTRIBUTES_V is not referenced by any database object

[top of page]

View: HXC_TIMECARD_AUDIT_SUMMARY

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
HOURS NUMBER

Hours entered
REASON VARCHAR2 (80)
Reason type
REASON_COMMENT VARCHAR2 (150)
Reason comments
REASON_TYPE VARCHAR2 (150)
Change or late reason
PROJECT_NAME VARCHAR2 (25)
Project name
TASK_NUMBER VARCHAR2 (25)
task number
EXPENDITURE_TYPE VARCHAR2 (150)
Expenditure type
DATE_ENTERED DATE

Date entered
DAY_ENTERED DATE

Day entered
TIMECARD_ID NUMBER (15)
Timecard id
DETAIL_ID NUMBER (15)
Detail id
DETAIL_OVN NUMBER (9)
Detail OVN

[top of page]

APPS.HXC_TIMECARD_AUDIT_SUMMARY references the following:

APPS
SYNONYM - FND_LOOKUP_VALUES
PACKAGE - HR_GENERAL
VIEW - HXC_BASE_PA_ONLINE_PROJECTS_V
VIEW - HXC_BASE_PA_ONLINE_TASKS_V
SYNONYM - HXC_TIME_ATTRIBUTES
SYNONYM - HXC_TIME_ATTRIBUTE_USAGES
SYNONYM - HXC_TIME_BUILDING_BLOCKS

APPS.HXC_TIMECARD_AUDIT_SUMMARY is not referenced by any database object

[top of page]

View: HXC_TIMECARD_DAYS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
DAY_TIMECARD_ID NUMBER (15) Y
DAY_TIMECARD_OVN NUMBER (9) Y
DAY_PARENT_ID NUMBER (15)
DAY_PARENT_OVN NUMBER (9)
DAY_START_TIME DATE

DAY_STOP_TIME DATE

DAY_RESOURCE_ID NUMBER (15)

[top of page]

APPS.HXC_TIMECARD_DAYS_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - HXC_TIME_BUILDING_BLOCKS
APPS.HXC_TIMECARD_DAYS_V is referenced by following:

APPS
VIEW - HXC_APPROVAL_DETAILS_V

[top of page]

View: HXC_TIMECARD_DETAILS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
DETAIL_TIMECARD_ID NUMBER (15) Y
DETAIL_OBJECT_VERSION NUMBER (9) Y
DETAIL_START_TIME DATE

DETAIL_STOP_TIME DATE

DETAIL_COMMENT_TEXT VARCHAR2 (2000)
DETAIL_PARENT_TIMECARD_ID NUMBER (15)
DETAIL_PARENT_OBJECT_VERSION NUMBER (9)
DETAIL_RESOURCE_ID NUMBER (15)
DETAIL_SCOPE VARCHAR2 (30) Y
DETAIL_MEASURE NUMBER

DETAIL_UNIT_OF_MEASURE VARCHAR2 (30)
DETAIL_BLD_BLK_INFO_TYPE_ID NUMBER (30) Y
DETAIL_ATTRIBUTE_CATEGORY VARCHAR2 (30)
DETAIL_ATTRIBUTE1 VARCHAR2 (150)
DETAIL_ATTRIBUTE2 VARCHAR2 (150)
DETAIL_ATTRIBUTE3 VARCHAR2 (150)
DETAIL_ATTRIBUTE4 VARCHAR2 (150)
DETAIL_ATTRIBUTE5 VARCHAR2 (150)
DETAIL_ATTRIBUTE6 VARCHAR2 (150)
DETAIL_ATTRIBUTE7 VARCHAR2 (150)
DETAIL_ATTRIBUTE8 VARCHAR2 (150)
DETAIL_ATTRIBUTE9 VARCHAR2 (150)
DETAIL_ATTRIBUTE10 VARCHAR2 (150)
DETAIL_ATTRIBUTE11 VARCHAR2 (150)
DETAIL_ATTRIBUTE12 VARCHAR2 (150)
DETAIL_ATTRIBUTE13 VARCHAR2 (150)
DETAIL_ATTRIBUTE14 VARCHAR2 (150)
DETAIL_ATTRIBUTE15 VARCHAR2 (150)
DETAIL_ATTRIBUTE16 VARCHAR2 (150)
DETAIL_ATTRIBUTE17 VARCHAR2 (150)
DETAIL_ATTRIBUTE18 VARCHAR2 (150)
DETAIL_ATTRIBUTE19 VARCHAR2 (150)
DETAIL_ATTRIBUTE20 VARCHAR2 (150)
DETAIL_ATTRIBUTE21 VARCHAR2 (150)
DETAIL_ATTRIBUTE22 VARCHAR2 (150)
DETAIL_ATTRIBUTE23 VARCHAR2 (150)
DETAIL_ATTRIBUTE24 VARCHAR2 (150)
DETAIL_ATTRIBUTE25 VARCHAR2 (150)
DETAIL_ATTRIBUTE26 VARCHAR2 (150)
DETAIL_ATTRIBUTE27 VARCHAR2 (150)
DETAIL_ATTRIBUTE28 VARCHAR2 (150)
DETAIL_ATTRIBUTE29 VARCHAR2 (150)
DETAIL_ATTRIBUTE30 VARCHAR2 (150)

[top of page]

APPS.HXC_TIMECARD_DETAILS_V references the following:

APPS
PACKAGE - HR_GENERAL
SYNONYM - HXC_TIME_ATTRIBUTES
SYNONYM - HXC_TIME_ATTRIBUTE_USAGES
SYNONYM - HXC_TIME_BUILDING_BLOCKS
APPS.HXC_TIMECARD_DETAILS_V is referenced by following:

APPS
VIEW - HXC_APPROVAL_DETAILS_V
VIEW - HXC_RESOURCE_TIMECARD_DETAIL_V
VIEW - HXC_TIMECARD_ATTRIBUTES_V
VIEW - HXC_TIMECARD_DETAIL_HOURS_V

[top of page]

View: HXC_TIMECARD_DETAIL_HOURS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
DETAIL_TIMECARD_ID NUMBER (15) Y
DETAIL_OBJECT_VERSION NUMBER (9) Y
DETAIL_START_TIME DATE

DETAIL_STOP_TIME DATE

DETAIL_PARENT_TIMECARD_ID NUMBER (15)
DETAIL_PARENT_OBJECT_VERSION NUMBER (9)
DETAIL_RESOURCE_ID NUMBER (15)
DETAIL_MEASURE NUMBER

DETAIL_UNIT_OF_MEASURE VARCHAR2 (30)
DETAIL_HOURS_TYPE_ID VARCHAR2 (20)
DETAIL_CONTEXT VARCHAR2 (80)
DETAIL_SEGMENT VARCHAR2 (80)

[top of page]

APPS.HXC_TIMECARD_DETAIL_HOURS_V references the following:

APPS
PACKAGE - HR_GENERAL
VIEW - HXC_MAPPING_ATTRIBUTES_V
VIEW - HXC_TIMECARD_DETAILS_V

APPS.HXC_TIMECARD_DETAIL_HOURS_V is not referenced by any database object

[top of page]

View: HXC_TIMECARD_HOURS_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
TIMECARD_ID NUMBER (15) Y
TIMECARD_OVN NUMBER (9) Y
REGULAR_HOURS NUMBER

PREMIUM_HOURS NUMBER

NON_WORKED_HOURS NUMBER

TOTAL_HOURS NUMBER

[top of page]

APPS.HXC_TIMECARD_HOURS_V references the following:

APPS
SYNONYM - HXC_TIME_BUILDING_BLOCKS
PACKAGE - HXC_TIME_CATEGORY_UTILS_PKG

APPS.HXC_TIMECARD_HOURS_V is not referenced by any database object

[top of page]

View: HXC_TIMECARD_PERIODS_DB_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
START_TIME VARCHAR2 (10)
STOP_TIME VARCHAR2 (10)
RESOURCE_ID NUMBER (15)
RESOURCE_TYPE VARCHAR2 (30)

[top of page]

APPS.HXC_TIMECARD_PERIODS_DB_V references the following:

APPS
SYNONYM - HXC_TIME_BUILDING_BLOCKS

APPS.HXC_TIMECARD_PERIODS_DB_V is not referenced by any database object

[top of page]

View: HXC_TIMECARD_PERIODS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
DISPLAY_DATES VARCHAR2 (0)
VALUE_DATES VARCHAR2 (0)
RESOURCE_ID VARCHAR2 (0)
RESOURCE_TYPE VARCHAR2 (0)

[top of page]

APPS.HXC_TIMECARD_PERIODS_V references the following:

PUBLIC
SYNONYM - DUAL
- DUAL

APPS.HXC_TIMECARD_PERIODS_V is not referenced by any database object

[top of page]

View: HXC_TIMECARD_TEMPLATES_V

Comments
***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

Columns
Name Datatype Length Mandatory Comments
VALUE VARCHAR2 (48)
DISPLAY_VALUE VARCHAR2 (150)
RESOURCE_ID NUMBER

RESOURCE_TYPE VARCHAR2 (30)
LAYOUT_ID VARCHAR2 (150)

[top of page]

APPS.HXC_TIMECARD_TEMPLATES_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - FND_PROFILE
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOOKUPS
SYNONYM - HXC_TIME_ATTRIBUTES
SYNONYM - HXC_TIME_ATTRIBUTE_USAGES
SYNONYM - HXC_TIME_BUILDING_BLOCKS

APPS.HXC_TIMECARD_TEMPLATES_V is not referenced by any database object

[top of page]

View: HXC_TIME_CATEGORIES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TIME_CATEGORY_ID NUMBER (15) Y
OBJECT_VERSION_NUMBER NUMBER (9) Y
TIME_CATEGORY_NAME VARCHAR2 (90) Y
DESCRIPTION VARCHAR2 (240)
TIME_SQL LONG (0)
OPERATOR VARCHAR2 (30)
OPERATOR_MEANING VARCHAR2 (80) Y
DISPLAY VARCHAR2 (1)
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

APPS.HXC_TIME_CATEGORIES_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - HXC_TIME_CATEGORIES

APPS.HXC_TIME_CATEGORIES_V is not referenced by any database object

[top of page]

View: HXC_TIME_CATEGORY_COMPS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TIME_CATEGORY_COMP_ID NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (15)
TIME_CATEGORY_ID NUMBER (15)
REF_TIME_CATEGORY_ID NUMBER (15)
TIME_CATEGORY_NAME VARCHAR2 (90)
TIME_CATEGORY_DESCRIPTION VARCHAR2 (240)
REF_OPERATOR VARCHAR2 (30)
TYPE VARCHAR2 (10)
COMPONENT_TYPE_ID NUMBER (15)
FLEX_VALUE_SET_ID NUMBER (15)
EQUAL_TO VARCHAR2 (1)
IS_NULL VARCHAR2 (1)
IS_NULL_MEANING VARCHAR2 (80)
VALUE_ID VARCHAR2 (150)
VALUE VARCHAR2 (4000)
SEGMENT VARCHAR2 (80)
CONTEXT VARCHAR2 (80)
CATEGORY VARCHAR2 (80)
END_USER_COLUMN_NAME VARCHAR2 (30)
MAPPING_COMPONENT_NAME VARCHAR2 (80)
AN_CONTEXT VARCHAR2 (30)
AN_CONTEXT_MEANING VARCHAR2 (80)
ALIAS_VALUE_NAME VARCHAR2 (80)
VALUE_SET_NAME VARCHAR2 (60)
FORMULA_NAME VARCHAR2 (80)
FORMULA_DESCRIPTION VARCHAR2 (240)
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

APPS.HXC_TIME_CATEGORY_COMPS_V references the following:

APPS
SYNONYM - FF_FORMULAS_F
SYNONYM - FND_FLEX_VALUE_SETS
PACKAGE - FND_GLOBAL
SYNONYM - FND_LOOKUP_VALUES
SYNONYM - FND_SESSIONS
PACKAGE - HR_API
VIEW - HR_LOOKUPS
SYNONYM - HXC_ALIAS_DEFINITIONS
SYNONYM - HXC_ALIAS_TYPES
SYNONYM - HXC_ALIAS_TYPE_COMPONENTS
SYNONYM - HXC_ALIAS_VALUES
SYNONYM - HXC_BLD_BLK_INFO_TYPES
SYNONYM - HXC_MAPPING_COMPONENTS
VIEW - HXC_MAPPING_COMPONENTS_V
SYNONYM - HXC_TIME_CATEGORIES
SYNONYM - HXC_TIME_CATEGORY_COMPS
PACKAGE - HXC_TIME_CATEGORY_UTILS_PKG

APPS.HXC_TIME_CATEGORY_COMPS_V is not referenced by any database object

[top of page]

View: HXC_TIME_ENTRY_RULES_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TIME_ENTRY_RULE_ID NUMBER (15) Y
NAME VARCHAR2 (80) Y
RULE_USAGE VARCHAR2 (30) Y
BUSINESS_GROUP_ID NUMBER (15)
LEGISLATION_CODE VARCHAR2 (30)
RULE_USAGE_NAME VARCHAR2 (80)
MAPPING_ID NUMBER (15)
MAPPING_NAME VARCHAR2 (80)
FORMULA_ID NUMBER (9)
FORMULA_NAME VARCHAR2 (80)
FF_DESCRIPTION VARCHAR2 (240)
DESCRIPTION VARCHAR2 (2000)
START_DATE DATE
Y
END_DATE DATE

OBJECT_VERSION_NUMBER NUMBER (9)
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
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)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
ATTRIBUTE21 VARCHAR2 (150)
ATTRIBUTE22 VARCHAR2 (150)
ATTRIBUTE23 VARCHAR2 (150)
ATTRIBUTE24 VARCHAR2 (150)
ATTRIBUTE25 VARCHAR2 (150)
ATTRIBUTE26 VARCHAR2 (150)
ATTRIBUTE27 VARCHAR2 (150)
ATTRIBUTE28 VARCHAR2 (150)
ATTRIBUTE29 VARCHAR2 (150)
ATTRIBUTE30 VARCHAR2 (150)

[top of page]

APPS.HXC_TIME_ENTRY_RULES_V references the following:

APPS
SYNONYM - FF_FORMULAS_F
PACKAGE - FND_GLOBAL
VIEW - HXC_LOOKUPS
SYNONYM - HXC_MAPPINGS
SYNONYM - HXC_TIME_ENTRY_RULES
APPS.HXC_TIME_ENTRY_RULES_V is referenced by following:

APPS
VIEW - HXC_TIME_ENTRY_RULE_COMPS_V

[top of page]

View: HXC_TIME_ENTRY_RULE_COMPS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TIME_ENTRY_GROUP_COMP_ID NUMBER (15) Y
TIME_ENTRY_RULE_GROUP_ID NUMBER (15) Y
TIME_ENTRY_RULE_ID NUMBER (15) Y
TIME_ENTRY_RULE_NAME VARCHAR2 (80) Y
RULE_OUTCOME VARCHAR2 (150)
RULE_OUTCOME_NAME VARCHAR2 (80) Y
RULE_USAGE VARCHAR2 (30) Y
RULE_USAGE_NAME VARCHAR2 (80)
MAPPING_ID NUMBER (15)
MAPPING_NAME VARCHAR2 (80)
FORMULA_ID NUMBER (9)
FORMULA_NAME VARCHAR2 (240)
DESCRIPTION VARCHAR2 (2000)
START_DATE DATE
Y
END_DATE VARCHAR2 (9)
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)
ATTRIBUTE17 VARCHAR2 (150)
ATTRIBUTE18 VARCHAR2 (150)
ATTRIBUTE19 VARCHAR2 (150)
ATTRIBUTE20 VARCHAR2 (150)
ATTRIBUTE21 VARCHAR2 (150)
ATTRIBUTE22 VARCHAR2 (150)
ATTRIBUTE23 VARCHAR2 (150)
ATTRIBUTE24 VARCHAR2 (150)
ATTRIBUTE25 VARCHAR2 (150)
ATTRIBUTE26 VARCHAR2 (150)
ATTRIBUTE27 VARCHAR2 (150)
ATTRIBUTE28 VARCHAR2 (150)
ATTRIBUTE29 VARCHAR2 (150)
ATTRIBUTE30 VARCHAR2 (150)
OBJECT_VERSION_NUMBER NUMBER

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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

APPS.HXC_TIME_ENTRY_RULE_COMPS_V references the following:

APPS
PACKAGE - FND_GLOBAL
PACKAGE - HR_API
PACKAGE - HR_GENERAL
VIEW - HR_LOOKUPS
SYNONYM - HXC_ENTITY_GROUP_COMPS
VIEW - HXC_TIME_ENTRY_RULES_V
APPS.HXC_TIME_ENTRY_RULE_COMPS_V is referenced by following:

APPS
PACKAGE - HXC_TIME_ENTRY_RULES_UTILS_PKG

[top of page]

View: HXC_TIME_ENTRY_RULE_GROUPS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
TIME_ENTRY_RULE_GROUP_ID NUMBER (15) Y
TIME_ENTRY_RULE_GROUP_NAME VARCHAR2 (80) Y
OBJECT_VERSION_NUMBER NUMBER

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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).

[top of page]

APPS.HXC_TIME_ENTRY_RULE_GROUPS_V references the following:

APPS
SYNONYM - HXC_ENTITY_GROUPS
APPS.HXC_TIME_ENTRY_RULE_GROUPS_V is referenced by following:

APPS
PACKAGE BODY - HXC_HPH_UPLOAD_PKG
PACKAGE BODY - HXC_TERG_UPL_PKG

[top of page]

View: HXC_TK_GROUPS_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID
TK_GROUP_ID NUMBER (15) Y Primary Key
TK_GROUP_NAME VARCHAR2 (80) Y Timekeeper Group Name
TK_RESOURCE_ID NUMBER (15) Y The resource id (person id) of the timekeeper
LAST_NAME VARCHAR2 (150) Y Last Name of the Timekeeper
FIRST_NAME VARCHAR2 (150)
First Name of the Timekeeper
FULL_NAME VARCHAR2 (240)
Full Name of the Timekeeper
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
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.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
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).
BUSINESS_GROUP_ID NUMBER (15)
Stores the Business Group

[top of page]

APPS.HXC_TK_GROUPS_V references the following:

APPS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_PERSON_TYPE_USAGE_INFO
PACKAGE - HR_SECURITY
SYNONYM - HXC_TK_GROUPS
VIEW - PER_PEOPLE

APPS.HXC_TK_GROUPS_V is not referenced by any database object

[top of page]

View: HXC_TK_GROUP_QUERY_CRITERIA_V

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row Id
TK_GROUP_QUERY_CRITERIA_ID NUMBER (15) Y Primary Key
TK_GROUP_QUERY_ID NUMBER (15) Y Foreign Key to timekeeper group queries
CRITERIA_TYPE VARCHAR2 (30) Y The type of criteria specified in the Criteria Id, for example, 'PERSON' would mean a person is stored in Criteria Id
CRITERIA_ID NUMBER (15) Y
GROUP_QUERY_NAME VARCHAR2 (30) Y
TK_GROUP_ID NUMBER (15) Y The unique identifier of the entity specified in Criteria Type
INCLUDE_EXCLUDE VARCHAR2 (1) Y Include or Exclude the criteria from this query in the group. 'I' for Include, 'E' for Exclude.
SYSTEM_USER VARCHAR2 (1) Y Is this a Sytem generated or User defined query? 'S' for System and 'U' for User.
CRITERIA_DISPLAY1 VARCHAR2 (240)
Displays a meaning associated with the criteria id
CRITERIA_DISPLAY2 VARCHAR2 (30)
Displays a meaning associated with the criteria id
CRITERIA_DISPLAY_TYPE VARCHAR2 (4000)
Criteria Type
TC_PERIOD_NAME VARCHAR2 (4000)
AUDIT_ENABLED VARCHAR2 (4000)
Audit Enabled
OBJECT_VERSION_NUMBER NUMBER (9) Y Object Version Number
BUSINESS_GROUP_ID NUMBER (15) Y
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

LAST_UPDATED_BY NUMBER (15)
LAST_UPDATE_DATE DATE

LAST_UPDATE_LOGIN NUMBER (15)

[top of page]

APPS.HXC_TK_GROUP_QUERY_CRITERIA_V references the following:

APPS
PACKAGE - FND_PROFILE
SYNONYM - FND_SESSIONS
PACKAGE - HR_GENERAL
PACKAGE - HR_PERSON_NAME
PACKAGE - HR_PERSON_TYPE_USAGE_INFO
PACKAGE - HR_SECURITY
SYNONYM - HXC_TK_GROUP_QUERIES
SYNONYM - HXC_TK_GROUP_QUERY_CRITERIA
PACKAGE - HXC_TK_GRP_QUERY_CRITERIA_API
VIEW - PER_ASSIGNMENTS_F
VIEW - PER_PEOPLE
SYNONYM - PER_PERIODS_OF_PLACEMENT
SYNONYM - PER_PERSON_TYPES
VIEW - PER_PERSON_TYPE_USAGES

APPS.HXC_TK_GROUP_QUERY_CRITERIA_V is not referenced by any database object

[top of page]

View: HXC_TK_PAY_LOCATIONS

Comments
View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns
Name Datatype Length Mandatory Comments
LOCATION VARCHAR2 (105)
STATE_ID VARCHAR2 (2) Y
STATE VARCHAR2 (25) Y
COUNTY VARCHAR2 (30) Y
CITY VARCHAR2 (30) Y
ZIP VARCHAR2 (10) Y
ZIP_END VARCHAR2 (10) Y

[top of page]

APPS.HXC_TK_PAY_LOCATIONS references the following:

APPS
SYNONYM - PAY_US_CITY_NAMES
SYNONYM - PAY_US_COUNTIES
SYNONYM - PAY_US_STATES
SYNONYM - PAY_US_ZIP_CODES

APPS.HXC_TK_PAY_LOCATIONS is not referenced by any database object

[top of page]
Copyright (c) 2001 - 2005, Oracle - Use Restricted by Contract