[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_AS_DOC_DETAILS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_AS_DOC_DETAILS_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This view stores stores the information regarding the documents associated with the orders.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ROW_ID | ROWID | (10) | Row id | |
| PLAN_ID | NUMBER | (15) | Plan ID for payment plan | |
| DELIVERY_FEE | NUMBER | Delivery Fee | ||
| DOC_FEE_PER_COPY | NUMBER | Document Fee | ||
| AMOUNT_DELIVERY_FEE | NUMBER | Amount Delivery Fee | ||
| AMOUNT_DUE | NUMBER | Amount Due | ||
| OVERRIDDEN_DOC_DELIVERY_FEE | NUMBER | (18) | Overridden document delivery fees. | |
| OVERRIDDEN_DOCUMENT_FEE | NUMBER | (18) | Overridden document fees. | |
| FEE_OVERRIDDEN_BY | NUMBER | (15) | Fees overridden by. | |
| FEE_OVERRIDDEN_DATE | DATE | Fees overridden date. | ||
| DOC_PURPOSE_CODE | VARCHAR2 | (30) | Code for purpose of ordering the transcript | |
| INCL_DEPARTMENT | VARCHAR2 | (1) | Include Department Information in Enrollment certificate | |
| INCL_FIELD_OF_STDY | VARCHAR2 | (1) | Include Field of Study Information in Enrollment certificate | |
| INCL_ATTEND_MODE | VARCHAR2 | (1) | Include Attendance Mode Information in Enrollment certificate | |
| INCL_YOP_ACAD_PRD | VARCHAR2 | (1) | Include Year of Program and Academic period Information in Enrollment certificate | |
| INCL_INTRMSN_ST_END | VARCHAR2 | (1) | Include Intermission start and end dates | |
| INCL_HNRS_LVL | VARCHAR2 | (1) | Include honours level Information in Enrollment certificate | |
| INCL_AWARDS | VARCHAR2 | (1) | Include awards Information in Enrollment certificate | |
| INCL_AWARD_AIM | VARCHAR2 | (1) | Include award aims Information in Enrollment certificate | |
| INCL_ACAD_SESSIONS | VARCHAR2 | (1) | Include Academic sessions Information in Enrollment certificate | |
| INCL_ST_END_ACAD_SES | VARCHAR2 | (1) | Include start and end date of each academic session Information in Enrollment certificate | |
| INCL_HESA_NUM | VARCHAR2 | (1) | Include HESA number in Enrollment certificate | |
| INCL_LOCATION | VARCHAR2 | (1) | Include Location Information in Enrollment certificate | |
| INCL_PROGRAM_TYPE | VARCHAR2 | (1) | Include Program type Information in Enrollment certificate | |
| INCL_PROGRAM_NAME | VARCHAR2 | (1) | Include Program Name Information in Enrollment certificate | |
| INCL_PROG_ATMPT_STAT | VARCHAR2 | (1) | Include Program attempt status Information in Enrollment certificate | |
| INCL_PROG_ATMPT_END | VARCHAR2 | (1) | Include Program attempt end date Information in Enrollment certificate | |
| INCL_PROG_ATMPT_STRT | VARCHAR2 | (1) | Include Program attempt start date Information in Enrollment certificate | |
| INCL_REQ_CMPLETE | VARCHAR2 | (1) | Include Requirements complete flag Information in Enrollment certificate | |
| INCL_EXPECTED_COMPL_DT | VARCHAR2 | (1) | Include Requirements complete flag Information in Enrollment certificate | |
| INCL_CONFERRAL_DT | VARCHAR2 | (1) | Include Conferral dates Information in Enrollment certificate | |
| INCL_THESIS_TITLE | VARCHAR2 | (1) | Include Thesis title Information in Enrollment certificate | |
| INCL_PROGRAM_CODE | VARCHAR2 | (1) | Include Program Code Information in Enrollment certificate | |
| INCL_PROGRAM_VER | VARCHAR2 | (1) | Include Program version Information in Enrollment certificate | |
| INCL_STUD_NO | VARCHAR2 | (1) | Include Student Number Information in Enrollment certificate | |
| INCL_SURNAME | VARCHAR2 | (1) | Include Surname Information in Enrollment certificate | |
| INCL_FORE_NAME | VARCHAR2 | (1) | Include ForeNames Information in Enrollment certificate | |
| INCL_PREV_NAMES | VARCHAR2 | (1) | Include Previous Names Information in Enrollment certificate | |
| INCL_INITIALS | VARCHAR2 | (1) | Include Initials Information in Enrollment certificate | |
| ORDER_NUMBER | NUMBER | (15) | Yes | Request Number of the request for Documents. Sequence generated.Sequence Generated Column |
| DOCUMENT_TYPE | VARCHAR2 | (30) | Yes | Specifies the type of document that are ordered. The value may be Like TRANSCRIPT','ENROLLMENT CERTIFICATION' |
| DOCUMENT_SUB_TYPE | VARCHAR2 | (30) | Yes | Indicates the transcript type requested by the student. Values will be like 'Official', 'Unofficial' etc. |
| ITEM_NUMBER | NUMBER | (15) | Yes | Indicates the Item number in the Order |
| ITEM_STATUS | VARCHAR2 | (30) | Status of the Document | |
| DATE_PRODUCED | DATE | Indicates the date the document was produced. | ||
| INCL_CURR_COURSE | VARCHAR2 | (1) | Indicates whether to include the courses, which are currently in progress in the transcript. | |
| NUM_OF_COPIES | NUMBER | (15) | Yes | Indicates the number of copies of the documents requested |
| COMMENTS | VARCHAR2 | (240) | Indicates the purpose for which this document is requested | |
| RECIP_PERS_NAME | VARCHAR2 | (240) | Recipien'st Name is always data-entered by the requester and stored explicitly. | |
| RECIP_INST_CD | VARCHAR2 | (30) | Code for the recipient institution. | |
| RECIP_INST_NAME | VARCHAR2 | (240) | Please note that the organization may be either registered in the TCA or not. So, Name is stored explicitly as found in TCA, data-entered or corrected. | |
| RECIP_ADDR_LINE_1 | VARCHAR2 | (240) | Yes | Indicates the recipient's Line 1 of address, as found in TCA, data-entered or corrected. |
| RECIP_ADDR_LINE_2 | VARCHAR2 | (240) | Indicates the recipient's Line 2 of address, as found in TCA, data-entered or corrected. | |
| RECIP_ADDR_LINE_3 | VARCHAR2 | (240) | Indicates the recipient's Line 3 of address, as found in TCA, data-entered or corrected. | |
| RECIP_ADDR_LINE_4 | VARCHAR2 | (240) | Indicates the recipient's Line 4 of address, as found in TCA, data-entered or corrected. | |
| RECIP_CITY | VARCHAR2 | (60) | Indicates the recipient's city of address, as found in TCA, data-entered or corrected. | |
| RECIP_POSTAL_CODE | VARCHAR2 | (60) | Indicates the recipient's postal code of address, as found in TCA, data-entered or corrected. | |
| RECIP_STATE | VARCHAR2 | (60) | Indicates the recipient's State of address, as found in TCA, data-entered or corrected. | |
| RECIP_PROVINCE | VARCHAR2 | (60) | Indicates the recipient's Province of address, as found in TCA, data-entered or corrected. | |
| RECIP_COUNTY | VARCHAR2 | (60) | Indicates the recipient's county of address, as found in TCA, data-entered or corrected. | |
| RECIP_COUNTRY | VARCHAR2 | (60) | Yes | Indicates the recipient's address, as found in TCA, data-entered or corrected. |
| RECIP_FAX_AREA_CODE | VARCHAR2 | (10) | Indicates the recipient's fax area code. Will be used if the delivery method is fax. | |
| RECIP_FAX_COUNTRY_CODE | VARCHAR2 | (10) | Indicates the recipient's fax country code. Will be used if the delivery method is fax. | |
| RECIP_FAX_NUMBER | VARCHAR2 | (40) | Indicates the recipient's fax number. Will be used if the delivery method is fax. | |
| DELIVERY_METHOD_TYPE | VARCHAR2 | (30) | Yes | This value is the result of the requester selecting from an LOV or pre-populated by the program if EDI required to an EDI partner option is enabled and the associated receiving institution is an EDI partner. |
| PROGRAMS_ON_FILE | VARCHAR2 | (100) | Programs on File which should be displayed on the transcript | |
| MISSING_ACAD_RECORD_DATA_IND | VARCHAR2 | (1) | Missing Academic Record Data Indicator | |
| MISSING_ACADEMIC_RECORD_DATA | VARCHAR2 | (2000) | Missing Academic Record Data | |
| SEND_TRANSCRIPT_IMMEDIATELY | VARCHAR2 | (1) | Indicates whether Transcript should be sent Immediately | |
| HOLD_RELEASE_OF_FINAL_GRADES | VARCHAR2 | (1) | Indicates whether Final Grades should be held for release. | |
| FGRADE_CAL_TYPE | VARCHAR2 | (10) | Indicates the teaching period for which to wait for final grades to be entered - if checked should be added to hold file. | |
| FGRADE_SEQ_NUM | NUMBER | (6) | Indicates the teaching period for which to wait for final grades to be entered - if checked should be added to hold file. | |
| HOLD_DEGREE_EXPECTED | VARCHAR2 | (1) | Indicates whether Degree Expected at the end of teaching period should be held. | |
| DEGHOLD_CAL_TYPE | VARCHAR2 | (10) | Indicates the teaching period for which to wait for degree to be entered - if checked should be added to hold file. | |
| DEGHOLD_SEQ_NUM | NUMBER | (6) | Indicates the teaching period for which to wait for degree to be entered - if checked should be added to hold file. | |
| HOLD_FOR_GRADE_CHG | VARCHAR2 | (1) | Indicates whether the hold for grade changes is applicable or not. | |
| SPECIAL_INSTR | VARCHAR2 | (240) | Indicates special Instruction. | |
| EXPRESS_MAIL_TYPE | VARCHAR2 | (30) | Manually populated by an Administrator with the carrier name if the requester chooses a delivery method that has a carrier associated with it. | |
| EXPRESS_MAIL_TRACK_NUM | VARCHAR2 | (30) | Indicates whether the duplicate of the document is requested or not. Default value is 'N' | |
| GE_CERTIFICATION | VARCHAR2 | (255) | Holds the General Education certification details | |
| EXTERNAL_COMMENTS | VARCHAR2 | (255) | Holds the external comments | |
| INTERNAL_COMMENTS | VARCHAR2 | (255) | Holds the internal comments | |
| DUP_REQUESTED | VARCHAR2 | (1) | Indicates whether the duplicate is requested or not. Default value is 'N' | |
| DUP_REQ_DATE | DATE | Date on which the duplicate was requested. | ||
| DUP_SENT_DATE | DATE | Date on which the duplicate document was produced and sent. | ||
| ENR_TERM_CAL_TYPE | VARCHAR2 | (10) | Calendar Type that will determine the information that will appear on Enrollment certification | |
| ENR_CI_SEQUENCE_NUMBER | NUMBER | (6) | Sequence number for the Calendar Type that will determine the term that will appear on Enrollment certification. This is mandatory for Enrollment Certification. | |
| INCL_ATTEMPTED_HOURS | VARCHAR2 | (1) | Indicates whether the Attempted hours will appear on the enrollment certification. | |
| INCL_CLASS_RANK | VARCHAR2 | (1) | Indicates whether the Class Rank will appear on the enrollment certification. | |
| INCL_PROGRESSSION_STATUS | VARCHAR2 | (1) | Indicates whether the Progression status will appear on the enrollment certification. | |
| INCL_CLASS_STANDING | VARCHAR2 | (1) | Indicates whether the Class standing will appear on the enrollment certification. | |
| INCL_CUM_HOURS_EARNED | VARCHAR2 | (1) | Indicates whether the Cumulative hours earned will appear on the enrollment certification. | |
| INCL_GPA | VARCHAR2 | (1) | Indicates whether the GPA of the student will appear on the enrollment certification. | |
| INCL_DATE_OF_GRADUATION | VARCHAR2 | (1) | Indicates whether the Date of graduation will appear on the enrollment certification. | |
| INCL_DEGREE_DATES | VARCHAR2 | (1) | Indicates whether Degree Dates will appear on the enrollment certification. | |
| INCL_DEGREE_EARNED | VARCHAR2 | (1) | Indicates whether the Degree Earned will appear on the enrollment certification. | |
| INCL_DATE_OF_ENTRY | VARCHAR2 | (1) | Indicates whether the Date of entry will appear on the enrollment certification. | |
| INCL_DROP_WITHDRAWAL_DATES | VARCHAR2 | (1) | Indicates whether the Drop or withdrawal dates will appear on the enrollment certification. | |
| INCL_HRS_EARNED_FOR_CURR_TERM | VARCHAR2 | (1) | Indicates whether the Hours earned for the current term will appear on the enrollment certification. | |
| INCL_MAJORS | VARCHAR2 | (1) | Indicates whether the Majors will appear on the enrollment certification. | |
| INCL_LAST_DATE_OF_ENROLLMENT | VARCHAR2 | (1) | Indicates whether the Last date of enrollment will appear on the enrollment certification. | |
| INCL_PROFESSIONAL_LICENSURE | VARCHAR2 | (1) | Indicates whether the Professional Licensure information will appear on the enrollment certification. | |
| INCL_COLLEGE_AFFILIATION | VARCHAR2 | (1) | Indicates whether the College affiliation will appear on the enrollment certification. | |
| INCL_INSTRUCTION_DATES | VARCHAR2 | (1) | Indicates whether the Instruction dates will appear on the enrollment certification. | |
| INCL_USEC_DATES | VARCHAR2 | (1) | Indicates whether the Unit section dates will appear on the enrollment certification. | |
| INCL_PROGRAM_ATTEMPT | VARCHAR2 | (1) | Indicates whether the Program attempt information will appear on the enrollment certification. | |
| INCL_ATTENDENCE_TYPE | VARCHAR2 | (1) | Indicates whether the Attendance type information like Full Time/Part time will appear on the enrollment certification. | |
| INCL_LAST_TERM_ENROLLED | VARCHAR2 | (1) | Indicates whether the Last term enrolled will appear on the enrollment certification. | |
| INCL_SSN | VARCHAR2 | (1) | Indicates whether the Social security number will appear on the enrollment certification. | |
| INCL_DATE_OF_BIRTH | VARCHAR2 | (1) | Indicates whether the Date of Birth will appear on the enrollment certification | |
| INCL_DISCIPLIN_STANDING | VARCHAR2 | (1) | Indicates whether the Disciplinary standing will appear on the enrollment certification | |
| INCL_NO_FUTURE_TERM | VARCHAR2 | (1) | Indicates The disclaimer that will appear on enrollment certification, which says We do not include future term. | |
| INCL_ACURAT_TILL_COPMP_DT | VARCHAR2 | (1) | Indicates The disclaimer that will appear on enrollment certification, which says Information is accurate till the completion date. | |
| INCL_CANT_REL_WITHOUT_SIGN | VARCHAR2 | (1) | Indicates That the enrollment certification will not be released without student's signature. | |
| CREATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| CREATION_DATE | DATE | Yes | Standard WHO Column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard WHO Column |
| LAST_UPDATE_DATE | DATE | Yes | Standard WHO Column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| REQUEST_ID | NUMBER | (15) | Standard who column for concurrent programs | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard who column for concurrent programs | |
| PROGRAM_ID | NUMBER | (15) | Standard who column for concurrent programs | |
| PROGRAM_UPDATE_DATE | DATE | Standard who column for concurrent programs | ||
| DELIVERY_METHOD_DESCRIPTION | VARCHAR2 | (80) | Yes | Delivery method |
| DOCUMENT_TYPE_DESC | VARCHAR2 | (80) | Yes | Delivery Type |
| DOC_SUB_TYPE_DESC | VARCHAR2 | (80) | Yes | Delivery Sub Type |
| GRADES_HOLD_CALENDAR | VARCHAR2 | (30) | Grades Holds calendar | |
| DEGREE_HOLD_CALENDAR | VARCHAR2 | (30) | Degree Holds calendar | |
| TERM_CALENDAR | VARCHAR2 | (30) | Term Calendar | |
| PERSON_ID | NUMBER | (15) | Person Number | |
| RECIP_COUNTRY_DESC | VARCHAR2 | (80) | Recipient Country | |
| ITEM_STATUS_DESC | VARCHAR2 | (80) | Item Status | |
| RECIP_EMAIL | VARCHAR2 | (2000) | Recipient Email | |
| PRODUCED_BY | NUMBER | (15) | Document Produced by person ID | |
| PRODUCED_BY_NAME | VARCHAR2 | (360) | Name of this party |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, PLAN_ID
, DELIVERY_FEE
, DOC_FEE_PER_COPY
, AMOUNT_DELIVERY_FEE
, AMOUNT_DUE
, OVERRIDDEN_DOC_DELIVERY_FEE
, OVERRIDDEN_DOCUMENT_FEE
, FEE_OVERRIDDEN_BY
, FEE_OVERRIDDEN_DATE
, DOC_PURPOSE_CODE
, 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
, ORDER_NUMBER
, DOCUMENT_TYPE
, DOCUMENT_SUB_TYPE
, ITEM_NUMBER
, ITEM_STATUS
, DATE_PRODUCED
, INCL_CURR_COURSE
, NUM_OF_COPIES
, COMMENTS
, RECIP_PERS_NAME
, RECIP_INST_CD
, 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
, DELIVERY_METHOD_TYPE
, PROGRAMS_ON_FILE
, MISSING_ACAD_RECORD_DATA_IND
, MISSING_ACADEMIC_RECORD_DATA
, SEND_TRANSCRIPT_IMMEDIATELY
, HOLD_RELEASE_OF_FINAL_GRADES
, FGRADE_CAL_TYPE
, FGRADE_SEQ_NUM
, HOLD_DEGREE_EXPECTED
, DEGHOLD_CAL_TYPE
, DEGHOLD_SEQ_NUM
, 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
, ENR_TERM_CAL_TYPE
, ENR_CI_SEQUENCE_NUMBER
, 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
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, DELIVERY_METHOD_DESCRIPTION
, DOCUMENT_TYPE_DESC
, DOC_SUB_TYPE_DESC
, GRADES_HOLD_CALENDAR
, DEGREE_HOLD_CALENDAR
, TERM_CALENDAR
, PERSON_ID
, RECIP_COUNTRY_DESC
, ITEM_STATUS_DESC
, RECIP_EMAIL
, PRODUCED_BY
, PRODUCED_BY_NAME
FROM APPS.IGS_AS_DOC_DETAILS_V;
APPS
FND_LOOKUP_VALUES
FND_TERRITORIES_TL
HZ_PARTIES
IGS_AS_DOC_DETAILS
IGS_AS_DOC_DLVY_FEE
IGS_AS_DOC_DLVY_TYP
IGS_CA_INST_ALL
APPS.IGS_AS_DOC_DETAILS_V is not referenced by any database object
|
|
|
|