RS_RES_ASSGN_VW(SQL View) |
Index Back |
|---|---|
Assignments detail for a ResResource Assignment Details used in Staffing Workbench -Resource Projections |
| SELECT A.ASSIGNMENT_ID , Prj.DESCR ,CUS.NAME1 , A1.START_DT , A1.END_DT , A.EMPLID , C.DESCR ,c.ASSIGN_STS , B.COMMENTS_254 , B.LASTUPDDTTM FROM PS_RS_ASSIGNMENT A LEFT OUTER JOIN PS_CUSTOMER_FS CUS ON A.CUST_ID=CUS.CUST_ID , PS_RS_ASSIGNDET_VW A1 , PS_RS_ASSGN_STS B , PS_RS_ASSGN_ST_TBL C , PS_SP_PROJP_NONVW Prj WHERE A.ASSIGNMENT_ID = A1.ASSIGNMENT_ID AND A.SYSTEM_SOURCE = 'RS' AND A.ASSIGNMENT_ID = B.ASSIGNMENT_ID AND B.LASTUPDDTTM = ( SELECT MAX(LASTUPDDTTM) FROM PS_RS_ASSGN_STS WHERE ASSIGNMENT_ID = A.ASSIGNMENT_ID) AND C.ASSIGN_STS = B.ASSIGN_STS AND C.ASSIGN_STS NOT IN('X','C','R') AND A.Project_ID=Prj.Project_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | ASSIGNMENT_ID | Character(15) | VARCHAR2(15) NOT NULL | Work Assignment ID |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | NAME1 | Character(40) | VARCHAR2(40) NOT NULL | Name 1 |
| 4 | START_DT | Date(10) | DATE | Start Date |
| 5 | END_DT | Date(10) | DATE | End Date |
| 6 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 7 | DESCR1 | Character(30) | VARCHAR2(30) NOT NULL | Descr |
| 8 | ASSIGN_STS | Character(2) | VARCHAR2(2) NOT NULL |
Assignment Status
A=Assign C=Complete I=Interview P=Propose R=Reject S=Reserve V=Pending Approval X=Cancel |
| 9 | COMMENTS_254 | Character(254) | VARCHAR2(254) NOT NULL | EDI Comments |
| 10 | LASTUPDDTTM | DateTime(26) | TIMESTAMP | Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts. |