PC_ARL_RESDTLVW

(SQL View)
 Index Back

PGM ARL view for proj res detl

Program Management ARL view for display in the project resource detail page.

SELECT A.BUSINESS_UNIT , A.PROJECT_ID , A.ACTIVITY_ID , A.TEAM_MEMBER_CLASS , A.TEAM_MEMBER_IND , A.TEAM_MEMBER , A.PROJ_ROLE , A.SCHED_NUM , A.USER_FIELD_1 , A.UNIT_OF_MEASURE , A.PGM_RATE_TYPE , A.COST_RATE , A.CURRENCY_CD , A.COST , A.PC_BUDGET_ITEM , A.AVAIL_UNITS , A.QTY , A.ASSGND_WORK , A.ACTUAL_WORK , A.REMAINING_WORK , A.RESOURCE_NOTIFIED , A.EXCEPTION_NUM , B.DESCR , B.START_DT , B.END_DT FROM PS_PROJ_ACT_TEAM A , PS_PROJ_ACTIVITY B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PROJECT_ID = B.PROJECT_ID AND A.ACTIVITY_ID = B.ACTIVITY_ID

  • Parent record: PROJ_ACTIVITY

    • # 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
    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
    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 USER_FIELD_1 Character(10) VARCHAR2(10) NOT NULL User Field 1
    10 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
    MHR=Muti Hourly
    PER=Percentage
    SQF=Square Footage
    11 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
    12 COST_RATE Number(27,3) DECIMAL(26,3) NOT NULL Cost Rate
    13 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
    14 COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Cost
    15 PC_BUDGET_ITEM Character(15) VARCHAR2(15) NOT NULL Project Budgeting: Budget Item 11/15/2004- FS - Added label COST_BUDGET_ITEM
    16 AVAIL_UNITS Number(6,0) INTEGER NOT NULL Availability Units
    17 QTY Signed Number(17,4) DECIMAL(15,4) NOT NULL Quantity
    18 ASSGND_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL Assigned Work
    19 ACTUAL_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL Actual Work
    20 REMAINING_WORK Signed Number(16,2) DECIMAL(14,2) NOT NULL New Remaining work in hours
    21 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

    22 EXCEPTION_NUM Number(3,0) SMALLINT NOT NULL Exception Flag
    23 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    24 START_DT Date(10) DATE Start Date
    25 END_DT Date(10) DATE End Date