[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Base View for UCAS Transactions table |
| Implementation/DBA Data: | Not implemented in this database |
SELECT TR.UC_TRAN_ID TRANSACTION_SEQUENCE_ID
, TR.TRANSACTION_ID TRANSACTION_ID
, TR.UPDATER UPDATER
, TR.ERROR_CODE ERROR_CODE
, TR.TRANSACTION_TYPE TRANSACTION_TYPE
, TR.APP_NO APPLICANT_UCAS_NUMBER
, TR.CHOICE_NO APPLICANT_CHOICE_NUMBER
, TR.UCAS_CYCLE UCAS_CYCLE
, TR.DECISION DECISION
, TR.PROGRAM_CODE UCAS_PROGRAM_CODE
, TR.CAMPUS UCAS_CAMPUS
, TR.ENTRY_MONTH ENTRY_MONTH
, TR.ENTRY_YEAR ENTRY_YEAR
, TR.ENTRY_POINT ENTRY_POINT
, TR.SOC SUMMARY_OF_CONDITIONS
, TR.COMMENTS_IN_OFFER COMMENTS_IN_OFFER
, TR.RETURN1 RETURN1
, TR.RETURN2 RETURN2
, TR.HOLD_FLAG HOLD_FLAG
, TR.SENT_TO_UCAS SENT_TO_UCAS_FLAG
, TR.TEST_COND_CAT TEST_CONDITION_CATEGORY
, TR.TEST_COND_NAME TEST_CONDITION_NAME
, TR.INST_REFERENCE INSTITUTION_REFERENCE
, TR.AUTO_GENERATED_FLAG AUTO_GENERATED_FLAG
, TR.SYSTEM_CODE UCAS_SYSTEM_CODE
, TR.MODULAR MODULAR
, TR.PART_TIME PART_TIME
, TR.CREATED_BY CREATED_BY
, TR.CREATION_DATE CREATION_DATE
, TR.LAST_UPDATED_BY LAST_UPDATED_BY
, TR.LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM IGS_UC_TRANSACTIONS TR WITH READ ONLY