TABLE DETAIL REFERENCE: WorkersCompCodeRateHistory
(USA VERSION)
FIELD NAME TYPE TYPENAME LENGTH QUERYABLE UPDATEABLE INSERTABLE REQUIRED
ON INSERT
VALIDATE RELATES TO
ListID12 VARCHAR 36TrueFalseFalseFalse%s Yes
TimeCreated11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
TimeModified11 TIMESTAMP 16TrueFalseFalseFalseCCCC-MM-DDThh:mm:ssZ
EditSequence12 VARCHAR 16TrueFalseFalseFalse%s
Name12 VARCHAR 31TrueFalseFalseTrue%s
IsActive-7 BIT 1TrueFalseFalseFalse
1
0
true
false
Desc12 VARCHAR 31TrueFalseFalseTrue%s
Description12 VARCHAR 4095TrueFalseFalseFalse%s
CurrentRate3 DECIMAL 18TrueFalseFalseFalse%10.5f
CurrentEffectiveDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
NextRate3 DECIMAL 18TrueFalseFalseFalse%10.5f
NextEffectiveDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
RateHistorySeqNo4 INTEGER 4TrueFalseFalseFalseSeqNo
RateHistoryRate3 DECIMAL 18TrueFalseFalseFalse%10.5f
RateHistoryEffectiveDate9 DATE 6TrueFalseFalseFalseCCCC-MM-DD
FQPrimaryKey12 VARCHAR 73TrueFalseFalseFalseFQPrimaryKey