[Home] [Help]
| Product: | IGS - Student System (Obsolete) |
|---|---|
| Description: | Shows the information about the documents associated with the order |
| Implementation/DBA Data: | Not implemented in this database |
SELECT ITEM_NUMBER
, ORDER_NUMBER
, '_LA:DOCUMENT_TYPE:IGS_LOOKUP_VALUES:IGS_AS_DOCUMENT_TYPE:MEANING'
, '_LA:DOCUMENT_SUB_TYPE:IGS_LOOKUP_VALUES:IGS_AS_DOCUMENT_SUB_TYPE:MEANING'
, '_LA:ITEM_STATUS:IGS_LOOKUP_VALUES:IGS_AS_ITEM_STATUS:MEANING'
, DATE_PRODUCED
, INCL_CURR_COURSE
, NUM_OF_COPIES
, COMMENTS
, RECIP_PERS_NAME
, RECIP_INST_NAME
, RECIP_ADDR_LINE_1
, RECIP_ADDR_LINE_2
, RECIP_ADDR_LINE_3
, RECIP_ADDR_LINE_4
, RECIP_CITY
, RECIP_POSTAL_CODE
, RECIP_STATE
, RECIP_PROVINCE
, RECIP_COUNTY
, RECIP_COUNTRY
, RECIP_FAX_AREA_CODE
, RECIP_FAX_COUNTRY_CODE
, RECIP_FAX_NUMBER
, PROGRAMS_ON_FILE
, MISSING_ACAD_RECORD_DATA_IND
, MISSING_ACADEMIC_RECORD_DATA
, SEND_TRANSCRIPT_IMMEDIATELY
, HOLD_RELEASE_OF_FINAL_GRADES
, HOLD_DEGREE_EXPECTED
, HOLD_FOR_GRADE_CHG
, SPECIAL_INSTR
, EXPRESS_MAIL_TYPE
, EXPRESS_MAIL_TRACK_NUM
, GE_CERTIFICATION
, EXTERNAL_COMMENTS
, INTERNAL_COMMENTS
, DUP_REQUESTED
, DUP_REQ_DATE
, DUP_SENT_DATE
, INCL_ATTEMPTED_HOURS
, INCL_CLASS_RANK
, INCL_PROGRESSSION_STATUS
, INCL_CLASS_STANDING
, INCL_CUM_HOURS_EARNED
, INCL_GPA
, INCL_DATE_OF_GRADUATION
, INCL_DEGREE_DATES
, INCL_DEGREE_EARNED
, INCL_DATE_OF_ENTRY
, INCL_DROP_WITHDRAWAL_DATES
, INCL_HRS_EARNED_FOR_CURR_TERM
, INCL_MAJORS
, INCL_LAST_DATE_OF_ENROLLMENT
, INCL_PROFESSIONAL_LICENSURE
, INCL_COLLEGE_AFFILIATION
, INCL_INSTRUCTION_DATES
, INCL_USEC_DATES
, INCL_PROGRAM_ATTEMPT
, INCL_ATTENDENCE_TYPE
, INCL_LAST_TERM_ENROLLED
, INCL_SSN
, INCL_DATE_OF_BIRTH
, INCL_DISCIPLIN_STANDING
, INCL_NO_FUTURE_TERM
, INCL_ACURAT_TILL_COPMP_DT
, INCL_CANT_REL_WITHOUT_SIGN
, INCL_DEPARTMENT
, INCL_FIELD_OF_STDY
, INCL_ATTEND_MODE
, INCL_YOP_ACAD_PRD
, INCL_INTRMSN_ST_END
, INCL_HNRS_LVL
, INCL_AWARDS
, INCL_AWARD_AIM
, INCL_ACAD_SESSIONS
, INCL_ST_END_ACAD_SES
, INCL_HESA_NUM
, INCL_LOCATION
, INCL_PROGRAM_TYPE
, INCL_PROGRAM_NAME
, INCL_PROG_ATMPT_STAT
, INCL_PROG_ATMPT_END
, INCL_PROG_ATMPT_STRT
, INCL_REQ_CMPLETE
, INCL_EXPECTED_COMPL_DT
, INCL_CONFERRAL_DT
, INCL_THESIS_TITLE
, INCL_PROGRAM_CODE
, INCL_PROGRAM_VER
, INCL_STUD_NO
, INCL_SURNAME
, INCL_FORE_NAME
, INCL_PREV_NAMES
, INCL_INITIALS
, DOC_FEE_PER_COPY
, DELIVERY_FEE
, RECIP_EMAIL
, OVERRIDDEN_DOC_DELIVERY_FEE
, OVERRIDDEN_DOCUMENT_FEE
, FEE_OVERRIDDEN_BY
, FEE_OVERRIDDEN_DATE
, DELIVERY_METHOD_TYPE
, DOC_PURPOSE_CODE
, FGRADE_CAL_TYPE
, FGRADE_SEQ_NUM
, DEGHOLD_CAL_TYPE
, DEGHOLD_SEQ_NUM
, ENR_TERM_CAL_TYPE
, ENR_CI_SEQUENCE_NUMBER
, PLAN_ID
, PRODUCED_BY
, PERSON_ID
, RECIP_INST_CD
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
FROM IGS_AS_DOC_DETAILS WITH READ ONLY