[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_AD_MISSING_ITEMS_LETTER_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_AD_MISSING_ITEMS_LETTER_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
Returns the missing items. For processing application of the student, few documents are required by the admission module. When student forget to send any document or miss out any document , then these documents are treated as missing items . This view would be used to return all the missing items of the student which are required for admission processing.
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PERSON_ID | NUMBER | (15) | Yes | Party identifier |
| 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 ie 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) | Second line of the Identifying 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) | The name of the city, where the communication is to be done | |
| 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 name, where the communication is to be done | |
| 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) | 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) | Provides the fiscal code for an organization. This code is used in some European countries | |
| 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) | This field contains the mission statement of the 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 | Unique party identifier from foreign or legacy system |
| 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 | |
| COURSE_TITLE | VARCHAR2 | (90) | Yes | Title of the course |
| ACAD_CAL_TYPE | VARCHAR2 | (10) | Yes | Academic Calendar Type attached to the program |
| ACAD_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | The Calendar Instance to on which the program is offered |
| ADM_CAL_TYPE | VARCHAR2 | (10) | Yes | Describes the admission calendar type to which the admission application applies |
| ADM_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Describes the admission calendar sequence number that theadmission application is for |
| ADM_APPL_NUMBER | NUMBER | (2) | Yes | Identifies uniquely an admission application for a person |
| NOMINATED_COURSE_CD | VARCHAR2 | (6) | Yes | Describes the program code of the program offering instance to that the person is applying for admission |
| APPL_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Sequence Generated Number , it gives the sequence number of the Application |
| ADM_DOC_STATUS | VARCHAR2 | (10) | Yes | Admission Document Status |
| ITEM_DESCRIPTION | VARCHAR2 | (60) | Yes | Tracking Item Description |
| COMPLETION_DUE_DATE | DATE | Completion Due date for tracking | ||
| STEP_DESCRIPTION | VARCHAR2 | (60) | Yes | Tracking Step Description |
| TODAYS_DATE | VARCHAR2 | (16) | Today's Date | |
| STEP_DUE_DATE | VARCHAR2 | (11) | Tracking Completion Due Date | |
| LOCATION_DESC | VARCHAR2 | (60) | Location Description | |
| ATTENDENCE_MODE_DESC | VARCHAR2 | (60) | Attendance Mode Description | |
| ATTENDENCE_TYPE_DESC | VARCHAR2 | (60) | Attendance Type Description | |
| PERSON_NAME_ADDRESS | VARCHAR2 | (4000) | Concatenated field which includes the Address Lines , postal code , city and the country. | |
| ORG_UNIT_CD | VARCHAR2 | (30) | Yes | Organizational Unit Code |
| PERS_GROUP_ID | NUMBER | (6) | Person Group Identifier | |
| ADM_OUTCOME_STATUS | VARCHAR2 | (10) | Yes | Admission Outcome Status |
| S_ADM_OUTCOME_STATUS | VARCHAR2 | (30) | Yes | System Admission Outcome Status |
| ADM_PROCESS_CAT | VARCHAR2 | (91) | Admission Process Category | |
| APPLICATION_ID | NUMBER | (15) | Application Identifier |
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
, COURSE_TITLE
, ACAD_CAL_TYPE
, ACAD_CI_SEQUENCE_NUMBER
, ADM_CAL_TYPE
, ADM_CI_SEQUENCE_NUMBER
, ADM_APPL_NUMBER
, NOMINATED_COURSE_CD
, APPL_SEQUENCE_NUMBER
, ADM_DOC_STATUS
, ITEM_DESCRIPTION
, COMPLETION_DUE_DATE
, STEP_DESCRIPTION
, TODAYS_DATE
, STEP_DUE_DATE
, LOCATION_DESC
, ATTENDENCE_MODE_DESC
, ATTENDENCE_TYPE_DESC
, PERSON_NAME_ADDRESS
, ORG_UNIT_CD
, PERS_GROUP_ID
, ADM_OUTCOME_STATUS
, S_ADM_OUTCOME_STATUS
, ADM_PROCESS_CAT
, APPLICATION_ID
FROM APPS.IGS_AD_MISSING_ITEMS_LETTER_V;
APPS
HZ_PARTIES
IGS_AD_APLINS_ADMREQ
IGS_AD_APPL_ALL
IGS_AD_APPL_STAT
IGS_AD_DOC_STAT
IGS_AD_LOCATION_ALL
IGS_AD_OU_STAT
IGS_AD_PRCS_CAT_ALL
IGS_AD_PRCS_CAT_STEP
IGS_AD_PS_APPL_INST_ALL
IGS_CO_GEN_003
- show dependent code
IGS_EN_ATD_MODE_ALL
IGS_EN_ATD_TYPE_ALL
IGS_LOOKUPS_VIEW
IGS_PE_HZ_PARTIES
IGS_PE_PRSID_GRP_MEM_ALL
IGS_PS_VER_ALL
IGS_TR_GEN_001
- show dependent code
IGS_TR_ITEM_V
IGS_TR_STATUS
IGS_TR_STEP
IGS_TR_STEP_V
IGS_TR_TYPE
APPS
IGS_CO_PROCESS
- show dependent code
|
|
|
|