PC_TEAM_UPG_TAO

(SQL Table)
Index Back

Project Team Upgrade TAO

  • Parent record: PROJECT
  • # 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