In your client’s company, the Telephone Allowance is paid as per the grade of an employee. This
information is stored in a User Defined Table. The Row is set as the Grade name and the Column
Value is set as the applicable amount of the Telephone Allowance. Your client wants to validate
that the value entered in the column Value is between 0 to 300 USD.
How would you configure this validation?
A.
In the Table Structure window, set the Match Type of the table as Range. Choose the Rows
button to go to the Rows window and specify the lower and upper boundary values as 0 and 300
respectively.
B.
In the Table Structure window, set the Match Type of the table as Match. Choose the Rows
button to go to the Rows window and specify the lower and upper boundary values as 0 and 300
respectively.
C.
Create a Formula Validation to return an error if the Entry Value is greater than 300. In the
Table Structure window choose the Columns button to go to the Columns window. Associate the
Validation Formula with the appropriate Column Name.
D.
In the Table Structure window, select the Range Validation check box. Choose the Rows button
to go to the Rows window and specify the lower and upper boundary values as 0 and 300
respectively.
E.
Create an Independent Value set to have values from 0 to 300. In the Table Structure window
choose the Columns button to go to the columns window. Associate the Value Set with the
appropriate Column Name.
Explanation:
You set up user tables in the Table Structure window.
To set up the structure of a table:
1.Set your effective date to the date from which you want the table’s row labels to take
effect.
2.Enter the table name.
3.For the table’s match type, select Match or Range. Select Match if each row is for one
item, such as one job or one code. Select Range if each row is for a range of numeric
values, such as an age range or a pay range. (A)
4.If the match type is Match, select Date, Number or Text as the Key Units of Measure,
depending on whether entries in the rows are dates (DD-MON-YYYY), numbers, oralphanumeric text.
If the table’s match type is Range, the Key Units of Measure automatically becomes
Number.
5.Enter the row label as the Row Title.
For example, if the table rows refer to rate codes, an appropriate row title would be Rate
Code. If the rows refer to age ranges, you might use the title Age Range.
6.Save your work, and choose the Columns button to go to the Columns window.
Oracle Human Resource Management Systems, Setting Up User Tables