[Home] [Help]
View: IGSFV_AS_ANONYMOUS_ID_PROGS
Product: | IGS - Student System (Obsolete) |
Description: | Holds the person with the assigned Anonymous ID for the Method PROGRAM. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT HP.PARTY_NAME
, HP.PARTY_NUMBER
, APS.ANONYMOUS_ID
, '_LA:APS.SYSTEM_GENERATED_IND:IGS_LOOKUP_VALUES:YES_NO:MEANING'
, APS.COURSE_CD
, CRV.TITLE
, APS.PERSON_ID
, APS.CREATED_BY
, APS.CREATION_DATE
, APS.LAST_UPDATED_BY
, APS.LAST_UPDATE_DATE
FROM HZ_PARTIES HP
, IGS_AS_ANON_ID_PS APS
, IGS_PS_VER_ALL CRV
, IGS_EN_STDNT_PS_ATT_ALL SPA
WHERE APS.PERSON_ID = HP.PARTY_ID
AND SPA.COURSE_CD = CRV.COURSE_CD
AND SPA.VERSION_NUMBER = CRV.VERSION_NUMBER
AND APS.PERSON_ID = SPA.PERSON_ID
AND APS.COURSE_CD = SPA.COURSE_CD WITH READ ONLY
Columns
Name |
PERSON_NAME |
PERSON_NUMBER |
ANONYMOUS_ID |
"_LA:SYSTEM_GENERATED_IND" |
PROGRAM_CODE |
PROGRAM_TITLE |
PERSON_ID |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |