Technical Information

This section discusses processing details and the information derived when importing subcontractor detail information into Costpoint.

Processing Details

Any pre-existing information in the worktables is deleted. (Normally, there is not any data in these tables at the start of processing unless a previous attempt to use the Import Subcontractor Detail screen terminated abnormally.)
If a SCHEMA.INI file does not exist in the Import Directory, Costpoint creates one when you click the Upload button on the Import Subcontractor Detail screen. This file must exist in the import directory for the Subcontractor Detail Preprocessor to validate any information in the input files.
The preprocessor checks the length of each field as it is being read into the worktables. If a field is too long to fit into the worktable, it is truncated.
Worktables are populated with the information from the .csv files. NULL columns are replaced with default work assignment information, if appropriate, and then all records are validated.
Error information is inserted into the D_xxxSMPSUBC_ERR table. This information is displayed on the Import Subcontractor Detail screen after the upload step is complete; you can sort the information by double-clicking the column heading. You can print the Import Subcontractor Detail Error Report for review.
The Upload process must complete without errors before you can import into the database. When the Upload completes without errors, you can print the Import Subcontractor Detail Report.
Once you have printed the Import Subcontractor Detail Report, the import process is enabled and you can import records into the database.

Derived Information

Table Name	Costpoint Screen Name	Column Name	Costpoint Field Name	Derivation Information
SUBC_TS_HDR and SUBC_TS_LN	Manage Subcontractor Detail - Timesheet Detail	SUBC_TS_HDR_KEY	Timesheet Header Key	Costpoint generates a synthetic key from user-assigned numbers. The header key is used to associate timesheet lines to the correct header information.
SUBC_TS_HDR	Manage Subcontractor Detail - Timesheet Detail	VEND_EMPL_ID	Vendor Employee ID	If there is a resource line number provided, Costpoint gets the vendor employee ID from the WA_CHG_LN_RESOURCE and matches it against the vendor employee ID in the input file. If there is no resource line number in the input file, Costpoint validates against all work assignment vendor employees.
SUBC_TS_HDR	Manage Subcontractor Detail - Timesheet Detail	TIMESHEET_DT	Timesheet Date	Timesheet date follows the Work Assignment Period of Performance vaildation.
SUBC_TS_LN	Manage Subcontractor Detail - Timesheet Detail	SUBC_TS_LN_KEY	Timesheet Line Key	Enter sequential timesheet line numbers.
SUBC_TS_LN	Manage Subcontractor Detail - Timesheet Detail	HRS_DT	Timesheet Hours Date	Timesheet hours date follows the Work Assignment Period of Performance vaildation.
SUBC_TS_LN	Manage Subcontractor Detail - Timesheet Detail	PO_LN_NO	PO Line Number	This value is derived from WA_CHG_LN (Manage Work Assignments > Charges).
SUBC_TS_LN	Manage Subcontractor Detail - Timesheet Detail	WA_ID	Work Assignment ID	Both WA_HDR and Charge Lines must be approved.
SUBC_TS_LN	Manage Subcontractor Detail - Timesheet Detail	CHG_LN_NO	Work Assignment Charge Line Number	This value is derived from WA_CHG_LN (Manage Work Assignments > Charges).
SUBC_TS_LN	Manage Subcontractor Detail - Timesheet Detail	RESOURCE_LN_NO	Resource Line Number	This value corresponds to Manage Work Assignments > Charges > Vendor Employees.
SUBC_TS_LN	Manage Subcontractor Detail - Timesheet Detail	GENL_LAB_CAT_CD	GLC	This value is derived from Manage Work Assignments > Charges > Vendor Employees. If this column is blank or NULL, the value is derived from the charge line.
SUBC_TS_LN	Manage Subcontractor Detail - Timesheet Detail	BILL_LAB_CAT_CD	PLC	This value is derived from Manage Work Assignments > Charges > Vendor Employees. If this column is blank or NULL, the value is derived from the charge line.
SUBC_EXP_HDR and SUBC_EXP_LN	Manage Subcontractor Detail - Expense Detail	SUBC_EXP_HDR_KEY	Expense Header Key	Costpoint generates a synthetic key from user-assigned numbers. The header key is used to associate expense lines to the correct header information.
SUBC_EXP_HDR	Manage Subcontractor Detail - Expense Detail	EXP_RPT_DT	Expense Report Date	Expense report date follows the Work Assignment Period of Performance vaildation.
SUBC_EXP_HDR	Manage Subcontractor Detail - Expense Detail	VEND_ID	Vendor ID	Costpoint validates the vendor ID against the Work Assignment PO Vendor.
SUBC_EXP_HDR	Manage Subcontractor Detail - Expense Detail	VEND_EMPL_ID	Vendor Employee ID	If there is a resource line number provided, Costpoint gets the vendor employee ID from the WA_CHG_LN_RESOURCE and matches it against the vendor employee ID in the input file. If there is no resource line number in the input file, Costpoint validates against all work assignment vendor employees.
SUBC_EXP_LN	Manage Subcontractor Detail - Expense Detail	SUBC_EXP_LN_KEY	Expense Line Key	Enter sequential expense line numbers.
SUBC_EXP_LN	Manage Subcontractor Detail - Expense Detail	EXP_DT	Expense Date	Expense date follows the Work Assignment Period of Performance vaildation.
SUBC_EXP_LN	Manage Subcontractor Detail - Expense Detail	PO_LN_NO	PO Line Number	This value is derived from WA_CHG_LN (Manage Work Assignments > Charges).
SUBC_EXP_LN	Manage Subcontractor Detail - Expense Detail	WA_ID	Work Assignment ID	Both WA_HDR and Charge Lines must be approved.
SUBC_EXP_LN	Manage Subcontractor Detail - Expense Detail	CHG_LN_NO	Work Assignment Charge Line Number	This value is derived from WA_CHG_LN (Manage Work Assignments > Charges).
SUBC_EXP_LN	Manage Subcontractor Detail - Expense Detail	RESOURCE_LN_NO	Resource Line Number	This value corresponds to Manage Work Assignments > Charges > Vendor Employees.
SUBC_EXP_LN	Manage Subcontractor Detail - Expense Detail	EXP_TYPE_CD	Expense Type Code	This value is derived from the Charges subtask of the Manage Work Assignments screen. If T&E is not co-deployed, Costpoint assigns a value as they are used in the ORDER_BY, WHERE, and GROUP_BY clauses. The default value being assigned is "DFLT" with a corresponding EXP_TYPE_DESC value of "Default."

Parent Topic:

Import Subcontractor Detail