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.

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.

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.

Must exist in input file.

IF - Last Name is null AND

• Vendor Employee is new.

Must exist in input file.

IF - First Name is null AND

• Vendor Employee is new.

Must be A or I.

IF - Vendor Employee Status is not null AND

• Vendor Employee Status <> A or I.

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.

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.

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

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:

1. Set it to A, if the Subcontractor Vendor Employee Approval - Requires Approval check box in Configure Accounts Payable Settings is not selected.
2. Set it to P, if the Subcontractor Vendor Employee Approval - Requires Approval check box in Configure Accounts Payable Settings is selected.

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).

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).

Bad CSV file. File: VEND_EMPL, Field: VEND_EMPL_TERM_DATE, Value: <Date>

Termination Date is not a valid date.

Termination Date is less than the workforce start date.

IF - The vendor employee is assigned to a workforce AND

• The Termination Date is earlier than the workforce start date.

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.

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.

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.

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.

Not found in PAY_TYPE table.

IF - Default Pay Type is not null AND

• Default Pay Type does not exist in PAY_TYPE table.

Table: VE_LAB_INFO, Column DFLT_PAY_TYPE, Value <default pay type> truncated to 15 characters.

Default Pay Type exceeds 15 characters.

Not greater than zero.

IF - Default Invoice Rate is not null AND

• Default Invoice Rate <= 0.

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.

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.

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.

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.

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

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.

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

Not found in MAIL_STATE table.

IF - State/Province is not null AND

• State/Province does not exist in MAIL_STATE table.

Not found in POSTAL_CD table.

IF - Postal Code is not null AND

• Postal Code does not exist in POSTAL_CD table.

Not found in COUNTRY table.

IF - Country Code is not null AND

• Country Code does not exist in COUNTRY table.

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.

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.

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.

Not greater than zero.

IF - Default Transactional Invoice Rate is not null AND

• Default Transactional Invoice Rate <= 0.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

Not found in TRAINING_SRCE table.

IF - Training Source is not null AND

• Training Source does not exist in TRAINING_SRCE table.

Must be I or E.

IF - Internal/External Training is not null AND

• Internal/External Training <> I or E.

Negative numbers are not allowed.

IF - CEU Credits Earned is not null AND

• CEU Credits Earned < 0.

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.

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.

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.

Must be O or U.

IF - Property Ownership is not null AND

• Property Ownership <> O or U.

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.