eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: IGSFV_PERSON_OFFICE_HOURS

Product:	IGS - Student System (Obsolete)
Description:	Extension table of HZ_CONTACT_PREFERENCES. This would be useful to store office hours for a staff, Faculty
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT POH.OFFICE_HRS_ID
, POH.CONTACT_PREFERENCE_ID
, HCP.CONTACT_LEVEL_TABLE_ID
, HP.PARTY_NUMBER
, HP.PARTY_NAME
, '_LA:HCP.CONTACT_TYPE:IGS_LOOKUP_VALUES:CONTACT_TYPE:MEANING'
, '_LA:HCP.PREFERENCE_CODE:IGS_LOOKUP_VALUES:PREFERENCE_CODE:MEANING'
, '_LA:HCP.PREFERENCE_TOPIC_TYPE:IGS_LOOKUP_VALUES:PREFERENCE_TOPIC_TYPE:MEANING'
, HCP.PREFERENCE_START_DATE
, HCP.PREFERENCE_END_DATE
, HCP.REASON_CODE
, '_LA:POH.DAY_OF_WEEK_CODE:IGS_LOOKUP_VALUES:IGS_WEEK_DAYS:MEANING'
, POH.START_TM_DATE
, POH.END_TM_DATE
, POH.CREATED_BY
, POH.CREATION_DATE
, POH.LAST_UPDATED_BY
, POH.LAST_UPDATE_DATE
, POH.LAST_UPDATE_LOGIN
FROM IGS_PE_OFFICE_HRS POH
, HZ_CONTACT_PREFERENCES HCP
, HZ_PARTIES HP
WHERE POH.CONTACT_PREFERENCE_ID = HCP.CONTACT_PREFERENCE_ID
AND HCP.CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
AND HCP.CONTACT_LEVEL_TABLE_ID = HP.PARTY_ID WITH READ ONLY

Columns

Name
OFFICE_HRS_IDENTIFIER
CONTACT_PREFERENCE_IDENTIFIER
PERSON_IDENTIFIER
PERSON_NUMBER
PERSON_NAME
"_LA:CONTACT_TYPE"
"_LA:PREFERENCE_CODE"
"_LA:PREFERENCE_TOPIC_TYPE"
PREFERENCE_START_DATE
PREFERENCE_END_DATE
REASON_CODE
"_LA:DAY_OF_WEEK_CODE"
START_TIME_DATE
END_TIME_DATE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN