
 EXEC P_ALTERPK 'PK_HRCS_WARNCALFIELD', 'T_HRCS_WARNCALFIELD', 'FID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_WARNCALFIELD_FNUMBER') CREATE INDEX IDX_HRCS_WARNCALFIELD_FNUMBER ON T_HRCS_WARNCALFIELD ( FNUMBER );


 EXEC P_ALTERPK 'PK_HRCS_WARNCALFIELD_L', 'T_HRCS_WARNCALFIELD_L', 'FPKID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_WARNCALFIELD_L') CREATE INDEX IDX_HRCS_WARNCALFIELD_L ON T_HRCS_WARNCALFIELD_L ( FLOCALEID ,FID );


 EXEC P_ALTERPK 'PK_HRCS_WARNCALREFFIELD', 'T_HRCS_WARNCALREFFIELD', 'FENTRYID', '1';

 IF NOT EXISTS (SELECT 1 FROM KSQL_INDEXES WHERE KSQL_INDNAME = 'IDX_HRCS_WARNCALREFFIELD') CREATE INDEX IDX_HRCS_WARNCALREFFIELD ON T_HRCS_WARNCALREFFIELD ( FID );
