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

VIEW: APPS.IGS_AD_INTERVIEW_LETTERS_V

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

View Type

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


Admission Interview Letters


[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (15) Yes Person Identifier
PARTY_NAME VARCHAR2 (360) Yes Party Name
PERSON_NUMBER VARCHAR2 (30) Yes Person Number
ADDRESS_LINE1 VARCHAR2 (240)
Address Line 1
ADDRESS_LINE2 VARCHAR2 (240)
Address Line 2
ADDRESS_LINE3 VARCHAR2 (240)
Address Line 3
ADDRESS_LINE4 VARCHAR2 (240)
Address Line 4
CATEGORY_CODE VARCHAR2 (30)
Category Code
CITY VARCHAR2 (60)
City
COUNTRY VARCHAR2 (60)
Country
COUNTY VARCHAR2 (60)
County
EMAIL_ADDRESS VARCHAR2 (2000)
Email Address
PREFERRED_GIVEN_NAME VARCHAR2 (240)
Preferred Given Name
PERSON_ACADEMIC_TITLE VARCHAR2 (30)
Academic Title
GIVEN_NAMES VARCHAR2 (150)
Given Names
PERSON_FIRST_NAME_PHONETIC VARCHAR2 (60)
Person Phonetic First Name
PERSON_IDEN_TYPE VARCHAR2 (30)
Person Identifier Type
PERSON_IDENTIFIER VARCHAR2 (60)
Person Identifier
SURNAME VARCHAR2 (150)
Surname
PERSON_LAST_NAME_PHONETIC VARCHAR2 (60)
Person Phonetic Last Name
MIDDLE_NAME VARCHAR2 (60)
Middle Name
SUFFIX VARCHAR2 (30)
Suffix
PREFIX VARCHAR2 (30)
Prefix
PERSON_PREVIOUS_LAST_NAME VARCHAR2 (150)
Person Previous Last Name
TITLE VARCHAR2 (60)
Title
POSTAL_CODE VARCHAR2 (60)
Postal Code
PROVINCE VARCHAR2 (60)
Province
SALUTATION VARCHAR2 (60)
Salutation
STATE VARCHAR2 (60)
State
STATUS VARCHAR2 (1) Yes Status
PREFERENCE_NUMBER NUMBER (2)
Preference Number
COURSE_CD VARCHAR2 (6) Yes Course Code
COURSE_TITLE VARCHAR2 (90) Yes Course Title
COURSE_OU_CD VARCHAR2 (30) Yes Course
COURSE_OU_DESCRIPTION VARCHAR2 (360) Yes Course Description
COURSE_TYPE VARCHAR2 (10) Yes Course Type
ADMISSION_OUTCOME_STATUS VARCHAR2 (10) Yes Admission Outcome Status
EXPECTED_COURSE_COMPLETE_YEAR NUMBER (4)
Expected Course Completion Year
EXPECTED_COURSE_COMPLETE_PERD VARCHAR2 (1)
Expected Course Completion Period
ACADEMIC_YEAR_ALTERNATE_CODE VARCHAR2 (10)
Academic Year Alternate Code
ACAD_CAL_TYPE VARCHAR2 (10) Yes Academic Calendar type
ACAD_CI_SEQUENCE_NUMBER NUMBER (6) Yes Academic Calendar Sequence Number
ADM_CAL_TYPE VARCHAR2 (10) Yes Admission Calendar Type
ADM_CI_SEQUENCE_NUMBER NUMBER (6) Yes Admission Calendar Sequence Number
APPL_DT DATE
Yes Application Date
COMMENCEMENT_PERIOD VARCHAR2 (21)
Commencement Period
ADMISSION_PROCESS_CATEGORY VARCHAR2 (91)
Admission Process Category
S_ADM_OUTCOME_STATUS VARCHAR2 (30) Yes System Admission Outcome Status
ADM_CNDTNL_OFFER_STATUS VARCHAR2 (10) Yes Admission Conditional Offer Status
PERSON_NAME_ADDRESS VARCHAR2 (4000)
Person Name And Address For Correspondence
TODAYS_DATE VARCHAR2 (17)
Todays Date
PERS_GROUP_ID NUMBER (6)
Person 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 Application Sequence Number
APPLICATION_ID NUMBER (15)
Application Identifier
INTERVIEW_LEVEL VARCHAR2 (30)
Interview Level
PANEL_CODE VARCHAR2 (30) Yes Panel Code
PANEL_DESCRIPTION VARCHAR2 (60) Yes Panel Description
ROLE_TYPE_CODE VARCHAR2 (30) Yes Role Type Code
ROLE_TYPE_DESC VARCHAR2 (80) Yes Role Type Descripton
MEMBER_PERSON_ID NUMBER (15) Yes Interview Panel Member Person Identifier
MEMBER_PERSON_NUMBER VARCHAR2 (30)
Interview Panel Member Person Number
MEMBER_FULL_NAME VARCHAR2 (450)
Interview Panel Member Person Full Name
INTERVIEW_DATE DATE

Interview Date
INTERVIEW_TIME VARCHAR2 (5)
Interview Time
INTW_LOCATION_CD VARCHAR2 (10)
Interview Location Code
INTW_LOCATION_DESC VARCHAR2 (60)
Interview Location Description
ROOM_ID NUMBER

Interview room Identifier
ROOM_CD VARCHAR2 (10)
Interview room Code
ROOM_DESC VARCHAR2 (80)
Interview Room Description
MEMBER_DECISION_CODE VARCHAR2 (30) Yes Interview Panel Member Decision Code
MEMBER_DECISION_CODE_DESC VARCHAR2 (30)
Interview Panel Member Decision
MEMBER_DECISION_TYPE VARCHAR2 (30) Yes Interview Panel Member Decision Type
MEMBER_DECISION_DATE DATE

Interview Panel Member Decision Date
FINAL_DECISION_CODE VARCHAR2 (30) Yes Final Decision Code
FINAL_DECISION_CODE_DESC VARCHAR2 (30)
Final Decision Code Description
FINAL_DECISION_TYPE VARCHAR2 (30) Yes Final Decision Type
FINAL_DECISION_DATE DATE

Final Decision Date
ATTENDANCE_TYPE VARCHAR2 (2)
Attendance Type
ATTENDANCE_MODE VARCHAR2 (2)
Attendance Mode
Query Text

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


SELECT PERSON_ID
,      PARTY_NAME
,      PERSON_NUMBER
,      ADDRESS_LINE1
,      ADDRESS_LINE2
,      ADDRESS_LINE3
,      ADDRESS_LINE4
,      CATEGORY_CODE
,      CITY
,      COUNTRY
,      COUNTY
,      EMAIL_ADDRESS
,      PREFERRED_GIVEN_NAME
,      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
,      SALUTATION
,      STATE
,      STATUS
,      PREFERENCE_NUMBER
,      COURSE_CD
,      COURSE_TITLE
,      COURSE_OU_CD
,      COURSE_OU_DESCRIPTION
,      COURSE_TYPE
,      ADMISSION_OUTCOME_STATUS
,      EXPECTED_COURSE_COMPLETE_YEAR
,      EXPECTED_COURSE_COMPLETE_PERD
,      ACADEMIC_YEAR_ALTERNATE_CODE
,      ACAD_CAL_TYPE
,      ACAD_CI_SEQUENCE_NUMBER
,      ADM_CAL_TYPE
,      ADM_CI_SEQUENCE_NUMBER
,      APPL_DT
,      COMMENCEMENT_PERIOD
,      ADMISSION_PROCESS_CATEGORY
,      S_ADM_OUTCOME_STATUS
,      ADM_CNDTNL_OFFER_STATUS
,      PERSON_NAME_ADDRESS
,      TODAYS_DATE
,      PERS_GROUP_ID
,      ADM_APPL_NUMBER
,      NOMINATED_COURSE_CD
,      APPL_SEQUENCE_NUMBER
,      APPLICATION_ID
,      INTERVIEW_LEVEL
,      PANEL_CODE
,      PANEL_DESCRIPTION
,      ROLE_TYPE_CODE
,      ROLE_TYPE_DESC
,      MEMBER_PERSON_ID
,      MEMBER_PERSON_NUMBER
,      MEMBER_FULL_NAME
,      INTERVIEW_DATE
,      INTERVIEW_TIME
,      INTW_LOCATION_CD
,      INTW_LOCATION_DESC
,      ROOM_ID
,      ROOM_CD
,      ROOM_DESC
,      MEMBER_DECISION_CODE
,      MEMBER_DECISION_CODE_DESC
,      MEMBER_DECISION_TYPE
,      MEMBER_DECISION_DATE
,      FINAL_DECISION_CODE
,      FINAL_DECISION_CODE_DESC
,      FINAL_DECISION_TYPE
,      FINAL_DECISION_DATE
,      ATTENDANCE_TYPE
,      ATTENDANCE_MODE
FROM APPS.IGS_AD_INTERVIEW_LETTERS_V;

Dependencies

[top of page]

APPS.IGS_AD_INTERVIEW_LETTERS_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
ViewIGS_AD_APPL_ADMAPPL_V
SynonymIGS_AD_APPL_ALL
SynonymIGS_AD_APPL_STAT
SynonymIGS_AD_CODE_CLASSES
SynonymIGS_AD_INTVW_PNLS
SynonymIGS_AD_OU_STAT
ViewIGS_AD_PNMEMBR_DTLS_V
ViewIGS_AD_PRCS_CAT_STEP
SynonymIGS_AD_PS_APPL_INST_ALL
ViewIGS_AD_SCRN_INT_PANEL_DTLS_V
PL/SQL PackageIGS_CO_GEN_003 - show dependent code
SynonymIGS_PE_HZ_PARTIES
SynonymIGS_PE_PRSID_GRP_MEM_ALL
SynonymIGS_PS_VER_ALL
APPS.IGS_AD_INTERVIEW_LETTERS_V is referenced by following:

SchemaAPPS
Package BodyIGS_CO_SUBMIT - show dependent code