|
Package gb_gtvrrac Standard functions and procedures for Regulatory Race Validation Table. |
| Program units |
| f_code_exists | Determines if the code exists in the table. |
| f_get_description | Returns description for the code. |
| Cursors |
| gtvrrac_c | Returns the record from the validation table. |
gtvrrac_c
CURSOR gtvrrac_c(
p_code gtvrrac.gtvrrac_code%TYPE)
RETURN gtvrrac%ROWTYPE;
Returns the record from the validation table.
f_code_exists
FUNCTION f_code_exists(p_code gtvrrac.gtvrrac_code%TYPE) RETURN VARCHAR2
Determines if the code exists in the table.
| Parameters |
| p_code |
Regulatory race code. Used in regulatory data collection of race information established by the United States government. Other countries with race data collection requirements can also use this field to identify race codes. |
| Returns |
|
Y if found, otherwise N |
f_get_description
FUNCTION f_get_description(p_code gtvrrac.gtvrrac_code%TYPE) RETURN VARCHAR2
Returns description for the code.
| Parameters |
| p_code |
Regulatory race code description. These codes are mapped to the institution defined codes on GORRACE. |
| Returns |
|
Description |