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]

TABLE: IGF.IGF_SL_ST_RESP_DTLS

Object Details

Object Name:	IGF_SL_ST_RESP_DTLS
Object Type:	TABLE
Owner:	IGF
FND Design Data:	IGF.IGF_SL_ST_RESP_DTLS
Subobject Name:
Status:	VALID

Table storing the Student Tag Response Elements from the response XML file

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
IGF_SL_ST_RESP_DTLS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	STDNT_RESP_ID

Columns

Name	Datatype	Length	Mandatory	Comments
STDNT_RESP_ID	NUMBER		Yes	Identifier for the student response records
ATD_SCHL_RESP_ID	NUMBER			Identifier for the corresponding attending school response record.
S_SSN	VARCHAR2	(30)	Yes	Indicates the current Social Security Number of the student
DRIVER_LIC_STATE	VARCHAR2	(60)		Attribute indicating the person's driver's License State.
DRIVER_LIC_NUMBER	VARCHAR2	(30)		Attribute indicating the person's driver's License Number.
S_DATE_OF_BIRTH	DATE		Yes	Attribute indicating the person's Date of birth.
FIRST_NAME	VARCHAR2	(60)		Attribute indicating the person's First name
MIDDLE_NAME	VARCHAR2	(60)		Attribute indicating the person's Middle name.
S_LAST_NAME	VARCHAR2	(60)	Yes	Attribute indicating the person's Last name.
S_CHG_DATE_OF_BIRTH	DATE			Indicates the changed Date of Birth
S_CHG_LAST_NAME	VARCHAR2	(60)		Indicates the changed Last Name
S_CHG_SSN	VARCHAR2	(30)		Indicates the changed SSN
PERMT_ADDR_FOREIGN_FLAG	VARCHAR2	(60)		Indicates if the permanent address is foreign or not.
ADDR_TYPE_CODE	VARCHAR2	(30)		Indicates whether the address is Permanent or Temporary
PERMT_ADDR_LINE_1	VARCHAR2	(40)		Indicates the first line of permanent address
PERMT_ADDR_LINE_2	VARCHAR2	(40)		Indicates the second line of permanent address
PERMT_ADDR_LINE_3	VARCHAR2	(40)		Indicates the third line of permanent address
PERMT_ADDR_CITY	VARCHAR2	(60)		Indicates the permanent address's city
PERMT_ADDR_STATE_CODE	VARCHAR2	(30)		Indicates the permanent address's state code
PERMT_ADDR_POST_CODE	VARCHAR2	(30)		Indicates the permanent address's postal Code (zip code).
PERMT_ADDR_COUNTY	VARCHAR2	(30)		Indicates the permanent address's county
PERMT_ADDR_COUNTRY	VARCHAR2	(30)		Indicates the permanent address's country
PHONE_NUMBER_1	VARCHAR2	(30)		Indicating the person's phone number. There can be maximum of three phonenumbers for a person.
PHONE_NUMBER_2	VARCHAR2	(30)		Indicating the person's phone number. There can be maximum of three phonenumbers for a person.
PHONE_NUMBER_3	VARCHAR2	(30)		Indicating the person's phone number. There can be maximum of three phonenumbers for a person.
TEMP_ADDR_FOREIGN_FLAG	VARCHAR2	(30)		Indicates if the temporary address is foreign or not.
TEMP_ADDR_LINE_1	VARCHAR2	(40)		Indicates the first line of temporary address
TEMP_ADDR_LINE_2	VARCHAR2	(40)		Indicates the second line of temporary address
TEMP_ADDR_LINE_3	VARCHAR2	(40)		Indicates the third line of temporary address
TEMP_ADDR_CITY	VARCHAR2	(60)		Indicates the temporary address's city
TEMP_ADDR_STATE_CODE	VARCHAR2	(30)		Indicates the temporary address's state code
TEMP_ADDR_POST_CODE	VARCHAR2	(30)		Indicates the temporary address's postal Code (zip code).
TEMP_ADDR_COUNTY	VARCHAR2	(30)		Indicates the temporary address's county
TEMP_ADDR_COUNTRY	VARCHAR2	(30)		Indicates the temporary address's country
EMAIL_ADDRESS	VARCHAR2	(138)		Indicates the E-mail address of the person
CITZN_STATUS_CODE	VARCHAR2	(30)		Indicates the citizenship status code of the person
NOTE_MESSAGE	VARCHAR2	(100)		Indicates the Note Message
RESP_CODE	VARCHAR2	(30)		Indicates the Response Code
CREATED_BY	NUMBER	(15)		Standard Who column
CREATION_DATE	DATE			Standard Who column
LAST_UPDATED_BY	NUMBER	(15)		Standard Who column
LAST_UPDATE_DATE	DATE			Standard Who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who column
PROGRAM_APPLICATION_ID	NUMBER	(15)		Standard Who column
PROGRAM_ID	NUMBER	(15)		Standard Who column
PROGRAM_UPDATE_DATE	DATE			Standard Who column
REQUEST_ID	NUMBER	(15)		Standard Who column

Query Text

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


SELECT STDNT_RESP_ID
,      ATD_SCHL_RESP_ID
,      S_SSN
,      DRIVER_LIC_STATE
,      DRIVER_LIC_NUMBER
,      S_DATE_OF_BIRTH
,      FIRST_NAME
,      MIDDLE_NAME
,      S_LAST_NAME
,      S_CHG_DATE_OF_BIRTH
,      S_CHG_LAST_NAME
,      S_CHG_SSN
,      PERMT_ADDR_FOREIGN_FLAG
,      ADDR_TYPE_CODE
,      PERMT_ADDR_LINE_1
,      PERMT_ADDR_LINE_2
,      PERMT_ADDR_LINE_3
,      PERMT_ADDR_CITY
,      PERMT_ADDR_STATE_CODE
,      PERMT_ADDR_POST_CODE
,      PERMT_ADDR_COUNTY
,      PERMT_ADDR_COUNTRY
,      PHONE_NUMBER_1
,      PHONE_NUMBER_2
,      PHONE_NUMBER_3
,      TEMP_ADDR_FOREIGN_FLAG
,      TEMP_ADDR_LINE_1
,      TEMP_ADDR_LINE_2
,      TEMP_ADDR_LINE_3
,      TEMP_ADDR_CITY
,      TEMP_ADDR_STATE_CODE
,      TEMP_ADDR_POST_CODE
,      TEMP_ADDR_COUNTY
,      TEMP_ADDR_COUNTRY
,      EMAIL_ADDRESS
,      CITZN_STATUS_CODE
,      NOTE_MESSAGE
,      RESP_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
FROM IGF.IGF_SL_ST_RESP_DTLS;

Dependencies

[top of page]

IGF.IGF_SL_ST_RESP_DTLS does not reference any database object

IGF.IGF_SL_ST_RESP_DTLS is referenced by following:

APPS: IGF_SL_ST_RESP_DTLS