[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGS_AD_POSTADM_MISS_ITM_LTR_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGS.IGS_AD_POSTADM_MISS_ITM_LTR_V
|
| Subobject Name: | |
| Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
It returns the Missing items for Post Admission Requirements
| 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) | 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 | |
| ADM_CAL_TYPE | VARCHAR2 | (10) | Yes | Describes the admission calendar type to which theadmission application applies |
| ADM_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Describes the admission calendar sequence number that theadmission application is for |
| ACAD_CAL_TYPE | VARCHAR2 | (10) | Yes | Describes the academic calendar type to which theadmission application relates |
| ACAD_CI_SEQUENCE_NUMBER | NUMBER | (6) | Yes | Describes the academic 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 | Describes the unique identifier of an admission program application instance. The unique identifier is required to allow for preferences on location code, attendance mode, attendance type andunit set code. |
| ADM_DOC_STATUS | VARCHAR2 | (10) | Yes | Describes the documentation status of the admission program application instance |
| ORG_UNIT_CD | VARCHAR2 | (30) | Yes | Code of the organizational unit responsible for the program version. |
| COURSE_TITLE | VARCHAR2 | (90) | Yes | Title or full name of the program. |
| ITEM_DESCRIPTION | VARCHAR2 | (60) | Yes | Tracking Item Description |
| COMPLETION_DUE_DATE | DATE | Completion due date | ||
| STEP_DESCRIPTION | VARCHAR2 | (60) | Yes | Tracking Step Description |
| STEP_DUE_DATE | VARCHAR2 | (11) | Tracking completion due date | |
| PERSON_NAME_ADDRESS | VARCHAR2 | (4000) | Concatenated field which includes the Address Lines , postal code , city and the country | |
| LOCATION_DESC | VARCHAR2 | (60) | Location Description | |
| ATTENDENCE_MODE_DESC | VARCHAR2 | (60) | Attendance Mode Description | |
| ATTENDENCE_TYPE_DESC | VARCHAR2 | (60) | Attendance Type Description | |
| PERS_GROUP_ID | NUMBER | (6) | Person Group Identifier | |
| S_ADM_OUTCOME_STATUS | VARCHAR2 | (30) | Yes | System Admission Outcome Status |
| ADM_OUTCOME_STATUS | VARCHAR2 | (10) | Yes | Admission Outcome Status |
| ADM_PROCESS_CAT | VARCHAR2 | (91) | Admission Process Category | |
| TODAYS_DATE | VARCHAR2 | (17) | Today's Date | |
| 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
, ADM_CAL_TYPE
, ADM_CI_SEQUENCE_NUMBER
, ACAD_CAL_TYPE
, ACAD_CI_SEQUENCE_NUMBER
, ADM_APPL_NUMBER
, NOMINATED_COURSE_CD
, APPL_SEQUENCE_NUMBER
, ADM_DOC_STATUS
, ORG_UNIT_CD
, COURSE_TITLE
, ITEM_DESCRIPTION
, COMPLETION_DUE_DATE
, STEP_DESCRIPTION
, STEP_DUE_DATE
, PERSON_NAME_ADDRESS
, LOCATION_DESC
, ATTENDENCE_MODE_DESC
, ATTENDENCE_TYPE_DESC
, PERS_GROUP_ID
, S_ADM_OUTCOME_STATUS
, ADM_OUTCOME_STATUS
, ADM_PROCESS_CAT
, TODAYS_DATE
, APPLICATION_ID
FROM APPS.IGS_AD_POSTADM_MISS_ITM_LTR_V;
APPS
HZ_PARTIES
IGS_AD_APLINS_ADMREQ
IGS_AD_APPL_ALL
IGS_AD_APPL_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_AD_POSTADM_MISS_ITM_LTR_V is not referenced by any database object
|
|
|
|