EMPLIDSYSTEM_SOURCEDefault Value: RS
DATE_UNDER_RPTDefault Value: %date
SEQNODefault Value: 0
Prompt Table: RS_EMPL_ASSN_VW
RS_ASSGN_DTS(SQL Table) |
Index Back |
|---|---|
Resource Sched Conflicts ViewResource Schedule Conflicts View. |
| # | 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 |
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 | TASK_TYPE | Character(18) | VARCHAR2(18) NOT NULL | Task Category |
| 8 | TIME_START | Time(15) | TIMESTAMP | Start Time |
| 9 | START_TIME | Time(15) | TIMESTAMP | Start of Shift |
| 10 | END_TIME | Time(15) | TIMESTAMP | End of Shift |
| 11 | SCHEDULED_HRS | Signed Number(10,4) | DECIMAL(8,4) NOT NULL | Scheduled Hours |