RS_ASSIGNDET_VW

(SQL View)
 Index Back

SELECT A.ASSIGNMENT_ID , MIN(A.START_DT) , MAX(A.END_DT) , MIN(TIME_HH) , MIN(TIME_MM) , MIN(END_TIME) , MIN(A.TIME_START) , MAX(A.SCHEDULED_HRS) , MAX(A.PERCENTAGE) , MAX(A.SUN) , MAX(A.MON) , MAX(A.TUES) , MAX(A.WED) , MAX(A.THURS) , MAX(A.FRI) , MAX(A.SAT) FROM %Table(RS_ASSGN_DETAIL) A GROUP BY A.ASSIGNMENT_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
2 START_DT Date(10) DATE Start Date
3 END_DT Date(10) DATE End Date
4 TIME_HH Number(2,0) SMALLINT NOT NULL Time - Hour
5 TIME_MM Number(2,0) SMALLINT NOT NULL Time - Minute
6 END_TIME Time(15) TIMESTAMP End of Shift
7 TIME_START Time(15) TIMESTAMP Start Time
8 SCHEDULED_HRS Signed Number(10,4) DECIMAL(8,4) NOT NULL Scheduled Hours
9 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
10 SUN Character(1) VARCHAR2(1) NOT NULL Sunday

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit

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

Y/N Table Edit