Work Certifications to Employee Setup Linking Table
Field Name |
Caption |
Mask |
Description |
Field Type |
ER_ADDPAY |
% Add Pay |
nnnnnnnn.nn |
% Add Pay |
Double |
ER_ADDPAY_FLG |
Add Pay Flag |
|
Add Pay Flag |
Boolean |
ER_CERT_DT |
Certification Date |
mm/dd/yyyy |
Certification Date |
Date/Time |
ER_CERT_NO |
Certification No |
25x |
Certification No. |
Text |
ER_COMMENT1 |
Long Note |
|
Long Note |
Memo |
ER_CRT_BY |
Created By |
25x |
Created By |
Text |
ER_CRT_DTTM |
Creation Date Time |
mm/dd/yyyy hh:mm am |
Creation Date Time |
Date/Time |
ER_DAYSAHEAD |
|
nnn |
Days Ahead from the Expiration Date to Set the Notification Date |
Integer |
ER_EC_ID |
Link to WKEMPCRT |
nnnnnnnn |
Long Integer |
|
ER_EM_ID |
Link to WKUEMP |
nnnnnnnn |
Long Integer |
|
ER_EMPL_CD |
Employee |
20x |
Employee |
Text |
ER_EMPL_TY |
Employee Name |
40x |
Employee Name |
Text |
ER_EXP_DT |
Expiration Date |
mm/dd/yyyy |
Expiration Date |
Date/Time |
ER_ID |
Auto Number |
nnnnnnnn |
AutoNumber |
Long Integer |
ER_JOBREQ_FLG |
Job Required |
|
Job Required |
Boolean |
ER_MOD_BY |
Last Modified By |
25x |
Last Modified By |
Text |
ER_MOD_DT |
Last Modified Date |
mm/dd/yyyy |
Last Modified Date |
Date/Time |
ER_MOD_TM |
Last Modified Time |
hh:mm am |
Modified Time |
Date/Time |
ER_NOTI_DT |
Notification Date |
mm/dd/yyyy hh:mm am |
Notification Date |
DateTime |
ER_NOTIF_ID |
Notification |
nnnnnnnn |
Link to CMNOTIF.NOTIF_ID |
Long Integer |
ER_NSENT_FLG |
Notification Sent |
|
Notification Sent |
Boolean |
ER_RENW_DT |
Renewal Date |
mm/dd/yyyy |
Renewal Date |
Date/Time |
ER_ROWVER |
|
|
Rowversion for optimistic locking |
Date/Time |