Employee Certification Classes
Field Name |
Caption |
Mask |
Description |
Field Type |
CC_CCOST |
Class Cost |
nnnnnnnn.nn |
Class Cost |
Double |
CC_CEU |
CEUs |
nn.nn |
CEUs |
Double |
CC_COURSE |
Course Name |
50x |
Course Name |
Text |
CC_CRT_BY |
Created By |
25x |
Created By |
Text |
CC_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
CC_CTYP_CD |
Cost Type |
nnn |
Cost Type |
Integer |
CC_CTYP_TY |
Cost Type Text |
25x |
Cost Type Text |
String |
CC_DAYSAHEAD |
Days Ahead |
nnn |
Days Ahead from the Expiration Date to Set the Notification Date |
Integer |
CC_DESC |
Description |
50x |
Description |
Text |
CC_DL |
Degree/License |
|
Degree/License |
Boolean |
CC_DOC_FLG |
Document Available |
|
Document Attached |
Boolean |
CC_EC_ID |
Certification Rec # |
nnnnnnnn |
Long Integer |
|
CC_END_DT |
End Date |
mm/dd/yyyy |
End Date |
Date/Time |
CC_END_TM |
End Time |
hh:mm am |
End Time |
Date/Time |
CC_ENTITY |
Cert Entity |
50x |
Certifying Entity |
Text |
CC_HOURS |
Hours |
nnnnnnnn.nn |
Hours |
Double |
CC_ID |
Classes Rec # |
nnnnnnnn |
AutoID Number |
Long Integer |
CC_IMG_FLG |
|
|
Image Available |
Boolean |
CC_LOC |
Location |
50x |
Location |
Text |
CC_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
CC_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
CC_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
CC_MOV_FLG |
|
|
Movie Available |
Boolean |
CC_NOTES |
Notes |
250x |
Notes |
String |
CC_NOTI_DT |
Notification Date |
mm/dd/yyyy hh:mm am |
Notification Date |
DateTime |
CC_NOTIF_ID |
Notification |
nnnnnnnn |
Long Integer |
|
CC_NSENT_FLG |
Notification Sent |
|
Notification Sent |
Boolean |
CC_NUM |
Number |
20x |
Number |
Text |
CC_OREGION |
Outside of Region |
|
Outside of Region |
Boolean |
CC_PDH |
PDHs |
nn.nn |
PDHs |
Double |
CC_PRBY_CD |
Presented By |
10x |
Presented By |
String |
CC_PRBY_TY |
Presented By Text |
60x |
Presented By Text |
String |
CC_REQUIRED |
Required |
|
Required |
Boolean |
CC_RES_CD |
Results |
nnn |
Results |
Integer |
CC_RES_TY |
Results Text |
25x |
Results Text |
Text |
CC_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |
CC_STRT_DT |
Start Date |
mm/dd/yyyy |
Start Date |
Date/Time |
CC_STRT_TM |
Start Time |
hh:mm am |
Start Time |
Date/Time |
CC_TCOST |
Total Cost |
nnnnnnnn.nn |
Total Cost |
Double |
CC_TYPE_CD |
Class Type |
nnn |
Class Type |
Integer |
CC_TYPE_TY |
Class Type Text |
25x |
Class Type Text |
Text |
CC_USER1CD |
User 1 |
nnn |
User 1 |
Integer |
CC_USER1TY |
User 1 Text |
25x |
User 1 Text |
Text |
CC_USER2CD |
User 2 |
nnn |
User 2 |
Integer |
CC_USER2TY |
User 2 Text |
25x |
User 2 Text |
Text |
CC_USER3CD |
User 3 |
nnn |
User 3 |
Integer |
CC_USER3TY |
User 3 Text |
25x |
User 3 Text |
Text |
CC_USER4 |
User 4 |
30x |
User 4 |
Text |
CC_USER5 |
User 5 |
30x |
User 5 |
Text |
CC_USER6 |
User 6 |
30x |
User 6 |
Text |
CC_USER7 |
User 7 |
-nnnnnnnn.nn |
User 7 |
Double |
CC_USER8 |
User 8 |
-nnnnnnnn.nn |
User 8 |
Double |
CC_USER9 |
User 9 |
-nnnnnnnn.nn |
User 9 |
Double |
CC_USER10 |
User 10 |
mm/dd/yyyy |
User 10 |
Date/Time |
CC_USER11 |
User 11 |
mm/dd/yyyy |
User 11 |
Date/Time |
CC_USER12 |
User 12 |
mm/dd/yyyy |
User 12 |
Date/Time |
CC_USER13 |
User 13 |
|
User 13 |
Boolean |
CC_USER14 |
User 14 |
|
User 14 |
Boolean |
CC_USER15 |
User 15 |
|
User 15 |
Boolean |
CC_USER16CD |
User 16 |
nnn |
User 16 |
Integer |
CC_USER16TY |
User 16 Text |
50x |
User 16 Text |
String |
CC_USER17CD |
User 17 |
nnn |
User 17 |
Integer |
CC_USER17TY |
User 17 Text |
50x |
User 17 Text |
String |
CC_USER18CD |
User 18 |
nnn |
User 18 |
Integer |
CC_USER18TY |
User 18 Text |
50x |
User 18 Text |
String |
CC_USER19CD |
User 19 |
nnn |
User 19 |
Integer |
CC_USER19TY |
User 19 Text |
50x |
User 19 Text |
String |
CC_USER20CD |
User 20 |
nnn |
User 20 |
Integer |
CC_USER20TY |
User 20 Text |
50x |
User 20 Text |
String |
CC_USER21 |
User 21 |
50x |
User 21 |
String |
CC_USER22 |
User 22 |
50x |
User 22 |
String |
CC_USER23 |
User 23 |
50x |
User 23 |
String |
CC_USER24 |
User 24 |
50x |
User 24 |
String |
CC_USER25 |
User 25 |
50x |
User 25 |
String |
CC_USER26 |
User 26 |
nnnnnnnn.nn |
User 26 |
Double |
CC_USER27 |
User 27 |
nnnnnnnn.nn |
User 27 |
Double |
CC_USER28 |
User 28 |
nnnnnnnn.nn |
User 28 |
Double |
CC_USER29 |
User 29 |
nnnnnnnn.nn |
User 29 |
Double |
CC_USER30 |
User 30 |
nnnnnnnn.nn |
User 30 |
Double |
CC_USER31 |
User 31 |
mm/dd/yyyy hh:mm am |
User 31 |
DateTime |
CC_USER32 |
User 32 |
mm/dd/yyyy hh:mm am |
User 32 |
DateTime |
CC_USER33 |
User 33 |
mm/dd/yyyy hh:mm am |
User 33 |
DateTime |
CC_USER34 |
User 34 |
mm/dd/yyyy hh:mm am |
User 34 |
DateTime |
CC_USER35 |
User 35 |
mm/dd/yyyy hh:mm am |
User 35 |
DateTime |
CC_USER36 |
User 36 |
|
User 36 |
Boolean |
CC_USER37 |
User 37 |
|
User 37 |
Boolean |
CC_USER38 |
User 38 |
|
User 38 |
Boolean |
CC_USER39 |
User 39 |
|
User 39 |
Boolean |
CC_USER40 |
User 40 |
|
User 40 |
Boolean |