[Home] [Help] [Dependency Information]
Object Name: | IGSBV_AS_DOCUMENT_DETAILS |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGSBV_AS_DOCUMENT_DETAILS |
Subobject Name: | |
Status: | VALID |
A Business Intelligence System view
Shows the information about the documents associated with the order
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ITEM_NUMBER | NUMBER | (15) | Yes | Indicates the Item number in the Order |
ORDER_NUMBER | NUMBER | (15) | Yes | Request Number of the request for Documents. |
_LA:DOCUMENT_TYPE | CHAR | (64) | Specifies the type of document that are ordered | |
_LA:DOCUMENT_SUB_TYPE | CHAR | (72) | Indicates the transcript type requested by the student. | |
_LA:ITEM_STATUS | CHAR | (60) | Status of the Document | |
DATE_PRODUCED | DATE | Indicates the date the document was produced. | ||
INCL_CURR_COURSE | VARCHAR2 | (1) | 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) | Recipient Name is always data-entered by the requester and stored explicitly. | |
RECIP_INST_NAME | VARCHAR2 | (240) | Recipient Institution name. | |
RECIP_ADDR_LINE_1 | VARCHAR2 | (240) | Yes | Indicates the recipient's address, as found in TCA, data-entered or corrected. |
RECIP_ADDR_LINE_2 | VARCHAR2 | (240) | Indicates the recipient's address, as found in TCA, data-entered or corrected. | |
RECIP_ADDR_LINE_3 | VARCHAR2 | (240) | Indicates the recipient's address, as found in TCA, data-entered or corrected. | |
RECIP_ADDR_LINE_4 | VARCHAR2 | (240) | Indicates the recipient's address, as found in TCA, data-entered or corrected. | |
RECIP_CITY | VARCHAR2 | (60) | Indicates the recipient's city. | |
RECIP_POSTAL_CODE | VARCHAR2 | (60) | Indicates the recipient's postal code | |
RECIP_STATE | VARCHAR2 | (60) | Indicates the recipient's state. | |
RECIP_PROVINCE | VARCHAR2 | (60) | Indicates the recipient's province. | |
RECIP_COUNTY | VARCHAR2 | (60) | Indicates the recipient's county. | |
RECIP_COUNTRY | VARCHAR2 | (60) | Yes | Indicates the recipient's country. |
RECIP_FAX_AREA_CODE | VARCHAR2 | (10) | Indicates recipient's fax area code. Will be used if the delivery method is fax. | |
RECIP_FAX_COUNTRY_CODE | VARCHAR2 | (10) | 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. | |
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. | |
HOLD_DEGREE_EXPECTED | VARCHAR2 | (1) | Whether Degree Expected at the end of teaching period should be held. | |
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) | Carrier's mail type | |
EXPRESS_MAIL_TRACK_NUM | VARCHAR2 | (30) | Carrier's mail tracking number. | |
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) | Whether the duplicate of the document is requested or not. | |
DUP_REQ_DATE | DATE | Date on which duplicate was requested | ||
DUP_SENT_DATE | DATE | Date on which the duplicate t document was produced and sent. | ||
INCL_ATTEMPTED_HOURS | VARCHAR2 | (1) | Include the Attempted hours the enrollment certification. | |
INCL_CLASS_RANK | VARCHAR2 | (1) | Indicates whether the Class Rank will appear on the enrollment certification. | |
INCL_PROGRESSSION_STATUS | VARCHAR2 | (1) | Whether the Progression status will appear on the enrollment certification. | |
INCL_CLASS_STANDING | VARCHAR2 | (1) | Whether the Class standing will appear on the enrollment certification. | |
INCL_CUM_HOURS_EARNED | VARCHAR2 | (1) | Whether Cumulative hours earned will appear on the enrollment certification. | |
INCL_GPA | VARCHAR2 | (1) | Whether the GPA of the student will appear on the enrollment certification. | |
INCL_DATE_OF_GRADUATION | VARCHAR2 | (1) | 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) | 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) | Whether Drop or withdrawal dates will appear on the enrollment certification. | |
INCL_HRS_EARNED_FOR_CURR_TERM | VARCHAR2 | (1) | Include Hours earned for the current term 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) | Whether Last date of enrollment will appear on the enrollment certification. | |
INCL_PROFESSIONAL_LICENSURE | VARCHAR2 | (1) | Include Professional Licensure information on the enrollment certification. | |
INCL_COLLEGE_AFFILIATION | VARCHAR2 | (1) | Whether the College affiliation will appear on the enrollment certification. | |
INCL_INSTRUCTION_DATES | VARCHAR2 | (1) | Whether the Instruction dates will appear on the enrollment certification. | |
INCL_USEC_DATES | VARCHAR2 | (1) | Whether the Unit section dates will appear on the enrollment certification. | |
INCL_PROGRAM_ATTEMPT | VARCHAR2 | (1) | Include the Program attempt information on the enrollment certification. | |
INCL_ATTENDENCE_TYPE | VARCHAR2 | (1) | Include the Attendance type information like Full Time/Part time on the enrollment certification. | |
INCL_LAST_TERM_ENROLLED | VARCHAR2 | (1) | Include the Last term enrolled on the enrollment certification. | |
INCL_SSN | VARCHAR2 | (1) | Include the Social security number 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) | Include the Disciplinary standing the enrollment certification | |
INCL_NO_FUTURE_TERM | VARCHAR2 | (1) | Include the disclaimer enrollment certification, which says We do not include future term. | |
INCL_ACURAT_TILL_COPMP_DT | VARCHAR2 | (1) | Include he disclaimer 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. | |
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 honors 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 status 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 | |
DOC_FEE_PER_COPY | NUMBER | Document Fee | ||
DELIVERY_FEE | NUMBER | Delivery Fee | ||
RECIP_EMAIL | VARCHAR2 | (2000) | Recipient Email | |
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. | ||
DELIVERY_METHOD_TYPE | VARCHAR2 | (30) | Yes | Delivery method for the document. |
DOC_PURPOSE_CODE | VARCHAR2 | (30) | Code for purpose of ordering the transcript | |
FGRADE_CAL_TYPE | VARCHAR2 | (10) | Indicates the teaching period for which to wait for final grades to be entered. | |
FGRADE_SEQ_NUM | NUMBER | (6) | Indicates the teaching period for which to wait for final grades to be entered. | |
DEGHOLD_CAL_TYPE | VARCHAR2 | (10) | Indicates the teaching period for which to wait for degree to be entered | |
DEGHOLD_SEQ_NUM | NUMBER | (6) | Indicates the teaching period for which to wait for degree to be entered | |
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. | |
PLAN_ID | NUMBER | (15) | Plan ID for payment plan | |
PRODUCED_BY | NUMBER | (15) | Document Produced by person ID | |
PERSON_ID | NUMBER | (15) | Person ID against whom order is placed | |
RECIP_INST_CD | VARCHAR2 | (30) | Code for the recipient institution. | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT ITEM_NUMBER
, ORDER_NUMBER
, _LA:DOCUMENT_TYPE
, _LA:DOCUMENT_SUB_TYPE
, _LA:ITEM_STATUS
, 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 APPS.IGSBV_AS_DOCUMENT_DETAILS;
APPS.IGSBV_AS_DOCUMENT_DETAILS is not referenced by any database object
|
|
|