EMPLIDDATE_UNDER_RPTSEQNODefault Value: 0
Prompt Table: RS_TASK_TYPE
B=Both
N=No
Y=Yes
Y/N Table Edit
Default Value: N
RS_DAYASSIGN_VW(SQL View) |
Index Back |
|---|
| SELECT A.EMPLID ,A.DATE_UNDER_RPT ,A.SEQNO ,A.TASK_TYPE ,B.RESERVED_FLAG ,B.DESCR ,B.DESCR254_MIXED FROM PS_RS_SCHED_TASK A , PS_RS_ASSIGNMENT B WHERE A.ASSIGNMENT_ID = B.ASSIGNMENT_ID AND A.SYSTEM_SOURCE = B.SYSTEM_SOURCE GROUP BY A.EMPLID ,A.DATE_UNDER_RPT, A.SEQNO, A.TASK_TYPE, B.RESERVED_FLAG, B.DESCR, B.DESCR254_MIXED |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 2 | DATE_UNDER_RPT |
Date(10) | DATE | Date Under Report |
| 3 | SEQNO |
Number(5,0) | INTEGER NOT NULL |
Sequence Number
Default Value: 0 |
| 4 | TASK_TYPE | Character(18) | VARCHAR2(18) NOT NULL |
Task Category
Prompt Table: RS_TASK_TYPE |
| 5 | RESERVED_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Reserved Flag
B=Both N=No Y=Yes Y/N Table Edit Default Value: N |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | DESCR254_MIXED | Character(254) | VARCHAR2(254) NOT NULL | Description |