EMPLIDBUSINESS_UNIT_PCPROJECT_IDROW_NUMBER_5WBS_IDDESCR50EX_ACTEAM_TE_VW(SQL View) |
Index Back |
|---|---|
Project Activity Prompt ViewThis provides an easy way to use on-line prompt for the Project Activities. The activity list that shows in the prompt is based on the team based enforce setting. This view is used only by Expenses for description prompting. |
| SELECT B.EMPLID ,A.BUSINESS_UNIT ,A.PROJECT_ID ,A.ROW_NUMBER_5 ,A.WBS_ID ,A.DESCR ,A.DESCR %Concat A.ACTIVITY_ID ,A.ACTIVITY_ID FROM PS_PROJ_ACTIVITY A , PS_PERSONAL_DATA B WHERE A.EFF_STATUS = 'A' AND A.SUMMARY_ACT = 'N' AND ( A.ENFORCE IN ('N','T') OR EXISTS ( SELECT 'X' FROM PS_PROJ_ACT_TEAM PT WHERE A.BUSINESS_UNIT = PT.BUSINESS_UNIT AND A.PROJECT_ID = PT.PROJECT_ID AND A.ACTIVITY_ID = PT.ACTIVITY_ID AND PT.TEAM_MEMBER_CLASS = 'L' AND PT.TEAM_MEMBER_IND = 'E' AND B.EMPLID = PT.TEAM_MEMBER)) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | BUSINESS_UNIT_PC |
Character(5) | VARCHAR2(5) NOT NULL | PC Business Unit |
| 3 | PROJECT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Project Id ChartField |
| 4 | ROW_NUMBER_5 |
Number(5,0) | INTEGER NOT NULL | Row Number |
| 5 | WBS_ID |
Character(100) | VARCHAR2(100) NOT NULL | WBS ID |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCR50 |
Character(50) | VARCHAR2(50) NOT NULL | Description of length 50 |
| 8 | ACTIVITY_ID | Character(15) | VARCHAR2(15) NOT NULL | Activity ID |