Field Descriptions

Table Information

 

Detail

What can I do in this subtask?

Use this subtask to view detailed rows of the PROJ_SUM table.  If you rolled up the data by project, account, or organization level in the main screen, you can view the rows that make up the lines in the main screen in this subtask.

When you I use this subtask?

Use this subtask when you need to view the detailed rows of the summary rows on the main screen.

Field Descriptions

PROJ_ID

This non-editable field displays the project ID.

ORG_ID

This non-editable field displays the organization ID.

ACCT_ID

This non-editable field displays the account number.

FY_CD

This non-editable field displays the fiscal year associated with the data on this row.

PD_NO

This non-editable field displays the period number associated with the data on this row of the table.

SUB_PD_NO

This non-editable field displays the subperiod number for this row of the table window.

ACCT_FUNC_NO

This non-editable field displays the account function number.  This number is assigned based on the function code of the account that was charged.  

The values in this field are as follows:

Non-WIP Projects

1 - Revenue

2- Labor

3- Non-labor

4- Burden

5- Cost of Money

11- Unallowable Labor

12- Unallowable Non-labor

13- Units

WIP Projects

1 - Revenue

2- Labor

3- Non-labor

4- Burden

5- Cost of Money

6- Cost of Sales

7- WIP Transfer

11- Unallowable Labor

12- Unallowable Non-labor

13- Units

The account function numbers are used when the project status report tables are created and when the Update Prior Year History screen (Projects\Utilities\Project Toolkits\Update Project Prior Year History) is executed.

BURD_CALC_FL

This non-editable field displays a "Y" or a "N."  This flag indicates whether or not burden has been calculated for the direct cost amounts on this row of the table.

FEE_BURD_ACT_AMT

This non-editable field displays the fee on the burden amount that was calculated using actual rates.

FEE_BURD_TGT_AMT

This non-editable field displays the fee on the burden amount that was calculated using target rates.

FEE_ON_DIR_AMT

This non-editable field displays the fee on the direct cost amount.

FEE_ON_HRS_AMT

This non-editable field displays the fee on hours.

MARKUP_FEE_AMT

This non-editable field displays retroactive revenue adjustments for revenue calculated at actual rates.   This field is only used if you have made an adjustment to a year-to-date revenue formula.

OTH_FEE_ACT_AMT

This non-editable field displays any other fees that are calculated on indirect costs using actual rates.

OTH_FEE_TGT_AMT

This non-editable field displays any other fees that are calculated on indirect costs using target rates.

OVER_ACT_CST_AMT

This non-editable field displays the amount by which total costs calculated at actual rates exceed the cost portion of the contract value.

Contract values are entered in the Enter Project Modifications screen (Projects\Transactions\Project\Enter Project Modifications).

OVER_ACT_FEE_AMT

This non-editable field displays the amount by which the fee calculated at actual rates exceeds the contract value fee.

Contract values are entered in the Enter Project Modifications screen (Projects\Transactions\Project\Enter Project Modifications).

OVER_ACT_TOT_AMT

This non-editable field displays the amount by which the total costs and revenue calculated at actual rates exceed the contract value.  

Contract values are entered in the Enter Project Modifications screen (Projects\Transactions\Project\Enter Project Modifications).

OVER_TGT_CST_AMT

This non-editable field displays the amount by which total costs calculated at target rates exceed the cost portion of the contract value.

Contract values are entered in the Enter Project Modifications screen (Projects\Transactions\Project\Enter Project Modifications).

OVER_TGT_FEE_AMT

This non-editable field displays the amount by which the fee calculated at actual rates exceeds the contract value fee.

Contract values are entered in the Enter Project Modifications screen (Projects\Transactions\Project\Enter Project Modifications).

OVER_TGT_TOT_AMT

This non-editable field displays the amount by which the total costs and revenue calculated at target rates exceed the contract value.  

Contract values are entered in the Enter Project Modifications screen (Projects\Transactions\Project\Enter Project Modifications).

POST_SEQ_NO

This non-editable field displays the posting sequence number.  This is a number that is assigned by the system during the posting process.

PTD_ACT_AL_BUR_AMT

This non-editable field displays the period-to-date allowable burden amount calculated at actual rates.

PTD_ACT_BURD_AMT

This non-editable field displays the period-to-date actual burden amount.

PTD_AL_UNITS_QTY

This non-editable field displays the period-to-date allowable units quantity.  Units are allowable as long as they so not exceed any unit ceilings.

PTD_COM_ACT_AL_AMT

This non-editable field displays period-to-date allowable cost of money amount calculated using actual rates. Amounts are allowable as long as they do not exceed cost of money ceilings.

PTD_COM_ACT_AMT

This non-editable field displays period-to-date cost of money amount calculated using actual rates.

PTD_COM_TGT_AL_AMT

This non-editable field displays period-to-date allowable cost of money amount calculated using target rates. Amounts are allowable as long as they do not exceed cost of money ceilings.

PTD_COM_TGT_AMT

This non-editable field displays period-to-date cost of money amount calculated using target rates.

PTD_DIR_ALLOW_AMT

This non-editable field displays the period-to-date allowable direct cost.  Costs are allowable as long as they do not exceed any direct cost ceilings.

PTD_DIR_ALLOW_HRS

This non-editable field displays allowable direct hours.  Hours are allowable as long as they do not exceed any hours ceilings.

PTD_DIR_AMT

This non-editable amount displays period-to-date allowable direct costs.

PTD_DIR_HRS

This non-editable field displays period-to-date direct hours.

PTD_TGT_AL_BUR_AMT

This non-editable field displays the allowable burden calculated at target rates. Burden is allowable as long as it does not exceed burden cost ceilings.

PTD_TGT_BURD_AMT

This non-editable field displays the period-to-date burden calculated using target rates.

PTD_UNITS_QTY

This non-editable field displays the period-to-date units quantity.

REALLOC_CALC_FL

This non-editable field displays  "Y" or "N."  This flag indicates whether reallocation of revenue has been executed.

REALLOC_ACT_AMT

This non-editable field displays redistributed revenue calculated at actual rates.  This field is populated by the Redistribute Revenue screen (Projects\Process\Revenue\Redistribute Revenue).

REALLOC_TGT_AMT

This non-editable field displays redistributed revenue calculated at target rates.  This field is populated by the Redistribute Revenue screen (Projects\Process\Revenue\Redistribute Revenue).

REV_ADJ_AMT

This non-editable field displays any revenue adjustments that have been made to the project.

REV_CALC_FL

This non-editable field displays the revenue calculation flag.  This flag indicates whether or not revenue has been calculated on this transaction.

REV_POST_FL

This non-editable field displays a "Y" or "N."  This flag indicates if revenue has been posted for the data on this row of the table window.

SUB_ACT_AL_BUR_AMT

This non-editable field displays supberiod allowable burden calculated using actual rates.  Burden is allowable as long as it does not exceed any burden ceilings.

SUB_ACT_BURD_AMT

This non-editable field displays the subperiod burden amount calculated using actual rates.

SUB_AL_UNITS_QTY

This non-editable field displays the allowable units quantity.

SUB_COM_ACT_AL_AMT

This non-editable field displays the subperiod cost of money allowable amounts calculated using actual rates.  The allowable portion of the cost of money amount is the amount that does not exceed cost of money ceilings.

SUB_COM_ACT_AMT

This non-editable field displays the subperiod cost of money amount calculated using actual rates.  

SUB_COM_TGT_AL_AMT

This non-editable field displays the subperiod allowable cost of money amount calculated using target rates.  The allowable portion of the cost of money amount is the amount that does not exceed the cost of money ceiling.

SUB_COM_TGT_AMT

This non-editable field displays the subperiod cost of money amount calculated using target rates.

SUB_DIR_ALLOW_AMT

This non-editable field displays the subperiod allowable direct cost amount.  The allowable amount is the amount that does not exceed any direct cost ceilings.

SUB_DIR_ALLOW_HRS

This non-editable field displays the subperiod allowable direct hours.  The allowable hours are those that do not exceed any hours ceilings.

SUB_DIR_AMT

This non-editable field displays the subperiod direct amount.

SUB_DIR_HRS

This non-editable field displays the subperiod direct hours.

SUB_TGT_AL_BUR_AMT

This non-editable field displays the subperiod burden on direct costs calculated at target rates.  The allowable portion is the amount that does not exceed the burden ceilings.

SUB_TGT_BURD_AMT

This non-editable field displays the subperiod direct burden amount calculated at target rates.  

SUB_UNITS_QTY

This non-editable field displays the subperiod direct units quantity.

S_JNL_CD

This non-editable field displays the journal code.

TOT_ACT_AL_EXP_AMT

This non-editable field displays the total allowable expense amount calculated using actual rates.  The total allowable expense is the amount that does not exceed any ceilings.

TOT_REV_ACT_AMT

This non-editable field displays the total revenue amount calculated using actual rates.

TOT_REV_MARKUP_AMT

This non-editable field displays retroactive revenue adjustments for revenue calculated at target rates.  Adjustments are stored in this field if revenue was changed for prior periods.

TOT_REV_TGT_AMT

This non-editable field displays the total revenue amount calculated using target rates.

TOT_REV_TMLAB_AMT

This non-editable field displays the total revenue for time and materials projects.

TOT_REV_TMLAB1_AMT

This non-editable field displays revenue for time and materials projects that do not use the "B" rate type.  It is primarily used when multipliers need to be applied to all rate types except "B."

TOT_REV_UNITS_AMT

This non-editable field displays the total revenue for unit revenue formulas.

TOT_TGT_AL_EXP_AMT

This non-editable field displays the total allowable expenses calculated using target rates.

YTD_ACT_AL_BUR_AMT

This non-editable field displays the year-to-date allowable burden amount calculated using actual rates.

YTD_ACT_BURD_AMT

This non-editable field displays the year-to-date burden amount calculated using actual rates.

YTD_AL_UNITS_QTY

This non-editable field displays the year-to-date  allowable units.  The allowable units are the number of units that do not exceed units ceilings.

YTD_COM_ACT_AL_AMT

This non-editable field displays the year-to-date cost of money allowable amount calculated using actual rates.  The allowable amount is the amount that does not exceed cost of money ceilings.

YTD_COM_ACT_AMT

This non-editable field displays the year-to-date cost of money allowable amount calculated using actual rates.

YTD_COM_TGT_AL_AMT

This non-editable field displays the year-to-date cost of money allowable amount calculated using target rates.  The allowable amount is the amount that does not exceed cost of money ceilings.

YTD_COM_TGT_AMT

This non-editable field displays the year-to-date cost of money allowable amount calculated using target rates.

YTD_DIR_ALLOW_AMT

This non-editable field displays the year-to-date allowable direct amount.  The allowable direct amount is the amount of direct costs that does not exceed any direct cost ceiling.

YTD_DIR_ALLOW_HRS

This non-editable field displays the year-to-date allowable direct hours. Allowable direct hours are those that do not exceed hours ceilings.

YTD_DIR_AMT

This non-editable field displays the year-to-date direct cost amount.

YTD_DIR_HRS

This non-editable field displays the year-to-date direct hours.

YTD_TGT_AL_BUR_AMT

This non-editable field displays the year-to-date allowable burden calculated using target rates.  Allowable burden is the amount of burden that does not exceed burden ceilings.

YTD_TGT_BURD_AMT

This non-editable field displays the year-to-date burden amount calculated using target rates.

YTD_UNITS_QTY

This non-editable field displays the year-to-date units quantity.

* A red asterisk denotes a required field.

Table Information

Data in the PROJ_SUM (Project Summary) table is used in this process.

Top of Page