Any pre-existing information in the worktables is deleted. (Normally there will not be any data in these tables at the start of processing unless a previous attempt to use the Project Preprocessor terminated abnormally.)
If a SCHEMA.INI file does not exist in the Import Directory, the system creates one when you click the Upload button in the Upload Project Information screen (Projects » Project Setup » Project Master). This file must exist in the import directory in order for the Project 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 project information, if appropriate, and then all records are validated.
Error information is inserted into the Z_PJPPREP_ERR table. This information is displayed on the Upload Project Information screen (Projects » Project Setup » Project Master) after the Upload step is complete; you can sort the information by double-clicking the column heading. You can print the Project Preprocessor 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 Project Preprocessor Report.
Once you have printed the Project Preprocessor Report, the import process is enabled and you can import records into the database.
|
Table Name |
Costpoint Screen Name |
Column Name |
Costpoint Field Name |
Derivation Information |
|
PROJ |
Basic Info (Projects » Project Setup » Project Master) |
TXBL_PROJ_FL |
|
Insert an N. This field is not used. |
|
PROJ |
Basic Info |
LVL_NO |
Level |
Derived from the PROJ_ID. |
|
PROJ |
Basic Info |
INVT_FL |
|
Insert an N. This field is not used. |
|
PROJ |
Basic Info |
PROJ_END_DT |
|
The upload process will populate the end date with a NULL value. After importing the data, run the Update Period of Performance toolkit in the Miscellaneous Toolkits screen (Projects » Cost and Revenue Processing » Utilities). This will populate the correct values from the PROJ_MOD table. |
|
PROJ |
Basic Info |
PROJ_START_DT |
|
The upload process will populate the start date with a NULL value. After importing the data, run the Update Period of Performance toolkit in the Miscellaneous Toolkits screen (Projects » Cost and Revenue Processing » Utilities). This will populate the correct values from the PROJ_MOD table. |
|
PROJ |
Basic Info |
PROJ_ABBRV_CD |
Project Abbreviation |
If NULL in the input file, insert a ' ' (space) because NULLs are not allowed in the PROJ table. |
|
PROJ |
Basic Info |
MODIFIED_BY |
|
User ID that imports the data. |
|
PROJ |
Basic Info |
TIME_STAMP |
|
System date and time of import. |
|
PROJ |
Basic Info |
PROJ_V_TOT_AMT |
|
The upload process will populate the total contract value with zero. After importing the data, run the Update Contract and Funded Values toolkit in the Miscellaneous Toolkits screen (Projects » Cost and Revenue Processing » Utilities). This will populate the correct values from the PROJ_MOD table. |
|
PROJ |
Basic Info |
PROJ_F_TOT_AMT |
|
The upload process will populate the total funded value with zero. After importing the data, run the Update Contract and Funded Values toolkit in the Miscellaneous Toolkits screen (Projects » Cost and Revenue Processing » Utilities). This will populate the correct values from the PROJ_MOD table. |
|
PROJ |
Basic Info |
ROWVERSION |
|
Enter zero. |
|
PROJ |
Basic Info |
L1_PROJ_NAME |
|
PROJ_NAME. |
|
PROJ |
Basic Info |
L2_PROJ_NAME |
|
If LVL_NO > 1, PROJ_NAME of LVL_2 PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L3_PROJ_NAME |
|
If LVL_NO > 2, PROJ_NAME of LVL_3 PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L4_PROJ_NAME |
|
If LVL_NO > 3, PROJ_NAME of LVL_4 PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L5_PROJ_NAME |
|
If LVL_NO > 4, PROJ_NAME of LVL_5 PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L6_PROJ_NAME |
|
If LVL_NO > 5, PROJ_NAME of LVL_6 PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L7_PROJ_NAME |
|
If LVL_NO > 6, PROJ_NAME of LVL_7 PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L8_PROJ_NAME |
|
If LVL_NO > 7, PROJ_NAME of LVL_8 PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L9_PROJ_NAME |
|
If LVL_NO > 8, PROJ_NAME of LVL_9 PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L10_PROJ_NAME |
|
If LVL_NO > 9, PROJ_NAME of LVL_10 PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L11_PROJ_NAME |
|
If LVL_NO > 10, PROJ_NAME of LVL_11 PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L12_PROJ_NAME |
|
If LVL_NO > 11, PROJ_NAME of LVL_12 PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L13_PROJ_NAME |
|
If LVL_NO > 12, PROJ_NAME of LVL_13 PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L14_PROJ_NAME |
|
If LVL_NO > 13, PROJ_NAME of LVL_14 PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
GOVT_LAB_TYPE_FL |
|
N. |
|
PROJ |
Basic Info |
L1_PROJ_SEG_ID |
|
First segment of Proj ID. |
|
PROJ |
Basic Info |
L2_PROJ_SEG_ID |
|
If LVL_NO > 1, 2nd Segment of PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L3_PROJ_SEG_ID |
|
If LVL_NO > 2, 3rd Segment of PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L4_PROJ_SEG_ID |
|
If LVL_NO > 3, 4th Segment of PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L5_PROJ_SEG_ID |
|
If LVL_NO > 4, 5th Segment of PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L6_PROJ_SEG_ID |
|
If LVL_NO > 5, 6th Segment of PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L7_PROJ_SEG_ID |
|
If LVL_NO > 6, 7th Segment of PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L8_PROJ_SEG_ID |
|
If LVL_NO > 7, 8th Segment of PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L9_PROJ_SEG_ID |
|
If LVL_NO > 8, 9th Segment of PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L10_PROJ_SEG_ID |
|
If LVL_NO > 9, 10th Segment of PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L11_PROJ_SEG_ID |
|
If LVL_NO > 10, 11th Segment of PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L12_PROJ_SEG_ID |
|
If LVL_NO > 11, 12th Segment of PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L13_PROJ_SEG_ID |
|
If LVL_NO > 12, 13th Segment of PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L14_PROJ_SEG_ID |
|
If LVL_NO > 13, 14th Segment of PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
L15_PROJ_SEG_ID |
|
If LVL_NO > 14, 15th Segment of PROJ_ID, else NULL. |
|
PROJ |
Basic Info |
LAST_RQ_ID |
|
NULL. This field is not used. |
|
PROJ |
Basic Info |
RQ_APPR_PROC_ CD |
|
NULL. This field is populated when a project is linked to a Requisition Approval Process Code in the Requisition Approval Processes screen (Materials » Procurement Planning » Requisition Controls). |
|
PROJ |
Basic Info |
PROJ_MGR_NAME |
Project Manager (Name) |
If PROJ_MGR_NAME is NULL and EMPL_ID is populated in the input file, insert the PROJ_MGR_NAME value by selecting the LAST_FIRST_NAME from the EMPL table where the EMPL_ID in input file = EMPL_ID in EMPL table. If both EMPL_ID and PROJ_MGR_NAME are NULL in the input file, make the PROJ_MGR_NAME = ' ' since PROJ_MGR_NAME does not allow NULLS in the table. |
|
PROJ |
Basic Info |
PROJ_V_FEE_AMT |
|
The upload process will populate the contract fee amount with zero. After importing the data, run the Update Contract and Funded Values toolkit in the Miscellaneous Toolkits screen (Projects » Cost and Revenue Processing » Utilities). This will populate the correct values from the PROJ_MOD table. |
|
PROJ |
Basic Info |
PROJ_V_CST_AMT |
|
The upload process will populate the contract cost amount with zero. After importing the data, run the Update Contract and Funded Values toolkit in the Miscellaneous Toolkits screen (Projects » Cost and Revenue Processing » Utilities). This will populate the correct values from the PROJ_MOD table. |
|
PROJ |
Basic Info |
PROJ_F_FEE_AMT |
|
The upload process will populate the funded fee amount with zero. After importing the data, run the Update Contract and Funded Values toolkit in the Miscellaneous Toolkits screen (Projects » Cost and Revenue Processing » Utilities). This will populate the correct values from the PROJ_MOD table. |
|
PROJ |
Basic Info |
PROJ_F_CST_AMT |
|
The upload process will populate the funded cost amount with zero. After importing the data, run the Update Contract and Funded Values toolkit in the Miscellaneous Toolkits screen (Projects » Cost and Revenue Processing » Utilities). This will populate the correct values from the PROJ_MOD table. |
|
PROJ |
Basic Info |
PRIME_CONTR_ID |
Prime Contract No |
If the PRIME_CONTR_ID is NULL in the input file, enter a ' ' (space) since NULLs are not allowed in this field. |
|
PROJ |
Basic Info |
SUBCTR_ID |
Subcontractor No |
If the SUBCTR_ID is NULL in the input file, enter a ' ' (space) since NULLs are not allowed in this field. |
|
PROJ |
Basic Info |
CUST_PO_ID |
Purchase Order No |
If the CUST_PO_ID is NULL in the input file, enter a ' ' (space) since NULLs are not allowed in this field. |
|
PROJ_EDIT |
|
PROJ_ID |
|
PROJ_ID from PROJ. |
|
PROJ_EDIT |
|
PROJ_NAME |
|
PROJ_NAME from PROJ. |
|
PROJ_EDIT |
|
PROJ_ABBRV_CD |
|
PROJ_ABBRV_CD from PROJ. |
|
PROJ_EDIT |
|
ACCT_GRP_CD |
|
ACCT_GRP_CD from PROJ. |
|
PROJ_EDIT |
|
ORG_ID |
|
ORG_ID from PROJ. |
|
PROJ_EDIT |
|
ALLOW_CHARGES_FL |
|
ALLOW_CHARGES_FL from PROJ. |
|
PROJ_EDIT |
|
ACTIVE_FL |
|
ACTIVE_FL from PROJ. |
|
PROJ_EDIT |
|
DFLT_ORG_ ENTRY_FL |
|
DFLT_ORG_ENTRY_FL from PROJ. |
|
PROJ_EDIT |
|
LIMIT_ACCTS_FL |
|
LIMIT_ACCTS_FL from PROJ. |
|
PROJ_EDIT |
|
LIMIT_ORGS_FL |
|
LIMIT_ORGS_FL from PROJ. |
|
PROJ_EDIT |
|
LIMIT_AO_FL |
|
LIMIT_AO_FL from PROJ. |
|
PROJ_EDIT |
|
PROJ_START_DT |
|
PROJ_START_DT from PROJ (NULL). |
|
PROJ_EDIT |
|
PROJ_END_DT |
|
PROJ_END_DT from PROJ (NULL). |
|
PROJ_EDIT |
|
PROJ_WORK_FRC_FL |
|
PROJ_WORK_FRC_FL from PROJ. |
|
PROJ_EDIT |
|
TOP_LVL_WRK_ FRC_FL |
|
TOP_LVL_WRK_FRC_FL from PROJ. |
|
PROJ_EDIT |
|
MODIFIED_BY |
|
USER ID that imports the data. |
|
PROJ_EDIT |
|
TIME_STAMP |
|
System date and time of import. |
|
PROJ_EDIT |
|
ROWVERSION |
|
ROWVERSION from PROJ. |
|
PROJ_LVL |
|
PROJ_ID_TOP |
|
Project Structure defined in PROJ. |
|
PROJ_LVL |
|
PROJ_LVL_KEY |
|
Project Structure defined in PROJ. |
|
PROJ_LVL |
|
LVL_NO |
|
Project Structure defined in PROJ. |
|
PROJ_LVL |
|
LVL_LEN_NO |
|
Project Structure defined in PROJ. |
|
PROJ_LVL |
|
LVL_NAME |
|
If the Level Name of the derived level number for the project exists in the DEFAULT_PROJ_LEVELS table, insert the LVL_NAME from the DEFAULT_PROJ_LEVELS table. If the Level Name does not exist in the DEFAULT_PROJ_LEVELS table, insert "Level X" and substitute "X" for the appropriate level number. |
|
PROJ_LVL |
|
MODIFIED_BY |
|
USER ID that imports the data. |
|
PROJ_LVL |
|
TIME_STAMP |
|
System date and time of import. |
|
PROJ_LVL |
|
ROWVERSION |
|
ROWVERSION from PROJ. |
|
PROJ_ERMS |
|
PROJ_ID |
|
If you are licensed for ERMS, insert PROJ_ID from PROJ. If you are not licensed for ERMS, this table will not be created. |
|
PROJ_ERMS |
|
EXPORT_FL |
|
If you are licensed for ERMS, insert "'N." If you are not licensed for ERMS, this table will not be created. |
|
PROJ_ERMS |
|
MODIFIED_BY |
|
If you are licensed for ERMS, insert USER ID that imports the data. If you are not licensed for ERMS, this table will not be created. |
|
PROJ_ERMS |
|
TIME_STAMP |
|
If you are licensed for ERMS, insert System Date and Time of import. If you are not licensed for ERMS, this table will not be created. |
|
PROJ_ERMS |
|
ROWVERSION |
|
If licensed for ERMS, insert ROWVERSION from PROJ. If not licensed for ERMS, this table will not be created. |
|
PROJ_MOD |
Modifications (Projects » Project Setup » Controls) |
PROJ_MOD_DESC |
|
If PROJ_MOD_DESC is NULL in the input file, enter a ' ' (space) since NULLs are not allowed in the table. |
|
PROJ_MOD |
Modifications |
NOTES |
Notes |
If NOTES is NULL in the input file, enter a ' ' (space) since NULLs are not allowed in the table. |
|
PROJ_MOD |
Modifications |
MODIFIED_BY |
|
USER ID that imports the data. |
|
PROJ_MOD |
Modifications |
TIME_STAMP |
|
System date and time of import. |
|
PROJ_MOD |
Modifications |
PROJ_V_PROFT_ RT |
Value Fee % |
If PROJ_V_CST_AMT is not NULL, PROJ_V_FEE_AMT / PROJ_V_CST_AMT, else 0. |
|
PROJ_MOD |
Modifications |
PROJ_F_PROFT_RT |
Funding Fee % |
If PROJ_F_CST_AMT is not NULL, PROJ_F_FEE_AMT / PROJ_F_CST_AMT, else 0. |
|
PROJ_MOD |
Modifications |
ROWVERSION |
|
|
|
PROJ_MOD |
Modifications |
PROJ_MOD_ID |
ID |
If the Modification ID is NULL in the input file, insert 0000. This field is required in the PROJ_MOD table. |
|
PROJ_MOD |
Modifications |
ITEM_KEY |
|
Synthetic Key (System Use). |
|
PROJ_REV_ SETUP |
Basic Revenue Info (Projects » Project Setup » Revenue Setup) |
REV_ADJ_AMT |
|
Zero. |
|
PROJ_REV_ SETUP |
Basic Revenue Info |
CONTR_LOSS_VAL_AMT |
ITD Revenue Loss Amount |
Zero. |
|
PROJ_REV_ SETUP |
Basic Revenue Info |
MODIFIED_BY |
|
USER ID that imports the data. |
|
PROJ_REV_ SETUP |
Basic Revenue Info |
TIME_STAMP |
|
System date and time of import. |
|
PROJ_REV_ SETUP |
Basic Revenue Info |
ROWVERSION |
|
Enter zero. |
|
PROJ_REV_ SETUP |
Basic Revenue Info |
REV_CALC1_AMT |
(The name changes based on the revenue formula. See the "Revenue Formula Validation Detail" section.) |
If this field is NULL in the input file and S_Rev_Formula_CD = CIMR, RSMNLM, or CVPCVSE, insert 1. If this field is NULL in the input file and S_Rev_Formula_CD does not = CIMR, RSMNLM, or CVPCVSE, insert zero. |
|
PROJ_REV_ SETUP |
Basic Revenue Info |
REV_CALC2_AMT |
(The name changes based on the revenue formula. See the "Revenue Formula Validation Detail" section.) |
If this field is NULL in the input file and S_Rev_Formula_CD = CVPCVSE, insert 1. If this field is NULL in the input file and S_Rev_Formula_CD does not = CVPCVSE, insert zero. |
|
PROJ_REV_ SETUP |
Basic Revenue Info |
LBR_MULT_RT |
Goal Multiplier - Labor |
If this field is NULL in the input file, insert a 1. |
|
PROJ_REV_ SETUP |
Basic Revenue Info |
NLBR_MULT_RT |
Goal Multiplier - Non Labor |
If this field is NULL in the input file, insert a 1. |
|
PROJ_BILL_INFO |
Project Billing Info |
LAST_BILL_NO_ID |
Last Bill Number |
If the Last Bill Number is NULL in the input file, insert a ' ' (space) since NULLs are not allowed in the PROJ_BILL_INFO table. |
|
PROJ_BILL_INFO |
Project Billing Info |
S_WHEN_RETAIN_CD |
Retainage - Withhold On |
If the Retainage Withhold On field is NULL in the input file, insert a ' ' (space) since NULLs are not allowed in the PROJ_BILL_INFO table. |
|
PROJ_BILL_INFO |
Project Billing Info |
S_1035_TYPE |
Government 1035 Format Information - Print Cost Plus/Fixed Price Format or Print Using T&M Format |
If the 1035 Format is NULL in the input file, insert CP since NULLs are not allowed in the PROJ_BILL_INFO table. |
|
PROJ_BILL_INFO |
Project Billing Info |
ACCT_LVL_1035_ NO |
Roll Up Accounts to Level |
If the ACCT_LVL_1035_NO is NULL in the input file, insert 1 since NULLs are not allowed in the PROJ_BILL_INFO table. |
|
PROJ_BILL_INFO |
Project Billing Info |
MODIFIED_BY |
|
USER ID that imports the data. |
|
PROJ_BILL_INFO |
Project Billing Info |
TIME_STAMP |
|
System date and time of import. |
|
PROJ_BILL_INFO |
Project Billing Info |
ROWVERSION |
|
|
|
PROJ_BILL_INFO |
Project Billing Info |
LAST_BILL_NO |
|
Last Bill Number - Numeric Suffix. |
|
PROJ_BILL_INFO |
Project Billing Info |
BILL_NUM_LEN_ NO |
|
Length of Last Bill Number - Numeric Suffix. |
|
PROJ_BILL_INFO |
Project Billing Info |
LAST_BILL_ID |
|
Last Bill Number - Character Prefix. |
|
PROJ_BILL_INFO |
Project Billing Info |
BILL_DESC |
Bill Heading |
If the Bill Heading is NULL in the input file, insert a ' ' (space) since NULLs are not allowed for this field in the PROJ_BILL_INFO table. |
|
PROJ_BILL_INFO |
Project Billing Info |
S_INVT_BILL_CD |
Bill Inventory Issues As (Cost, Units, Accounts) |
If S_INVT_BILL_CD is NULL, insert C. |
|
PROJ_BILL_INFO |
Project Billing Info |
PRICE_CATLG_CD |
Catalog |
If PRICE_CATLG_CD is NULL in the input file, insert a ' ' (space). |
|
PROJ_BILL_INFO |
Project Billing Info |
S_PRICE_SRCE_CD |
|
If S_INVT_BILL_CD = C, insert a " " (space). If S_INVT_BILL_CD = U or A, insert C if PRICE_CATLG_CD is not NULL, and P if PRICE_CATLG_CD is NULL and CLIN_ID is not NULL. |
|
PROJ_BILL_INFO |
Project Billing Info |
CLIN_ID |
CLIN |
If CLIN_ID is NULL in the input file, insert a " " (space). |
|
PROJ_BILL_INFO |
Project Billing Info |
SRCE_PROJ_ID |
Source Project |
If CLIN_ID is not NULL, insert PROJ_ID from PROJ_CLIN where CLIN_ID equals CLIN_ID in PROJ_CLIN. If CLIN_ID is NULL or if it is equal to a " " (space), insert a " " (space) for the SRCE_PROJ_ID. |
|
PROJ_BILL_INFO |
Project Billing Info |
PROGRESS_PMT_ RT |
Rates - Progress Payment |
If this field is NULL, enter 1. |
|
PROJ_BILL_INFO |
Project Billing Info |
EST_CST_AMT |
Estimate to Complete |
If this field is NULL, enter zero. |
|
PROJ_BILL_INFO |
Project Billing Info |
LAST_1443_NO |
|
Enter a zero. |
|
PROJ_BILL_INFO |
Project Billing Info |
LAST_1443_ID |
|
Enter a " " (space). |
|
PROJ_BILL_INFO |
Project Billing Info |
LAST_1443_NO_ID |
|
Enter a " " (space). |
|
PROJ_BILL_INFO |
Project Billing Info |
LEN_1443_NO |
|
Enter zero. |
|
PROJ_BILL_INFO |
Project Billing Info |
S_CONTR_PRICE_CD |
Contract Info - Price Basis |
If Price Basis is NULL, insert a " " (space) since NULLs are not allowed in the table. |
|
PROJ_BILL_INFO |
Project Billing Info |
CONTR_OVRIDE_ AMT |
Other Amount |
If this field is NULL, enter zero. |
|
PROJ_BILL_INFO |
Project Billing Info |
CONTR_REP_ NAME |
Contract Info - Rep Name |
If this field is NULL, enter a " " (space) since NULLs are not allowed in the table. |
|
PROJ_BILL_INFO |
Project Billing Info |
CONTR_REP_ TITLE |
Contract Info - Rep Title |
If this field is NULL, enter a " " (space) since NULLs are not allowed in the table. |
|
PROJ_BILL_INFO |
Project Billing Info |
CONTR_OFFCR_ TITLE |
|
Input a " " (space). |
|
PROJ_BILL_INFO |
Project Billing Info |
RSN_CD |
Reason Code |
Insert a " " (space). This field is not used. |
|
PROJ_CUST_ SETUP |
Project Billing Info (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup) - Customer(s) subtask |
MODIFIED_BY |
|
User ID that imports the data. |
|
PROJ_CUST_ SETUP |
Project Billing Info - Customer(s) subtask |
TIME_STAMP |
|
System date and time of import. |
|
PROJ_CUST_ SETUP |
Project Billing Info - Customer(s) subtask |
ROWVERSION |
|
Enter zero. |
|
PROJ_ORG_ACCT |
Maintain Valid Project/Account/Orgs (Projects » Project Setup » Project Master) |
MODIFIED_BY |
|
User ID that imports the data. |
|
PROJ_ORG_ACCT |
Maintain Valid Project/Account/Orgs |
TIME_STAMP |
|
System date and time of import. |
|
PROJ_ORG_ACCT |
Maintain Valid Project/Account/Orgs |
ROWVERSION |
|
Enter zero. |
|
PROJ_GOVT_ CONTR |
Government Contract Info (Projects » Project Setup » Project Master) |
DMS_DPS_CD |
DPAS Purchasing Rating |
If this field is NULL, enter a " " (space) since NULLs are not allowed in the table. |
|
PROJ_GOVT_ CONTR |
Government Contract Info |
COM_APPLIC_FL |
|
Insert a NULL. This field is not in use. It exists in the PROJ table. |
|
PROJ_GOVT_ CONTR |
Government Contract Info |
FUND_SRCE_DESC |
Funding Source |
If this field is NULL in the input file, insert a " " (space) since NULLs are not allowed in the input file. |
|
PROJ_GOVT_ CONTR |
Government Contract Info |
PRIME_CONTR_ID |
|
Insert a NULL. This field is not in use. It exists in the PROJ table. |
|
PROJ_GOVT_ CONTR |
Government Contract Info |
SUBCTR_ID |
|
Insert a NULL. This field is not in use. It exists in the PROJ table. |
|
PROJ_GOVT_ CONTR |
Government Contract Info |
MODIFIED_BY |
|
User ID that imports the data. |
|
PROJ_GOVT_ CONTR |
Government Contract Info |
TIME_STAMP |
|
System date and time of import. |
|
PROJ_GOVT_ CONTR |
Government Contract Info |
ROWVERSION |
|
Enter zero. |
|
PROJ_GOVT_ CONTR |
Government Contract Info |
CUST_PO_ID |
|
Insert a NULL. This field is not in use. It exists in the PROJ table. |
|
PROJ_LAB_CAT |
Assign PLC to Projects (Projects » Project Setup » Project Labor) |
BILL_LAB_CAT_ DESC |
Description |
If NULL in the input file, insert the BILL_LAB_CAT_DESC from the BILL_LAB_CAT table where BILL_LAB_CAT_CD in the input file equals the BILL_LAB_CAT_CD in the BILL_LAB_CAT table. |
|
PROJ_LAB_CAT |
Assign PLC to Projects |
MODIFIED_BY |
|
User ID that imports the data. |
|
PROJ_LAB_CAT |
Assign PLC to Projects |
TIME_STAMP |
|
System date and time of import. |
|
PROJ_LAB_CAT |
Assign PLC to Projects |
ROWVERSION |
|
|
|
PROJ_EMPL |
Project Employee Work Force (Projects » Project Setup » Project Labor) |
MODIFIED_BY |
|
User ID that imports the data. |
|
PROJ_EMPL |
Project Employee Work Force |
TIME_STAMP |
|
System date and time of import. |
|
PROJ_EMPL |
Project Employee Work Force |
ROWVERSION |
|
Enter zero. |
|
PROJ_VEND |
Project Vendor Work Force (Projects » Project Setup » Project Labor) |
MODIFIED_BY |
|
User ID that imports the data. |
|
PROJ_VEND |
Project Vendor Work Force |
TIME_STAMP |
|
System date and time of import. |
|
PROJ_VEND |
Project Vendor Work Force |
ROWVERSION |
|
Enter zero. |
|
PROJ_VEND_EMPL |
Project Vendor Employee Work Force (Projects » Project Setup » Project Labor) |
MODIFIED_BY |
|
User ID that imports the data. |
|
PROJ_VEND_EMPL |
Project Vendor Employee Work Force |
TIME_STAMP |
|
System date and time of import. |
|
PROJ_VEND_EMPL |
Project Vendor Employee Work Force |
ROWVERSION |
|
Enter zero. |
|
PROJ_EMPL_LAB_CAT |
Assign PLC to Employee Work Force (Projects » Project Setup » Project Labor) |
MODIFIED_BY |
|
User ID that imports the data. |
|
PROJ_EMPL_LAB_CAT |
Assign PLC to Employee Work Force |
TIME_STAMP |
|
System date and time of import. |
|
PROJ_EMPL_LAB_CAT |
Assign PLC to Employee Work Force |
ROWVERSION |
|
Enter zero. |
|
PROJ_VEND_LAB_CAT |
Assign PLC to Vendor Work Force (Projects » Project Setup » Project Labor) |
MODIFIED_BY |
|
User ID that imports the data. |
|
PROJ_VEND_LAB_CAT |
Assign PLC to Vendor Work Force |
TIME_STAMP |
|
System date and time of import. |
|
PROJ_VEND_LAB_CAT |
Assign PLC to Vendor Work Force |
ROWVERSION |
|
Enter zero. |
|
PROJ_VEND_EMPL_PLC |
Assign PLC to Vendor Employee Work Force (Projects » Project Setup » Project Labor) |
MODIFIED_BY |
|
User ID that imports the data. |
|
PROJ_VEND_EMPL_PLC |
Assign PLC to Vendor Employee Work Force |
TIME_STAMP |
|
System date and time of import. |
|
PROJ_VEND_EMPL_PLC |
Assign PLC to Vendor Employee Work Force |
ROWVERSION |
|
Enter zero. |
|
BILL_LAB_CAT |
Set Up Project Labor Categories (PLC) (Projects » Project Setup » Project Labor) |
MODIFIED_BY |
|
User ID that imports the data. |
|
BILL_LAB_CAT |
Set Up Project Labor Categories (PLC) |
TIME_STAMP |
|
System date and time of import. |
|
BILL_LAB_CAT |
Set Up Project Labor Categories (PLC) |
ROWVERSION |
|
Enter zero. |
|
BILL_LAB_CAT |
Set Up Project Labor Categories (PLC) |
BILL_AVG_RT_ AMT |
|
Enter zero. |
|
PROJ_LAB_CAT_MAP |
Link GLC to Project PLC (Projects » Project Setup » Project Labor) |
MODIFIED_BY |
|
User ID that imports the data. |
|
PROJ_LAB_CAT_MAP |
Link GLC to Project PLC |
TIME_STAMP |
|
System date and time of import. |
|
PROJ_LAB_CAT_MAP |
Link GLC to Project PLC |
ROWVERSION |
|
Enter zero. |
|
PROJ_LAB_CAT_RT_SC |
Project PLC Rates screen (Projects » Project Setup » Project Labor) |
PROJ_LC_RT_KEY |
|
Insert Max (LAST_KEY) + 1 from the SEQ_GENERATOR table where S_TABLE_ID = DELTEK.PROJ_LAB_CAT_RT_SC. |
|
PROJ_LAB_CAT_RT_SC |
Project PLC Rates |
START_DT |
|
If this field is NULL in the input file, insert "01/01/1900." |
|
PROJ_LAB_CAT_RT_SC |
Project PLC Rates |
END_DT |
Ending Date |
If this field is NULL in the input file, insert 12/31/3000. |
|
PROJ_LAB_CAT_RT_SC |
Project PLC Rates |
MODIFIED_BY |
|
User ID that imports the data. |
|
PROJ_LAB_CAT_RT_SC |
Project PLC Rates |
TIME_STAMP |
|
System date and time of import. |
|
PROJ_LAB_CAT_RT_SC |
Project PLC Rates |
ROWVERSION |
|
Enter zero. |
|
PROJ_EMPL_RT_SCH |
Project PLC Rates by Employee/Vendor (Projects » Project Setup » Project Labor) |
PROJ_EMPL_RT_ KEY |
|
Synthetic Key (System Use). |
|
PROJ_EMPL_RT_SCH |
Project PLC Rates by Employee/Vendor |
START_DT |
Starting Date |
If this field is NULL in
the input file, insert 01/01/1900. |
|
PROJ_EMPL_RT_SCH |
Project PLC Rates by Employee/Vendor |
END_DT |
Ending Date |
If this field is NULL in the input file, insert 12/31/3000. |
|
PROJ_EMPL_RT_SCH |
Project PLC Rates by Employee/Vendor |
MODIFIED_BY |
|
User ID that imports the data. |
|
PROJ_EMPL_RT_SCH |
Project PLC Rates by Employee/Vendor |
TIME_STAMP |
|
System date and time of import. |
|
PROJ_EMPL_RT_SCH |
Project PLC Rates by Employee/Vendor |
ROWVERSION |
|
Enter zero. |
|
LAB_CAT_RT_ SCH |
Set Up Project Labor Categories (PLC) (Projects » Project Setup » Project Labor) - Billing Rates subtask |
LAB_CAT_RT_KEY |
|
Synthetic Key (System Use). |
|
LAB_CAT_RT_ SCH |
Set Up Project Labor Categories (PLC) - Billing Rates subtask |
START_DT |
Starting Date |
If this field is NULL in the input file, insert 01/01/1900. |
|
LAB_CAT_RT_ SCH |
Set Up Project Labor Categories (PLC) - Billing Rates subtask |
END_DT |
Ending Date |
If this field is NULL in the input file, insert 01/01/3000. |
|
LAB_CAT_RT_ SCH |
Set Up Project Labor Categories (PLC) - Billing Rates subtask |
MODIFIED_BY |
|
User ID that imports the data. |
|
LAB_CAT_RT_ SCH |
Set Up Project Labor Categories (PLC) - Billing Rates subtask |
TIME_STAMP |
|
System date and time of import. |
|
LAB_CAT_RT_ SCH |
Set Up Project Labor Categories (PLC) - Billing Rates subtask |
ROWVERSION |
|
Enter zero. |
|
TM_RT_ORDER |
Define Rate Sequence (Projects » Project Setup » Revenue Setup) |
MODIFIED_BY |
|
User ID that imports the data. |
|
TM_RT_ORDER |
Define Rate Sequence |
TIME_STAMP |
|
System date and time of import. |
|
TM_RT_ORDER |
Define Rate Sequence |
ROWVERSION |
|
Enter zero. |
|
TM_RT_ORDER |
Define Rate Sequence |
TM_RT_ORDER_ KEY |
|
Synthetic Key (System Use). |
|
CEIL_DIR_CST |
Project Direct Cost Ceilings (Projects » Project Setup » Project Ceilings) |
MODIFIED_BY |
|
User ID that imports the data. |
|
CEIL_DIR_CST |
Project Direct Cost Ceilings |
TIME_STAMP |
|
System date and time of import. |
|
CEIL_DIR_CST |
Project Direct Cost Ceilings |
ROWVERSION |
|
|
|
CEIL_DIR_HRS |
Project Hours Ceilings (Projects » Project Setup » Project Ceilings) |
MODIFIED_BY |
|
User ID that imports the data. |
|
CEIL_DIR_HRS |
Project Hours Ceilings |
TIME_STAMP |
|
System date and time of import. |
|
CEIL_DIR_HRS |
Project Hours Ceilings |
ROWVERSION |
|
Enter zero. |
|
CEIL_BURDEN_ CST |
Project Burden Cost Ceilings (Projects » Project Setup » Project Ceilings) |
ALLOC_GRP_NO |
|
Insert 1. |
|
CEIL_BURDEN_ CST |
Project Burden Cost Ceilings |
MODIFIED_BY |
|
User ID that imports the data. |
|
CEIL_BURDEN_ CST |
Project Burden Cost Ceilings |
TIME_STAMP |
|
System date and time of import. |
|
CEIL_BURDEN_ CST |
Project Burden Cost Ceilings |
ROWVERSION |
|
Enter zero. |
|
EMPL_CEIL |
Project Employee Hours Ceilings (Projects » Project Setup » Project Ceilings) |
MODIFIED_BY |
|
User ID that imports the data. |
|
EMPL_CEIL |
Project Employee Hours Ceilings |
TIME_STAMP |
|
System date and time of import. |
|
EMPL_CEIL |
Project Employee Hours Ceilings |
ROWVERSION |
|
Enter zero. |
|
VEND_CEIL |
Project Vendor Hours Ceilings (Projects » Project Setup » Project Ceilings) |
MODIFIED_BY |
|
User ID that imports the data. |
|
VEND_CEIL |
Project Vendor Hours Ceilings |
TIME_STAMP |
|
System date and time of import. |
|
VEND_CEIL |
Project Vendor Hours Ceilings |
ROWVERSION |
|
Enter zero. |
|
PROJ_BILL_INFO_SCH |
Project Billing Info (Projects » Billing » Billing Master or Projects » Project Setup » Revenue Setup) - Supporting Schedule Headers (Detail Bills) |
MODIFIED_BY |
|
User ID that imports the data. |
|
PROJ_BILL_INFO_SCH |
Project Billing Info - Supporting Schedule Headers (Detail Bills) |
TIME_STAMP |
|
System date and time of import. |
|
PROJ_BILL_INFO_SCH |
Project Billing Info - Supporting Schedule Headers (Detail Bills) |
ROWVERSION |
|
Enter zero. |
|
OVRIDE_MLT_ ON_DIR |
Maintain Multiplier Overrides (Projects » Project Setup » Revenue Setup) |
MODIFIED_BY |
|
User ID that imports the data. |
|
OVRIDE_MLT_ ON_DIR |
Maintain Multiplier Overrides |
TIME_STAMP |
|
System date and time of import. |
|
OVRIDE_MLT_ ON_DIR |
Maintain Multiplier Overrides |
ROWVERSION |
|
Enter zero. |
|
OVRIDE_FEE_ ON_DIR |
Maintain Cost Fee Overrides (Projects » Project Setup » Revenue Setup) |
MODIFIED_BY |
|
User ID that imports the data. |
|
OVRIDE_FEE_ON_DIR |
Maintain Cost Fee Overrides |
TIME_STAMP |
|
System date and time of import. |
|
OVRIDE_FEE_ON_DIR |
Maintain Cost Fee Overrides |
ROWVERSION |
|
Enter zero. |
|
OVRIDE_FEE_ON_BURD |
Maintain Burden Fee Overrides (Projects » Project Setup » Revenue Setup) |
ALLOC_GRP_NO |
|
Insert 1. |
|
OVRIDE_FEE_ON_BURD |
Maintain Burden Fee Overrides |
MODIFIED_BY |
|
User ID that imports the data. |
|
OVRIDE_FEE_ON_BURD |
Maintain Burden Fee Overrides |
TIME_STAMP |
|
System date and time of import. |
|
OVRIDE_FEE_ON_BURD |
Maintain Burden Fee Overrides |
ROWVERSION |
|
Enter zero. |
|
EMPL_PROJ_TS_DFLT |
Employee Project TS Defaults (People » Labor » Timesheet Default) |
TIME_STAMP |
|
System date and time of import. |
|
EMPL_PROJ_TS_DFLT |
Employee Project TS Defaults |
ROWVERSION |
|
Enter zero. |
|
EMPL_PROJ_TS_DFLT |
Employee Project TS Defaults |
OT_PAY_TYPE |
|
Insert a NULL. This field is not used. |
|
EMPL_PROJ_TS_DFLT |
Employee Project TS Defaults |
MODIFIED_BY |
|
User ID that imports the data. |
|
LAB_ACCT_GRP_DFLT |
Labor-Grp Project-Acct-Grp TS Defaults (People » Labor » Timesheet Default) |
OT_PAY_TYPE |
|
Insert a NULL. This field is not used. |
|
LAB_ACCT_GRP_DFLT |
Labor-Grp Project-Acct-Grp TS Defaults |
MODIFIED_BY |
|
User ID that imports the data. |
|
LAB_ACCT_GRP_DFLT |
Labor-Grp Project-Acct-Grp TS Defaults |
TIME_STAMP |
|
System date and time of import. |
|
LAB_ACCT_GRP_DFLT |
Labor-Grp Project-Acct-Grp TS Defaults |
ROWVERSION |
|
Enter zero. |
|
EMPL_ACCT_ GRP_DFLT |
Employee Project-Acct-Grp TS Defaults |
MODIFIED_BY |
|
User ID that imports the data. |
|
EMPL_ACCT_ GRP_DFLT |
Employee Project-Acct-Grp TS Defaults |
TIME_STAMP |
|
System date and time of import. |
|
EMPL_ACCT_ GRP_DFLT |
Employee Project-Acct-Grp TS Defaults |
ROWVERSION |
|
Enter zero. |
|
EMPL_ACCT_ GRP_DFLT |
Employee Project-Acct-Grp TS Defaults |
OT_PAY_TYPE |
|
Insert a NULL. This field is not used. |
|
PROJ_TS_DFLT |
Project TS Defaults (People » Labor » Timesheet Default) |
OT_PAY_TYPE |
|
Insert a NULL. This field is not used. |
|
PROJ_TS_DFLT |
Project TS Defaults |
MODIFIED_BY |
|
User ID that imports the data. |
|
PROJ_TS_DFLT |
Project TS Defaults |
TIME_STAMP |
|
System date and time of import. |
|
PROJ_TS_DFLT |
Project TS Defaults |
ROWVERSION |
|
Enter zero. |
The tables derive as follows:
|
Table Name |
Column Name |
Data Type |
Data Length |
"R" (Required) / "O" (Optional) / "D" (Derived) |
Required in the Input File (I) or Default Project (D) |
Derivation Information |
|
PROJ_HIERARCHY |
PROJ_ID |
VARCHAR |
30 |
D |
|
PROJ_ID from PROJ |
|
PROJ_HIERARCHY |
LVL_NO |
SMALL INT |
22 |
D |
|
LVL_NO from PROJ |
|
PROJ_HIERARCHY |
PARENT_PROJ_ID |
VARCHAR |
30 |
D |
|
Derived from PROJ project structure. When LVL_NO = 1, the PARENT_PROJ_ID is always be NULL. When LVL_NO = 2, the PARENT_PROJ_ID is equal to the L1_PROJ_SEG_ID. When LVL_NO =3, the PARENT_PROJ_ID value is equal to the L2_PROJ_SEG_ID, and so on. |
|
PROJ_HIERARCHY |
HAVE_CHILDREN_FL |
VARCHAR |
1 |
D |
|
Derived from PROJ_HIERARCHY. If the PROJ_HIERARCHY.PROJ_ID is found in the PARENT_PROJ_ID field for the project structure, update the HAVE_CHILDREN_FL to Y; otherwise, update to N. |
|
PROJ_HIERARCHY |
L1_PROJ_SEG_ID |
VARCHAR |
30 |
D |
|
L1_PROJ_SEG_ID from PROJ |
|
PROJ_HIERARCHY |
COMPANY_ID |
VARCHAR |
10 |
D |
|
The company the user is logged into. |
|
PROJ_HIERARCHY |
MODIFIED_BY |
VARCHAR |
20 |
D |
|
ID of the user who imports the data. |
|
PROJ_HIERARCHY |
TIME_STAMP |
DATE |
7 |
D |
|
System date and time of import. |
|
PROJ_HIERARCHY |
ROWVERSION |
INTEGER |
22 |
D |
|
Input 0. |
|
PROJ_SRCE_PROJ |
PROJ_ID |
VARCHAR |
30 |
D |
|
PROJ_ID from PROJ |
|
PROJ_SRCE_PROJ |
SRCE_PROJ_ID |
VARCHAR |
30 |
D |
|
Derived from PROJ or TM_RT_ORDER |
|
PROJ_SRCE_PROJ |
L1_PROJ_SEG_ID |
VARCHAR |
30 |
D |
|
L1_PROJ_SEG_ID from PROJ |
|
PROJ_SRCE_PROJ |
PROJ_NAME |
VARCHAR |
25 |
D |
|
PROJ_NAME from PROJ. The PROJ_NAME will come from the top level project number when TOP_LVL_WRK_FRC_FL = Y. |
|
PROJ_SRCE_PROJ |
COMPANY_ID |
VARCHAR |
10 |
D |
|
The company the user is logged into. |
|
PROJ_SRCE_PROJ |
DUMMY_STR_1 |
VARCHAR |
30 |
D |
|
NULL; reserved for future use. |
|
PROJ_SRCE_PROJ |
DUMMY_STR_2 |
VARCHAR |
30 |
D |
|
NULL; reserved for future use. |
|
PROJ_SRCE_PROJ |
DUMMY_DATE_1 |
DATE |
7 |
D |
|
NULL; reserved for future use. |
|
PROJ_SRCE_PROJ |
MODIFIED_BY |
VARCHAR |
20 |
D |
|
User who imports the data. |
|
PROJ_SRCE_PROJ |
TIME_STAMP |
DATE |
7 |
D |
|
System date and time of import. |
|
PROJ_SRCE_PROJ |
ROWVERSION |
INTEGER |
22 |
D |
|
Imput 0. |
|
ROJ_INVC_PROJ |
PROJ_ID |
VARCHAR |
30 |
D |
|
PROJ_ID from PROJ where the LVL_NO for the project structure is greater than or equal to the LVL_NO of the billing level project number from PROJ_BILL_INFO. |
|
PROJ_INVC_PROJ |
INVC_PROJ_ID |
VARCHAR |
30 |
D |
|
INVC_PROJ_ID from PROJ_BILL_INFO |
|
PROJ_INVC_PROJ |
COMPANY_ID |
VARCHAR |
10 |
D |
|
The company the user is logged into. |
|
PROJ_INVC_PROJ |
MODIFIED_BY |
VARCHAR |
20 |
D |
|
ID of the user who imports the data. |
|
PROJ_INVC_PROJ |
TIME_STAMP |
DATE |
7 |
D |
|
System date and time of import. |
|
PROJ_INVC_PROJ |
ROWVERSION |
INTEGER |
22 |
D |
|
Import 0. |
|
PROJ_REV_PROJ |
PROJ_ID |
VARCHAR |
30 |
D |
|
PROJ_ID from PROJ where the LVL_NO for the project structure is greater than or equal to the LVL_NO of the revenue level project number from PROJ_REV_SETUP. |
|
PROJ_REV_PROJ |
REV_PROJ_ID |
VARCHAR |
30 |
D |
|
PROJ_ID from PROJ_REV_SETUP |
|
PROJ_REV_PROJ |
COMPANY_ID |
VARCHAR |
10 |
D |
|
The company the user is logged into. |
|
PROJ_REV_PROJ |
MODIFIED_BY |
VARCHAR |
20 |
D |
|
The ID of the user who imports the data. |
|
PROJ_REV_PROJ |
TIME_STAMP |
DATE |
7 |
D |
|
System date and time of import. |
|
PROJ_REV_PROJ |
ROWVERSION |
INTEGER |
20 |
D |
|
Import 0. |
|
Report Source Table |
File |
|
PROJ |
PJPPREP1.QRP |
|
PROJ_EDIT |
PJPPREP2.QRP |
|
PROJ_LVL |
PJPPREP3.QRP |
|
PROJ_MOD |
PJPPREP4.QRP |
|
PROJ_REV_SETUP |
PJPPREP5.QRP |
|
PROJ_BILL_INFO |
PJPPREP6.QRP |
|
PROJ_CUST_SETUP |
PJPPREP25.QRP |
|
PROJ_GOVT_CONTR |
PJPPREP7.QRP |
|
PROJ_ORG_ACCT |
PJPPREP9.QRP |
|
BILL_LAB_CAT |
PJPPREP25.QRP |
|
PROJ_LAB_CAT |
PJPPREP9.QRP |
|
PROJ_EMPL |
PJPPREP9.QRP |
|
PROJ_VEND |
PJPPREP9.QRP |
|
PROJ_VEND_EMPL |
PJPPREP9.QRP |
|
PROJ_EMPL_LAB_CAT |
PJPPREP9.QRP |
|
PROJ_VEND_LAB_CAT |
PJPPREP9.QRP |
|
PROJ_VEND_EMPL_PLC |
PJPPREP9.QRP |
|
PROJ_LAB_CAT_MAP |
PJPPREP9.QRP |
|
PROJ_BILL_INFO_SCH |
PJPPREP9.QRP |
|
PROJ_RPT_ID |
PJPPREP10.QRP |
|
TOP_LVL_RPT |
PJPPREP10.QRP |
|
PROJ_RPT_PROJ |
PJPPREP10.QRP |
|
PROJ_LAB_CAT_RT_SC |
PJPPREP15.QRP |
|
PROJ_EMPL_RT_SCH |
PJPPREP15.QRP |
|
LAB_CAT_RT_SCH |
PJPPREP15.QRP |
|
CEIL_BURDEN_CST |
PJPPREP21.QRP |
|
TM_RT_ORDER |
PJPPREP25.QRP |
|
CEIL_DIR_CST |
PJPPREP25.QRP |
|
CEIL_DIR_HRS |
PJPPREP25.QRP |
|
OVRIDE_FEE_ON_BURD |
PJPPREP21.QRP |
|
EMPL_CEIL |
PJPPREP25.QRP |
|
VEND_CEIL |
PJPPREP25.QRP |
|
OVRIDE_MLT_ON_DIR |
PJPPREP25.QRP |
|
OVRIDE_FEE_ON_DIR |
PJPPREP25.QRP |
|
EMPL_PROJ_TS_DFLT |
PJPPREP28.QRP |
|
LAB_ACCT_GRP_DFLT |
PJPPREP28.QRP |
|
EMPL_ACT_GRP_DFLT |
PJPPREP28.QRP |
|
PROJ_TS_DFLT |
PJPPREP28.QRP |
|
PROJ_WAWF_INFO |
PJPPREP33.QRP |