Costpoint Online Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

Row Definition Subtask

Use this subtask to define source file row type, description, and input file content definition from a Costpoint budgeting perspective.

You also define row specifications using a specific column number and a data value within that column.

Contents

Field Description
Row Type ID

Enter a row type.

Row Type Description

Enter a Row Type description.

Record Type

Use this drop-down list to select the type of data represented by this row. Valid options are:

  • DLC: Direct labor
  • DNLC: Direct non-labor
  • INDC: Indirects
  • FEE: Manual Fee
  • ETC: Estimate-to-complete revenue amounts.

You cannot process indirects alone; you must process them in the same input file as direct labor or direct non-labor and they must contain the same logical key information as the directs. You cannot process direct labor and direct non-labor in the same source file definition. If the input file contains ETC-based data, you can select only ETC.

Column

Use this column to identify which column contains a specific data value that uniquely identifies this row. This value must be greater than zero.

Column Data Value

Use this column to define the exact data value the application uses to determine whether an input file row matches this source file row definition. The value entered must match the input file data pattern exactly.

Options

Use this column to define how the application evaluates the "data value" within a column. The selections are:

  • BEGINS WITH: Column starts with value
  • ENDS WITH: Column ends with value
  • CONTAINS: Column has value somewhere within it
  • EQUALS: Matches column value exactly
Warning: Altering or deleting a row type definition deletes all mapping definition information. You must then re-enter that information in the Configure Project Planner Mapping Definitions screen.

Subtasks

Subtask Description
Column Definition The Column Definition subtask displays the physical columns in the input file, describes each column, defines inclusion for mapping, and specifies whether the column repeats, at what interval, and how often.
Mapping Definition The Mapping Definition subtask displays the list of columns you have defined for the input file and the list of columns required for update in the Costpoint tables. This subtask displays data from the Configure Project Planner Mapping Definitions screen