[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | View over the staging table igs_as_ord_itm_int, which stores data temporarily before moving to document details table |
| Implementation/DBA Data: | Not implemented in this database |
SELECT INT.ROWID
, INT.ORDER_NUMBER
, INT.PERSON_ID
, INT.DOCUMENT_TYPE
, INT.DOCUMENT_SUB_TYPE
, INT.ITEM_NUMBER
, INT.ITEM_STATUS
, INT.DATE_PRODUCED
, INT.NUM_OF_COPIES
, INT.PROGRAMS_ON_FILE
, INT.COMMENTS
, INT.RECIP_PERS_NAME
, INT.RECIP_INST_NAME
, INT.RECIP_ADDR_LINE_1
, INT.RECIP_ADDR_LINE_2
, INT.RECIP_ADDR_LINE_3
, INT.RECIP_ADDR_LINE_4
, INT.RECIP_CITY
, INT.RECIP_POSTAL_CODE
, INT.RECIP_STATE
, INT.RECIP_PROVINCE
, INT.RECIP_COUNTY
, INT.RECIP_COUNTRY
, INT.RECIP_FAX_AREA_CODE
, INT.RECIP_FAX_COUNTRY_CODE
, INT.RECIP_FAX_NUMBER
, INT.DELIVERY_METHOD_TYPE
, INT.DUP_REQUESTED
, INT.DUP_REQ_DATE
, INT.DUP_SENT_DATE
, INT.FGRADE_CAL_TYPE
, INT.FGRADE_SEQ_NUM
, INT.DEGHOLD_CAL_TYPE
, INT.DEGHOLD_SEQ_NUM
, INT.HOLD_FOR_GRADE_CHG
, INT.HOLD_DEGREE_EXPECTED
, INT.HOLD_RELEASE_OF_FINAL_GRADES
, INT.INCL_CURR_COURSE
, INT.MISSING_ACAD_RECORD_DATA_IND
, INT.MISSING_ACADEMIC_RECORD_DATA
, INT.SEND_TRANSCRIPT_IMMEDIATELY
, INT.SPECIAL_INSTR
, INT.EXPRESS_MAIL_TYPE
, INT.EXPRESS_MAIL_TRACK_NUM
, INT.GE_CERTIFICATION
, INT.EXTERNAL_COMMENTS
, INT.INTERNAL_COMMENTS
, INT.ENR_TERM_CAL_TYPE
, INT.ENR_CI_SEQUENCE_NUMBER
, INT.INCL_ATTEMPTED_HOURS
, INT.INCL_CLASS_RANK
, INT.INCL_PROGRESSSION_STATUS
, INT.INCL_CLASS_STANDING
, INT.INCL_CUM_HOURS_EARNED
, INT.INCL_GPA
, INT.INCL_DATE_OF_GRADUATION
, INT.INCL_DEGREE_DATES
, INT.INCL_DEGREE_EARNED
, INT.INCL_DATE_OF_ENTRY
, INT.INCL_DROP_WITHDRAWAL_DATES
, INT.INCL_HRS_EARNED_FOR_CURR_TERM
, INT.INCL_MAJORS
, INT.INCL_LAST_DATE_OF_ENROLLMENT
, INT.INCL_PROFESSIONAL_LICENSURE
, INT.INCL_COLLEGE_AFFILIATION
, INT.INCL_INSTRUCTION_DATES
, INT.INCL_USEC_DATES
, INT.INCL_PROGRAM_ATTEMPT
, INT.INCL_ATTENDENCE_TYPE
, INT.INCL_LAST_TERM_ENROLLED
, INT.INCL_SSN
, INT.INCL_DATE_OF_BIRTH
, INT.INCL_DISCIPLIN_STANDING
, INT.INCL_NO_FUTURE_TERM
, INT.INCL_ACURAT_TILL_COPMP_DT
, INT.INCL_CANT_REL_WITHOUT_SIGN
, INT.CREATED_BY
, INT.CREATION_DATE
, INT.LAST_UPDATED_BY
, INT.LAST_UPDATE_DATE
, INT.LAST_UPDATE_LOGIN
, INT.REQUEST_ID
, INT.PROGRAM_APPLICATION_ID
, INT.PROGRAM_ID
, INT.PROGRAM_UPDATE_DATE
, INT.RECIP_INST_CD
, INT.RECIP_EMAIL
, RANK () OVER (PARTITION BY INT.ORDER_NUMBER ORDER BY INT.ITEM_NUMBER) DISPLAY_ITEM_NUMBER
FROM IGS_AS_ORD_ITM_INT INT