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: IGS_PE_CREDENTIALS_V

Product:	IGS - Student System (Obsolete)
Description:	Holds credential details for a person
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT C.ROWID ROW_ID
, C.CREDENTIAL_ID
, CT.CREDENTIAL_TYPE
, CT.SYSTEM_TYPE
, CT.DESCRIPTION CT_DESCRIPTION
, C.PERSON_ID
, C.CREDENTIAL_TYPE_ID
, C.DATE_RECEIVED
, C.RATING_CODE
, CC.MEANING RATING_DESCRIPTION
, C.REVIEWER_ID
, P.PERSON_NUMBER REVIEWER_NUMBER
, P.FULL_NAME REVIEWER_NAME
, C.REVIEWER_NOTES
, C.RECOMMENDER_NAME
, C.RECOMMENDER_TITLE
, C.RECOMMENDER_ORGANIZATION
, C.CREATED_BY
, C.CREATION_DATE
, C.LAST_UPDATED_BY
, C.LAST_UPDATE_DATE
, C.LAST_UPDATE_LOGIN
FROM IGS_PE_CREDENTIALS C
, IGS_AD_CRED_TYPES CT
, IGS_LOOKUP_VALUES CC
, IGS_PE_PERSON_BASE_V P
WHERE C.CREDENTIAL_TYPE_ID = CT.CREDENTIAL_TYPE_ID
AND C.RATING_CODE = CC.LOOKUP_CODE (+)
AND CC.LOOKUP_TYPE(+) ='PE_CRE_RATING'
AND C.REVIEWER_ID = P.PERSON_ID (+)

Columns

Name
ROW_ID
CREDENTIAL_ID
CREDENTIAL_TYPE
SYSTEM_TYPE
CT_DESCRIPTION
PERSON_ID
CREDENTIAL_TYPE_ID
DATE_RECEIVED
RATING_CODE
RATING_DESCRIPTION
REVIEWER_ID
REVIEWER_NUMBER
REVIEWER_NAME
REVIEWER_NOTES
RECOMMENDER_NAME
RECOMMENDER_TITLE
RECOMMENDER_ORGANIZATION
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN