Question 6
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?
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.
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.
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.
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.
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.
Correct answer: A
Explanation:
You set up user tables in the Table Structure window. To set up the structure of a table:Set your effective date to the date from which you want the table's row labels to take effect. Enter the table name. 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) 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, or alphanumeric text. If the table's match type is Range, the Key Units of Measure automatically becomes Number. 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. Save your work, and choose the Columns button to go to the Columns window. References:
You set up user tables in the Table Structure window.
To set up the structure of a table:
Set your effective date to the date from which you want the table's row labels to take effect.
Enter the table name.
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)
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, or alphanumeric text.
If the table's match type is Range, the Key Units of Measure automatically becomes Number.
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.
Save your work, and choose the Columns button to go to the Columns window.
References: