[Home] [Help] [Dependency Information]
Object Name: | IGF_AP_BATCH_AW_MAP_ALL |
---|---|
Object Type: | TABLE |
Owner: | IGF |
FND Design Data: | IGF.IGF_AP_BATCH_AW_MAP_ALL |
Subobject Name: | |
Status: | VALID |
IGF_AP_BATCH_AW_MAP_ALL stores the ISIR batch year and award year mapping.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
IGF_AP_BATCH_AW_MAP_ALL_PK | NORMAL | UNIQUE | APPS_TS_TX_IDX | BAM_ID |
IGF_AP_BATCH_AW_MAP_ALL_U2 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
CI_CAL_TYPE
CI_SEQUENCE_NUMBER |
IGF_AP_BATCH_AW_MAP_ALL_U6 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SYS_AWARD_YEAR |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
BATCH_YEAR | NUMBER | (2) | Contains batch year as present in ISIR data file | |
CI_SEQUENCE_NUMBER | NUMBER | (15) | Yes | Indicates unique identifier for award year calendar instance |
CI_CAL_TYPE | VARCHAR2 | (10) | Yes | Indicates code for award year calendar type. Used within operating unit. |
CI_SEQUENCE_NUMBER_ACAD | NUMBER | (15) | Indicates unique identifier for academic year calendar instance - Obsoleted | |
CI_CAL_TYPE_ACAD | VARCHAR2 | (10) | Indicates code for academic year calendar type. Used within operating unit. - Obsoleted | |
CI_CAL_TYPE_ADM | VARCHAR2 | (10) | Indicates code for admission calendar type. Used within operating unit. - Obsoleted | |
CI_SEQUENCE_NUMBER_ADM | NUMBER | (15) | Indicates unique identifier for admission calendar instance - Obsoleted | |
CSS_ACADEMIC_YEAR | NUMBER | CSS Academic Year | ||
CREATED_BY | NUMBER | (15) | Yes | Standard Who column |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who column |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
ORG_ID | NUMBER | (15) | Operating unit identifier | |
BAM_ID | NUMBER | (15) | Yes | Identifier for the ISIR batch year and Award year mapping |
EFC_FRML | VARCHAR2 | (30) | EFC formula code with lookup_type as 'IGF_AP_EFC_FRML' | |
NUM_DAYS_DIVISOR | NUMBER | (2) | Status values - 28/29/30/31 | |
ROUNDOFF_FACT | VARCHAR2 | (30) | Stores the round off factor code. comes from lookups with lookup_type 'IGF_AP_EFC_ROUND_FACT' | |
EFC_DOB | DATE | Indicates Default Date of Birth for Family Contribution Calculation | ||
DL_CODE | VARCHAR2 | (30) | Indicates Direct Loan Record Version | |
FFEL_CODE | VARCHAR2 | (30) | Indicates FFEL Record Version | |
PELL_CODE | VARCHAR2 | (30) | Indicates Pell Record Version | |
ISIR_CODE | VARCHAR2 | (30) | Indicates ISIR Record Version | |
PROFILE_CODE | VARCHAR2 | (30) | Indicates Profile Record Version | |
SYS_AWARD_YEAR | VARCHAR2 | (30) | Stores the system award year to which the Financial aid award year , ISIR batch year and Profile year map | |
TOLERANCE_LIMIT | NUMBER | (14) | Indicates extent to which any difference in ISIR amount and verification amount is ignored | |
AWARD_YEAR_STATUS_CODE | VARCHAR2 | (30) | Indicates which award years that are open, closed or which years contain historical legacy to Financial Aid | |
PELL_PARTICIPANT_CODE | VARCHAR2 | (80) | Indicates whether the school is full participant or phase-in-participant for Pell | |
DL_PARTICIPANT_CODE | VARCHAR2 | (80) | Indicates whether the school is full participant or phase-in-participant for Direct Loan | |
PUBLISH_IN_SS_FLAG | VARCHAR2 | (1) | Indicates whether this award year is published to the student in student self-service. |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_YEAR
, CI_SEQUENCE_NUMBER
, CI_CAL_TYPE
, CI_SEQUENCE_NUMBER_ACAD
, CI_CAL_TYPE_ACAD
, CI_CAL_TYPE_ADM
, CI_SEQUENCE_NUMBER_ADM
, CSS_ACADEMIC_YEAR
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, ORG_ID
, BAM_ID
, EFC_FRML
, NUM_DAYS_DIVISOR
, ROUNDOFF_FACT
, EFC_DOB
, DL_CODE
, FFEL_CODE
, PELL_CODE
, ISIR_CODE
, PROFILE_CODE
, SYS_AWARD_YEAR
, TOLERANCE_LIMIT
, AWARD_YEAR_STATUS_CODE
, PELL_PARTICIPANT_CODE
, DL_PARTICIPANT_CODE
, PUBLISH_IN_SS_FLAG
FROM IGF.IGF_AP_BATCH_AW_MAP_ALL;
IGF.IGF_AP_BATCH_AW_MAP_ALL does not reference any database object
IGF.IGF_AP_BATCH_AW_MAP_ALL is referenced by following:
|
|
|