BUSINESS_UNITDefault Value: PROJECT.BUSINESS_UNIT
Prompt Table: SP_BU_PC_NONVW
PROJECT_IDPrompt Table: PROJECT_VW
SETIDJOBCODEEFFDTDefault Value: %date
PC_TEAM_JOBCDVW(SQL View) |
Index Back |
|---|---|
Project Team Members Prompt VwPrompt table view of Jobcode as project team members. |
| SELECT PT.BUSINESS_UNIT , PT.PROJECT_ID , JOB.SETID , JOB.JOBCODE , JOB.EFFDT , JOB.DESCR FROM PS_PROJECT_TEAM PT , PS_JOBCODE_TBL JOB WHERE PT.TEAM_MEMBER_CLASS = 'L' AND PT.TEAM_MEMBER_IND = 'E' AND PT.FROM_JCODE = JOB.JOBCODE |
| # | 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_VW |
| 3 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | SetID |
| 4 | JOBCODE |
Character(6) | VARCHAR2(6) NOT NULL | Job Code |
| 5 | EFFDT |
Date(10) | DATE |
Effective Date
Default Value: %date |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |