Table vs. View – Any difference?

Many of us might struggle to give a precise answer to this question. This article might just help ..

The difference between a view and a table is that views are definitions built on top of other tables (or views), and do not hold data themselves. To put it in simple words, a view is a virtual table which also consists of rows and columns just like a table. Views have no direct or physical relation with the database.

Imp HR and Payroll Tables - Part V

>> PAY_INPUT_VALUES_F

Each defined element generally has one or multiple input segment, this DateTracked  payroll table holds the definitions of the input values associated with a specific element. Users can add or modify input values for non–legislative elements.

>> PAY_ELEMENT_ENTRIES_F

This payroll DateTracked table holds the list of element entries for each assignment. The actual values for each entry are held in PAY_ELEMENT_ENTRY_VALUES_F.

Imp HR and Payroll Tables - Part IV

>> PAY_PAYMENT_TYPES

This payroll table holds details of the payment types that can be processed by the system. Used to define specific payment methods in PAY_ORG_PAYMENT_METHODS_F

>> PAY_ORG_PAYMENT_METHODS_F

This payroll table holds the definitions that identify business groups and the organization units within a single business group. Additional information about classifications and information types for each organization is held in HR_ORGANIZATION_INFORMATION

Imp HR and Payroll Tables - Part III

>> HR_ORGANIZATION_UNITS

This table holds the definitions that identify business groups and the organization units within a single business group. Additional information about classifications and information types for each organization is held in HR_ORGANIZATION_INFORMATION

Imp HR and Payroll Tables - Part II

>> PER_ADDRESSES

Holds address information for current and ex–employees, current and ex–applicants and employee contacts. Addresses have a specific address STYLE that identifies the address format for a specific country, or territory. A person may have more than one address at any one time, and each address can be in a different style.

The PRIMARY_FLAG identifies the primary address. Primary addresses are not DateTracked, but they are contiguous and cannot overlap. From the first date a person has an address to the last date they have an address, a person must have one primary address. Any secondary address can be disabled by entering a value in DATE_TO.

Imp HR and Payroll Tables - Part I

>> PER_ALL_PEOPLE_F

This is the base table for all date-tracked personal details and provides the very basic information about employee/contingent worker/applicant. The columns START_DATE, EFFECTIVE_START_DATE and EFFECTIVE_END_DATE are all maintained by DateTrack. The START_DATE is the date when the first record for this person was created. The earliest EFFECTIVE_START_DATE for a person is equal to the START_DATE. The very data from the first screen we see when we open the ‘People à Enter and Maintain’ form goes into this table.

Define Organizations - Part IV

Frequently Asked Questions (FAQs)

How can I find the LOV used by a segment in the Information Type I select from the ‘Others’ button?

Query up the DFF ‘Org Developer DF’ and select the context whose name matches the name of the Information type you selected from the ‘Others’ button. The Segments screen lists the fields defined for that information type. The LOV will come from the validation used by the relevant segment.

Define Organizations - Part III

Related Oracle HRMS Tables

HR_ALL_ORGANIZATION_UNITS: The basic details of oracle erp organizations are stored here. There is also a translation table HR_ALL_ORGANIZATION_UNITS_TL for the organization name in each language installed.

Define Organizations - Part II

Business Groups

Business Groups are just organizations which have the classification ‘Business Group’ Each organization will have a BUSINESS_GROUP_ID to identify which business group it was created from. A business group will have identical values for BUSINESS_GROUP_ID and ORGANIZATION_ID. Organizations from all business groups can be queried up in the Define Organizations screen. However only organizations for the current business group and the classification ‘HR Organization’ can be used in the Assignment screen.

Define Organizations - Part I

In the next 3-4 posts (including this one) I’ll discuss about oracle hrms organization, oracle hrms organization classification and relevant oracle hrms tables

Organizations in HRMS

Organizations are used in oracle erp to represent Business Groups (BGs), External organizations (for example, tax offices, insurance carriers, disability organizations, benefit carriers, or recruitment agencies), Internal organizations (for example, departments, sections or cost centers) and GREs/Legal Entities.

Introduction to HRMS

Each and every enterprise needs people to manage and run its business. People are the most basic and the most important ingredient of any business. It could be an NGO, a Bank or a Robotics laboratory, no matter where the enterprise focuses on, it must need people to run it. That is why it becomes necessary for the enterprise to store organizational data along with employee data, and use them to manage the people related to the enterprise effectively. This requirement creates the market for a system called the Human Resource Management System.

SQL vs. PL/SQL

It’s an interesting question, to be sure. Most people who are familiar with Oracle development wouldn't give it a thought but when you come down to it, it’s sometimes confusing to define the demarcation between SQL and PL/SQL. Through this note let us try to understand the differences between SQL and PL/SQL. You never know, this  might just be the starting point of your next oracle hrms interview questions or oracle payroll interview questions :)