Field Descriptions

 

 

Mass Add Project Information

What can I do in this screen?

Use this screen to mass add or update multiple projects by replicating existing information across multiple records. The utility involves two steps: adding project basic information, and updating existing project information with additional data.

When should I use this screen?

Run this utility any time you need to create or modify projects. You must fill out the Basic Info (Projects\Maintain\Project) screen for the project before you use this utility to add other tables. You can also add the project's basic information at the same time as other project data by selecting the Include Basic Info checkbox in the Project group box.

Field Descriptions

Identification

Use the fields in this block to create a new parameter ID or to retrieve a previously saved parameter ID.  A parameter ID represents a set of screen selection parameters.  Once you have saved a parameter ID and its related parameters, you can retrieve them using Query.  

You can use the retrieved parameters to produce reports and run processes more efficiently and with greater consistency.  Many users save a unique set of parameters for each different way they run a report or process.  If you select a previously saved parameter ID or parameter description, the associated saved screen selection parameters will automatically display as selection defaults.  You can change any of the associated selection defaults as necessary.

Parameter ID *

Enter, or use Query to select, a parameter ID of up to 15 alphanumeric characters.  You should choose characters for your parameter ID that help identify the type of selections you made in the screen, such as “PERIOD” or “QUARTERLY.”  

When you save your record, all the selections made in the screen are stored with the parameter ID. Later, you can retrieve the parameter using Query.

You can use the parameter to produce reports and run processes more efficiently because you can select the parameter ID with its previously defined screen selections.  Once the default selections display in the screen, you can override the defaults as necessary.

Description *

Enter, or use Query to select, a parameter description of up to 30 alphanumeric characters.

Selection Ranges

Use the fields in this block to select the template and destination projects.

Template Project

Option

This non-editable field displays the "One" option. This is because you can only use one project as the template.  

Start

Enter, or use Lookup to select, a template project to be used in this process.  This project should be the project that you want to replicate.

The new (destination) project's structure will be identical to that of the template project, if you selected the Include Basic Info checkbox.

The unlabeled field below is the project description for the template project.

Destination Project

Option

This non-editable field displays the "Range" option.  This is because you must enter a range of projects that you want to create.

If you want to create only one new project, enter that project number in the Start and the End fields.

Start

Enter, or use Lookup to select,  a starting destination project for this process. Lookup for the destination project is only available if you have previously created the project and want to add other project screens.

End

Enter the ending project in the range to be created.

There are certain restrictions placed on the number of projects and projects levels that you can create. These restrictions are as follows:

Number of Projects

This field displays the number of projects that will be created when you execute the process.

To update this field, use the Fill Table pushbutton.

Options

Use the fields in this block to select options for the Basic Info screen and the project structure for the destination project. You can also select the additional project screens that you want to include in the process.

Include Basic Info

Select this checkbox to set up project basic information.

You must set up the Basic Info screen (Projects\Maintain\Project) before or at the same time as other project tables. The additional tables that can optionally be added depend upon the Basic Info screen. Therefore, you must set up these records before or at the same time as the dependent tables.

Include Lower Levels

Select this checkbox to set up the entire project tree.

If you select this checkbox, the new project will be an exact duplication of the template project in that the project levels and level lengths will be identical.

Fill Table

Select this pushbutton to fill the table window using the template project and project range entered above. For each new project being created, the program will generate a separate line.

You can use the table window to review the projects that will be created.  The projects displayed in the table window are not created until the process is executed.

Include

Select the tables that you want to replicate for this project.  The following options are available:

Table Window

Use the fields in this table window to view information about the projects that will be created. The projects are not created until the process is executed.  The table window should be used to edit information and review what will be created by the process.

Template Project

This field displays the project number of the template project replicated.

Destination Project

This field displays the project number of the destination project being added.

This restriction exists to prevent dependent lower project levels and segment lengths from being set up incorrectly.

Destination Project Name

This field stores the name of the destination project.  The template project name defaults in and can be edited.

Destination Project Abbrev

This field displays the abbreviation code associated with the destination project.  You can edit this field.

Active

This field determines whether the destination project will be set as active or inactive when being created. A value of "Y" defaults into this field, indicating that the project will be active. You can edit this field.

Owning Org

Enter, or use Lookup to select, the owning organization of the destination project(s). You can edit this field.

* A red asterisk denotes a required field.

Table Information

This screen updates the following tables:

PROJ

PROJ_BILL_INFO - This table updates if you select "Project Billing Info" in the Include list box.

PROJ_HIERARCHY -  This table derives from the PROJ table when the Include Basic Info checkbox is selected. This table stores all the projects and their parent project numbers.

PROJ_SRCE_PROJ - This table derives from the PROJ table when the Include Basic Info checkbox is selected. This table stores all the projects and their source project numbers.  The source project number is used for project labor category defaults and validations. If you select the "Define Rate Sequence" table in the Include list box, the PROJ_SRCE_PROJ table is re-evaluated and the appropriate source project number is updated based upon the selection in the T+M Rate Sequence Search for PLC Source Project group box in the Project Settings screen (Administration\Configure\Projects) and the TM_RT_ORDER table (Define Rate Sequence (Projects\Maintain\Revenue)).

PROJ_INVC_PROJ - This table derives from the PROJ_BILL_INFO table (determines the invoice project number) and the PROJ table (determines the child project numbers) when the "Project Billing Info" table is selected in the Include list box. This table stores the billing level invoice project number and all children of the invoice project.

PROJ_REV_PROJ - This table derives from the PROJ_REV_SETUP table (determines the revenue project number) and the PROJ table (determines the child project numbers) when the "Project Revenue Setup" table is selected in the Include list box. This table stores the revenue level project number and all children of the revenue project.

Top of Page