TASK_TYPEN=N
Y=Y
Y/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: Y
Y/N Table Edit
Default Value: N
Y/N Table Edit
Default Value: N
O=Other
S=System
Default Value: O
RS_ASSGN_TTVW(SQL View) |
Index Back |
|---|
| SELECT TASK_TYPE ,DESCR ,FLEXIBILITY ,RS_MANAGER ,RS_RESOURCE ,RS_MGR_NOTIFY ,RS_RES_NOTIFY ,RS_TYPE_SYS_OPT ,EXTERNAL_CATEGORY ,DESCRLONG FROM %Table(RS_TASK_TYPE) WHERE RS_ASSIGNMENT_FLAG = 'Y' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | TASK_TYPE |
Character(18) | VARCHAR2(18) NOT NULL | Task Category |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | FLEXIBILITY | Number(4,2) | DECIMAL(3,2) NOT NULL | Flexibility Factor |
| 4 | RS_MANAGER | Character(1) | VARCHAR2(1) NOT NULL |
Update by Manager
N=N Y=Y Y/N Table Edit Default Value: Y |
| 5 | RS_RESOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Update by Resource
Y/N Table Edit Default Value: Y |
| 6 | RS_MGR_NOTIFY | Character(1) | VARCHAR2(1) NOT NULL |
Notify by Manager
Y/N Table Edit Default Value: N |
| 7 | RS_RES_NOTIFY | Character(1) | VARCHAR2(1) NOT NULL |
Notify by Resource
Y/N Table Edit Default Value: N |
| 8 | RS_TYPE_SYS_OPT | Character(1) | VARCHAR2(1) NOT NULL |
System Delivered
O=Other S=System Default Value: O |
| 9 | EXTERNAL_CATEGORY | Character(40) | VARCHAR2(40) NOT NULL | External Category |
| 10 | DESCRLONG | Long Character | CLOB | Long Description |