RS_SCHED_VW1

(SQL View)

SELECT EMPLID ,DATE_UNDER_RPT ,SEQNO ,DESCR254 ,ASSIGNMENT_ID ,TASK_TYPE ,PERCENTAGE ,TIME_START ,SCHEDULED_HRS ,SCHEDULE_SOURCE ,CREATE_DTTM ,LAST_UPDATE_DTTM FROM %Table(RS_SCHED_TASK) WHERE SEQNO = 1

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

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

2 DATE_UNDER_RPT Date(10) DATE Date Under Report

3 SEQNO Number(5,0) INTEGER NOT NULL Sequence Number
Default Value: 0

4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254

5 ASSIGNMENT_ID Character(15) VARCHAR2(15) NOT NULL Work Assignment ID
Prompt Table: RS_EMPL_ASSN_VW

6 TASK_TYPE Character(18) VARCHAR2(18) NOT NULL Task Category
Prompt Table: %EDITTABLE

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

8 TIME_START Time(15) TIMESTAMP Start Time

9 SCHEDULED_HRS Signed Number(10,4) DECIMAL(8,4) NOT NULL Scheduled Hours

10 SCHEDULE_SOURCE Character(1) VARCHAR2(1) NOT NULL Source of the scheduled event
O=Other
R=Batch-Generated Read Only
S=System-Generated

11 CREATE_DTTM DateTime(26) TIMESTAMP Creation Datetime

12 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
2	DATE_UNDER_RPT	Date(10)	DATE	Date Under Report
3	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number Default Value: 0
4	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
5	ASSIGNMENT_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Assignment ID Prompt Table: RS_EMPL_ASSN_VW
6	TASK_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Task Category Prompt Table: %EDITTABLE
7	PERCENTAGE	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percentage
8	TIME_START	Time(15)	TIMESTAMP	Start Time
9	SCHEDULED_HRS	Signed Number(10,4)	DECIMAL(8,4) NOT NULL	Scheduled Hours
10	SCHEDULE_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Source of the scheduled event O=Other R=Batch-Generated Read Only S=System-Generated
11	CREATE_DTTM	DateTime(26)	TIMESTAMP	Creation Datetime
12	LAST_UPDATE_DTTM	DateTime(26)	TIMESTAMP	Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.