INTFC_TEAM_GEN

(SQL Table)
 Index Back

Third-Party Resource Staging

Third-Party Resource Staging table for loading Project Team and/or Activity Team from a third-party system.

  • Parent record: PROJ_ACTIVITY

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 INTFC_ID Number(8,0) INTEGER NOT NULL Interface ID
    2 INTFC_LINE_NUM Number(8,0) INTEGER NOT NULL Interface Line Number
    3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

    Default Value: OPR_DEF_TBL_PC.BUSINESS_UNIT

    Prompt Table: SP_BU_PC_NONVW

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

    Default Value: OPR_DEF_TBL_PC.PROJECT_ID

    Prompt Table: SP_PROJ_NONVW

    5 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

    Prompt Table: PROJ_ACTIVITY

    6 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

    7 TEAM_MEMBER_IND Character(1) VARCHAR2(1) NOT NULL Team Member Indicator
    E=Employee
    G=Generic Resource
    N=Not Applicable

    Default Value: E

    8 TEAM_MEMBER Character(30) VARCHAR2(30) NOT NULL Team Member

    Prompt Table: %EDIT_ID_NUM

    9 PROCESS_INSTANCE Number(10,0) DECIMAL(10) NOT NULL Process Instance
    10 PLAN_STARTDT Date(10) DATE Planned Start Date

    Default Value: PROJECT.START_DT

    11 PLAN_ENDDT Date(10) DATE Planned End Date

    Default Value: PROJECT.END_DT

    12 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role

    Default Value: BUS_UNIT_OPT_PC.PC_DEFAULT_ROLE

    Prompt Table: PROJ_ROLE

    13 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
    14 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
    15 ASSET_SUBTYPE Character(15) VARCHAR2(15) NOT NULL Asset Subtype

    Prompt Table: AM_SUBTYPE

    16 MODEL Character(30) VARCHAR2(30) NOT NULL Model

    Prompt Table: MFG_MODEL_VW

    17 MFG_ID Character(50) VARCHAR2(50) NOT NULL Manufacturer ID

    Prompt Table: MANUFACTURER

    18 AVAIL_UNITS Number(6,0) INTEGER NOT NULL Availability Units
    19 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage

    Default Value: OPR_DEF_TBL_PC.UNIT_OF_MEASURE

    Prompt Table: UNITS_TBL

    20 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: C

    21 COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Cost Rate
    22 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

    Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    23 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

    Default Value: C

    24 BILL_RATE Number(27,3) DECIMAL(26,3) NOT NULL Billing Rate
    25 BILL_CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Bill Currency Code

    Default Value: BUS_UNIT_TBL_PC.CURRENCY_CD

    Prompt Table: CURRENCY_CD_TBL

    26 ASSGND_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL Assigned Work

    Default Value: 0

    27 BASELINE_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL Baseline Work
    28 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
    29 INTFC_STATUS Character(3) VARCHAR2(3) NOT NULL Interface Status
    CON=Consolidated
    DON=Mass Changes Generated
    ERR=Error
    NEW=Mass Changes Not Generated
    REP=Replaced by Other Records (AP)
    UNI=Unitized

    Default Value: NEW

    30 LOAD_STATUS Character(3) VARCHAR2(3) NOT NULL /* -> JMZ. PSOFT. 11-OCT-2002 */ New Status were added : HLD and INP for Asset Management. /* <- JMZ. PSOFT. 11-OCT-2002 */
    CON=Consolidated
    DON=Loaded
    ERR=Errored
    EXC=Excluded
    HLD=On Hold
    INP=In Process
    NEW=Pending
    PGI=PO Grp Incomplete
    REP=Replaced
    UNI=Unitized

    Default Value: NEW

    31 ERR_REASON Character(3) VARCHAR2(3) NOT NULL Reason code for error
    ACT=Activity Error
    DUP=Duplicate
    EDT=Invalid Field Value
    PRJ=Project Error
    REQ=Required Field Missing
    SUM=Resource at Summary Activity
    32 PC_DURATION Number(11,2) DECIMAL(10,2) NOT NULL Duration
    33 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

    34 PROJECT_OBJECTID Number(10,0) DECIMAL(10) NOT NULL A unique ID that is the Project key to a corresponding table in an external system such as Primavera.
    35 ACTIVITY_OBJECTID Number(10,0) DECIMAL(10) NOT NULL A unique ID that is the Activity key to a corresponding table in an external system such as Primavera.
    36 RESASSIGN_OBJECTID Number(10,0) DECIMAL(10) NOT NULL A unique ID that is the Resource Assignment key to a corresponding table in an external system such as Primavera.
    37 P6_TSKRS_GUID Character(36) VARCHAR2(36) NOT NULL P6 ResourceAssignment GUID