DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGS_AD_OUTCOME_LETTERS_V

Object Details
Object Name: IGS_AD_OUTCOME_LETTERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_AD_OUTCOME_LETTERS_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


The validations for the individual letters are placed at the SQL query level that we attach to master document


[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (15) Yes Party identifier, This field is used by the system internally for identification
PARTY_NAME VARCHAR2 (360) Yes Name of this party
PERSON_NUMBER VARCHAR2 (30) Yes Unique identification number for this party
PARTY_TYPE VARCHAR2 (30) Yes The party type can only be Person, Organization, Group or Relationship.
ADDRESS_LINE1 VARCHAR2 (240)
First line of the Identifying address
ADDRESS_LINE2 VARCHAR2 (240)
Second line of the Identifying address
ADDRESS_LINE3 VARCHAR2 (240)
Third line of the Identifying address
ADDRESS_LINE4 VARCHAR2 (240)
Fourth line of the Identifying address
ANALYSIS_FY VARCHAR2 (5)
Fiscal year that financial information is based on
CATEGORY_CODE VARCHAR2 (30)
User-definable category. Lookup type is CUSTOMER_CATEGORY
CITY VARCHAR2 (60)
City of the Identifying address
COMPETITOR_FLAG VARCHAR2 (1)
Indicates if a party is a competitor. Y for a party that is a competitor, N or null for a party that is not a competitor
COUNTRY VARCHAR2 (60)
The country listed in the TERRITORY_CODE column of the FND_TERRITORY table. for the Identifying address.
COUNTY VARCHAR2 (60)
County of the Identifying address
CURR_FY_POTENTIAL_REVENUE NUMBER

Organization's potential revenue this fiscal year
CUSTOMER_KEY VARCHAR2 (500)
Derived key used to facilitate fuzzy searches
DO_NOT_MAIL_FLAG VARCHAR2 (1)
No longer used
DUNS_NUMBER NUMBER

The DUNS number, a unique, nine-digit identification number assigned to business entities by Dun & Bradstreet
EMAIL_ADDRESS VARCHAR2 (2000)
E-mail address
EMPLOYEES_TOTAL NUMBER

Total number of employees
FISCAL_YEAREND_MONTH VARCHAR2 (30)
Month in which fiscal year ends for organization
GROUP_TYPE VARCHAR2 (30)
Lookup for group type
GSA_INDICATOR_FLAG VARCHAR2 (1)
Indicates if this is a US federal agency supported by the General Services Administration (GSA). Y for organizations served by the GSA, N for organizations that are not served by the GSA.
HQ_BRANCH_IND VARCHAR2 (30)
Status of this site. Identifies if the location is the headquarters, a branch, or a single location.
JGZZ_FISCAL_CODE VARCHAR2 (20)
Taxpayer identification number. Used in Europe to identify customers. Also known as the fiscal code or NIF.
PREFERRED_GIVEN_NAME VARCHAR2 (240)
An alias or other name by which a party is known
KNOWN_AS2 VARCHAR2 (240)
An alias or other name by which a party is known
KNOWN_AS3 VARCHAR2 (240)
An alias or other name by which a party is known
KNOWN_AS4 VARCHAR2 (240)
An alias or other name by which a party is known
KNOWN_AS5 VARCHAR2 (240)
An alias or other name by which a party is known
LANGUAGE_NAME VARCHAR2 (4)
Standard name for a language
LAST_ORDERED_DATE DATE

Date of the most recent order
MISSION_STATEMENT VARCHAR2 (2000)
Corporate charter of organization
NEXT_FY_POTENTIAL_REVENUE NUMBER

Organization's potential revenue for next fiscal year
ORGANIZATION_NAME_PHONETIC VARCHAR2 (320)
Japanese Kana, or phonetic representation of organization name
ORIG_SYSTEM_REFERENCE VARCHAR2 (240) Yes Customer identifier from foreign system. May not be unique.
PERSON_ACADEMIC_TITLE VARCHAR2 (30)
Academic title that is part of a person's name, such as Dr. John Smith.
GIVEN_NAMES VARCHAR2 (150)
First name of the person
PERSON_FIRST_NAME_PHONETIC VARCHAR2 (60)
Phonetic representation of the person's first name
PERSON_IDEN_TYPE VARCHAR2 (30)
Lookup representing most common personal identification number in a country. For example, Social Security Number in the US
PERSON_IDENTIFIER VARCHAR2 (60)
Identity reference field for things like Social Security, tax identity number, or driver's license number.
SURNAME VARCHAR2 (150)
Last or surname of the person
PERSON_LAST_NAME_PHONETIC VARCHAR2 (60)
Phonetic representation of the person's last name
MIDDLE_NAME VARCHAR2 (60)
Middle name of the person
SUFFIX VARCHAR2 (30)
Indicates the place in a family structure. For example, in Tom Jones III, the "III" is the suffix.
PREFIX VARCHAR2 (30)
Salutary introduction, such as Mr. or Herr
PERSON_PREVIOUS_LAST_NAME VARCHAR2 (150)
Previous last or surname of the person
TITLE VARCHAR2 (60)
A professional or family title. For example, Don or The Right Honorable.
POSTAL_CODE VARCHAR2 (60)
Postal Code of the Identifying address
PROVINCE VARCHAR2 (60)
Province of the Identifying address
REFERENCE_USE_FLAG VARCHAR2 (1)
Indicates if customer has agreed to be a reference. Y for customer who is referencable, N or null for a nonreferencable customer
SALUTATION VARCHAR2 (60)
Phrase used to address a party in any correspondence.
SIC_CODE VARCHAR2 (30)
Standard Industry Classification (SIC) code
SIC_CODE_TYPE VARCHAR2 (30)
Version of Standard Industry Classification (SIC) code
STATE VARCHAR2 (60)
State of the Identifying address
STATUS VARCHAR2 (1) Yes Party status flag.
TAX_NAME VARCHAR2 (60)
No longer used
TAX_REFERENCE VARCHAR2 (50)
Taxpayer registration number, also known as the VAT number.
THIRD_PARTY_FLAG VARCHAR2 (1)
Tracks if a party has a direct relationship with the organization using Oracle Receivables or through a third party vendor. Y for a third party relationship, N for a direct relationship. If Oracle Service is installed, the Third Party field in the Customers window is mandatory.
TOTAL_NUM_OF_ORDERS NUMBER

Total number of orders through the last ordered date
TOTAL_ORDERED_AMOUNT NUMBER

Total amount ordered through the last ordered date
URL VARCHAR2 (2000)
Uniform resource locator
VALIDATED_FLAG VARCHAR2 (1)
Indicates if the party was validated. Y for a validated party, N for a party that is not validated.
WH_UPDATE_DATE DATE

Obsolete
YEAR_ESTABLISHED NUMBER (4)
Year that the organization began doing business
PREFERENCE_NUMBER NUMBER (2)
This field describes the applicant preference number of the course applied for
COURSE_CD VARCHAR2 (6) Yes Code used to identify the program in that the student is enrolled.
COURSE_TITLE VARCHAR2 (90) Yes Title or full name of the program.
COURSE_OU_CD VARCHAR2 (30) Yes Code of the organizational unit responsible for the program version.
COURSE_OU_DESCRIPTION VARCHAR2 (360) Yes Responsible Organizational Unit Code Description
COURSE_OU_START_DT DATE
Yes Start date of the organizational unit responsible for the program version.
COURSE_TYPE VARCHAR2 (10) Yes Institution-defined program type. Program type indicates the type of higher education program.
LOCATION_CD VARCHAR2 (10)
This field describes the location code of the course admission application
ATTENDANCE_MODE VARCHAR2 (2)
This field describes the attendance mode of the course admission application
ATTENDANCE_TYPE VARCHAR2 (2)
This field describes the nominated attendance type of the course admission application
ADMISSION_OUTCOME_STATUS VARCHAR2 (10) Yes This field describes the outcome status of the admission course application instance.
ENTRY_STATUS NUMBER

Entry Status
ENTRY_STATUS_NAME VARCHAR2 (10)
Entry Status Name
ENTRY_STATUS_DESC VARCHAR2 (30)
Entry Status Description
ENTRY_LEVEL NUMBER

Entry Level
ENTRY_LEVEL_NAME VARCHAR2 (10)
Entry Level Name
ENTRY_LEVEL_DESC VARCHAR2 (30)
Entry Status Description
SCH_APL_TO_ID NUMBER

School Apply To ID
SCH_APL_TO VARCHAR2 (30)
School Applying To
SCH_APL_TO_DESC VARCHAR2 (60)
School Applying To Description
EXPECTED_COURSE_COMPLETE_YEAR NUMBER (4)
The year in which the assessor considers the applicant will have completed all course requirements. The assessor also nominates the expected period (Summer, Mid-year or End of Year) of course completion. This information can be derived from course version F/T, P/T standard completion time but may need to be overriden when advanced standing is a consideration. This information will enable determination of fee-paying applicant contract durations.
EXPECTED_COURSE_COMPLETE_PERD VARCHAR2 (1)
The period, or part of the year, at which time the assessor considers the applicant will have completed all course requirements. The allowable values are Summer, Mid-year or End of Year. The assessor also nominates the year of expected course completion.
EDU_GOAL_PRIOR_ENROLL VARCHAR2 (10)
Education goal prior to Enrollment
EDU_GOAL_PRIOR_ENROLL_DESC VARCHAR2 (30)
Education goal prior to Enrollment Description
LOCATION_DESC VARCHAR2 (60)
The description of a physical location owned or used by an institution. Each location has a location type, such as Campus, that defines its use in the system.
ATTENDANCE_MODE_DESC VARCHAR2 (60)
Description of an institution-defined attendance mode. An attendance mode identifies the mode of attendance for a program that student undertakes. Each attendance mode must be mapped to a government attendance type-DETYA element 329. For example, ONCAMPUS, OFF CAMPUS, and MULTI-MODAL.
ATTENDANCE_TYPE_DESC VARCHAR2 (60)
Description of an institution-defined attendance type. An attendance type identifies whether a student is classified as part-time or full-time in the program, based on their study load in the reference year. Each attendance type must be mapped to a government attendance type DETYA element 330.
ACADEMIC_YEAR_ALTERNATE_CODE VARCHAR2 (10)
The alternate short reference code for identifying a teaching or academic calendar instance. This code is used for mass keying of enrolments and unit/course offerings.
ACAD_CAL_TYPE VARCHAR2 (10) Yes This field describes the academic calendar type to which the admission application applies
ACAD_CI_SEQUENCE_NUMBER NUMBER (6) Yes This field describes the academic calendar sequence number that the admission application is for
ADM_CAL_TYPE VARCHAR2 (10) Yes This field describes the admission calendar type to which the admission application applies
ADM_CI_SEQUENCE_NUMBER NUMBER (6) Yes This field describes the admission calendar sequence number that the admission application is for
APPL_DT DATE
Yes This field describes the date the admission application was made
COMMENCEMENT_PERIOD VARCHAR2 (21)
Indicates the Commencement Period of the Admission Application
SPECIAL_GROUP1 NUMBER

Special Group1
SPECIAL_GROUP1_NAME VARCHAR2 (10)
Special Group1 Name
SPECIAL_GROUP1_DESC VARCHAR2 (30)
Special Group1 Description
SPECIAL_GROUP2 NUMBER

Special Group2
SPECIAL_GROUP2_NAME VARCHAR2 (10)
Special Group2 Name
SPECIAL_GROUP2_DESC VARCHAR2 (30)
Special Group2 Description
ADMISSION_PROCESS_CATEGORY VARCHAR2 (91)
This field describes the admission process category of the admission application
S_ADM_OUTCOME_STATUS VARCHAR2 (30) Yes Contains the system-defined status assigned to an admission application to describe the state of the applicant's request for admission. For example, Pending, Offer, Cond-Offer.
ADM_CNDTNL_OFFER_STATUS VARCHAR2 (10) Yes This field describes the status assigned to an admission course application in relation to a conditional offer.
CNDTNL_OFFER_CNDTN VARCHAR2 (2000)
Describes the conditions that have been asociated with a conditional offer
CNDTNL_OFFER_SATISFIED_DT DATE

This field describes the date on which a conditional offer was satisfied or waived
CNDTNL_OFFER_MUST_BE_STSFD_IND VARCHAR2 (1) Yes This field describes whether or not conditions attached to an offer must be satisfied before an offer can be accepted. Setting the indicator (ticked) means that the condition must be satisfied before the conditional offer can be accepted.
WAITLIST_STATUS VARCHAR2 (30)
Waitlist Status
WAITLIST_STATUS_DESC VARCHAR2 (80)
Waitlist Status Description
WAITLIST_RANK VARCHAR2 (30)
Waitlist Rank for the Admission Application
FUTURE_ACAD_ALTERNATE_CODE VARCHAR2 (10)
Future academic alternate code
FUTURE_ACAD_CAL_TYPE VARCHAR2 (10)
Future academic calendar type
FUTURE_ACAD_CI_SEQUENCE_NUMBER NUMBER (6)
Future academic calendar type instance
FUTURE_ADM_ALTERNATE_CODE VARCHAR2 (10)
Future admission alternate code
FUTURE_ADM_CAL_TYPE VARCHAR2 (10)
Future admission calendar type
FUTURE_ADM_CI_SEQUENCE_NUMBER NUMBER (6)
Future admission calendar type instance
PREVIOUS_TERM_ADM_APPL_NUMBER NUMBER (2)
Previous admission term application number reference
PREVIOUS_TERM_SEQUENCE_NUMBER NUMBER (6)
Previous admission term sequence number reference
FUTURE_TERM_ADM_APPL_NUMBER NUMBER (2)
Future admission term application number reference
FUTURE_TERM_SEQUENCE_NUMBER NUMBER (6)
Future admission term sequence number reference
PERSON_NAME_ADDRESS VARCHAR2 (4000)
Concatenated field which includes the Address Lines , postal code , city and the country
EXPECTED_PROGRAM_COMPLETE_DATE DATE

Projected Program Completion Date
PRG_APPL_INST_DFF_VALUES VARCHAR2 (4000)
Concatenated field which includes the values of the additional attribute values for the Application Instance details
CITIZENSHIP_STATUS VARCHAR2 (4000)
Student Citizenship Status
TODAYS_DATE VARCHAR2 (16)
Today's Date
PERS_GROUP_ID NUMBER (6)
Person's Group Identifier
ADM_APPL_NUMBER NUMBER (2) Yes Admission Application Number
NOMINATED_COURSE_CD VARCHAR2 (6) Yes Nominated Course Code
APPL_SEQUENCE_NUMBER NUMBER (6) Yes Admission Application Sequence Number
APPLICATION_ID NUMBER (15)
Application Identifier
ADM_OFFER_RESP_STATUS VARCHAR2 (10) Yes Admission Offer Response Status
S_ADM_OFFER_RESP_STATUS VARCHAR2 (30) Yes System Offer Response Status
OFFER_RESPONSE_DT DATE

Offer Response Date
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PERSON_ID
,      PARTY_NAME
,      PERSON_NUMBER
,      PARTY_TYPE
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      ANALYSIS_FY
,      CATEGORY_CODE
,      CITY
,      COMPETITOR_FLAG
,      COUNTRY
,      COUNTY
,      CURR_FY_POTENTIAL_REVENUE
,      CUSTOMER_KEY
,      DO_NOT_MAIL_FLAG
,      DUNS_NUMBER
,      EMAIL_ADDRESS
,      EMPLOYEES_TOTAL
,      FISCAL_YEAREND_MONTH
,      GROUP_TYPE
,      GSA_INDICATOR_FLAG
,      HQ_BRANCH_IND
,      JGZZ_FISCAL_CODE
,      PREFERRED_GIVEN_NAME
,      KNOWN_AS2
,      KNOWN_AS3
,      KNOWN_AS4
,      KNOWN_AS5
,      LANGUAGE_NAME
,      LAST_ORDERED_DATE
,      MISSION_STATEMENT
,      NEXT_FY_POTENTIAL_REVENUE
,      ORGANIZATION_NAME_PHONETIC
,      ORIG_SYSTEM_REFERENCE
,      PERSON_ACADEMIC_TITLE
,      GIVEN_NAMES
,      PERSON_FIRST_NAME_PHONETIC
,      PERSON_IDEN_TYPE
,      PERSON_IDENTIFIER
,      SURNAME
,      PERSON_LAST_NAME_PHONETIC
,      MIDDLE_NAME
,      SUFFIX
,      PREFIX
,      PERSON_PREVIOUS_LAST_NAME
,      TITLE
,      POSTAL_CODE
,      PROVINCE
,      REFERENCE_USE_FLAG
,      SALUTATION
,      SIC_CODE
,      SIC_CODE_TYPE
,      STATE
,      STATUS
,      TAX_NAME
,      TAX_REFERENCE
,      THIRD_PARTY_FLAG
,      TOTAL_NUM_OF_ORDERS
,      TOTAL_ORDERED_AMOUNT
,      URL
,      VALIDATED_FLAG
,      WH_UPDATE_DATE
,      YEAR_ESTABLISHED
,      PREFERENCE_NUMBER
,      COURSE_CD
,      COURSE_TITLE
,      COURSE_OU_CD
,      COURSE_OU_DESCRIPTION
,      COURSE_OU_START_DT
,      COURSE_TYPE
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      ADMISSION_OUTCOME_STATUS
,      ENTRY_STATUS
,      ENTRY_STATUS_NAME
,      ENTRY_STATUS_DESC
,      ENTRY_LEVEL
,      ENTRY_LEVEL_NAME
,      ENTRY_LEVEL_DESC
,      SCH_APL_TO_ID
,      SCH_APL_TO
,      SCH_APL_TO_DESC
,      EXPECTED_COURSE_COMPLETE_YEAR
,      EXPECTED_COURSE_COMPLETE_PERD
,      EDU_GOAL_PRIOR_ENROLL
,      EDU_GOAL_PRIOR_ENROLL_DESC
,      LOCATION_DESC
,      ATTENDANCE_MODE_DESC
,      ATTENDANCE_TYPE_DESC
,      ACADEMIC_YEAR_ALTERNATE_CODE
,      ACAD_CAL_TYPE
,      ACAD_CI_SEQUENCE_NUMBER
,      ADM_CAL_TYPE
,      ADM_CI_SEQUENCE_NUMBER
,      APPL_DT
,      COMMENCEMENT_PERIOD
,      SPECIAL_GROUP1
,      SPECIAL_GROUP1_NAME
,      SPECIAL_GROUP1_DESC
,      SPECIAL_GROUP2
,      SPECIAL_GROUP2_NAME
,      SPECIAL_GROUP2_DESC
,      ADMISSION_PROCESS_CATEGORY
,      S_ADM_OUTCOME_STATUS
,      ADM_CNDTNL_OFFER_STATUS
,      CNDTNL_OFFER_CNDTN
,      CNDTNL_OFFER_SATISFIED_DT
,      CNDTNL_OFFER_MUST_BE_STSFD_IND
,      WAITLIST_STATUS
,      WAITLIST_STATUS_DESC
,      WAITLIST_RANK
,      FUTURE_ACAD_ALTERNATE_CODE
,      FUTURE_ACAD_CAL_TYPE
,      FUTURE_ACAD_CI_SEQUENCE_NUMBER
,      FUTURE_ADM_ALTERNATE_CODE
,      FUTURE_ADM_CAL_TYPE
,      FUTURE_ADM_CI_SEQUENCE_NUMBER
,      PREVIOUS_TERM_ADM_APPL_NUMBER
,      PREVIOUS_TERM_SEQUENCE_NUMBER
,      FUTURE_TERM_ADM_APPL_NUMBER
,      FUTURE_TERM_SEQUENCE_NUMBER
,      PERSON_NAME_ADDRESS
,      EXPECTED_PROGRAM_COMPLETE_DATE
,      PRG_APPL_INST_DFF_VALUES
,      CITIZENSHIP_STATUS
,      TODAYS_DATE
,      PERS_GROUP_ID
,      ADM_APPL_NUMBER
,      NOMINATED_COURSE_CD
,      APPL_SEQUENCE_NUMBER
,      APPLICATION_ID
,      ADM_OFFER_RESP_STATUS
,      S_ADM_OFFER_RESP_STATUS
,      OFFER_RESPONSE_DT
FROM APPS.IGS_AD_OUTCOME_LETTERS_V;

Dependencies

[top of page]

APPS.IGS_AD_OUTCOME_LETTERS_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
ViewIGS_AD_APPL_ADMAPPL_V
SynonymIGS_AD_APPL_ALL
SynonymIGS_AD_APPL_STAT
SynonymIGS_AD_LOCATION_ALL
SynonymIGS_AD_OFR_RESP_STAT
SynonymIGS_AD_OU_STAT
ViewIGS_AD_PRCS_CAT_STEP
ViewIGS_AD_PS_APPL_INST_APLINST_V
PL/SQL PackageIGS_CO_GEN_003 - show dependent code
SynonymIGS_EN_ATD_MODE_ALL
SynonymIGS_EN_ATD_TYPE_ALL
PL/SQL PackageIGS_GE_GEN_001 - show dependent code
SynonymIGS_PE_HZ_PARTIES
SynonymIGS_PE_PRSID_GRP_MEM_ALL
SynonymIGS_PS_VER_ALL

APPS.IGS_AD_OUTCOME_LETTERS_V is not referenced by any database object