PC_CPY_ACTY_TAO

(SQL Table)
Index Back

Tmpl Copy Temp tbl Activity

# 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

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

Default Value: OPR_DEF_TBL_PC.PROJECT_ID

3 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
4 PC_CPY_UNIQUEID Character(15) VARCHAR2(15) NOT NULL Copy Unique ID
5 EFF_STATUS Character(1) VARCHAR2(1) NOT NULL Effective Status
A=Active
I=Inactive

Default Value: A

6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
7 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
8 WBS_ID Character(100) VARCHAR2(100) NOT NULL WBS ID
9 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

10 ACT_TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Activity Template
11 ACT_TEMPLATE_SW Character(1) VARCHAR2(1) NOT NULL Use Activity as Template

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: PROJECT.AFUDC_PROJ_SW

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

Y/N Table Edit

Default Value: N

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

Y/N Table Edit

Default Value: N

17 PERCENT_COMPLETE Number(6,2) DECIMAL(5,2) NOT NULL % Complete
18 START_DT Date(10) DATE Start Date
19 END_DT Date(10) DATE End Date
20 EARLY_START_DT Date(10) DATE Early Start Date
21 LATE_START_DT Date(10) DATE Late Start Date
22 ACTUAL_START_DT Date(10) DATE Actual Start Date
23 EARLY_FINISH_DT Date(10) DATE Early Finish Date
24 LATE_FINISH_DT Date(10) DATE Late Finish Date
25 ACTUAL_FINISH_DT Date(10) DATE Actual Finish Date
26 BASELINE_FINISH_DT Date(10) DATE Baseline Finish Date
27 BASELINE_START_DT Date(10) DATE Baseline Start Date
28 BCWP Number(3,0) SMALLINT NOT NULL BCWP - Worked Performed
29 BCWS Number(3,0) SMALLINT NOT NULL BCWS Work Scheduled
30 ACT_TYPE_SCH Character(5) VARCHAR2(5) NOT NULL Schedule Activity Type
31 INTEGRATION_ID Character(40) VARCHAR2(40) NOT NULL 3rd Prty Integr Identifier
32 INTEGRATION_TRG Character(3) VARCHAR2(3) NOT NULL Integration Trigger
33 INTEGRATION_ANTYPE Character(5) VARCHAR2(5) NOT NULL Integration AnType Override
34 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.
35 DRAWING_NAME Character(8) VARCHAR2(8) NOT NULL Drawing Name
36 ACTIVITY_USER1 Character(10) VARCHAR2(10) NOT NULL User 1
37 ACTIVITY_USER2 Character(10) VARCHAR2(10) NOT NULL User 2
38 ACTIVITY_USER3 Character(10) VARCHAR2(10) NOT NULL User 3
39 ACTIVITY_USER4 Character(10) VARCHAR2(10) NOT NULL User 4
40 ACTIVITY_USER5 Character(10) VARCHAR2(10) NOT NULL User 5
41 PC_ACT_USER_DT1 Date(10) DATE Date 1
42 PC_ACT_USER_DT2 Date(10) DATE Date 2
43 PC_USER_CURRENCY Character(3) VARCHAR2(3) NOT NULL User Currency
44 PC_ACT_USERAMT1 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 1
45 PC_ACT_USERAMT2 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 2
46 PC_ACT_USERAMT3 Signed Number(17,2) DECIMAL(15,2) NOT NULL Amount 3
47 PC_MSP_UNIQUE_ID Character(22) VARCHAR2(22) NOT NULL Proj Act Unique ID
48 PC_MILESTONE_FLG Character(1) VARCHAR2(1) NOT NULL Milestone Activity
N=No
Y=Yes

Y/N Table Edit

49 IN_USE_FLAG Character(1) VARCHAR2(1) NOT NULL Row in use flag
50 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.
51 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
52 PC_TEMPLATE_ID Character(15) VARCHAR2(15) NOT NULL Rate Template ID
53 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
54 SUMMARY_ACT Character(1) VARCHAR2(1) NOT NULL Flag to indicate whether an activity is summary or detail.
N=Detail Activity
Y=Summary Activity
55 PC_DURATION Number(11,2) DECIMAL(10,2) NOT NULL Duration
56 PC_CHC_ACT_SW Character(1) VARCHAR2(1) NOT NULL Enable Change Control
57 FMS_DTTM_STAMP DateTime(26) TIMESTAMP Specifies the date and time of the original entry.
58 FMS_OPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the original entry.
59 FMS_LASTUPDDTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry.
60 FMS_LASTUPDOPRID Character(30) VARCHAR2(30) NOT NULL Specifies the User ID which made the last update to an entry.
61 LEVEL1 Number(5,0) INTEGER NOT NULL Level 1
62 LEVEL2 Number(5,0) INTEGER NOT NULL Level 2
63 LEVEL3 Number(5,0) INTEGER NOT NULL Level 3
64 LEVEL4 Number(5,0) INTEGER NOT NULL Level 4
65 LEVEL5 Number(5,0) INTEGER NOT NULL Level 5
66 LEVEL6 Number(5,0) INTEGER NOT NULL Level 6
67 LEVEL7 Number(5,0) INTEGER NOT NULL Level 7
68 LEVEL8 Number(5,0) INTEGER NOT NULL Level 8
69 LEVEL9 Number(5,0) INTEGER NOT NULL Level 9
70 LEVEL10 Number(5,0) INTEGER NOT NULL Level 10
71 LEVEL11 Number(5,0) INTEGER NOT NULL Level 11
72 LEVEL12 Number(5,0) INTEGER NOT NULL Level 12
73 LEVEL13 Number(5,0) INTEGER NOT NULL Level 13
74 LEVEL14 Number(5,0) INTEGER NOT NULL Level 14
75 LEVEL15 Number(5,0) INTEGER NOT NULL Level 15
76 LEVEL16 Number(5,0) INTEGER NOT NULL Level 16
77 LEVEL17 Number(5,0) INTEGER NOT NULL Level 17
78 LEVEL18 Number(5,0) INTEGER NOT NULL Level 18
79 LEVEL19 Number(5,0) INTEGER NOT NULL Level 19
80 LEVEL20 Number(5,0) INTEGER NOT NULL Level 20
81 LEVEL21 Number(5,0) INTEGER NOT NULL Level 21
82 LEVEL22 Number(5,0) INTEGER NOT NULL Level 22
83 LEVEL23 Number(5,0) INTEGER NOT NULL Level 23
84 LEVEL24 Number(5,0) INTEGER NOT NULL Level 24
85 LEVEL25 Number(5,0) INTEGER NOT NULL Level 25
86 LEVEL26 Number(5,0) INTEGER NOT NULL Level 26
87 LEVEL_NUM Number(3,0) SMALLINT NOT NULL Level
88 ROW_NUMBER_5 Number(5,0) INTEGER NOT NULL Row Number
89 DEADLINE_DT Date(10) DATE Deadline Date
90 CONSTRAINT_DT Date(10) DATE Constraint Date
91 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
92 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

93 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

94 BILL_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Bill Amount
95 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
96 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

97 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

98 ASSGND_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL Assigned Work
99 ACTUAL_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL Actual Work
100 REMAINING_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL New Remaining work in hours
101 BASELINE_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL Baseline Work
102 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
103 DEFAULT_CURR_SW Character(1) VARCHAR2(1) NOT NULL Default Currency

Default Value: Y

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

Y/N Table Edit

Default Value: Y