RS_TASK_TYPE(SQL Table) |
Index Back |
---|---|
Task Category |
# | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
---|---|---|---|---|
1 | TASK_TYPE | Character(18) | VARCHAR2(18) NOT NULL | Task Category |
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 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | FLEXIBILITY | Number(4,2) | DECIMAL(3,2) NOT NULL | Flexibility Factor |
5 | RESV_FLEXIBILITY | Number(4,2) | DECIMAL(3,2) NOT NULL | Reserved Status Flexibility |
6 | RS_ASSIGNMENT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Use for Assignment
Y/N Table Edit Default Value: N |
7 | RS_MANAGER | Character(1) | VARCHAR2(1) NOT NULL |
Update by Manager
N=N Y=Y Y/N Table Edit Default Value: Y |
8 | RS_RESOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Update by Resource
Y/N Table Edit Default Value: Y |
9 | RS_MGR_NOTIFY | Character(1) | VARCHAR2(1) NOT NULL |
Notify by Manager
Y/N Table Edit Default Value: N |
10 | RS_RES_NOTIFY | Character(1) | VARCHAR2(1) NOT NULL |
Notify by Resource
Y/N Table Edit Default Value: N |
11 | RS_TYPE_SYS_OPT | Character(1) | VARCHAR2(1) NOT NULL |
System Delivered
O=Other S=System Default Value: O |
12 | EXTERNAL_CATEGORY | Character(40) | VARCHAR2(40) NOT NULL | External Category |
13 | DESCRLONG | Long Character | CLOB | Long Description |