[Home] [Help] [Dependency Information]
Object Name: | IGF_GR_MRR |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | IGF.IGF_GR_MRR |
Subobject Name: | |
Status: | VALID |
A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ROW_ID | ROWID | (10) | ||
MRR_ID | NUMBER | (15) | Yes | |
RECORD_TYPE | VARCHAR2 | (2) | ||
REQ_INST_PELL_ID | VARCHAR2 | (30) | ||
MRR_CODE1 | VARCHAR2 | (30) | ||
MRR_CODE2 | VARCHAR2 | (30) | ||
MR_STUD_ID | VARCHAR2 | (30) | ||
MR_INST_PELL_ID | VARCHAR2 | (30) | ||
STUD_ORIG_SSN | VARCHAR2 | (9) | ||
ORIG_NAME_CD | VARCHAR2 | (2) | ||
INST_PELL_ID | VARCHAR2 | (30) | ||
INST_NAME | VARCHAR2 | (70) | ||
INST_ADDR1 | VARCHAR2 | (35) | ||
INST_ADDR2 | VARCHAR2 | (35) | ||
INST_CITY | VARCHAR2 | (25) | ||
INST_STATE | VARCHAR2 | (2) | ||
ZIP_CODE | VARCHAR2 | (9) | ||
FAA_NAME | VARCHAR2 | (30) | ||
FAA_TEL | VARCHAR2 | (30) | ||
FAA_FAX | VARCHAR2 | (30) | ||
FAA_INTERNET_ADDR | VARCHAR2 | (100) | ||
SCHD_PELL_GRANT | NUMBER | (12) | ||
ORIG_AWD_AMT | NUMBER | (12) | ||
TRAN_NUM | VARCHAR2 | (2) | ||
EFC | NUMBER | (12) | ||
ENRL_DT | DATE | |||
ORIG_CREATION_DT | DATE | |||
DISB_ACCEPTED_AMT | NUMBER | (12) | ||
LAST_ACTIVE_DT | DATE | |||
NEXT_EST_DISB_DT | DATE | |||
ELIGIBILITY_USED | NUMBER | (7) | ||
ED_USE_FLAGS | VARCHAR2 | (30) | ||
STUD_LAST_NAME | VARCHAR2 | (30) | ||
STUD_FIRST_NAME | VARCHAR2 | (30) | ||
STUD_MIDDLE_NAME | VARCHAR2 | (30) | ||
STUD_DOB | DATE | |||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
REQUEST_ID | NUMBER | (15) | ||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
ORG_ID | NUMBER | (15) | ||
CURRENT_SSN | VARCHAR2 | (30) |
Cut, paste (and edit) the following text to query this object:
SELECT ROW_ID
, MRR_ID
, RECORD_TYPE
, REQ_INST_PELL_ID
, MRR_CODE1
, MRR_CODE2
, MR_STUD_ID
, MR_INST_PELL_ID
, STUD_ORIG_SSN
, ORIG_NAME_CD
, INST_PELL_ID
, INST_NAME
, INST_ADDR1
, INST_ADDR2
, INST_CITY
, INST_STATE
, ZIP_CODE
, FAA_NAME
, FAA_TEL
, FAA_FAX
, FAA_INTERNET_ADDR
, SCHD_PELL_GRANT
, ORIG_AWD_AMT
, TRAN_NUM
, EFC
, ENRL_DT
, ORIG_CREATION_DT
, DISB_ACCEPTED_AMT
, LAST_ACTIVE_DT
, NEXT_EST_DISB_DT
, ELIGIBILITY_USED
, ED_USE_FLAGS
, STUD_LAST_NAME
, STUD_FIRST_NAME
, STUD_MIDDLE_NAME
, STUD_DOB
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ORG_ID
, CURRENT_SSN
FROM APPS.IGF_GR_MRR;
|
|
|