Transact-SQL stored procedures can use the cursor data type only for OUTPUT parameters. If the cursor data type is specified for a parameter, both the VARYING and OUTPUT parameters are required. If the VARYING keyword is specified for a parameter, the data type must be cursor and the OUTPUT keyword must be specified.
There is two-year statute of limitations that applies to workers' compensation cases. A formal claim petition must be filed within two years of the date of injury or the date of last payment of compensation, whichever is later. Medical treatment authorized by the employer is considered a payment of compensation.
Terms of Payment. Some states require that insurance companies make the lump-sum payments within a time limit, in most cases 30 days. Your attorney will also be able to negotiate this deadline and will have a standard length of time written into his settlement agreement template. Fifteen or 30 days is the most common range of time for a lump-sum payment on a workers'-comp settlement.