Product: | IGS - Student System (Obsolete) |
---|---|
Description: | This entity contains information about the person's military services. |
Implementation/DBA Data: | Not implemented in this database |
SELECT HZP.PARTY_NUMBER
, '_LA:PMS.MILITARY_TYPE_CD:IGS_LOOKUP_VALUES:PE_MIL_SEV_TYPE:MEANING'
, PMS.START_DATE
, PMS.END_DATE
, '_LA:PMS.SEPARATION_TYPE_CD:IGS_LOOKUP_VALUES:PE_MIL_SEP_TYPE:MEANING'
, '_LA:PMS.ASSISTANCE_TYPE_CD:IGS_LOOKUP_VALUES:PE_MIL_ASS_TYPE:MEANING'
, '_LA:PMS.ASSISTANCE_STATUS_CD:IGS_LOOKUP_VALUES:PE_MIL_ASS_STATUS:MEANING'
, '_DF:IGS:IGS_PE_MIL_SERVICE_FLEX:PMS'
, PMS.MILIT_SERVICE_ID
, PMS.PERSON_ID
, PMS.CREATED_BY
, PMS.CREATION_DATE
, PMS.LAST_UPDATED_BY
, PMS.LAST_UPDATE_DATE
FROM IGS_PE_MIL_SERVICES_ALL PMS
, HZ_PARTIES HZP
WHERE PMS.PERSON_ID=HZP.PARTY_ID WITH READ ONLY