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_PRIVACY_DETAILS

Product:	IGS - Student System (Obsolete)
Description:	This entity contains information about the privacy details of a person.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT PPL.DATA_GROUP
, PPL.LVL
, '_LA:PPL.ACTION:IGS_LOOKUP_VALUES:PERSON_PRIVACY_ACTION:MEANING'
, '_LA:PPL.WHOM:IGS_LOOKUP_VALUES:PARTY_RELATIONS_TYPE:MEANING'
, PPL.START_DATE
, PPL.END_DATE
, GEN.NOTE_TEXT
, PDG.DESCRIPTION
, HZP.PARTY_NUMBER
, PPL.PRIVACY_LEVEL_ID
, PPL.PERSON_ID
, PPL.DATA_GROUP_ID
, PPL.REF_NOTES_ID
, PPL.CREATION_DATE
, PPL.CREATED_BY
, PPL.LAST_UPDATED_BY
, PPL.LAST_UPDATE_DATE
FROM IGS_PE_PRIV_LEVEL PPL
, HZ_PARTIES HZP
, IGS_PE_DATA_GROUPS_ALL PDG
, IGS_GE_NOTE GEN
WHERE PPL.PERSON_ID=HZP.PARTY_ID
AND PPL.DATA_GROUP_ID=PDG.DATA_GROUP_ID
AND GEN.REFERENCE_NUMBER(+)=PPL.REF_NOTES_ID WITH READ ONLY

Columns

Name
DATA_GROUP
LVL
"_LA:ACTION"
"_LA:TO_WHOM"
START_DATE
END_DATE
NOTE_TEXT
LEVEL_DESCRIPTION
PERSON_NUMBER
PRIVACY_LEVEL_ID
PERSON_ID
DATA_GROUP_ID
REF_NOTES_ID
CREATION_DATE
CREATED_BY
LAST_UPDATED_BY
LAST_UPDATE_DATE