[Home] [Help] [Dependency Information]
Object Name: | IGS_AS_DOC_DETAILS |
---|---|
Object Type: | TABLE |
Owner: | IGS |
FND Design Data: | IGS.IGS_AS_DOC_DETAILS |
Subobject Name: | |
Status: | VALID |
This table will store the information about the documents associated with the order
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGS_AS_DOC_DETAILS_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ORDER_NUMBER |
IGS_AS_DOC_DETAILS_U1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ITEM_NUMBER |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 user. Values are like 'Official', 'Unofficial'. |
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) | 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 as found in TCA, data-entered or corrected. | |
RECIP_ADDR_LINE_1 | VARCHAR2 | (240) | Yes | Indicates Line 1 of the recipient s address, as found in TCA, data-entered or corrected. |
RECIP_ADDR_LINE_2 | VARCHAR2 | (240) | Indicates Line 2 of the recipient s address, as found in TCA, data-entered or corrected. | |
RECIP_ADDR_LINE_3 | VARCHAR2 | (240) | Indicates Line 3 of the recipient s address, as found in TCA, data-entered or corrected. | |
RECIP_ADDR_LINE_4 | VARCHAR2 | (240) | Indicates Line 4 of the recipient s address, as found in TCA, data-entered or corrected. | |
RECIP_CITY | VARCHAR2 | (60) | Indicates city of the recipient's city, as found in TCA, data-entered or corrected. | |
RECIP_POSTAL_CODE | VARCHAR2 | (60) | Indicates postal code of the recipient's city, as found in TCA, data-entered or corrected. | |
RECIP_STATE | VARCHAR2 | (60) | Indicates state of the recipient's city, as found in TCA, data-entered or corrected. | |
RECIP_PROVINCE | VARCHAR2 | (60) | Indicates province of the recipient's province, as found in TCA, data-entered or corrected. | |
RECIP_COUNTY | VARCHAR2 | (60) | Indicates county of the recipient's city, as found in TCA, data-entered or corrected. | |
RECIP_COUNTRY | VARCHAR2 | (60) | Yes | Indicates country of the recipient's city, 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) | Populated manually by the person who fulfils the request if the carrier for the delivery method chosen offers a 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) | Indicates whether the duplicate of the document is requested or not. Default value is "N" | |
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. | ||
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 | ||
RECIP_INST_CD | VARCHAR2 | (30) | Code for the recipient institution. | |
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. | ||
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 | |
DOC_PURPOSE_CODE | VARCHAR2 | (30) | Code for purpose of ordering the transcript | |
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 |
Cut, paste (and edit) the following text to query this object:
SELECT 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_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
, RECIP_INST_CD
, DOC_FEE_PER_COPY
, DELIVERY_FEE
, RECIP_EMAIL
, OVERRIDDEN_DOC_DELIVERY_FEE
, OVERRIDDEN_DOCUMENT_FEE
, FEE_OVERRIDDEN_BY
, FEE_OVERRIDDEN_DATE
, 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_PURPOSE_CODE
, PLAN_ID
, PRODUCED_BY
, PERSON_ID
FROM IGS.IGS_AS_DOC_DETAILS;
IGS.IGS_AS_DOC_DETAILS does not reference any database object
IGS.IGS_AS_DOC_DETAILS is referenced by following:
|
|
|