Product: | IGS - Student System (Obsolete) |
---|---|
Description: | Describes Institution Crosswalk Details |
Implementation/DBA Data: | Not implemented in this database |
SELECT OW.ROWID ROW_ID
, OW.CROSSWALK_ID CROSSWALK_ID
, OWD.CROSSWALK_DTL_ID CROSSWALK_DTL_ID
, OW.INSTITUTION_NAME INST_NAME
, OW.INSTITUTION_CODE INST_CODE
, OWD.ALT_ID_TYPE ALT_ID_TYPE
, OWD.ALT_ID_VALUE ALT_ID_VALUE
, OWD.CREATED_BY CREATED_BY
, OWD.CREATION_DATE CREATION_DATE
, OWD.LAST_UPDATED_BY LAST_UPDATED_BY
, OWD.LAST_UPDATE_DATE LAST_UPDATE_DATE
, OWD.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OWD.REQUEST_ID REQUEST_ID
, OWD.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, OWD.PROGRAM_ID PROGRAM_ID
, OWD.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM IGS_OR_CWLK OW
, IGS_OR_CWLK_DTL OWD
WHERE OW.CROSSWALK_ID = OWD.CROSSWALK_ID