SESSION_IDEMPLIDSCHED_DATERS_DF_WO_DATE_W(SQL Table) |
Index Back |
|---|
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SESSION_ID |
Number(6,0) | INTEGER NOT NULL | Session ID |
| 2 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL | Employee ID |
| 3 | SCHED_DATE |
Date(10) | DATE | Schedule Date |
| 4 | BUSY_PROBABILITY | Number(6,4) | DECIMAL(5,4) NOT NULL | Busy Probability |
| 5 | PERCENT_DAY_BUSY | Number(6,4) | DECIMAL(5,4) NOT NULL | Percent Day Busy |
| 6 | STD_DAY_PERCENT | Number(7,4) | DECIMAL(6,4) NOT NULL | The standard work day represented as a ratio of the worker's standard day to the general standard day. |