[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_AP_FA_CON_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGF_AP_FA_CON_V
|
| Subobject Name: | |
| Status: | VALID |
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 |
|---|---|---|---|---|
| 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 |
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;
APPS
HZ_PARTIES
IGF_AP_FA_BASE_REC_ALL
IGF_AP_ISIR_MATCHED_ALL
IGF_LOOKUPS_VIEW
IGS_CA_INST_ALL
IGS_EN_GEN_003
- show dependent code
IGS_PE_ALT_PERS_ID
IGS_PE_HZ_PARTIES
IGS_PE_PERSON_ID_TYP
APPS
IGF_AP_ISIR_IMPORT_PKG
- show dependent code
IGF_AP_MATCHING_PROCESS_PKG
- show dependent code
IGF_AW_CANCEL_AWD
- show dependent code
IGF_AW_CANCEL_AWD
- show dependent code
IGF_AW_FISAP_PKG
- show dependent code
IGF_AW_FUND_DET_GRP_V
IGF_AW_FUND_GRP_V
IGF_AW_PACKAGING
- show dependent code
IGF_AW_RULE
- show dependent code
IGF_AW_SS_GEN_PKG
- show dependent code
IGF_DB_DISB
- show dependent code
IGF_DB_SF_INTEGRATION
- show dependent code
IGF_DB_SF_INTEGRATION
- show dependent code
IGF_SL_LAR_CREATION
- show dependent code
|
|
|
|