Apps - Oracle Hrms Tables 23v70
This document was ed by and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this report form. Report 3i3n4
Overview 26281t
& View Apps - Oracle Hrms Tables as PDF for free.
More details 6y5l6z
- Words: 6,104
- Pages: 30
11/01/2015
Apps Oracle HRMS Tables
Oracle HRMS Tables
| Print |
Written by Anil i Saturday, 20 January 2007 Please find a list of Oracle HRMS Tables, with a brief description. You can also get the most uptodate list from FND_TABLES Oracle HRMS Table Name
Table Description
HR_ALL_ORGANIZATION_UNITS
Organization unit definitions.
HR_ALL_ORGANIZATION_UNITS_TL
Translated organization unit name definitions.
HR_ALL_POSITIONS_F
Position definition information.
HR_ALL_POSITIONS_F_TL
Translation table
HR_API_BATCH_MESSAGE_LINES
Results and messages generated during batch API processing.
HR_API_HOOKS
Lists the hook points which are available in each API module.
Lists which extra logic, package procedures or formula, should be HR_API_HOOK_CALLS
called from the API hook points.
HR_API_MODULES
Holds details of the business processes and row handlers.
HR_API_TRANSACTIONS
Kiosk processes in progress
HR_API_TRANSACTION_STEPS
Kiosk workflow data rows
HR_API_TRANSACTION_VALUES
Kiosk workflow data columns and values
Used to hold HR_API__HOOK error information if this HR_API__HOOK_REPORTS
exists otherwise no information is held.
HR_ASSIGNMENT_SETS
Formula definitions that identify sets of assignments.
HR_ASSIGNMENT_SET_AMENDMENTS
Identifies explicit include and exclude rules for an assignment set.
HR_ASSIGNMENT_SET_CRITERIA
Identifies individual criteria in the definition of an assignment set.
HR_ATH_ELIGIBLE_TBLS
This table contains ODBC connectivity information for the HR_ATH_ENROLL_TBLS
Authoria enrolled plans table﴾s﴿.
HR_ATH_VARIABLEMAP
Variable mappings table for the Authoria Integration
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
1/30
11/01/2015
Apps Oracle HRMS Tables
HR_AUTHORIA_MAPPINGS
Authoria Mapping Information
HR_CALENDARS
Dated instances of a repeating pattern.
HR_CALENDAR_USAGES
Assignments of calendars to individual entities.
HR_CANVAS_PROPERTIES
Canvas properties for configurable forms
HR_COMMENTS
Central repository for comments.
Holds Liability Insurance Providers rates for the HR_DE_LIABILITY_S_F
Organization
HR_DE_ORGANIZATION_LINKS
Holds extra information for Organizations links with External Orgs
HR_DE_SOC_INS_CONTR_LVLS_F
Holds German Social Insurance Contibution data
HR_DM_APPLICATION_GROUPS
Data Migrator locking ladder groups for applications.
HR_DM_COLUMN_DEFINITIONS
Column definitions for sequence range management
HR_DM_DATABASES
Table containing names of all databases within database farm
This table holds the information for the deletion of date tracked data. This table is also used to hold participant data information HR_DM_DT_DELETES
of data that has been ed but not been ed.
This table holds the data from various tables in the source database that will be moved to the destination database using the HR_DM_EXP_IMPS
transportable tablespace for in the destination database
This table holds information about the groupings used in the data HR_DM_GROUPS
migration process.
This entity will contain the relationships between tables. The HR_DM_HIERARCHIES
following relationship will be recorded:
HR_DM_LOADER_PARAMS
This entity contains the configuration data for the AOL loader files
This entity contains the migration specific configuration data for HR_DM_LOADER_PHASE_ITEMS
the AOL loader files.
This table contains the data migration information. There is one HR_DM_MIGRATIONS
row per migration in progress.
This table holds the allocated ranges for each slave process to http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
2/30
11/01/2015
Apps Oracle HRMS Tables
process during each Application/Participant data HR_DM_MIGRATION_RANGES
phase of the migration.
This table holds the information about the request id of the HR_DM_MIGRATION_REQUESTS
issuing concurrent program.
This table holds the information about each phase of the HR_DM_PHASES
migration process.
This table details the work to be undertaken for each phase of the HR_DM_PHASE_ITEMS
Data Migrator.
This table contains the rules governing which phases apply to HR_DM_PHASE_RULES
which migrations.
This entity contains the values of the primary key for both the source and destination database for each table for use by the HR_DM_RESOLVE_PKS
TUPS package.
Table containing Sequence Name information for the HR_DM_SEQUENCE_DEFINITIONS
PER/PAY/DT/FF/OTA/SSP/GHR/HXT/BEN applications.
Table containing sequence information from the different Fidelity databases. To be updated before any changes to sequences are HR_DM_SEQUENCE_HISTORIES
made to enable sequence history tracking.
Table containing Sequence Ranges for particular Sequence and Database. This table can hold multiple Ranges for a given HR_DM_SEQUENCE_RANGES
Sequence and Database.
This entity contains a HRMS table listing that will be processed by HR_DM_TABLES
the data migrator.
HR_DM_TABLE_GROUPINGS
This entity holds the information for the grouping of tables.
HR_DOCUMENT_EXTRA_INFO
Documents of Record Information
HR_DOCUMENT_TYPES
Document Types for Documents od Record
HR_DOCUMENT_TYPES_TL
Translated Document Types for Documents of Record
This table holds the relationship between the column name used in the source object ﴾e.g. the spreadsheet column﴿ and the output HR_DU_COLUMN_MAPPINGS
target ﴾e.g. the Data Pump parameter name﴿.
This table holds the descriptor details for each API to be HR_DU_DESCRIPTORS
ed.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
3/30
11/01/2015
Apps Oracle HRMS Tables
This table holds details about errors encountered during HR_DU_ERRORS
processing of a batch by any of the Data er modules.
This table holds the details about each module which can be HR_DU_MODULES
used for either input, process or output with in the data er.
This table holds the data relating to information ed from a HR_DU_S
single source file.
HR_DU__HEADERS
This table holds the details for each API to be ed.
This table holds the details for each item to be ed with an HR_DU__LINES
item spanning one or more rows
Contains one row for each time the EFC conversion process or HR_EFC_ACTIONS
delete _EFC table data process is run.
Contains one row per NCU currency as defined in FND_CURRENCIES at the time of the EFC processing with HR_EFC_CURRENCY_HISTORIES
details of the NCU.
Holds one row for each processing script in each conversion HR_EFC_PROCESS_COMPONENTS
processing run.
Holds one row for each time a rounding error adjustment has HR_EFC_ROUNDING_ERRORS
been made.
Holds one row for each parallel worker instance of a processing HR_EFC_WORKERS
component.
Holds one row for each HR_EFC_WORKER row per currency HR_EFC_WORKER_AUDITS
code processed for update scripts only.
HR_EXCEPTION_USAGES
Identifies usage of defined exceptions to a repeating pattern.
HR_FORM_CANVASES_B
Canvas definition for configurable forms
HR_FORM_CANVASES_TL
Translated canvas definitions for configurable forms.
HR_FORM_DATA_GROUPS_B
Form data group definition for configurable forms
HR_FORM_DATA_GROUPS_TL
Translated form data group definitions for configurable forms
HR_FORM_DATA_GROUP_ITEMS
Links items with data groups for configurable forms
HR_FORM_ITEMS_B
Definition of items available for configurable forms
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
4/30
11/01/2015
Apps Oracle HRMS Tables
HR_FORM_ITEMS_TL
Translated definitions of form items for configurable forms
HR_FORM_PROPERTIES
Configurable properties for configurable forms modules
HR_FORM_TAB_PAGES_B
Definition of form tab page for configurable forms
HR_FORM_TAB_PAGES_TL
Translated definition of form tab page for configurable forms
HR_FORM_TAB_STACKED_CANVASES
Definition of stacked canvas for tab pages in configurable forms
HR_FORM_TEMPLATES_B
Definition of template used by configurable forms
HR_FORM_TEMPLATES_TL
Translated template definition for use in configurable forms
HR_FORM_WINDOWS_B
Definition of windows for use in configurable forms
HR_FORM_WINDOWS_TL
Translated definition of windows for configurable form
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to addresses while data is HR_H2PI_ADDRESSES
in progress.
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to assignments while data HR_H2PI_ASSIGNMENTS
is in progress.
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to bg_and_gre while data HR_H2PI_BG_AND_GRE
is in progress.
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to us employees city tax rules HR_H2PI_CITY_TAX_RULES
while data is in progress.
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to cost allocations s while data HR_H2PI_COST_ALLOCATIONS
is in progress.
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to us employee county tax rules HR_H2PI_COUNTY_TAX_RULES
while data is in progress.
This table stores information about date feed history for Oracle HR_H2PI_DATA_FEED_HIST
HR to Oracle Payroll Interface ﴾H2PI﴿.
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to element entries while data HR_H2PI_ELEMENT_ENTRIES
is in progress.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
5/30
11/01/2015
Apps Oracle HRMS Tables
HR_H2PI_ELEMENT_ENTRY_VALUES
HR_H2PI_ELEMENT_LINKS
HR_H2PI_ELEMENT_NAMES
HR_H2PI_ELEMENT_TYPES
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to employees while data is HR_H2PI_EMPLOYEES
in progress.
HR_H2PI_FEDERAL_TAX_RULES
HR_H2PI_HR_ORGANIZATIONS
This table stores information about ID mapping for Oracle HR to HR_H2PI_ID_MAPPING
Oracle Payroll Interface ﴾H2PI﴿.
HR_H2PI_INPUT_VALUES
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to locations while data is HR_H2PI_LOCATIONS
in progress.
This table stores information about all the messages for Oracle HR_H2PI_MESSAGE_LINES
HR to Oracle Payroll Interface ﴾H2PI﴿.
HR_H2PI_ORGANIZATION_CLASS
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to organization info while data HR_H2PI_ORGANIZATION_INFO
is in progress.
HR_H2PI_ORG_PAYMENT_METHODS
HR_H2PI_PATCH_STATUS
HR_H2PI_PAYMENT_METHODS
HR_H2PI_PAYROLLS
HR_H2PI_PAY_BASES
HR_H2PI_PERIODS_OF_SERVICE
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
6/30
11/01/2015
Apps Oracle HRMS Tables
HR_H2PI_SALARIES
HR_H2PI_STATE_TAX_RULES
HR_H2PI_US_CITY_NAMES
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to US midified geocodes while HR_H2PI_US_MODIFIED_GEOCODES
data is in progress.
HR_INCOMPATIBILITY_RULES
Incompatibility rules for navigation units.
HR_ITEM_CONTEXTS
Combinations table for the item context key flexfield ICX
HR_ITEM_PROPERTIES_B
Properties for form or template items used by configurable forms.
HR_ITEM_PROPERTIES_TL
Translatable properties of items for configurable forms
This table holds unique id for Japanese legislative specific data in order not to hardcode Multibyte characters in Japanese HR_JP_PARAMETERS
localization code objects.
This table holds the details of the KI integration external HR_KI_EXT_APPLICATIONS
applications
HR_KI_SESSIONS
Information about an instance of a SelfService Interface HR_LAYOUTS
configuration.
HR_LAYOUTS_TL
Translation table for HR_LAYOUTS.
Set of Interface Components used within a configurable HR_LAYOUT_COMPONENTS
SelfService layout.
Definitions of the set of Interface components that can be HR_LAYOUT_COMP_DEFINITIONS
used within a configurable Self Service Interface Layout.
Set of prompt codes associated with a Configurable UI Layout HR_LAYOUT_COMP_PROMPTS
Component
Set of layout qualifiers which can be used to modify the rendering HR_LAYOUT_COMP_QUALIFIERS
of a Self Service Interface component.
Set of rules that determine whether a Self Service Interface HR_LAYOUT_COMP_QUAL_RULES
component can use a particular layout qualifier.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
7/30
11/01/2015
Apps Oracle HRMS Tables
HR_LEGISLATION_INSTALLATIONS
Status of each product/legislation combination installed
HR_LOCATIONS_ALL
Work location definitions.
HR_LOCATIONS_ALL_TL
Translated location codes and descriptions.
HR_LOCATION_EXTRA_INFO
Extra information for a location.
HR_LOCATION_INFO_TYPES
Types of extra information that may be held against a Location.
Contains the format masks used to determine the displayed formats of personal names in Applications. Oracle will seed rows in this table which cannot be deleted, but can be modified by HR_NAME_FORMATS
customers. Additional rows can be created.
HR_NAVIGATION_CONTEXT_RULES
Context specific rules for taskflow navigation.
HR_NAVIGATION_NODES
Taskflow node definitions.
Intersection table between HR_WORKFLOWS, HR_NAVIGATION_NODE_USAGES
HR_NAVIGATION_NODES and HR_NAVIGATION_PATHS.
HR_NAVIGATION_PATHS
Taskflow navigation path details.
HR_NAVIGATION_PATHS_TL
HR_NAVIGATION_UNITS
Information about potential navigation options in a taskflow.
HR_NAVIGATION_UNITS_TL
Translated fields for hr_navigation_units
Global variable usage by specific navigation unit. ﴾Form or HR_NAV_UNIT_GLOBAL_USAGES
block﴿.
Additional attributes of an organization, dependent on class or HR_ORGANIZATION_INFORMATION
organization information type.
This is a copy of theHR_ORGANIZATION_INFORMATION table which is populated by the EFC ﴾Euro as Functional Currency﴿ HR_ORGANIZATION_INFORMATIO_EFC
process.
Information types that are used to add information for an HR_ORG_INFORMATION_TYPES
organization.
Defines organization information types for specific organization HR_ORG_INFO_TYPES_BY_CLASS
classifications.
A repeating time pattern, eg a work pattern, SSP qualifying http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
8/30
11/01/2015
Apps Oracle HRMS Tables
HR_PATTERNS
pattern or a resource schedule.
HR_PATTERN_BITS
A defined period of time used to construct a pattern.
Decomposition of a repeating pattern into its individual 'bits' of HR_PATTERN_CONSTRUCTIONS
time.
HR_PATTERN_EXCEPTIONS
An exception to a repeating pattern.
Potential purpose for the parent pattern, eg 'Work Pattern', HR_PATTERN_PURPOSES
'Resource schedule', etc.
HR_PATTERN_PURPOSE_USAGES
Valid combinations of entities and pattern purposes.
HR_PTL_SUMMARY_DATA
HR_PUMP_BATCH_EXCEPTIONS
Holds data pump processing exception ﴾error﴿ information.
HR_PUMP_BATCH_HEADERS
Stores information on a batch to be loaded by the data pump.
Each rows stores the information required to make an API call. HR_PUMP_BATCH_LINES
OUTparameter values are written back after the API call.
keys and their associated information is stored here on the HR_PUMP_BATCH_LINE__KEYS
creation of entities that require keys.
Lists API modules that do not conform to the API parameter HR_PUMP_DEFAULT_EXCEPTIONS
defaulting rules.
Lists PL/SQL packages that contain the parameter mapping functions used by data pump generated code. If module_package and module_name are both null then the mapping functions may HR_PUMP_MAPPING_PACKAGES
be used by all APIs.
Holds seeded information about API parameters for data pump HR_PUMP_MODULE_PARAMETERS
code generation.
Controls the parallelisation of the work when the data pump is HR_PUMP_RANGES
running on multiprocessor platforms.
Holds information on data pump concurrent requests currently HR_PUMP_REQUESTS
running.
HR_QUESTIONNAIRES
Questionnaires used within SSHR.
HR_QUEST_ANSWERS
Answers for a questionnaire.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
9/30
11/01/2015
Apps Oracle HRMS Tables
HR_QUEST_ANSWER_VALUES
Answer values for a questionnaire.
HR_QUEST_FIELDS
Fields of a questionnaire.
Legislation specific information for payrolls, organizations and HR_SOFT_CODING_KEYFLEX
assignments.
Identities of templates which have been copied and the resulting HR_SOURCE_FORM_TEMPLATES
copy. Helps distinguish seeded templates from copied ones.
HR_STU_EXCEPTIONS
Error conditions from the startup data process.
HR_STU_HISTORY
Versions of HRMS Startup data installed
HR_SUMMARY
HR_SUMMARY holds all data for the Generic Summary Process.
This is a copy of the HR_SUMMARY table which is populated by HR_SUMMARY_EFC
the EFC ﴾Euro as Functional Currency﴿ process.
HR_S_MAGNETIC_BLOCKS
HR_S_MAGNETIC_RECORDS
HR_S_US_CITY_GEOCODES
US cities and their VERTEX geocodes, used to validate US HR_S_US_CITY_NAMES
addresses.
HR_S_US_CITY_SCHOOL_DSTS
HR_S_US_CITY_TAX_INFO_F
Element definitions.
HR_S_US_COUNTY_TAX_INFO_F
Element definitions.
HR_S_US_FEDERAL_TAX_INFO_F
Element definitions.
HR_S_US_GARN_EXEMPTION_RULES_F
HR_S_US_GARN_FEE_RULES_F
HR_S_US_GARN_LIMIT_RULES_F
HR_S_US_STATE_TAX_INFO_F
Element definitions.
Valid zip code ranges for VERTEX cities, used to validate US HR_S_US_ZIP_CODES
addresses.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
10/30
11/01/2015
Apps Oracle HRMS Tables
HR_S_VALID_DEPENDENT_TYPES
Retrofitted
HR_S_WC_STATE_SURCHARGES
Retrofitted
HR_TAB_PAGE_PROPERTIES_B
Properties of tab pages for configurable forms
HR_TAB_PAGE_PROPERTIES_TL
Translated properties of tab pages for configurable forms
HR_TEMPLATE_CANVASES_B
Definition of canvases on template for configurable forms
HR_TEMPLATE_DATA_GROUPS
Definition for data group on template for configurable forms
HR_TEMPLATE_ITEMS_B
Definition of items on template for configurable forms
Definition of items on a template for given context, for HR_TEMPLATE_ITEM_CONTEXTS_B
configurable forms
Information about which tab pages item belongs to for a specific HR_TEMPLATE_ITEM_CONTEXT_PAGES
context, on template for configurable form.
Information about which tab pages item belongs to on template HR_TEMPLATE_ITEM_TAB_PAGES
for configurable form.
HR_TEMPLATE_TAB_PAGES_B
Definition of tab page for template, for configurable forms
HR_TEMPLATE_WINDOWS_B
Definition of window for a template, for configurable forms
HR_TIPS
Help components used within SSHR.
HR_WINDOW_PROPERTIES_B
Properties of windows for configurable forms
HR_WINDOW_PROPERTIES_TL
Translated properties of windows for configurable forms
HR_WIP_LOCKS
Stores context lock for a transaction
HR_WIP_TRANSACTIONS
Stores the transaction information and state
HR_WORKFLOWS
Taskflows in Oracle HRMS.
Holds a list of people who constitute a current list, used in HR_WORKING_PERSON_LISTS
the Line Manager Web pages
PER_ABSENCE_ATTENDANCES
Records of absence, or attendance for an employee.
This is a copy of the PER_ABSENCE_ATTENDANCES table http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
11/30
11/01/2015
Apps Oracle HRMS Tables
which is populated by the EFC ﴾Euro as Functional Currency﴿ PER_ABSENCE_ATTENDANCES_EFC
process.
PER_ABSENCE_ATTENDANCE_TYPES
defined absence types.
PER_ABS_ATTENDANCE_REASONS
Valid absence reasons for an absence type.
PER_ABS_ATTENDANCE_TYPES_TL
Holds translated information for Absence Types
PER_ADDRESSES
Address information for people.
PER_ALL_ASSIGNMENTS_F
Employee and applicant assignment details.
DateTracked table holding personal information for employees, PER_ALL_PEOPLE_F
applicants and other people.
PER_ALL_POSITIONS
Dualmaintained position definition information.
PER_ALL_VACANCIES
Vacancies within a specific requisition.
PER_ANALYSIS_CRITERIA
Flexfield combination table for the personal analysis key flexfield.
PER_APPLICATIONS
Applications for employment.
PER_APPRAISALS
An appraisal is a record of an evaluation of a person by others.
PER_APPRAISAL_TEMPLATES
The heading or grouping of appraisal questions.
PER_ASSESSMENTS
The grouping of a set of assessment elements.
PER_ASSESSMENT_GROUPS
Grouping of People for 360 reviews
PER_ASSESSMENT_TYPES
The definition of an assessment template
PER_ASSIGNMENT_BUDGET_VALUES_F
Budget values for an assignment.
This is a copy of the PER_ASSIGNMENT_BUDGET_VALUES_F table which is populated by the EFC ﴾Euro as Functional PER_ASSIGNMENT_BUDGET_VALU_EFC
Currency﴿ process.
PER_ASSIGNMENT_EXTRA_INFO
Extra information for an assignment.
This is a copy of the PER_ASSIGNMENT_EXTRA_INFO table which is populated by the EFC ﴾Euro as Functional Currency﴿ PER_ASSIGNMENT_EXTRA_INFO_EFC
process.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
12/30
11/01/2015
PER_ASSIGNMENT_INFO_TYPES
Apps Oracle HRMS Tables
Types of extra information that may be held against an assignment.
Translated types of extra information that may be held against an PER_ASSIGNMENT_INFO_TYPES_TL
assignment.
PER_ASSIGNMENT_LIST
List of assignments that a secure can access.
PER_ASSIGNMENT_STATUS_TYPES
Predefined and defined assignment status types.
PER_ASSIGNMENT_STATUS_TYPES_TL
Predefined and defined translated assignment status types.
PER_ASSIGN_PROPOSAL_ANSWERS
Web Candidate Offer Answers
PER_ASS_STATUS_TYPE_AMENDS
amendments to predefined assignment status types.
Translated amendments to predefined assignment status PER_ASS_STATUS_TYPE_AMENDS_TL
types.
Holds assignment level run amount and summary values for PER_BF_BALANCE_AMOUNTS
backfeed balances by payroll processing period
PER_BF_BALANCE_AMOUNTS_EFC
PER_BF_BALANCE_TYPES
Types of balances that can be held
PER_BF_BALANCE_TYPES_EFC
Holds details of payments that have been processed by a 3rd PER_BF_PAYMENT_DETAILS
party payroll provider, by assignment.
PER_BF_PAYMENT_DETAILS_EFC
PER_BF_PAYROLL_RUNS
Payrolls processed by 3rd party payroll provider.
Intersection table storing details of assignments that have been PER_BF_PROCESSED_ASSIGNMENTS
processed by a 3rd party payroll provider in each payroll run
PER_BOOKINGS
Event booking details.
PER_BUDGETS
Definitions of HR budgets.
Combinations of organization, grade, job, and position used to PER_BUDGET_ELEMENTS
define detailed budget values.
PER_BUDGET_VALUES
Planned HR budget values for specific budget elements.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
13/30
11/01/2015
Apps Oracle HRMS Tables
This is a copy of the PER_BUDGET_VALUES table which is PER_BUDGET_VALUES_EFC
populated by the EFC ﴾Euro as Functional Currency﴿ process.
PER_BUDGET_VERSIONS
Identifies specific versions of an HR budget.
PER_CAGR_APIS
PER_CAGR_APIS_TL
PER_CAGR_API_PARAMETERS
PER_CAGR_API_PARAMETERS_TL
PER_CAGR_COPY_LOG
PER_CAGR_ENTITLEMENTS
PER_CAGR_ENTITLEMENT_ITEMS
PER_CAGR_ENTITLEMENT_ITEMS_TL
PER_CAGR_ENTITLEMENT_LINES_F
PER_CAGR_ENTITLEMENT_RESULTS
The reference collectively agreed grades for a Collective PER_CAGR_GRADES
Agreement.
PER_CAGR_GRADES_DEF
Collective agreement grades key flexfield combinations table.
The valid collectively agreed grade key flexfield structures for a PER_CAGR_GRADE_STRUCTURES
particular collective agreement
PER_CAGR_LOG
PER_CAGR_REQUESTS
PER_CAGR_RETAINED_RIGHTS
PER_CALENDAR_ENTRIES
Calendar Entries
PER_CAL_ENTRY_GEO_LIST
Calendar Entry Geo Coverage Cache
PER_CAL_ENTRY_ORG_LIST
Calendar Entry Org Coverage Cache
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
14/30
11/01/2015
Apps Oracle HRMS Tables
PER_CAL_ENTRY_VALUES
Calendar Entry Values
PER_CAREER_PATHS
List of career paths for jobs.
PER_CAREER_PATH_ELEMENTS
Progression paths for specific jobs.
PER_CA_EE_REPORT_LINES
PER_CHECKLIST_ITEMS
Checklist information.
Details of a benefit that the employee accepts or rejects as part of PER_COBRA_COVERAGE_BENEFITS_F
their COBRA coverage.
PER_COBRA_COVERAGE_PERIODS
Holds coverage periods for COBRA qualifying events.
PER_COBRA_COVERAGE_STATUSES
Tracks the status of a COBRA enrollment.
Enrollments for people who are eligible for continued benefit PER_COBRA_COV_ENROLLMENTS
coverage under COBRA.
Holds employee dependents coverage for a COBRA qualifying PER_COBRA_DEPENDENTS_F
event.
Events that have meaning in the context of COBRA coverage, PER_COBRA_QFYING_EVENTS_F
e.g. Divorce, Termination, Death etc.
PER_COLLECTIVE_AGREEMENTS
Collective agreement information.
A competence is a definition of knowledge, skills, abilities or other PER_COMPETENCES
charactaristics that a person may possess.
PER_COMPETENCES_TL
This table is used for language translations
PER_COMPETENCE_DEFINITIONS
COMPETENCES Key flexfield combinations table
A competence element is used to record an individual PER_COMPETENCE_ELEMENTS
competence and an evaluation rating.
PER_COMPETENCE_OUTCOMES
Competence outcomes
PER_COMP_ELEMENT_OUTCOMES
The outcomes achieved towards a given Competency .
PER__EXTRA_INFO_F
Extra information for a relationship.
Types of extra information that may be held against a PER__INFO_TYPES
relationship.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
15/30
11/01/2015
Apps Oracle HRMS Tables
Translated types of extra information that may be held against a PER__INFO_TYPES_TL
relationship.
s and relationship details for dependents, beneficiaries, PER__RELATIONSHIPS
emergency s, parents etc.
PER_CONTRACTS_F
The details of a persons contract of employment
Used to log errors / warnings during the conversion of PER_N_DATA_UPGRADE
competences to a key flex structure.
A factor affecting a person's capacity to be deployed within an PER_DEPLOYMENT_FACTORS
organization.
PER_DISABILITIES_F
Hold Disability information for one person
PER_ELECTIONS
Holds election related information.
PER_ELECTION_CANDIDATES
Holds information of Election candidates.
This table holds information related to constituencies participating PER_ELECTION_CONSTITUENCYS
in the election.
PER_EMPDIR_ASSIGNMENTS
PER_EMPDIR_JOBS
PER_EMPDIR_LOCATIONS
PER_EMPDIR_LOCATIONS_TL
PER_EMPDIR_ORGANIZATIONS
PER_EMPDIR_PEOPLE
PER_EMPDIR_PHONES
PER_EMPDIR_POSITIONS
This entity is used to maintain a list of educational PER_ESTABLISHMENTS
establishments e.g. schools, colleges, universities, etc.
A record of educational establishments that a person is currently PER_ESTABLISHMENT_ATTENDANCES
attending or has previously attended.
Record of events such as interviews and appraisals for applicants http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
16/30
11/01/2015
PER_EVENTS
Apps Oracle HRMS Tables
and employees.
Navigation and person change information for the Enter Person PER_FORM_FUNCTIONS
information screens.
Text lines for output by a generic report script, including: title, PER_GENERIC_REPORT_OUTPUT
header, footer and body lines.
PER_GEN_HIERARCHY
PER_GEN_HIERARCHY_NODES
PER_GEN_HIERARCHY_VERSIONS
PER_GEN_HIER_NODE_TYPES
PER_GRADES
Grade definitions for a business group.
PER_GRADES_TL
Trnslated fields for per_grades
PER_GRADE_DEFINITIONS
Grade key flexfield combinations table.
PER_GRADE_SPINES_F
Stores the progression points for each grade scale.
PER_HEADCOUNT_PORTLET_TBL
PER_HTML_TOOLKIT_REC_TYPES
Default values for the HR html toolkit.
PER_IMAGES
Images for a designated row in a designated table.
Cross table between Responsibilty and Info_type tables, used to PER_INFO_TYPE_SECURITY
secure info types based on responsibility.
PER_JOBS
Jobs defined for a Business Group.
PER_JOBS_TL
Translated columns for per_jobs
PER_JOB_DEFINITIONS
Job key flexfield combinations table.
PER_JOB_EVALUATIONS
Job evaluation details for specific jobs or positions.
PER_JOB_EXTRA_INFO
Extra information for a job.
Holds Job Group Information. Each Job will be a member of a Job Group and a Job Group can optionally be within a business PER_JOB_GROUPS
group.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
17/30
11/01/2015
PER_JOB_INFO_TYPES
Apps Oracle HRMS Tables
Types of extra information that may be held against a job.
Requirements for specific jobs or positions. For example, skills, PER_JOB_REQUIREMENTS
qualifications, experience, training.
PER_JP_ADDRESS_LOOKUPS
Lookups for Japanese Addresses
PER_JP_BANK_LOOKUPS
Lookups for Japanese Bank Branches
PER_JP_POSTAL_CODES
Lookups for Japanese postal codes and districts
PER_JP_SCHOOL_LOOKUPS
Lookups for Japanese Educational Institutions
PER_KR_ADDRESSES
KR specific
PER_KR_GRADES
KR specific
PER_KR_GRADE_AMOUNT_F
KR specific
PER_KR_G_POINTS
KR specific
PER_KR_G_POINT_AMOUNT_F
KR specific
Associations between letter types and possible status type PER_LETTER_GEN_STATUSES
changes.
PER_LETTER_REQUESTS
Requests for specific types of standard letter.
PER_LETTER_REQUEST_LINES
Details of individual letter requests.
PER_LETTER_TYPES
Letter types and autorequest definitions.
PER_MASS_MOVES
High level mass move definition.
PER_MEDICAL_ASSESSMENTS
Hold Medical Assessment information for one person
PER_MM_ASSIGNMENTS holds assignments that were defined PER_MM_ASSIGNMENTS
as part of a mass move.
PER_MM_JOB_REQUIREMENTS holds data related to PER_MM_JOB_REQUIREMENTS
transferring position requirements to a newly created position.
PER_MM_POSITIONS holds positions that were defined as part PER_MM_POSITIONS
of a mass move.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
18/30
11/01/2015
PER_MM_VALID_GRADES
Apps Oracle HRMS Tables
PER_MM_VALID_GRADES holds valid grades that will be moved with a position during a mass move.
PER_NL_ABSENCE_ACTIONS
Dutch Specific Absence Actions
PER_NL_ABSENCE_CHANGES
Dutch Specific Absence Changes
Records the Dutch Assignment SCL Context Information PER_NL_ASG_SCL_UPGRADE
Migrated used by the Report
PER_NUMBER_GENERATION_CONTROLS holds the numbers PER_NUMBER_GENERATION_CONTROLS
that are automatically generated for a Business Group.
PER_OBJECTIVES
A target or goal which may be evaluated during an appraisal.
PER_ORGANIZATION_LIST
List of organizations that a secure can access.
PER_ORGANIZATION_STRUCTURES
Organization hierarchy names.
Organization hierarchy details showing parentchild reporting PER_ORG_STRUCTURE_ELEMENTS
relationships between organizations.
PER_ORG_STRUCTURE_VERSIONS
Version control information for specific organization hierarchies.
PER_PARENT_SPINES
Details of pay scales, ﴾previously known as parent spines﴿.
PER_PARTICIPANTS
A person participating in an appraisal or assessment.
PER_PAY_BASES
Definitions of specific salary bases.
Salary proposals and performance review information for PER_PAY_PROPOSALS
employee assignments.
This is a copy of the PER_PAY_PROPOSALS table which is PER_PAY_PROPOSALS_EFC
populated by the EFC ﴾Euro as Functional Currency﴿ process.
Component details of a pay proposal for an employee PER_PAY_PROPOSAL_COMPONENTS
assignment.
This is a copy of the PER_PAY_PROPOSAL_COMPONENT table which is populated by the EFC ﴾Euro as Functional PER_PAY_PROPOSAL_COMPONENT_EFC
Currency﴿ process.
PER_PAY_PROPOSAL_COMPONENT_EFC
PER_PEOPLE_EXTRA_INFO
Extra information for a person.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
19/30
11/01/2015
Apps Oracle HRMS Tables
The table holds the definitions of extra information types that may PER_PEOPLE_INFO_TYPES
be held against a person.
PER_PERFORMANCE_RATINGS
A single evaluation of an objective.
PER_PERFORMANCE_REVIEWS
Performance review information for employees.
PER_PERIODS_OF_PLACEMENT
Periods of placement details for a nonpayrolled worker
PER_PERIODS_OF_SERVICE
Period of service details for an employee.
This is a copy of the PER_PERIODS_OF_SERVICE table which PER_PERIODS_OF_SERVICE_EFC
is populated by the EFC ﴾Euro as Functional Currency﴿ process.
PER_PERSON_ANALYSES
Special information types for a person.
PER_PERSON_DLVRY_METHODS
The communication delivery method for a person.
PER_PERSON_LIST
List of people that a secure can access.
List of people that are to be added to current PER_PERSON_LIST_CHANGES
PER_PERSON_LIST.
Archive table to hold content of PER_PERSON_LIST_CHANGES PER_PERSON_LIST_CHG_ARCH
on upgrade.
PER_PERSON_TYPES
Person types visible to specific Business Groups.
PER_PERSON_TYPES_TL
Translated person types information.
PER_PERSON_TYPE_USAGES_F
Identifies the types a person may be.
PER_PHONES holds phone numbers for current and ex PER_PHONES
employees, current and exapplicants and employee s.
PER_POSITION_DEFINITIONS
Combinations of segments stored in the PER_POSTIONS table.
PER_POSITION_EXTRA_INFO
Extra information for a position.
PER_POSITION_INFO_TYPES
Types of extra information that may be held against a position.
PER_POSITION_LIST
List of positions that a secure can access.
PER_POSITION_STRUCTURES
Position Hierarchy names.
Position hierarchy details showing parentchild reporting http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
20/30
11/01/2015
Apps Oracle HRMS Tables
PER_POS_STRUCTURE_ELEMENTS
relationships between positions.
PER_POS_STRUCTURE_VERSIONS
Version control information for specific position hierarchies.
PER_PREVIOUS_EMPLOYERS
PER_PREVIOUS_JOBS
Used to store Previous Jobs
PER_PREVIOUS_JOB_EXTRA_INFO
Previous Jobs extra info
PER_PREVIOUS_JOB_INFO_TYPES
Used to store previous job info types
PER_PREVIOUS_JOB_USAGES
Used to store previous job Usages
PER_PREV_JOB_EXTRA_INFO
Previous Jobs extra info
PER_PREV_JOB_INFO_TYPES
Used to store previous job info types
PER_PROPOSAL_CATEGORY_
Web Offers profile categories of questions
PER_PROPOSAL_CATEGORY_TYPES
Generic web offer category definitions
PER_PROPOSAL_OFFER_PARAGRAPHS
Web Offer letter text
PER_PROPOSAL_QUESTIONS_ADV
Web Offer advanced questions
PER_PROPOSAL_QUESTION_
Web offer profile questions
PER_PROPOSAL_QUESTION_TYPES
Generic web offer questions
PER_PROPOSAL_TEMPLATES
Retrofitted
Table for storing DFF migration mapping Information from PER_PTU_DFF_MAPPING_HEADERS
PER_ALL_PEOPLE_F to PER_PERSON_TYPE_USAGES_F.
Table for storing DFF migration mapping Information from PER_PTU_DFF_MAPPING_LINES
PER_ALL_PEOPLE_F to PER_PERSON_TYPE_USAGES_F.
This table is used to store the details of the person records failed to migrate to PER_PERSON_TYPE_USAGES_F from PER_PTU_DFF_MIG_FAILED_PEOPLE
PER_ALL_PEOPLE_F.
A record of educational qualification, certificates, licenses, etc PER_QUALIFICATIONS
that a person holds or is acquiring.
This is a copy of the PER_QUALIFICATIONS table which is http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
21/30
11/01/2015
Apps Oracle HRMS Tables
PER_QUALIFICATIONS_EFC
populated by the EFC ﴾Euro as Functional Currency﴿ process.
PER_QUALIFICATIONS_TL
Translated qualification details.
PER_QUALIFICATION_TYPES
Maintains the list of qualiification types that can be attained.
PER_QUALIFICATION_TYPES_TL
Maintains the list of qualiification type translations
PER_QUERY_CRITERIA
Used to store criteria to build up a query
PER_QUICKPAINT_INVOCATIONS
Identifies QuickPaint report runs.
PER_QUICKPAINT_RESULT_TEXT
Text description for the result of a single QuickPaint run.
A rating scale step is a single point on a rating scale and is used PER_RATING_LEVELS
to rate competences.
A rating scale step is a single point on a rating scale and is used PER_RATING_LEVELS_TL
to rate competences.
PER_RATING_SCALES
A scale used to rate compentencies.
PER_RATING_SCALES_TL
Translated rating scale name and description.
PER_RECRUITMENT_ACTIVITIES
Recruitment activities and costs.
This is a copy of the PER_RECRUITMENT_ACTIVITIES table which is populated by the EFC ﴾Euro as Functional Currency﴿ PER_RECRUITMENT_ACTIVITIES_EFC
process.
PER_RECRUITMENT_ACTIVITY_FOR
Vacancies associated with a specific recruitment activity.
PER_REQUISITIONS
Vacancy requisition details.
PER_RI_DEPENDENCIES
Dependencies among Workbench tasks
PER_RI_REQUESTS
Concurrent requests for workbench componenets
PER_RI_SETUP_SUB_TASKS
Workbench setup subtasks
PER_RI_SETUP_SUB_TASKS_TL
TL table for PER_RI_SETUP_SUB_TASKS
PER_RI_SETUP_TASKS
Workbench Setup Tasks
PER_RI_SETUP_TASKS_TL
TL table for PER_RI_SETUP_TASKS table
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
22/30
11/01/2015
Apps Oracle HRMS Tables
PER_RI_VIEW_REPORTS
Stores data related to view reports for HRMS
PER_RI_VIEW_REPORTS_TL
Workbench View Reports Translation Table
PER_RI_WORKBENCH_ITEMS
Workbench items
PER_RI_WORKBENCH_ITEMS_TL
Translation table for Per_ri_workbench_items
PER_ROLES
Holds the different roles that a person performs.
PER_SALARY_SURVEYS
Market salary survey information.
PER_SALARY_SURVEY_LINES
Details for market salary surveys.
This is a copy of the PER_SALARY_SURVEY_LINES table which is populated by the EFC ﴾Euro as Functional Currency﴿ PER_SALARY_SURVEY_LINES_EFC
process.
PER_SALARY_SURVEY_MAPPINGS
Mapping information for a salary survey line.
PER_SCHED_COBRA_PAYMENTS
Payment schedules for benefits provided by a COBRA coverage.
Secondary assignment statuses used for information and PER_SECONDARY_ASS_STATUSES
reporting.
List of organizations to include or exclude from PER_SECURITY_ORGANIZATIONS
security list
Security profile definitions to restrict access to specific PER_SECURITY_PROFILES
HRMS records.
List of s for a security profile whose access permissions will PER_SECURITY_S
be stored in static lists duringSecurity List Maintenance.
Security profile assignments for , Responsibility and PER_SEC_PROFILE_ASSIGNMENTS
Business Group.
PER_SHARED_TYPES
Holds 'type' and 'status' information.
PER_SHARED_TYPES_TL
Translated information for shared types.
PER_SPECIAL_INFO_TYPES
Special information types available to a Business Group.
PER_SPECIAL_INFO_TYPE_USAGES
Limits usage of special information types to specific windows.
PER_SPINAL_POINTS
List of progression points in a pay scale.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
23/30
11/01/2015
PER_SPINAL_POINT_PLACEMENTS_F
Apps Oracle HRMS Tables
Details of assignment placements to a grade step and point.
Grade steps defined in a specific grade scale and their PER_SPINAL_POINT_STEPS_F
incremental order.
PER_STANDARD_HOLIDAYS
Statutory Holiday information.
PER_STARTUP_PERSON_TYPES_TL
Predefined list of translated person types.
PER_STD_HOLIDAY_ABSENCES
Records when Statutory Holidays are taken.
PER_SUBJECTS_TAKEN
Holds a record of a person's subject usages for a qualification
PER_SUBJECTS_TAKEN_TL
Translated grade_attained.
PER_SUCCESSION_PLANNING
The record of a person's proposed succession to a position.
Time period definitions for payroll processing and HR budget PER_TIME_PERIODS
calendars.
PER_TIME_PERIOD_RULES
Rules for time periods used by the system.
PER_TIME_PERIOD_SETS
Specific dates for a defined calendar.
Predefined list of valid period types for payroll and HR budget PER_TIME_PERIOD_TYPES
calendars.
Predefined list of translated period types for payroll and HR PER_TIME_PERIOD_TYPES_TL
budget calendars.
PER_US_INVAL_ADDRESSES
Temporary table used to hold invalid addresses.
PER_US_INVAL_LOCATIONS
Temporary table used to hold invalid location addresses.
PER_VALID_GRADES
Lists valid grades for jobs and positions.
Holds information on Incidents that happen at work or en route to PER_WORK_INCIDENTS
work, for example, an industrial accident
This is a copy of the PER_WORK_INCIDENTS table which is PER_WORK_INCIDENTS_EFC
populated by the EFC ﴾Euro as Functional Currency﴿ process.
PER_ZA_AREAS_OF_ASSESSMENT
Table to store the Areas of assessment per NQF Assessment
PER_ZA_ASSESSMENTS
Table to store the NQF Assessment info for a person
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
24/30
11/01/2015
Apps Oracle HRMS Tables
PER_ZA_EMPLOYMENT_EQUITY
Temporary table for Employment Equity Reporting
PER_ZA_FORMAL_QUALIFICATIONS
Table to store additional NQF Qualification info for a person
Table to store the NQF learnership agreement info between a PER_ZA_LEARNERSHIP_AGREEMENTS
person and the organization
PER_ZA_QUALIFICATION_TYPES
Table to link qualification types ﴾titles﴿ to NQF qualification types
PER_ZA_TRAINING
Table to store NQF Training info for a person
Comments (15) Subscribe to this comment's feed
... written by Florin Barbalau , February 09, 2007 Hi Anil, I was looking on the way security profiles work and there is no table such as PER_SECURITY_S in my implementation of oracle apps altough I found it on eTrm on metalink. Did you had this situation before ? We use : Oracle Applications : 11.5.9 thanks,
... written by Anil i , February 10, 2007 Hi Florin, This table exists in 11.5.10 with following columns. Possibly this is a new addition to 11.5.10 DEV11510>>desc PER_SECURITY_S Name SECURITY__ID SECURITY_PROFILE_ID _ID OBJECT_VERSION_NUMBER LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_ CREATED_BY CREATION_DATE Thanks, Anil i
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
25/30
11/01/2015
Apps Oracle HRMS Tables
... written by Aravind , April 10, 2007 Hi Anil, We have upgraded from oracle 11.5.9 to 11.5.10.The address form﴾People>enter and Maintain﴿ in 11.5.9 is PERWSADR and it is PERACADR in 11.5.10. Can we say it is because of the upgrade.how to check this form is changed because of upgrade. Thanks in advance. Aravind M
... written by Anil i , April 14, 2007 Usually DBAs create a frozen environment of preupgrade instance. you may ask your DbAs to check there in fnd_form_functions_vl Thanks, Anil i
... written by Anil i , June 15, 2007 Hi Hari Per_ALL_PEOPLE_F is the right table. Try this... select * from per_all_people_f where creation_date > sysdate 2 ; this will return all the records created during last two days. Before you do that, can you query the record back from the screen? You need to be 100% certain that the record got saved in the DB. Thanks, Anil i
... written by Saurabh.s , September 07, 2007 HI ,Anil. again great effort from your side.your site is giving me a lot of knowledge in each n every way .Here i like to ask one thing ,wheather I am not very sure I am rite or not. but can you provide some list of queries which generally we use to develop any report or any form .I am giving you a example for that may be my point will be clear ,just like previous you have send one query which will" return all the records created during last two days" select * from per_all_people_f where creation_date > sysdate 2 ; like this if you can send us some more query then that will be really great help from your side. Thankx & Regards Saurabh Srivastava
... written by Anil i , September 07, 2007 Hi Hari
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
26/30
11/01/2015
Apps Oracle HRMS Tables
Please see http://oracle.anili.com/or...ables.html Thanks, Anil i
Multiple assignments in Self Service Time Sheet written by Gupta Nagubandi , October 10, 2007 Hi Anil, Your website is really very helpful, thnx for all your efforts. The Self Service Time sheet that is available in OTL, does not allow the to fill the time for multiple assigments if the employee is assigned to more than one assignment. The client wants us to implement the solution so that the employees should be allowed to fill the time entry for multiple assignments. Could you please share your ideas on how to achieve this? Best Regards, Gupta
Urgent help required in DFF segments custom validation written by Lakshman Kalisetti , October 11, 2007 Hi Anil, We need your expert guidence in implementing address validation in Oracle R12 HRMS form "PERACADR.fmb" In this form person address is captured using the standard DFF "Personal Address Information". This DFF is context sensitive. Address Type is the reference field. In case of address types US and CAN, we need to have our customized validation on the segments like City, State, Country, Zip Code. All the segments are attached with oracle supplied value sets. In our case, while populating the list of values for any of the above four segments, we need to consider the remaining three segments. Based on those three segments we need to do some validations and populate the list with valid data only. We tried below steps to implement this... 1. Create new value sets based on our custom tables and assign them to all four segments. 2. Write KeyListval trigger on all the four segments with following code... a﴿ call our custom procedures to populate the custom tables with valid values b﴿ populate the LOV using list_values But after implementing the above changes, we identified that none of our triggers on DFF segments are getting executed. We tried some other possiblities also, but could not make it. Could you please provide us your expert guidence on this. Your earliest reply would be highly appreciated.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
27/30
11/01/2015
Apps Oracle HRMS Tables
Thanks in advance, Lucky
Hi, Whenever tries to see the list of values for any segment, data should be populated in our custom tables which are used in value set. So this is a an frontend item level action, which cannot be done using backend triggers. Please let us know, if you have any other inputs. Thanks, Lucky
IT Analyst written by Zain Rehan , October 30, 2007 Hey Anil, I was wondering if you can guide me to understanding Oracle HRMS field interdependencies? Does Oracle or any other source offers any tools or mappings as such? For example, there might be an inter dependency between 'City' and 'Country' fields. Looking at some masking solutions and thus wanted to make sure we cover all integrity and data relationship issues. Your guidance would be greatly appreciated. Many thanks,
... written by Anil i , October 30, 2007 Hi Zain Depending upon your business requirements, you can use CUSTOM.pll or API Hooks or Personalizations to achieve your requirement. Also check Metalink if there exists a localization patch for the specific country address for validations. Thanks, Anil i
OTL workflow shows wrong information in FYI notification to the Employee who enters time sheet written by Prasad Kumar , January 08, 2008 Iam "A" entering time sheet, it is approved by my manager "B", I have set vacation rule to delegate my notifications to my friend "C" , "C" gets the notification , but the action history shows that some other person 'D" has approved my time sheet, can I know how to debug this, Iam using 11.5.9 , Example "A" Feil, Mrs. Phyllis Jan http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
28/30
11/01/2015
Apps Oracle HRMS Tables
"B" Uran, Mr. D Mark ﴾Mark﴿ "C" Huynh, Ms. Thuy Ngoc Thanh ﴾Tiffany﴿ "D" Ahnberg, Mr. Donald Searle ﴾Don﴿ Not related to any one in the list...
FYI: Uran, Mr. D Mark ﴾Mark﴿ approved timecard for period 11NOV07 to 17NOV07, 46 Total Hours ﴾Timecard Num: 671416 ﴿ From Feil, Mrs. Phyllis Jan To Huynh, Ms. Thuy Ngoc Thanh ﴾Tiffany﴿ Sent 16NOV2007 13:18:15 ID 1792503
Feil, Mrs. Phyllis Jan, This timecard has been approved :
Timecard Details Project Number Project Name Task Number Task Name Type Hour Type Date Day Hours Comments ITFINANCE ITFINANCE 1.01 NON ERP HOUR NON ERP HOUR PSLabor Worked Hours 12Nov07 Mon 11 ITERP2 QUOTE TO CASH ERP PHASE2 QUOTE TO CASH 8.00 Project Project PSLabor Worked Hours 13Nov07 Tue 1 ITFINANCE ITFINANCE 1.01 NON ERP HOUR NON ERP HOUR PSLabor Worked Hours 13Nov07 Tue 10 ITFINANCE ITFINANCE 1.01 NON ERP HOUR NON ERP HOUR PSLabor Worked Hours 14Nov07 Wed 5 ITERP2 QUOTE TO CASH ERP PHASE2 QUOTE TO CASH 8.00 Project Project PSLabor Worked Hours 14Nov07 Wed 4 ITFINANCE ITFINANCE 1.01 NON ERP HOUR NON ERP HOUR PSLabor Worked Hours 15Nov07 Thu 10 ITFINANCE ITFINANCE 1.01 NON ERP HOUR NON ERP HOUR PSLabor Worked Hours 16Nov07 Fri 5
Timecard Link Action History Num Action Date Action From To Details 1 16NOV2007 13:18:15 Submit Ahnberg, Mr. Donald Searle ﴾Don﴿ Feil, Mrs. Phyllis Jan 2 16NOV2007 13:18:15 Delegate Feil, Mrs. Phyllis Jan Huynh, Ms. Thuy Ngoc Thanh ﴾Tiffany﴿
... written by Nancy , February 02, 2008 Hey Anil, Could u please show ER Diagram of Oracle HRMS?? Nancy
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
29/30
11/01/2015
Apps Oracle HRMS Tables
SET UP for UAE localisation written by Naren , February 06, 2008 Hi Anil, This is my first mail to you. Am looking for any document related to Oracle HR and payroll set up of UAE localisation. Kindly help me Thanks Naren
HRMS written by karima , February 20, 2008 HI Anil This is my first post Have any hint to change UK to Sadui legislation without creating new business group and data migration Thanks Abdul
You must be logged in to a comment. Please if you do not have an yet.
Close Window
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
30/30
Apps Oracle HRMS Tables
Oracle HRMS Tables
| Print |
Written by Anil i Saturday, 20 January 2007 Please find a list of Oracle HRMS Tables, with a brief description. You can also get the most uptodate list from FND_TABLES Oracle HRMS Table Name
Table Description
HR_ALL_ORGANIZATION_UNITS
Organization unit definitions.
HR_ALL_ORGANIZATION_UNITS_TL
Translated organization unit name definitions.
HR_ALL_POSITIONS_F
Position definition information.
HR_ALL_POSITIONS_F_TL
Translation table
HR_API_BATCH_MESSAGE_LINES
Results and messages generated during batch API processing.
HR_API_HOOKS
Lists the hook points which are available in each API module.
Lists which extra logic, package procedures or formula, should be HR_API_HOOK_CALLS
called from the API hook points.
HR_API_MODULES
Holds details of the business processes and row handlers.
HR_API_TRANSACTIONS
Kiosk processes in progress
HR_API_TRANSACTION_STEPS
Kiosk workflow data rows
HR_API_TRANSACTION_VALUES
Kiosk workflow data columns and values
Used to hold HR_API__HOOK error information if this HR_API__HOOK_REPORTS
exists otherwise no information is held.
HR_ASSIGNMENT_SETS
Formula definitions that identify sets of assignments.
HR_ASSIGNMENT_SET_AMENDMENTS
Identifies explicit include and exclude rules for an assignment set.
HR_ASSIGNMENT_SET_CRITERIA
Identifies individual criteria in the definition of an assignment set.
HR_ATH_ELIGIBLE_TBLS
This table contains ODBC connectivity information for the HR_ATH_ENROLL_TBLS
Authoria enrolled plans table﴾s﴿.
HR_ATH_VARIABLEMAP
Variable mappings table for the Authoria Integration
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
1/30
11/01/2015
Apps Oracle HRMS Tables
HR_AUTHORIA_MAPPINGS
Authoria Mapping Information
HR_CALENDARS
Dated instances of a repeating pattern.
HR_CALENDAR_USAGES
Assignments of calendars to individual entities.
HR_CANVAS_PROPERTIES
Canvas properties for configurable forms
HR_COMMENTS
Central repository for comments.
Holds Liability Insurance Providers rates for the HR_DE_LIABILITY_S_F
Organization
HR_DE_ORGANIZATION_LINKS
Holds extra information for Organizations links with External Orgs
HR_DE_SOC_INS_CONTR_LVLS_F
Holds German Social Insurance Contibution data
HR_DM_APPLICATION_GROUPS
Data Migrator locking ladder groups for applications.
HR_DM_COLUMN_DEFINITIONS
Column definitions for sequence range management
HR_DM_DATABASES
Table containing names of all databases within database farm
This table holds the information for the deletion of date tracked data. This table is also used to hold participant data information HR_DM_DT_DELETES
of data that has been ed but not been ed.
This table holds the data from various tables in the source database that will be moved to the destination database using the HR_DM_EXP_IMPS
transportable tablespace for in the destination database
This table holds information about the groupings used in the data HR_DM_GROUPS
migration process.
This entity will contain the relationships between tables. The HR_DM_HIERARCHIES
following relationship will be recorded:
HR_DM_LOADER_PARAMS
This entity contains the configuration data for the AOL loader files
This entity contains the migration specific configuration data for HR_DM_LOADER_PHASE_ITEMS
the AOL loader files.
This table contains the data migration information. There is one HR_DM_MIGRATIONS
row per migration in progress.
This table holds the allocated ranges for each slave process to http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
2/30
11/01/2015
Apps Oracle HRMS Tables
process during each Application/Participant data HR_DM_MIGRATION_RANGES
phase of the migration.
This table holds the information about the request id of the HR_DM_MIGRATION_REQUESTS
issuing concurrent program.
This table holds the information about each phase of the HR_DM_PHASES
migration process.
This table details the work to be undertaken for each phase of the HR_DM_PHASE_ITEMS
Data Migrator.
This table contains the rules governing which phases apply to HR_DM_PHASE_RULES
which migrations.
This entity contains the values of the primary key for both the source and destination database for each table for use by the HR_DM_RESOLVE_PKS
TUPS package.
Table containing Sequence Name information for the HR_DM_SEQUENCE_DEFINITIONS
PER/PAY/DT/FF/OTA/SSP/GHR/HXT/BEN applications.
Table containing sequence information from the different Fidelity databases. To be updated before any changes to sequences are HR_DM_SEQUENCE_HISTORIES
made to enable sequence history tracking.
Table containing Sequence Ranges for particular Sequence and Database. This table can hold multiple Ranges for a given HR_DM_SEQUENCE_RANGES
Sequence and Database.
This entity contains a HRMS table listing that will be processed by HR_DM_TABLES
the data migrator.
HR_DM_TABLE_GROUPINGS
This entity holds the information for the grouping of tables.
HR_DOCUMENT_EXTRA_INFO
Documents of Record Information
HR_DOCUMENT_TYPES
Document Types for Documents od Record
HR_DOCUMENT_TYPES_TL
Translated Document Types for Documents of Record
This table holds the relationship between the column name used in the source object ﴾e.g. the spreadsheet column﴿ and the output HR_DU_COLUMN_MAPPINGS
target ﴾e.g. the Data Pump parameter name﴿.
This table holds the descriptor details for each API to be HR_DU_DESCRIPTORS
ed.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
3/30
11/01/2015
Apps Oracle HRMS Tables
This table holds details about errors encountered during HR_DU_ERRORS
processing of a batch by any of the Data er modules.
This table holds the details about each module which can be HR_DU_MODULES
used for either input, process or output with in the data er.
This table holds the data relating to information ed from a HR_DU_S
single source file.
HR_DU__HEADERS
This table holds the details for each API to be ed.
This table holds the details for each item to be ed with an HR_DU__LINES
item spanning one or more rows
Contains one row for each time the EFC conversion process or HR_EFC_ACTIONS
delete _EFC table data process is run.
Contains one row per NCU currency as defined in FND_CURRENCIES at the time of the EFC processing with HR_EFC_CURRENCY_HISTORIES
details of the NCU.
Holds one row for each processing script in each conversion HR_EFC_PROCESS_COMPONENTS
processing run.
Holds one row for each time a rounding error adjustment has HR_EFC_ROUNDING_ERRORS
been made.
Holds one row for each parallel worker instance of a processing HR_EFC_WORKERS
component.
Holds one row for each HR_EFC_WORKER row per currency HR_EFC_WORKER_AUDITS
code processed for update scripts only.
HR_EXCEPTION_USAGES
Identifies usage of defined exceptions to a repeating pattern.
HR_FORM_CANVASES_B
Canvas definition for configurable forms
HR_FORM_CANVASES_TL
Translated canvas definitions for configurable forms.
HR_FORM_DATA_GROUPS_B
Form data group definition for configurable forms
HR_FORM_DATA_GROUPS_TL
Translated form data group definitions for configurable forms
HR_FORM_DATA_GROUP_ITEMS
Links items with data groups for configurable forms
HR_FORM_ITEMS_B
Definition of items available for configurable forms
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
4/30
11/01/2015
Apps Oracle HRMS Tables
HR_FORM_ITEMS_TL
Translated definitions of form items for configurable forms
HR_FORM_PROPERTIES
Configurable properties for configurable forms modules
HR_FORM_TAB_PAGES_B
Definition of form tab page for configurable forms
HR_FORM_TAB_PAGES_TL
Translated definition of form tab page for configurable forms
HR_FORM_TAB_STACKED_CANVASES
Definition of stacked canvas for tab pages in configurable forms
HR_FORM_TEMPLATES_B
Definition of template used by configurable forms
HR_FORM_TEMPLATES_TL
Translated template definition for use in configurable forms
HR_FORM_WINDOWS_B
Definition of windows for use in configurable forms
HR_FORM_WINDOWS_TL
Translated definition of windows for configurable form
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to addresses while data is HR_H2PI_ADDRESSES
in progress.
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to assignments while data HR_H2PI_ASSIGNMENTS
is in progress.
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to bg_and_gre while data HR_H2PI_BG_AND_GRE
is in progress.
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to us employees city tax rules HR_H2PI_CITY_TAX_RULES
while data is in progress.
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to cost allocations s while data HR_H2PI_COST_ALLOCATIONS
is in progress.
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to us employee county tax rules HR_H2PI_COUNTY_TAX_RULES
while data is in progress.
This table stores information about date feed history for Oracle HR_H2PI_DATA_FEED_HIST
HR to Oracle Payroll Interface ﴾H2PI﴿.
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to element entries while data HR_H2PI_ELEMENT_ENTRIES
is in progress.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
5/30
11/01/2015
Apps Oracle HRMS Tables
HR_H2PI_ELEMENT_ENTRY_VALUES
HR_H2PI_ELEMENT_LINKS
HR_H2PI_ELEMENT_NAMES
HR_H2PI_ELEMENT_TYPES
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to employees while data is HR_H2PI_EMPLOYEES
in progress.
HR_H2PI_FEDERAL_TAX_RULES
HR_H2PI_HR_ORGANIZATIONS
This table stores information about ID mapping for Oracle HR to HR_H2PI_ID_MAPPING
Oracle Payroll Interface ﴾H2PI﴿.
HR_H2PI_INPUT_VALUES
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to locations while data is HR_H2PI_LOCATIONS
in progress.
This table stores information about all the messages for Oracle HR_H2PI_MESSAGE_LINES
HR to Oracle Payroll Interface ﴾H2PI﴿.
HR_H2PI_ORGANIZATION_CLASS
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to organization info while data HR_H2PI_ORGANIZATION_INFO
is in progress.
HR_H2PI_ORG_PAYMENT_METHODS
HR_H2PI_PATCH_STATUS
HR_H2PI_PAYMENT_METHODS
HR_H2PI_PAYROLLS
HR_H2PI_PAY_BASES
HR_H2PI_PERIODS_OF_SERVICE
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
6/30
11/01/2015
Apps Oracle HRMS Tables
HR_H2PI_SALARIES
HR_H2PI_STATE_TAX_RULES
HR_H2PI_US_CITY_NAMES
This is staging table for the Oracle HR to Oracle Payroll Interface ﴾H2PI﴿ and stores data related to US midified geocodes while HR_H2PI_US_MODIFIED_GEOCODES
data is in progress.
HR_INCOMPATIBILITY_RULES
Incompatibility rules for navigation units.
HR_ITEM_CONTEXTS
Combinations table for the item context key flexfield ICX
HR_ITEM_PROPERTIES_B
Properties for form or template items used by configurable forms.
HR_ITEM_PROPERTIES_TL
Translatable properties of items for configurable forms
This table holds unique id for Japanese legislative specific data in order not to hardcode Multibyte characters in Japanese HR_JP_PARAMETERS
localization code objects.
This table holds the details of the KI integration external HR_KI_EXT_APPLICATIONS
applications
HR_KI_SESSIONS
Information about an instance of a SelfService Interface HR_LAYOUTS
configuration.
HR_LAYOUTS_TL
Translation table for HR_LAYOUTS.
Set of Interface Components used within a configurable HR_LAYOUT_COMPONENTS
SelfService layout.
Definitions of the set of Interface components that can be HR_LAYOUT_COMP_DEFINITIONS
used within a configurable Self Service Interface Layout.
Set of prompt codes associated with a Configurable UI Layout HR_LAYOUT_COMP_PROMPTS
Component
Set of layout qualifiers which can be used to modify the rendering HR_LAYOUT_COMP_QUALIFIERS
of a Self Service Interface component.
Set of rules that determine whether a Self Service Interface HR_LAYOUT_COMP_QUAL_RULES
component can use a particular layout qualifier.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
7/30
11/01/2015
Apps Oracle HRMS Tables
HR_LEGISLATION_INSTALLATIONS
Status of each product/legislation combination installed
HR_LOCATIONS_ALL
Work location definitions.
HR_LOCATIONS_ALL_TL
Translated location codes and descriptions.
HR_LOCATION_EXTRA_INFO
Extra information for a location.
HR_LOCATION_INFO_TYPES
Types of extra information that may be held against a Location.
Contains the format masks used to determine the displayed formats of personal names in Applications. Oracle will seed rows in this table which cannot be deleted, but can be modified by HR_NAME_FORMATS
customers. Additional rows can be created.
HR_NAVIGATION_CONTEXT_RULES
Context specific rules for taskflow navigation.
HR_NAVIGATION_NODES
Taskflow node definitions.
Intersection table between HR_WORKFLOWS, HR_NAVIGATION_NODE_USAGES
HR_NAVIGATION_NODES and HR_NAVIGATION_PATHS.
HR_NAVIGATION_PATHS
Taskflow navigation path details.
HR_NAVIGATION_PATHS_TL
HR_NAVIGATION_UNITS
Information about potential navigation options in a taskflow.
HR_NAVIGATION_UNITS_TL
Translated fields for hr_navigation_units
Global variable usage by specific navigation unit. ﴾Form or HR_NAV_UNIT_GLOBAL_USAGES
block﴿.
Additional attributes of an organization, dependent on class or HR_ORGANIZATION_INFORMATION
organization information type.
This is a copy of theHR_ORGANIZATION_INFORMATION table which is populated by the EFC ﴾Euro as Functional Currency﴿ HR_ORGANIZATION_INFORMATIO_EFC
process.
Information types that are used to add information for an HR_ORG_INFORMATION_TYPES
organization.
Defines organization information types for specific organization HR_ORG_INFO_TYPES_BY_CLASS
classifications.
A repeating time pattern, eg a work pattern, SSP qualifying http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
8/30
11/01/2015
Apps Oracle HRMS Tables
HR_PATTERNS
pattern or a resource schedule.
HR_PATTERN_BITS
A defined period of time used to construct a pattern.
Decomposition of a repeating pattern into its individual 'bits' of HR_PATTERN_CONSTRUCTIONS
time.
HR_PATTERN_EXCEPTIONS
An exception to a repeating pattern.
Potential purpose for the parent pattern, eg 'Work Pattern', HR_PATTERN_PURPOSES
'Resource schedule', etc.
HR_PATTERN_PURPOSE_USAGES
Valid combinations of entities and pattern purposes.
HR_PTL_SUMMARY_DATA
HR_PUMP_BATCH_EXCEPTIONS
Holds data pump processing exception ﴾error﴿ information.
HR_PUMP_BATCH_HEADERS
Stores information on a batch to be loaded by the data pump.
Each rows stores the information required to make an API call. HR_PUMP_BATCH_LINES
OUTparameter values are written back after the API call.
keys and their associated information is stored here on the HR_PUMP_BATCH_LINE__KEYS
creation of entities that require keys.
Lists API modules that do not conform to the API parameter HR_PUMP_DEFAULT_EXCEPTIONS
defaulting rules.
Lists PL/SQL packages that contain the parameter mapping functions used by data pump generated code. If module_package and module_name are both null then the mapping functions may HR_PUMP_MAPPING_PACKAGES
be used by all APIs.
Holds seeded information about API parameters for data pump HR_PUMP_MODULE_PARAMETERS
code generation.
Controls the parallelisation of the work when the data pump is HR_PUMP_RANGES
running on multiprocessor platforms.
Holds information on data pump concurrent requests currently HR_PUMP_REQUESTS
running.
HR_QUESTIONNAIRES
Questionnaires used within SSHR.
HR_QUEST_ANSWERS
Answers for a questionnaire.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
9/30
11/01/2015
Apps Oracle HRMS Tables
HR_QUEST_ANSWER_VALUES
Answer values for a questionnaire.
HR_QUEST_FIELDS
Fields of a questionnaire.
Legislation specific information for payrolls, organizations and HR_SOFT_CODING_KEYFLEX
assignments.
Identities of templates which have been copied and the resulting HR_SOURCE_FORM_TEMPLATES
copy. Helps distinguish seeded templates from copied ones.
HR_STU_EXCEPTIONS
Error conditions from the startup data process.
HR_STU_HISTORY
Versions of HRMS Startup data installed
HR_SUMMARY
HR_SUMMARY holds all data for the Generic Summary Process.
This is a copy of the HR_SUMMARY table which is populated by HR_SUMMARY_EFC
the EFC ﴾Euro as Functional Currency﴿ process.
HR_S_MAGNETIC_BLOCKS
HR_S_MAGNETIC_RECORDS
HR_S_US_CITY_GEOCODES
US cities and their VERTEX geocodes, used to validate US HR_S_US_CITY_NAMES
addresses.
HR_S_US_CITY_SCHOOL_DSTS
HR_S_US_CITY_TAX_INFO_F
Element definitions.
HR_S_US_COUNTY_TAX_INFO_F
Element definitions.
HR_S_US_FEDERAL_TAX_INFO_F
Element definitions.
HR_S_US_GARN_EXEMPTION_RULES_F
HR_S_US_GARN_FEE_RULES_F
HR_S_US_GARN_LIMIT_RULES_F
HR_S_US_STATE_TAX_INFO_F
Element definitions.
Valid zip code ranges for VERTEX cities, used to validate US HR_S_US_ZIP_CODES
addresses.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
10/30
11/01/2015
Apps Oracle HRMS Tables
HR_S_VALID_DEPENDENT_TYPES
Retrofitted
HR_S_WC_STATE_SURCHARGES
Retrofitted
HR_TAB_PAGE_PROPERTIES_B
Properties of tab pages for configurable forms
HR_TAB_PAGE_PROPERTIES_TL
Translated properties of tab pages for configurable forms
HR_TEMPLATE_CANVASES_B
Definition of canvases on template for configurable forms
HR_TEMPLATE_DATA_GROUPS
Definition for data group on template for configurable forms
HR_TEMPLATE_ITEMS_B
Definition of items on template for configurable forms
Definition of items on a template for given context, for HR_TEMPLATE_ITEM_CONTEXTS_B
configurable forms
Information about which tab pages item belongs to for a specific HR_TEMPLATE_ITEM_CONTEXT_PAGES
context, on template for configurable form.
Information about which tab pages item belongs to on template HR_TEMPLATE_ITEM_TAB_PAGES
for configurable form.
HR_TEMPLATE_TAB_PAGES_B
Definition of tab page for template, for configurable forms
HR_TEMPLATE_WINDOWS_B
Definition of window for a template, for configurable forms
HR_TIPS
Help components used within SSHR.
HR_WINDOW_PROPERTIES_B
Properties of windows for configurable forms
HR_WINDOW_PROPERTIES_TL
Translated properties of windows for configurable forms
HR_WIP_LOCKS
Stores context lock for a transaction
HR_WIP_TRANSACTIONS
Stores the transaction information and state
HR_WORKFLOWS
Taskflows in Oracle HRMS.
Holds a list of people who constitute a current list, used in HR_WORKING_PERSON_LISTS
the Line Manager Web pages
PER_ABSENCE_ATTENDANCES
Records of absence, or attendance for an employee.
This is a copy of the PER_ABSENCE_ATTENDANCES table http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
11/30
11/01/2015
Apps Oracle HRMS Tables
which is populated by the EFC ﴾Euro as Functional Currency﴿ PER_ABSENCE_ATTENDANCES_EFC
process.
PER_ABSENCE_ATTENDANCE_TYPES
defined absence types.
PER_ABS_ATTENDANCE_REASONS
Valid absence reasons for an absence type.
PER_ABS_ATTENDANCE_TYPES_TL
Holds translated information for Absence Types
PER_ADDRESSES
Address information for people.
PER_ALL_ASSIGNMENTS_F
Employee and applicant assignment details.
DateTracked table holding personal information for employees, PER_ALL_PEOPLE_F
applicants and other people.
PER_ALL_POSITIONS
Dualmaintained position definition information.
PER_ALL_VACANCIES
Vacancies within a specific requisition.
PER_ANALYSIS_CRITERIA
Flexfield combination table for the personal analysis key flexfield.
PER_APPLICATIONS
Applications for employment.
PER_APPRAISALS
An appraisal is a record of an evaluation of a person by others.
PER_APPRAISAL_TEMPLATES
The heading or grouping of appraisal questions.
PER_ASSESSMENTS
The grouping of a set of assessment elements.
PER_ASSESSMENT_GROUPS
Grouping of People for 360 reviews
PER_ASSESSMENT_TYPES
The definition of an assessment template
PER_ASSIGNMENT_BUDGET_VALUES_F
Budget values for an assignment.
This is a copy of the PER_ASSIGNMENT_BUDGET_VALUES_F table which is populated by the EFC ﴾Euro as Functional PER_ASSIGNMENT_BUDGET_VALU_EFC
Currency﴿ process.
PER_ASSIGNMENT_EXTRA_INFO
Extra information for an assignment.
This is a copy of the PER_ASSIGNMENT_EXTRA_INFO table which is populated by the EFC ﴾Euro as Functional Currency﴿ PER_ASSIGNMENT_EXTRA_INFO_EFC
process.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
12/30
11/01/2015
PER_ASSIGNMENT_INFO_TYPES
Apps Oracle HRMS Tables
Types of extra information that may be held against an assignment.
Translated types of extra information that may be held against an PER_ASSIGNMENT_INFO_TYPES_TL
assignment.
PER_ASSIGNMENT_LIST
List of assignments that a secure can access.
PER_ASSIGNMENT_STATUS_TYPES
Predefined and defined assignment status types.
PER_ASSIGNMENT_STATUS_TYPES_TL
Predefined and defined translated assignment status types.
PER_ASSIGN_PROPOSAL_ANSWERS
Web Candidate Offer Answers
PER_ASS_STATUS_TYPE_AMENDS
amendments to predefined assignment status types.
Translated amendments to predefined assignment status PER_ASS_STATUS_TYPE_AMENDS_TL
types.
Holds assignment level run amount and summary values for PER_BF_BALANCE_AMOUNTS
backfeed balances by payroll processing period
PER_BF_BALANCE_AMOUNTS_EFC
PER_BF_BALANCE_TYPES
Types of balances that can be held
PER_BF_BALANCE_TYPES_EFC
Holds details of payments that have been processed by a 3rd PER_BF_PAYMENT_DETAILS
party payroll provider, by assignment.
PER_BF_PAYMENT_DETAILS_EFC
PER_BF_PAYROLL_RUNS
Payrolls processed by 3rd party payroll provider.
Intersection table storing details of assignments that have been PER_BF_PROCESSED_ASSIGNMENTS
processed by a 3rd party payroll provider in each payroll run
PER_BOOKINGS
Event booking details.
PER_BUDGETS
Definitions of HR budgets.
Combinations of organization, grade, job, and position used to PER_BUDGET_ELEMENTS
define detailed budget values.
PER_BUDGET_VALUES
Planned HR budget values for specific budget elements.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
13/30
11/01/2015
Apps Oracle HRMS Tables
This is a copy of the PER_BUDGET_VALUES table which is PER_BUDGET_VALUES_EFC
populated by the EFC ﴾Euro as Functional Currency﴿ process.
PER_BUDGET_VERSIONS
Identifies specific versions of an HR budget.
PER_CAGR_APIS
PER_CAGR_APIS_TL
PER_CAGR_API_PARAMETERS
PER_CAGR_API_PARAMETERS_TL
PER_CAGR_COPY_LOG
PER_CAGR_ENTITLEMENTS
PER_CAGR_ENTITLEMENT_ITEMS
PER_CAGR_ENTITLEMENT_ITEMS_TL
PER_CAGR_ENTITLEMENT_LINES_F
PER_CAGR_ENTITLEMENT_RESULTS
The reference collectively agreed grades for a Collective PER_CAGR_GRADES
Agreement.
PER_CAGR_GRADES_DEF
Collective agreement grades key flexfield combinations table.
The valid collectively agreed grade key flexfield structures for a PER_CAGR_GRADE_STRUCTURES
particular collective agreement
PER_CAGR_LOG
PER_CAGR_REQUESTS
PER_CAGR_RETAINED_RIGHTS
PER_CALENDAR_ENTRIES
Calendar Entries
PER_CAL_ENTRY_GEO_LIST
Calendar Entry Geo Coverage Cache
PER_CAL_ENTRY_ORG_LIST
Calendar Entry Org Coverage Cache
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
14/30
11/01/2015
Apps Oracle HRMS Tables
PER_CAL_ENTRY_VALUES
Calendar Entry Values
PER_CAREER_PATHS
List of career paths for jobs.
PER_CAREER_PATH_ELEMENTS
Progression paths for specific jobs.
PER_CA_EE_REPORT_LINES
PER_CHECKLIST_ITEMS
Checklist information.
Details of a benefit that the employee accepts or rejects as part of PER_COBRA_COVERAGE_BENEFITS_F
their COBRA coverage.
PER_COBRA_COVERAGE_PERIODS
Holds coverage periods for COBRA qualifying events.
PER_COBRA_COVERAGE_STATUSES
Tracks the status of a COBRA enrollment.
Enrollments for people who are eligible for continued benefit PER_COBRA_COV_ENROLLMENTS
coverage under COBRA.
Holds employee dependents coverage for a COBRA qualifying PER_COBRA_DEPENDENTS_F
event.
Events that have meaning in the context of COBRA coverage, PER_COBRA_QFYING_EVENTS_F
e.g. Divorce, Termination, Death etc.
PER_COLLECTIVE_AGREEMENTS
Collective agreement information.
A competence is a definition of knowledge, skills, abilities or other PER_COMPETENCES
charactaristics that a person may possess.
PER_COMPETENCES_TL
This table is used for language translations
PER_COMPETENCE_DEFINITIONS
COMPETENCES Key flexfield combinations table
A competence element is used to record an individual PER_COMPETENCE_ELEMENTS
competence and an evaluation rating.
PER_COMPETENCE_OUTCOMES
Competence outcomes
PER_COMP_ELEMENT_OUTCOMES
The outcomes achieved towards a given Competency .
PER__EXTRA_INFO_F
Extra information for a relationship.
Types of extra information that may be held against a PER__INFO_TYPES
relationship.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
15/30
11/01/2015
Apps Oracle HRMS Tables
Translated types of extra information that may be held against a PER__INFO_TYPES_TL
relationship.
s and relationship details for dependents, beneficiaries, PER__RELATIONSHIPS
emergency s, parents etc.
PER_CONTRACTS_F
The details of a persons contract of employment
Used to log errors / warnings during the conversion of PER_N_DATA_UPGRADE
competences to a key flex structure.
A factor affecting a person's capacity to be deployed within an PER_DEPLOYMENT_FACTORS
organization.
PER_DISABILITIES_F
Hold Disability information for one person
PER_ELECTIONS
Holds election related information.
PER_ELECTION_CANDIDATES
Holds information of Election candidates.
This table holds information related to constituencies participating PER_ELECTION_CONSTITUENCYS
in the election.
PER_EMPDIR_ASSIGNMENTS
PER_EMPDIR_JOBS
PER_EMPDIR_LOCATIONS
PER_EMPDIR_LOCATIONS_TL
PER_EMPDIR_ORGANIZATIONS
PER_EMPDIR_PEOPLE
PER_EMPDIR_PHONES
PER_EMPDIR_POSITIONS
This entity is used to maintain a list of educational PER_ESTABLISHMENTS
establishments e.g. schools, colleges, universities, etc.
A record of educational establishments that a person is currently PER_ESTABLISHMENT_ATTENDANCES
attending or has previously attended.
Record of events such as interviews and appraisals for applicants http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
16/30
11/01/2015
PER_EVENTS
Apps Oracle HRMS Tables
and employees.
Navigation and person change information for the Enter Person PER_FORM_FUNCTIONS
information screens.
Text lines for output by a generic report script, including: title, PER_GENERIC_REPORT_OUTPUT
header, footer and body lines.
PER_GEN_HIERARCHY
PER_GEN_HIERARCHY_NODES
PER_GEN_HIERARCHY_VERSIONS
PER_GEN_HIER_NODE_TYPES
PER_GRADES
Grade definitions for a business group.
PER_GRADES_TL
Trnslated fields for per_grades
PER_GRADE_DEFINITIONS
Grade key flexfield combinations table.
PER_GRADE_SPINES_F
Stores the progression points for each grade scale.
PER_HEADCOUNT_PORTLET_TBL
PER_HTML_TOOLKIT_REC_TYPES
Default values for the HR html toolkit.
PER_IMAGES
Images for a designated row in a designated table.
Cross table between Responsibilty and Info_type tables, used to PER_INFO_TYPE_SECURITY
secure info types based on responsibility.
PER_JOBS
Jobs defined for a Business Group.
PER_JOBS_TL
Translated columns for per_jobs
PER_JOB_DEFINITIONS
Job key flexfield combinations table.
PER_JOB_EVALUATIONS
Job evaluation details for specific jobs or positions.
PER_JOB_EXTRA_INFO
Extra information for a job.
Holds Job Group Information. Each Job will be a member of a Job Group and a Job Group can optionally be within a business PER_JOB_GROUPS
group.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
17/30
11/01/2015
PER_JOB_INFO_TYPES
Apps Oracle HRMS Tables
Types of extra information that may be held against a job.
Requirements for specific jobs or positions. For example, skills, PER_JOB_REQUIREMENTS
qualifications, experience, training.
PER_JP_ADDRESS_LOOKUPS
Lookups for Japanese Addresses
PER_JP_BANK_LOOKUPS
Lookups for Japanese Bank Branches
PER_JP_POSTAL_CODES
Lookups for Japanese postal codes and districts
PER_JP_SCHOOL_LOOKUPS
Lookups for Japanese Educational Institutions
PER_KR_ADDRESSES
KR specific
PER_KR_GRADES
KR specific
PER_KR_GRADE_AMOUNT_F
KR specific
PER_KR_G_POINTS
KR specific
PER_KR_G_POINT_AMOUNT_F
KR specific
Associations between letter types and possible status type PER_LETTER_GEN_STATUSES
changes.
PER_LETTER_REQUESTS
Requests for specific types of standard letter.
PER_LETTER_REQUEST_LINES
Details of individual letter requests.
PER_LETTER_TYPES
Letter types and autorequest definitions.
PER_MASS_MOVES
High level mass move definition.
PER_MEDICAL_ASSESSMENTS
Hold Medical Assessment information for one person
PER_MM_ASSIGNMENTS holds assignments that were defined PER_MM_ASSIGNMENTS
as part of a mass move.
PER_MM_JOB_REQUIREMENTS holds data related to PER_MM_JOB_REQUIREMENTS
transferring position requirements to a newly created position.
PER_MM_POSITIONS holds positions that were defined as part PER_MM_POSITIONS
of a mass move.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
18/30
11/01/2015
PER_MM_VALID_GRADES
Apps Oracle HRMS Tables
PER_MM_VALID_GRADES holds valid grades that will be moved with a position during a mass move.
PER_NL_ABSENCE_ACTIONS
Dutch Specific Absence Actions
PER_NL_ABSENCE_CHANGES
Dutch Specific Absence Changes
Records the Dutch Assignment SCL Context Information PER_NL_ASG_SCL_UPGRADE
Migrated used by the Report
PER_NUMBER_GENERATION_CONTROLS holds the numbers PER_NUMBER_GENERATION_CONTROLS
that are automatically generated for a Business Group.
PER_OBJECTIVES
A target or goal which may be evaluated during an appraisal.
PER_ORGANIZATION_LIST
List of organizations that a secure can access.
PER_ORGANIZATION_STRUCTURES
Organization hierarchy names.
Organization hierarchy details showing parentchild reporting PER_ORG_STRUCTURE_ELEMENTS
relationships between organizations.
PER_ORG_STRUCTURE_VERSIONS
Version control information for specific organization hierarchies.
PER_PARENT_SPINES
Details of pay scales, ﴾previously known as parent spines﴿.
PER_PARTICIPANTS
A person participating in an appraisal or assessment.
PER_PAY_BASES
Definitions of specific salary bases.
Salary proposals and performance review information for PER_PAY_PROPOSALS
employee assignments.
This is a copy of the PER_PAY_PROPOSALS table which is PER_PAY_PROPOSALS_EFC
populated by the EFC ﴾Euro as Functional Currency﴿ process.
Component details of a pay proposal for an employee PER_PAY_PROPOSAL_COMPONENTS
assignment.
This is a copy of the PER_PAY_PROPOSAL_COMPONENT table which is populated by the EFC ﴾Euro as Functional PER_PAY_PROPOSAL_COMPONENT_EFC
Currency﴿ process.
PER_PAY_PROPOSAL_COMPONENT_EFC
PER_PEOPLE_EXTRA_INFO
Extra information for a person.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
19/30
11/01/2015
Apps Oracle HRMS Tables
The table holds the definitions of extra information types that may PER_PEOPLE_INFO_TYPES
be held against a person.
PER_PERFORMANCE_RATINGS
A single evaluation of an objective.
PER_PERFORMANCE_REVIEWS
Performance review information for employees.
PER_PERIODS_OF_PLACEMENT
Periods of placement details for a nonpayrolled worker
PER_PERIODS_OF_SERVICE
Period of service details for an employee.
This is a copy of the PER_PERIODS_OF_SERVICE table which PER_PERIODS_OF_SERVICE_EFC
is populated by the EFC ﴾Euro as Functional Currency﴿ process.
PER_PERSON_ANALYSES
Special information types for a person.
PER_PERSON_DLVRY_METHODS
The communication delivery method for a person.
PER_PERSON_LIST
List of people that a secure can access.
List of people that are to be added to current PER_PERSON_LIST_CHANGES
PER_PERSON_LIST.
Archive table to hold content of PER_PERSON_LIST_CHANGES PER_PERSON_LIST_CHG_ARCH
on upgrade.
PER_PERSON_TYPES
Person types visible to specific Business Groups.
PER_PERSON_TYPES_TL
Translated person types information.
PER_PERSON_TYPE_USAGES_F
Identifies the types a person may be.
PER_PHONES holds phone numbers for current and ex PER_PHONES
employees, current and exapplicants and employee s.
PER_POSITION_DEFINITIONS
Combinations of segments stored in the PER_POSTIONS table.
PER_POSITION_EXTRA_INFO
Extra information for a position.
PER_POSITION_INFO_TYPES
Types of extra information that may be held against a position.
PER_POSITION_LIST
List of positions that a secure can access.
PER_POSITION_STRUCTURES
Position Hierarchy names.
Position hierarchy details showing parentchild reporting http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
20/30
11/01/2015
Apps Oracle HRMS Tables
PER_POS_STRUCTURE_ELEMENTS
relationships between positions.
PER_POS_STRUCTURE_VERSIONS
Version control information for specific position hierarchies.
PER_PREVIOUS_EMPLOYERS
PER_PREVIOUS_JOBS
Used to store Previous Jobs
PER_PREVIOUS_JOB_EXTRA_INFO
Previous Jobs extra info
PER_PREVIOUS_JOB_INFO_TYPES
Used to store previous job info types
PER_PREVIOUS_JOB_USAGES
Used to store previous job Usages
PER_PREV_JOB_EXTRA_INFO
Previous Jobs extra info
PER_PREV_JOB_INFO_TYPES
Used to store previous job info types
PER_PROPOSAL_CATEGORY_
Web Offers profile categories of questions
PER_PROPOSAL_CATEGORY_TYPES
Generic web offer category definitions
PER_PROPOSAL_OFFER_PARAGRAPHS
Web Offer letter text
PER_PROPOSAL_QUESTIONS_ADV
Web Offer advanced questions
PER_PROPOSAL_QUESTION_
Web offer profile questions
PER_PROPOSAL_QUESTION_TYPES
Generic web offer questions
PER_PROPOSAL_TEMPLATES
Retrofitted
Table for storing DFF migration mapping Information from PER_PTU_DFF_MAPPING_HEADERS
PER_ALL_PEOPLE_F to PER_PERSON_TYPE_USAGES_F.
Table for storing DFF migration mapping Information from PER_PTU_DFF_MAPPING_LINES
PER_ALL_PEOPLE_F to PER_PERSON_TYPE_USAGES_F.
This table is used to store the details of the person records failed to migrate to PER_PERSON_TYPE_USAGES_F from PER_PTU_DFF_MIG_FAILED_PEOPLE
PER_ALL_PEOPLE_F.
A record of educational qualification, certificates, licenses, etc PER_QUALIFICATIONS
that a person holds or is acquiring.
This is a copy of the PER_QUALIFICATIONS table which is http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
21/30
11/01/2015
Apps Oracle HRMS Tables
PER_QUALIFICATIONS_EFC
populated by the EFC ﴾Euro as Functional Currency﴿ process.
PER_QUALIFICATIONS_TL
Translated qualification details.
PER_QUALIFICATION_TYPES
Maintains the list of qualiification types that can be attained.
PER_QUALIFICATION_TYPES_TL
Maintains the list of qualiification type translations
PER_QUERY_CRITERIA
Used to store criteria to build up a query
PER_QUICKPAINT_INVOCATIONS
Identifies QuickPaint report runs.
PER_QUICKPAINT_RESULT_TEXT
Text description for the result of a single QuickPaint run.
A rating scale step is a single point on a rating scale and is used PER_RATING_LEVELS
to rate competences.
A rating scale step is a single point on a rating scale and is used PER_RATING_LEVELS_TL
to rate competences.
PER_RATING_SCALES
A scale used to rate compentencies.
PER_RATING_SCALES_TL
Translated rating scale name and description.
PER_RECRUITMENT_ACTIVITIES
Recruitment activities and costs.
This is a copy of the PER_RECRUITMENT_ACTIVITIES table which is populated by the EFC ﴾Euro as Functional Currency﴿ PER_RECRUITMENT_ACTIVITIES_EFC
process.
PER_RECRUITMENT_ACTIVITY_FOR
Vacancies associated with a specific recruitment activity.
PER_REQUISITIONS
Vacancy requisition details.
PER_RI_DEPENDENCIES
Dependencies among Workbench tasks
PER_RI_REQUESTS
Concurrent requests for workbench componenets
PER_RI_SETUP_SUB_TASKS
Workbench setup subtasks
PER_RI_SETUP_SUB_TASKS_TL
TL table for PER_RI_SETUP_SUB_TASKS
PER_RI_SETUP_TASKS
Workbench Setup Tasks
PER_RI_SETUP_TASKS_TL
TL table for PER_RI_SETUP_TASKS table
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
22/30
11/01/2015
Apps Oracle HRMS Tables
PER_RI_VIEW_REPORTS
Stores data related to view reports for HRMS
PER_RI_VIEW_REPORTS_TL
Workbench View Reports Translation Table
PER_RI_WORKBENCH_ITEMS
Workbench items
PER_RI_WORKBENCH_ITEMS_TL
Translation table for Per_ri_workbench_items
PER_ROLES
Holds the different roles that a person performs.
PER_SALARY_SURVEYS
Market salary survey information.
PER_SALARY_SURVEY_LINES
Details for market salary surveys.
This is a copy of the PER_SALARY_SURVEY_LINES table which is populated by the EFC ﴾Euro as Functional Currency﴿ PER_SALARY_SURVEY_LINES_EFC
process.
PER_SALARY_SURVEY_MAPPINGS
Mapping information for a salary survey line.
PER_SCHED_COBRA_PAYMENTS
Payment schedules for benefits provided by a COBRA coverage.
Secondary assignment statuses used for information and PER_SECONDARY_ASS_STATUSES
reporting.
List of organizations to include or exclude from PER_SECURITY_ORGANIZATIONS
security list
Security profile definitions to restrict access to specific PER_SECURITY_PROFILES
HRMS records.
List of s for a security profile whose access permissions will PER_SECURITY_S
be stored in static lists duringSecurity List Maintenance.
Security profile assignments for , Responsibility and PER_SEC_PROFILE_ASSIGNMENTS
Business Group.
PER_SHARED_TYPES
Holds 'type' and 'status' information.
PER_SHARED_TYPES_TL
Translated information for shared types.
PER_SPECIAL_INFO_TYPES
Special information types available to a Business Group.
PER_SPECIAL_INFO_TYPE_USAGES
Limits usage of special information types to specific windows.
PER_SPINAL_POINTS
List of progression points in a pay scale.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
23/30
11/01/2015
PER_SPINAL_POINT_PLACEMENTS_F
Apps Oracle HRMS Tables
Details of assignment placements to a grade step and point.
Grade steps defined in a specific grade scale and their PER_SPINAL_POINT_STEPS_F
incremental order.
PER_STANDARD_HOLIDAYS
Statutory Holiday information.
PER_STARTUP_PERSON_TYPES_TL
Predefined list of translated person types.
PER_STD_HOLIDAY_ABSENCES
Records when Statutory Holidays are taken.
PER_SUBJECTS_TAKEN
Holds a record of a person's subject usages for a qualification
PER_SUBJECTS_TAKEN_TL
Translated grade_attained.
PER_SUCCESSION_PLANNING
The record of a person's proposed succession to a position.
Time period definitions for payroll processing and HR budget PER_TIME_PERIODS
calendars.
PER_TIME_PERIOD_RULES
Rules for time periods used by the system.
PER_TIME_PERIOD_SETS
Specific dates for a defined calendar.
Predefined list of valid period types for payroll and HR budget PER_TIME_PERIOD_TYPES
calendars.
Predefined list of translated period types for payroll and HR PER_TIME_PERIOD_TYPES_TL
budget calendars.
PER_US_INVAL_ADDRESSES
Temporary table used to hold invalid addresses.
PER_US_INVAL_LOCATIONS
Temporary table used to hold invalid location addresses.
PER_VALID_GRADES
Lists valid grades for jobs and positions.
Holds information on Incidents that happen at work or en route to PER_WORK_INCIDENTS
work, for example, an industrial accident
This is a copy of the PER_WORK_INCIDENTS table which is PER_WORK_INCIDENTS_EFC
populated by the EFC ﴾Euro as Functional Currency﴿ process.
PER_ZA_AREAS_OF_ASSESSMENT
Table to store the Areas of assessment per NQF Assessment
PER_ZA_ASSESSMENTS
Table to store the NQF Assessment info for a person
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
24/30
11/01/2015
Apps Oracle HRMS Tables
PER_ZA_EMPLOYMENT_EQUITY
Temporary table for Employment Equity Reporting
PER_ZA_FORMAL_QUALIFICATIONS
Table to store additional NQF Qualification info for a person
Table to store the NQF learnership agreement info between a PER_ZA_LEARNERSHIP_AGREEMENTS
person and the organization
PER_ZA_QUALIFICATION_TYPES
Table to link qualification types ﴾titles﴿ to NQF qualification types
PER_ZA_TRAINING
Table to store NQF Training info for a person
Comments (15) Subscribe to this comment's feed
... written by Florin Barbalau , February 09, 2007 Hi Anil, I was looking on the way security profiles work and there is no table such as PER_SECURITY_S in my implementation of oracle apps altough I found it on eTrm on metalink. Did you had this situation before ? We use : Oracle Applications : 11.5.9 thanks,
... written by Anil i , February 10, 2007 Hi Florin, This table exists in 11.5.10 with following columns. Possibly this is a new addition to 11.5.10 DEV11510>>desc PER_SECURITY_S Name SECURITY__ID SECURITY_PROFILE_ID _ID OBJECT_VERSION_NUMBER LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_ CREATED_BY CREATION_DATE Thanks, Anil i
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
25/30
11/01/2015
Apps Oracle HRMS Tables
... written by Aravind , April 10, 2007 Hi Anil, We have upgraded from oracle 11.5.9 to 11.5.10.The address form﴾People>enter and Maintain﴿ in 11.5.9 is PERWSADR and it is PERACADR in 11.5.10. Can we say it is because of the upgrade.how to check this form is changed because of upgrade. Thanks in advance. Aravind M
... written by Anil i , April 14, 2007 Usually DBAs create a frozen environment of preupgrade instance. you may ask your DbAs to check there in fnd_form_functions_vl Thanks, Anil i
... written by Anil i , June 15, 2007 Hi Hari Per_ALL_PEOPLE_F is the right table. Try this... select * from per_all_people_f where creation_date > sysdate 2 ; this will return all the records created during last two days. Before you do that, can you query the record back from the screen? You need to be 100% certain that the record got saved in the DB. Thanks, Anil i
... written by Saurabh.s , September 07, 2007 HI ,Anil. again great effort from your side.your site is giving me a lot of knowledge in each n every way .Here i like to ask one thing ,wheather I am not very sure I am rite or not. but can you provide some list of queries which generally we use to develop any report or any form .I am giving you a example for that may be my point will be clear ,just like previous you have send one query which will" return all the records created during last two days" select * from per_all_people_f where creation_date > sysdate 2 ; like this if you can send us some more query then that will be really great help from your side. Thankx & Regards Saurabh Srivastava
... written by Anil i , September 07, 2007 Hi Hari
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
26/30
11/01/2015
Apps Oracle HRMS Tables
Please see http://oracle.anili.com/or...ables.html Thanks, Anil i
Multiple assignments in Self Service Time Sheet written by Gupta Nagubandi , October 10, 2007 Hi Anil, Your website is really very helpful, thnx for all your efforts. The Self Service Time sheet that is available in OTL, does not allow the to fill the time for multiple assigments if the employee is assigned to more than one assignment. The client wants us to implement the solution so that the employees should be allowed to fill the time entry for multiple assignments. Could you please share your ideas on how to achieve this? Best Regards, Gupta
Urgent help required in DFF segments custom validation written by Lakshman Kalisetti , October 11, 2007 Hi Anil, We need your expert guidence in implementing address validation in Oracle R12 HRMS form "PERACADR.fmb" In this form person address is captured using the standard DFF "Personal Address Information". This DFF is context sensitive. Address Type is the reference field. In case of address types US and CAN, we need to have our customized validation on the segments like City, State, Country, Zip Code. All the segments are attached with oracle supplied value sets. In our case, while populating the list of values for any of the above four segments, we need to consider the remaining three segments. Based on those three segments we need to do some validations and populate the list with valid data only. We tried below steps to implement this... 1. Create new value sets based on our custom tables and assign them to all four segments. 2. Write KeyListval trigger on all the four segments with following code... a﴿ call our custom procedures to populate the custom tables with valid values b﴿ populate the LOV using list_values But after implementing the above changes, we identified that none of our triggers on DFF segments are getting executed. We tried some other possiblities also, but could not make it. Could you please provide us your expert guidence on this. Your earliest reply would be highly appreciated.
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
27/30
11/01/2015
Apps Oracle HRMS Tables
Thanks in advance, Lucky
Hi, Whenever tries to see the list of values for any segment, data should be populated in our custom tables which are used in value set. So this is a an frontend item level action, which cannot be done using backend triggers. Please let us know, if you have any other inputs. Thanks, Lucky
IT Analyst written by Zain Rehan , October 30, 2007 Hey Anil, I was wondering if you can guide me to understanding Oracle HRMS field interdependencies? Does Oracle or any other source offers any tools or mappings as such? For example, there might be an inter dependency between 'City' and 'Country' fields. Looking at some masking solutions and thus wanted to make sure we cover all integrity and data relationship issues. Your guidance would be greatly appreciated. Many thanks,
... written by Anil i , October 30, 2007 Hi Zain Depending upon your business requirements, you can use CUSTOM.pll or API Hooks or Personalizations to achieve your requirement. Also check Metalink if there exists a localization patch for the specific country address for validations. Thanks, Anil i
OTL workflow shows wrong information in FYI notification to the Employee who enters time sheet written by Prasad Kumar , January 08, 2008 Iam "A" entering time sheet, it is approved by my manager "B", I have set vacation rule to delegate my notifications to my friend "C" , "C" gets the notification , but the action history shows that some other person 'D" has approved my time sheet, can I know how to debug this, Iam using 11.5.9 , Example "A" Feil, Mrs. Phyllis Jan http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
28/30
11/01/2015
Apps Oracle HRMS Tables
"B" Uran, Mr. D Mark ﴾Mark﴿ "C" Huynh, Ms. Thuy Ngoc Thanh ﴾Tiffany﴿ "D" Ahnberg, Mr. Donald Searle ﴾Don﴿ Not related to any one in the list...
FYI: Uran, Mr. D Mark ﴾Mark﴿ approved timecard for period 11NOV07 to 17NOV07, 46 Total Hours ﴾Timecard Num: 671416 ﴿ From Feil, Mrs. Phyllis Jan To Huynh, Ms. Thuy Ngoc Thanh ﴾Tiffany﴿ Sent 16NOV2007 13:18:15 ID 1792503
Feil, Mrs. Phyllis Jan, This timecard has been approved :
Timecard Details Project Number Project Name Task Number Task Name Type Hour Type Date Day Hours Comments ITFINANCE ITFINANCE 1.01 NON ERP HOUR NON ERP HOUR PSLabor Worked Hours 12Nov07 Mon 11 ITERP2 QUOTE TO CASH ERP PHASE2 QUOTE TO CASH 8.00 Project Project PSLabor Worked Hours 13Nov07 Tue 1 ITFINANCE ITFINANCE 1.01 NON ERP HOUR NON ERP HOUR PSLabor Worked Hours 13Nov07 Tue 10 ITFINANCE ITFINANCE 1.01 NON ERP HOUR NON ERP HOUR PSLabor Worked Hours 14Nov07 Wed 5 ITERP2 QUOTE TO CASH ERP PHASE2 QUOTE TO CASH 8.00 Project Project PSLabor Worked Hours 14Nov07 Wed 4 ITFINANCE ITFINANCE 1.01 NON ERP HOUR NON ERP HOUR PSLabor Worked Hours 15Nov07 Thu 10 ITFINANCE ITFINANCE 1.01 NON ERP HOUR NON ERP HOUR PSLabor Worked Hours 16Nov07 Fri 5
Timecard Link Action History Num Action Date Action From To Details 1 16NOV2007 13:18:15 Submit Ahnberg, Mr. Donald Searle ﴾Don﴿ Feil, Mrs. Phyllis Jan 2 16NOV2007 13:18:15 Delegate Feil, Mrs. Phyllis Jan Huynh, Ms. Thuy Ngoc Thanh ﴾Tiffany﴿
... written by Nancy , February 02, 2008 Hey Anil, Could u please show ER Diagram of Oracle HRMS?? Nancy
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
29/30
11/01/2015
Apps Oracle HRMS Tables
SET UP for UAE localisation written by Naren , February 06, 2008 Hi Anil, This is my first mail to you. Am looking for any document related to Oracle HR and payroll set up of UAE localisation. Kindly help me Thanks Naren
HRMS written by karima , February 20, 2008 HI Anil This is my first post Have any hint to change UK to Sadui legislation without creating new business group and data migration Thanks Abdul
You must be logged in to a comment. Please if you do not have an yet.
Close Window
http://oracle.anili.com/index2.php?option=com_content&task=view&id=113&pop=1&page=0&Itemid=32
30/30
Related Documents 3h463d
Apps - Oracle Hrms Tables 23v70
December 2022 0
Oracle Hrms Tables 445z25
November 2019 125
Oracle Hrms Payroll Tables 1034f
December 2019 146
Oracle Apps Tables List 4f2jh
April 2022 0
Apps Hrms 2y4212
December 2019 104
April 2020 20
More Documents from "Shyam Ganugapati" 5ic43
Apps - Oracle Hrms Tables 23v70
December 2022 0
Is 2190.pdf 4u4p2j
August 2021 0
Copy John.wick.chapter.3. .parabellum.2019.720p.bluray.x264 [yts.lt] 4r555y
August 2022 0
Gsm Protocol Stack 2e5n5b
November 2019 67
Movement Types Determining The Wm Movement Type During To Creation.pdf 71gu
June 2020 2