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

VIEW: APPS.IGF_AP_FA_CON_V

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

View Type

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.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
BASE_ID NUMBER (10) Yes Unique identifier for student financial aid record
PERSON_ID NUMBER (15) Yes Person identifier
CI_CAL_TYPE VARCHAR2 (10) Yes Indicates code for award year calendar type. Used within operating unit.
CI_SEQUENCE_NUMBER NUMBER (6) Yes Indicates unique identifier for award year calendar instance
SSN VARCHAR2 (20)
Social security number
SURNAME VARCHAR2 (150)
Surname
GIVEN_NAMES VARCHAR2 (150)
Given names
FULL_NAME VARCHAR2 (301)
Full name
CI_ALTERNATE_CODE VARCHAR2 (10)
START_DT DATE
Yes Start date
END_DT DATE
Yes End date
PERSON_NUMBER VARCHAR2 (30) Yes
ORG_ID NUMBER (15)
Operating unit identifier
EFC_I VARCHAR2 (0)
Denotes student's EFC as per calculations made by institutional methodology - Obsolete
NEED_I VARCHAR2 (0)
Denotes need calculated as per institutional method - Obsolete
NEED_F VARCHAR2 (0)
Denotes need calculated as per federal method - Obsolete
EFC_F VARCHAR2 (0)
Denotes student's EFC as per calculations made by federal methodology - Obsolete
VERIFICATION_PROCESS_RUN VARCHAR2 (30)
Indicates whether verification selection process has been run on financial aid base record
COA_PENDING VARCHAR2 (30)
Denotes whether cost of attendance calculation is pending
INST_VERIF_STATUS_DATE DATE

Indicates date on which institutional verification flag is set
MANUAL_VERIF_FLAG VARCHAR2 (30)
Indicates whether financial aid record is manually selected for verification
NSLDS_ELIGIBLE VARCHAR2 (30)
Indicates eligibility for NSLDS loans
FED_VERIF_STATUS_DATE DATE

Date when federal verification status is set
FED_VERIF_STATUS VARCHAR2 (30)
Denotes whether selected for federal verification process
INST_VERIF_STATUS VARCHAR2 (30)
Indicates whether selected for institutional verification
ISIR_CORR_STATUS_DATE DATE

Denotes date on which correction status for payment ISIR is updated
EDE_CORRECTION_BATCH_ID VARCHAR2 (25)
Denotes electronic data exchange correction batch identifier
ISIR_CORR_STATUS VARCHAR2 (30)
Denotes status of corrections made to payment ISIR indicated on financial aid base record
ISIR_STATUS_DATE DATE

Denotes date on which ISIR status was set
PROFILE_STATUS VARCHAR2 (30)
Stores the status of profile record added for the student.
PROFILE_STATUS_DATE DATE

Stores the date on which the status of profile record added for the student
PROFILE_FC NUMBER (15)
Holds the Family Contribution from Profile records
FA_PROCESS_STATUS_DATE DATE

Denotes date of overall processing status of financial aid record
ISIR_STATUS VARCHAR2 (30)
Denotes status of payment ISIR
DISBURSEMENT_HOLD VARCHAR2 (30)
Indicates whether disbursements are to be put on hold
COA_CODE_F VARCHAR2 (30)
obsolete
COA_CODE_I VARCHAR2 (30)
obsolete
NOTIFICATION_STATUS VARCHAR2 (30)
Indicates status of award notification
PACKAGING_STATUS VARCHAR2 (30)
Denotes packaging status
PACKAGING_STATUS_DATE DATE

Indicates date on which packaging status was set
PACKAGING_HOLD VARCHAR2 (30)
Obsolete
COA_F NUMBER (12)
Denotes cost of attendance for student calculated as per federal methodology
FA_PROCESS_STATUS VARCHAR2 (30)
Indicates overall processing status of financial aid student
TOTAL_PACKAGE_OFFERED NUMBER (11)
Indicates total package offered
TOTAL_PACKAGE_ACCEPTED NUMBER (11)
Indicates total package accepted
NOTIFICATION_STATUS_DATE DATE

Indicates date on which award notification status was set
COA_I NUMBER (12)
Denotes cost of attendance for student calculated as per institutional methodology
PAYMENT_ISIR_ID VARCHAR2 (0)
Indicates ISIR identifier that is marked for consideration in packaging process - Obsolete
ACTIVE_ISIR VARCHAR2 (13)
DEPENDENCY_STATUS VARCHAR2 (30)
PROF_JUDGEMENT_FLG VARCHAR2 (30)
NSLDS_DATA_OVERRIDE_FLG VARCHAR2 (30)
Indicates whether student data mentioned in NSLDS files can be overridden at time of loan processing
NSLDS_MATCH_FLAG VARCHAR2 (30)
COA_FIXED NUMBER (12)
Denotes cost of attendance for fixed items
COA_PELL NUMBER (12)
Denotes cost of attendance for Pell grant
TARGET_GROUP VARCHAR2 (30)
Indicates cost of attendance group to which student belongs
ENCUMBERED_IND VARCHAR2 (1)
DECEASED_IND VARCHAR2 (1)
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)
PYMT_ISIR_EFC NUMBER

COMMENT_CODES VARCHAR2 (1)
FAFSA_RCPT_DT DATE

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
CAL_DESCRIPTION VARCHAR2 (30)
The description associated with the calender instance.
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.
MESSAGE_CLASS_TXT VARCHAR2 (30)
Message Class associated with the data file sent by CPS
ISIR_TYPE_DESC VARCHAR2 (80)
Indicates the ISIR type description
ISIR_TYPE VARCHAR2 (30)
Indicate the ISIR Type Daily, Requested, CPS Pushed
AWARDING_ISIR VARCHAR2 (13)
Indicates the Awarding ISIR ID, the combination of SSN, Name code and the transaction number.
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 COA Flag
Query Text

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


SELECT ROW_ID
,      BASE_ID
,      PERSON_ID
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      SSN
,      SURNAME
,      GIVEN_NAMES
,      FULL_NAME
,      CI_ALTERNATE_CODE
,      START_DT
,      END_DT
,      PERSON_NUMBER
,      ORG_ID
,      EFC_I
,      NEED_I
,      NEED_F
,      EFC_F
,      VERIFICATION_PROCESS_RUN
,      COA_PENDING
,      INST_VERIF_STATUS_DATE
,      MANUAL_VERIF_FLAG
,      NSLDS_ELIGIBLE
,      FED_VERIF_STATUS_DATE
,      FED_VERIF_STATUS
,      INST_VERIF_STATUS
,      ISIR_CORR_STATUS_DATE
,      EDE_CORRECTION_BATCH_ID
,      ISIR_CORR_STATUS
,      ISIR_STATUS_DATE
,      PROFILE_STATUS
,      PROFILE_STATUS_DATE
,      PROFILE_FC
,      FA_PROCESS_STATUS_DATE
,      ISIR_STATUS
,      DISBURSEMENT_HOLD
,      COA_CODE_F
,      COA_CODE_I
,      NOTIFICATION_STATUS
,      PACKAGING_STATUS
,      PACKAGING_STATUS_DATE
,      PACKAGING_HOLD
,      COA_F
,      FA_PROCESS_STATUS
,      TOTAL_PACKAGE_OFFERED
,      TOTAL_PACKAGE_ACCEPTED
,      NOTIFICATION_STATUS_DATE
,      COA_I
,      PAYMENT_ISIR_ID
,      ACTIVE_ISIR
,      DEPENDENCY_STATUS
,      PROF_JUDGEMENT_FLG
,      NSLDS_DATA_OVERRIDE_FLG
,      NSLDS_MATCH_FLAG
,      COA_FIXED
,      COA_PELL
,      TARGET_GROUP
,      ENCUMBERED_IND
,      DECEASED_IND
,      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
,      PYMT_ISIR_EFC
,      COMMENT_CODES
,      FAFSA_RCPT_DT
,      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
,      CAL_DESCRIPTION
,      ASSOC_ORG_NUM
,      AWARD_FMLY_CONTRIBUTION_TYPE
,      ISIR_LOCKED_BY
,      MESSAGE_CLASS_TXT
,      ISIR_TYPE_DESC
,      ISIR_TYPE
,      AWARDING_ISIR
,      ADNL_UNSUB_LOAN_ELIG_FLAG
,      LOCK_AWD_FLAG
,      LOCK_COA_FLAG
FROM APPS.IGF_AP_FA_CON_V;

Dependencies

[top of page]

APPS.IGF_AP_FA_CON_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymIGF_AP_FA_BASE_REC_ALL
SynonymIGF_AP_ISIR_MATCHED_ALL
ViewIGF_LOOKUPS_VIEW
SynonymIGS_CA_INST_ALL
PL/SQL PackageIGS_EN_GEN_003 - show dependent code
SynonymIGS_PE_ALT_PERS_ID
SynonymIGS_PE_HZ_PARTIES
SynonymIGS_PE_PERSON_ID_TYP
APPS.IGF_AP_FA_CON_V is referenced by following:

SchemaAPPS
Package BodyIGF_AP_ISIR_IMPORT_PKG - show dependent code
Package BodyIGF_AP_MATCHING_PROCESS_PKG - show dependent code
PL/SQL PackageIGF_AW_CANCEL_AWD - show dependent code
Package BodyIGF_AW_CANCEL_AWD - show dependent code
Package BodyIGF_AW_FISAP_PKG - show dependent code
ViewIGF_AW_FUND_DET_GRP_V
ViewIGF_AW_FUND_GRP_V
Package BodyIGF_AW_PACKAGING - show dependent code
Package BodyIGF_AW_RULE - show dependent code
Package BodyIGF_AW_SS_GEN_PKG - show dependent code
Package BodyIGF_DB_DISB - show dependent code
PL/SQL PackageIGF_DB_SF_INTEGRATION - show dependent code
Package BodyIGF_DB_SF_INTEGRATION - show dependent code
Package BodyIGF_SL_LAR_CREATION - show dependent code