RS_SCHED_TASKVW

(SQL View)
 Index Back

Resource Schedule View

Resource Schedule View. Calendar view for a resource from the calendar table RS_SCHED_TASK.

SELECT A.EMPLID , A.SYSTEM_SOURCE , A.DATE_UNDER_RPT , A.SEQNO , A.DESCR254 , A.ASSIGNMENT_ID , A.RS_APPT_ID , A.TASK_TYPE , A.PERCENTAGE , A.TIME_START , A.SCHEDULED_HRS , A.SCHEDULE_SOURCE FROM PS_RS_SCHED_TASK A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
2 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.

Default Value: RS

3 DATE_UNDER_RPT Date(10) DATE NOT NULL Date Under Report

Default Value: %date

4 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number

Default Value: 0

5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
6 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID

Prompt Table: RS_EMPL_ASSN_VW

7 RS_APPT_ID Character(15) VARCHAR2(15) NOT NULL Appointment Id
8 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Task Category
9 PERCENTAGE Signed Number(7,2) DECIMAL(5,2) NOT NULL Percentage
10 TIME_START Time(15) TIMESTAMP Start Time
11 SCHEDULED_HRS Signed Number(10,4) DECIMAL(8,4) NOT NULL Scheduled Hours
12 SCHEDULE_SOURCE Character(1) VARCHAR2(1) NOT NULL Source of the scheduled event
O=Other
R=Batch-Generated Read Only
S=System-Generated