[Home] [Help]
[Dependency Information]
[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
APPS.IGS_AS_ORD_ITM_INT_V is not referenced by any database object
|
|
|
|