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 |