[Home] [Help]
View: IGS_PE_PER_TYPE_MAP_V
| Product: | IGS - Student System (Obsolete) |
|---|
| Description: | Stores the defined mapping between OSS and HR Person Types |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT MAP.ROWID
, MAP.PERSON_TYPE_CODE
, MAP.SYSTEM_TYPE
, MAP.PER_PERSON_TYPE_ID HR_PERSON_TYPE_ID
, TYP.USER_PERSON_TYPE HR_PERSON_TYPE
, TYP.SYSTEM_NAME HR_SYSTEM_TYPE_DESC
, MAP.CREATED_BY
, MAP.CREATION_DATE
, MAP.LAST_UPDATED_BY
, MAP.LAST_UPDATE_DATE
, MAP.LAST_UPDATE_LOGIN
FROM IGS_PE_PER_TYPE_MAP MAP
, PER_PERSON_TYPES_V TYP
WHERE MAP.PER_PERSON_TYPE_ID = TYP.PERSON_TYPE_ID
Columns
| Name |
| ROW_ID |
| PERSON_TYPE_CODE |
| SYSTEM_TYPE |
| HR_PERSON_TYPE_ID |
| HR_PERSON_TYPE |
| HR_SYSTEM_TYPE_DESC |
| CREATED_BY |
| CREATION_DATE |
| LAST_UPDATED_BY |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |