RS_ASSGN_SO_VW5(SQL View) |
Index Back |
|---|
| SELECT A.ASSIGNMENT_ID , A.EMPLID , A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , A.PROJECT_ID , B.ASSIGN_STS , A.SYSTEM_SOURCE , C.END_DT FROM %Table(RS_ASSIGNMENT) A , %Table(RS_ASSGN_STS) B ,%Table(RS_ASSGN_DETAIL) C WHERE A.ASSIGNMENT_ID = B.ASSIGNMENT_ID AND B.ASSIGNMENT_ID = C.ASSIGNMENT_ID AND B.LASTUPDDTTM = ( SELECT MAX(D.LASTUPDDTTM) FROM %Table(RS_ASSGN_STS) D WHERE D.ASSIGNMENT_ID = B.ASSIGNMENT_ID) AND C.SEQNO = ( SELECT MAX(E.SEQNO) FROM %Table(RS_ASSGN_DETAIL) E WHERE E.ASSIGNMENT_ID = C.ASSIGNMENT_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  ASSIGNMENT_ID |
Character(15) | VARCHAR2(15) NOT NULL |
Work Assignment ID
Default Value: NEXT |
| 2 | EMPLID | Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 3 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 4 | SO_ID | Character(15) | VARCHAR2(15) NOT NULL |
Service Order ID
Prompt Table: RS_SO_SRCH_VW |
| 5 | SO_LINE | Number(3,0) | SMALLINT NOT NULL |
Line Number
Prompt Table: RS_SO_LN_SCH_VW |
| 6 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: PROJ_SRCH |
| 7 | 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 |
| 8 | SYSTEM_SOURCE | Character(3) | VARCHAR2(3) NOT NULL | Identifies the application or source system that generated a journal entry. Release 8.80 - 11/14/2002 - RVlasic - Removed GDM (JrnlGen - Deduction Management) from Translate Values. SUJ---Included a label as Product. Release 8.9 - 05/11/2005 - RVlasic - Added PRV (Variance Pricing) and PKK (KK Budget Journal) and deleted GLK for Project Costing per Brian Cohen. |
| 9 | END_DT | Date(10) | DATE | End Date |