PC_BUD_AET

(SQL Table)
 Index Back

PC Budgets Calc State Rec

This is the state record for the PC_BUD_CALC app engine. This app engine calculates budget amounts, costs amounts, and variance amounts by period by budget item.

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
2 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
3 RUN_CNTL_ID Character(30) VARCHAR2(30) NOT NULL Run Control ID
4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
5 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
6 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField
7 PC_BUDGET_ID Number(3,0) SMALLINT NOT NULL Budget Plan ID
8 PC_BUD_TYPE Character(1) VARCHAR2(1) NOT NULL This field defines a Projects Budget as either Cost or Revenue Based.
C=Cost Budget
R=Revenue Budget
9 BUDG_ANALYSIS_GRP Character(5) VARCHAR2(5) NOT NULL Budget Analysis Group
10 COST_ANALYSIS_GRP Character(5) VARCHAR2(5) NOT NULL Cost Analysis Group
11 TO_CUR Character(3) VARCHAR2(3) NOT NULL To Currency Code
12 RT_TYPE Character(5) VARCHAR2(5) NOT NULL Defines a category of market rates for currency conversion. Some examples of rate types are commercial, average, floating, and historical.
13 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
14 PC_BUDGET_ITEM Character(15) VARCHAR2(15) NOT NULL Project Budgeting: Budget Item 11/15/2004- FS - Added label COST_BUDGET_ITEM
15 PC_WEIGHT_POINTS Number(10,0) DECIMAL(10) NOT NULL Weight Points
16 START_DT Date(10) DATE Start Date
17 PC_BUDGET_PERIOD Character(1) VARCHAR2(1) NOT NULL Project Budgeting: Period Type
1=Daily Period
2=Weekly Period
3=Monthly Period
4=Quarterly Period
5=Yearly Period
18 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
19 CALENDAR_ID Character(2) VARCHAR2(2) NOT NULL Calendar ID
20 WORK_CNT Number(10,0) DECIMAL(10) NOT NULL Count of Anything
21 WHERE_CLAUSE_LONG Long Character(4000) CLOB Where Clause