PROJ_ACT_TEAM(SQL Table) |
Index Back |
---|---|
Project Activity Team MemberProject Activity Team Member (also known as Resource). This may include labor, material or asset resources. 06/01/2004 - PR_FS_B005 changes done with respect to "Estimating Labor PRL/ARL Changes" TDD. |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: PROJECT.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW |
2 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: PROJECT_ALL_VW |
3 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL |
Activity ID
Prompt Table: PROJ_ACTIVITY |
4 | TEAM_MEMBER_CLASS | Character(1) | VARCHAR2(1) NOT NULL |
05/26/2004 - FS
Translate Value "O" added.
A=Asset L=Labor M=Material O=Other Default Value: L |
5 | TEAM_MEMBER_IND | Character(1) | VARCHAR2(1) NOT NULL |
Team Member Indicator
E=Employee G=Generic Resource N=Not Applicable Default Value: G |
6 | TEAM_MEMBER | Character(30) | VARCHAR2(30) NOT NULL |
Team Member
Prompt Table: PGM_TEAM_PRM_VW |
7 | PROJ_ROLE | Character(15) | VARCHAR2(15) NOT NULL |
Project Role
Prompt Table: PROJ_ROLE |
8 | SCHED_NUM | Number(5,0) | INTEGER NOT NULL |
Team sequence number
Default Value: 1 Prompt Table: PROJ_TEAM_SCHED |
9 | SOURCE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Team member created from
6=Primavera P6 G=Proposal Management M=MSP P=Projects online R=Resource Management |
10 | ACT_UID | Character(15) | VARCHAR2(15) NOT NULL | Task ID |
11 | DESCRLONG | Long Character | CLOB | Long Description |
12 | LASTUPDSOURCE | Character(1) | VARCHAR2(1) NOT NULL | Team member source |
13 | USER_FIELD_1 | Character(10) | VARCHAR2(10) NOT NULL | User Field 1 |
14 | UNIT_OF_MEASURE | Character(3) | VARCHAR2(3) NOT NULL |
Used on an approval rule set.
MHR=Muti Hourly PER=Percentage SQF=Square Footage Prompt Table: %EDIT_UOM |
15 | PGM_RATE_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
06/15/2004 FS - Changed eff. dates to 1/1/1900 from 1/1/2000
C=Override Rate E=Employee Rate J=Jobcode Rate R=Project Role Rate X=Custom Rate |
16 | COST_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Rate |
17 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Currency Code
Default Value: PROJECT.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL |
18 | COST | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Total Cost |
19 | PC_BUDGET_ITEM | Character(15) | VARCHAR2(15) NOT NULL |
Project Budgeting: Budget Item
11/15/2004- FS - Added label COST_BUDGET_ITEM
Prompt Table: %EDIT_BUD_CAT |
20 | AVAIL_UNITS | Number(6,0) | INTEGER NOT NULL |
Availability Units
Default Value: 100 |
21 | QTY | Signed Number(17,4) | DECIMAL(15,4) NOT NULL | Quantity |
22 | ASSGND_WORK | Signed Number(16,2) | DECIMAL(14,2) NOT NULL |
Assigned Work
Default Value: 0 |
23 | ACTUAL_WORK | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Actual Work |
24 | REMAINING_WORK | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | New Remaining work in hours |
25 | BASELINE_WORK | Signed Number(16,2) | DECIMAL(14,2) NOT NULL | Baseline Work |
26 | RESOURCE_NOTIFIED | Character(1) | VARCHAR2(1) NOT NULL |
Flag to indicate whether an activity resource has been notified of his/her assignment to the activity.
N=Not Notified Y=Notified Y/N Table Edit Default Value: N |
27 | FMS_DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the original entry. |
28 | FMS_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the original entry. |
29 | FMS_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
30 | FMS_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |
31 | BILL_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Billing Rate |
32 | BILL_RATE_TYPE_1 | Character(1) | VARCHAR2(1) NOT NULL |
06/03/2004 - PR_FS_B005 Estimanting Labor PRL/ARL Changes
C=Override Rate E=Employee Rate J=Jobcode Rate R=Project Role Rate X=Custom Rate |
33 | BILL_AMT | Signed Number(28,3) | DECIMAL(26,3) NOT NULL | Bill Amount |
34 | BILL_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Bill Currency Code
Default Value: PROJECT.CURRENCY_CD Prompt Table: CURRENCY_CD_TBL |
35 | ACT_ASSGN_DAYS | Number(8,2) | DECIMAL(7,2) NOT NULL | Actual Assignment Days |
36 | ASSIGNED_TO_WO | Character(1) | VARCHAR2(1) NOT NULL |
An indicator that if a project activitity resource is copied over to a work order.
N=No Y=Yes Default Value: N |
37 | EXCEPTION_NUM | Number(3,0) | SMALLINT NOT NULL |
Exception Flag
Default Value: 0 |
38 | ASSET_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Asset Type
010=IT Hardware 020=IT Software 040=Equipment 050=Property 060=Fleet 070=Machinery 080=Furniture 090=Facility 100=Intangible 200=Asset Retirement Obligations 999=Other |
39 | ASSET_SUBTYPE | Character(15) | VARCHAR2(15) NOT NULL |
Asset Subtype
Prompt Table: AM_SUBTYPE |
40 | MFG_ID | Character(50) | VARCHAR2(50) NOT NULL |
Manufacturer ID
Prompt Table: MANUFACTURER |
41 | MODEL | Character(30) | VARCHAR2(30) NOT NULL |
Model
Prompt Table: MFG_MODEL |
42 | P6_MERGED_ASSIGNMT | Character(1) | VARCHAR2(1) NOT NULL |
An indicator that tells whether a resource assignment (activity team member) originated from a merging of multiple P6 assignments.
N=Not Merged Y=Merged Y/N Table Edit Default Value: N |
43 | DEF_CRATE_COST | Character(15) | VARCHAR2(15) NOT NULL |
The default Custom Rate Name for costing rate
Prompt Table: PC_CR_PRL_VW |
44 | DEF_CRATE_BILL | Character(15) | VARCHAR2(15) NOT NULL |
The default Custom Rate Name for billing rate
Prompt Table: PC_CR_PRL_VW |