RS_ASSGN_SRH_VW(SQL View) |
Index Back |
|---|---|
Assignment search viewA view used for searching assignments. |
| SELECT A.ASSIGNMENT_ID , A.EMPLID , C.NAME , A.SYSTEM_SOURCE , B.ASSIGN_STS , A1.START_DT , A1.END_DT , A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , A.PROJECT_ID , A.CUST_ID FROM PS_RS_ASSIGNMENT A LEFT OUTER JOIN PS_PERSONAL_DATA C ON A.EMPLID = C.EMPLID , PS_RS_ASSIGNDET_VW A1 , PS_RS_ASSGN_STS B WHERE A.ASSIGNMENT_ID = A1.ASSIGNMENT_ID AND A.ASSIGNMENT_ID = B.ASSIGNMENT_ID AND B.LASTUPDDTTM = ( SELECT MAX(B_ED.LASTUPDDTTM) FROM PS_RS_ASSGN_STS B_ED WHERE B.ASSIGNMENT_ID = B_ED.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 | NAME | Character(50) | VARCHAR2(50) NOT NULL | Name |
| 4 | 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. |
| 5 | 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 |
| 6 | START_DT | Date(10) | DATE | Start Date |
| 7 | END_DT | Date(10) | DATE | End Date |
| 8 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BU_PC_NONVW |
| 9 | SO_ID | Character(15) | VARCHAR2(15) NOT NULL |
Service Order ID
Prompt Table: RS_ASSN_SOSO_VW |
| 10 | SO_LINE | Number(3,0) | SMALLINT NOT NULL |
Line Number
Prompt Table: RS_ASSGN_OSL_VW |
| 11 | PROJECT_ID | Character(15) | VARCHAR2(15) NOT NULL |
Project Id ChartField
Prompt Table: SP_PROJ_NONVW |
| 12 | CUST_ID | Character(15) | VARCHAR2(15) NOT NULL |
Uniquely identifies an organizational entity that purchases goods or services from the enterprise. Represents the sold-to customer which is the customer organization that places orders. The CUST_ID may or may not be the same as the identifiers for the bill-to and ship-to locations.
Prompt Table: RS_CUSTOMER_VW |