PROJ_ACT_CA_VW

(SQL View)
 Index Back

Project Activities

To be used on Console

SELECT CONTRACT_NUM , CONTRACT_LINE_NUM , BUSINESS_UNIT , ACT.PROJECT_ID , ACT.ACTIVITY_ID , EFF_STATUS , DESCR , ACTIVITY_TYPE , WBS_ID , SYSTEM_SOURCE , ACT_TEMPLATE_ID , ACT_TEMPLATE_SW , WORK_ORDER_ID , WORK_ORDER_DTL_ID , AFUDC_ACT_SW , TARGET_ACT_SW , SALES_TAX_ACT_SW , PERCENT_COMPLETE , START_DT , END_DT , EARLY_START_DT , LATE_START_DT , ACTUAL_START_DT , EARLY_FINISH_DT , LATE_FINISH_DT , ACTUAL_FINISH_DT , BASELINE_FINISH_DT , BASELINE_START_DT , BCWP , BCWS , ACT_TYPE_SCH , INTEGRATION_ID , INTEGRATION_TRG , INTEGRATION_ANTYPE , DTTM_STAMP , DRAWING_NAME , ACTIVITY_USER1 , ACTIVITY_USER2 , ACTIVITY_USER3 , ACTIVITY_USER4 , ACTIVITY_USER5 , PC_ACT_USER_DT1 , PC_ACT_USER_DT2 , PC_USER_CURRENCY , PC_ACT_USERAMT1 , PC_ACT_USERAMT2 , PC_ACT_USERAMT3 , PC_MSP_UNIQUE_ID , PC_MILESTONE_FLG , IN_USE_FLAG , PC_SCH_FIELD1 , PC_SCH_FIELD2 , PC_SCH_FIELD3 , PC_SCH_FIELD4 , PC_SCH_FIELD5 , PC_SCH_FIELD6 , PC_SCH_FIELD7 , WAIVED_FA_CLC_MTHD , ENFORCE , SUMMARY_ACT , PC_DURATION , PC_CHC_ACT_SW , PGM_SCHED_METHOD , ASSGND_WORK , ACTUAL_WORK , REMAINING_WORK , BASELINE_WORK , COST , DEFAULT_CURR_SW , FMS_DTTM_STAMP , FMS_OPRID , FMS_LASTUPDDTTM , FMS_LASTUPDOPRID , LEVEL1 , LEVEL2 , LEVEL3 , LEVEL4 , LEVEL5 , LEVEL6 , LEVEL7 , LEVEL8 , LEVEL9 , LEVEL10 , LEVEL11 , LEVEL12 , LEVEL13 , LEVEL14 , LEVEL15 , LEVEL16 , LEVEL17 , LEVEL18 , LEVEL19 , LEVEL20 , LEVEL21 , LEVEL22 , LEVEL23 , LEVEL24 , LEVEL25 , LEVEL26 , LEVEL_NUM , ROW_NUMBER_5 , DEADLINE_DT , CONSTRAINT_DT , CONSTRAINT_TYPE , COSTING_ACT_SW , PC_ACT_OWNER , BILL_AMT , CURRENCY_CD , PC_ACT_DEF_CALC_MT , PARTICIPATING FROM PS_CA_DETAIL_PROJ DTL , PS_PROJ_ACTIVITY ACT WHERE ACT.BUSINESS_UNIT = DTL.BUSINESS_UNIT_PC AND ACT.PROJECT_ID = DTL.PROJECT_ID AND ACT.ACTIVITY_ID = DTL.ACTIVITY_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

Default Value: OPR_DEF_TBL_PC.PROJECT_ID

Prompt Table: SP_PROJ_NONVW

5 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: PC_TYPE_ACT_VW

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

Default Value: A

7 DESCR Character(30) VARCHAR2(30) NOT NULL Description
8 ACTIVITY_TYPE Character(5) VARCHAR2(5) NOT NULL Activity Type
A=Activity Type
E=Entry Type
G=Group Type/Origin
O=Activity Type/Origin
R=Entry Type/Reason

Prompt Table: PROJ_ACT_TBL

9 WBS_ID Character(100) VARCHAR2(100) NOT NULL WBS ID

Prompt Table: PC_WBS_DTL_VW

10 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

11 ACT_TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Activity Template

Prompt Table: PROJ_ACT_TMP_VW

12 ACT_TEMPLATE_SW Character(1) VARCHAR2(1) NOT NULL Use Activity as Template

Y/N Table Edit

Default Value: N

13 WORK_ORDER_ID Character(15) VARCHAR2(15) NOT NULL Work Order ID
14 WORK_ORDER_DTL_ID Character(15) VARCHAR2(15) NOT NULL Work Order Detail
15 AFUDC_ACT_SW Character(1) VARCHAR2(1) NOT NULL Allow AFUDC Calculation

Y/N Table Edit

Default Value: PROJECT.AFUDC_PROJ_SW

16 TARGET_ACT_SW Character(1) VARCHAR2(1) NOT NULL Allow Node to be target

Y/N Table Edit

Default Value: N

17 SALES_TAX_ACT_SW Character(1) VARCHAR2(1) NOT NULL Allow Sales Tax Calculation

Y/N Table Edit

Default Value: N

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

Default Value: 0

19 START_DT Date(10) DATE NOT NULL Start Date

Default Value: PROJECT.START_DT

20 END_DT Date(10) DATE NOT NULL End Date
21 EARLY_START_DT Date(10) DATE Early Start Date
22 LATE_START_DT Date(10) DATE Late Start Date
23 ACTUAL_START_DT Date(10) DATE Actual Start Date
24 EARLY_FINISH_DT Date(10) DATE Early Finish Date
25 LATE_FINISH_DT Date(10) DATE Late Finish Date
26 ACTUAL_FINISH_DT Date(10) DATE Actual Finish Date
27 BASELINE_FINISH_DT Date(10) DATE Baseline Finish Date
28 BASELINE_START_DT Date(10) DATE Baseline Start Date
29 BCWP Number(3,0) SMALLINT NOT NULL BCWP - Worked Performed
30 BCWS Number(3,0) SMALLINT NOT NULL BCWS Work Scheduled
31 ACT_TYPE_SCH Character(5) VARCHAR2(5) NOT NULL Schedule Activity Type

Prompt Table: PC_ACT_TYPE_SCH

32 INTEGRATION_ID Character(40) VARCHAR2(40) NOT NULL 3rd Prty Integr Identifier
33 INTEGRATION_TRG Character(3) VARCHAR2(3) NOT NULL Integration Trigger
34 INTEGRATION_ANTYPE Character(5) VARCHAR2(5) NOT NULL Integration AnType Override
35 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.
36 DRAWING_NAME Character(8) VARCHAR2(8) NOT NULL Drawing Name
37 ACTIVITY_USER1 Character(10) VARCHAR2(10) NOT NULL User 1
38 ACTIVITY_USER2 Character(10) VARCHAR2(10) NOT NULL User 2
39 ACTIVITY_USER3 Character(10) VARCHAR2(10) NOT NULL User 3
40 ACTIVITY_USER4 Character(10) VARCHAR2(10) NOT NULL User 4
41 ACTIVITY_USER5 Character(10) VARCHAR2(10) NOT NULL User 5
42 PC_ACT_USER_DT1 Date(10) DATE Date 1
43 PC_ACT_USER_DT2 Date(10) DATE Date 2
44 PC_USER_CURRENCY Character(3) VARCHAR2(3) NOT NULL User Currency

Prompt Table: CURRENCY_CD_TBL

45 PC_ACT_USERAMT1 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 1
46 PC_ACT_USERAMT2 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 2
47 PC_ACT_USERAMT3 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 3
48 PC_MSP_UNIQUE_ID Character(22) VARCHAR2(22) NOT NULL Proj Act Unique ID
49 PC_MILESTONE_FLG Character(1) VARCHAR2(1) NOT NULL Milestone Activity
N=No
Y=Yes

Y/N Table Edit

50 IN_USE_FLAG Character(1) VARCHAR2(1) NOT NULL Row in use flag
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 WAIVED_FA_CLC_MTHD Character(1) VARCHAR2(1) NOT NULL This field allows a user to defined whether waived facilities and administrative costs are determined by subtracting the budgeted/funded amount from the institution amount or from the sponsor amount.
I=Institution Minus Funded
S=Sponsor Minus Funded

Default Value: BUS_UNIT_OPT_PC.WAIVED_FA_CLC_MTHD

59 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: N

60 SUMMARY_ACT Character(1) VARCHAR2(1) NOT NULL Flag to indicate whether an activity is summary or detail.
N=Detail Activity
Y=Summary Activity

Default Value: N

61 PC_DURATION Number(11,2) DECIMAL(10,2) NOT NULL Duration
62 PC_CHC_ACT_SW Character(1) VARCHAR2(1) NOT NULL Enable Change Control

Y/N Table Edit

Default Value: PROJECT.PC_CHC_SW

63 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: PROJECT.PGM_SCHED_METHOD

64 ASSGND_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL Assigned Work
65 ACTUAL_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL Actual Work
66 REMAINING_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL New Remaining work in hours
67 BASELINE_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL Baseline Work
68 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
69 DEFAULT_CURR_SW Character(1) VARCHAR2(1) NOT NULL Default Currency

Default Value: Y

70 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
71 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
72 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
73 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.
74 LEVEL1 Number(5,0) INTEGER NOT NULL Level 1
75 LEVEL2 Number(5,0) INTEGER NOT NULL Level 2
76 LEVEL3 Number(5,0) INTEGER NOT NULL Level 3
77 LEVEL4 Number(5,0) INTEGER NOT NULL Level 4
78 LEVEL5 Number(5,0) INTEGER NOT NULL Level 5
79 LEVEL6 Number(5,0) INTEGER NOT NULL Level 6
80 LEVEL7 Number(5,0) INTEGER NOT NULL Level 7
81 LEVEL8 Number(5,0) INTEGER NOT NULL Level 8
82 LEVEL9 Number(5,0) INTEGER NOT NULL Level 9
83 LEVEL10 Number(5,0) INTEGER NOT NULL Level 10
84 LEVEL11 Number(5,0) INTEGER NOT NULL Level 11
85 LEVEL12 Number(5,0) INTEGER NOT NULL Level 12
86 LEVEL13 Number(5,0) INTEGER NOT NULL Level 13
87 LEVEL14 Number(5,0) INTEGER NOT NULL Level 14
88 LEVEL15 Number(5,0) INTEGER NOT NULL Level 15
89 LEVEL16 Number(5,0) INTEGER NOT NULL Level 16
90 LEVEL17 Number(5,0) INTEGER NOT NULL Level 17
91 LEVEL18 Number(5,0) INTEGER NOT NULL Level 18
92 LEVEL19 Number(5,0) INTEGER NOT NULL Level 19
93 LEVEL20 Number(5,0) INTEGER NOT NULL Level 20
94 LEVEL21 Number(5,0) INTEGER NOT NULL Level 21
95 LEVEL22 Number(5,0) INTEGER NOT NULL Level 22
96 LEVEL23 Number(5,0) INTEGER NOT NULL Level 23
97 LEVEL24 Number(5,0) INTEGER NOT NULL Level 24
98 LEVEL25 Number(5,0) INTEGER NOT NULL Level 25
99 LEVEL26 Number(5,0) INTEGER NOT NULL Level 26
100 LEVEL_NUM Number(3,0) SMALLINT NOT NULL Level

Default Value: 1

101 ROW_NUMBER_5 Number(5,0) INTEGER NOT NULL Row Number
102 DEADLINE_DT Date(10) DATE Deadline Date
103 CONSTRAINT_DT Date(10) DATE Constraint Date
104 CONSTRAINT_TYPE Character(4) VARCHAR2(4) NOT NULL Constraint Type
ALAP=As Late As Possible
ASAP=As Soon As Possible
ENET=End No Earlier Than
ENLT=End No Later Than
MEO=Must End On
MSO=Must Start On
SNET=Start No Earlier Than
SNLT=Start No Later Than
105 COSTING_ACT_SW Character(1) VARCHAR2(1) NOT NULL Activity Costing Switch - determines whether an activity is available for charging. 'Y' = charging is allowed; 'N' = charging is not allowed.

Y/N Table Edit

106 PC_ACT_OWNER Character(11) VARCHAR2(11) NOT NULL Activity Owner - The employee id of the individual who is responsible for the execution of an activity or a group of activities.

Prompt Table: PC_TEAM_PROM_VW

107 BILL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Bill Amount
108 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: PROJECT.CURRENCY_CD

109 PC_ACT_DEF_CALC_MT Character(1) VARCHAR2(1) NOT NULL Activity Calculation Method
D=Duration
E=End Date
S=Start Date

Default Value: PROJECT.PC_ACT_DEF_CALC_MT

110 PARTICIPATING Character(1) VARCHAR2(1) NOT NULL Participating

Y/N Table Edit

Default Value: Y