Warning and Error Messages

When errors are encountered during the importing of vendor employees, messages may display.

VEND_EMPL

Field	Description
Vendor ID	Error Message Meaning/Related Information Must exist in input file. The Vendor ID is null. Contains invalid character(s). IF Vendor ID is not null AND Vendor ID contains invalid characters. Not found in VEND table. IF Vendor ID is not null AND Vendor ID does not exist in VEND table. Must have a parent record. Already exists in another company. IF Vendor ID is not null AND Vendor ID exists in VEND table for another Company ID. Cannot have <vendor employee> if <vendor> is linked to an <employee>. IF Vendor ID is not null AND Vendor ID exists in VEND table for current Company ID AND Employee ID in VEND table is not null. Existing Vendor linked to an Employee CANNOT have Vendor Employees.
Vendor Employee ID	Error Message Meaning/Related Information Must exist in input file. The Vendor Employee ID is null. Contains invalid character(s). IF Vendor Employee ID is not null AND Vendor Employee ID contains invalid characters.
Vendor Employee ID, Vendor ID	Error Message Meaning/Related Information Already exists for another <vendor> in this company. IF Vendor Employee ID is not null AND Vendor Employee ID exists in VEND_EMPL table or input file for another Vendor ID in current Company ID. Input file contains duplicate record. IF Vendor Employee ID is not null AND Vendor ID is not null AND (Vendor Employee ID + Vendor ID) is duplicated in input file for current Company ID.
Last Name	Error Message Meaning/Related Information Must exist in input file. IF Last Name is null AND Vendor Employee is new.
First Name	Error Message Meaning/Related Information Must exist in input file. IF First Name is null AND Vendor Employee is new.
Vendor Employee Status	Error Message Meaning/Related Information Must be A or I. IF Vendor Employee Status is not null AND Vendor Employee Status <> A or I.
T&E Employee ID	Error Message Meaning/Related Information Contains invalid character(s). IF T&E Employee ID is not null AND T&E Employee ID contains invalid characters. Already exists for another <vendor employee> in the VEND_EMPL input file. IF T&E Employee ID is not null AND T&E Employee ID exists in VEND_EMPL input file for another Vendor Employee ID. Already exists for another <vendor employee> in the VEND_EMPL table. IF T&E Employee ID is not null AND T&E Employee ID exists in VEND_EMPL table for another Vendor Employee ID. Already exists for another <employee> in the EMPL table. IF T&E Employee ID is not null AND T&E Employee ID exists (as Employee ID) in EMPL table.
Vendor Employee Approver ID	Error Message Meaning/Related Information Not found in EMPL table. IF Vendor Employee Approver ID is not null AND Vendor Employee Approver ID does not exist in EMPL table AND Vendor Employee Requires Approval in AP_SETTINGS.
Vendor Employee Approval Status Date	Warning Message Meaning/Related Information Will be set to the system date. IF Vendor Employee Approval Status Date is null AND Vendor Employee Approver ID is not null AND Vendor Employee Requires Approval in AP_SETTINGS
Vendor Employee Approval Status	Error Message Meaning/Related Information Must be A, P, or R. IF Vendor Employee Approval Status is not null AND Vendor Employee Approval Status <> A, P, or R. If null, there will be no error or warning but Costpoint will do the following: Set it to A, if the Subcontractor Vendor Employee Approval - Requires Approval check box in Configure Accounts Payable Settings is not selected. Set it to P, if the Subcontractor Vendor Employee Approval - Requires Approval check box in Configure Accounts Payable Settings is selected.
US Citizen Flag	Error Message Meaning/Related Information Must be Y or N. IF US Citizen Flag is not null AND US Citizen Flag <> Y or N. If null, there will be no error or warning but the system will set it to N (default).
ITAR Status Code	Error Message Meaning/Related Information Must be U, F, N, or NA. IF ITAR Status Code is not null AND ITAR Status Code <> U, F, N, or NA. If null, there will be no error or warning but the system will set it to N (default).

VE_LAB_INFO

Field	Description
Vendor ID	Error Message Meaning/Related Information Must exist in input file. Vendor ID is null.
Vendor Employee ID	Error Message Meaning/Related Information Must exist in input file. Vendor Employee ID is null.
Effective Start Date	Error Message Meaning/Related Information Must exist in input file. Effective Start Date is null.
Vendor Employee ID, Vendor ID	Error Message Meaning/Related Information Not found in VEND_EMPL input file and VEND_EMPL table. IF Vendor Employee ID is not null AND Vendor ID is not null AND (Vendor Employee ID + Vendor ID) does not exist in VEND_EMPL input file for current Company ID AND (Vendor Employee ID + Vendor ID) does not exist in VEND_EMPL table for current Company ID.
Vendor Employee ID, Vendor ID, Effective Start Date	Error Message Meaning/Related Information Input file contains duplicate record. IF Vendor Employee ID is not null AND Vendor ID is not null AND Effective Start Date is not null AND (Vendor Employee ID + Vendor ID + Effective Start Date) is duplicated in input file for current Company ID.
Default GLC	Error Message Meaning/Related Information Required if T&E <employee>ID is not blank. IF Default GLC is null AND T&E Employee ID in VEND_EMPL table or input file is not null Not found in GEN_LAB_CAT table. IF Default GLC is not null AND Default GLC does not exist in GEN_LAB_CAT table.
Default PLC	Error Message Meaning/Related Information Required if T&E <employee> ID is not blank. IF Default PLC is null AND T&E Employee ID in VEND_EMPL table or input file is not null Not found in BILL_LAB_CAT table. IF Default PLC is not null AND Default PLC does not exist in BILL_LAB_CAT table.
Default Pay Type	Error Message Meaning/Related Information Not found in PAY_TYPE table. IF Default Pay Type is not null AND Default Pay Type does not exist in PAY_TYPE table.
Default Invoice Rate	Error Message Meaning/Related Information Must exist in input file. Default Invoice Rate is null.
Default Invoice Rate	Warning Message Meaning/Related Information Not greater than zero. IF Default Invoice Rate is not null AND Default Invoice Rate <= 0.
Detail Job Title Code	Error Message Meaning/Related Information Required if T&E <employee> ID is not blank. IF Detail Job Title Code is null AND T&E Employee ID in VEND_EMPL table or input file is not null HR license = ON. Not found in DETL_JOB_TITLES table. IF Detail Job Title Code is not null AND Detail Job Title Code does not exist in DETL_JOB_TITLES table AND HR license = ON.
Manager ID	Error Message Meaning/Related Information Required if T&E <employee> ID is not blank. IF Manager ID is null AND T&E Employee ID in VEND_EMPL table or input file is not null Not found in EMPL table. IF Manager ID is not null AND Manager ID does not exist in EMPL table.
Labor Location	Error Message Meaning/Related Information Required if T&E <employee> ID is not blank. IF Labor Location is null AND T&E Employee ID in VEND_EMPL table or input file is not null Not found in LAB_LOCATION table. IF Labor Location is not null AND Labor Location does not exist in LAB_LOCATION table.
Work Schedule	Error Message Meaning/Related Information Required if T&E <employee> ID is not blank. IF Work Schedule is null AND Default Work Schedule in VEND_SETTINGS table is null AND T&E Employee ID in VEND_EMPL table or input file is not null Not found in WORK_SCH table. IF Work Schedule is not null AND Work Schedule does not exist in WORK_SCH table.
Timesheet Schedule	Error Message Meaning/Related Information Required if T&E <employee> ID is not blank. IF Timesheet Schedule is null AND Default Timesheet Schedule in VEND_SETTINGS table is null AND T&E Employee ID in VEND_EMPL table or input file is not null
Timesheet Class	Error Message Meaning/Related Information Required if T&E <employee> ID is not blank. IF Timesheet Class is null AND Default Timesheet Class in VEND_SETTINGS table is null AND T&E Employee ID in VEND_EMPL table or input file is not null Not found in EMPL_CLASS table. IF Timesheet Class is not null AND Timesheet Class does not exist in EMPL_CLASS table.
Expense Class Code	Error Message Meaning/Related Information Required if T&E <employee> ID is not blank. IF Expense Class is null AND Default Expense Class in VEND_SETTINGS table is null AND T&E Employee ID in VEND_EMPL table or input file is not null
State/Province	Error Message Meaning/Related Information Not found in MAIL_STATE table. IF State/Province is not null AND State/Province does not exist in MAIL_STATE table.
Postal Code	Error Message Meaning/Related Information Not found in POSTAL_CD table. IF Postal Code is not null AND Postal Code does not exist in POSTAL_CD table.
Country Code	Error Message Meaning/Related Information Not found in COUNTRY table. IF Country Code is not null AND Country Code does not exist in COUNTRY table.

VE_LAB_TRN_RT

Field	Description
Vendor ID	Error Message Meaning/Related Information Must exist in input file. Vendor ID is null.
Vendor Employee ID	Error Message Meaning/Related Information Must exist in input file. Vendor Employee ID is null.
Effective Start Date	Error Message Meaning/Related Information Must exist in input file. Effective Start Date is null.
Vendor Employee ID, Vendor ID, Effective Start Date	Error Message Meaning/Related Information Not found in VE_LAB_INFO input file and VE_LAB_INFO table. IF Vendor Employee ID is not null AND Vendor ID is not null AND Effective Start Date is not null AND (Vendor Employee ID + Vendor ID + Effective Start Date) does not exist in VE_LAB_INFO input file for current Company ID AND (Vendor Employee ID + Vendor ID + Effective Start Date) does not exist in VE_LAB_INFO table for current Company ID.
Transactional Currency Code	Error Message Meaning/Related Information Must exist in input file. IF Transactional Currency Code is null. Not found in CURRENCY table. IF Transactional Currency Code is not null AND Transactional Currency Code does not exist in CURRENCY table.
Vendor Employee ID, Vendor ID, Effective Start Date, Transactional Currency Code	Error Message Meaning/Related Information Input file contains duplicate record. IF Vendor Employee ID is not null AND Vendor ID is not null AND Effective Start Date is not null AND Transactional Currency Code is not null AND (Vendor Employee ID + Vendor ID + Effective Start Date + Transactional Currency Code) is duplicated in input file for current Company ID.
Default Transactional Invoice Rate	Error Message Meaning/Related Information Must exist in input file. IF Default Transactional Invoice Rate is null.
Default Transactional Invoice Rate	Warning Message Meaning/Related Information Not greater than zero. IF Default Transactional Invoice Rate is not null AND Default Transactional Invoice Rate <= 0.

SEC_CLR

Field	Description
Vendor ID	Error Message Meaning/Related Information Must exist in input file. Vendor ID is null.
Vendor Employee ID	Error Message Meaning/Related Information Must exist in input file. Vendor Employee ID is null.
Vendor Employee ID, Vendor ID	Error Message Meaning/Related Information Not found in VEND_EMPL input file and VEND_EMPL table. IF Vendor Employee ID is not null AND Vendor ID is not null AND (Vendor Employee ID + Vendor ID) does not exist in VEND_EMPL input file for current Company ID AND (Vendor Employee ID + Vendor ID) does not exist in VEND_EMPL table for current Company ID.
Security Clearance Code	Error Message Meaning/Related Information Must exist in input file. Security Clearance Code is null. Not found in SEC_CLR_SETTINGS table. IF Security Clearance Code is not null AND Security Clearance Code does not exist in SEC_CLR_SETTINGS table.
Vendor Employee ID, Vendor ID, Security Clearance Code	Error Message Meaning/Related Information Input file contains duplicate record. IF Vendor Employee ID is not null AND Vendor ID is not null AND Security Clearance Code is not null AND (Vendor Employee ID + Vendor ID + Security Clearance Code) is duplicated in input file for current Company ID.
Issuing Agency	Error Message Meaning/Related Information Must exist in input file. IF Issuing Agency is null.

SUBC_SCISAP_CLR

Field	Description
Vendor ID	Error Message Meaning/Related Information Must exist in input file. Vendor ID is null.
Vendor Employee ID	Error Message Meaning/Related Information Must exist in input file. Vendor Employee ID is null.
Security Clearance Code	Error Message Meaning/Related Information Must exist in input file. Security Clearance Code is null.
Vendor Employee ID, Vendor ID, Security Clearance Code	Error Message Meaning/Related Information Not found in SEC_CLR input file and SEC_CLR table. IF Vendor Employee ID is not null AND Vendor ID is not null AND Security Clearance Code is not null AND (Vendor Employee ID + Vendor ID + Security Clearance Code) does not exist in VEND_EMPL input file for current Company ID AND (Vendor Employee ID + Vendor ID + Security Clearance Code) does not exist in VEND_EMPL table for current Company ID.
SCI/SAP Clearance Code	Error Message Meaning/Related Information Must exist in input file. SCI/SAP Clearance Code is null. Not found in SCISAP_CLR table. IF SCI/SAP Clearance Code is not null AND SCI/SAP Clearance Code does not exist in SCISAP_CLR table.
Vendor Employee ID, Vendor ID, Security Clearance Code, SCI/SAP Clearance Code	Error Message Meaning/Related Information Input file contains duplicate record. IF Vendor Employee ID is not null AND Vendor ID is not null AND Security Clearance Code is not null AND SCI/SAP Clearance Code is not null AND (Vendor Employee ID + Vendor ID + Security Clearance Code + SCI/SAP Clearance Code) is duplicated in input file for current Company ID.
SCI Granting Agency	Error Message Meaning/Related Information Must exist in input file. IF SCI Granting Agency is null.

SUBC_SKILLS

Field	Description
Vendor ID	Error Message Meaning/Related Information Must exist in input file. Vendor ID is null.
Vendor Employee ID	Error Message Meaning/Related Information Must exist in input file. Vendor Employee ID is null.
Vendor Employee ID, Vendor ID	Error Message Meaning/Related Information Not found in VEND_EMPL input file and VEND_EMPL table. IF Vendor Employee ID is not null AND Vendor ID is not null AND (Vendor Employee ID + Vendor ID) does not exist in VEND_EMPL input file for current Company ID AND (Vendor Employee ID + Vendor ID) does not exist in VEND_EMPL table for current Company ID.
Skill ID	Error Message Meaning/Related Information Must exist in input file. Skill ID is null. Not found in SKILL table. IF Skill ID is not null AND Skill ID does not exist in SKILL table.
Vendor Employee ID, Vendor ID, Skill ID	Error Message Meaning/Related Information Input file contains duplicate record. IF Vendor Employee ID is not null AND Vendor ID is not null AND Skill ID is not null AND (Vendor Employee ID + Vendor ID + Skill ID) is duplicated in input file for current Company ID.
Skill Level Code	Error Message Meaning/Related Information Not found in H_SKILL_LVL table. IF Skill Level Code is not null AND Skill Level Code does not exist in H_SKILL_LVL table.

SUBC_TRAININGS

Field	Description
Vendor ID	Error Message Meaning/Related Information Must exist in input file. Vendor ID is null.
Vendor Employee ID	Error Message Meaning/Related Information Must exist in input file. Vendor Employee ID is null.
Vendor Employee ID, Vendor ID	Error Message Meaning/Related Information Not found in VEND_EMPL input file and VEND_EMPL table. IF Vendor Employee ID is not null AND Vendor ID is not null AND (Vendor Employee ID + Vendor ID) does not exist in VEND_EMPL input file for current Company ID AND (Vendor Employee ID + Vendor ID) does not exist in VEND_EMPL table for current Company ID.
Training ID	Error Message Meaning/Related Information Must exist in input file. IF Training ID is null. Not found in TRAINING table. IF Training ID is not null AND Training ID does not exist in TRAINING table.
Vendor Employee ID, Vendor ID, Training ID	Error Message Meaning/Related Information Input file contains duplicate record. IF Vendor Employee ID is not null AND Vendor ID is not null AND Skill ID is not null AND (Vendor Employee ID + Vendor ID + Training ID) is duplicated in input file for current Company ID.
Training Source	Error Message Meaning/Related Information Not found in TRAINING_SRCE table. IF Training Source is not null AND Training Source does not exist in TRAINING_SRCE table.
Internal/External Training	Error Message Meaning/Related Information Must be I or E. IF Internal/External Training is not null AND Internal/External Training <> I or E.
CEU Credits Earned	Error Message Meaning/Related Information Negative numbers are not allowed. IF CEU Credits Earned is not null AND CEU Credits Earned < 0.

SUBC_PROPERTY

Field	Description
Vendor ID	Error Message Meaning/Related Information Must exist in input file. Vendor ID is null.
Vendor Employee ID	Error Message Meaning/Related Information Must exist in input file. Vendor Employee ID is null.
Vendor Employee ID, Vendor ID	Error Message Meaning/Related Information Not found in VEND_EMPL input file and VEND_EMPL table. IF Vendor Employee ID is not null AND Vendor ID is not null AND (Vendor Employee ID + Vendor ID) does not exist in VEND_EMPL input file for current Company ID AND (Vendor Employee ID + Vendor ID) does not exist in VEND_EMPL table for current Company ID.
Property ID	Error Message Meaning/Related Information Must exist in input file. Property ID is null. Not found in H_COMPANY_PROP table. IF Property ID is not null AND Property ID does not exist in H_COMPANY_PROP table.
Vendor Employee ID, Vendor ID, Property ID	Error Message Meaning/Related Information Input file contains duplicate record. IF Vendor Employee ID is not null AND Vendor ID is not null AND Property ID is not null AND (Vendor Employee ID + Vendor ID + Property ID) is duplicated in input file for current Company ID.
Property Quantity	Error Message Meaning/Related Information Must exist in input file. Property Quantity is null.
Property Ownership	Error Message Meaning/Related Information Must be O or U. IF Property Ownership is not null AND Property Ownership <> O or U.
Asset ID, Asset Item Number	Error Message Meaning/Related Information Not found in ASSET table. IF Asset ID is not null AND Asset Item Number is not null AND (Asset ID + Asset Item Number) does not exist in ASSET table for current Company ID.
Issue Date	Error Message Meaning/Related Information Must exist in input file. Issue Date is null.