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

VIEW: APPS.IGF_AW_AWARD_V

Object Details
Object Name: IGF_AW_AWARD_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGF_AW_AWARD_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)
Database rowid for igf_aw_award table
AWARD_ID NUMBER (15) Yes Unique identifier for awards
CI_CAL_TYPE VARCHAR2 (10) Yes Indicates the code for the award year calender type, used within the operating unit
CI_SEQUENCE_NUMBER NUMBER (6) Yes Indicates a unique identifier for the award year calender instance
CI_ALTERNATE_CODE VARCHAR2 (10)
Indicates the alternate short reference code for identifying a award year calendar instance
CI_START_DT DATE
Yes Indicates the award year start date
CI_END_DT DATE
Yes Indicates the award year end date
FUND_CODE VARCHAR2 (30) Yes Unique code for each fund
FUND_TYPE VARCHAR2 (30) Yes A unique code which identifies the Type under which the fund falls.
FED_FUND_CODE VARCHAR2 (30) Yes Unique code for each federal fund
SYS_FUND_TYPE VARCHAR2 (30) Yes Unique code for each system fund type
FUND_ID NUMBER (15) Yes Unique identifier for each fund
DESCRIPTION VARCHAR2 (80)
Long name for fund identifier
BASE_ID NUMBER (10) Yes Identifier for student financial aid record
OFFERED_AMT NUMBER (12)
Total award amount offered
ACCEPTED_AMT NUMBER (12)
Total award amount accepted
PAID_AMT NUMBER (12)
Amount of award already paid
PACKAGING_TYPE VARCHAR2 (1)
The packaging method used to add this fund to the students award
MANUAL_UPDATE VARCHAR2 (30)
Flag that indicates if a manual change was done
RULES_OVERRIDE VARCHAR2 (30)
Flag that indicates if the manual edit had violated the funds rules and it was overridden
BATCH_ID VARCHAR2 (30)
Identifier of the batch process that calculated the award
AWARD_DATE DATE

Date on which the award record was created
AWARD_STATUS VARCHAR2 (30)
Status code of the current award
AWARD_STATUS_DESC VARCHAR2 (4000)
Long name for award status code
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield segmen
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (160)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE16 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE17 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE18 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE19 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE20 VARCHAR2 (150)
Descriptive flexfield segment
FUND_SOURCE VARCHAR2 (30) Yes Unique code for each fund source
STUDENT_ID NUMBER (15) Yes Person Identifier
PERSON_ID NUMBER (15) Yes Person Identifier
PERSON_NUMBER VARCHAR2 (30) Yes Person identifier
SSN VARCHAR2 (20)
Student's social security number
FULL_NAME VARCHAR2 (301)
Full name of the person
RVSN_ID NUMBER (15)
Revision Code
REVISION_DESC VARCHAR2 (80)
Revision Description
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
PROGRAM_APPLICATION_ID NUMBER (15)
Standard who column for concurrent programs
PROGRAM_ID NUMBER (15)
Standard who column for concurrent programs
PROGRAM_UPDATE_DATE DATE

Standard who column for concurrent programs
REQUEST_ID NUMBER (15)
Standard who column for concurrent programs
ALT_PELL_SCHEDULE VARCHAR2 (30)
Indicates if a Pell award is regular or Alternate Pell schedule award.
LEGACY_RECORD_FLAG VARCHAR2 (1)
Indicates this student award record is imported through legacy import process
AWARD_NUMBER_TXT VARCHAR2 (15)
Stores the Award Number populated through the Legacy Award Import process.
ADPLANS_ID NUMBER

Foreign Key to Award Distribution Plan Table
AWD_DIST_PLAN_CD VARCHAR2 (30)
Award Distribution Plan Code
AWD_DIST_PLAN_CD_DESC VARCHAR2 (80)
Award Distribution Plan Description
DIST_PLAN_METHOD_CODE VARCHAR2 (30)
Award Distribution Plan Method Code
LOCK_AWARD_FLAG VARCHAR2 (1)
To Lock Award From Pell Repackage.
APP_TRANS_NUM_TXT VARCHAR2 (30)
Aid Application ID Used to Award.
ALT_LOAN_CODE VARCHAR2 (30)
Alternative Loan Code for the corresponding Alternative Loan Fund
ALT_REL_CODE VARCHAR2 (30)
Lender Relationship Code for the corresponding Alternative Loan Code
AWD_PROC_STATUS_CODE VARCHAR2 (30)
Award processing Status Code
NOTIFICATION_STATUS_CODE VARCHAR2 (30)
Award Letter Notification Status Code
NOTIFICATION_STATUS_CODE_DESC VARCHAR2 (4000)
Award Letter Notification Status Code Description
NOTIFICATION_STATUS_DATE DATE

Award letter notification status date.
PUBLISH_IN_SS_FLAG VARCHAR2 (1)
Award Published Indicator
Query Text

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


SELECT ROW_ID
,      AWARD_ID
,      CI_CAL_TYPE
,      CI_SEQUENCE_NUMBER
,      CI_ALTERNATE_CODE
,      CI_START_DT
,      CI_END_DT
,      FUND_CODE
,      FUND_TYPE
,      FED_FUND_CODE
,      SYS_FUND_TYPE
,      FUND_ID
,      DESCRIPTION
,      BASE_ID
,      OFFERED_AMT
,      ACCEPTED_AMT
,      PAID_AMT
,      PACKAGING_TYPE
,      MANUAL_UPDATE
,      RULES_OVERRIDE
,      BATCH_ID
,      AWARD_DATE
,      AWARD_STATUS
,      AWARD_STATUS_DESC
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE16
,      ATTRIBUTE17
,      ATTRIBUTE18
,      ATTRIBUTE19
,      ATTRIBUTE20
,      FUND_SOURCE
,      STUDENT_ID
,      PERSON_ID
,      PERSON_NUMBER
,      SSN
,      FULL_NAME
,      RVSN_ID
,      REVISION_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ALT_PELL_SCHEDULE
,      LEGACY_RECORD_FLAG
,      AWARD_NUMBER_TXT
,      ADPLANS_ID
,      AWD_DIST_PLAN_CD
,      AWD_DIST_PLAN_CD_DESC
,      DIST_PLAN_METHOD_CODE
,      LOCK_AWARD_FLAG
,      APP_TRANS_NUM_TXT
,      ALT_LOAN_CODE
,      ALT_REL_CODE
,      AWD_PROC_STATUS_CODE
,      NOTIFICATION_STATUS_CODE
,      NOTIFICATION_STATUS_CODE_DESC
,      NOTIFICATION_STATUS_DATE
,      PUBLISH_IN_SS_FLAG
FROM APPS.IGF_AW_AWARD_V;

Dependencies

[top of page]

APPS.IGF_AW_AWARD_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
ViewIGF_AP_FA_BASE_REC
ViewIGF_AW_AWARD
SynonymIGF_AW_AWD_DIST_PLANS
ViewIGF_AW_AWD_RVSN_RSN
ViewIGF_AW_FUND_CAT
ViewIGF_AW_FUND_MAST
ViewIGF_AW_FUND_TYPE
PL/SQL PackageIGF_AW_GEN - show dependent code
ViewIGS_CA_INST
SynonymIGS_PE_ALT_PERS_ID
SynonymIGS_PE_PERSON_ID_TYP
APPS.IGF_AW_AWARD_V is referenced by following:

SchemaAPPS
Package BodyIGF_AW_CANCEL_AWD - show dependent code
ViewIGF_AW_FUND_DET_GRP_V
ViewIGF_AW_FUND_GRP_V
PL/SQL PackageIGF_AW_GEN_002 - show dependent code
Package BodyIGF_AW_GEN_002 - show dependent code
PL/SQL PackageIGF_AW_GEN_003 - show dependent code
Package BodyIGF_AW_GEN_003 - show dependent code
ViewIGF_DB_AWD_DISB_V
Package BodyIGF_DB_SF_INTEGRATION - show dependent code
ViewIGF_SE_EARNINGS_SUMMARY_V
Package BodyIGF_SE_GEN_001 - show dependent code
Package BodyIGF_SL_CL_LI_IMP_PKG - show dependent code
Package BodyIGF_SL_DL_PRINT_MANIFEST - show dependent code
Package BodyIGF_SL_DL_PRINT_PNOTE - show dependent code
Package BodyIGF_SL_LAR_CREATION - show dependent code
ViewIGF_SL_LOR_DTLS_V