BUSINESS_UNITPROJECT_IDEMPLIDAL=Allocated
CA=Cancelled
CM=Committed
CO=Considered
CP=Completed
RE=Rejected
RQ=Requested
PC_MBR_INFO_VW(SQL View) |
Index Back |
|---|---|
project team membersproject team members |
| SELECT PT.BUSINESS_UNIT , PT.PROJECT_ID , PT.TEAM_MEMBER , PT.PLAN_PROJROLE , PT.RESOURCE_STS , PT.BILL_RATE , PT.BILL_CURRENCY_CD , PT.COST_RATE , PT.CURRENCY_CD , JB.JOBCODE , PS.NAME , PS.PHONE , PS.COUNTRY , PS.POSTAL , PS.STATE , PS.CITY , PH.EMPLOYEE_PHOTO FROM PS_PROJECT_TEAM PT , PS_PERSONAL_DATA PS LEFT OUTER JOIN PS_RS_WO_CURJOB_VW JB ON PS.EMPLID = JB.EMPLID AND JB.SYSTEM_SOURCE = 'RS' LEFT OUTER JOIN PS_EMPL_PHOTO PH ON PS.EMPLID = PH.EMPLID AND PH.PHOTO_SIZENAME = 'PAGE' WHERE PT.TEAM_MEMBER = PS.EMPLID AND PT.TEAM_MEMBER_CLASS = 'L' AND PT.RESOURCE_STS <> 'CA' AND PT.RESOURCE_STS <> 'RE' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | PROJECT_ROLE | Character(30) | VARCHAR2(30) NOT NULL | Project Role |
| 5 | 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 |
| 6 | BILL_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Billing Rate |
| 7 | BILL_CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Bill Currency Code |
| 8 | COST_RATE | Number(27,3) | DECIMAL(26,3) NOT NULL | Cost Rate |
| 9 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 10 | JOBCODE | Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 11 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 12 | PHONE | Character(24) | VARCHAR2(24) NOT NULL | Telephone |
| 13 | COUNTRY | Character(3) | VARCHAR2(3) NOT NULL | Country |
| 14 | POSTAL | Character(12) | VARCHAR2(12) NOT NULL | Postal |
| 15 | STATE | Character(6) | VARCHAR2(6) NOT NULL | State |
| 16 | CITY | Character(30) | VARCHAR2(30) NOT NULL | City |
| 17 | EMPLOYEE_PHOTO | Image / Attachment(256) | VARCHAR2(256) | Employee Photograph |