supply_validation: Talent Supply Validation Function

In JFGallegos/supplyvalidation: What the Package Does (One Line, Title Case)

Description

This function allows you to validate the talent supply counts by Local and Onet taxonomies.This files must be saved in the data science Talent Supply directory in share drive. The files with local occupation taxonomy supply counts must be saved in the Input_files folder. The files with Onet occupation taxonomy supply counts must be saved in the Output_files folder. A report with local occupation taxonomy is created for each available year in order to facilitate to the Quantitative Analyst the visual analysis of the data sets if necessary. The validation script executes the following validations, in the order specified below: Local codes files validation

1. Verify that the number of available local codes in the file at Country level is equal to the number of codes available in the State level file

2. Verify that the sum of total supply crossed local codes at State level is equal to Country level

3. Verify that the sum of supply of each occupation at Country level is less or equal than its State level counterpart. If test #3 fails, a file with all codes for which this test does not respect the constraint is saved in the error folder

4. Verify that the sum by occupation at MSA level is equal or less than its State counterpart. If test #4 fails, a file with all codes for which this test does not respect the constraint is saved in the error folder

Onet codes files validation

1. Verify that the number of available Onet codes in the file at Country level is equal to the number of Onet codes available in the State level file

2. Verify that the sum of total supply crossed Onet codes at State level is equal to Country level

3. Verify that the sum of supply by occupation at Country level is equal than its State level counterpart. If test #3 fails, a file with all codes for which this test does not respect the constraint is saved in the error folder

4. Verify that the sum by Onet occupation at MSA level is equal or less than its State counterpart.If test #4 fails, a file with all codes for which this test does not respect the constraint is saved in the error folder

Usage

supply_validation(year, country_name, user, password, occupation_type_id,
  level_occupation, Are_Onet_files_available, host)

Arguments

year	Year for which we are validating the data
country_name	Country for which we are validating the data.E.g, "South_Africa"
user	Data Base user name E.g, "user"
password	Data base password E.g, "password"
occupation_type_id	Country Occupation type id as in data base
level_occupation	Level of occupation that we are validating, this number correspond to the column level as in table norm_prod.occupations
Are_Onet_files_available	"yes" if the files with Onet supply are available and ready to be validated
host	Indicate Hostname server

Examples

supply_validation(2017,"South_Africa","user","password",20,4,"yes","10.0.5.30")

JFGallegos/supplyvalidation documentation built on May 29, 2019, 9:16 a.m.