PER Tables (592)

PER - Human Resources — documented tables from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

Table	Columns	Description
AME_ACTIONS	15	To be Updated
AME_ACTION_TYPES	16	To be Updated
AME_ACTION_TYPE_CONFIG	14
AME_ACTION_TYPE_USAGES	12	To be Updated
AME_ACTION_USAGES	11
AME_APPROVALS_HISTORY	15	To be Updated
AME_APPROVAL_GROUPS	15	To be Updated
AME_APPROVAL_GROUP_CONFIG	13
AME_APPROVAL_GROUP_ITEMS	14	To be Updated
AME_APPROVAL_GROUP_MEMBERS	10	To be Updated
AME_APPROVER_TYPES	22	To be Updated
AME_APPROVER_TYPE_USAGES	11	To be Updated
AME_ATTRIBUTES	17	To be Updated
AME_ATTRIBUTE_USAGES	17	To be Updated
AME_CALLING_APPS	15	To be Updated
AME_CONDITIONS	19	To be Updated
AME_CONDITION_USAGES	12	To be Updated
AME_CONFIG_VARS	14	To be Updated
AME_EXCEPTIONS_LOG	8	To be Updated
AME_FIELD_HELP	5	To be Updated
AME_HELP	4	To be Updated
AME_ITEM_CLASSES	11
AME_ITEM_CLASS_USAGES	15
AME_MANDATORY_ATTRIBUTES	12	To be Updated
AME_RULES	16	To be Updated
AME_RULE_USAGES	15	To be Updated
AME_STRING_VALUES	12	To be Updated
AME_TEMP_DELETIONS	16	To be Updated
AME_TEMP_HANDLER_STATES	6	To be Updated
AME_TEMP_INSERTIONS	20	To be Updated
AME_TEMP_OLD_APPROVER_LISTS	17	To be Updated
AME_TEMP_TRANSACTIONS	19	To be Updated
AME_TEMP_TRANS_ATT_VALUES	14
AME_TEMP_TRANS_LOCKS	4	To be Updated
AME_TEST_TRANS_ATT_VALUES	14	To be Updated
BEN_BENEFICIARIES_F	13	Beneficiaries for a benefit program
BEN_BENEFIT_CLASSIFICATIONS	21	Classification for a particular benefit, eg pension, health, life insurance, flex plan.
BEN_BENEFIT_CONTRIBUTIONS_F	39	Default contributions payable for cover by a specific benefit.
BEN_COVERED_DEPENDENTS_F	10	Dependents covered by specific benefit plans.
BEN_VALID_DEPENDENT_TYPES	11	Types of dependent relationship that are valid for cover by a specific benefit.
HR_ALL_ORGANIZATION_UNITS	54	Organization unit definitions.
HR_ALL_ORGANIZATION_UNITS_TL	10	Translated organization unit name definitions.
HR_ALL_POSITIONS_F	136	Position definition information.
HR_ALL_POSITIONS_F_TL	9	Translation table
HR_API_BATCH_MESSAGE_LINES	9	Results and messages generated during batch API processing.
HR_API_HOOKS	15	Lists the hook points which are available in each API module.
HR_API_HOOK_CALLS	20	Lists which extra logic, package procedures or formula, should be called from the API hook points.
HR_API_MODULES	12	Holds details of the business processes and row handlers.
HR_API_TRANSACTIONS	34	Kiosk processes in progress
HR_API_TRANSACTION_STEPS	56	Kiosk workflow data rows
HR_API_TRANSACTION_VALUES	18	Kiosk workflow data columns and values
HR_API_USER_HOOK_REPORTS	4	Used to hold HR_API_USER_HOOK error information if this exists otherwise no information is held.
HR_ASSIGNMENT_SETS	10	Formula definitions that identify sets of assignments.
HR_ASSIGNMENT_SET_AMENDMENTS	8	Identifies explicit include and exclude rules for an assignment set.
HR_ASSIGNMENT_SET_CRITERIA	11	Identifies individual criteria in the definition of an assignment set.
HR_ATH_ELIGIBLE_TBLS	9
HR_ATH_ENROLL_TBLS	9	This table contains ODBC connectivity information for the Authoria enrolled plans table(s).
HR_ATH_VARIABLEMAP	11	Variable mappings table for the Authoria Integration
HR_AUTHORIA_MAPPINGS	11	Authoria Mapping Information
HR_CALENDARS	11	Dated instances of a repeating pattern.
HR_CALENDAR_USAGES	12	Assignments of calendars to individual entities.
HR_CANVAS_PROPERTIES	46	Canvas properties for configurable forms
HR_COMMENTS	8	Central repository for comments.
HR_DE_LIABILITY_PREMIUMS_F	35	Holds Liability Insurance Providers Premium rates for the Organization
HR_DE_ORGANIZATION_LINKS	73	Holds extra information for Organizations links with External Orgs
HR_DE_SOC_INS_CONTR_LVLS_F	59	Holds German Social Insurance Contibution data
HR_DM_APPLICATION_GROUPS	11	Data Migrator locking ladder groups for applications.
HR_DM_COLUMN_DEFINITIONS	8	Column definitions for sequence range management
HR_DM_DATABASES	10	Table containing names of all databases within database farm
HR_DM_DT_DELETES	14	This table holds the information for the deletion of date tracked data. This table is also used to hold participant data information of dat
HR_DM_EXP_IMPS	108	This table holds the data from various tables in the source database that will be moved to the destination database using the transportable
HR_DM_GROUPS	9	This table holds information about the groupings used in the data migration process.
HR_DM_HIERARCHIES	14	This entity will contain the relationships between tables. The following relationship will be recorded:
HR_DM_LOADER_PARAMS	19	This entity contains the configuration data for the AOL loader files
HR_DM_LOADER_PHASE_ITEMS	26	This entity contains the migration specific configuration data for the AOL loader files.
HR_DM_MIGRATIONS	22	This table contains the data migration information. There is one row per migration in progress.
HR_DM_MIGRATION_RANGES	14	This table holds the allocated ranges for each slave process to process during each Download Application/Participant data phase of the migra
HR_DM_MIGRATION_REQUESTS	13	This table holds the information about the request id of the issuing concurrent program.
HR_DM_PHASES	12	This table holds the information about each phase of the migration process.
HR_DM_PHASE_ITEMS	16	This table details the work to be undertaken for each phase of the Data Migrator.
HR_DM_PHASE_RULES	12	This table contains the rules governing which phases apply to which migrations.
HR_DM_RESOLVE_PKS	11	This entity contains the values of the primary key for both the source and destination database for each table for use by the TUPS package.
HR_DM_SEQUENCE_DEFINITIONS	10	Table containing Sequence Name information for the PER/PAY/DT/FF/OTA/SSP/GHR/HXT/BEN applications.
HR_DM_SEQUENCE_HISTORIES	11	Table containing sequence information from the different Fidelity databases. To be updated before any changes to sequences are made to enabl
HR_DM_SEQUENCE_RANGES	11	Table containing Sequence Ranges for particular Sequence and Database. This table can hold multiple Ranges for a given Sequence and Databas
HR_DM_TABLES	34	This entity contains a HRMS table listing that will be processed by the data migrator.
HR_DM_TABLE_GROUPINGS	10	This entity holds the information for the grouping of tables.
HR_DOCUMENT_EXTRA_INFO	87	Documents of Record Information
HR_DOCUMENT_TYPES	20	Document Types for Documents od Record
HR_DOCUMENT_TYPES_TL	11	Translated Document Types for Documents of Record
HR_DU_COLUMN_MAPPINGS	13	This table holds the relationship between the column name used in the source object (e.g. the spreadsheet column) and the output target (e.g
HR_DU_DESCRIPTORS	12	This table holds the descriptor details for each API to be uploaded.
HR_DU_ERRORS	12	This table holds details about errors encountered during processing of a batch by any of the Data Uploader modules.
HR_DU_MODULES	13	This table holds the details about each module which can be used for either input, process or output with in the data Uploader.
HR_DU_UPLOADS	15	This table holds the data relating to information uploaded from a single source file.
HR_DU_UPLOAD_HEADERS	11	This table holds the details for each API to be uploaded.
HR_DU_UPLOAD_LINES	244	This table holds the details for each item to be uploaded with an item spanning one or more rows
HR_EFC_ACTIONS	14	Contains one row for each time the EFC conversion process or delete _EFC table data process is run.
HR_EFC_CURRENCY_HISTORIES	11	Contains one row per NCU currency as defined in FND_CURRENCIES at the time of the EFC processing with details of the NCU.
HR_EFC_PROCESS_COMPONENTS	12	Holds one row for each processing script in each conversion processing run.
HR_EFC_ROUNDING_ERRORS	11	Holds one row for each time a rounding error adjustment has been made.
HR_EFC_WORKERS	16	Holds one row for each parallel worker instance of a processing component.
HR_EFC_WORKER_AUDITS	10	Holds one row for each HR_EFC_WORKER row per currency code processed for update scripts only.
HR_EXCEPTION_USAGES	11	Identifies usage of defined exceptions to a repeating pattern.
HR_FORM_CANVASES_B	11	Canvas definition for configurable forms
HR_FORM_CANVASES_TL	11	Translated canvas definitions for configurable forms.
HR_FORM_DATA_GROUPS_B	11	Form data group definition for configurable forms
HR_FORM_DATA_GROUPS_TL	11	Translated form data group definitions for configurable forms
HR_FORM_DATA_GROUP_ITEMS	10	Links items with data groups for configurable forms
HR_FORM_ITEMS_B	18	Definition of items available for configurable forms
HR_FORM_ITEMS_TL	11	Translated definitions of form items for configurable forms
HR_FORM_PROPERTIES	43	Configurable properties for configurable forms modules
HR_FORM_TAB_PAGES_B	12	Definition of form tab page for configurable forms
HR_FORM_TAB_PAGES_TL	11	Translated definition of form tab page for configurable forms
HR_FORM_TAB_STACKED_CANVASES	10	Definition of stacked canvas for tab pages in configurable forms
HR_FORM_TEMPLATES_B	44	Definition of template used by configurable forms
HR_FORM_TEMPLATES_TL	11	Translated template definition for use in configurable forms
HR_FORM_WINDOWS_B	11	Definition of windows for use in configurable forms
HR_FORM_WINDOWS_TL	11	Translated definition of windows for configurable form
HR_H2PI_ADDRESSES	51	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to addresses while data upload is in pro
HR_H2PI_ASSIGNMENTS	112	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to assignments while data upload is in
HR_H2PI_BG_AND_GRE	9	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to bg_and_gre while data upload is in p
HR_H2PI_CITY_TAX_RULES	24	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to us employees city tax rules while da
HR_H2PI_COST_ALLOCATIONS	46	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to cost allocations s while data upload
HR_H2PI_COUNTY_TAX_RULES	23	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to us employee county tax rules while d
HR_H2PI_DATA_FEED_HIST	16	This table stores information about date feed history for Oracle HR to Oracle Payroll Interface (H2PI).
HR_H2PI_ELEMENT_ENTRIES	71	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to element entries while data upload is
HR_H2PI_ELEMENT_ENTRY_VALUES	10
HR_H2PI_ELEMENT_LINKS	14
HR_H2PI_ELEMENT_NAMES	7
HR_H2PI_ELEMENT_TYPES	10
HR_H2PI_EMPLOYEES	90	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to employees while data upload is in pro
HR_H2PI_FEDERAL_TAX_RULES	28
HR_H2PI_HR_ORGANIZATIONS	31
HR_H2PI_ID_MAPPING	10	This table stores information about ID mapping for Oracle HR to Oracle Payroll Interface (H2PI).
HR_H2PI_INPUT_VALUES	14
HR_H2PI_LOCATIONS	50	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to locations while data upload is in pr
HR_H2PI_MESSAGE_LINES	7	This table stores information about all the messages for Oracle HR to Oracle Payroll Interface (H2PI).
HR_H2PI_ORGANIZATION_CLASS	9
HR_H2PI_ORGANIZATION_INFO	27	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to organization info while data upload
HR_H2PI_ORG_PAYMENT_METHODS	12
HR_H2PI_PATCH_STATUS	6
HR_H2PI_PAYMENT_METHODS	68
HR_H2PI_PAYROLLS	11
HR_H2PI_PAY_BASES	7
HR_H2PI_PERIODS_OF_SERVICE	30
HR_H2PI_SALARIES	30
HR_H2PI_STATE_TAX_RULES	29
HR_H2PI_US_CITY_NAMES	8
HR_H2PI_US_MODIFIED_GEOCODES	11	This is staging table for the Oracle HR to Oracle Payroll Interface (H2PI) and stores data related to US midified geocodes while data uplo
HR_INCOMPATIBILITY_RULES	3	Incompatibility rules for navigation units.
HR_ITEM_CONTEXTS	43	Combinations table for the item context key flexfield ICX
HR_ITEM_PROPERTIES_B	77	Properties for form or template items used by configurable forms.
HR_ITEM_PROPERTIES_TL	14	Translatable properties of items for configurable forms
HR_JP_PARAMETERS	3	This table holds unique id for Japanese legislative specific data in order not to hard-code Multibyte characters in Japanese localization co
HR_KI_EXT_APPLICATIONS	8	This table holds the details of the KI integration external applications
HR_KI_SESSIONS	7
HR_LEGISLATION_INSTALLATIONS	11	Status of each product/legislation combination installed
HR_LOCATIONS_ALL	90	Work location definitions.
HR_LOCATIONS_ALL_TL	10	Translated location codes and descriptions.
HR_LOCATION_EXTRA_INFO	65	Extra information for a location.
HR_LOCATION_INFO_TYPES	16	Types of extra information that may be held against a Location.
HR_NAME_FORMATS	12	Contains the format masks used to determine the displayed formats of personal names in Applications. Oracle will seed rows in this table whi
HR_NAVIGATION_CONTEXT_RULES	5	Context specific rules for taskflow navigation.
HR_NAVIGATION_NODES	5	Taskflow node definitions.
HR_NAVIGATION_NODE_USAGES	5	Intersection table between HR_WORKFLOWS, HR_NAVIGATION_NODES and HR_NAVIGATION_PATHS.
HR_NAVIGATION_PATHS	7	Taskflow navigation path details.
HR_NAVIGATION_PATHS_TL	10
HR_NAVIGATION_UNITS	8	Information about potential navigation options in a taskflow.
HR_NAVIGATION_UNITS_TL	10	Translated fields for hr_navigation_units
HR_NAV_UNIT_GLOBAL_USAGES	6	Global variable usage by specific navigation unit. (Form or block).
HR_ORGANIZATION_INFORMATION	55	Additional attributes of an organization, dependent on class or organization information type.
HR_ORGANIZATION_INFORMATIO_EFC	6	This is a copy of theHR_ORGANIZATION_INFORMATION table which is populated by the EFC (Euro as Functional Currency) process.
HR_ORG_INFORMATION_TYPES	13	Information types that are used to add information for an organization.
HR_ORG_INFO_TYPES_BY_CLASS	10	Defines organization information types for specific organization classifications.
HR_PATTERNS	10	A repeating time pattern, eg a work pattern, SSP qualifying pattern or a resource schedule.
HR_PATTERN_BITS	11	A defined period of time used to construct a pattern.
HR_PATTERN_CONSTRUCTIONS	12	Decomposition of a repeating pattern into its individual 'bits' of time.
HR_PATTERN_EXCEPTIONS	12	An exception to a repeating pattern.
HR_PATTERN_PURPOSES	9	Potential purpose for the parent pattern, eg 'Work Pattern', 'Resource schedule', etc.
HR_PATTERN_PURPOSE_USAGES	10	Valid combinations of entities and pattern purposes.
HR_PERSON_DEPLOYMENTS	70	Record of cross-business group periods of work for an employee
HR_PERSON_DEPLYMT_CONTACTS	9	Contacts to recreate in new business group for deployed employees
HR_PERSON_DEPLYMT_EITS	9	Extra Information to recreate in new business group for deployed employees
HR_PTL_SUMMARY_DATA	57
HR_PUMP_BATCH_EXCEPTIONS	6	Holds data pump processing exception (error) information.
HR_PUMP_BATCH_HEADERS	11	Stores information on a batch to be loaded by the data pump.
HR_PUMP_BATCH_LINES	239	Each rows stores the information required to make an API call. OUT-parameter values are written back after the API call.
HR_PUMP_BATCH_LINE_USER_KEYS	9	User keys and their associated information is stored here on the creation of entities that require user keys.
HR_PUMP_DEFAULT_EXCEPTIONS	8	Lists API modules that do not conform to the API parameter defaulting rules.
HR_PUMP_MAPPING_PACKAGES	11	Lists PL/SQL packages that contain the parameter mapping functions used by data pump generated code. If module_package and module_name are b
HR_PUMP_MODULE_PARAMETERS	12	Holds seeded information about API parameters for data pump code generation.
HR_PUMP_RANGES	5	Controls the parallelisation of the work when the data pump is running on multiprocessor platforms.
HR_PUMP_REQUESTS	3	Holds information on data pump concurrent requests currently running.
HR_QUESTIONNAIRES	12	Questionnaires used within SSHR.
HR_QUEST_ANSWERS	10	Answers for a questionnaire.
HR_QUEST_ANSWER_VALUES	10	Answer values for a questionnaire.
HR_QUEST_FIELDS	16	Fields of a questionnaire.
HR_SOFT_CODING_KEYFLEX	46	Legislation specific information for payrolls, organizations and assignments.
HR_SOURCE_FORM_TEMPLATES	10	Identities of templates which have been copied and the resulting copy. Helps distinguish seeded templates from copied ones.
HR_STU_EXCEPTIONS	4	Error conditions from the startup data process.
HR_STU_HISTORY	6	Versions of HRMS Startup data installed
HR_SUMMARY	25	HR_SUMMARY holds all data for the Generic Summary Process.
HR_SUMMARY_EFC	4	This is a copy of the HR_SUMMARY table which is populated by the EFC (Euro as Functional Currency) process.
HR_S_APPLICATION_OWNERSHIPS	3	- Retrofitted
HR_S_ASSIGNMENT_INFO_TYPES	15	- Retrofitted
HR_S_ASSIGNMENT_STATUS_TYPES	14	- Retrofitted
HR_S_BALANCE_CATEGORIES_F	45
HR_S_BALANCE_CLASSIFICATIONS	13	- Retrofitted
HR_S_BALANCE_DIMENSIONS	20	- Retrofitted
HR_S_BALANCE_FEEDS_F	17	- Retrofitted
HR_S_BALANCE_TYPES	43	- Retrofitted
HR_S_BENEFIT_CLASSIFICATIONS	20	- Retrofitted
HR_S_COBRA_QFYING_EVENTS_F	14	- Retrofitted
HR_S_COMMON_LOOKUPS	29	- Retrofitted
HR_S_COMMON_LOOKUP_TYPES	9	- Retrofitted
HR_S_CONTEXTS	4	- Retrofitted
HR_S_DATABASE_ITEMS	11	- Retrofitted
HR_S_DEFINED_BALANCES	16	- Retrofitted
HR_S_DIMENSION_ROUTES	13	-Retrofitted
HR_S_ELEMENT_CLASSIFICATIONS	23	- Retrofitted
HR_S_ELEMENT_SETS	11	- Retrofitted
HR_S_ELEMENT_TYPES_F	96	- Retrofitted
HR_S_ELEMENT_TYPE_RULES	8	- Retrofitted
HR_S_ELE_CLASSN_RULES	7	- Retrofitted
HR_S_FORMULAS_F	16	- Retrofitted
HR_S_FORMULA_RESULT_RULES_F	18	- Retrofitted
HR_S_FORMULA_TYPES	8	- Retrofitted
HR_S_FTYPE_CONTEXT_USAGES	2	- Retrofitted
HR_S_FUNCTIONS	14	- Retrofitted
HR_S_FUNCTION_CONTEXT_USAGES	8	- Retrofitted
HR_S_FUNCTION_PARAMETERS	12	- Retrofitted
HR_S_GLOBALS_F	14	- Retrofitted
HR_S_HISTORY	5	- Retrofitted
HR_S_INPUT_VALUES_F	28	- Retrofitted
HR_S_LEGISLATION_RULES	3	- Retrofitted
HR_S_LEGISLATION_SUBGROUPS	4	- Retrofitted
HR_S_LEGISLATIVE_FIELD_INFO	13	- Retrofitted
HR_S_LOOKUP_TYPE_USAGES	8	- Retrofitted
HR_S_MAGNETIC_BLOCKS	6
HR_S_MAGNETIC_RECORDS	7
HR_S_MONETARY_UNITS	12	- Retrofitted
HR_S_ORG_INFORMATION_TYPES	12	- Retrofitted
HR_S_ORG_INFO_TYPES_BY_CLASS	9	- Retrofitted
HR_S_PAYMENT_TYPES	17	- Retrofitted
HR_S_QP_REPORTS	14	- Retrofitted
HR_S_REPORT_FORMAT_ITEMS_F	16
HR_S_REPORT_FORMAT_MAPPINGS_F	25
HR_S_REPORT_LOOKUPS	9
HR_S_ROUTES	11	- Retrofitted
HR_S_ROUTE_CONTEXT_USAGES	3	- Retrofitted
HR_S_ROUTE_PARAMETERS	5	- Retrofitted
HR_S_ROUTE_PARAMETER_VALUES	8	- Retrofitted
HR_S_STATE_RULES	13	- Retrofitted
HR_S_STATUS_PROCESSING_RULES_F	17	- Retrofitted
HR_S_SUB_CLASSN_RULES_F	13	- Retrofitted
HR_S_TAXABILITY_RULES	13	- Retrofitted
HR_S_USER_COLUMNS	13	- Retrofitted
HR_S_USER_COLUMN_INSTANCES_F	15	- Retrofitted
HR_S_USER_ENTITIES	14	- Retrofitted
HR_S_USER_ROWS_F	16	- Retrofitted
HR_S_USER_TABLES	14	- Retrofitted
HR_S_US_CITY_GEOCODES	3
HR_S_US_CITY_NAMES	11	US cities and their VERTEX geocodes, used to validate US addresses.
HR_S_US_CITY_SCHOOL_DSTS	5
HR_S_US_CITY_TAX_INFO_F	68	Element definitions.
HR_S_US_COUNTY_TAX_INFO_F	68	Element definitions.
HR_S_US_FEDERAL_TAX_INFO_F	72	Element definitions.
HR_S_US_GARN_FEE_RULES_F	18
HR_S_US_STATE_TAX_INFO_F	72	Element definitions.
HR_S_US_ZIP_CODES	5	Valid zip code ranges for VERTEX cities, used to validate US addresses.
HR_S_VALID_DEPENDENT_TYPES	11	- Retrofitted
HR_S_WC_STATE_SURCHARGES	11	- Retrofitted
HR_TAB_PAGE_PROPERTIES_B	43	Properties of tab pages for configurable forms
HR_TAB_PAGE_PROPERTIES_TL	10	Translated properties of tab pages for configurable forms
HR_TEMPLATE_CANVASES_B	10	Definition of canvases on template for configurable forms
HR_TEMPLATE_DATA_GROUPS	10	Definition for data group on template for configurable forms
HR_TEMPLATE_ITEMS_B	10	Definition of items on template for configurable forms
HR_TEMPLATE_ITEM_CONTEXTS_B	11	Definition of items on a template for given context, for configurable forms
HR_TEMPLATE_ITEM_CONTEXT_PAGES	10	Information about which tab pages item belongs to for a specific context, on template for configurable form.
HR_TEMPLATE_ITEM_TAB_PAGES	10	Information about which tab pages item belongs to on template for configurable form.
HR_TEMPLATE_TAB_PAGES_B	10	Definition of tab page for template, for configurable forms
HR_TEMPLATE_WINDOWS_B	10	Definition of window for a template, for configurable forms
HR_TIPS	8	Help components used within SSHR.
HR_WINDOW_PROPERTIES_B	44	Properties of windows for configurable forms
HR_WINDOW_PROPERTIES_TL	10	Translated properties of windows for configurable forms
HR_WIP_LOCKS	13	Stores context lock for a transaction
HR_WIP_TRANSACTIONS	15	Stores the transaction information and state
HR_WORKFLOWS	4	Taskflows in Oracle HRMS.
HR_WORKING_PERSON_LISTS	7	Holds a list of people who constitute a user current list, used in the Line Manager Web pages
IRC_AGENCY_VACANCIES	44
IRC_ALL_RECRUITING_SITES	55	This table currently stores a list of all of the third parties which you have agreements with to send adverts to. In future it may be expand
IRC_ALL_RECRUITING_SITES_TL	7	Contains the tranlated versions of the recruiting sites.
IRC_ASSIGNMENT_DETAILS_F	15	iRecruitment specific additional assignment details.
IRC_ASSIGNMENT_STATUSES	13	Stored assignment statuses for a particular applicant assignment.
IRC_DEFAULT_POSTINGS	41	Stores a library of postings, each mapped to one of a position, a job or an organization.
IRC_DEFAULT_POSTINGS_TL	13	Contains the tranlated versions of the default postings.
IRC_DOCUMENTS	19	Stores documents that a registered user wishes to store on the database. Examples include resumes and cover letters.
IRC_JOB_BASKET_ITEMS	10	The jobs that an applicant has placed in their job basket
IRC_LOCATION_CRITERIA_VALUES	9	The Locations the Candidate has saved as part of Job Searches
IRC_NOTES	9	IRC Offer Notes Table
IRC_NOTIFICATION_PREFERENCES	47	Stores an applicants preferences to do with being contacted by the customer.
IRC_OFFERS	57	Table to maintain details of iRecruitment Offers
IRC_OFFER_STATUS_HISTORY	12	Table to maintain history of offers statuses
IRC_PENDING_DATA	56	Stores User applications created on High Availability instance
IRC_POSTING_CONTENTS	78	Stores the actual content of a posting in a table where it can be reused.
IRC_POSTING_CONTENTS_TL	15	Stores the translation content of the advert.
IRC_PROF_AREA_CRITERIA_VALUES	9	The Professional Area saved by the Candidate as part of Job Searches
IRC_REC_TEAM_MEMBERS	16	Stores the list of people who are working on a particular vacancy
IRC_REFERENCES	11	Not currently used.
IRC_SEARCH_CRITERIA	100	Contains job matching preferences and saved advanced search criteria
IRC_TEMPLATE_ASSOCIATIONS	14	Offer Template Association table
IRC_VACANCY_CONSIDERATIONS	11	This table holds the consideration of a Manager or a Recruiter a candidate in the pool and their Vacancy
IRC_VAC_ALLOWED_STATUS_TYPES	10	Stores the recruiting statuses that are valid for a particular vacancy, and the sequence that it should be used in.
IRC_VARIABLE_COMP_ELEMENTS	8	Variable compensation element data. This data is utilized for display purposes only.
PER_ABSENCE_ATTENDANCES	97	Records of absence, or attendance for an employee.
PER_ABSENCE_ATTENDANCES_EFC	8	This is a copy of the PER_ABSENCE_ATTENDANCES table which is populated by the EFC (Euro as Functional Currency) process.
PER_ABSENCE_ATTENDANCE_TYPES	66	User defined absence types.
PER_ABSENCE_CASES	75	This table is to store the Details of Absence Cases. Absence Case is a collection of Absences of an Employee grouped manually based on some
PER_ABS_ATTENDANCE_REASONS	13	Valid absence reasons for an absence type.
PER_ABS_ATTENDANCE_TYPES_TL	9	Holds translated information for Absence Types
PER_ADDRESSES	63	Address information for people.
PER_ALLOCATED_CHECKLISTS	55	Allocated Checklists
PER_ALLOCATED_TASKS	63	Allocated Tasks
PER_ALL_ASSIGNMENTS_F	116	Employee and applicant assignment details.
PER_ALL_PEOPLE_F	152	DateTracked table holding personal information for employees, applicants and other people.
PER_ALL_POSITIONS	61	Dual-maintained position definition information.
PER_ALL_VACANCIES	56	Vacancies within a specific requisition.
PER_ANALYSIS_CRITERIA	46	Flexfield combination table for the personal analysis key flexfield.
PER_APPLICATIONS	41	Applications for employment.
PER_APPRAISALS	75	An appraisal is a record of an evaluation of a person by others.
PER_APPRAISAL_PERIODS	52	This table holds planned appraisal periods, defined as part of the performance management plan.
PER_APPRAISAL_TEMPLATES	66	The heading or grouping of appraisal questions.
PER_ASSESSMENTS	42	The grouping of a set of assessment elements.
PER_ASSESSMENT_GROUPS	32	Grouping of People for 360 reviews
PER_ASSESSMENT_TYPES	48	The definition of an assessment template
PER_ASSIGNMENT_BUDGET_VALUES_F	17	Budget values for an assignment.
PER_ASSIGNMENT_BUDGET_VALU_EFC	6	This is a copy of the PER_ASSIGNMENT_BUDGET_VALUES_F table which is populated by the EFC (Euro as Functional Currency) process.
PER_ASSIGNMENT_EXTRA_INFO	65	Extra information for an assignment.
PER_ASSIGNMENT_EXTRA_INFO_EFC	33	This is a copy of the PER_ASSIGNMENT_EXTRA_INFO table which is populated by the EFC (Euro as Functional Currency) process.
PER_ASSIGNMENT_INFO_TYPES	16	Types of extra information that may be held against an assignment.
PER_ASSIGNMENT_INFO_TYPES_TL	10	Translated types of extra information that may be held against an assignment.
PER_ASSIGNMENT_LIST	8	List of assignments that a secure user can access.
PER_ASSIGNMENT_STATUS_TYPES	15	Predefined and user defined assignment status types.
PER_ASSIGNMENT_STATUS_TYPES_TL	11	Predefined and user defined translated assignment status types.
PER_ASSIGN_PROPOSAL_ANSWERS	14	Web Candidate Offer Answers
PER_ASS_STATUS_TYPE_AMENDS	14	User amendments to predefined assignment status types.
PER_ASS_STATUS_TYPE_AMENDS_TL	10	Translated user amendments to predefined assignment status types.
PER_BEN_IDENTIFIED_EVENTS	12
PER_BF_BALANCE_AMOUNTS	47	Holds assignment level run amount and summary values for backfeed balances by payroll processing period
PER_BF_BALANCE_AMOUNTS_EFC	10
PER_BF_BALANCE_TYPES	16	Types of balances that can be held
PER_BF_BALANCE_TYPES_EFC	3
PER_BF_PAYMENT_DETAILS	45	Holds details of payments that have been processed by a 3rd party payroll provider, by assignment.
PER_BF_PAYMENT_DETAILS_EFC	4
PER_BF_PAYROLL_RUNS	44	Payrolls processed by 3rd party payroll provider.
PER_BF_PROCESSED_ASSIGNMENTS	40	Intersection table storing details of assignments that have been processed by a 3rd party payroll provider in each payroll run
PER_BOOKINGS	36	Event booking details.
PER_BUDGETS	37	Definitions of HR budgets.
PER_BUDGET_ELEMENTS	19	Combinations of organization, grade, job, and position used to define detailed budget values.
PER_BUDGET_VALUES	76	Planned HR budget values for specific budget elements.
PER_BUDGET_VALUES_EFC	5	This is a copy of the PER_BUDGET_VALUES table which is populated by the EFC (Euro as Functional Currency) process.
PER_BUDGET_VERSIONS	37	Identifies specific versions of an HR budget.
PER_CAGR_APIS	10
PER_CAGR_APIS_TL	10
PER_CAGR_API_PARAMETERS	17
PER_CAGR_API_PARAMETERS_TL	10
PER_CAGR_ENTITLEMENTS	16
PER_CAGR_ENTITLEMENT_ITEMS	26
PER_CAGR_ENTITLEMENT_ITEMS_TL	10
PER_CAGR_ENTITLEMENT_LINES_F	22
PER_CAGR_ENTITLEMENT_RESULTS	41
PER_CAGR_GRADES	10	The reference collectively agreed grades for a Collective Agreement.
PER_CAGR_GRADES_DEF	32	Collective agreement grades key flexfield combinations table.
PER_CAGR_GRADE_STRUCTURES	31	The valid collectively agreed grade key flexfield structures for a particular collective agreement
PER_CAGR_LOG	9
PER_CAGR_REQUESTS	14
PER_CAGR_RETAINED_RIGHTS	38
PER_CALENDAR_ENTRIES	24	Calendar Entries
PER_CAL_ENTRY_GEO_LIST	8	Calendar Entry Geo Coverage Cache
PER_CAL_ENTRY_ORG_LIST	8	Calendar Entry Org Coverage Cache
PER_CAL_ENTRY_VALUES	18	Calendar Entry Values
PER_CAL_MAP_CACHE	15	Calendar Entry to Person Assignment Mapping Cache
PER_CAREER_PATHS	34	List of career paths for jobs.
PER_CAREER_PATH_ELEMENTS	14	Progression paths for specific jobs.
PER_CA_EE_REPORT_LINES	33
PER_CHECKLISTS	54
PER_CHECKLIST_ITEMS	44	Checklist information.
PER_COBRA_COVERAGE_BENEFITS_F	35	Details of a benefit that the employee accepts or rejects as part of their COBRA coverage.
PER_COBRA_COVERAGE_PERIODS	12	Holds coverage periods for COBRA qualifying events.
PER_COBRA_COVERAGE_STATUSES	32	Tracks the status of a COBRA enrollment.
PER_COBRA_COV_ENROLLMENTS	38	Enrollments for people who are eligible for continued benefit coverage under COBRA.
PER_COBRA_DEPENDENTS_F	32	Holds employee dependents coverage for a COBRA qualifying event.
PER_COBRA_QFYING_EVENTS_F	14	Events that have meaning in the context of COBRA coverage, e.g. Divorce, Termination, Death etc.
PER_COLLECTIVE_AGREEMENTS	64	Collective agreement information.
PER_COMPETENCES	74	A competence is a definition of knowledge, skills, abilities or other charactaristics that a person may possess.
PER_COMPETENCES_TL	12	This table is used for language translations
PER_COMPETENCE_DEFINITIONS	45	COMPETENCES Key flexfield combinations table
PER_COMPETENCE_ELEMENTS	91	A competence element is used to record an individual competence and an evaluation rating.
PER_COMPETENCE_OUTCOMES	55	Competence outcomes
PER_COMP_ELEMENT_OUTCOMES	53	The outcomes achieved towards a given Competency .
PER_CONTACT_EXTRA_INFO_F	67	Extra information for a contact relationship.
PER_CONTACT_INFO_TYPES	15	Types of extra information that may be held against a contact relationship.
PER_CONTACT_INFO_TYPES_TL	10	Translated types of extra information that may be held against a contact relationship.
PER_CONTACT_RELATIONSHIPS	71	Contacts and relationship details for dependents, beneficiaries, emergency contacts, parents etc.
PER_CONTRACTS_F	70	The details of a persons contract of employment
PER_CPN_DATA_UPGRADE	2	Used to log errors / warnings during the conversion of competences to a key flex structure.
PER_DEPLOYMENT_FACTORS	60	A factor affecting a person's capacity to be deployed within an organization.
PER_DISABILITIES_F	87	Hold Disability information for one person
PER_ELECTIONS	77	Holds election related information.
PER_ELECTION_CANDIDATES	75	Holds information of Election candidates.
PER_ELECTION_CONSTITUENCYS	41	This table holds information related to constituencies participating in the election.
PER_EMPDIR_ASSIGNMENTS	60
PER_EMPDIR_JOBS	38
PER_EMPDIR_LOCATIONS	35
PER_EMPDIR_LOCATIONS_TL	16
PER_EMPDIR_ORGANIZATIONS	42
PER_EMPDIR_PEOPLE	104
PER_EMPDIR_PHONES	20
PER_EMPDIR_POSITIONS	41
PER_ESTABLISHMENTS	52	This entity is used to maintain a list of educational establishments e.g. schools, colleges, universities, etc.
PER_ESTABLISHMENT_ATTENDANCES	37	A record of educational establishments that a person is currently attending or has previously attended.
PER_EVENTS	48	Record of events such as interviews and appraisals for applicants and employees.
PER_FORM_FUNCTIONS	6	Navigation and person change information for the Enter Person information screens.
PER_GENERIC_REPORT_OUTPUT	3	Text lines for output by a generic report script, including: title, header, footer and body lines.
PER_GEN_HIERARCHY	77
PER_GEN_HIERARCHY_NODES	81
PER_GEN_HIERARCHY_VERSIONS	81
PER_GEN_HIER_NODE_TYPES	14
PER_GRADES	61	Grade definitions for a business group.
PER_GRADES_TL	9	Trnslated fields for per_grades
PER_GRADE_DEFINITIONS	46	Grade key flexfield combinations table.
PER_GRADE_SPINES_F	18	Stores the progression points for each grade scale.
PER_HTML_TOOLKIT_REC_TYPES	14	Default values for the HR html toolkit.
PER_IMAGES	4	Images for a designated row in a designated table.
PER_INFO_TYPE_SECURITY	12	Cross table between Responsibilty and Info_type tables, used to secure info types based on responsibility.
PER_INTERIM_ENTITY_LIST	7
PER_JOBS	64	Jobs defined for a Business Group.
PER_JOBS_TL	9	Translated columns for per_jobs
PER_JOB_DEFINITIONS	45	Job key flexfield combinations table.
PER_JOB_EVALUATIONS	39	Job evaluation details for specific jobs or positions.
PER_JOB_EXTRA_INFO	65	Extra information for a job.
PER_JOB_GROUPS	13	Holds Job Group Information. Each Job will be a member of a Job Group and a Job Group can optionally be within a business group.
PER_JOB_INFO_TYPES	16	Types of extra information that may be held against a job.
PER_JOB_REQUIREMENTS	40	Requirements for specific jobs or positions. For example, skills, qualifications, experience, training.
PER_JP_ADDRESS_LOOKUPS	9	Lookups for Japanese Addresses
PER_JP_POSTAL_CODES	9	Lookups for Japanese postal codes and districts
PER_JP_SCHOOL_LOOKUPS	10	Lookups for Japanese Educational Institutions
PER_KR_ADDRESSES	17	KR specific
PER_KR_GRADES	13	KR specific
PER_KR_GRADE_AMOUNT_F	42	KR specific
PER_KR_G_POINTS	13	KR specific
PER_KR_G_POINT_AMOUNT_F	42	KR specific
PER_LETTER_GEN_STATUSES	14	Associations between letter types and possible status type changes.
PER_LETTER_REQUESTS	18	Requests for specific types of standard letter.
PER_LETTER_REQUEST_LINES	21	Details of individual letter requests.
PER_LETTER_TYPES	36	Letter types and auto-request definitions.
PER_MASS_MOVES	13	High level mass move definition.
PER_MEDICAL_ASSESSMENTS	79	Hold Medical Assessment information for one person
PER_MM_ASSIGNMENTS	14	PER_MM_ASSIGNMENTS holds assignments that were defined as part of a mass move.
PER_MM_JOB_REQUIREMENTS	39	PER_MM_JOB_REQUIREMENTS holds data related to transferring position requirements to a newly created position.
PER_MM_POSITIONS	45	PER_MM_POSITIONS holds positions that were defined as part of a mass move.
PER_MM_VALID_GRADES	29	PER_MM_VALID_GRADES holds valid grades that will be moved with a position during a mass move.
PER_NL_ABSENCE_ACTIONS	18	Dutch Specific Absence Actions
PER_NL_ABSENCE_CHANGES	8	Dutch Specific Absence Changes
PER_NL_ASG_SCL_UPGRADE	7	Records the Dutch Assignment SCL Context Information Migrated used by the Report
PER_NUMBER_GENERATION_CONTROLS	8	PER_NUMBER_GENERATION_CONTROLS holds the numbers that are automatically generated for a Business Group.
PER_OBJECTIVES	67	A target or goal which may be evaluated during an appraisal.
PER_OBJECTIVES_LIBRARY	57	This table holds a library of objectives - objectives that are well written, SMART and re-usable.
PER_ORGANIZATION_LIST	7	List of organizations that a secure user can access.
PER_ORGANIZATION_STRUCTURES	37	Organization hierarchy names.
PER_ORG_STRUCTURE_ELEMENTS	17	Organization hierarchy details showing parent-child reporting relationships between organizations.
PER_ORG_STRUCTURE_VERSIONS	18	Version control information for specific organization hierarchies.
PER_PARENT_SPINES	69	Details of pay scales, (previously known as parent spines).
PER_PARTICIPANTS	40	A person participating in an appraisal or assessment.
PER_PAY_BASES	59	Definitions of specific salary bases.
PER_PAY_PROPOSALS	46	Salary proposals and performance review information for employee assignments.
PER_PAY_PROPOSALS_EFC	4	This is a copy of the PER_PAY_PROPOSALS table which is populated by the EFC (Euro as Functional Currency) process.
PER_PEOPLE_EXTRA_INFO	66	Extra information for a person.
PER_PEOPLE_INFO_TYPES	16	The table holds the definitions of extra information types that may be held against a person.
PER_PERFORMANCE_RATINGS	34	A single evaluation of an objective.
PER_PERFORMANCE_REVIEWS	43	Performance review information for employees.
PER_PERF_MGMT_PLANS	70	This table holds Performance Management Plans - a plan that controls and automates goal setting and performance management by defining the t
PER_PERIODS_OF_PLACEMENT	77	Periods of placement details for a non-payrolled worker
PER_PERIODS_OF_SERVICE	78	Period of service details for an employee.
PER_PERIODS_OF_SERVICE_EFC	4	This is a copy of the PER_PERIODS_OF_SERVICE table which is populated by the EFC (Euro as Functional Currency) process.
PER_PERSONAL_SCORECARDS	52	This table holds Personal Scorecards - one worker's objectives for one particular performance management plan, which provides a goal setting
PER_PERSON_ANALYSES	40	Special information types for a person.
PER_PERSON_DLVRY_METHODS	37	The communication delivery method for a person.
PER_PERSON_LIST	7	List of people that a secure user can access.
PER_PERSON_LIST_CHANGES	8	List of people that are to be added to current PER_PERSON_LIST.
PER_PERSON_LIST_CHG_ARCH	8	Archive table to hold content of PER_PERSON_LIST_CHANGES on upgrade.
PER_PERSON_LIST_STAGE	7
PER_PERSON_TYPES	13	Person types visible to specific Business Groups.
PER_PERSON_TYPES_TL	10	Translated person types information.
PER_PERSON_TYPE_USAGES_F	46	Identifies the types a person may be.
PER_PHONES	46	PER_PHONES holds phone numbers for current and ex-employees, current and ex-applicants and employee contacts.
PER_POSITION_DEFINITIONS	41	Combinations of segments stored in the PER_POSTIONS table.
PER_POSITION_EXTRA_INFO	65	Extra information for a position.
PER_POSITION_INFO_TYPES	16	Types of extra information that may be held against a position.
PER_POSITION_LIST	7	List of positions that a secure user can access.
PER_POSITION_STRUCTURES	36	Position Hierarchy names.
PER_POS_STRUCTURE_ELEMENTS	15	Position hierarchy details showing parent-child reporting relationships between positions.
PER_POS_STRUCTURE_VERSIONS	17	Version control information for specific position hierarchies.
PER_PREVIOUS_EMPLOYERS	84
PER_PREVIOUS_JOBS	79	Used to store Previous Jobs
PER_PREVIOUS_JOB_USAGES	57	Used to store previous job Usages
PER_PREV_JOB_EXTRA_INFO	71	Previous Jobs extra info
PER_PREV_JOB_INFO_TYPES	12	Used to store previous job info types
PER_PROPOSAL_CATEGORY_MEMBERS	13	Web Offers profile categories of questions
PER_PROPOSAL_CATEGORY_TYPES	12	Generic web offer category definitions
PER_PROPOSAL_OFFER_PARAGRAPHS	7	Web Offer letter text
PER_PROPOSAL_QUESTIONS_ADV	13	Web Offer advanced questions
PER_PROPOSAL_QUESTION_MEMBERS	23	Web offer profile questions
PER_PROPOSAL_QUESTION_TYPES	24	Generic web offer questions
PER_PROPOSAL_TEMPLATES	9	- Retrofitted
PER_PTU_DFF_MAPPING_HEADERS	12	Table for storing DFF migration mapping Information from PER_ALL_PEOPLE_F to PER_PERSON_TYPE_USAGES_F.
PER_PTU_DFF_MAPPING_LINES	13	Table for storing DFF migration mapping Information from PER_ALL_PEOPLE_F to PER_PERSON_TYPE_USAGES_F.
PER_PTU_DFF_MIG_FAILED_PEOPLE	10	This table is used to store the details of the person records failed to migrate to PER_PERSON_TYPE_USAGES_F from PER_ALL_PEOPLE_F.
PER_QUALIFICATIONS	78	A record of educational qualification, certificates, licenses, etc that a person holds or is acquiring.
PER_QUALIFICATIONS_EFC	4	This is a copy of the PER_QUALIFICATIONS table which is populated by the EFC (Euro as Functional Currency) process.
PER_QUALIFICATIONS_TL	16	Translated qualification details.
PER_QUALIFICATION_TYPES	73	Maintains the list of qualiification types that can be attained.
PER_QUALIFICATION_TYPES_TL	10	Maintains the list of qualiification type translations
PER_QUERY_CRITERIA	7	Used to store criteria to build up a query
PER_QUICKPAINT_INVOCATIONS	11	Identifies QuickPaint report runs.
PER_QUICKPAINT_RESULT_TEXT	9	Text description for the result of a single QuickPaint run.
PER_RATING_LEVELS	34	A rating scale step is a single point on a rating scale and is used to rate competences.
PER_RATING_LEVELS_TL	10	A rating scale step is a single point on a rating scale and is used to rate competences.
PER_RATING_SCALES	35	A scale used to rate compentencies.
PER_RATING_SCALES_TL	10	Translated rating scale name and description.
PER_RECRUITMENT_ACTIVITIES	55	Recruitment activities and costs.
PER_RECRUITMENT_ACTIVITIES_EFC	5	This is a copy of the PER_RECRUITMENT_ACTIVITIES table which is populated by the EFC (Euro as Functional Currency) process.
PER_RECRUITMENT_ACTIVITY_FOR	14	Vacancies associated with a specific recruitment activity.
PER_REQUISITIONS	39	Vacancy requisition details.
PER_RI_CONFIGURATIONS	10	This table stores information about configurations created by the users including the name,description and status of the configuration
PER_RI_CONFIGURATIONS_TL	11	This is the Translation Table for the PER_RI_CONFIGURATIONS table
PER_RI_CONFIG_DEFAULTS	8	This table store the default values for the parameters which needs to be passed in the PL/SQL APIs calls to insert rows into datapump batch
PER_RI_CONFIG_INFORMATION	41	To Store Input Values Specified by the user in Rapid Implementation Configuration Wizard
PER_RI_CONFIG_LOCATIONS	33	This stores locations information specified by the user in the Organization Structures Configuration wizard (configurations) it is required
PER_RI_DEPENDENCIES	9	Dependencies among Workbench tasks
PER_RI_REQUESTS	10	Concurrent requests for workbench componenets
PER_RI_RT_GEN	8	TestSuite Generator Request Details
PER_RI_SETUP_SUB_TASKS	17	Workbench setup sub-tasks
PER_RI_SETUP_SUB_TASKS_TL	11	TL table for PER_RI_SETUP_SUB_TASKS
PER_RI_SETUP_TASKS	15	Workbench Setup Tasks
PER_RI_SETUP_TASKS_TL	11	TL table for PER_RI_SETUP_TASKS table
PER_RI_VIEW_REPORTS	15	Stores data related to view reports for HRMS
PER_RI_VIEW_REPORTS_TL	11	Workbench View Reports Translation Table
PER_RI_WORKBENCH_ITEMS	13	Workbench items
PER_RI_WORKBENCH_ITEMS_TL	11	Translation table for Per_ri_workbench_items
PER_ROLES	60	Holds the different roles that a person performs.
PER_SALARY_SURVEYS	33	Market salary survey information.
PER_SALARY_SURVEY_LINES	84	Details for market salary surveys.
PER_SALARY_SURVEY_LINES_EFC	36	This is a copy of the PER_SALARY_SURVEY_LINES table which is populated by the EFC (Euro as Functional Currency) process.
PER_SALARY_SURVEY_MAPPINGS	36	Mapping information for a salary survey line.
PER_SCHED_COBRA_PAYMENTS	35	Payment schedules for benefits provided by a COBRA coverage.
PER_SCORECARD_SHARING	40	This table holds access permisssions for what people can access which scorecard.
PER_SECONDARY_ASS_STATUSES	38	Secondary assignment statuses used for information and reporting.
PER_SECURITY_ORGANIZATIONS	10	List of organizations to include or exclude from security list
PER_SECURITY_PROFILES	42	Security profile definitions to restrict user access to specific HRMS records.
PER_SECURITY_USERS	10	List of users for a security profile whose access permissions will be stored in static lists duringSecurity List Maintenance.
PER_SEC_PROFILE_ASSIGNMENTS	15	Security profile assignments for User, Responsibility and Business Group.
PER_SHARED_TYPES	44	Holds 'type' and 'status' information.
PER_SHARED_TYPES_TL	10	Translated information for shared types.
PER_SPECIAL_INFO_TYPES	36	Special information types available to a Business Group.
PER_SPECIAL_INFO_TYPE_USAGES	7	Limits usage of special information types to specific windows.
PER_SPINAL_POINTS	46	List of progression points in a pay scale.
PER_SPINAL_POINT_PLACEMENTS_F	51	Details of assignment placements to a grade step and point.
PER_SPINAL_POINT_STEPS_F	48	Grade steps defined in a specific grade scale and their incremental order.
PER_STANDARD_HOLIDAYS	37	Statutory Holiday information.
PER_STARTUP_PERSON_TYPES_TL	15	Predefined list of translated person types.
PER_STD_HOLIDAY_ABSENCES	35	Records when Statutory Holidays are taken.
PER_SUBJECTS_TAKEN	56	Holds a record of a person's subject usages for a qualification
PER_SUBJECTS_TAKEN_TL	9	Translated grade_attained.
PER_SUCCESSION_PLANNING	43	The record of a person's proposed succession to a position.
PER_TASKS_IN_CHECKLIST	60
PER_TIME_PERIODS	80	Time period definitions for payroll processing and HR budget calendars.
PER_TIME_PERIOD_RULES	10	Rules for time periods used by the system.
PER_TIME_PERIOD_SETS	39	Specific dates for a defined calendar.
PER_TIME_PERIOD_TYPES	37	Predefined list of valid period types for payroll and HR budget calendars.
PER_TIME_PERIOD_TYPES_TL	11	Predefined list of translated period types for payroll and HR budget calendars.
PER_VALID_GRADES	39	Lists valid grades for jobs and positions.
PER_WORK_INCIDENTS	125	Holds information on Incidents that happen at work or en route to work, for example, an industrial accident
PER_WORK_INCIDENTS_EFC	4	This is a copy of the PER_WORK_INCIDENTS table which is populated by the EFC (Euro as Functional Currency) process.
PER_ZA_AREAS_OF_ASSESSMENT	10	Table to store the Areas of assessment per NQF Assessment
PER_ZA_ASSESSMENTS	26	Table to store the NQF Assessment info for a person
PER_ZA_EMPLOYMENT_EQUITY	18	Temporary table for Employment Equity Reporting
PER_ZA_FORMAL_QUALIFICATIONS	11	Table to store additional NQF Qualification info for a person
PER_ZA_LEARNERSHIP_AGREEMENTS	20	Table to store the NQF learnership agreement info between a person and the organization
PER_ZA_QUALIFICATION_TYPES	7	Table to link qualification types (titles) to NQF qualification types
PER_ZA_TRAINING	15	Table to store NQF Training info for a person