[Home] [Help] [Dependency Information]
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
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_SL_ST_RESP_DTLS_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | STDNT_RESP_ID |
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 |
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;
IGF.IGF_SL_ST_RESP_DTLS does not reference any database object
IGF.IGF_SL_ST_RESP_DTLS is referenced by following:
|
|
|