VFS_TEST
Normal
/
ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDTRANSNAMEYTRANSNAMESTATUSYSTATUSLINES_READYLINES_READLINES_WRITTENYLINES_WRITTENLINES_UPDATEDYLINES_UPDATEDLINES_INPUTYLINES_INPUTLINES_OUTPUTYLINES_OUTPUTLINES_REJECTEDYLINES_REJECTEDERRORSYERRORSSTARTDATEYSTARTDATEENDDATEYENDDATELOGDATEYLOGDATEDEPDATEYDEPDATEREPLAYDATEYREPLAYDATELOG_FIELDYLOG_FIELDEXECUTING_SERVERNEXECUTING_SERVEREXECUTING_USERNEXECUTING_USERCLIENTNCLIENT
ID_BATCHYID_BATCHSEQ_NRYSEQ_NRLOGDATEYLOGDATETRANSNAMEYTRANSNAMESTEPNAMEYSTEPNAMESTEP_COPYYSTEP_COPYLINES_READYLINES_READLINES_WRITTENYLINES_WRITTENLINES_UPDATEDYLINES_UPDATEDLINES_INPUTYLINES_INPUTLINES_OUTPUTYLINES_OUTPUTLINES_REJECTEDYLINES_REJECTEDERRORSYERRORSINPUT_BUFFER_ROWSYINPUT_BUFFER_ROWSOUTPUT_BUFFER_ROWSYOUTPUT_BUFFER_ROWS
ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDLOG_DATEYLOG_DATELOGGING_OBJECT_TYPEYLOGGING_OBJECT_TYPEOBJECT_NAMEYOBJECT_NAMEOBJECT_COPYYOBJECT_COPYREPOSITORY_DIRECTORYYREPOSITORY_DIRECTORYFILENAMEYFILENAMEOBJECT_IDYOBJECT_IDOBJECT_REVISIONYOBJECT_REVISIONPARENT_CHANNEL_IDYPARENT_CHANNEL_IDROOT_CHANNEL_IDYROOT_CHANNEL_ID
ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDLOG_DATEYLOG_DATETRANSNAMEYTRANSNAMESTEPNAMEYSTEPNAMESTEP_COPYYSTEP_COPYLINES_READYLINES_READLINES_WRITTENYLINES_WRITTENLINES_UPDATEDYLINES_UPDATEDLINES_INPUTYLINES_INPUTLINES_OUTPUTYLINES_OUTPUTLINES_REJECTEDYLINES_REJECTEDERRORSYERRORSLOG_FIELDNLOG_FIELD
ID_BATCHYID_BATCHCHANNEL_IDYCHANNEL_IDLOG_DATEYLOG_DATEMETRICS_DATEYMETRICS_DATEMETRICS_CODEYMETRICS_CODEMETRICS_DESCRIPTIONYMETRICS_DESCRIPTIONMETRICS_SUBJECTYMETRICS_SUBJECTMETRICS_TYPEYMETRICS_TYPEMETRICS_VALUEYMETRICS_VALUE
0.0
0.0
10000
50
50
N
Y
50000
Y
N
1000
100
-
2015/10/19 17:57:07.411
-
2015/10/19 17:57:07.411
N
SG_AHT
MSSQL
JNDI
SG_AHT
1521
Encrypted
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
INITIAL_POOL_SIZE
5
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
MSSQL_DOUBLE_DECIMAL_SEPARATOR
N
PORT_NUMBER
1521
PRESERVE_RESERVED_WORD_CASE
N
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
Y
SUPPORTS_TIMESTAMP_DATA_TYPE
Y
USE_POOLING
Y
SG_DWS
${SG_TEST_HOST}
MYSQL
JNDI
SG_DWS
${SG_TEST_PORT}
Encrypted
EXTRA_OPTION_MYSQL.rewriteBatchedStatments
true
EXTRA_OPTION_MYSQL.useCompression
true
EXTRA_OPTION_MYSQL.useServerPrepStmts
false
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
INITIAL_POOL_SIZE
5
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
PORT_NUMBER
${SG_TEST_PORT}
PRESERVE_RESERVED_WORD_CASE
N
QUOTE_ALL_FIELDS
N
STREAM_RESULTS
Y
SUPPORTS_BOOLEAN_DATA_TYPE
N
SUPPORTS_TIMESTAMP_DATA_TYPE
N
USE_POOLING
Y
SG_JDE
AS/400
JNDI
SG_JDE
1521
Encrypted
EXTRA_OPTION_AS/400.block size
64
EXTRA_OPTION_AS/400.data compression
true
EXTRA_OPTION_AS/400.errors
full
EXTRA_OPTION_AS/400.translate binary
true
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
INITIAL_POOL_SIZE
5
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
PORT_NUMBER
1521
PRESERVE_RESERVED_WORD_CASE
N
QUOTE_ALL_FIELDS
Y
SUPPORTS_BOOLEAN_DATA_TYPE
N
SUPPORTS_TIMESTAMP_DATA_TYPE
N
USE_POOLING
Y
SG_LEGIANT
MSSQL
JNDI
SG_LEGIANT
1521
Encrypted
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
INITIAL_POOL_SIZE
5
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
MSSQL_DOUBLE_DECIMAL_SEPARATOR
N
PORT_NUMBER
1521
PRESERVE_RESERVED_WORD_CASE
N
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
Y
SUPPORTS_TIMESTAMP_DATA_TYPE
N
USE_POOLING
Y
SG_LG
MSSQL
JNDI
SG_LG
1521
Encrypted
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
MSSQL_DOUBLE_DECIMAL_SEPARATOR
N
PORT_NUMBER
1521
PRESERVE_RESERVED_WORD_CASE
N
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
Y
SUPPORTS_TIMESTAMP_DATA_TYPE
Y
USE_POOLING
N
SG_LG_ARCHIVE
MSSQL
JNDI
SG_LG_ARCHIVE
1521
Encrypted
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
MSSQL_DOUBLE_DECIMAL_SEPARATOR
N
PORT_NUMBER
1521
PRESERVE_RESERVED_WORD_CASE
N
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
Y
SUPPORTS_TIMESTAMP_DATA_TYPE
Y
USE_POOLING
N
SG_LG_CP
MSSQL
JNDI
SG_LG_CP
1521
Encrypted
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
INITIAL_POOL_SIZE
5
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
MSSQL_DOUBLE_DECIMAL_SEPARATOR
N
PORT_NUMBER
1521
PRESERVE_RESERVED_WORD_CASE
N
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
Y
SUPPORTS_TIMESTAMP_DATA_TYPE
Y
USE_POOLING
Y
SG_LG_PG
MSSQL
JNDI
SG_LG_PG
1521
Encrypted
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
INITIAL_POOL_SIZE
5
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
MSSQL_DOUBLE_DECIMAL_SEPARATOR
N
PORT_NUMBER
1521
PRESERVE_RESERVED_WORD_CASE
N
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
Y
SUPPORTS_TIMESTAMP_DATA_TYPE
Y
USE_POOLING
Y
SG_LG_PP
MSSQL
JNDI
SG_LG_PP
1521
Encrypted
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
INITIAL_POOL_SIZE
5
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
MSSQL_DOUBLE_DECIMAL_SEPARATOR
N
PORT_NUMBER
1521
PRESERVE_RESERVED_WORD_CASE
N
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
Y
SUPPORTS_TIMESTAMP_DATA_TYPE
Y
USE_POOLING
Y
SG_LG_RV
MSSQL
JNDI
SG_LG_RV
1521
Encrypted
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
INITIAL_POOL_SIZE
5
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
MSSQL_DOUBLE_DECIMAL_SEPARATOR
N
PORT_NUMBER
1521
PRESERVE_RESERVED_WORD_CASE
N
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
Y
SUPPORTS_TIMESTAMP_DATA_TYPE
Y
USE_POOLING
Y
SG_LG_SR
MSSQL
JNDI
SG_LG_SR
1521
Encrypted
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
INITIAL_POOL_SIZE
5
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
MSSQL_DOUBLE_DECIMAL_SEPARATOR
N
PORT_NUMBER
1521
PRESERVE_RESERVED_WORD_CASE
N
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
Y
SUPPORTS_TIMESTAMP_DATA_TYPE
Y
USE_POOLING
Y
SG_MARIADB
${SG_TEST_HOST}
MYSQL
JNDI
SG_MARIADB
${SG_TEST_PORT}
Encrypted
EXTRA_OPTION_MYSQL.rewriteBatchedStatments
true
EXTRA_OPTION_MYSQL.useCompression
true
EXTRA_OPTION_MYSQL.useServerPrepStmts
false
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
INITIAL_POOL_SIZE
5
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
PORT_NUMBER
${SG_TEST_PORT}
PRESERVE_RESERVED_WORD_CASE
N
QUOTE_ALL_FIELDS
N
STREAM_RESULTS
Y
SUPPORTS_BOOLEAN_DATA_TYPE
N
SUPPORTS_TIMESTAMP_DATA_TYPE
N
USE_POOLING
Y
SG_MSSQL_JNDI
MSSQL
JNDI
${JNDI_NAME}
1521
Encrypted
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
IS_CLUSTERED
N
MSSQL_DOUBLE_DECIMAL_SEPARATOR
N
PORT_NUMBER
1521
PRESERVE_RESERVED_WORD_CASE
N
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
Y
SUPPORTS_TIMESTAMP_DATA_TYPE
Y
USE_POOLING
N
SG_PCC
MSSQL
JNDI
SG_PCC
1521
Encrypted
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
INITIAL_POOL_SIZE
5
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
MSSQL_DOUBLE_DECIMAL_SEPARATOR
N
PORT_NUMBER
1521
PRESERVE_RESERVED_WORD_CASE
N
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
Y
SUPPORTS_TIMESTAMP_DATA_TYPE
Y
USE_POOLING
Y
SG_QC
MSSQL
JNDI
SG_QC
1521
Encrypted
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
INITIAL_POOL_SIZE
5
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
MSSQL_DOUBLE_DECIMAL_SEPARATOR
N
PORT_NUMBER
1521
PRESERVE_RESERVED_WORD_CASE
N
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
Y
SUPPORTS_TIMESTAMP_DATA_TYPE
Y
USE_POOLING
Y
SG_VERTICA
VERTICA
JNDI
SG_VERTICA
1521
Encrypted
FORCE_IDENTIFIERS_TO_LOWERCASE
N
FORCE_IDENTIFIERS_TO_UPPERCASE
N
INITIAL_POOL_SIZE
5
IS_CLUSTERED
N
MAXIMUM_POOL_SIZE
10
PORT_NUMBER
1521
PRESERVE_RESERVED_WORD_CASE
N
QUOTE_ALL_FIELDS
N
SUPPORTS_BOOLEAN_DATA_TYPE
Y
SUPPORTS_TIMESTAMP_DATA_TYPE
Y
USE_POOLING
Y
InputDummy (do nothing)Y
Input
ExcelInput
Y
1
none
Y
N
0
Y
N
sftp://${VFS_USERNAME}@${VFS_IP}${VFS_ROOT_DIR}/Shared/input/original_facility_dimension_2.xls
N
N
N
N
FACILITY_DATE_FROM
Date
-1
-1
both
N
MM/dd/yyyy HH.mm.ss
FACILITY_DATE_TO
Date
-1
-1
both
N
MM/dd/yyyy HH.mm.ss
FACILITY_DK
Integer
-1
-1
both
N
FACILITY_SK
Integer
-1
-1
both
N
ACCOUNTING_NUMBER
String
-1
-1
both
N
FACILITY
String
-1
-1
both
N
APPLICATION
String
-1
-1
both
N
FACILITY_MDX
String
-1
-1
both
N
FACILITY_SK_REPORTING
String
-1
-1
both
N
LOCATION
String
-1
-1
both
N
SHORT_NAME
String
-1
-1
both
N
LEGAL_ENTITY
String
-1
-1
both
N
MANAGEMENT_COMPANY
String
-1
-1
both
N
FACILITY_ID
String
-1
-1
both
N
DBNAME
String
-1
-1
both
N
ADDRESS_1
String
-1
-1
both
N
ADDRESS_2
String
-1
-1
both
N
CITY
String
-1
-1
both
N
STATE
String
-1
-1
both
N
ZIPCODE
String
-1
-1
both
N
GEOGRAPHICAL_REGION
String
-1
-1
both
N
LATITUDE
String
-1
-1
both
N
LONGITUDE
String
-1
-1
both
N
PHONE
String
-1
-1
both
N
FAX
String
-1
-1
both
N
CLNF
Integer
-1
-1
both
N
#
NFBLDG
Integer
-1
-1
both
N
#
BLDGNM
String
-1
-1
both
N
STATE_SNF_LICENSE
Integer
-1
-1
both
N
#
ISSUED_DATE
Date
-1
-1
both
N
MM/dd/yyyy HH.mm.ss
EXPIRATION_DATE
Date
-1
-1
both
N
MM/dd/yyyy HH.mm.ss
STATE_FACILITY_MDS
String
-1
-1
both
N
MDS_NAME
String
-1
-1
both
N
PAY_GROUP
String
-1
-1
both
N
ISACTIVE
String
-1
-1
both
N
ADMIN_EMAIL
String
-1
-1
both
N
ADMIN_USER
String
-1
-1
both
N
ADMIN_NAME
String
-1
-1
both
N
EXEC_EMAIL
String
-1
-1
both
N
EXEC_USER
String
-1
-1
both
N
RDO_EMAIL
String
-1
-1
both
N
RDO_USER
String
-1
-1
both
N
RDO_NAME
String
-1
-1
both
N
COO_USER
String
-1
-1
both
N
COO_NAME
String
-1
-1
both
N
COO_EMAIL
String
-1
-1
both
N
MARKETING_NAME
String
-1
-1
both
N
START_DATE
Date
-1
-1
both
N
MM/dd/yyyy HH.mm.ss
END_DATE
Date
-1
-1
both
N
MM/dd/yyyy HH.mm.ss
INVESTMENT_GROUP
String
-1
-1
both
N
FACILITY_SHORT
String
-1
-1
both
N
ORDINAL
Integer
-1
-1
both
N
#
COMBINED_CAMPUS
Integer
-1
-1
both
N
#
SPLIT_CAMPUS
Integer
-1
-1
both
N
#
MEDICARE_PROVIDER_NUMBER
Integer
-1
-1
both
N
#
MEDICAID_PROVIDER_NUMBER
String
-1
-1
both
N
NATIONAL_PROVIDER_ID
Integer
-1
-1
both
N
#
FEDERAL_TAX_ID
String
-1
-1
both
N
STATE_TAX_ID
Integer
-1
-1
both
N
#
MACHOCK_FILTER
Integer
-1
-1
both
N
#
URL
String
-1
-1
both
N
OMNICARE_ID
Integer
-1
-1
both
N
BASE_FILTER
Integer
-1
-1
both
N
#
ALF_FILTER
Integer
-1
-1
both
N
#
PROPERTY_TYPE
String
-1
-1
both
N
FLASH_LEVEL
String
-1
-1
both
N
ORDINAL_IS_DASH
Integer
-1
-1
both
N
#
LIC_BEDS
Integer
-1
-1
both
N
#
AVAIL_BEDS
Integer
-1
-1
both
N
#
OPS_FILTER
Integer
-1
-1
both
N
#
DIVISION
String
-1
-1
both
N
JNDI_NAME
String
-1
-1
both
N
PARENT_SK
Integer
-1
-1
none
N
PARENT_DK
Integer
-1
-1
none
N
Sheet1
0
0
N
N
N
warning
error
line
JXL
102
120
Y
Dummy (do nothing)
Dummy
Y
1
none
288
128
Y
N