RS_SCHED_TASK_H (SQL Table)	Index Back
Calendar Archive table Calendar Archive table for an employee

RS_SCHED_TASK_H

(SQL Table)

Calendar Archive table

Calendar Archive table for an employee

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PSARCH_ID Character(8) VARCHAR2(8) NOT NULL Archive ID (see PSARCHTEMPLATE).

2 PSARCH_BATCHNUM Number(30,0) DECIMAL(30) NOT NULL Archive Batch Number

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

4 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

5 DATE_UNDER_RPT Date(10) DATE NOT NULL Date Under Report
Default Value: %date

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

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

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

9 RS_APPT_ID Character(15) VARCHAR2(15) NOT NULL Appointment Id

10 RS_APPT_TYPE Character(3) VARCHAR2(3) NOT NULL Appointment Type
ACT=Activity
ASN=Assignment
DAY=All Day Event
MTG=Meeting

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

12 FLEXIBILITY Number(4,2) DECIMAL(3,2) NOT NULL Flexibility Factor

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

14 TIME_START Time(15) TIMESTAMP Start Time

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

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

17 CREATE_DTTM DateTime(26) TIMESTAMP Creation Datetime

18 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	PSARCH_ID	Character(8)	VARCHAR2(8) NOT NULL	Archive ID (see PSARCHTEMPLATE).
2	PSARCH_BATCHNUM	Number(30,0)	DECIMAL(30) NOT NULL	Archive Batch Number
3	EMPLID	Character(11)	VARCHAR2(11) NOT NULL	Employee ID
4	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
5	DATE_UNDER_RPT	Date(10)	DATE NOT NULL	Date Under Report Default Value: %date
6	SEQNO	Number(5,0)	INTEGER NOT NULL	Sequence Number Default Value: 0
7	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254
8	ASSIGNMENT_ID	Character(15)	VARCHAR2(15) NOT NULL	Work Assignment ID Prompt Table: RS_EMPL_ASSN_VW
9	RS_APPT_ID	Character(15)	VARCHAR2(15) NOT NULL	Appointment Id
10	RS_APPT_TYPE	Character(3)	VARCHAR2(3) NOT NULL	Appointment Type ACT=Activity ASN=Assignment DAY=All Day Event MTG=Meeting
11	TASK_TYPE	Character(18)	VARCHAR2(18) NOT NULL	Task Category Prompt Table: %EDITTABLE
12	FLEXIBILITY	Number(4,2)	DECIMAL(3,2) NOT NULL	Flexibility Factor
13	PERCENTAGE	Signed Number(7,2)	DECIMAL(5,2) NOT NULL	Percentage
14	TIME_START	Time(15)	TIMESTAMP	Start Time
15	SCHEDULED_HRS	Signed Number(10,4)	DECIMAL(8,4) NOT NULL	Scheduled Hours
16	SCHEDULE_SOURCE	Character(1)	VARCHAR2(1) NOT NULL	Source of the scheduled event O=Other R=Batch-Generated Read Only S=System-Generated
17	CREATE_DTTM	DateTime(26)	TIMESTAMP	Creation Datetime
18	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.