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 - HXT Tables and Views

TABLE - HXT.HXT_ADD_ASSIGN_INFO_F

TABLE - HXT.HXT_ADD_ELEM_INFO_F

TABLE - HXT.HXT_BATCH_STATES

TABLE - HXT.HXT_DET_HOURS_WORKED_F

TABLE - HXT.HXT_EARNING_POLICIES

TABLE - HXT.HXT_EARNING_RULES

TABLE - HXT.HXT_EARN_GROUPS

TABLE - HXT.HXT_EARN_GROUP_TYPES

TABLE - HXT.HXT_ERRORS_F

TABLE - HXT.HXT_HOLIDAY_CALENDARS

TABLE - HXT.HXT_HOLIDAY_DAYS

TABLE - HXT.HXT_HOLIDAY_DAYS_TL

TABLE - HXT.HXT_HOUR_DEDUCTION_RULES

TABLE - HXT.HXT_HOUR_DEDUCT_POLICIES

TABLE - HXT.HXT_PREM_ELIGBLTY_POLICIES

TABLE - HXT.HXT_PREM_ELIGBLTY_POL_RULES

TABLE - HXT.HXT_PREM_ELIGBLTY_RULES

TABLE - HXT.HXT_PREM_INTERACT_POLICIES

TABLE - HXT.HXT_PREM_INTERACT_POL_RULES

TABLE - HXT.HXT_PREM_INTERACT_RULES

TABLE - HXT.HXT_PREV_WAGE_BASE

TABLE - HXT.HXT_PROJECTS

TABLE - HXT.HXT_ROTATION_PLANS

TABLE - HXT.HXT_ROTATION_SCHEDULES

TABLE - HXT.HXT_SHIFTS

TABLE - HXT.HXT_SHIFT_DIFF_POLICIES

TABLE - HXT.HXT_SHIFT_DIFF_RULES

TABLE - HXT.HXT_SUM_HOURS_WORKED_F

TABLE - HXT.HXT_TASKS

TABLE - HXT.HXT_TIMECARDS_F

TABLE - HXT.HXT_TIMECLOCK_ERRORS

TABLE - HXT.HXT_UPGRADE_BG_MESSAGES

TABLE - HXT.HXT_VARIANCES

TABLE - HXT.HXT_WEEKLY_WORK_SCHEDULES

TABLE - HXT.HXT_WORK_SHIFTS

VIEW - APPS.HXTFV_ADD_ASSIGN_INFO

VIEW - APPS.HXTFV_ADD_ELEM_INFO

VIEW - APPS.HXTFV_DET_HOURS_WORKED

VIEW - APPS.HXTFV_EARNING_GROUPS

VIEW - APPS.HXTFV_EARNING_POLICY

VIEW - APPS.HXTFV_EARNING_RULES

VIEW - APPS.HXTFV_ELIGIBILITY_POLICY

VIEW - APPS.HXTFV_HOLIDAY_CALENDARS

VIEW - APPS.HXTFV_HOURS_POLICY

VIEW - APPS.HXTFV_INTERACT_POLICY

VIEW - APPS.HXTFV_PROJECT_ACCOUNTING

VIEW - APPS.HXTFV_ROTATION_SCHEDULES

VIEW - APPS.HXTFV_SHIFTS

VIEW - APPS.HXTFV_SHIFT_POLICY

VIEW - APPS.HXTFV_SUM_HOURS_WORKED

VIEW - APPS.HXTFV_TIMECARDS

VIEW - APPS.HXTFV_VARIANCES

VIEW - APPS.HXT_ADD_ASSIGN_INFO

VIEW - APPS.HXT_ADD_ASSIGN_INFO_D

VIEW - APPS.HXT_ADD_ASSIGN_INFO_FMV

VIEW - APPS.HXT_ADD_ASSIGN_INFO_X

VIEW - APPS.HXT_ADD_ELEM_INFO

VIEW - APPS.HXT_ADD_ELEM_INFO_D

VIEW - APPS.HXT_ADD_ELEM_INFO_FMV

VIEW - APPS.HXT_ADD_ELEM_INFO_X

VIEW - APPS.HXT_ALL_PROJECTS_V

VIEW - APPS.HXT_ALL_TASKS_V

VIEW - APPS.HXT_BATCH_REFERENCE_V

VIEW - APPS.HXT_BATCH_STATUS_FMV

VIEW - APPS.HXT_BATCH_SUM_AMOUNTS_V

VIEW - APPS.HXT_BATCH_SUM_HOURS_ROLLUP_V

VIEW - APPS.HXT_BATCH_VALUES_V

VIEW - APPS.HXT_DAILY_HOURS_WORKED_V

VIEW - APPS.HXT_DET_HOURS_WORKED

VIEW - APPS.HXT_DET_HOURS_WORKED_FMV

VIEW - APPS.HXT_DET_HOURS_WORKED_X

VIEW - APPS.HXT_EARNING_POLICIES_FMV

VIEW - APPS.HXT_EARNING_RULES_FMV

VIEW - APPS.HXT_EMP_ASGN_INFO_V

VIEW - APPS.HXT_EMP_TIME_INFO_V

VIEW - APPS.HXT_ERRORS

VIEW - APPS.HXT_ERRORS_V

VIEW - APPS.HXT_ERRORS_X

VIEW - APPS.HXT_HDP_DET_HOURS_WORKED_V

VIEW - APPS.HXT_HDP_SUM_HOURS_WORKED_V

VIEW - APPS.HXT_HOLIDAY_DAYS_VL

VIEW - APPS.HXT_HOUR_DEDUCTION_RULES_FMV

VIEW - APPS.HXT_HR_ORG_INFO_DDF_V

VIEW - APPS.HXT_PAY_ELEMENT_TYPES_F_DDF_V

VIEW - APPS.HXT_PER_AEI_DDF_V

VIEW - APPS.HXT_PROJECTS_V

VIEW - APPS.HXT_RBCK_BATCH_REF_V

VIEW - APPS.HXT_SHIFTS_D

VIEW - APPS.HXT_SUM_HOURS_WORKED

VIEW - APPS.HXT_SUM_HOURS_WORKED_D

VIEW - APPS.HXT_SUM_HOURS_WORKED_FMV

VIEW - APPS.HXT_SUM_HOURS_WORKED_X

VIEW - APPS.HXT_TASKS_FMV

VIEW - APPS.HXT_TASKS_V

VIEW - APPS.HXT_TIMECARDS

VIEW - APPS.HXT_TIMECARDS_D

VIEW - APPS.HXT_TIMECARDS_FMV

VIEW - APPS.HXT_TIMECARDS_PER_FMV

VIEW - APPS.HXT_TIMECARDS_X

VIEW - APPS.HXT_TIM_SUMMARY_FMV

VIEW - APPS.HXT_VAL_BATCH_REFERENCE_V

VIEW - APPS.HXT_WEEKLY_WORK_SCHEDULES_FMV

VIEW - APPS.HXT_WORK_SHIFTS_FMV

Table: HXT_ADD_ASSIGN_INFO_F

Primary Key: HXT_AAIF_HRW_PK

1. ID
2. EFFECTIVE_START_DATE
3. EFFECTIVE_END_DATE

Foreign Keys from this table:

Comments

Contains all the time management policies and rules which are associated with the person's assignments.

Indexes

Columns

[top of page]

HXT.HXT_ADD_ASSIGN_INFO_F does not reference any database object

HXT.HXT_ADD_ASSIGN_INFO_F is referenced by following:

APPS

SYNONYM - HXT_ADD_ASSIGN_INFO_F

TRIGGER - HXT_ADD_ASSIGN_INFO_F_WHO

[top of page]

Table: HXT_ADD_ELEM_INFO_F

Primary Key: HXT_AEIF_HRW_PK

1. ID
2. EFFECTIVE_START_DATE
3. EFFECTIVE_END_DATE

Comments

Contains the details of time management elements such as absence category, premium type, premium amount and expenditure type details.

Indexes

Columns

[top of page]

HXT.HXT_ADD_ELEM_INFO_F does not reference any database object

HXT.HXT_ADD_ELEM_INFO_F is referenced by following:

APPS

SYNONYM - HXT_ADD_ELEM_INFO_F

TRIGGER - HXT_ADD_ELEM_INFO_F_WHO

[top of page]

Table: HXT_BATCH_STATES

Primary Key: HXT_BATCH_STATES_PK

1. BATCH_ID

Comments

Details of the batch status of timecards.

Indexes

Columns

[top of page]

HXT.HXT_BATCH_STATES does not reference any database object

HXT.HXT_BATCH_STATES is referenced by following:

APPS

SYNONYM - HXT_BATCH_STATES

[top of page]

Table: HXT_DET_HOURS_WORKED_F

Comments

A location for describing a specific block of time worked for a
specific date.

Indexes

Columns

[top of page]

HXT.HXT_DET_HOURS_WORKED_F does not reference any database object

HXT.HXT_DET_HOURS_WORKED_F is referenced by following:

APPS

SYNONYM - HXT_DET_HOURS_WORKED_F

TRIGGER - HXT_DET_HOURS_WORKED_F_WHO

[top of page]

Table: HXT_EARNING_POLICIES

Primary Key: HXT_EARNING_POLICIES_PK

1. ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

An Earning Policy may be composed of more than one overtime rule, a
premium policy, and a premium processing policy. For each assignment,
an employee is defined with one of an unlimited number of earning
policies. Earning policies provide the means for performing detailed
overtime calculations using the methods defined by the user in the
overtime rules.

Indexes

Columns

[top of page]

HXT.HXT_EARNING_POLICIES does not reference any database object

HXT.HXT_EARNING_POLICIES is referenced by following:

APPS

SYNONYM - HXT_EARNING_POLICIES

TRIGGER - HXT_EARNING_POLICIES_WHO

[top of page]

Table: HXT_EARNING_RULES

Primary Key: HXT_EARNING_RULES_PK

1. ID

Primary Key: HXT_EARNING_RULES_UK

1. EGP_ID
2. SEQ_NO

Foreign Keys from this table:

Comments

Identifies overtime earnings and the number of hours required. The
seq.no. indicates the order in which the overtime rules are applied.

Indexes

Columns

[top of page]

HXT.HXT_EARNING_RULES does not reference any database object

HXT.HXT_EARNING_RULES is referenced by following:

APPS

SYNONYM - HXT_EARNING_RULES

TRIGGER - HXT_EARNING_RULES_WHO

[top of page]

Table: HXT_EARN_GROUPS

Primary Key: HXT_EARN_GROUPS_PK

1. EGT_ID
2. ELEMENT_TYPE_ID

Foreign Keys from this table:

Comments

A link between earning group types and earning codes.

Indexes

Columns

[top of page]

HXT.HXT_EARN_GROUPS does not reference any database object

HXT.HXT_EARN_GROUPS is referenced by following:

APPS

SYNONYM - HXT_EARN_GROUPS

TRIGGER - HXT_EARN_GROUPS_WHO

[top of page]

Table: HXT_EARN_GROUP_TYPES

Primary Key: HXT_EARN_GROUP_TYPES_PK

1. ID

Primary Key: HXT_EARN_GROUP_TYPES_UK

1. NAME

Foreign Keys to this table:

Comments

A group of earning codes used for reporting purposes.

Indexes

Columns

[top of page]

HXT.HXT_EARN_GROUP_TYPES does not reference any database object

HXT.HXT_EARN_GROUP_TYPES is referenced by following:

APPS

SYNONYM - HXT_EARN_GROUP_TYPES

TRIGGER - HXT_EARN_GROUP_TYPES_WHO

[top of page]

Table: HXT_ERRORS_F

Comments

Table for storing errors encountered (ex. Auto-Gen process or timecard
entry).
User can view only hours worked records with STATUS=E. The error
message presented will aid the user in resolving timecard errors in
preparation for batch submittal to HRMS payroll. Once errors are
corrected the error record will be removed from this table.

Indexes

Columns

[top of page]

HXT.HXT_ERRORS_F does not reference any database object

HXT.HXT_ERRORS_F is referenced by following:

APPS

SYNONYM - HXT_ERRORS_F

TRIGGER - HXT_ERRORS_F_WHO

[top of page]

Table: HXT_HOLIDAY_CALENDARS

Primary Key: HXT_HOLIDAY_CALENDARS_PK

1. ID

Foreign Keys to this table:

Comments

Contains the names and descriptions of holiday calendars used to
determine paid and unpaid holiday.

Indexes

Columns

[top of page]

HXT.HXT_HOLIDAY_CALENDARS does not reference any database object

HXT.HXT_HOLIDAY_CALENDARS is referenced by following:

APPS

SYNONYM - HXT_HOLIDAY_CALENDARS

TRIGGER - HXT_HOLIDAY_CALENDARS_WHO

[top of page]

Table: HXT_HOLIDAY_DAYS

Primary Key: HXT_HOLIDAY_DAYS_PK

1. ID

Primary Key: HXT_HOLIDAY_DAYS_UK

1. NAME
2. HCL_ID
3. HOLIDAY_DATE

Foreign Keys from this table:

Comments

A location to put user-defined holiday dates. If hours are worked on
a holiday, these dates are used to process holidays and/or determine
special premiums.

Indexes

Columns

[top of page]

HXT.HXT_HOLIDAY_DAYS does not reference any database object

HXT.HXT_HOLIDAY_DAYS is referenced by following:

APPS

SYNONYM - HXT_HOLIDAY_DAYS

TRIGGER - HXT_HOLIDAY_DAYS_WHO

[top of page]

Table: HXT_HOLIDAY_DAYS_TL

Primary Key: HXT_HOLIDAY_DAYS_TL_PK

1. ID
2. LANGUAGE

Comments

Contains the translated user defined holiday days.

Indexes

Columns

[top of page]

HXT.HXT_HOLIDAY_DAYS_TL does not reference any database object

HXT.HXT_HOLIDAY_DAYS_TL is referenced by following:

APPS

SYNONYM - HXT_HOLIDAY_DAYS_TL

TRIGGER - HXT_HOLIDAY_DAYS_TL041249_WHO

[top of page]

Table: HXT_HOUR_DEDUCTION_RULES

Primary Key: HXT_HOUR_DEDUCTION_RULES_PK

1. HDP_ID
2. FCL_DEDUCTION_TYPE
3. EFFECTIVE_START_DATE
4. EFFECTIVE_END_DATE

Foreign Keys from this table:

Comments

A set of hour deductions that apply to a pay policy and the rules
governing their use. Employees that have earnings generated from total
hours worked may besubject to meal and break time deduction.

Indexes

Columns

[top of page]

HXT.HXT_HOUR_DEDUCTION_RULES does not reference any database object

HXT.HXT_HOUR_DEDUCTION_RULES is referenced by following:

APPS

SYNONYM - HXT_HOUR_DEDUCTION_RULES

TRIGGER - HXT_HOUR_DEDUCTION_RULES_WHO

[top of page]

Table: HXT_HOUR_DEDUCT_POLICIES

Primary Key: HXT_HOUR_DEDUCT_POLICIES_PK

1. ID

Primary Key: HXT_HOUR_DEDUCT_POLICIES_UK

1. NAME

Foreign Keys to this table:

Comments

Contains names and descriptions of the Hour Deduction policies.

Indexes

Columns

[top of page]

HXT.HXT_HOUR_DEDUCT_POLICIES does not reference any database object

HXT.HXT_HOUR_DEDUCT_POLICIES is referenced by following:

APPS

SYNONYM - HXT_HOUR_DEDUCT_POLICIES

TRIGGER - HXT_HOUR_DEDUCT_POLICIES_WHO

[top of page]

Table: HXT_PREM_ELIGBLTY_POLICIES

Primary Key: HXT_PREM_ELIGBLTY_POLICIES_PK

1. ID

Primary Key: HXT_PREM_ELIGBLTY_POLICIES_UK

1. NAME
2. DATE_FROM

Foreign Keys to this table:

Comments

Determines the premiums that may be paid on each base earning.

Indexes

Columns

[top of page]

HXT.HXT_PREM_ELIGBLTY_POLICIES does not reference any database object

HXT.HXT_PREM_ELIGBLTY_POLICIES is referenced by following:

APPS

SYNONYM - HXT_PREM_ELIGBLTY_POLICIES

TRIGGER - HXT_PREM_ELIGBLTY_POLICIES_WHO

[top of page]

Table: HXT_PREM_ELIGBLTY_POL_RULES

Primary Key: HXT_PREM_ELIGBLTY_POL_RULES_PK

1. PEP_ID
2. ELT_BASE_ID
3. EFFECTIVE_START_DATE
4. EFFECTIVE_END_DATE

Foreign Keys from this table:

Comments

Defines the polcies which applies to eligible premiums for a group of
people.

Indexes

Columns

[top of page]

HXT.HXT_PREM_ELIGBLTY_POL_RULES does not reference any database object

HXT.HXT_PREM_ELIGBLTY_POL_RULES is referenced by following:

APPS

SYNONYM - HXT_PREM_ELIGBLTY_POL_RULES

TRIGGER - HXT_PREM_ELIGBLTY_POL_RULE_WHO

[top of page]

Table: HXT_PREM_ELIGBLTY_RULES

Primary Key: HXT_PREM_ELIGBLTY_RULES_PK

1. PEP_ID
2. ELT_BASE_ID
3. ELT_PREMIUM_ID
4. EFFECTIVE_START_DATE
5. EFFECTIVE_END_DATE

Foreign Keys from this table:

Comments

Determines the rules which governs the Premium Eligibilty.

Indexes

Columns

[top of page]

HXT.HXT_PREM_ELIGBLTY_RULES does not reference any database object

HXT.HXT_PREM_ELIGBLTY_RULES is referenced by following:

APPS

SYNONYM - HXT_PREM_ELIGBLTY_RULES

TRIGGER - HXT_PREM_ELIGBLTY_RULES_WHO

[top of page]

Table: HXT_PREM_INTERACT_POLICIES

Primary Key: HXT_PREM_INTERACT_POLICIES_PK

1. ID

Foreign Keys to this table:

Comments

Determines whether a premium includes components of previously applied
premiums. For example, when a shift differential is paid on an
overtime shift the system determines an adjustment by the overtime
factor.

Indexes

Columns

[top of page]

HXT.HXT_PREM_INTERACT_POLICIES does not reference any database object

HXT.HXT_PREM_INTERACT_POLICIES is referenced by following:

APPS

SYNONYM - HXT_PREM_INTERACT_POLICIES

TRIGGER - HXT_PREM_INTERACT_POLICIES_WHO

[top of page]

Table: HXT_PREM_INTERACT_POL_RULES

Primary Key: HXT_PREM_INTERACT_POL_RULES_PK

1. PIP_ID
2. ELT_EARNED_PREM_ID
3. EFFECTIVE_START_DATE
4. EFFECTIVE_END_DATE

Foreign Keys from this table:

Comments

Determines the rules which govern the premium interaction policies.

Indexes

Columns

[top of page]

HXT.HXT_PREM_INTERACT_POL_RULES does not reference any database object

HXT.HXT_PREM_INTERACT_POL_RULES is referenced by following:

APPS

SYNONYM - HXT_PREM_INTERACT_POL_RULES

TRIGGER - HXT_PREM_INTERACT_POL_RULE_WHO

[top of page]

Table: HXT_PREM_INTERACT_RULES

Primary Key: HXT_PREM_INTERACT_RULES_PK

1. PIP_ID
2. ELT_EARNED_PREM_ID
3. ELT_PRIOR_PREM_ID
4. EFFECTIVE_START_DATE
5. EFFECTIVE_END_DATE

Foreign Keys from this table:

Comments

Determines the rules which apply to the perimum interaction.

Indexes

Columns

[top of page]

HXT.HXT_PREM_INTERACT_RULES does not reference any database object

HXT.HXT_PREM_INTERACT_RULES is referenced by following:

APPS

SYNONYM - HXT_PREM_INTERACT_RULES

TRIGGER - HXT_PREM_INTERACT_RULES_WHO

[top of page]

Table: HXT_PREV_WAGE_BASE

Primary Key: HXT_PREV_WAGE_BASE_PK

1. PREV_WAGE_CODE
2. EFFECTIVE_START_DATE
3. EFFECTIVE_END_DATE

Comments

Indexes

Columns

[top of page]

HXT.HXT_PREV_WAGE_BASE does not reference any database object

HXT.HXT_PREV_WAGE_BASE is referenced by following:

APPS

SYNONYM - HXT_PREV_WAGE_BASE

[top of page]

Table: HXT_PROJECTS

Primary Key: HXT_PROJECTS_PK

1. ID

Primary Key: HXT_PROJECTS_UK

1. NAME

Foreign Keys to this table:

Comments

Contains the details of projects that user has defined.

Indexes

Columns

[top of page]

HXT.HXT_PROJECTS does not reference any database object

HXT.HXT_PROJECTS is referenced by following:

APPS

SYNONYM - HXT_PROJECTS

TRIGGER - HXT_PROJECTS_WHO

[top of page]

Table: HXT_ROTATION_PLANS

Primary Key: HXT_ROTATION_PLANS_PK

1. ID

Primary Key: HXT_ROTATION_PLANS_UK

1. NAME

Foreign Keys to this table:

Comments

The details of a rotation plan which is composed of many work plans
starting at specified dates.

Indexes

Columns

[top of page]

HXT.HXT_ROTATION_PLANS does not reference any database object

HXT.HXT_ROTATION_PLANS is referenced by following:

APPS

SYNONYM - HXT_ROTATION_PLANS

TRIGGER - HXT_ROTATION_PLANS_WHO

[top of page]

Table: HXT_ROTATION_SCHEDULES

Primary Key: HXT_ROTATION_SCHEDULES_PK

1. RTP_ID
2. START_DATE

Foreign Keys from this table:

Comments

A location to put rotating work plan schedules.

Indexes

Columns

[top of page]

HXT.HXT_ROTATION_SCHEDULES does not reference any database object

HXT.HXT_ROTATION_SCHEDULES is referenced by following:

APPS

SYNONYM - HXT_ROTATION_SCHEDULES

TRIGGER - HXT_ROTATION_SCHEDULES_WHO

[top of page]

Table: HXT_SHIFTS

Primary Key: HXT_SHIFTS_PK

1. ID

Primary Key: HXT_SHIFTS_UK

1. NAME

Foreign Keys to this table:

Comments

Defines company shifts based on a twenty-four hour clock. Shifts are
created with start and stop times. Work Plan, work Schedule, and Shift
are all used to calculate the number of hours paid. Shift hours are
determined by Shift Stop Hours minus Shift Start Hours.

Indexes

Columns

[top of page]

HXT.HXT_SHIFTS does not reference any database object

HXT.HXT_SHIFTS is referenced by following:

APPS

SYNONYM - HXT_SHIFTS

TRIGGER - HXT_SHIFTS_WHO

[top of page]

Table: HXT_SHIFT_DIFF_POLICIES

Primary Key: HXT_SHIFT_DIFF_POLICIES_PK

1. ID

Primary Key: HXT_SHIFT_DIFF_POLICIES_UK

1. NAME

Foreign Keys to this table:

Comments

A location to putcompany shift differential policies. A shift
differential policy can be made up of differentials which define the
start and stop time(s). Differentials are linked to a shift
differential type earning code. The daily shift differential is
generated by matching the shift differential start and stop time to
the employee time record start and stop time. The earning code and
shift differential entries are used to compute the premium. If the
time-in and time-out inputs are changed by data entry, the system
recomputes the total hours and continues to apply the proper shift
differential.

Indexes

Columns

[top of page]

HXT.HXT_SHIFT_DIFF_POLICIES does not reference any database object

HXT.HXT_SHIFT_DIFF_POLICIES is referenced by following:

APPS

SYNONYM - HXT_SHIFT_DIFF_POLICIES

TRIGGER - HXT_SHIFT_DIFF_POLICIES_WHO

[top of page]

Table: HXT_SHIFT_DIFF_RULES

Primary Key: HXT_SHIFT_DIFF_RULES_PK

1. ID

Primary Key: HXT_SHIFT_DIFF_RULES_UK

1. NAME
2. SDP_ID

Foreign Keys from this table:

Comments

Describes and defines a time range that includes separate pay rules
for a specific shift.

Indexes

Columns

[top of page]

HXT.HXT_SHIFT_DIFF_RULES does not reference any database object

HXT.HXT_SHIFT_DIFF_RULES is referenced by following:

APPS

SYNONYM - HXT_SHIFT_DIFF_RULES

TRIGGER - HXT_SHIFT_DIFF_RULES_WHO

[top of page]

Table: HXT_SUM_HOURS_WORKED_F

Comments

Describes a summary of the number of hours, rate and type of
premium associated with each hour worked in a payroll period..

Indexes

Columns

[top of page]

HXT.HXT_SUM_HOURS_WORKED_F does not reference any database object

HXT.HXT_SUM_HOURS_WORKED_F is referenced by following:

APPS

SYNONYM - HXT_SUM_HOURS_WORKED_F

TRIGGER - HXT_SUM_HOURS_WORKED_F_WHO

[top of page]

Table: HXT_TASKS

Primary Key: HXT_TASKS_PK

1. ID
2. PRO_ID

Primary Key: HXT_TASKS_UK

1. PRO_ID
2. NAME

Foreign Keys from this table:

Comments

Defines a divided project assigned to an employee.

Indexes

Columns

[top of page]

HXT.HXT_TASKS does not reference any database object

HXT.HXT_TASKS is referenced by following:

APPS

SYNONYM - HXT_TASKS

TRIGGER - HXT_TASKS_WHO

[top of page]

Table: HXT_TIMECARDS_F

Comments

A location to store the number of hours an employee works in a payroll
period.

Indexes

Columns

[top of page]

HXT.HXT_TIMECARDS_F does not reference any database object

HXT.HXT_TIMECARDS_F is referenced by following:

APPS

SYNONYM - HXT_TIMECARDS_F

TRIGGER - HXT_TIMECARDS_F_WHO

[top of page]

Table: HXT_TIMECLOCK_ERRORS

Primary Key: HXT_TIMECLOCK_ERRORS_PK

1. ID

Comments

HXT_TIMECLOCK_ERRORS contains error messages displayed during the HXT API upload

Indexes

Columns

[top of page]

HXT.HXT_TIMECLOCK_ERRORS does not reference any database object

HXT.HXT_TIMECLOCK_ERRORS is referenced by following:

APPS

SYNONYM - HXT_TIMECLOCK_ERRORS

TRIGGER - HXT_TIMECLOCK_ERRORS_WHO

[top of page]

Table: HXT_UPGRADE_BG_MESSAGES

Comments

This table is used to store the error messages raised during the OTM business group upgrade.

Columns

[top of page]

HXT.HXT_UPGRADE_BG_MESSAGES does not reference any database object

HXT.HXT_UPGRADE_BG_MESSAGES is referenced by following:

APPS

SYNONYM - HXT_UPGRADE_BG_MESSAGES

[top of page]

Table: HXT_VARIANCES

Primary Key: HXT_VARIANCES_PK

1. FCL_PERIOD
2. VAR_TYPE_ID

Comments

A location to define earning variance thersholds (highs and lows).

Indexes

Columns

[top of page]

HXT.HXT_VARIANCES does not reference any database object

HXT.HXT_VARIANCES is referenced by following:

APPS

SYNONYM - HXT_VARIANCES

TRIGGER - HXT_VARIANCES_WHO

[top of page]

Table: HXT_WEEKLY_WORK_SCHEDULES

Primary Key: HXT_WEEKLY_WORK_SCHEDULES_PK

1. ID

Primary Key: HXT_WEEKLY_WORK_SCHEDULES_UK

1. NAME
2. BUSINESS_GROUP_ID

Foreign Keys to this table:

Comments

A location to define a company's various employee work plans.
Assigning a new work plan is easily done throughout the pay year. The
work plan indicates the employees shift for each day.
An employee's work shif is the foundation for all earnings.
Provides an unlimited number of plans with early or late start and
stop times including any grace periods. Multiple work plans may be
effective during the pay period.

Indexes

Columns

[top of page]

HXT.HXT_WEEKLY_WORK_SCHEDULES does not reference any database object

HXT.HXT_WEEKLY_WORK_SCHEDULES is referenced by following:

APPS

SYNONYM - HXT_WEEKLY_WORK_SCHEDULES

TRIGGER - HXT_WEEKLY_WORK_SCHEDULES_WHO

[top of page]

Table: HXT_WORK_SHIFTS

Primary Key: HXT_WORK_SHIFTS_PK

1. SHT_ID
2. TWS_ID
3. SEQ_NO

Foreign Keys from this table:

Comments

A location to define an employee's work shifts on which all earnings
are based.
Provides an unlimited number of shifts with early or late start and
stop times including any grace periods.

Indexes

Columns

[top of page]

HXT.HXT_WORK_SHIFTS does not reference any database object

HXT.HXT_WORK_SHIFTS is referenced by following:

APPS

SYNONYM - HXT_WORK_SHIFTS

TRIGGER - HXT_WORK_SHIFTS_WHO

[top of page]

View: HXTFV_ADD_ASSIGN_INFO

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

[top of page]

APPS

SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL

PACKAGE - HR_GENERAL

PACKAGE - HR_SECURITY

SYNONYM - HXT_ADD_ASSIGN_INFO_F

SYNONYM - HXT_EARNING_POLICIES

SYNONYM - HXT_HOUR_DEDUCT_POLICIES

SYNONYM - HXT_ROTATION_PLANS

SYNONYM - HXT_SHIFT_DIFF_POLICIES

SYNONYM - PER_ALL_PEOPLE_F

VIEW - PER_ASSIGNMENTS_F

PUBLIC

SYNONYM - HXTFV_ADD_ASSIGN_INFO

[top of page]

View: HXTFV_ADD_ELEM_INFO

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

[top of page]

APPS

PACKAGE - HR_GENERAL

SYNONYM - HXT_ADD_ELEM_INFO_F

SYNONYM - PAY_ELEMENT_TYPES_F

PUBLIC

SYNONYM - HXTFV_ADD_ELEM_INFO

[top of page]

View: HXTFV_DET_HOURS_WORKED

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