DISP_TMPL_FAM_CDDAYOFWEEKSTART_TIMERC_SSAGTIME_VW(SQL View) |
Index Back |
|---|---|
Provider Group Schedule/TimeStores the days and times of operation for the provider group. |
| SELECT A.DISP_TMPL_FAM_CD , A.DAYOFWEEK , A.START_TIME , A.END_TIME ,B.TIMEZONE ,B.HOLIDAY_SCHEDULE FROM PS_RC_SSAGT_TIME A , PS_RC_SS_AGTSCHDL B WHERE A.DISP_TMPL_FAM_CD =B.DISP_TMPL_FAM_CD |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DISP_TMPL_FAM_CD |
Character(30) | VARCHAR2(30) NOT NULL | Display Template Family Code |
| 2 | DAYOFWEEK |
Number(1,0) | SMALLINT NOT NULL | Day of Week |
| 3 | START_TIME |
Time(15) | TIMESTAMP | Start of Shift |
| 4 | END_TIME | Time(15) | TIMESTAMP | End of Shift |
| 5 | TIMEZONE | Character(9) | VARCHAR2(9) NOT NULL | Time Zone |
| 6 | HOLIDAY_SCHEDULE | Character(6) | VARCHAR2(6) NOT NULL | This is the holiday schedule field. |