| id |
BIGINT |
19 |
|
√ |
null |
|
|
|
| learningcomptype |
TINYINT |
3 |
|
|
null |
|
|
Type of component - program, course, competency |
| activeperiod |
VARCHAR |
20 |
√ |
|
null |
|
|
How long is the certificate active for - stored as seconds |
| minimumactiveperiod |
VARCHAR |
20 |
√ |
|
null |
|
|
When using fixed expiry date, calculated expiry dates must be at least this far in the future |
| windowperiod |
VARCHAR |
20 |
√ |
|
null |
|
|
How long before a learners certification is due for renewal and that the recertification window should open - stored as seconds |
| recertifydatetype |
BIT |
1 |
|
|
null |
|
|
Indicator for which date is used for the recertification, either the completion date or the certificate expiry date |
| timemodified |
BIGINT |
19 |
|
|
0 |
|
|
|
