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

VIEW: APPS.IGS_AD_RESI_LETTER_V

Object Details
Object Name: IGS_AD_RESI_LETTER_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGS_AD_RESI_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 Residency 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 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)
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)
This field contains the e-mail address of the student
EMPLOYEES_TOTAL NUMBER

Total number of employees in an Organization
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
RESIDENT_DETAILS_ID NUMBER (15) Yes Residency Detail Identifier
RESIDENCY_CLASS_DESC VARCHAR2 (80) Yes Residency class code description.
RESIDENCY_CLASS_CD VARCHAR2 (30) Yes Residency class code.
RESIDENCY_STATUS_DESC VARCHAR2 (80) Yes Residency status code description.
RESIDENCY_STATUS_CD VARCHAR2 (30) Yes Residency status code.
EVALUATION_DATE DATE
Yes Date on which the evaluation takes place
EVALUATOR VARCHAR2 (30) Yes Person who is doing the evaluation
START_DT DATE
Yes Residency calendar start date
END_DT DATE
Yes Residency calendar end date
RES_CAL_TYPE VARCHAR2 (10) Yes Residency calendar type
RES_SEQUENCE_NUMBER NUMBER
Yes Residency calendar sequence number
RES_CALENDAR_DESC VARCHAR2 (30)
Residency calendar description
COMMENTS VARCHAR2 (240)
Comments
ACAD_CAL_TYPE VARCHAR2 (10) Yes Academic Calendar Type
ACAD_CI_SEQUENCE_NUMBER NUMBER (6) Yes The Calendar Instance to which the program is offered
ACADEMIC_YEAR VARCHAR2 (30)
Academic Year, in which the residency detail is valid
RESIDENCY_DFF_VALUES VARCHAR2 (4000)
Concatenated field which includes the values of the additional attribute values for the residency details
PERSON_NAME_ADDRESS VARCHAR2 (4000)
Concatenated field which includes the Address Lines, Postal Code, city and the Country
TODAYS_DATE VARCHAR2 (17)
Todays Date
PERS_GROUP_ID NUMBER (6)
Person Group 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
,      RESIDENT_DETAILS_ID
,      RESIDENCY_CLASS_DESC
,      RESIDENCY_CLASS_CD
,      RESIDENCY_STATUS_DESC
,      RESIDENCY_STATUS_CD
,      EVALUATION_DATE
,      EVALUATOR
,      START_DT
,      END_DT
,      RES_CAL_TYPE
,      RES_SEQUENCE_NUMBER
,      RES_CALENDAR_DESC
,      COMMENTS
,      ACAD_CAL_TYPE
,      ACAD_CI_SEQUENCE_NUMBER
,      ACADEMIC_YEAR
,      RESIDENCY_DFF_VALUES
,      PERSON_NAME_ADDRESS
,      TODAYS_DATE
,      PERS_GROUP_ID
FROM APPS.IGS_AD_RESI_LETTER_V;

Dependencies

[top of page]

APPS.IGS_AD_RESI_LETTER_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
ViewIGS_AD_APPL
ViewIGS_CA_INST
PL/SQL PackageIGS_CO_GEN_003 - show dependent code
SynonymIGS_PE_HZ_PARTIES
SynonymIGS_PE_PRSID_GRP_MEM_ALL
ViewIGS_PE_RES_DTLS_V

APPS.IGS_AD_RESI_LETTER_V is not referenced by any database object