WorkersCompCodeRateHistory Table

Back to list of tables.

ColumnData typeData type nameLengthCan be queried?Can be updated?Can be inserted?Mandatory when inserting?FormatRefers ToVersion introduced inEdition available in
ID12VARCHAR75TrueFalseFalseFalse%s7.0US
ListID12VARCHAR12TrueFalseFalseFalse%s7.0US
TimeCreated93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ7.0US
TimeModified93TIMESTAMP23TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ7.0US
EditSequence12VARCHAR16TrueFalseFalseFalse%s7.0US
Name12VARCHAR31TrueFalseFalseTrue%s7.0US
IsActive-7BIT2TrueFalseFalseFalse
1
0
true
false
7.0US
Description12VARCHAR31TrueFalseFalseTrue%s7.0US
CurrentRate2NUMERIC15TrueFalseFalseFalse%10.5f7.0US
CurrentEffectiveDate91DATE10TrueFalseFalseFalseCCCC-MM-DD7.0US
NextRate2NUMERIC15TrueFalseFalseFalse%10.5f7.0US
NextEffectiveDate91DATE10TrueFalseFalseFalseCCCC-MM-DD7.0US
RateEntry_SeqNo4INTEGER9TrueFalseFalseFalseSeqNo7.0US
RateEntry_Rate2NUMERIC15TrueFalseFalseFalse%10.5f7.0US
RateEntry_EffectiveDate91DATE10TrueFalseFalseFalseCCCC-MM-DD7.0US
RQUseCachedID-7BIT2TrueFalseFalseFalse
1
0
true
false
7.0US