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

VIEW: APPS.IGS_AD_ACK_LETTER_V

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

View Type

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


It would return the Acknowledgement Details of a student


[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (15) Yes Person Identifier, this field is used by the system internally for identification
PARTY_NAME VARCHAR2 (360) Yes This field stores the Name of the person
PERSON_NUMBER VARCHAR2 (30) Yes This field Identifies a person uniquely, this field is shown to the user for identification
PARTY_TYPE VARCHAR2 (30) Yes This field used in TCA to distinguish the party_id's i.e. if the party_id is for a PERSON, ORGANIZATION or PARTY_RELATIONSHIP. This field would always return 'PERSON' as it's value, in this case
ADDRESS_LINE1 VARCHAR2 (240)
Stores the Line 1 of the Address
ADDRESS_LINE2 VARCHAR2 (240)
Stores the Line 2 of the Address
ADDRESS_LINE3 VARCHAR2 (240)
Stores the Line 3 of the Address
ADDRESS_LINE4 VARCHAR2 (240)
Stores the Line 4 of the 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)
The county name, where the communication is to be done
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)
Field returns the flag as 'Y' or 'N' . If 'N' the mail can be sent to the student else no mail is to be sent to the student
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)
The name for the party that is recognized by the tax authority
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)
Preference Number for the Application Instance
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.
LOCATION_CD VARCHAR2 (10)
Location Code
ATTENDANCE_MODE VARCHAR2 (2)
Attendance Mode
ATTENDANCE_TYPE VARCHAR2 (2)
Attendance Type
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.
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
ADM_APPL_NUMBER NUMBER (2) Yes Application Number
NOMINATED_COURSE_CD VARCHAR2 (6) Yes Course for which Student is nominated
APPL_SEQUENCE_NUMBER NUMBER (6) Yes Sequence Generated Number , it gives the sequence number of the Application
COMMENCEMENT_PERIOD VARCHAR2 (21)
This field describes the commencement period the admission application is applicable for
ACAD_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.
APPLICATION_STATUS VARCHAR2 (10) Yes This field describes the institution-defined application status of the admission application
CHANGE_OF_PREF_DATE VARCHAR2 (4000)
The Date instance for change of preferences
PERSON_NAME_ADDRESS VARCHAR2 (4000)
Concatenated field which includes the Address Lines , postal code , city and the country
TODAYS_DATE VARCHAR2 (17)
Today's Date
PERS_GROUP_ID NUMBER (6)
Perso Group Identifier
ADM_PROCESS_CAT VARCHAR2 (91)
Admission Process Category
APPL_DT DATE
Yes Indicates the date when Admission Application was made
ADM_OUTCOME_STATUS VARCHAR2 (10) Yes Admission Outcome Status
S_ADM_OUTCOME_STATUS VARCHAR2 (30) Yes System Admission Outcome Status
APPLICATION_ID NUMBER (15)
Application Identifier
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
,      LOCATION_CD
,      ATTENDANCE_MODE
,      ATTENDANCE_TYPE
,      LOCATION_DESC
,      ATTENDANCE_MODE_DESC
,      ATTENDANCE_TYPE_DESC
,      ACAD_CAL_TYPE
,      ACAD_CI_SEQUENCE_NUMBER
,      ADM_CAL_TYPE
,      ADM_CI_SEQUENCE_NUMBER
,      ADM_APPL_NUMBER
,      NOMINATED_COURSE_CD
,      APPL_SEQUENCE_NUMBER
,      COMMENCEMENT_PERIOD
,      ACAD_ALTERNATE_CODE
,      APPLICATION_STATUS
,      CHANGE_OF_PREF_DATE
,      PERSON_NAME_ADDRESS
,      TODAYS_DATE
,      PERS_GROUP_ID
,      ADM_PROCESS_CAT
,      APPL_DT
,      ADM_OUTCOME_STATUS
,      S_ADM_OUTCOME_STATUS
,      APPLICATION_ID
FROM APPS.IGS_AD_ACK_LETTER_V;

Dependencies

[top of page]

APPS.IGS_AD_ACK_LETTER_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
ViewIGS_AD_APPL_ADMAPPL_V
SynonymIGS_AD_APPL_STAT
PL/SQL PackageIGS_AD_GEN_004 - show dependent code
SynonymIGS_AD_LOCATION_ALL
SynonymIGS_AD_OU_STAT
ViewIGS_AD_PRCS_CAT_STEP
ViewIGS_AD_PS_APPL_INST
PL/SQL PackageIGS_CO_GEN_003 - show dependent code
SynonymIGS_EN_ATD_MODE_ALL
SynonymIGS_EN_ATD_TYPE_ALL
SynonymIGS_PE_HZ_PARTIES
SynonymIGS_PE_PRSID_GRP_MEM_ALL
SynonymIGS_PS_VER_ALL

APPS.IGS_AD_ACK_LETTER_V is not referenced by any database object