[Home] [Help]
View: IGSBV_PERSON_TYPE_MAPPINGS
Product: | IGS - Student System (Obsolete) |
Description: | This entity contains information about the mapping between the Student System defined person types and HRMS defined person types. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PTM.PERSON_TYPE_CODE
, 'LA:PTM.SYSTEM_TYPE:IGS_LOOKUP_VALUES:SYSTEM_PERSON_TYPES:MEANING'
, PPT.DESCRIPTION
, HPT.USER_PERSON_TYPE
, PTM.PER_PERSON_TYPE_ID
, PTM.CREATED_BY
, PTM.CREATION_DATE
, PTM.LAST_UPDATED_BY
, PTM.LAST_UPDATE_DATE
FROM IGS_PE_PER_TYPE_MAP PTM
, IGS_PE_PERSON_TYPES PPT
, PER_PERSON_TYPES HPT
WHERE PTM.PERSON_TYPE_CODE=PPT.PERSON_TYPE_CODE
AND PTM.PER_PERSON_TYPE_ID=HPT.PERSON_TYPE_ID WITH READ ONLY
Columns
Name |
PERSON_TYPE_CODE |
"LA:SYSTEM_TYPE" |
PERSON_TYPE_DESCRIPTION |
HR_PERSON_TYPE |
HR_PERSON_TYPE_ID |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |