BUSINESS_UNITASSIGNMENT_IDFO_ASGN_M_YR_VW(SQL View) |
Index Back |
|---|---|
Assignment Month/Year View |
| SELECT A.BUSINESS_UNIT , A.ASSIGNMENT_ID , A.EMPLID , A.EMPL_RCD_NUM ,B.START_DT ,B.END_DT FROM PS_RS_ASSIGNMENT A , PS_RS_ASSGN_DETAIL B WHERE A.ASSIGNMENT_ID = B.ASSIGNMENT_ID AND A.SYSTEM_SOURCE = 'STF' AND B.START_DT = ( SELECT MIN(START_DT) FROM PS_RS_ASSGN_DETAIL DS WHERE B.ASSIGNMENT_ID = DS.ASSIGNMENT_ID) AND ( B.END_DT = ( SELECT MAX(END_DT) FROM PS_RS_ASSGN_DETAIL DE WHERE B.ASSIGNMENT_ID = DE.ASSIGNMENT_ID) OR B.END_DT IS NULL) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | ASSIGNMENT_ID |
Character(15) | VARCHAR2(15) NOT NULL | Work Assignment ID |
| 3 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 4 | EMPL_RCD_NUM | Number(3,0) | SMALLINT NOT NULL | Project Employee Job Record # |
| 5 | START_DT | Date(10) | DATE | Start Date |
| 6 | END_DT | Date(10) | DATE | End Date |