RS_WO_RR_ASN_VW

(SQL View)

SELECT A.EMPLID , A.BUSINESS_UNIT , A.SO_ID , A.SO_LINE , A1.START_DT , B.ASSIGN_STS FROM %Table(RS_ASSIGNMENT) A , %Table(RS_ASSIGNDET_VW) A1 , %Table(RS_ASSGN_STS) B WHERE A.ASSIGNMENT_ID = A1.ASSIGNMENT_ID AND A.ASSIGNMENT_ID = B. ASSIGNMENT_ID AND A.EMPLID <> ' ' AND A.BUSINESS_UNIT <> ' ' AND A.SO_ID <> ' '

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

3 SO_ID Character(15) VARCHAR2(15) NOT NULL Service Order ID

4 SO_LINE Number(3,0) SMALLINT NOT NULL Line Number

5 START_DT Date(10) DATE Start Date

6 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
Prompt Table: RS_ASSGN_ST_TBL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	BUSINESS_UNIT	Character(5)	VARCHAR2(5) NOT NULL	Business Unit
3	SO_ID	Character(15)	VARCHAR2(15) NOT NULL	Service Order ID
4	SO_LINE	Number(3,0)	SMALLINT NOT NULL	Line Number
5	START_DT	Date(10)	DATE	Start Date
6	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 Prompt Table: RS_ASSGN_ST_TBL