[Home] [Help] [Dependency Information]
Object Name: | IGF_GR_RESP_DTLS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGF_GR_RESP_DTLS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DOCUMENT_ID_TXT | VARCHAR2 | (30) | Yes | Indicates the Document ID |
DOC_CREATED_DATE | DATE | Indicates the created date | ||
SOURCE_ENTITY_ID_TXT | VARCHAR2 | (30) | Indicates the source entity id | |
DEST_ENTITY_ID_TXT | VARCHAR2 | (30) | Indicates the destination entity id | |
SOFT_PROVIDER | VARCHAR2 | (30) | Indicates the software provider | |
SOFT_VERSION | VARCHAR2 | (30) | Indicates the software version | |
FULL_RESP_CODE | VARCHAR2 | (30) | Indicates the full response code | |
RECEIPT_DATE | DATE | Indicates the receipt | ||
DOC_TYPE_CODE | VARCHAR2 | (30) | Indicates the document type code | |
DOC_STATUS_CODE | VARCHAR2 | (30) | Indicates the document status | |
PROCESS_DATE | DATE | Indicates the process date | ||
REP_SCHL_RESP_ID | NUMBER | Yes | Indicates the reporting school response id | |
REP_ENTITY_ID_TXT | VARCHAR2 | (30) | Indicates the reporting entity id | |
REP_RESP_CODE | VARCHAR2 | (30) | Indicates the reporting school response code | |
ATT_SCHL_RESP_ID | NUMBER | Yes | Indicates the attending school response id | |
ATD_ENTITY_ID_TXT | VARCHAR2 | (30) | Indicates the attending entity id | |
ATT_RESP_CODE | VARCHAR2 | (30) | Indicates the attending response code | |
STDNT_RESP_ID | NUMBER | Yes | Indicates the student's response id | |
S_SSN | VARCHAR2 | (30) | Yes | Indicates the student's social security number |
FIRST_NAME | VARCHAR2 | (60) | Indicates the student's first name | |
S_LAST_NAME | VARCHAR2 | (60) | Yes | Indicates the student's last name |
S_DATE_OF_BIRTH | DATE | Yes | Indicates the student's date of birth | |
STUDENT_RESP_CODE | VARCHAR2 | (30) | Indicates the student's response code | |
PELL_RESP_ID | NUMBER | Yes | Indicates the pell response id | |
FIN_AWD_YR | VARCHAR2 | (30) | Indicates the financial award year | |
CPS_TRANS_NUM | VARCHAR2 | (2) | Indicates the CPS transaction number | |
AWARD_AMT | NUMBER | Indicates the award amount | ||
NOTE_MESSAGE | VARCHAR2 | (100) | Indicates the Note message | |
COA_AMT | NUMBER | Indicates the cost of attendance amount | ||
LOW_TUTION_FEE | VARCHAR2 | (30) | Indicates the low tuition fee. | |
INCARC_FLAG | VARCHAR2 | (30) | Indicates the incarcerated indicator | |
VER_STATUS_CODE | VARCHAR2 | (30) | Indicates the verification status code. | |
ENROLLMENT_DATE | DATE | Indicates the enrollment date. | ||
SEC_EFC_CODE | VARCHAR2 | (30) | Indicates the secondary efc code | |
YTD_DISB_AMT | NUMBER | Indicates the year to date disbursement amount | ||
TOT_ELIG_USED | NUMBER | Indicates the total eligible amount used | ||
SCHD_PELL_AMT | NUMBER | Indicates the scheduled pell amount | ||
NEG_PEND_AMT | NUMBER | Indicates the negative pending amount | ||
FSA_CODE_1 | VARCHAR2 | (30) | Indicates the FSA code | |
FSA_CODE_2 | VARCHAR2 | (30) | Indicates the FSA code | |
FSA_CODE_3 | VARCHAR2 | (30) | Indicates the FSA code | |
CPS_VERIF_FLAG | VARCHAR2 | (30) | Indicates the CPS verification flag. | |
HIGH_CPS_TRANS_NUM | NUMBER | Indicates the high CPS transaction number | ||
PELL_RESP_CODE | VARCHAR2 | (30) | Indicates the pell response code. |
Cut, paste (and edit) the following text to query this object:
SELECT DOCUMENT_ID_TXT
, DOC_CREATED_DATE
, SOURCE_ENTITY_ID_TXT
, DEST_ENTITY_ID_TXT
, SOFT_PROVIDER
, SOFT_VERSION
, FULL_RESP_CODE
, RECEIPT_DATE
, DOC_TYPE_CODE
, DOC_STATUS_CODE
, PROCESS_DATE
, REP_SCHL_RESP_ID
, REP_ENTITY_ID_TXT
, REP_RESP_CODE
, ATT_SCHL_RESP_ID
, ATD_ENTITY_ID_TXT
, ATT_RESP_CODE
, STDNT_RESP_ID
, S_SSN
, FIRST_NAME
, S_LAST_NAME
, S_DATE_OF_BIRTH
, STUDENT_RESP_CODE
, PELL_RESP_ID
, FIN_AWD_YR
, CPS_TRANS_NUM
, AWARD_AMT
, NOTE_MESSAGE
, COA_AMT
, LOW_TUTION_FEE
, INCARC_FLAG
, VER_STATUS_CODE
, ENROLLMENT_DATE
, SEC_EFC_CODE
, YTD_DISB_AMT
, TOT_ELIG_USED
, SCHD_PELL_AMT
, NEG_PEND_AMT
, FSA_CODE_1
, FSA_CODE_2
, FSA_CODE_3
, CPS_VERIF_FLAG
, HIGH_CPS_TRANS_NUM
, PELL_RESP_CODE
FROM APPS.IGF_GR_RESP_DTLS_V;
APPS.IGF_GR_RESP_DTLS_V is not referenced by any database object
|
|
|