EMPL_PHONE

The Employee Phone (EMPL_PHONE) table stores the phone number information of employees.

Costpoint Destination Table Costpoint Destination Field Costpoint Field Description Required (Y/N) Talent Management/Default Source
EMPL_PHONE EMPL_ID Employee ID Y (if auto ID generation is not enabled) user_employee_id
EMPL_PHONE MODIFIED_BY ID of the user who last created or modified row N N/A
EMPL_PHONE PHONE_EXT_CD Phone number N N/A
EMPL_PHONE PHONE_ID Phone number Y (if record is initiated) N/A
EMPL_PHONE PHONE_TYPE_DC Phone type Y (if record is initiated) phone_home, phone_work, phone_mobile, phone_pager, phone_fax, phone_data
EMPL_PHONE ROWVERSION System-assigned number to handle row concurrency N N/A
EMPL_PHONE TIME_STAMP Date and time of row creation or last modification N N/A
EMPL_PHONE SEQ_NO Sequence number N Calculated