SUJ--Modified to list only Resource Management Assignments

RS_ASSGN_WO_VW

(SQL View)
 Index Back

SELECT A.ASSIGNMENT_ID , A.EMPLID , A1.START_DT , A1.END_DT ,BUSINESS_UNIT_WO ,WO_ID , A.TASK_TYPE , A1.SUN , A1.MON , A1.TUES , A1.WED , A1.THURS , A1.FRI , A1.SAT , A1.PERCENTAGE , A1.TIME_START , A1.SCHEDULED_HRS , A.ASSIGNED_TO , 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.SYSTEM_SOURCE = 'WM' AND A.RSRC_TYPE = '1' AND B.LASTUPDDTTM = ( SELECT MAX(C.LASTUPDDTTM) FROM %Table(RS_ASSGN_STS) C WHERE C.ASSIGNMENT_ID = B.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 START_DT Date(10) DATE Start Date
4 END_DT Date(10) DATE End Date
5 BUSINESS_UNIT_WO Character(5) VARCHAR2(5) NOT NULL Business Unit Work Order
6 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
7 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Task Category

Prompt Table: RS_TASK_TYPE

8 SUN Character(1) VARCHAR2(1) NOT NULL Sunday

Y/N Table Edit

Default Value: INSTALLATION_RS.SUN

9 MON Character(1) VARCHAR2(1) NOT NULL Monday

Y/N Table Edit

Default Value: INSTALLATION_RS.MON

10 TUES Character(1) VARCHAR2(1) NOT NULL Tuesday

Y/N Table Edit

Default Value: INSTALLATION_RS.TUES

11 WED Character(1) VARCHAR2(1) NOT NULL Wednesday

Y/N Table Edit

Default Value: INSTALLATION_RS.WED

12 THURS Character(1) VARCHAR2(1) NOT NULL Thursday

Y/N Table Edit

Default Value: INSTALLATION_RS.THURS

13 FRI Character(1) VARCHAR2(1) NOT NULL Friday

Y/N Table Edit

Default Value: INSTALLATION_RS.FRI

14 SAT Character(1) VARCHAR2(1) NOT NULL Saturday

Y/N Table Edit

Default Value: INSTALLATION_RS.SAT

15 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage

Default Value: 1

16 TIME_START Time(15) TIMESTAMP Start Time

Default Value: INSTALLATION_RS.TIME_START

17 SCHEDULED_HRS Signed Number(10,4) DECIMAL(8,4) NOT NULL Scheduled Hours
18 ASSIGNED_TO Character(30) VARCHAR2(30) NOT NULL Assigned To
19 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