EMSURVEY1_TAO
(SQL Table) |
Index Back |
|---|
EE Survay Temp Table
|
| # |
PeopleSoft Field Name |
PeopleSoft Field Type |
Database Column Type |
Description |
| 1 |
 EMPLID |
Character(11) |
VARCHAR2(11) NOT NULL |
Employee ID
|
| 2 |
EMPL_RCD |
Number(3,0) |
SMALLINT NOT NULL |
Empl Rcd Nbr
|
| 3 |
EFFDT |
Date(10) |
DATE |
Effective Date
|
| 4 |
EFFSEQ |
Number(3,0) |
SMALLINT NOT NULL |
Effective Sequence
|
| 5 |
WORKING_HOURS |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Working Hours
|
| 6 |
THEORETICAL_DAYS |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Theoretical Working Days
|
| 7 |
LOST_DAYS |
Number(8,2) |
DECIMAL(7,2) NOT NULL |
Lost Days
|