PROJ_ACTIVITY(SQL Table) |
Index Back |
---|---|
Project ActivitiesActivities (also known as Tasks) that make up a Project. Activities may be summary activities or detail activities. Summary activities are only used if the project has a work breakdown structure (wbs) where detail activities may roll up to summary activities. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW |
2 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Default Value: OPR_DEF_TBL_PC.PROJECT_ID Prompt Table: SP_PROJ_NONVW |
3 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PC_TYPE_ACT_VW |
4 | EFF_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Effective Status
A=Active I=Inactive Default Value: A |
5 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
6 | 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 |
7 | WBS_ID | Character(100) | VARCHAR2(100) NOT NULL |
WBS ID
Prompt Table: PC_WBS_DTL_VW |
8 | 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 |
9 | ACT_TEMPLATE_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity Template
Prompt Table: PROJ_ACT_TMP_VW |
10 | ACT_TEMPLATE_SW | Character(1) | VARCHAR2(1) NOT NULL |
Use Activity as Template
Y/N Table Edit Default Value: N |
11 | WORK_ORDER_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
12 | WORK_ORDER_DTL_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Order Detail |
13 | AFUDC_ACT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Allow AFUDC Calculation
Y/N Table Edit Default Value: PROJECT.AFUDC_PROJ_SW |
14 | TARGET_ACT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Allow Node to be target
Y/N Table Edit Default Value: N |
15 | SALES_TAX_ACT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Allow Sales Tax Calculation
Y/N Table Edit Default Value: N |
16 | PERCENT_COMPLETE | Number(6,2) | DECIMAL(5,2) NOT NULL |
% Complete
Default Value: 0 |
17 | START_DT | Date(10) | DATE NOT NULL |
Start Date
Default Value: PROJECT.START_DT |
18 | END_DT | Date(10) | DATE NOT NULL | End Date |
19 | EARLY_START_DT | Date(10) | DATE | Early Start Date |
20 | LATE_START_DT | Date(10) | DATE | Late Start Date |
21 | ACTUAL_START_DT | Date(10) | DATE | Actual Start Date |
22 | EARLY_FINISH_DT | Date(10) | DATE | Early Finish Date |
23 | LATE_FINISH_DT | Date(10) | DATE | Late Finish Date |
24 | ACTUAL_FINISH_DT | Date(10) | DATE | Actual Finish Date |
25 | BASELINE_FINISH_DT | Date(10) | DATE | Baseline Finish Date |
26 | BASELINE_START_DT | Date(10) | DATE | Baseline Start Date |
27 | BCWP | Number(3,0) | SMALLINT NOT NULL | BCWP - Worked Performed |
28 | BCWS | Number(3,0) | SMALLINT NOT NULL | BCWS Work Scheduled |
29 | ACT_TYPE_SCH | Character(5) | VARCHAR2(5) NOT NULL |
Schedule Activity Type
Prompt Table: PC_ACT_TYPE_SCH |
30 | INTEGRATION_ID | Character(40) | VARCHAR2(40) NOT NULL | 3rd Prty Integr Identifier |
31 | INTEGRATION_TRG | Character(3) | VARCHAR2(3) NOT NULL | Integration Trigger |
32 | INTEGRATION_ANTYPE | Character(5) | VARCHAR2(5) NOT NULL | Integration AnType Override |
33 | 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. |
34 | DRAWING_NAME | Character(8) | VARCHAR2(8) NOT NULL | Drawing Name |
35 | ACTIVITY_USER1 | Character(10) | VARCHAR2(10) NOT NULL | User 1 |
36 | ACTIVITY_USER2 | Character(10) | VARCHAR2(10) NOT NULL | User 2 |
37 | ACTIVITY_USER3 | Character(10) | VARCHAR2(10) NOT NULL | User 3 |
38 | ACTIVITY_USER4 | Character(10) | VARCHAR2(10) NOT NULL | User 4 |
39 | ACTIVITY_USER5 | Character(10) | VARCHAR2(10) NOT NULL | User 5 |
40 | PC_ACT_USER_DT1 | Date(10) | DATE | Date 1 |
41 | PC_ACT_USER_DT2 | Date(10) | DATE | Date 2 |
42 | PC_USER_CURRENCY | Character(3) | VARCHAR2(3) NOT NULL |
User Currency
Prompt Table: CURRENCY_CD_TBL |
43 | PC_ACT_USERAMT1 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount 1 |
44 | PC_ACT_USERAMT2 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount 2 |
45 | PC_ACT_USERAMT3 | Signed Number(17,2) | DECIMAL(15,2) NOT NULL | Amount 3 |
46 | PC_MSP_UNIQUE_ID | Character(22) | VARCHAR2(22) NOT NULL | Proj Act Unique ID |
47 | PC_MILESTONE_FLG | Character(1) | VARCHAR2(1) NOT NULL |
Milestone Activity
N=No Y=Yes Y/N Table Edit |
48 | IN_USE_FLAG | Character(1) | VARCHAR2(1) NOT NULL | Row in use flag |
49 | PC_SCH_FIELD1 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
50 | PC_SCH_FIELD2 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
51 | PC_SCH_FIELD3 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
52 | PC_SCH_FIELD4 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
53 | PC_SCH_FIELD5 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
54 | PC_SCH_FIELD6 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
55 | PC_SCH_FIELD7 | Character(40) | VARCHAR2(40) NOT NULL | Generic field used for Projects Third Party Schedule Integration. |
56 | 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 |
57 | 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 |
58 | 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 |
59 | PC_DURATION | Number(11,2) | DECIMAL(10,2) NOT NULL | Duration |
60 | PC_CHC_ACT_SW | Character(1) | VARCHAR2(1) NOT NULL |
Enable Change Control
Y/N Table Edit Default Value: PROJECT.PC_CHC_SW |
61 | 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 |
62 | ASSGND_WORK | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Assigned Work |
63 | ACTUAL_WORK | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Actual Work |
64 | REMAINING_WORK | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | New Remaining work in hours |
65 | BASELINE_WORK | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Baseline Work |
66 | COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Cost |
67 | DEFAULT_CURR_SW | Character(1) | VARCHAR2(1) NOT NULL |
Default Currency
Default Value: Y |
68 | FMS_DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the original entry. |
69 | FMS_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the original entry. |
70 | FMS_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
71 | FMS_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |
72 | LEVEL1 | Number(5,0) | INTEGER NOT NULL | Level 1 |
73 | LEVEL2 | Number(5,0) | INTEGER NOT NULL | Level 2 |
74 | LEVEL3 | Number(5,0) | INTEGER NOT NULL | Level 3 |
75 | LEVEL4 | Number(5,0) | INTEGER NOT NULL | Level 4 |
76 | LEVEL5 | Number(5,0) | INTEGER NOT NULL | Level 5 |
77 | LEVEL6 | Number(5,0) | INTEGER NOT NULL | Level 6 |
78 | LEVEL7 | Number(5,0) | INTEGER NOT NULL | Level 7 |
79 | LEVEL8 | Number(5,0) | INTEGER NOT NULL | Level 8 |
80 | LEVEL9 | Number(5,0) | INTEGER NOT NULL | Level 9 |
81 | LEVEL10 | Number(5,0) | INTEGER NOT NULL | Level 10 |
82 | LEVEL11 | Number(5,0) | INTEGER NOT NULL | Level 11 |
83 | LEVEL12 | Number(5,0) | INTEGER NOT NULL | Level 12 |
84 | LEVEL13 | Number(5,0) | INTEGER NOT NULL | Level 13 |
85 | LEVEL14 | Number(5,0) | INTEGER NOT NULL | Level 14 |
86 | LEVEL15 | Number(5,0) | INTEGER NOT NULL | Level 15 |
87 | LEVEL16 | Number(5,0) | INTEGER NOT NULL | Level 16 |
88 | LEVEL17 | Number(5,0) | INTEGER NOT NULL | Level 17 |
89 | LEVEL18 | Number(5,0) | INTEGER NOT NULL | Level 18 |
90 | LEVEL19 | Number(5,0) | INTEGER NOT NULL | Level 19 |
91 | LEVEL20 | Number(5,0) | INTEGER NOT NULL | Level 20 |
92 | LEVEL21 | Number(5,0) | INTEGER NOT NULL | Level 21 |
93 | LEVEL22 | Number(5,0) | INTEGER NOT NULL | Level 22 |
94 | LEVEL23 | Number(5,0) | INTEGER NOT NULL | Level 23 |
95 | LEVEL24 | Number(5,0) | INTEGER NOT NULL | Level 24 |
96 | LEVEL25 | Number(5,0) | INTEGER NOT NULL | Level 25 |
97 | LEVEL26 | Number(5,0) | INTEGER NOT NULL | Level 26 |
98 | LEVEL_NUM | Number(3,0) | SMALLINT NOT NULL |
Level
Default Value: 1 |
99 | ROW_NUMBER_5 | Number(5,0) | INTEGER NOT NULL | Row Number |
100 | DEADLINE_DT | Date(10) | DATE | Deadline Date |
101 | CONSTRAINT_DT | Date(10) | DATE | Constraint Date |
102 | 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 |
103 | 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 |
104 | 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 |
105 | BILL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bill Amount |
106 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: PROJECT.CURRENCY_CD |
107 | 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 |
108 | PARTICIPATING | Character(1) | VARCHAR2(1) NOT NULL |
Participating
Y/N Table Edit Default Value: Y |
109 | P6_WBS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
A flag, when set to Y(es) indicates that an activity originated from a Primavera WBS.
N=Activity Y=Work Breakdown Structure |