VocabularyUpdate/Update_HCPCS.properties at master · dimshitc/VocabularyUpdate · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
#*******************************************
#  Properties for HCPCS vocabulary update  *
#  Version 0.0.6                           *
#*******************************************

# Common
vocabulary.display.name=HCPCS
basePath=.\\vocabulary_data\\dev_hcpcs

# Database
db.userName=DEV_HCPCS
db.password=DEV_HCPCS
db.tnsName=ORCL

# Build bootstrap action
startUpdate.description=Start Update

# Fast recreate phase (SQL-based)
fastRecreate.description=Fast Recreate
#fastRecreate.sqlFileName=00.fast_recreate_schema.sql
fastRecreate.sqlFileName=mock\\00.mock_fast_recreate_schema.sql
fastRecreate.logFileName=fast_recreate.log
fastRecreate.streamLogFileName=fast_recreate_stream.log
fastRecreate.streamErrFileName=fast_recreate_stream.err

# Create source file phase (SQL-based)
createSourceTable.description=Create Source Table
#createSourceTable.sqlFileName=01.create_source_tables.sql
createSourceTable.sqlFileName=mock\\01.mock_create_source_tables.sql
createSourceTable.logFileName=create_source_table.log
createSourceTable.streamLogFileName=create_source_table_stream.log
createSourceTable.streamErrFileName=create_source_table_stream.err

# Download vocabulary update package phase
downloadUpdatePack.description=Download
downloadUpdatePack.fileUrl=https://www.cms.gov/Medicare/Coding/HCPCSReleaseCodeSets/Downloads/2017-Alpha-Numeric-HCPCS-File.zip

# Extract phase
extractFiles.description=Extract

# Covert phase
xls2Csv.description=Convert from XLS to CSV
xls2Csv.srcFileName=HCPC17_CONTR_ANWEB.xlsx
xls2Csv.destFileName=ANWEB_V2.csv

# Import data phase
import.description=Import
import.controlFileName=ANWEB_V2.ctl
importData.dataFileName=ANWEB_V2.csv
importData.logFileName=ANWEB_V2.log
importData.discardFileName=ANWEB_V2.dsc
importData.badFileName=ANWEB_V2.bad
importData.streamLogFileName=import_data_stream.log
importData.streamErrFileName=import_data_stream.err

# Load stage phase (SQL-based)
loadStage.description=Load Stage
#loadStage.sqlFileName=03.load_stage.sql
loadStage.sqlFileName=mock\\03.mock_load_stage.sql
loadStage.logFileName=load_stage.log
loadStage.logProcedureDrugFileName=procedure_drug.log
loadStage.logMapDrugVocabularyFileName=map_drug_vocabulary.log
loadStage.streamLogFileName=load_stage_stream.log
loadStage.streamErrFileName=load_stage_stream.err

# Generic update phase (SQL-based)
genericUpdate.description=Generic Update
#genericUpdate.sqlFileName=04.generic_update.sql
genericUpdate.sqlFileName=mock\\04.mock_generic_update.sql
genericUpdate.logFileName=generic_update.log
genericUpdate.streamLogFileName=generic_update_stream.log
genericUpdate.streamErrFileName=generic_update_stream.err

# Check update results phase (SQL-based)
checkUpdateResults.description=Check Update Results
#checkUpdateResults.sqlFileName=05.update_results.sql
checkUpdateResults.sqlFileName=mock\\05.mock_update_results.sql
checkUpdateResults.logFileName=update_results.log
checkUpdateResults.streamLogFileName=update_results_stream.log
checkUpdateResults.streamErrFileName=update_results_stream.err