Payroll Insight
The following table lists objects (tables) of the Payroll Insight for Oracle
| Table/view name in IRC | Friendly name |
|---|---|
| AP_BANK_ACCOUNTS_ALL Extracted table name for Oracle 12 version = IBY_EXT_BANK_ACCOUNTS | Bank Accounts |
| BEN_BENEFIT_CLASSIFICATIONS | Benefit Classifications |
| FF_CONTEXTS | Context For Specific Formulas |
| FF_DATABASE_ITEMS | Database Items |
| FF_FORMULA_TYPES | Formula Types |
| FF_FORMULAS_F | Formula Definitions |
| FF_FUNCTIONS | Fast Formula Function Definitions |
| FF_GLOBALS_F | Global Values And Data Types |
| FF_USER_ENTITIES | User Entities |
| FND_CURRENCIES | Currencies |
| FND_FLEX_VALUE_SETS | Value sets used by both key and descriptive flexfields |
| FND_LOOKUP_VALUES | Quick Code Values |
| FND_TERRITORIES | Territories |
| GL_DAILY_CONVERSION_TYPES | Conversion Rate Types |
| GL_DAILY_RATES | Daily Conversion Rates |
| HR_ALL_ORGANIZATION_UNITS | Organization Unit Definitions |
| HR_ALL_POSITIONS_F | Position Definition |
| HR_ASSIGNMENT_SET_AMENDMENTS | Assignment Set Amendments |
| HR_ASSIGNMENT_SET_CRITERIA | Assignment Set Criteria |
| HR_ASSIGNMENT_SETS | Assignment Sets |
| HR_LOCATIONS_ALL | Work Location Definitions |
| HR_ORGANIZATION_INFORMATION | Organization Information |
| PAY_ACCRUAL_BANDS | Accrual Bands |
| PAY_ACTION_INTERLOCKS | Action Interlock Definitions |
| PAY_ALL_PAYROLLS_F | Payroll Group Definitions |
| PAY_ASSIGNMENT_ACTIONS | Assignment Actions |
| PAY_BACKPAY_RULES | Back pay Rules |
| PAY_BALANCE_CLASSIFICATIONS | Balance Classification |
| PAY_BALANCE_DIMENSIONS | Balance Summation |
| PAY_BALANCE_FEEDS_F | Balance Feeds |
| PAY_BALANCE_TYPES | Balance Types |
| PAY_CONSOLIDATION_SETS | Consolidation Set Of Results |
| PAY_COST_ALLOCATION_KEYFLEX | Cost Allocation Key Flexfield Combinations |
| PAY_COST_ALLOCATIONS_F | Cost Allocation Details |
| PAY_DEFINED_BALANCES | Defined Balances |
| PAY_ELE_CLASSIFICATION_RULES | Element Classification Rules |
| PAY_ELEMENT_CLASSIFICATIONS | Element Classifications |
| PAY_ELEMENT_ENTRIES_F | Element Entry List |
| PAY_ELEMENT_ENTRY_VALUES_F | Input Values For Element Entries |
| PAY_ELEMENT_LINKS_F | Eligibility Rules For An Element Type |
| PAY_ELEMENT_SETS | Element Sets |
| PAY_ELEMENT_TYPE_RULES | Element Type Rules |
| PAY_ELEMENT_TYPE_USAGES_F | Used to store all elements from a defined run type |
| PAY_ELEMENT_TYPES_F | Element Definitions |
| PAY_EXTERNAL_ACCOUNTS | Bank Account Details |
| PAY_INPUT_VALUES_F | Input Value Definitions For Specific Elements |
| PAY_LINK_INPUT_VALUES_F | Input Value Overrides For Specific Element Link |
| PAY_MONETARY_UNITS | Denominations For Currencies |
| PAY_ORG_PAY_METHOD_USAGES_F | Available Payment Methods |
| PAY_ORG_PAYMENT_METHODS_F | Payment Methods |
| PAY_PAYMENT_TYPES | Payment Types |
| PAY_PAYROLL_ACTIONS | Payroll Process Hold Information |
| PAY_PAYROLL_GL_FLEX_MAPS | Payroll To GL Key Flexfield Segment Mappings |
| PAY_PERSONAL_PAYMENT_METHODS_F | Personal Payment Method Details |
| PAY_PRE_PAYMENTS | Pre-payments |
| PAY_RUN_TYPES_F | Payroll Run Processing Types |
| PAY_SECURITY_PAYROLLS | List of payrolls and security profile access rules |
| PAY_STATUS_PROCESSING_RULES_F | Assignment Status Rules |
| PAY_SUB_CLASSIFICATION_RULES_F | Sub Classification Rules |
| PER_ABS_ATTENDANCE_REASONS | Absence Reasons |
| PER_ABSENCE_ATTENDANCE_TYPES | Absence Types |
| PER_ABSENCE_ATTENDANCES | Employee Absence Or Attendance Details |
| PER_ADDRESSES | Employee Address Details |
| PER_ALL_ASSIGNMENTS_F | Employee And Applicant Assignment Details. |
| PER_ALL_PEOPLE_F | Employee Personal Details |
| PER_ANALYSIS_CRITERIA | Personal Analysis Key Flexfield |
| PER_ASS_STATUS_TYPE_AMENDS | Amendments To Assignment Status Types |
| PER_ASSIGNMENT_STATUS_TYPES | Assignment Status Types |
| PER_COLLECTIVE_AGREEMENTS | Collective Agreement Details |
| PER_CONTRACTS_F | Person Contract Details |
| PER_GRADES | Grade Definitions |
| PER_JOBS | Jobs Defined |
| PER_ORG_STRUCTURE_ELEMENTS | Organization Hierarchy Details |
| PER_ORG_STRUCTURE_VERSIONS | Version Control Information |
| PER_ORGANIZATION_STRUCTURES | Organization hierarchy names |
| PER_PAY_BASES | Salary Bases Definitions |
| PER_PAY_PROPOSAL_COMPONENTS | Proposal Component Details |
| PER_PAY_PROPOSALS | Salary Proposals And Performance Review Information |
| PER_PERFORMANCE_REVIEWS | Performance Review Information |
| PER_PERIODS_OF_SERVICE | Period Of Service Details |
| PER_PERSON_ANALYSES | Special Information Types For Person |
| PER_PERSON_TYPES | Person Types |
| PER_SECONDARY_ASS_STATUSES | Secondary Assignment Statuses |
| PER_SPINAL_POINT_STEPS_F | Grade Steps |
| PER_SPINAL_POINTS | Progression Points |
| PER_TIME_PERIOD_RULES | Time Period Rules |
| PER_TIME_PERIOD_TYPES | Time Period Types |
| PER_TIME_PERIODS | Time Period Definitions |