RS_SCHED_TASK(SQL Table) |
Index Back |
---|---|
Calendar table for an employeeSUJ--Included SYSTEM_SOURCE and RS_APPT_TYPE field to store product type and Appointment type. Increased the precision of SCHEDULED_HRS |
# | 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 | RS_APPT_TYPE | Character(3) | VARCHAR2(3) NOT NULL |
Appointment Type
ACT=Activity ASN=Assignment DAY=All Day Event MTG=Meeting |
9 | TASK_TYPE | Character(18) | VARCHAR2(18) NOT NULL |
Task Category
Prompt Table: %EDITTABLE |
10 | FLEXIBILITY | Number(4,2) | DECIMAL(3,2) NOT NULL | Flexibility Factor |
11 | PERCENTAGE | Signed Number(7,2) | DECIMAL(5,2) NOT NULL | Percentage |
12 | TIME_START | Time(15) | TIMESTAMP | Start Time |
13 | SCHEDULED_HRS | Signed Number(10,4) | DECIMAL(8,4) NOT NULL | Scheduled Hours |
14 | SCHEDULE_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Source of the scheduled event
O=Other R=Batch-Generated Read Only S=System-Generated |
15 | CREATE_DTTM | DateTime(26) | TIMESTAMP | Creation Datetime |
16 | 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. |