|
SELECT DISTINCT CONTRACT_NUM , CONTRACT_LINE_NUM , BUSINESS_UNIT , PROJ.PROJECT_ID , LAST_ACTIVITY_ID , EFF_STATUS , IN_USE_SW , INTEGRATION_TMPL , DESCR , PROJECT_TYPE , BUSINESS_UNIT_AM , ASSET_ID , PROFILE_ID , SYSTEM_SOURCE , TEMPLATE_ID , TEMPLATE_SW , AFUDC_PROJ_SW , TARGET_PROJ_SW , SALES_TAX_PROJ_SW , DOCKET_NUMBER , PROJECT_FUNCTION , LAST_CRITERIA_ID , CURRENCY_CD , RT_TYPE , CUR_EFFDT_TYPE , PERCENT_COMPLETE , PC_ACT_OPTION , PROJECT_USER1 , PROJECT_USER2 , PROJECT_USER3 , PROJECT_USER4 , PROJECT_USER5 , PROJECT_USER_DT1 , PROJECT_USER_DT2 , PC_USER_CURRENCY , PROJECT_USERAMT1 , PROJECT_USERAMT2 , PROJECT_USERAMT3 , AN_GRP_ACTV_BUD , AN_GRP_TOT_COSTS , SET_OVERRIDE , DTTM_STAMP , PC_MSP_USR1 , PC_MSP_USR2 , PC_MSP_PROJ_ID , PC_REV_ACTIVITY , ENFORCE , ENFORCE_TYPE , TOLERANCE , PC_SCH_PRODUCT , PC_SCH_FIELD1 , PC_SCH_FIELD2 , PC_SCH_FIELD3 , PC_SCH_FIELD4 , PC_SCH_FIELD5 , PC_SCH_FIELD6 , PC_SCH_FIELD7 , PC_SCH_FIELD8 , PC_INDENT_LEVEL , PROJ_GRANT_STATUS , GRANT_FLG , GM_PRIMARY_FLAG , PC_TEMPLATE_ID , PC_FND_DIST_SW , START_DT , END_DT , BASELINE_START_DT , BASELINE_FINISH_DT , EARLY_START_DT , EARLY_FINISH_DT , ACTUAL_START_DT , ACTUAL_FINISH_DT , LATE_START_DT , LATE_FINISH_DT , PC_DURATION , SUMMARY_PRJ , PC_CHC_SW , PC_CHC_TEMPLATE , PC_CALCULATE_SW , PC_PRJ_DEF_CALC_MT , PC_ACT_DEF_CALC_MT , PC_HOURS_PER_DAY , PC_CALC_METHOD , PC_SUM_METHOD , PM_AUTO_REVIEW , FORECAST_AUT_APP , FORECAST_LEVEL , FORECAST_RATE , FORECAST_SRC , PROJ_REQUEST_ID , PPK_PROJ_VERSION , PGM_SCHED_METHOD , PC_PERCENT_DTTM , HOLIDAY_LIST_ID , FMS_DTTM_STAMP , FMS_OPRID , FMS_LASTUPDDTTM , FMS_LASTUPDOPRID , CONSTRAINT_DT_FLG , CHARGING_LEVEL , CHARGING_LEVEL_TR , RATE_PLAN , BUDGET_APPROVER , SCEN_ADJUST_PCT_TM , SCEN_ADJUST_PCT_EX , TEMPLATE_TYPES , PROJ_TMPL_FILTER , LAST_CBUD_TYPE , LAST_RBUD_TYPE , FNA_REQUESTED , MANAGED_BY_WO , RELEASE , CATEGORY_IND , APPLICATION_AREA , APPLICATION , RATE_SELECT , PC_REV_BUD_AN_GRP , AN_GRP_TOT_REV , AN_GRP_EAC , RETAIN_HISTORY , AN_GRP_FREV , ANLTC_ACT_COST , ANLTC_ACT_REV , ANLTC_FC_COST , ANLTC_FC_REV , ONE_TARGET_SW FROM PS_CA_DETAIL_PROJ DTL , PS_PROJECT PROJ WHERE PROJ.BUSINESS_UNIT = DTL.BUSINESS_UNIT_PC AND PROJ.PROJECT_ID = DTL.PROJECT_ID
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 CONTRACT_NUM |
Character(25) |
VARCHAR2(25) NOT NULL |
Contract
Prompt Table:
CA_CONTR_HDR
|
| 2 |
CONTRACT_LINE_NUM |
Number(3,0) |
SMALLINT NOT NULL |
Contract Line Num
|
| 3 |
BUSINESS_UNIT |
Character(5) |
VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT
Prompt Table:
SP_BU_PC_NONVW
|
| 4 |
PROJECT_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table:
PROJECT_VW
|
| 5 |
LAST_ACTIVITY_ID |
Number(8,0) |
INTEGER NOT NULL |
Last Actvity ID
|
| 6 |
EFF_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Effective Status
A=Active
I=Inactive
Default Value: A
|
| 7 |
IN_USE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Table in use switch
Default Value: N
|
| 8 |
INTEGRATION_TMPL |
Character(15) |
VARCHAR2(15) NOT NULL |
Integration
Default Value: OPR_DEF_TBL_PC.INTEGRATION_TMPL
Prompt Table:
PC_INT_TMPL
|
| 9 |
DESCR |
Character(30) |
VARCHAR2(30) NOT NULL |
Description
|
| 10 |
PROJECT_TYPE |
Character(5) |
VARCHAR2(5) NOT NULL |
Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment
Prompt Table:
PROJ_TYPE_TBL
|
| 11 |
BUSINESS_UNIT_AM |
Character(5) |
VARCHAR2(5) NOT NULL |
AM Business Unit
Default Value: PC_INT_TMPL.BUSINESS_UNIT_AM
Prompt Table:
SP_BU_AM_NONVW
|
| 12 |
ASSET_ID |
Character(12) |
VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table:
PROJ_ASSET_VW
|
| 13 |
PROFILE_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
Asset Profile ID
Prompt Table:
PROFILE_PCAM_VW
|
| 14 |
SYSTEM_SOURCE |
Character(3) |
VARCHAR2(3) NOT NULL |
Identifies the application or source system that generated a journal entry.
Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values.
SUJ---Included a label as Product.
Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen.
Default Value: PPC
|
| 15 |
TEMPLATE_ID |
Character(30) |
VARCHAR2(30) NOT NULL |
Project Template
Default Value: OPR_DEF_TBL_PC.TEMPLATE_ID
Prompt Table:
PROJECT_TMPL_VW
|
| 16 |
TEMPLATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allows the user to indicate whether a given bank transfer transaction should be designated as a
Y/N Table Edit
Default Value: N
|
| 17 |
AFUDC_PROJ_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Interest Calculation
Y/N Table Edit
Default Value: N
|
| 18 |
TARGET_PROJ_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allocation Target
Y/N Table Edit
Default Value: N
|
| 19 |
SALES_TAX_PROJ_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Allow Sales Tax Calculation
Y/N Table Edit
Default Value: N
|
| 20 |
DOCKET_NUMBER |
Character(15) |
VARCHAR2(15) NOT NULL |
Docket Number
|
| 21 |
PROJECT_FUNCTION |
Character(10) |
VARCHAR2(10) NOT NULL |
Project Function
|
| 22 |
LAST_CRITERIA_ID |
Number(8,0) |
INTEGER NOT NULL |
Last Criteria ID
|
| 23 |
CURRENCY_CD |
Character(3) |
VARCHAR2(3) NOT NULL |
Currency Code
Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD
Prompt Table:
CURRENCY_CD_TBL
|
| 24 |
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.
Default Value: BUS_UNIT_TBL_PC.RT_TYPE
Prompt Table:
RT_TYPE_TBL
|
| 25 |
CUR_EFFDT_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Currency Eff. Date Default
A=Accounting Date
C=Current Date
T=Transaction Date
Default Value: BUS_UNIT_TBL_PC.CUR_EFFDT_TYPE
|
| 26 |
PERCENT_COMPLETE |
Number(6,2) |
DECIMAL(5,2) NOT NULL |
% Complete
|
| 27 |
PC_ACT_OPTION |
Character(1) |
VARCHAR2(1) NOT NULL |
Standard Activities
F=FreeForm Activity ID's
P=Activity ID's by Project Type
Default Value: F
|
| 28 |
PROJECT_USER1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 1
|
| 29 |
PROJECT_USER2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 2
|
| 30 |
PROJECT_USER3 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 3
|
| 31 |
PROJECT_USER4 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 4
|
| 32 |
PROJECT_USER5 |
Character(10) |
VARCHAR2(10) NOT NULL |
Project User 5
|
| 33 |
PROJECT_USER_DT1 |
Date(10) |
DATE |
Date 1
|
| 34 |
PROJECT_USER_DT2 |
Date(10) |
DATE |
Date 2
|
| 35 |
PC_USER_CURRENCY |
Character(3) |
VARCHAR2(3) NOT NULL |
User Currency
Prompt Table:
CURRENCY_CD_TBL
|
| 36 |
PROJECT_USERAMT1 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount 1
|
| 37 |
PROJECT_USERAMT2 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount 2
|
| 38 |
PROJECT_USERAMT3 |
Signed Number(17,2) |
DECIMAL(15,2) NOT NULL |
Amount 3
|
| 39 |
AN_GRP_ACTV_BUD |
Character(5) |
VARCHAR2(5) NOT NULL |
Budget Analysis Group
Default Value: INSTALLATION_PC.AN_GRP_ACTV_BUD
Prompt Table:
SP_AN_GRP_NONVW
|
| 40 |
AN_GRP_TOT_COSTS |
Character(5) |
VARCHAR2(5) NOT NULL |
Cost Analysis Group
Default Value: INSTALLATION_PC.AN_GRP_TOT_COSTS
Prompt Table:
SP_AN_GRP_NONVW
|
| 41 |
SET_OVERRIDE |
Character(5) |
VARCHAR2(5) NOT NULL |
FS_08 SetID
Prompt Table:
SP_SETID_NONVW
|
| 42 |
DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
|
| 43 |
PC_MSP_USR1 |
Character(10) |
VARCHAR2(10) NOT NULL |
Microsoft User Define1
|
| 44 |
PC_MSP_USR2 |
Character(10) |
VARCHAR2(10) NOT NULL |
Microsoft User Define2
|
| 45 |
PC_MSP_PROJ_ID |
Character(22) |
VARCHAR2(22) NOT NULL |
Unique MSP Project ID
|
| 46 |
PC_REV_ACTIVITY |
Character(15) |
VARCHAR2(15) NOT NULL |
Revenue Activity
Prompt Table:
PROJ_ACT_VW
|
| 47 |
ENFORCE |
Character(1) |
VARCHAR2(1) NOT NULL |
Enforce project team based prompt. Besides the defined translate values, this field is updated with a value of 'N' when team is not enforced in any of the products.
E=Expenses
N=No
T=Time&Labor
Y=Exp and TL
Default Value: BUS_UNIT_OPT_PC.ENFORCE
|
| 48 |
ENFORCE_TYPE |
Character(1) |
VARCHAR2(1) NOT NULL |
Enforce project and activity team based prompt.
B=Project and Activity Team
N=Do Not Enforce
P=Project Team Only
R=Project Resource Pools Only
S=Project Activity Resource Pool
X=Decide at the Project Level
Default Value: BUS_UNIT_OPT_PC.ENFORCE_TYPE
|
| 49 |
TOLERANCE |
Signed Number(13,8) |
DECIMAL(11,8) NOT NULL |
Tolerance Percent
Default Value: INSTALLATION_PC.TOLERANCE
|
| 50 |
PC_SCH_PRODUCT |
Character(3) |
VARCHAR2(3) NOT NULL |
Product code used by Projects to determine the third party scheduling product being integrated with.
Prompt Table:
PC_SCH_PRODUCT
|
| 51 |
PC_SCH_FIELD1 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 52 |
PC_SCH_FIELD2 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 53 |
PC_SCH_FIELD3 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 54 |
PC_SCH_FIELD4 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 55 |
PC_SCH_FIELD5 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 56 |
PC_SCH_FIELD6 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 57 |
PC_SCH_FIELD7 |
Character(40) |
VARCHAR2(40) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 58 |
PC_SCH_FIELD8 |
Character(100) |
VARCHAR2(100) NOT NULL |
Generic field used for Projects Third Party Schedule Integration.
|
| 59 |
PC_INDENT_LEVEL |
Number(3,0) |
SMALLINT NOT NULL |
Tree Indent Level
|
| 60 |
PROJ_GRANT_STATUS |
Character(1) |
VARCHAR2(1) NOT NULL |
Status
A=Approved
C=Completed
I=In Progress
P=Proposed
|
| 61 |
GRANT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Grants Management
Used for designating whether or not an object is for Grants or for Projects.
N=Projects Object
Y=Grants Object
|
| 62 |
GM_PRIMARY_FLAG |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate a Project as a Primary Project
Y/N Table Edit
|
| 63 |
PC_TEMPLATE_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
Rate Template ID
Prompt Table:
PC_RATE_VW2
|
| 64 |
PC_FND_DIST_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
This field is used to indicate the use of Funds Distribution functionality.
Y/N Table Edit
Default Value: N
|
| 65 |
START_DT |
Date(10) |
DATE NOT NULL |
Start Date
Default Value: %Date
|
| 66 |
END_DT |
Date(10) |
DATE NOT NULL |
End Date
Default Value: %Date
|
| 67 |
BASELINE_START_DT |
Date(10) |
DATE |
Baseline Start Date
|
| 68 |
BASELINE_FINISH_DT |
Date(10) |
DATE |
Baseline Finish Date
|
| 69 |
EARLY_START_DT |
Date(10) |
DATE |
Early Start Date
|
| 70 |
EARLY_FINISH_DT |
Date(10) |
DATE |
Early Finish Date
|
| 71 |
ACTUAL_START_DT |
Date(10) |
DATE |
Actual Start Date
|
| 72 |
ACTUAL_FINISH_DT |
Date(10) |
DATE |
Actual Finish Date
|
| 73 |
LATE_START_DT |
Date(10) |
DATE |
Late Start Date
|
| 74 |
LATE_FINISH_DT |
Date(10) |
DATE |
Late Finish Date
|
| 75 |
PC_DURATION |
Number(11,2) |
DECIMAL(10,2) NOT NULL |
Duration
|
| 76 |
SUMMARY_PRJ |
Character(1) |
VARCHAR2(1) NOT NULL |
An indicator to determine whether project is summary or detail.
N=Detail Project
Y=Program
Default Value: N
|
| 77 |
PC_CHC_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Enable Change Control
Y/N Table Edit
Default Value: N
|
| 78 |
PC_CHC_TEMPLATE |
Character(30) |
VARCHAR2(30) NOT NULL |
Change Control Template
Default Value: BUS_UNIT_OPT_PC.PC_CHC_TEMPLATE
Prompt Table:
PC_CHC_CFG
|
| 79 |
PC_CALCULATE_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Project-level switch to allow auto-calculation to be turned off if enabled at the BU level.
D=Delay Calculations Until Save
M=Manual
R=Realtime Calculations
Default Value: BUS_UNIT_OPT_PC.PC_CALCULATE_SW
|
| 80 |
PC_PRJ_DEF_CALC_MT |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculate The
D=Duration
E=End Date
S=Start Date
Default Value: BUS_UNIT_OPT_PC.PC_PRJ_DEF_CALC_MT
|
| 81 |
PC_ACT_DEF_CALC_MT |
Character(1) |
VARCHAR2(1) NOT NULL |
Activity Calculation Method
D=Duration
E=End Date
S=Start Date
Default Value: BUS_UNIT_OPT_PC.PC_ACT_DEF_CALC_MT
|
| 82 |
PC_HOURS_PER_DAY |
Number(2,0) |
SMALLINT NOT NULL |
Hours per Day
Default Value: BUS_UNIT_OPT_PC.PC_HOURS_PER_DAY
|
| 83 |
PC_CALC_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Calculation Method
A=Budget Amount
D=Duration
F=Forecast Amount
H=Forecast Hours
M=Manual
U=Budget Hours
Default Value: BUS_UNIT_OPT_PC.PC_CALC_METHOD
|
| 84 |
PC_SUM_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
Summary Method
N=None
S=Straight-Line
W=Weighted
Default Value: BUS_UNIT_OPT_PC.PC_SUM_METHOD
|
| 85 |
PM_AUTO_REVIEW |
Character(1) |
VARCHAR2(1) NOT NULL |
Auto Review for Billing
N=Not Reviewed
Y=Reviewed
Default Value: PROJ_TYPE_TBL.PM_AUTO_REVIEW
|
| 86 |
FORECAST_AUT_APP |
Character(1) |
VARCHAR2(1) NOT NULL |
Automatic Forecast Approval
N=No
Y=Yes
Default Value: BUS_UNIT_OPT_PC.FORECAST_AUT_APP
|
| 87 |
FORECAST_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Forecast Level
A=Project/Activity
P=Project
Default Value: BUS_UNIT_OPT_PC.FORECAST_LEVEL
|
| 88 |
FORECAST_RATE |
Character(1) |
VARCHAR2(1) NOT NULL |
Standard Rate
E=Resource
J=Job Code
R=Role
Default Value: BUS_UNIT_OPT_PC.FORECAST_RATE
|
| 89 |
FORECAST_SRC |
Character(1) |
VARCHAR2(1) NOT NULL |
Forecast Source
F=PeopleSoft Forecast Collection
M=3rd Party Microsoft Project
P=3rd Party Primavera
Default Value: F
|
| 90 |
PROJ_REQUEST_ID |
Character(15) |
VARCHAR2(15) NOT NULL |
A unique identifier that represents a Project Request.
|
| 91 |
PPK_PROJ_VERSION |
Character(15) |
VARCHAR2(15) NOT NULL |
An identifier that represents a version of the Project Request.
|
| 92 |
PGM_SCHED_METHOD |
Character(1) |
VARCHAR2(1) NOT NULL |
The method to be used for Project Scheduling. Valid methods are: Fixed Units, Fixed Duration, and Fixed Work
D=Fixed Duration
U=Fixed Units
W=Fixed Work
Default Value: BUS_UNIT_OPT_PC.PGM_SCHED_METHOD
|
| 93 |
PC_PERCENT_DTTM |
DateTime(26) |
TIMESTAMP |
The datetime stamp of when the Project Percent Complete was either last calculated or manually entered.
|
| 94 |
HOLIDAY_LIST_ID |
Character(10) |
VARCHAR2(10) NOT NULL |
This is used to identify what holiday calendar to use. This is the access
field for all financials groups.
Default Value: BUS_UNIT_OPT_PC.HOLIDAY_LIST_ID
Prompt Table:
BUS_CAL_HOL_VW
|
| 95 |
FMS_DTTM_STAMP |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the original entry.
|
| 96 |
FMS_OPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the original entry.
|
| 97 |
FMS_LASTUPDDTTM |
DateTime(26) |
TIMESTAMP |
Specifies the date and time of the last update to an entry.
|
| 98 |
FMS_LASTUPDOPRID |
Character(30) |
VARCHAR2(30) NOT NULL |
Specifies the User ID which made the last update to an entry.
|
| 99 |
CONSTRAINT_DT_FLG |
Character(1) |
VARCHAR2(1) NOT NULL |
Always Honor Constraint Dates
Y/N Table Edit
Default Value: Y
|
| 100 |
CHARGING_LEVEL |
Character(1) |
VARCHAR2(1) NOT NULL |
Project Charging Level - identifies which level of the WBS activities are available for charging.
'D' indicates the detail level, which means all detail activities are available for charging.
'1' indicates level 1 of the WBS is available for charging.
'2' indicates level 2 of the WBS is available for charging.
'3' indicates level 3 of the WBS is available for charging.
1=Costing Level 1
2=Costing Level 2
3=Costing Level 3
D=Detail
Default Value: BUS_UNIT_OPT_PC.CHARGING_LEVEL
|
| 101 |
CHARGING_LEVEL_TR |
Character(1) |
VARCHAR2(1) NOT NULL |
Time Report Charging Level - identifies which level of the WBS activities are available for charging on time reports enter in Expenses.
'D' indicates the detail level, which means all detail activities are available for charging.
'1' indicates level 1 of the WBS is available for charging.
'2' indicates level 2 of the WBS is available for charging.
'3' indicates level 3 of the WBS is available for charging.
1=Costing Level 1
2=Costing Level 2
3=Costing Level 3
D=Detail
Default Value: BUS_UNIT_OPT_PC.CHARGING_LEVEL_TR
|
| 102 |
RATE_PLAN |
Character(15) |
VARCHAR2(15) NOT NULL |
Rate Plan - A Rate Plan will allow rate sets to be stacked on top of each other so that the output from one rate set can be used to create additional output from the next rate set. Rate Plans will replace existing Burden Plans in release 8.9. A Rate Plan could be tied to Project Type, Project, Activity or Contract line.
Prompt Table:
PC_RATE_PLAN_A
|
| 103 |
BUDGET_APPROVER |
Character(11) |
VARCHAR2(11) NOT NULL |
Budget Approver - the employee id of the individual who will be responsible for approving budget changes for a given project.
Prompt Table:
PC_CHC_BUD_APR
|
| 104 |
SCEN_ADJUST_PCT_TM |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Scenario Adjustment % for Time
06/09/2004 PR_FS_B005
Added Label - LABOR_ADJUST
|
| 105 |
SCEN_ADJUST_PCT_EX |
Signed Number(7,2) |
DECIMAL(5,2) NOT NULL |
Scenario Adjustment % for Expense
06/09/2004 PR_FS_B005
Added Label NON_LABOR_ADJUST
|
| 106 |
TEMPLATE_TYPES |
Character(1) |
VARCHAR2(1) NOT NULL |
Template Types - used to identify whether a project template is public or private.
R=Private
U=Public
Default Value: U
|
| 107 |
PROJ_TMPL_FILTER |
Character(30) |
VARCHAR2(30) NOT NULL |
Template Filter - identifies who is able to view/update a project template. If this field is set to '1', the template is public. If the template is private, this field will contain the operator id of the person who created the template.
Default Value: 1
|
| 108 |
LAST_CBUD_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the last cost budget analysis type used in Projects Budgeting when versioning is turned on.
|
| 109 |
LAST_RBUD_TYPE |
Character(3) |
VARCHAR2(3) NOT NULL |
This field stores the last revenue budget analysis type used in Projects Budgeting when versioning is turned on.
|
| 110 |
FNA_REQUESTED |
Character(1) |
VARCHAR2(1) NOT NULL |
Used for Grants type projects only. A flag to indicate whether FNA is requested.
Y/N Table Edit
Default Value: Y
|
| 111 |
MANAGED_BY_WO |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicates whether a project is Work Order Managed.
N=No
Y=Yes
Y/N Table Edit
Default Value: N
|
| 112 |
RELEASE |
Character(15) |
VARCHAR2(15) NOT NULL |
Release - Carries Release Information driven by the BUSINESS_UNIT
Prompt Table:
PGM_RELEASE_ALL
|
| 113 |
CATEGORY_IND |
Character(10) |
VARCHAR2(10) NOT NULL |
An additional attribute of the project, program, or project request for further classification. This field is user-defined. Examples of usage include "Strategic", "Operational", "Tactical", etc.
Prompt Table:
PGM_CATEGORY_AC
|
| 114 |
APPLICATION_AREA |
Character(10) |
VARCHAR2(10) NOT NULL |
The general area in which an application belongs. Examples: "Financials", "Human Resources", etc.
Prompt Table:
PGM_APPLAREA_AC
|
| 115 |
APPLICATION |
Character(10) |
VARCHAR2(10) NOT NULL |
Usually refers to a software application, such as "Payables", "Projects", "Purchasing", etc. An application needs to be defined under an application area.
Prompt Table:
PGM_APPLICAT_AC
|
| 116 |
RATE_SELECT |
Character(1) |
VARCHAR2(1) NOT NULL |
This will determine selection of 1) Rate Set and 2) Rate Plan in Project Type, Project and Activity.
1=Rate Set
2=Rate Plan
|
| 117 |
PC_REV_BUD_AN_GRP |
Character(5) |
VARCHAR2(5) NOT NULL |
Revenue budget analysis group
Default Value: INSTALLATION_PC.PC_REV_BUD_AN_GRP
Prompt Table:
SP_AN_GRP_NONVW
|
| 118 |
AN_GRP_TOT_REV |
Character(5) |
VARCHAR2(5) NOT NULL |
Cost Analysis Group
Default Value: INSTALLATION_PC.AN_GRP_TOT_REV
Prompt Table:
SP_AN_GRP_NONVW
|
| 119 |
AN_GRP_EAC |
Character(5) |
VARCHAR2(5) NOT NULL |
Analysis group representing the Estimate at Completion (a.k.a. Forecast).
Default Value: INSTALLATION_PC.AN_GRP_EAC
Prompt Table:
SP_AN_GRP_NONVW
|
| 120 |
RETAIN_HISTORY |
Character(1) |
VARCHAR2(1) NOT NULL |
Indicator to determine how often history is retained.
D=Daily
M=Monthly
Q=Quarterly
W=Weekly
Default Value: BUS_UNIT_OPT_PC.RETAIN_HISTORY
|
| 121 |
AN_GRP_FREV |
Character(5) |
VARCHAR2(5) NOT NULL |
Forecast Revenue analysis group - contains all the analysis types that make up Forecast Revenue.
Default Value: INSTALLATION_PC.AN_GRP_FREV
Prompt Table:
SP_AN_GRP_NONVW
|
| 122 |
ANLTC_ACT_COST |
Character(5) |
VARCHAR2(5) NOT NULL |
Actual Cost analysis group for profitability reporting - contains all the analysis types that make up Actual Cost.
Default Value: INSTALLATION_PC.AN_GRP_TOT_COSTS
Prompt Table:
SP_AN_GRP_NONVW
|
| 123 |
ANLTC_ACT_REV |
Character(5) |
VARCHAR2(5) NOT NULL |
Actual Revenue analysis group for profitability reporting - contains all the analysis types that make up Actual Revenue.
Default Value: INSTALLATION_PC.AN_GRP_TOT_REV
Prompt Table:
SP_AN_GRP_NONVW
|
| 124 |
ANLTC_FC_COST |
Character(5) |
VARCHAR2(5) NOT NULL |
Forecast Cost analysis group for profitability reporting - contains all the analysis types that make up Forecast Cost.
Default Value: INSTALLATION_PC.AN_GRP_EAC
Prompt Table:
SP_AN_GRP_NONVW
|
| 125 |
ANLTC_FC_REV |
Character(5) |
VARCHAR2(5) NOT NULL |
Forecast Revenue analysis group for profitability reporting - contains all the analysis types that make up Forecast Revenue.
Default Value: INSTALLATION_PC.AN_GRP_FREV
Prompt Table:
SP_AN_GRP_NONVW
|
| 126 |
ONE_TARGET_SW |
Character(1) |
VARCHAR2(1) NOT NULL |
Group target definitions
N=No
Y=Yes
Y/N Table Edit
Default Value: BUS_UNIT_OPT_PC.ONE_TARGET_SW
|