EMPLIDEMPL_RCDBEGIN_DTABSW_SEQ_NOABSW_TMPL_IDABSW_DAY_NOSTART_TIMEABSW_SCHD_VW(SQL View) |
Index Back |
|---|---|
EE Work Schedule ViewEE Work Schedule View |
| select C.EMPLID ,C.EMPL_RCD ,C.BEGIN_DT ,A.ABSW_SEQ_NO ,B.ABSW_TMPL_ID ,B.ABSW_DAY_NO ,B.START_TIME ,B.END_TIME ,B.DURATION_HOURS ,A.ABSW_SCHD_ID from PS_ABSW_SCHD_DET A ,PS_ABSW_TMPL_DET B ,PS_ABSW_SCHEDULE C where A.ABSW_TMPL_ID = B.ABSW_TMPL_ID and C.ABSW_SCHD_ID = A.ABSW_SCHD_ID |
| # | 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 | BEGIN_DT |
Date(10) | DATE | Begin Date |
| 4 | ABSW_SEQ_NO |
Number(2,0) | SMALLINT NOT NULL | Sequence Number |
| 5 | ABSW_TMPL_ID |
Character(10) | VARCHAR2(10) NOT NULL | Work Template |
| 6 | ABSW_DAY_NO |
Number(2,0) | SMALLINT NOT NULL | Day Number |
| 7 | START_TIME |
Time(15) | TIMESTAMP | Interview Start Time |
| 8 | END_TIME | Time(15) | TIMESTAMP | Interview End Time |
| 9 | DURATION_HOURS | Number(7,2) | DECIMAL(6,2) NOT NULL | Duration (Hours) |
| 10 | ABSW_SCHD_ID | Character(10) | VARCHAR2(10) NOT NULL | Work Schedule |