BUSINESS_UNITWORK_ORDER_IDACTIVITY_IDSPA_PL_ACTMS_VW(SQL View) |
Index Back |
|---|---|
Projects for time linesProjects for time lines |
| SELECT P.BUSINESS_UNIT , B.DESCR , P.WORK_ORDER_ID , W.JOB_TITLE , P.ACTIVITY_ID , A.DESCR FROM PS_SPF_PRGLOG_MS P , PS_BUS_UNIT_TBL_FS B , PS_SPF_WORDERREC W , PS_FS_ACTIVITY_TBL A , PS_SET_CNTRL_GROUP R WHERE P.MS_STATUS = 'N' AND P.BUSINESS_UNIT = B.BUSINESS_UNIT AND P.BUSINESS_UNIT = W.BUSINESS_UNIT AND P.WORK_ORDER_ID = W.WORK_ORDER_ID AND A.SETID = R.SETID AND R.REC_GROUP_ID = 'FS_43' AND R.SETCNTRLVALUE = P.BUSINESS_UNIT AND P.ACTIVITY_ID = A.ACTIVITY_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | WORK_ORDER_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Order ID |
| 4 | JOB_TITLE | Character(50) | VARCHAR2(50) NOT NULL | Job Title |
| 5 | ACTIVITY_ID |
Character(15) | VARCHAR2(15) NOT NULL | Activity ID |
| 6 | DESCR2 | Character(30) | VARCHAR2(30) NOT NULL | Description |