PC_TEAM_UPG_TAO(SQL Table) |
Index Back |
---|---|
Project Team Upgrade TAO |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | PROCESS_INSTANCE | Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
2 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: PROJECT.BUSINESS_UNIT Prompt Table: SP_BU_PC_NONVW |
3 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: PROJECT_ALL_VW |
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 | Character(30) | VARCHAR2(30) NOT NULL |
Team Member
Prompt Table: %EDITTABLE |
6 | TEAM_MEMBER_IND | Character(1) | VARCHAR2(1) NOT NULL |
Team Member Indicator
E=Employee G=Generic Resource N=Not Applicable Default Value: E |
7 | EXCEPTION_NUM | Number(3,0) | SMALLINT NOT NULL | Exception Flag |
8 | FMS_DTTM_STAMP | DateTime(26) | TIMESTAMP | Specifies the date and time of the original entry. |
9 | FMS_OPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the original entry. |
10 | FMS_LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. |
11 | FMS_LASTUPDOPRID | Character(30) | VARCHAR2(30) NOT NULL | Specifies the User ID which made the last update to an entry. |
12 | START_DT | Date(10) | DATE | Start Date |
13 | END_DT | Date(10) | DATE | End Date |
14 | EMAIL_NOTIFICATION | Character(1) | VARCHAR2(1) NOT NULL |
Email Notify for Status Change
N=No Y=Yes Default Value: Y |
15 | EMAILID | Character(70) | VARCHAR2(70) NOT NULL | A user's E-mail address |
16 | 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 |
17 | REQ_ASSIGNMENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Assignment ID |
18 | REQ_ASSIGN_METHOD | Character(1) | VARCHAR2(1) NOT NULL |
Requirement fulfill method
A=Assigned Status change from PC D=Direct Assignment from Project E=Map to an existing team member M=Direct assignment from MSP R=Assignment from RS S=Service Order W=Search & Assign from Workbench |
19 | PLAN_PROJROLE | Character(15) | VARCHAR2(15) NOT NULL | Requirement Project Role |
20 | SOURCE_REQ | Character(25) | VARCHAR2(25) NOT NULL | Source Requirement ID |
21 | SO_ID | Character(15) | VARCHAR2(15) NOT NULL | Service Order ID |
22 | SO_LINE | Number(3,0) | SMALLINT NOT NULL | Line Number |
23 | TEAM_SCHED_CNT | Number(4,0) | SMALLINT NOT NULL | Project Team Count |
24 | RES_UID | Character(15) | VARCHAR2(15) NOT NULL | Resource ID |
25 | LASTUPDSOURCE | Character(1) | VARCHAR2(1) NOT NULL | Team member source |
26 | USER_FIELD_1 | Character(10) | VARCHAR2(10) NOT NULL | User Field 1 |
27 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percentage |
28 | APPT_TYPE_MTH_ACAD | Number(6,2) | DECIMAL(5,2) NOT NULL | Academic Appointment Months |
29 | APPT_TYPE_MTH_CAL | Number(6,2) | DECIMAL(5,2) NOT NULL | Calendar Appointment Months |
30 | APPT_TYPE_MTH_SUMR | Number(6,2) | DECIMAL(5,2) NOT NULL | Summer Appointment Months |
31 | FROM_JCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
32 | DESCRLONG | Long Character | CLOB | Long Description |
33 | 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: UNITS_TBL |
34 | 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 Default Value: E |
35 | COST_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Rate |
36 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
37 | PC_BUDGET_ITEM | Character(15) | VARCHAR2(15) NOT NULL | Project Budgeting: Budget Item 11/15/2004- FS - Added label COST_BUDGET_ITEM |
38 | BILL_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Billing Rate |
39 | 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 |
40 | ORIGINAL_RES_ID | Character(30) | VARCHAR2(30) NOT NULL | Original Resource ID |
41 | BILL_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Bill Currency Code |
42 | CREDIT_PCT | Number(6,2) | DECIMAL(5,2) NOT NULL | Percentage Credit |
43 | RESOURCE_STS | Character(2) | VARCHAR2(2) NOT NULL |
11/15/2004 - New field added.
AL=Allocated CA=Cancelled CM=Committed CO=Considered CP=Completed RE=Rejected RQ=Requested |
44 | POOL_ID | Character(10) | VARCHAR2(10) NOT NULL | Pool ID field. |
45 | PER_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Personnel Status
E=Employee N=Non-Employee |
46 | REGION_CD | Character(10) | VARCHAR2(10) NOT NULL | Identifies the Sales Region. Populated on the Item Table to identify the Sales Region the Item is applied to. |
47 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL | AM Business Unit |