[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_AS_ORD_ITM_INT |
|---|---|
| Object Type: | TABLE |
| Owner: | IGS |
| FND Design Data: |  IGS.IGS_AS_ORD_ITM_INT
|
| Subobject Name: | |
| Status: | VALID |
This interface table contains one entry for each document requested as a line item on the associated order. The data is extracted from the OSS production tables and used by the consulting solution for document production. The options included allow determining the content of the requested document. The data will be purged from this table once the document is sent and data about the delivery and administrative entries are moved into the OSS production tables.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGS_AS_ORD_ITM_INT_PK | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 ORDER_NUMBER
ITEM_NUMBER
PERSON_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ORDER_NUMBER | NUMBER | (15) | Yes | Request Number of the request for Documents. Sequence generated.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 Document | |
| 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) | Indicates Line 1 of recipient's address. | |
| RECIP_ADDR_LINE_2 | VARCHAR2 | (240) | Indicates Line 2 of recipient's address. | |
| RECIP_ADDR_LINE_3 | VARCHAR2 | (240) | Indicates Line 3 of recipient's address. | |
| RECIP_ADDR_LINE_4 | VARCHAR2 | (240) | Indicates Line 4 of recipient's address. | |
| RECIP_CITY | VARCHAR2 | (60) | Indicates the city of recipient's address. | |
| RECIP_POSTAL_CODE | VARCHAR2 | (60) | Indicates postal code of recipient's address. | |
| RECIP_STATE | VARCHAR2 | (60) | Indicates state of recipient's address. | |
| RECIP_PROVINCE | VARCHAR2 | (60) | Indicates province of recipient's address. | |
| RECIP_COUNTY | VARCHAR2 | (60) | Indicates county of recipient's address. | |
| RECIP_COUNTRY | VARCHAR2 | (60) | Indicates country of the recipient's address. | |
| RECIP_FAX_AREA_CODE | VARCHAR2 | (10) | Indicates the area code of the recipient's fax number. Will be used if the delivery method is fax. | |
| RECIP_FAX_COUNTRY_CODE | VARCHAR2 | (10) | Country code for the FAX | |
| RECIP_FAX_NUMBER | VARCHAR2 | (40) | Recipient's FAX Number | |
| DELIVERY_METHOD_TYPE | VARCHAR2 | (30) | Indicates the delivery method to be used.This is a user-defined field. | |
| DUP_REQUESTED | VARCHAR2 | (1) | Indicates whether the duplicate document is requested by the user, Only Admin can exercise this option. Once checked, the status of the item is changed from COMPLETED to in process. | |
| DUP_REQ_DATE | DATE | Date on which the duplicate document was requested. | ||
| DUP_SENT_DATE | DATE | Date on which duplicate document was processed and sent | ||
| 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) | Sequence Number of the calendar instance for grade hold release. | |
| 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) | Sequence Number of the calander instance for Degree Hold | |
| HOLD_FOR_GRADE_CHG | VARCHAR2 | (1) | Indicates whether the hold for grade changes is applicable or not. | |
| HOLD_DEGREE_EXPECTED | VARCHAR2 | (1) | Indicates whethere the document should be held unless degree is expected. | |
| HOLD_RELEASE_OF_FINAL_GRADES | VARCHAR2 | (1) | Indicates whether the document is to be withheld until final grades are done. | |
| INCL_CURR_COURSE | VARCHAR2 | (1) | Indicates whether the information related to current course is to be included in document or not. | |
| 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 the student has chosen 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'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 | ||
| RECIP_INST_CD | VARCHAR2 | (30) | Code for the recipient institution | |
| RECIP_EMAIL | VARCHAR2 | (2000) | Recipient Email identifier |
Cut, paste (and edit) the following text to query this object:
SELECT 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
FROM IGS.IGS_AS_ORD_ITM_INT;
IGS.IGS_AS_ORD_ITM_INT does not reference any database object
IGS.IGS_AS_ORD_ITM_INT is referenced by following:
APPS
IGS_AS_ORD_ITM_INT
|
|
|
|