HR_PUMP_MAPPING_PACKAGES | 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 be used by all APIs. |
HR_PUMP_MODULE_PARAMETERS | Holds seeded information about API parameters for data pump code generation. |
HR_PUMP_RANGES | Controls the parallelisation of the work when the data pump is running on multiprocessor platforms. |
HR_PUMP_REQUESTS | Holds information on data pump concurrent requests currently running. |
HR_QUESTIONNAIRES | Questionnaires used within SSHR. |
HR_QUEST_ANSWERS | Answers for a questionnaire. |
HR_QUEST_ANSWER_VALUES | Answer values for a questionnaire. |
HR_QUEST_FIELDS | Fields of a questionnaire. |
HR_SOFT_CODING_KEYFLEX | Legislation specific information for payrolls, organizations and assignments. |
HR_SOURCE_FORM_TEMPLATES | Identities of templates which have been copied and the resulting 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. |
HR_SUMMARY_EFC | This is a copy of the HR_SUMMARY table which is populated by the EFC (Euro as Functional Currency) process. |
HR_S_MAGNETIC_BLOCKS | |
HR_S_MAGNETIC_RECORDS | |
HR_S_US_CITY_GEOCODES | |
HR_S_US_CITY_NAMES | US cities and their VERTEX geocodes, used to validate US 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. |
HR_S_US_ZIP_CODES | Valid zip code ranges for VERTEX cities, used to validate US addresses. |
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 |
HR_TEMPLATE_ITEM_CONTEXTS_B | Definition of items on a template for given context, for configurable forms |
HR_TEMPLATE_ITEM_CONTEXT_PAGES | Information about which tab pages item belongs to for a specific context, on template for configurable form. |
HR_TEMPLATE_ITEM_TAB_PAGES | Information about which tab pages item belongs to on template 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. |
HR_WORKING_PERSON_LISTS | Holds a list of people who constitute a user current list, used in the Line Manager Web pages |
PER_ABSENCE_ATTENDANCES | Records of absence, or attendance for an employee. |
PER_ABSENCE_ATTENDANCES_EFC | 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 | User 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. |
PER_ALL_PEOPLE_F | DateTracked table holding personal information for employees, applicants and other people. |
PER_ALL_POSITIONS | Dual-maintained 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. |
PER_ASSIGNMENT_BUDGET_VALU_EFC | 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 | Extra information for an assignment. |
PER_ASSIGNMENT_EXTRA_INFO_EFC | 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 | Types of extra information that may be held against an assignment. |
PER_ASSIGNMENT_INFO_TYPES_TL | Translated types of extra information that may be held against an assignment. |
PER_ASSIGNMENT_LIST | List of assignments that a secure user can access. |
PER_ASSIGNMENT_STATUS_TYPES | Predefined and user defined assignment status types. |
PER_ASSIGNMENT_STATUS_TYPES_TL | Predefined and user defined translated assignment status types. |
PER_ASSIGN_PROPOSAL_ANSWERS | Web Candidate Offer Answers |
PER_ASS_STATUS_TYPE_AMENDS | User amendments to predefined assignment status types. |
PER_ASS_STATUS_TYPE_AMENDS_TL | Translated user amendments to predefined assignment status types. |
PER_BF_BALANCE_AMOUNTS | Holds assignment level run amount and summary values for 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 | |
PER_BF_PAYMENT_DETAILS | Holds details of payments that have been processed by a 3rd party payroll provider, by assignment. |
PER_BF_PAYMENT_DETAILS_EFC | |
PER_BF_PAYROLL_RUNS | Payrolls processed by 3rd party payroll provider. |
PER_BF_PROCESSED_ASSIGNMENTS | Intersection table storing details of assignments that have been processed by a 3rd party payroll provider in each payroll run |
PER_BOOKINGS | Event booking details. |
PER_BUDGETS | Definitions of HR budgets. |
PER_BUDGET_ELEMENTS | Combinations of organization, grade, job, and position used to define detailed budget values. |
PER_BUDGET_VALUES | Planned HR budget values for specific budget elements. |
PER_BUDGET_VALUES_EFC | This is a copy of the PER_BUDGET_VALUES table which is 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 | |
PER_CAGR_GRADES | The reference collectively agreed grades for a Collective Agreement. |
PER_CAGR_GRADES_DEF | Collective agreement grades key flexfield combinations table. |
PER_CAGR_GRADE_STRUCTURES | The valid collectively agreed grade key flexfield structures for a 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 |
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. |
PER_COBRA_COVERAGE_BENEFITS_F | Details of a benefit that the employee accepts or rejects as part of 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. |
PER_COBRA_COV_ENROLLMENTS | Enrollments for people who are eligible for continued benefit coverage under COBRA. |
PER_COBRA_DEPENDENTS_F | Holds employee dependents coverage for a COBRA qualifying event. |
PER_COBRA_QFYING_EVENTS_F | Events that have meaning in the context of COBRA coverage, e.g. Divorce, Termination, Death etc. |
PER_COLLECTIVE_AGREEMENTS | Collective agreement information. |
PER_COMPETENCES | A competence is a definition of knowledge, skills, abilities or other charactaristics that a person may possess. |
PER_COMPETENCES_TL | This table is used for language translations |
PER_COMPETENCE_DEFINITIONS | COMPETENCES Key flexfield combinations table |
PER_COMPETENCE_ELEMENTS | A competence element is used to record an individual competence and an evaluation rating. |
PER_COMPETENCE_OUTCOMES | Competence outcomes |
PER_COMP_ELEMENT_OUTCOMES | The outcomes achieved towards a given Competency . |
PER_CONTACT_EXTRA_INFO_F | Extra information for a contact relationship. |
PER_CONTACT_INFO_TYPES | Types of extra information that may be held against a contact relationship. |
PER_CONTACT_INFO_TYPES_TL | Translated types of extra information that may be held against a contact relationship. |
PER_CONTACT_RELATIONSHIPS | Contacts and relationship details for dependents, beneficiaries, emergency contacts, parents etc. |
PER_CONTRACTS_F | The details of a persons contract of employment |
PER_CPN_DATA_UPGRADE | Used to log errors / warnings during the conversion of competences to a key flex structure. |
PER_DEPLOYMENT_FACTORS | A factor affecting a person's capacity to be deployed within an organization. |
PER_DISABILITIES_F | Hold Disability information for one person |
PER_ELECTIONS | Holds election related information. |
PER_ELECTION_CANDIDATES | Holds information of Election candidates. |
PER_ELECTION_CONSTITUENCYS | This table holds information related to constituencies participating 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 | |
PER_ESTABLISHMENTS | This entity is used to maintain a list of educational establishments e.g. schools, colleges, universities, etc. |
PER_ESTABLISHMENT_ATTENDANCES | A record of educational establishments that a person is currently attending or has previously attended. |
PER_EVENTS | Record of events such as interviews and appraisals for applicants and employees. |
PER_FORM_FUNCTIONS | Navigation and person change information for the Enter Person information screens. |
PER_GENERIC_REPORT_OUTPUT | Text lines for output by a generic report script, including: title, 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. |
PER_INFO_TYPE_SECURITY | Cross table between Responsibilty and Info_type tables, used to 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. |
PER_JOB_GROUPS | 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 | Types of extra information that may be held against a job. |
PER_JOB_REQUIREMENTS | Requirements for specific jobs or positions. For example, skills, 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 |
PER_LETTER_GEN_STATUSES | Associations between letter types and possible status type 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 auto-request definitions. |
PER_MASS_MOVES | High level mass move definition. |
PER_MEDICAL_ASSESSMENTS | Hold Medical Assessment information for one person |
PER_MM_ASSIGNMENTS | PER_MM_ASSIGNMENTS holds assignments that were defined as part of a mass move. |
PER_MM_JOB_REQUIREMENTS | PER_MM_JOB_REQUIREMENTS holds data related to transferring position requirements to a newly created position. |
PER_MM_POSITIONS | PER_MM_POSITIONS holds positions that were defined as part of a mass move. |
PER_MM_VALID_GRADES | 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 |
PER_NL_ASG_SCL_UPGRADE | Records the Dutch Assignment SCL Context Information Migrated used by the Report |
PER_NUMBER_GENERATION_CONTROLS | PER_NUMBER_GENERATION_CONTROLS holds the numbers 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 user can access. |
PER_ORGANIZATION_STRUCTURES | Organization hierarchy names. |
PER_ORG_STRUCTURE_ELEMENTS | Organization hierarchy details showing parent-child reporting 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. |
PER_PAY_PROPOSALS | Salary proposals and performance review information for employee assignments. |
PER_PAY_PROPOSALS_EFC | This is a copy of the PER_PAY_PROPOSALS table which is populated by the EFC (Euro as Functional Currency) process. |
lso | Component details of a pay proposal for an employee assignment. |
PER_PAY_PROPOSAL_COMPONENT_EFC | This is a copy of the PER_PAY_PROPOSAL_COMPONENT table which is populated by the EFC (Euro as Functional Currency) process. |
PER_PAY_PROPOSAL_COMPONENT_EFC | |
PER_PEOPLE_EXTRA_INFO | Extra information for a person. |
PER_PEOPLE_INFO_TYPES | The table holds the definitions of extra information types that may 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 non-payrolled worker |
PER_PERIODS_OF_SERVICE | Period of service details for an employee. |
PER_PERIODS_OF_SERVICE_EFC | This is a copy of the PER_PERIODS_OF_SERVICE table which 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 user can access. |
PER_PERSON_LIST_CHANGES | List of people that are to be added to current PER_PERSON_LIST. |
PER_PERSON_LIST_CHG_ARCH | Archive table to hold content of PER_PERSON_LIST_CHANGES 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 | PER_PHONES holds phone numbers for current and ex-employees, current and ex-applicants and employee contacts. |
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 user can access. |
PER_POSITION_STRUCTURES | Position Hierarchy names. |
PER_POS_STRUCTURE_ELEMENTS | Position hierarchy details showing parent-child reporting 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_MEMBERS | 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_MEMBERS | Web offer profile questions |
PER_PROPOSAL_QUESTION_TYPES | Generic web offer questions |
PER_PROPOSAL_TEMPLATES | - Retrofitted |
PER_PTU_DFF_MAPPING_HEADERS | Table for storing DFF migration mapping Information from PER_ALL_PEOPLE_F to PER_PERSON_TYPE_USAGES_F. |
PER_PTU_DFF_MAPPING_LINES | Table for storing DFF migration mapping Information from PER_ALL_PEOPLE_F to PER_PERSON_TYPE_USAGES_F. |
PER_PTU_DFF_MIG_FAILED_PEOPLE | 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 | A record of educational qualification, certificates, licenses, etc that a person holds or is acquiring. |
PER_QUALIFICATIONS_EFC | This is a copy of the PER_QUALIFICATIONS table which is 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. |
PER_RATING_LEVELS | A rating scale step is a single point on a rating scale and is used to rate competences. |
PER_RATING_LEVELS_TL | A rating scale step is a single point on a rating scale and is used 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. |
PER_RECRUITMENT_ACTIVITIES_EFC | 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 | 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 sub-tasks |
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 |
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. |
PER_SALARY_SURVEY_LINES_EFC | 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 | Mapping information for a salary survey line. |
PER_SCHED_COBRA_PAYMENTS | Payment schedules for benefits provided by a COBRA coverage. |
PER_SECONDARY_ASS_STATUSES | Secondary assignment statuses used for information and reporting. |
PER_SECURITY_ORGANIZATIONS | List of organizations to include or exclude from security list |
PER_SECURITY_PROFILES | Security profile definitions to restrict user access to specific HRMS records. |
PER_SECURITY_USERS | List of users for a security profile whose access permissions will be stored in static lists duringSecurity List Maintenance. |
PER_SEC_PROFILE_ASSIGNMENTS | Security profile assignments for User, Responsibility and 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. |
PER_SPINAL_POINT_PLACEMENTS_F | Details of assignment placements to a grade step and point. |
PER_SPINAL_POINT_SEPS_F | Grade steps defined in a specific grade scale and their 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. |
PER_TIME_PERIODS | Time period definitions for payroll processing and HR budget calendars. |
PER_TIME_PERIOD_RULES | Rules for time periods used by the system. |
PER_TIME_PERIOD_SETS | Specific dates for a defined calendar. |
PER_TIME_PERIOD_TYPES | Predefined list of valid period types for payroll and HR budget calendars. |
PER_TIME_PERIOD_TYPES_TL | Predefined list of translated period types for payroll and HR 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. |
PER_WORK_INCIDENTS | Holds information on Incidents that happen at work or en route to work, for example, an industrial accident |
PER_WORK_INCIDENTS_EFC | 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 | Table to store the Areas of assessment per NQF Assessment |
PER_ZA_ASSESSMENTS | Table to store the NQF Assessment info for a person |
PER_ZA_EMPLOYMENT_EQUITY | Temporary table for Employment Equity Reporting |
PER_ZA_FORMAL_QUALIFICATIONS | Table to store additional NQF Qualification info for a person |
PER_ZA_LEARNERSHIP_AGREEMENTS | Table to store the NQF learnership agreement info between a 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 |
HR_PUMP_MAPPING_PACKAGES | 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 be used by all APIs. |
HR_PUMP_MODULE_PARAMETERS | Holds seeded information about API parameters for data pump code generation. |
HR_PUMP_RANGES | Controls the parallelisation of the work when the data pump is running on multiprocessor platforms. |
HR_PUMP_REQUESTS | Holds information on data pump concurrent requests currently running. |
HR_QUESTIONNAIRES | Questionnaires used within SSHR. |
HR_QUEST_ANSWERS | Answers for a questionnaire. |
HR_QUEST_ANSWER_VALUES | Answer values for a questionnaire. |
HR_QUEST_FIELDS | Fields of a questionnaire. |
HR_SOFT_CODING_KEYFLEX | Legislation specific information for payrolls, organizations and assignments. |
HR_SOURCE_FORM_TEMPLATES | Identities of templates which have been copied and the resulting 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. |
HR_SUMMARY_EFC | This is a copy of the HR_SUMMARY table which is populated by the EFC (Euro as Functional Currency) process. |
HR_S_MAGNETIC_BLOCKS | |
HR_S_MAGNETIC_RECORDS | |
HR_S_US_CITY_GEOCODES | |
HR_S_US_CITY_NAMES | US cities and their VERTEX geocodes, used to validate US 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. |
HR_S_US_ZIP_CODES | Valid zip code ranges for VERTEX cities, used to validate US addresses. |
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 |
HR_TEMPLATE_ITEM_CONTEXTS_B | Definition of items on a template for given context, for configurable forms |
HR_TEMPLATE_ITEM_CONTEXT_PAGES | Information about which tab pages item belongs to for a specific context, on template for configurable form. |
HR_TEMPLATE_ITEM_TAB_PAGES | Information about which tab pages item belongs to on template 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. |
HR_WORKING_PERSON_LISTS | Holds a list of people who constitute a user current list, used in the Line Manager Web pages |
PER_ABSENCE_ATTENDANCES | Records of absence, or attendance for an employee. |
PER_ABSENCE_ATTENDANCES_EFC | 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 | User 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. |
PER_ALL_PEOPLE_F | DateTracked table holding personal information for employees, applicants and other people. |
PER_ALL_POSITIONS | Dual-maintained 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. |
PER_ASSIGNMENT_BUDGET_VALU_EFC | 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 | Extra information for an assignment. |
PER_ASSIGNMENT_EXTRA_INFO_EFC | 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 | Types of extra information that may be held against an assignment. |
PER_ASSIGNMENT_INFO_TYPES_TL | Translated types of extra information that may be held against an assignment. |
PER_ASSIGNMENT_LIST | List of assignments that a secure user can access. |
PER_ASSIGNMENT_STATUS_TYPES | Predefined and user defined assignment status types. |
PER_ASSIGNMENT_STATUS_TYPES_TL | Predefined and user defined translated assignment status types. |
PER_ASSIGN_PROPOSAL_ANSWERS | Web Candidate Offer Answers |
PER_ASS_STATUS_TYPE_AMENDS | User amendments to predefined assignment status types. |
PER_ASS_STATUS_TYPE_AMENDS_TL | Translated user amendments to predefined assignment status types. |
PER_BF_BALANCE_AMOUNTS | Holds assignment level run amount and summary values for 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 | |
PER_BF_PAYMENT_DETAILS | Holds details of payments that have been processed by a 3rd party payroll provider, by assignment. |
PER_BF_PAYMENT_DETAILS_EFC | |
PER_BF_PAYROLL_RUNS | Payrolls processed by 3rd party payroll provider. |
PER_BF_PROCESSED_ASSIGNMENTS | Intersection table storing details of assignments that have been processed by a 3rd party payroll provider in each payroll run |
PER_BOOKINGS | Event booking details. |
PER_BUDGETS | Definitions of HR budgets. |
PER_BUDGET_ELEMENTS | Combinations of organization, grade, job, and position used to define detailed budget values. |
PER_BUDGET_VALUES | Planned HR budget values for specific budget elements. |
PER_BUDGET_VALUES_EFC | This is a copy of the PER_BUDGET_VALUES table which is 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 | |
PER_CAGR_GRADES | The reference collectively agreed grades for a Collective Agreement. |
PER_CAGR_GRADES_DEF | Collective agreement grades key flexfield combinations table. |
PER_CAGR_GRADE_STRUCTURES | The valid collectively agreed grade key flexfield structures for a 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 |
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. |
PER_COBRA_COVERAGE_BENEFITS_F | Details of a benefit that the employee accepts or rejects as part of 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. |
PER_COBRA_COV_ENROLLMENTS | Enrollments for people who are eligible for continued benefit coverage under COBRA. |
PER_COBRA_DEPENDENTS_F | Holds employee dependents coverage for a COBRA qualifying event. |
PER_COBRA_QFYING_EVENTS_F | Events that have meaning in the context of COBRA coverage, e.g. Divorce, Termination, Death etc. |
PER_COLLECTIVE_AGREEMENTS | Collective agreement information. |
PER_COMPETENCES | A competence is a definition of knowledge, skills, abilities or other charactaristics that a person may possess. |
PER_COMPETENCES_TL | This table is used for language translations |
PER_COMPETENCE_DEFINITIONS | COMPETENCES Key flexfield combinations table |
PER_COMPETENCE_ELEMENTS | A competence element is used to record an individual competence and an evaluation rating. |
PER_COMPETENCE_OUTCOMES | Competence outcomes |
PER_COMP_ELEMENT_OUTCOMES | The outcomes achieved towards a given Competency . |
PER_CONTACT_EXTRA_INFO_F | Extra information for a contact relationship. |
PER_CONTACT_INFO_TYPES | Types of extra information that may be held against a contact relationship. |
PER_CONTACT_INFO_TYPES_TL | Translated types of extra information that may be held against a contact relationship. |
PER_CONTACT_RELATIONSHIPS | Contacts and relationship details for dependents, beneficiaries, emergency contacts, parents etc. |
PER_CONTRACTS_F | The details of a persons contract of employment |
PER_CPN_DATA_UPGRADE | Used to log errors / warnings during the conversion of competences to a key flex structure. |
PER_DEPLOYMENT_FACTORS | A factor affecting a person's capacity to be deployed within an organization. |
PER_DISABILITIES_F | Hold Disability information for one person |
PER_ELECTIONS | Holds election related information. |
PER_ELECTION_CANDIDATES | Holds information of Election candidates. |
PER_ELECTION_CONSTITUENCYS | This table holds information related to constituencies participating 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 | |
PER_ESTABLISHMENTS | This entity is used to maintain a list of educational establishments e.g. schools, colleges, universities, etc. |
PER_ESTABLISHMENT_ATTENDANCES | A record of educational establishments that a person is currently attending or has previously attended. |
PER_EVENTS | Record of events such as interviews and appraisals for applicants and employees. |
PER_FORM_FUNCTIONS | Navigation and person change information for the Enter Person information screens. |
PER_GENERIC_REPORT_OUTPUT | Text lines for output by a generic report script, including: title, 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. |
PER_INFO_TYPE_SECURITY | Cross table between Responsibilty and Info_type tables, used to 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. |
PER_JOB_GROUPS | 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 | Types of extra information that may be held against a job. |
PER_JOB_REQUIREMENTS | Requirements for specific jobs or positions. For example, skills, 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 |
PER_LETTER_GEN_STATUSES | Associations between letter types and possible status type 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 auto-request definitions. |
PER_MASS_MOVES | High level mass move definition. |
PER_MEDICAL_ASSESSMENTS | Hold Medical Assessment information for one person |
PER_MM_ASSIGNMENTS | PER_MM_ASSIGNMENTS holds assignments that were defined as part of a mass move. |
PER_MM_JOB_REQUIREMENTS | PER_MM_JOB_REQUIREMENTS holds data related to transferring position requirements to a newly created position. |
PER_MM_POSITIONS | PER_MM_POSITIONS holds positions that were defined as part of a mass move. |
PER_MM_VALID_GRADES | 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 |
PER_NL_ASG_SCL_UPGRADE | Records the Dutch Assignment SCL Context Information Migrated used by the Report |
PER_NUMBER_GENERATION_CONTROLS | PER_NUMBER_GENERATION_CONTROLS holds the numbers 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 user can access. |
PER_ORGANIZATION_STRUCTURES | Organization hierarchy names. |
PER_ORG_STRUCTURE_ELEMENTS | Organization hierarchy details showing parent-child reporting 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. |
PER_PAY_PROPOSALS | Salary proposals and performance review information for employee assignments. |
PER_PAY_PROPOSALS_EFC | This is a copy of the PER_PAY_PROPOSALS table which is populated by the EFC (Euro as Functional Currency) process. |
lso | Component details of a pay proposal for an employee assignment. |
PER_PAY_PROPOSAL_COMPONENT_EFC | This is a copy of the PER_PAY_PROPOSAL_COMPONENT table which is populated by the EFC (Euro as Functional Currency) process. |
PER_PAY_PROPOSAL_COMPONENT_EFC | |
PER_PEOPLE_EXTRA_INFO | Extra information for a person. |
PER_PEOPLE_INFO_TYPES | The table holds the definitions of extra information types that may 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 non-payrolled worker |
PER_PERIODS_OF_SERVICE | Period of service details for an employee. |
PER_PERIODS_OF_SERVICE_EFC | This is a copy of the PER_PERIODS_OF_SERVICE table which 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 user can access. |
PER_PERSON_LIST_CHANGES | List of people that are to be added to current PER_PERSON_LIST. |
PER_PERSON_LIST_CHG_ARCH | Archive table to hold content of PER_PERSON_LIST_CHANGES 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 | PER_PHONES holds phone numbers for current and ex-employees, current and ex-applicants and employee contacts. |
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 user can access. |
PER_POSITION_STRUCTURES | Position Hierarchy names. |
PER_POS_STRUCTURE_ELEMENTS | Position hierarchy details showing parent-child reporting 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_MEMBERS | 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_MEMBERS | Web offer profile questions |
PER_PROPOSAL_QUESTION_TYPES | Generic web offer questions |
PER_PROPOSAL_TEMPLATES | - Retrofitted |
PER_PTU_DFF_MAPPING_HEADERS | Table for storing DFF migration mapping Information from PER_ALL_PEOPLE_F to PER_PERSON_TYPE_USAGES_F. |
PER_PTU_DFF_MAPPING_LINES | Table for storing DFF migration mapping Information from PER_ALL_PEOPLE_F to PER_PERSON_TYPE_USAGES_F. |
PER_PTU_DFF_MIG_FAILED_PEOPLE | 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 | A record of educational qualification, certificates, licenses, etc that a person holds or is acquiring. |
PER_QUALIFICATIONS_EFC | This is a copy of the PER_QUALIFICATIONS table which is 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. |
PER_RATING_LEVELS | A rating scale step is a single point on a rating scale and is used to rate competences. |
PER_RATING_LEVELS_TL | A rating scale step is a single point on a rating scale and is used 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. |
PER_RECRUITMENT_ACTIVITIES_EFC | 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 | 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 sub-tasks |
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 |
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. |
PER_SALARY_SURVEY_LINES_EFC | 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 | Mapping information for a salary survey line. |
PER_SCHED_COBRA_PAYMENTS | Payment schedules for benefits provided by a COBRA coverage. |
PER_SECONDARY_ASS_STATUSES | Secondary assignment statuses used for information and reporting. |
PER_SECURITY_ORGANIZATIONS | List of organizations to include or exclude from security list |
PER_SECURITY_PROFILES | Security profile definitions to restrict user access to specific HRMS records. |
PER_SECURITY_USERS | List of users for a security profile whose access permissions will be stored in static lists duringSecurity List Maintenance. |
PER_SEC_PROFILE_ASSIGNMENTS | Security profile assignments for User, Responsibility and 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. |
PER_SPINAL_POINT_PLACEMENTS_F | Details of assignment placements to a grade step and point. |
PER_SPINAL_POINT_SEPS_F | Grade steps defined in a specific grade scale and their 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. |
PER_TIME_PERIODS | Time period definitions for payroll processing and HR budget calendars. |
PER_TIME_PERIOD_RULES | Rules for time periods used by the system. |
PER_TIME_PERIOD_SETS | Specific dates for a defined calendar. |
PER_TIME_PERIOD_TYPES | Predefined list of valid period types for payroll and HR budget calendars. |
PER_TIME_PERIOD_TYPES_TL | Predefined list of translated period types for payroll and HR 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. |
PER_WORK_INCIDENTS | Holds information on Incidents that happen at work or en route to work, for example, an industrial accident |
PER_WORK_INCIDENTS_EFC | 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 | Table to store the Areas of assessment per NQF Assessment |
PER_ZA_ASSESSMENTS | Table to store the NQF Assessment info for a person |
PER_ZA_EMPLOYMENT_EQUITY | Temporary table for Employment Equity Reporting |
PER_ZA_FORMAL_QUALIFICATIONS | Table to store additional NQF Qualification info for a person |
PER_ZA_LEARNERSHIP_AGREEMENTS | Table to store the NQF learnership agreement info between a 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 |
No comments:
Post a Comment