OI_PROJ_VW (SQL View)	Index Back
Project Primary record for Project

OI_PROJ_VW

(SQL View)

Project

Primary record for Project

SELECT PF.BUSINESS_UNIT , PF.PROJECT_ID , PF.DESCR , PF.EFF_STATUS , PF.LAST_ACTIVITY_ID , PF.IN_USE_SW , PF.INTEGRATION_TMPL , PF.DESCR INTEG_DESCR , PF.PROJECT_TYPE , PF.BUSINESS_UNIT_AM , PF.ASSET_ID , PF.PROFILE_ID , XLI1.DESCR SYSTEM_SOURCE , PF.TEMPLATE_ID , PF.TEMPLATE_SW , PF.AFUDC_PROJ_SW , PF.TARGET_PROJ_SW , PF.SALES_TAX_PROJ_SW , PF.DOCKET_NUMBER , PF.PROJECT_FUNCTION , PF.LAST_CRITERIA_ID , PF.CURRENCY_CD , PF.RT_TYPE , XLI2.DESCR CUR_EFFDT_TYPE , PF.PERCENT_COMPLETE , XLI3.DESCR PC_ACT_OPTION , PF.PROJECT_USER1 , PF.PROJECT_USER2 , PF.PROJECT_USER3 , PF.PROJECT_USER4 , PF.PROJECT_USER5 , PF.PROJECT_USER_DT1 , PF.PROJECT_USER_DT2 , PF.PC_USER_CURRENCY , PF.PROJECT_USERAMT1 , PF.PROJECT_USERAMT2 , PF.PROJECT_USERAMT3 , PF.AN_GRP_ACTV_BUD , PF.AN_GRP_TOT_COSTS , PF.SETID , PF.DTTM_STAMP , PF.PC_MSP_USR1 , PF.PC_MSP_USR2 , PF.PC_MSP_PROJ_ID , PF.PC_REV_ACTIVITY , PA.DESCR PC_REV_ACT_DESCR , PF.ENFORCE , XLI4.DESCR ENFORCE_TYPE , PF.TOLERANCE , PF.PC_SCH_PRODUCT , PF.PC_SCH_FIELD1 , PF.PC_SCH_FIELD2 , PF.PC_SCH_FIELD3 , PF.PC_SCH_FIELD4 , PF.PC_SCH_FIELD5 , PF.PC_SCH_FIELD6 , PF.PC_SCH_FIELD7 , PF.PC_SCH_FIELD8 , PF.PC_INDENT_LEVEL , XLI6.DESCR PROJ_GRANT_STATUS , XLI5.DESCR GRANT_FLG , PF.GM_PRIMARY_FLAG , PF.PC_TEMPLATE_ID , PF.PC_FND_DIST_SW , PF.START_DT , PF.END_DT , PF.BASELINE_START_DT , PF.BASELINE_FINISH_DT , PF.EARLY_START_DT , PF.EARLY_FINISH_DT , PF.ACTUAL_START_DT , PF.ACTUAL_FINISH_DT , PF.LATE_START_DT , PF.LATE_FINISH_DT , PF.PC_DURATION , XLI7.DESCR SUMMARY_PRJ , PF.PC_CHC_SW , PF.PC_CHC_TEMPLATE , XLI8.DESCR PC_CALCULATE_SW , XLI9.DESCR PC_PRJ_DEF_CALC_MT , XLI10.DESCR PC_ACT_DEF_CALC_MT , PF.PC_HOURS_PER_DAY , XLI11.DESCR PC_CALC_METHOD , XLI12.DESCR PC_SUM_METHOD , XLI13.DESCR PM_AUTO_REVIEW , XLI14.DESCR FORECAST_AUT_APP , XLI15.DESCR FORECAST_LEVEL , XLI16.DESCR FORECAST_RATE , XLI17.DESCR FORECAST_SRC , PF.PROJ_REQUEST_ID , PF.PPK_PROJ_VERSION , XLI18.DESCR PGM_SCHED_METHOD , PF.PC_PERCENT_DTTM , PF.HOLIDAY_LIST_ID , PF.CONSTRAINT_DT_FLG , XLI19.DESCR CHARGING_LEVEL , XLI20.DESCR CHARGING_LEVEL_TR , PF.RATE_PLAN , PF.BUDGET_APPROVER , PF.SCEN_ADJUST_PCT_TM , PF.SCEN_ADJUST_PCT_EX , XLI21.DESCR TEMPLATE_TYPES , PF.PROJ_TMPL_FILTER , PF.LAST_CBUD_TYPE , PF.LAST_RBUD_TYPE , PF.FNA_REQUESTED , PF.MANAGED_BY_WO , PF.RELEASE , PF.CATEGORY_IND , PF.APPLICATION_AREA , PF.APPLICATION , XLI22.DESCR RATE_SELECT , PF.PC_REV_BUD_AN_GRP , PF.AN_GRP_TOT_REV , PF.AN_GRP_EAC , XLI23.DESCR RETAIN_HISTORY , PF.AN_GRP_FREV , PF.ANLTC_ACT_COST , PF.ANLTC_ACT_REV , PF.ANLTC_FC_COST , PF.ANLTC_FC_REV , PF.ONE_TARGET_SW FROM PS_PROJECT_FS PF LEFT OUTER JOIN PS_PC_INT_TMPL IT ON PF.SETID = IT.SETID AND PF.INTEGRATION_TMPL = IT.INTEGRATION_TMPL LEFT OUTER JOIN PS_PROJ_ACTIVITY PA ON PF.BUSINESS_UNIT=PA.BUSINESS_UNIT AND PF.PC_REV_ACTIVITY = PA.ACTIVITY_ID AND PF.PROJECT_ID = PA.PROJECT_ID LEFT OUTER JOIN PS_OI_COMMON_VW XLI1 ON XLI1.CODESETNAME = PF.SYSTEM_SOURCE AND XLI1.CODESETGROUPNAME ='SYSTEM_SOURCE' LEFT OUTER JOIN PS_OI_COMMON_VW XLI2 ON XLI2.CODESETNAME = PF.CUR_EFFDT_TYPE AND XLI2.CODESETGROUPNAME ='CUR_EFFDT_TYPE' LEFT OUTER JOIN PS_OI_COMMON_VW XLI3 ON XLI3.CODESETNAME = PF.PC_ACT_OPTION AND XLI3.CODESETGROUPNAME ='PC_ACT_OPTION' LEFT OUTER JOIN PS_OI_COMMON_VW XLI4 ON XLI4.CODESETNAME = PF.ENFORCE_TYPE AND XLI4.CODESETGROUPNAME ='ENFORCE_TYPE' LEFT OUTER JOIN PS_OI_COMMON_VW XLI6 ON XLI6.CODESETNAME = PF.PROJ_GRANT_STATUS AND XLI6.CODESETGROUPNAME ='PROJ_GRANT_STATUS' LEFT OUTER JOIN PS_OI_COMMON_VW XLI5 ON XLI5.CODESETNAME = PF.GRANT_FLG AND XLI5.CODESETGROUPNAME ='GRANT_FLG' LEFT OUTER JOIN PS_OI_COMMON_VW XLI7 ON XLI7.CODESETNAME = PF.SUMMARY_PRJ AND XLI7.CODESETGROUPNAME ='SUMMARY_PRJ' LEFT OUTER JOIN PS_OI_COMMON_VW XLI8 ON XLI8.CODESETNAME = PF.PC_CALCULATE_SW AND XLI8.CODESETGROUPNAME ='PC_CALCULATE_SW' LEFT OUTER JOIN PS_OI_COMMON_VW XLI9 ON XLI9.CODESETNAME = PF.PC_PRJ_DEF_CALC_MT AND XLI9.CODESETGROUPNAME ='PC_PRJ_DEF_CALC_MT' LEFT OUTER JOIN PS_OI_COMMON_VW XLI10 ON XLI10.CODESETNAME = PF.PC_ACT_DEF_CALC_MT AND XLI10.CODESETGROUPNAME ='PC_ACT_DEF_CALC_MT' LEFT OUTER JOIN PS_OI_COMMON_VW XLI11 ON XLI11.CODESETNAME = PF.PC_CALC_METHOD AND XLI11.CODESETGROUPNAME ='PC_CALC_METHOD' LEFT OUTER JOIN PS_OI_COMMON_VW XLI12 ON XLI12.CODESETNAME = PF.PC_SUM_METHOD AND XLI12.CODESETGROUPNAME ='PC_SUM_METHOD' LEFT OUTER JOIN PS_OI_COMMON_VW XLI13 ON XLI13.CODESETNAME = PF.PM_AUTO_REVIEW AND XLI13.CODESETGROUPNAME ='PM_AUTO_REVIEW' LEFT OUTER JOIN PS_OI_COMMON_VW XLI14 ON XLI14.CODESETNAME = PF.FORECAST_AUT_APP AND XLI14.CODESETGROUPNAME ='FORECAST_AUT_APP' LEFT OUTER JOIN PS_OI_COMMON_VW XLI15 ON XLI15.CODESETNAME = PF.FORECAST_LEVEL AND XLI15.CODESETGROUPNAME ='FORECAST_LEVEL' LEFT OUTER JOIN PS_OI_COMMON_VW XLI16 ON XLI16.CODESETNAME = PF.FORECAST_RATE AND XLI16.CODESETGROUPNAME ='FORECAST_RATE' LEFT OUTER JOIN PS_OI_COMMON_VW XLI17 ON XLI17.CODESETNAME = PF.FORECAST_SRC AND XLI17.CODESETGROUPNAME ='FORECAST_SRC' LEFT OUTER JOIN PS_OI_COMMON_VW XLI18 ON XLI18.CODESETNAME = PF.PGM_SCHED_METHOD AND XLI18.CODESETGROUPNAME ='PGM_SCHED_METHOD' LEFT OUTER JOIN PS_OI_COMMON_VW XLI19 ON XLI19.CODESETNAME = PF.CHARGING_LEVEL AND XLI19.CODESETGROUPNAME ='CHARGING_LEVEL' LEFT OUTER JOIN PS_OI_COMMON_VW XLI20 ON XLI20.CODESETNAME = PF.CHARGING_LEVEL_TR AND XLI20.CODESETGROUPNAME ='CHARGING_LEVEL_TR' LEFT OUTER JOIN PS_OI_COMMON_VW XLI21 ON XLI21.CODESETNAME = PF.TEMPLATE_TYPES AND XLI21.CODESETGROUPNAME ='TEMPLATE_TYPES' LEFT OUTER JOIN PS_OI_COMMON_VW XLI22 ON XLI22.CODESETNAME = PF.RATE_SELECT AND XLI22.CODESETGROUPNAME ='RATE_SELECT' LEFT OUTER JOIN PS_OI_COMMON_VW XLI23 ON XLI23.CODESETNAME = PF.RETAIN_HISTORY AND XLI23.CODESETGROUPNAME ='RETAIN_HISTORY' UNION SELECT '-' , ' ' , '-' , 'A' ,0 , 'N' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' ,0 , '-' , '-' , '-' ,0 , '-' , '-' , '-' , '-' , '-' , '-' , %DateIn('1900-01-01') , %DateIn('1900-01-01') , '-' ,0 ,0 ,0 , '-' , '-' , SETID , %DateTimeIn('1900-01-01 00.00.00.000000') , '-' , '-' , '-' , '-' , '-' , '-' , '-' ,0 , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' ,0 , '-' , '-' , '-' , '-' , '-' , %DateIn('1900-01-01') , %DateIn('1900-01-01') , %DateIn('1900-01-01') , %DateIn('1900-01-01') , %DateIn('1900-01-01') , %DateIn('1900-01-01') , %DateIn('1900-01-01') , %DateIn('1900-01-01') , %DateIn('1900-01-01') , %DateIn('1900-01-01') ,0 , '-' , '-' , '-' , '-' , '-' , '-' ,0 , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , %DateTimeIn('1900-01-01 00.00.00.000000') , '-' , '-' , '-' , '-' , '-' , '-' ,0 ,0 , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' FROM PS_SETID_TBL UNION SELECT '-' , ' ' , '-' , 'A' ,0 , 'N' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' ,0 , '-' , '-' , '-' ,0 , '-' , '-' , '-' , '-' , '-' , '-' , %DateIn('1900-01-01') , %DateIn('1900-01-01') , '-' ,0 ,0 ,0 , '-' , '-' , ' ' , %DateTimeIn('1900-01-01 00.00.00.000000') , '-' , '-' , '-' , '-' , '-' , '-' , '-' ,0 , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' ,0 , '-' , '-' , '-' , '-' , '-' , %DateIn('1900-01-01') , %DateIn('1900-01-01') , %DateIn('1900-01-01') , %DateIn('1900-01-01') , %DateIn('1900-01-01') , %DateIn('1900-01-01') , %DateIn('1900-01-01') , %DateIn('1900-01-01') , %DateIn('1900-01-01') , %DateIn('1900-01-01') ,0 , '-' , '-' , '-' , '-' , '-' , '-' ,0 , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , %DateTimeIn('1900-01-01 00.00.00.000000') , '-' , '-' , '-' , '-' , '-' , '-' ,0 ,0 , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' , '-' FROM PS_INSTALLATION

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

2 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

3 DESCR Character(30) VARCHAR2(30) NOT NULL Description

4 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

5 LAST_ACTIVITY_ID Number(8,0) INTEGER NOT NULL Last Actvity ID

6 IN_USE_SW Character(1) VARCHAR2(1) NOT NULL Table in use switch

7 INTEGRATION_TMPL Character(15) VARCHAR2(15) NOT NULL Integration

8 IT_DESCR Character(30) VARCHAR2(30) NOT NULL Integration Template Desc

9 PROJECT_TYPE Character(5) VARCHAR2(5) NOT NULL Project Type
A=Activity
G=Grant
H=Phase
P=Project
S=Segment

10 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

11 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification

12 PROFILE_ID Character(10) VARCHAR2(10) NOT NULL Asset Profile ID

13 SYS_SRC_DESC Character(30) VARCHAR2(30) NOT NULL System Source Description

14 TEMPLATE_ID Character(30) VARCHAR2(30) NOT NULL Project Template

15 TEMPLATE_SW Character(1) VARCHAR2(1) NOT NULL Allows the user to indicate whether a given bank transfer transaction should be designated as a

16 AFUDC_PROJ_SW Character(1) VARCHAR2(1) NOT NULL Allow Interest Calculation

17 TARGET_PROJ_SW Character(1) VARCHAR2(1) NOT NULL Allocation Target

18 SALES_TAX_PROJ_SW Character(1) VARCHAR2(1) NOT NULL Allow Sales Tax Calculation

19 DOCKET_NUMBER Character(15) VARCHAR2(15) NOT NULL Docket Number

20 PROJECT_FUNCTION Character(10) VARCHAR2(10) NOT NULL Project Function

21 LAST_CRITERIA_ID Number(8,0) INTEGER NOT NULL Last Criteria ID

22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

23 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.

24 CURR_EFF_DESC Character(30) VARCHAR2(30) NOT NULL Current EffDate Description

25 PERCENT_COMPLETE Number(6,2) DECIMAL(5,2) NOT NULL % Complete

26 PC_ACT_DESC Character(30) VARCHAR2(30) NOT NULL PC Activities Description

27 PROJECT_USER1 Character(10) VARCHAR2(10) NOT NULL Project User 1

28 PROJECT_USER2 Character(10) VARCHAR2(10) NOT NULL Project User 2

29 PROJECT_USER3 Character(10) VARCHAR2(10) NOT NULL Project User 3

30 PROJECT_USER4 Character(10) VARCHAR2(10) NOT NULL Project User 4

31 PROJECT_USER5 Character(10) VARCHAR2(10) NOT NULL Project User 5

32 PROJECT_USER_DT1 Date(10) DATE Date 1

33 PROJECT_USER_DT2 Date(10) DATE Date 2

34 PC_USER_CURRENCY Character(3) VARCHAR2(3) NOT NULL User Currency

35 PROJECT_USERAMT1 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 1

36 PROJECT_USERAMT2 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 2

37 PROJECT_USERAMT3 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 3

38 AN_GRP_ACTV_BUD Character(5) VARCHAR2(5) NOT NULL Budget Analysis Group

39 AN_GRP_TOT_COSTS Character(5) VARCHAR2(5) NOT NULL Cost Analysis Group

40 SETID Character(5) VARCHAR2(5) NOT NULL SetID

41 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.

42 PC_MSP_USR1 Character(10) VARCHAR2(10) NOT NULL Microsoft User Define1

43 PC_MSP_USR2 Character(10) VARCHAR2(10) NOT NULL Microsoft User Define2

44 PC_MSP_PROJ_ID Character(22) VARCHAR2(22) NOT NULL Unique MSP Project ID

45 PC_REV_ACTIVITY Character(15) VARCHAR2(15) NOT NULL Revenue Activity

46 REV_ACT_DESCR Character(30) VARCHAR2(30) NOT NULL Reveue Activity Description

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

48 ET_DESC Character(30) VARCHAR2(30) NOT NULL Enforce Type Description

49 TOLERANCE Signed Number(13,8) DECIMAL(11,8) NOT NULL Tolerance Percent

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.

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_GS_DESC Character(30) VARCHAR2(30) NOT NULL Project Grant Status Desc

61 GRANT_FLG_DESC Character(30) VARCHAR2(30) NOT NULL Grants Project Description

62 GM_PRIMARY_FLAG Character(1) VARCHAR2(1) NOT NULL This field is used to indicate a Project as a Primary Project

63 PC_TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Rate Template ID

64 PC_FND_DIST_SW Character(1) VARCHAR2(1) NOT NULL This field is used to indicate the use of Funds Distribution functionality.

65 START_DT Date(10) DATE Start Date

66 END_DT Date(10) DATE End 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 SUMM_PRJ_DESC Character(30) VARCHAR2(30) NOT NULL Summary Project Description

77 PC_CHC_SW Character(1) VARCHAR2(1) NOT NULL Enable Change Control

78 PC_CHC_TEMPLATE Character(30) VARCHAR2(30) NOT NULL Change Control Template

79 CAL_SW_DESC Character(30) VARCHAR2(30) NOT NULL CAL Description

80 PRJ_DEF_DESC Character(30) VARCHAR2(30) NOT NULL Project Definition Description

81 ACT_DEF_DESC Character(30) VARCHAR2(30) NOT NULL Account Default Descr

82 PC_HOURS_PER_DAY Number(2,0) SMALLINT NOT NULL Hours per Day

83 CALC_MET_DESC Character(30) VARCHAR2(30) NOT NULL Calculation metric description

84 SUM_MET_DESC Character(30) VARCHAR2(30) NOT NULL Summary Method Description

85 AUT_REV_DESC Character(30) VARCHAR2(30) NOT NULL Unit of measure description

86 FOR_AUT_DESC Character(30) VARCHAR2(30) NOT NULL Forecast Approval

87 FOR_LVL_DESC Character(30) VARCHAR2(30) NOT NULL Forecast Level Description

88 FOR_RAT_DESC Character(30) VARCHAR2(30) NOT NULL Forecast Rate Description

89 FOR_SRC_DESC Character(30) VARCHAR2(30) NOT NULL Forecase Source Description

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_SCH_DESC Character(30) VARCHAR2(30) NOT NULL PGM Schedule Method Desc

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.

95 CONSTRAINT_DT_FLG Character(1) VARCHAR2(1) NOT NULL Always Honor Constraint Dates

96 CHG_LVL_DESC Character(30) VARCHAR2(30) NOT NULL Project Changing Level Desc

97 CHG_LVLTR_DESC Character(30) VARCHAR2(30) NOT NULL Project Changing Level TR

98 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.

99 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.

100 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

101 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

102 TEM_TYP_DESC Character(30) VARCHAR2(30) NOT NULL Template Type Description

103 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.

104 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.

105 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.

106 FNA_REQUESTED Character(1) VARCHAR2(1) NOT NULL Used for Grants type projects only. A flag to indicate whether FNA is requested.

107 MANAGED_BY_WO Character(1) VARCHAR2(1) NOT NULL Indicates whether a project is Work Order Managed.
N=No
Y=Yes

108 RELEASE Character(15) VARCHAR2(15) NOT NULL Release - Carries Release Information driven by the BUSINESS_UNIT

109 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.

110 APPLICATION_AREA Character(10) VARCHAR2(10) NOT NULL The general area in which an application belongs. Examples: "Financials", "Human Resources", etc.

111 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.

112 RAT_SEL_DESC Character(30) VARCHAR2(30) NOT NULL Rate Selection Description

113 PC_REV_BUD_AN_GRP Character(5) VARCHAR2(5) NOT NULL Revenue budget analysis group

114 AN_GRP_TOT_REV Character(5) VARCHAR2(5) NOT NULL Cost Analysis Group

115 AN_GRP_EAC Character(5) VARCHAR2(5) NOT NULL Analysis group representing the Estimate at Completion (a.k.a. Forecast).

116 RET_HIS_DESC Character(30) VARCHAR2(30) NOT NULL Retain History Description

117 AN_GRP_FREV Character(5) VARCHAR2(5) NOT NULL Forecast Revenue analysis group - contains all the analysis types that make up Forecast Revenue.

118 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.

119 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.

120 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.

121 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.

122 ONE_TARGET_SW Character(1) VARCHAR2(1) NOT NULL Group target definitions
N=No
Y=Yes

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
2	PROJECT_ID	Character(15)	VARCHAR2(15) NOT NULL	Project Id ChartField
3	DESCR	Character(30)	VARCHAR2(30) NOT NULL	Description
4	EFF_STATUS	Character(1)	VARCHAR2(1) NOT NULL	Effective Status A=Active I=Inactive
5	LAST_ACTIVITY_ID	Number(8,0)	INTEGER NOT NULL	Last Actvity ID
6	IN_USE_SW	Character(1)	VARCHAR2(1) NOT NULL	Table in use switch
7	INTEGRATION_TMPL	Character(15)	VARCHAR2(15) NOT NULL	Integration
8	IT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Integration Template Desc
9	PROJECT_TYPE	Character(5)	VARCHAR2(5) NOT NULL	Project Type A=Activity G=Grant H=Phase P=Project S=Segment
10	BUSINESS_UNIT_AM	Character(5)	VARCHAR2(5) NOT NULL	AM Business Unit
11	ASSET_ID	Character(12)	VARCHAR2(12) NOT NULL	Asset Identification
12	PROFILE_ID	Character(10)	VARCHAR2(10) NOT NULL	Asset Profile ID
13	SYS_SRC_DESC	Character(30)	VARCHAR2(30) NOT NULL	System Source Description
14	TEMPLATE_ID	Character(30)	VARCHAR2(30) NOT NULL	Project Template
15	TEMPLATE_SW	Character(1)	VARCHAR2(1) NOT NULL	Allows the user to indicate whether a given bank transfer transaction should be designated as a
16	AFUDC_PROJ_SW	Character(1)	VARCHAR2(1) NOT NULL	Allow Interest Calculation
17	TARGET_PROJ_SW	Character(1)	VARCHAR2(1) NOT NULL	Allocation Target
18	SALES_TAX_PROJ_SW	Character(1)	VARCHAR2(1) NOT NULL	Allow Sales Tax Calculation
19	DOCKET_NUMBER	Character(15)	VARCHAR2(15) NOT NULL	Docket Number
20	PROJECT_FUNCTION	Character(10)	VARCHAR2(10) NOT NULL	Project Function
21	LAST_CRITERIA_ID	Number(8,0)	INTEGER NOT NULL	Last Criteria ID
22	CURRENCY_CD	Character(3)	VARCHAR2(3) NOT NULL	Currency Code
23	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.
24	CURR_EFF_DESC	Character(30)	VARCHAR2(30) NOT NULL	Current EffDate Description
25	PERCENT_COMPLETE	Number(6,2)	DECIMAL(5,2) NOT NULL	% Complete
26	PC_ACT_DESC	Character(30)	VARCHAR2(30) NOT NULL	PC Activities Description
27	PROJECT_USER1	Character(10)	VARCHAR2(10) NOT NULL	Project User 1
28	PROJECT_USER2	Character(10)	VARCHAR2(10) NOT NULL	Project User 2
29	PROJECT_USER3	Character(10)	VARCHAR2(10) NOT NULL	Project User 3
30	PROJECT_USER4	Character(10)	VARCHAR2(10) NOT NULL	Project User 4
31	PROJECT_USER5	Character(10)	VARCHAR2(10) NOT NULL	Project User 5
32	PROJECT_USER_DT1	Date(10)	DATE	Date 1
33	PROJECT_USER_DT2	Date(10)	DATE	Date 2
34	PC_USER_CURRENCY	Character(3)	VARCHAR2(3) NOT NULL	User Currency
35	PROJECT_USERAMT1	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Amount 1
36	PROJECT_USERAMT2	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Amount 2
37	PROJECT_USERAMT3	Signed Number(17,2)	DECIMAL(15,2) NOT NULL	Amount 3
38	AN_GRP_ACTV_BUD	Character(5)	VARCHAR2(5) NOT NULL	Budget Analysis Group
39	AN_GRP_TOT_COSTS	Character(5)	VARCHAR2(5) NOT NULL	Cost Analysis Group
40	SETID	Character(5)	VARCHAR2(5) NOT NULL	SetID
41	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.
42	PC_MSP_USR1	Character(10)	VARCHAR2(10) NOT NULL	Microsoft User Define1
43	PC_MSP_USR2	Character(10)	VARCHAR2(10) NOT NULL	Microsoft User Define2
44	PC_MSP_PROJ_ID	Character(22)	VARCHAR2(22) NOT NULL	Unique MSP Project ID
45	PC_REV_ACTIVITY	Character(15)	VARCHAR2(15) NOT NULL	Revenue Activity
46	REV_ACT_DESCR	Character(30)	VARCHAR2(30) NOT NULL	Reveue Activity Description
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
48	ET_DESC	Character(30)	VARCHAR2(30) NOT NULL	Enforce Type Description
49	TOLERANCE	Signed Number(13,8)	DECIMAL(11,8) NOT NULL	Tolerance Percent
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.
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_GS_DESC	Character(30)	VARCHAR2(30) NOT NULL	Project Grant Status Desc
61	GRANT_FLG_DESC	Character(30)	VARCHAR2(30) NOT NULL	Grants Project Description
62	GM_PRIMARY_FLAG	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate a Project as a Primary Project
63	PC_TEMPLATE_ID	Character(15)	VARCHAR2(15) NOT NULL	Rate Template ID
64	PC_FND_DIST_SW	Character(1)	VARCHAR2(1) NOT NULL	This field is used to indicate the use of Funds Distribution functionality.
65	START_DT	Date(10)	DATE	Start Date
66	END_DT	Date(10)	DATE	End 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	SUMM_PRJ_DESC	Character(30)	VARCHAR2(30) NOT NULL	Summary Project Description
77	PC_CHC_SW	Character(1)	VARCHAR2(1) NOT NULL	Enable Change Control
78	PC_CHC_TEMPLATE	Character(30)	VARCHAR2(30) NOT NULL	Change Control Template
79	CAL_SW_DESC	Character(30)	VARCHAR2(30) NOT NULL	CAL Description
80	PRJ_DEF_DESC	Character(30)	VARCHAR2(30) NOT NULL	Project Definition Description
81	ACT_DEF_DESC	Character(30)	VARCHAR2(30) NOT NULL	Account Default Descr
82	PC_HOURS_PER_DAY	Number(2,0)	SMALLINT NOT NULL	Hours per Day
83	CALC_MET_DESC	Character(30)	VARCHAR2(30) NOT NULL	Calculation metric description
84	SUM_MET_DESC	Character(30)	VARCHAR2(30) NOT NULL	Summary Method Description
85	AUT_REV_DESC	Character(30)	VARCHAR2(30) NOT NULL	Unit of measure description
86	FOR_AUT_DESC	Character(30)	VARCHAR2(30) NOT NULL	Forecast Approval
87	FOR_LVL_DESC	Character(30)	VARCHAR2(30) NOT NULL	Forecast Level Description
88	FOR_RAT_DESC	Character(30)	VARCHAR2(30) NOT NULL	Forecast Rate Description
89	FOR_SRC_DESC	Character(30)	VARCHAR2(30) NOT NULL	Forecase Source Description
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_SCH_DESC	Character(30)	VARCHAR2(30) NOT NULL	PGM Schedule Method Desc
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.
95	CONSTRAINT_DT_FLG	Character(1)	VARCHAR2(1) NOT NULL	Always Honor Constraint Dates
96	CHG_LVL_DESC	Character(30)	VARCHAR2(30) NOT NULL	Project Changing Level Desc
97	CHG_LVLTR_DESC	Character(30)	VARCHAR2(30) NOT NULL	Project Changing Level TR
98	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.
99	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.
100	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
101	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
102	TEM_TYP_DESC	Character(30)	VARCHAR2(30) NOT NULL	Template Type Description
103	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.
104	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.
105	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.
106	FNA_REQUESTED	Character(1)	VARCHAR2(1) NOT NULL	Used for Grants type projects only. A flag to indicate whether FNA is requested.
107	MANAGED_BY_WO	Character(1)	VARCHAR2(1) NOT NULL	Indicates whether a project is Work Order Managed. N=No Y=Yes
108	RELEASE	Character(15)	VARCHAR2(15) NOT NULL	Release - Carries Release Information driven by the BUSINESS_UNIT
109	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.
110	APPLICATION_AREA	Character(10)	VARCHAR2(10) NOT NULL	The general area in which an application belongs. Examples: "Financials", "Human Resources", etc.
111	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.
112	RAT_SEL_DESC	Character(30)	VARCHAR2(30) NOT NULL	Rate Selection Description
113	PC_REV_BUD_AN_GRP	Character(5)	VARCHAR2(5) NOT NULL	Revenue budget analysis group
114	AN_GRP_TOT_REV	Character(5)	VARCHAR2(5) NOT NULL	Cost Analysis Group
115	AN_GRP_EAC	Character(5)	VARCHAR2(5) NOT NULL	Analysis group representing the Estimate at Completion (a.k.a. Forecast).
116	RET_HIS_DESC	Character(30)	VARCHAR2(30) NOT NULL	Retain History Description
117	AN_GRP_FREV	Character(5)	VARCHAR2(5) NOT NULL	Forecast Revenue analysis group - contains all the analysis types that make up Forecast Revenue.
118	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.
119	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.
120	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.
121	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.
122	ONE_TARGET_SW	Character(1)	VARCHAR2(1) NOT NULL	Group target definitions N=No Y=Yes