DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.IGF_AP_FA_BASE_REC

Object Details
Object Name: IGF_AP_FA_BASE_REC
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGF_AP_FA_BASE_REC
Subobject Name:
Status: VALID

View Type

A multi-org view which will retrive data for your current operating unit and ignore data in other operating units.


Holds the summarized information of all the financial aid processes for a student for an academic year


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
BASE_ID NUMBER (10) Yes
CI_CAL_TYPE VARCHAR2 (10) Yes
PERSON_ID NUMBER (15) Yes
CI_SEQUENCE_NUMBER NUMBER (6) Yes
ORG_ID NUMBER (15)
EFC_F NUMBER (10)
EFC_I NUMBER (10)
NEED_F NUMBER (10)
NEED_I NUMBER (10)
COA_PENDING VARCHAR2 (30)
VERIFICATION_PROCESS_RUN VARCHAR2 (30)
INST_VERIF_STATUS_DATE DATE

MANUAL_VERIF_FLAG VARCHAR2 (30)
FED_VERIF_STATUS VARCHAR2 (30)
FED_VERIF_STATUS_DATE DATE

INST_VERIF_STATUS VARCHAR2 (30)
NSLDS_ELIGIBLE VARCHAR2 (30)
EDE_CORRECTION_BATCH_ID VARCHAR2 (25)
FA_PROCESS_STATUS_DATE DATE

ISIR_CORR_STATUS VARCHAR2 (30)
ISIR_CORR_STATUS_DATE DATE

ISIR_STATUS VARCHAR2 (30)
ISIR_STATUS_DATE DATE

PROFILE_STATUS VARCHAR2 (30)
PROFILE_STATUS_DATE DATE

PROFILE_FC NUMBER (15)
COA_CODE_F VARCHAR2 (0)
COA_FIXED NUMBER (12)
COA_CODE_I VARCHAR2 (30)
COA_F NUMBER (12)
COA_I NUMBER (12)
COA_PELL NUMBER (12)
DISBURSEMENT_HOLD VARCHAR2 (30)
FA_PROCESS_STATUS VARCHAR2 (30)
NOTIFICATION_STATUS VARCHAR2 (30)
NOTIFICATION_STATUS_DATE DATE

PACKAGING_HOLD VARCHAR2 (0)
Obsolete
NSLDS_DATA_OVERRIDE_FLG VARCHAR2 (30)
PACKAGING_STATUS VARCHAR2 (30)
PROF_JUDGEMENT_FLG VARCHAR2 (30)
PACKAGING_STATUS_DATE DATE

PAYMENT_ISIR_ID NUMBER (15)
TARGET_GROUP VARCHAR2 (30)
TOTAL_PACKAGE_ACCEPTED NUMBER (11)
TOTAL_PACKAGE_OFFERED NUMBER (11)
ADMSTRUCT_ID VARCHAR2 (50)
ADMSEGMENT_1 VARCHAR2 (150)
ADMSEGMENT_2 VARCHAR2 (150)
ADMSEGMENT_3 VARCHAR2 (150)
ADMSEGMENT_4 VARCHAR2 (150)
ADMSEGMENT_5 VARCHAR2 (150)
ADMSEGMENT_6 VARCHAR2 (150)
ADMSEGMENT_7 VARCHAR2 (150)
ADMSEGMENT_8 VARCHAR2 (150)
ADMSEGMENT_9 VARCHAR2 (150)
ADMSEGMENT_10 VARCHAR2 (150)
ADMSEGMENT_11 VARCHAR2 (150)
ADMSEGMENT_12 VARCHAR2 (150)
ADMSEGMENT_13 VARCHAR2 (150)
ADMSEGMENT_14 VARCHAR2 (150)
ADMSEGMENT_15 VARCHAR2 (150)
ADMSEGMENT_16 VARCHAR2 (150)
ADMSEGMENT_17 VARCHAR2 (150)
ADMSEGMENT_18 VARCHAR2 (150)
ADMSEGMENT_19 VARCHAR2 (150)
ADMSEGMENT_20 VARCHAR2 (150)
PACKSTRUCT_ID VARCHAR2 (50)
PACKSEGMENT_1 VARCHAR2 (150)
PACKSEGMENT_2 VARCHAR2 (150)
PACKSEGMENT_3 VARCHAR2 (150)
PACKSEGMENT_4 VARCHAR2 (150)
PACKSEGMENT_5 VARCHAR2 (150)
PACKSEGMENT_6 VARCHAR2 (150)
PACKSEGMENT_7 VARCHAR2 (150)
PACKSEGMENT_8 VARCHAR2 (150)
PACKSEGMENT_9 VARCHAR2 (150)
PACKSEGMENT_10 VARCHAR2 (150)
PACKSEGMENT_11 VARCHAR2 (150)
PACKSEGMENT_12 VARCHAR2 (150)
PACKSEGMENT_13 VARCHAR2 (150)
PACKSEGMENT_14 VARCHAR2 (150)
PACKSEGMENT_15 VARCHAR2 (150)
PACKSEGMENT_16 VARCHAR2 (150)
PACKSEGMENT_17 VARCHAR2 (150)
PACKSEGMENT_18 VARCHAR2 (150)
PACKSEGMENT_19 VARCHAR2 (150)
PACKSEGMENT_20 VARCHAR2 (150)
MISCSTRUCT_ID VARCHAR2 (50)
MISCSEGMENT_1 VARCHAR2 (150)
MISCSEGMENT_2 VARCHAR2 (150)
MISCSEGMENT_3 VARCHAR2 (150)
MISCSEGMENT_4 VARCHAR2 (150)
MISCSEGMENT_5 VARCHAR2 (150)
MISCSEGMENT_6 VARCHAR2 (150)
MISCSEGMENT_7 VARCHAR2 (150)
MISCSEGMENT_8 VARCHAR2 (150)
MISCSEGMENT_9 VARCHAR2 (150)
MISCSEGMENT_10 VARCHAR2 (150)
MISCSEGMENT_11 VARCHAR2 (150)
MISCSEGMENT_12 VARCHAR2 (150)
MISCSEGMENT_13 VARCHAR2 (150)
MISCSEGMENT_14 VARCHAR2 (150)
MISCSEGMENT_15 VARCHAR2 (150)
MISCSEGMENT_16 VARCHAR2 (150)
MISCSEGMENT_17 VARCHAR2 (150)
MISCSEGMENT_18 VARCHAR2 (150)
MISCSEGMENT_19 VARCHAR2 (150)
MISCSEGMENT_20 VARCHAR2 (150)
TOLERANCE_AMOUNT NUMBER (15)
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

MANUAL_DISB_HOLD VARCHAR2 (1)
Indicates whether the Hold Disbursement for Manual Re-award checkbox is checked or not
PELL_ALT_EXPENSE NUMBER (15)
Alternate Pell Expense calculated for the student
ASSOC_ORG_NUM NUMBER

Associated Organization with the Student in the Award Year
AWARD_FMLY_CONTRIBUTION_TYPE VARCHAR2 (1)
To identify whether the Family contribution is Primary or Secondary EFC Type
ISIR_LOCKED_BY NUMBER (15)
Holds the User ID of the Person, who has locked the ISIR.
ADNL_UNSUB_LOAN_ELIG_FLAG VARCHAR2 (1)
Flag indicates if the Student is eligible for additional unsubsidized Loan.
LOCK_AWD_FLAG VARCHAR2 (1)
Lock Awards indicator
LOCK_COA_FLAG VARCHAR2 (1)
Lock Cost of Attendance indicator
Query Text

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


SELECT ROW_ID
,      BASE_ID
,      CI_CAL_TYPE
,      PERSON_ID
,      CI_SEQUENCE_NUMBER
,      ORG_ID
,      EFC_F
,      EFC_I
,      NEED_F
,      NEED_I
,      COA_PENDING
,      VERIFICATION_PROCESS_RUN
,      INST_VERIF_STATUS_DATE
,      MANUAL_VERIF_FLAG
,      FED_VERIF_STATUS
,      FED_VERIF_STATUS_DATE
,      INST_VERIF_STATUS
,      NSLDS_ELIGIBLE
,      EDE_CORRECTION_BATCH_ID
,      FA_PROCESS_STATUS_DATE
,      ISIR_CORR_STATUS
,      ISIR_CORR_STATUS_DATE
,      ISIR_STATUS
,      ISIR_STATUS_DATE
,      PROFILE_STATUS
,      PROFILE_STATUS_DATE
,      PROFILE_FC
,      COA_CODE_F
,      COA_FIXED
,      COA_CODE_I
,      COA_F
,      COA_I
,      COA_PELL
,      DISBURSEMENT_HOLD
,      FA_PROCESS_STATUS
,      NOTIFICATION_STATUS
,      NOTIFICATION_STATUS_DATE
,      PACKAGING_HOLD
,      NSLDS_DATA_OVERRIDE_FLG
,      PACKAGING_STATUS
,      PROF_JUDGEMENT_FLG
,      PACKAGING_STATUS_DATE
,      PAYMENT_ISIR_ID
,      TARGET_GROUP
,      TOTAL_PACKAGE_ACCEPTED
,      TOTAL_PACKAGE_OFFERED
,      ADMSTRUCT_ID
,      ADMSEGMENT_1
,      ADMSEGMENT_2
,      ADMSEGMENT_3
,      ADMSEGMENT_4
,      ADMSEGMENT_5
,      ADMSEGMENT_6
,      ADMSEGMENT_7
,      ADMSEGMENT_8
,      ADMSEGMENT_9
,      ADMSEGMENT_10
,      ADMSEGMENT_11
,      ADMSEGMENT_12
,      ADMSEGMENT_13
,      ADMSEGMENT_14
,      ADMSEGMENT_15
,      ADMSEGMENT_16
,      ADMSEGMENT_17
,      ADMSEGMENT_18
,      ADMSEGMENT_19
,      ADMSEGMENT_20
,      PACKSTRUCT_ID
,      PACKSEGMENT_1
,      PACKSEGMENT_2
,      PACKSEGMENT_3
,      PACKSEGMENT_4
,      PACKSEGMENT_5
,      PACKSEGMENT_6
,      PACKSEGMENT_7
,      PACKSEGMENT_8
,      PACKSEGMENT_9
,      PACKSEGMENT_10
,      PACKSEGMENT_11
,      PACKSEGMENT_12
,      PACKSEGMENT_13
,      PACKSEGMENT_14
,      PACKSEGMENT_15
,      PACKSEGMENT_16
,      PACKSEGMENT_17
,      PACKSEGMENT_18
,      PACKSEGMENT_19
,      PACKSEGMENT_20
,      MISCSTRUCT_ID
,      MISCSEGMENT_1
,      MISCSEGMENT_2
,      MISCSEGMENT_3
,      MISCSEGMENT_4
,      MISCSEGMENT_5
,      MISCSEGMENT_6
,      MISCSEGMENT_7
,      MISCSEGMENT_8
,      MISCSEGMENT_9
,      MISCSEGMENT_10
,      MISCSEGMENT_11
,      MISCSEGMENT_12
,      MISCSEGMENT_13
,      MISCSEGMENT_14
,      MISCSEGMENT_15
,      MISCSEGMENT_16
,      MISCSEGMENT_17
,      MISCSEGMENT_18
,      MISCSEGMENT_19
,      MISCSEGMENT_20
,      TOLERANCE_AMOUNT
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      MANUAL_DISB_HOLD
,      PELL_ALT_EXPENSE
,      ASSOC_ORG_NUM
,      AWARD_FMLY_CONTRIBUTION_TYPE
,      ISIR_LOCKED_BY
,      ADNL_UNSUB_LOAN_ELIG_FLAG
,      LOCK_AWD_FLAG
,      LOCK_COA_FLAG
FROM APPS.IGF_AP_FA_BASE_REC;

Dependencies

[top of page]

APPS.IGF_AP_FA_BASE_REC references the following:

SchemaAPPS
SynonymIGF_AP_FA_BASE_REC_ALL
APPS.IGF_AP_FA_BASE_REC is referenced by following:

SchemaAPPS
ViewIGF_AP_APP_ST_APLINST_V
Package BodyIGF_AP_BATCH_VER_PRC_PKG - show dependent code
ViewIGF_AP_CSS_PROFILE_V
Package BodyIGF_AP_EFC_CALC - show dependent code
PL/SQL PackageIGF_AP_EFC_CALC - show dependent code
ViewIGF_AP_EFC_DET_V
ViewIGF_AP_FA_BASE_RESULTS_V
Package BodyIGF_AP_ISIR_GEN_PKG - show dependent code
Package BodyIGF_AP_ISIR_IMPORT_PKG - show dependent code
ViewIGF_AP_ISIR_INFO_V
Package BodyIGF_AP_ISIR_MATCHED_PKG - show dependent code
Package BodyIGF_AP_LG_COA_IMP - show dependent code
Package BodyIGF_AP_LG_TD_IMP - show dependent code
Package BodyIGF_AP_LG_VER_IMP - show dependent code
Package BodyIGF_AP_LI_ISIR_IMP_PROC - show dependent code
Package BodyIGF_AP_MATCHING_PROCESS_PKG - show dependent code
Package BodyIGF_AP_OSS_INTR_DTLS - show dependent code
Package BodyIGF_AP_PROCESS_CORRECTIONS - show dependent code
PL/SQL PackageIGF_AP_PROFILE_MATCHING_PKG - show dependent code
Package BodyIGF_AP_PROFILE_MATCHING_PKG - show dependent code
Package BodyIGF_AP_TODO_GRPS_PRC_PKG - show dependent code
Package BodyIGF_AP_VER_GRPS_PRC_PKG - show dependent code
ViewIGF_AW_AWARD_V
Package BodyIGF_AW_CANCEL_AWD - show dependent code
Package BodyIGF_AW_COA_CALC - show dependent code
Package BodyIGF_AW_COA_GEN - show dependent code
ViewIGF_AW_COA_HIST_V
Package BodyIGF_AW_COA_UPDATE - show dependent code
Package BodyIGF_AW_FISAP_PKG - show dependent code
Package BodyIGF_AW_GEN - show dependent code
PL/SQL PackageIGF_AW_GEN - show dependent code
PL/SQL PackageIGF_AW_GEN_002 - show dependent code
Package BodyIGF_AW_GEN_002 - show dependent code
Package BodyIGF_AW_GEN_003 - show dependent code
PL/SQL PackageIGF_AW_GEN_003 - show dependent code
Package BodyIGF_AW_GEN_004 - show dependent code
Package BodyIGF_AW_MANAGE_AWD - show dependent code
ViewIGF_AW_NEED_ANLY_V
Package BodyIGF_AW_PACKAGING - show dependent code
PL/SQL PackageIGF_AW_PACKAGING - show dependent code
Package BodyIGF_AW_PACKNG_SUBFNS - show dependent code
PL/SQL PackageIGF_AW_PACKNG_SUBFNS - show dependent code
Package BodyIGF_AW_RULE - show dependent code
Package BodyIGF_AW_SS_GEN_PKG - show dependent code
ViewIGF_AW_STUD_AWD_TOTAL_V
ViewIGF_AW_STUD_AWD_TOT_V
Package BodyIGF_DB_DISB - show dependent code
Package BodyIGF_DB_DL_DISB_ORIG - show dependent code
Package BodyIGF_DB_SF_INTEGRATION - show dependent code
PL/SQL PackageIGF_GR_GEN - show dependent code
Package BodyIGF_GR_GEN - show dependent code
Package BodyIGF_GR_PELL - show dependent code
PL/SQL PackageIGF_GR_PELL_CALC - show dependent code
Package BodyIGF_GR_PELL_CALC - show dependent code
ViewIGF_GR_PERSON_V
Package BodyIGF_GR_VERIFY_PROCESS - show dependent code
Package BodyIGF_SE_GEN_001 - show dependent code
PL/SQL PackageIGF_SE_GEN_001 - show dependent code
Package BodyIGF_SL_CL_LI_IMP_PKG - show dependent code
Package BodyIGF_SL_CL_ORIG - show dependent code
Package BodyIGF_SL_CL_ORIG_ACK - show dependent code
Package BodyIGF_SL_CL_VALIDATION - show dependent code
Package BodyIGF_SL_DL_CHG_ORIG - show dependent code
Package BodyIGF_SL_DL_LI_IMP_PKG - show dependent code
Package BodyIGF_SL_DL_ORIG - show dependent code
Package BodyIGF_SL_DL_PRINT_MANIFEST - show dependent code
Package BodyIGF_SL_DL_PRINT_PNOTE - show dependent code
Package BodyIGF_SL_DL_RECORD - show dependent code
Package BodyIGF_SL_DL_VALIDATION - show dependent code
Package BodyIGF_SL_LAR_CREATION - show dependent code
ViewIGF_SL_LOANS_SUM_V
ViewIGF_SL_LOANS_V
ViewIGF_SL_LOR_V
ViewIGF_SL_PLUS_LOAN_DETAILS_V
ViewIGF_SL_PRK_LOAN_V
Package BodyIGF_SL_REL_DISB - show dependent code
Package BodyIGF_SP_ASSIGN_PUB - show dependent code
Package BodyIGF_SP_AWARD - show dependent code
Package BodyIGF_SP_CREATE_BASE_REC - show dependent code
PL/SQL PackageIGF_SP_CREATE_BASE_REC - show dependent code
Package BodyIGF_SP_ROLLOVER - show dependent code
ViewIGF_SP_STDNT_REL_V
Package BodyIGS_FI_BILL_EXTRACT - show dependent code
Package BodyIGS_FI_GEN_001 - show dependent code
ViewIGS_FI_PLN_CREDITS_V
Package BodyIGS_HE_EXTRACT_FIELDS_PKG - show dependent code