eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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:	IGS.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:

APPS: HZ_PARTIES; IGS_AD_APPL_ADMAPPL_V; IGS_AD_APPL_ALL; IGS_AD_APPL_STAT; IGS_AD_CODE_CLASSES; IGS_AD_INTVW_PNLS; IGS_AD_OU_STAT; IGS_AD_PNMEMBR_DTLS_V; IGS_AD_PRCS_CAT_STEP; IGS_AD_PS_APPL_INST_ALL; IGS_AD_SCRN_INT_PANEL_DTLS_V; IGS_CO_GEN_003 - show dependent code; IGS_PE_HZ_PARTIES; IGS_PE_PRSID_GRP_MEM_ALL; IGS_PS_VER_ALL

APPS.IGS_AD_INTERVIEW_LETTERS_V is referenced by following:

APPS: IGS_CO_SUBMIT - show dependent code