/** HR基础中台基础资料升级，增加出厂编码，出厂名称，出厂数据编辑状态字段 **/
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_BANKPURPOSE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_BANKPURPOSE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_BANKPURPOSE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_BANKPURPOSE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_BANKPURPOSE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_BANKPURPOSE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_BANKPURPOSE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_BANKPURPOSE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LABORRELTYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_LABORRELTYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LABORRELTYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_LABORRELTYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LABORRELTYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_LABORRELTYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LABORRELTYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_LABORRELTYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LABRELSTATUSCLS' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_LABRELSTATUSCLS ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LABRELSTATUSCLS' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_LABRELSTATUSCLS ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LABRELSTATUSCLS' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_LABRELSTATUSCLS ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LABRELSTATUSCLS_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_LABRELSTATUSCLS_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LABORRELTYPECLS' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_LABORRELTYPECLS ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LABORRELTYPECLS' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_LABORRELTYPECLS ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LABORRELTYPECLS' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_LABORRELTYPECLS ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LABORRELTYPECLS_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_LABORRELTYPECLS_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LABORRELSTATUS' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_LABORRELSTATUS ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LABORRELSTATUS' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_LABORRELSTATUS ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LABORRELSTATUS' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_LABORRELSTATUS ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LABORRELSTATUS_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_LABORRELSTATUS_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LABRELSTATUSPRD' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_LABRELSTATUSPRD ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LABRELSTATUSPRD' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_LABRELSTATUSPRD ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LABRELSTATUSPRD' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_LABRELSTATUSPRD ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LABRELSTATUSPRD_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_LABRELSTATUSPRD_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_POSTYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_POSTYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_POSTYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_POSTYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_POSTYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_POSTYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_POSTYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_POSTYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROTITLETYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_PROTITLETYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROTITLETYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_PROTITLETYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROTITLETYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_PROTITLETYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROTITLETYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_PROTITLETYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROCREATSTATUS' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_PROCREATSTATUS ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROCREATSTATUS' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_PROCREATSTATUS ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROCREATSTATUS' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_PROCREATSTATUS ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROCREATSTATUS_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_PROCREATSTATUS_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_OCPQUAL' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_OCPQUAL ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_OCPQUAL' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_OCPQUAL ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_OCPQUAL' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_OCPQUAL ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_OCPQUAL_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_OCPQUAL_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_OPERATIONQUAL' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_OPERATIONQUAL ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_OPERATIONQUAL' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_OPERATIONQUAL ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_OPERATIONQUAL' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_OPERATIONQUAL ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_OPERATIONQUAL_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_OPERATIONQUAL_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROTITLELEVEL' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_PROTITLELEVEL ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROTITLELEVEL' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_PROTITLELEVEL ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROTITLELEVEL' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_PROTITLELEVEL ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROTITLELEVEL_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_PROTITLELEVEL_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_OCPQUALLEVEL' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_OCPQUALLEVEL ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_OCPQUALLEVEL' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_OCPQUALLEVEL ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_OCPQUALLEVEL' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_OCPQUALLEVEL ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_OCPQUALLEVEL_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_OCPQUALLEVEL_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_RELIGION' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_RELIGION ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_RELIGION' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_RELIGION ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_RELIGION' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_RELIGION ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_RELIGION_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_RELIGION_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PARTY' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_PARTY ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PARTY' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_PARTY ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PARTY' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_PARTY ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PARTY_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_PARTY_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROTITLE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_PROTITLE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROTITLE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_PROTITLE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROTITLE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_PROTITLE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROTITLE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_PROTITLE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_NATIONALITY' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_NATIONALITY ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_NATIONALITY' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_NATIONALITY ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_NATIONALITY' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_NATIONALITY ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_NATIONALITY_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_NATIONALITY_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_POLITICALSTATUS' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_POLITICALSTATUS ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_POLITICALSTATUS' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_POLITICALSTATUS ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_POLITICALSTATUS' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_POLITICALSTATUS ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_POLITICALSTATUS_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_POLITICALSTATUS_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ONBOARDSOURCE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_ONBOARDSOURCE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ONBOARDSOURCE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_ONBOARDSOURCE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ONBOARDSOURCE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_ONBOARDSOURCE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ONBOARDSOURCE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_ONBOARDSOURCE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_MARRIAGESTATUS' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_MARRIAGESTATUS ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_MARRIAGESTATUS' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_MARRIAGESTATUS ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_MARRIAGESTATUS' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_MARRIAGESTATUS ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_MARRIAGESTATUS_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_MARRIAGESTATUS_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ZODIAC' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_ZODIAC ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ZODIAC' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_ZODIAC ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ZODIAC' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_ZODIAC ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ZODIAC_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_ZODIAC_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_TRAINTYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_TRAINTYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_TRAINTYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_TRAINTYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_TRAINTYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_TRAINTYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_TRAINTYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_TRAINTYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_SCHOOLTYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_SCHOOLTYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_SCHOOLTYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_SCHOOLTYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_SCHOOLTYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_SCHOOLTYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_SCHOOLTYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_SCHOOLTYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_TRAINMODE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_TRAINMODE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_TRAINMODE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_TRAINMODE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_TRAINMODE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_TRAINMODE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_TRAINMODE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_TRAINMODE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_DEGREE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_DEGREE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_DEGREE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_DEGREE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_DEGREE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_DEGREE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_DEGREE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_DEGREE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_EMPGROUP' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_EMPGROUP ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_EMPGROUP' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_EMPGROUP ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_EMPGROUP' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_EMPGROUP ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_EMPGROUP_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_EMPGROUP_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CATEGORY' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_CATEGORY ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CATEGORY' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_CATEGORY ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CATEGORY' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_CATEGORY ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CATEGORY_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_CATEGORY_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_EMPNATURE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_EMPNATURE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_EMPNATURE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_EMPNATURE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_EMPNATURE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_EMPNATURE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_EMPNATURE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_EMPNATURE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_HEALTHSTATUS' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_HEALTHSTATUS ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_HEALTHSTATUS' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_HEALTHSTATUS ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_HEALTHSTATUS' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_HEALTHSTATUS ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_HEALTHSTATUS_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_HEALTHSTATUS_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_DIPLOMATYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_DIPLOMATYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_DIPLOMATYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_DIPLOMATYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_DIPLOMATYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_DIPLOMATYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_DIPLOMATYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_DIPLOMATYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_FAMILIARITY' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_FAMILIARITY ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_FAMILIARITY' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_FAMILIARITY ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_FAMILIARITY' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_FAMILIARITY ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_FAMILIARITY_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_FAMILIARITY_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CONSTELLATION' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_CONSTELLATION ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CONSTELLATION' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_CONSTELLATION ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CONSTELLATION' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_CONSTELLATION ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CONSTELLATION_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_CONSTELLATION_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_FLOK' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_FLOK ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_FLOK' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_FLOK ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_FLOK' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_FLOK ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_FLOK_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_FLOK_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_INDUSTRYTYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_INDUSTRYTYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_INDUSTRYTYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_INDUSTRYTYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_INDUSTRYTYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_INDUSTRYTYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_INDUSTRYTYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_INDUSTRYTYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CREDENTIALSTYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_CREDENTIALSTYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CREDENTIALSTYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_CREDENTIALSTYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CREDENTIALSTYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_CREDENTIALSTYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_CREDENTIALSTYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_CREDENTIALSTYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_DIPLOMA' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_DIPLOMA ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_DIPLOMA' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_DIPLOMA ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_DIPLOMA' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_DIPLOMA ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_DIPLOMA_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_DIPLOMA_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ORGTYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_ORGTYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ORGTYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_ORGTYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ORGTYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_ORGTYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ORGTYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_ORGTYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ACTION' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_ACTION ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ACTION' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_ACTION ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ACTION' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_ACTION ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ACTION_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_ACTION_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_HRBUSINESSFIELD' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_HRBUSINESSFIELD ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_HRBUSINESSFIELD' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_HRBUSINESSFIELD ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_HRBUSINESSFIELD' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_HRBUSINESSFIELD ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_HRBUSINESSFIELD_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_HRBUSINESSFIELD_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_NUMBERPREFIX' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_NUMBERPREFIX ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_NUMBERPREFIX' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_NUMBERPREFIX ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_NUMBERPREFIX' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_NUMBERPREFIX ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_NUMBERPREFIX_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_NUMBERPREFIX_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_POSTSTATE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_POSTSTATE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_POSTSTATE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_POSTSTATE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_POSTSTATE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_POSTSTATE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_POSTSTATE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_POSTSTATE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_TEAMTYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_TEAMTYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_TEAMTYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_TEAMTYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_TEAMTYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_TEAMTYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_TEAMTYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_TEAMTYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_POSTCATEGORY' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_POSTCATEGORY ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_POSTCATEGORY' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_POSTCATEGORY ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_POSTCATEGORY' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_POSTCATEGORY ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_POSTCATEGORY_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_POSTCATEGORY_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_DEPCYTYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_DEPCYTYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_DEPCYTYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_DEPCYTYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_DEPCYTYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_DEPCYTYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_DEPCYTYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_DEPCYTYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ACTIONTYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_ACTIONTYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ACTIONTYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_ACTIONTYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ACTIONTYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_ACTIONTYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ACTIONTYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_ACTIONTYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROCREATMODE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_PROCREATMODE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROCREATMODE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_PROCREATMODE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROCREATMODE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_PROCREATMODE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROCREATMODE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_PROCREATMODE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LANGUAGECERT' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_LANGUAGECERT ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LANGUAGECERT' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_LANGUAGECERT ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LANGUAGECERT' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_LANGUAGECERT ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LANGUAGECERT_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_LANGUAGECERT_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PATENTSCATEGORY' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_PATENTSCATEGORY ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PATENTSCATEGORY' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_PATENTSCATEGORY ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PATENTSCATEGORY' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_PATENTSCATEGORY ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PATENTSCATEGORY_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_PATENTSCATEGORY_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_SEX' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_SEX ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_SEX' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_SEX ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_SEX' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_SEX ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_SEX_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_SEX_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ADDRESSTYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_ADDRESSTYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ADDRESSTYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_ADDRESSTYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ADDRESSTYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_ADDRESSTYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ADDRESSTYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_ADDRESSTYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LANGUAGETYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_LANGUAGETYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LANGUAGETYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_LANGUAGETYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LANGUAGETYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_LANGUAGETYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_LANGUAGETYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_LANGUAGETYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_COMPANYSCALE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_COMPANYSCALE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_COMPANYSCALE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_COMPANYSCALE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_COMPANYSCALE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_COMPANYSCALE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_COMPANYSCALE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_COMPANYSCALE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_EMERGCONTACTYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_EMERGCONTACTYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_EMERGCONTACTYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_EMERGCONTACTYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_EMERGCONTACTYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_EMERGCONTACTYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_EMERGCONTACTYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_EMERGCONTACTYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_TRIALPERIODRESULT' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_TRIALPERIODRESULT ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_TRIALPERIODRESULT' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_TRIALPERIODRESULT ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_TRIALPERIODRESULT' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_TRIALPERIODRESULT ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_TRIALPERIODRESULT_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_TRIALPERIODRESULT_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_BLOODTYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_BLOODTYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_BLOODTYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_BLOODTYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_BLOODTYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_BLOODTYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_BLOODTYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_BLOODTYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_FAMILYMEMBERREL' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_FAMILYMEMBERREL ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_FAMILYMEMBERREL' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_FAMILYMEMBERREL ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_FAMILYMEMBERREL' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_FAMILYMEMBERREL ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_FAMILYMEMBERREL_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_FAMILYMEMBERREL_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_SUPSERTYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_SUPSERTYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_SUPSERTYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_SUPSERTYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_SUPSERTYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_SUPSERTYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_SUPSERTYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_SUPSERTYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_SUPPLIERLEVEL' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_SUPPLIERLEVEL ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_SUPPLIERLEVEL' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_SUPPLIERLEVEL ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_SUPPLIERLEVEL' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_SUPPLIERLEVEL ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_SUPPLIERLEVEL_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_SUPPLIERLEVEL_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_BUSSINESSFIELD' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_BUSSINESSFIELD ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_BUSSINESSFIELD' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_BUSSINESSFIELD ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_BUSSINESSFIELD' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_BUSSINESSFIELD ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_BUSSINESSFIELD_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_BUSSINESSFIELD_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_EDUCERTTYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_EDUCERTTYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_EDUCERTTYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_EDUCERTTYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_EDUCERTTYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_EDUCERTTYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_EDUCERTTYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_EDUCERTTYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_POSTSTATECLS' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_POSTSTATECLS ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_POSTSTATECLS' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_POSTSTATECLS ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_POSTSTATECLS' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_POSTSTATECLS ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_POSTSTATECLS_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_POSTSTATECLS_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_REWPNMLEVEL' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_REWPNMLEVEL ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_REWPNMLEVEL' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_REWPNMLEVEL ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_REWPNMLEVEL' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_REWPNMLEVEL ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_REWPNMLEVEL_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_REWPNMLEVEL_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ONBOARDTYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_ONBOARDTYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ONBOARDTYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_ONBOARDTYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ONBOARDTYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_ONBOARDTYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_ONBOARDTYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_ONBOARDTYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROJECTTYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_PROJECTTYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROJECTTYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_PROJECTTYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROJECTTYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_PROJECTTYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_PROJECTTYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_PROJECTTYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_REWPNMTYPE' AND KSQL_COL_NAME ='FORINUMBER')
 ALTER TABLE T_HBSS_REWPNMTYPE ADD (FORINUMBER VARCHAR(60) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_REWPNMTYPE' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_REWPNMTYPE ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_REWPNMTYPE' AND KSQL_COL_NAME ='FORISTATUS')
 ALTER TABLE T_HBSS_REWPNMTYPE ADD (FORISTATUS VARCHAR(2) DEFAULT ' ' NOT NULL );
IF NOT EXISTS (SELECT 1 FROM KSQL_USERCOLUMNS WHERE KSQL_COL_TABNAME = 'T_HBSS_REWPNMTYPE_L' AND KSQL_COL_NAME ='FORINAME')
 ALTER TABLE T_HBSS_REWPNMTYPE_L ADD (FORINAME NVARCHAR(100) DEFAULT ' ' NOT NULL );

