[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_ORD_ITM_INT_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGS.IGS_AS_ORD_ITM_INT_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
View over the staging table igs_as_ord_itm_int, which stores data temporarily before moving to document details table
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | Row ID | |
ORDER_NUMBER | NUMBER | (15) | Yes | Request Number of the request for Documents. Sequence generated Column |
PERSON_ID | NUMBER | (15) | Yes | Identity of the Person who requested the Document |
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 Lookup Type = IGS_AS_DOCUMENT_TYPE |
ITEM_NUMBER | NUMBER | (15) | Yes | Indicates the Item number in the Order |
ITEM_STATUS | VARCHAR2 | (30) | Status of the Item | |
DATE_PRODUCED | DATE | Indicates the date the document was produced. | ||
NUM_OF_COPIES | NUMBER | (15) | Indicates the number of copies of the Document requested | |
PROGRAMS_ON_FILE | VARCHAR2 | (100) | Programs on File which should be displayed on the transcript | |
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) | Please note that the organization may be either registered in the TCA or not. So, Name is stored explicitly. | |
RECIP_ADDR_LINE_1 | VARCHAR2 | (240) | Recipient's address line1. | |
RECIP_ADDR_LINE_2 | VARCHAR2 | (240) | Recipient's address line2. | |
RECIP_ADDR_LINE_3 | VARCHAR2 | (240) | Recipient's address line3. | |
RECIP_ADDR_LINE_4 | VARCHAR2 | (240) | Recipient's address line4. | |
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) | Indicates the Recipient's Country. | |
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) | Indicates the delivery method type to be used. This is a user-defined field. | |
DUP_REQUESTED | VARCHAR2 | (1) | Indicates whether the request was submitted for a duplicate transcript. | |
DUP_REQ_DATE | DATE | Indicates whether the request was submitted for a duplicate transcript. | ||
DUP_SENT_DATE | DATE | Duplicate transcript send date. | ||
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. | |
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. | |
HOLD_DEGREE_EXPECTED | VARCHAR2 | (1) | Hold Degree Expected Indicator | |
HOLD_RELEASE_OF_FINAL_GRADES | VARCHAR2 | (1) | Hold Release of Final Grades Indicator | |
INCL_CURR_COURSE | VARCHAR2 | (1) | Include Current Course Indicator | |
MISSING_ACAD_RECORD_DATA_IND | VARCHAR2 | (1) | Indicates if there is some missing information that could not be selected from the choice available. | |
MISSING_ACADEMIC_RECORD_DATA | VARCHAR2 | (2000) | Missing information Text | |
SEND_TRANSCRIPT_IMMEDIATELY | VARCHAR2 | (1) | Indicates if the transcript is to be sent immediately. | |
SPECIAL_INSTR | VARCHAR2 | (240) | Special Instructions | |
EXPRESS_MAIL_TYPE | VARCHAR2 | (30) | Used if student has choosen the method type as overnight / express etc. | |
EXPRESS_MAIL_TRACK_NUM | VARCHAR2 | (30) | Used if the student has chosen the method type as overnight/express etc | |
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 | |
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 information that will appear on 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 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 | ||
RECIP_INST_CD | VARCHAR2 | (30) | Recipient's Institution Code | |
RECIP_EMAIL | VARCHAR2 | (2000) | Recipient's Email address | |
DISPLAY_ITEM_NUMBER | NUMBER | Item number renumbered starting from 1 for each Order Number for the end user. |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, ORDER_NUMBER
, PERSON_ID
, DOCUMENT_TYPE
, DOCUMENT_SUB_TYPE
, ITEM_NUMBER
, ITEM_STATUS
, DATE_PRODUCED
, NUM_OF_COPIES
, PROGRAMS_ON_FILE
, 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
, DELIVERY_METHOD_TYPE
, DUP_REQUESTED
, DUP_REQ_DATE
, DUP_SENT_DATE
, FGRADE_CAL_TYPE
, FGRADE_SEQ_NUM
, DEGHOLD_CAL_TYPE
, DEGHOLD_SEQ_NUM
, HOLD_FOR_GRADE_CHG
, HOLD_DEGREE_EXPECTED
, HOLD_RELEASE_OF_FINAL_GRADES
, INCL_CURR_COURSE
, MISSING_ACAD_RECORD_DATA_IND
, MISSING_ACADEMIC_RECORD_DATA
, SEND_TRANSCRIPT_IMMEDIATELY
, SPECIAL_INSTR
, EXPRESS_MAIL_TYPE
, EXPRESS_MAIL_TRACK_NUM
, GE_CERTIFICATION
, EXTERNAL_COMMENTS
, INTERNAL_COMMENTS
, 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
, RECIP_INST_CD
, RECIP_EMAIL
, DISPLAY_ITEM_NUMBER
FROM APPS.IGS_AS_ORD_ITM_INT_V;
APPS.IGS_AS_ORD_ITM_INT_V is not referenced by any database object
|
|
|