Search Results the blue lagoon nude




The IGS_PS_AWD_HNR_BASE table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical component of the Student Administration module, specifically within the Oracle Campus Solutions (formerly known as Oracle Student Systems) functionality. This table serves as a foundational repository for storing and managing data related to academic honors and awards conferred to students. It is part of the Institutional Global Systems (IGS) schema, which is tailored for higher education institutions to streamline academic processes, including student records, curriculum management, and awards.

Purpose and Functional Overview

The primary purpose of the IGS_PS_AWD_HNR_BASE table is to maintain a structured record of honors and awards granted to students based on their academic achievements, extracurricular activities, or other institutional criteria. This table acts as a central reference point for tracking award details, including the award type, eligibility criteria, and associated metadata. It integrates with other IGS tables, such as IGS_PS_STDNT_HNR_AWD (which links awards to specific students) and IGS_PS_HNR_AWD_CRT (which stores certificate details), to provide a comprehensive awards management system.

Key Columns and Data Structure

The table typically includes columns such as:
  • AWARD_HONORS_ID: A unique identifier for each award or honor.
  • AWARD_CODE: A code representing the specific award or honor.
  • DESCRIPTION: A textual description of the award.
  • AWARD_TYPE: Categorizes the award (e.g., academic, athletic, community service).
  • ELIGIBILITY_CRITERIA: Defines the conditions a student must meet to qualify.
  • ACTIVE_FLAG: Indicates whether the award is currently active.
  • CREATED_BY and CREATION_DATE: Audit columns tracking record creation.
  • LAST_UPDATED_BY and LAST_UPDATE_DATE: Audit columns for modifications.

Integration with Oracle EBS Modules

The IGS_PS_AWD_HNR_BASE table interacts with several Oracle EBS modules, including:
  • Student Records: Links awards to student academic profiles.
  • Financial Aid: May associate awards with scholarships or grants.
  • Curriculum Management: Tracks honors tied to specific programs or courses.

Technical Considerations

In Oracle EBS 12.1.1 and 12.2.2, this table is subject to standard Oracle database constraints, including primary and foreign key relationships. For example, AWARD_CODE might reference a code table, and AWARD_HONORS_ID could be a foreign key in related student award tables. Performance optimization techniques, such as indexing on frequently queried columns (e.g., AWARD_CODE), are recommended for large datasets.

Customization and Extensions

Institutions often extend the table's functionality by adding custom columns (e.g., INSTITUTION_SPECIFIC_FLAG) or integrating it with third-party systems via APIs. Oracle's flexible architecture allows for such modifications while maintaining data integrity.

Conclusion

The IGS_PS_AWD_HNR_BASE table is a pivotal element in Oracle Campus Solutions, enabling institutions to systematically manage student honors and awards. Its design supports scalability, integration, and compliance with academic policies, making it indispensable for higher education administrators leveraging Oracle EBS 12.1.1 or 12.2.2.

  • Lookup Type: IGP_WZ_FONT_COLOR 12.1.1

    product: IGS - Student System ,  meaning: Font Colors ,  description: Font Colors , 

  • Lookup Type: IGS_UC_DATA_ERRORS 12.1.1

    product: IGS - Student System ,  meaning: UCAS Process Data Errors ,  description: UCAS Process Data Errors , 

  • Lookup Type: IGS_UC_EXP_APP_ERROR 12.1.1

    product: IGS - Student System ,  meaning: IGS_UC_EXP_APP_ERROR ,  description: Lookup For Application Error While Export , 

  • Lookup Type: PRG_MEASURE_TYPE 12.1.1

    product: IGS - Student System ,  meaning: Progression Measure Types ,  description: Progression Measure Types , 

  • Lookup Type: IGS_FI_RECORD_IDENTIFIER 12.1.1

    product: IGS - Student System ,  meaning: Lockbox Record Identifier ,  description: Lockbox Interface Record Identifier , 

  • Lookup Type: IGS_AD_DERIVE_FINAL_US 12.1.1

    product: IGS - Student System ,  meaning: Derive Final Unit Set ,  description: Derive Final Unit Set , 

  • Lookup Type: IGS_AS_SESS_ATT_CODE 12.1.1

    product: IGS - Student System ,  meaning: Session Attendance identifier ,  description: This lookup type is used to identify if the student has attended the session or not , 

  • Table: IGS_PS_AWD_HNR_BASE 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_AWD_HNR_BASE,  object_name:IGS_PS_AWD_HNR_BASE,  status:VALID,  product: IGS - Student System ,  description: Defines the basis on what the honors level of the student is to be derived. The definition will include the unit level and the weightage that is to be given to a particular unit level mark to arrive at the honors level of a student in a giv ,  implementation_dba_data: IGS.IGS_PS_AWD_HNR_BASE , 

  • Table: IGS_CO_S_LTR_PR_ARG 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_CO_S_LTR_PR_ARG,  object_name:IGS_CO_S_LTR_PR_ARG,  status:VALID,  product: IGS - Student System ,  description: Holds relationship between bind variables used in the code_block field of the system letter parameter type table and the variables that are available in the function calling the dynamic SQL created from the code_block ,  implementation_dba_data: IGS.IGS_CO_S_LTR_PR_ARG , 

  • Table: IGS_HE_USR_RT_CL_FLD 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_HE_USR_RT_CL_FLD,  object_name:IGS_HE_USR_RT_CL_FLD,  status:VALID,  product: IGS - Student System ,  description: Holds the fields that the user wants to include in the User Defined Return Class. The fields are normally a sub set of the fields defined for the System Return Class ,  implementation_dba_data: IGS.IGS_HE_USR_RT_CL_FLD , 

  • Table: IGS_FI_BILL_TRNSCTNS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_BILL_TRNSCTNS,  object_name:IGS_FI_BILL_TRNSCTNS,  status:VALID,  product: IGS - Student System ,  description: IGS_FI_TRNSCTNS is the relation where the transactions recorded against a Bill are stored. This relation has a mapping to the Bill Header table as it stores the detail information against the header records. The transaction recorded in this ,  implementation_dba_data: IGS.IGS_FI_BILL_TRNSCTNS , 

  • Lookup Type: IGS_FI_LOCKBOX 12.1.1

    product: IGS - Student System ,  meaning: Concurrent Log Parameter Column Titles ,  description: Concurrent Log Parameter Column Titles , 

  • Lookup Type: IGS_HE_IMP_ERR 12.1.1

    product: IGS - Student System ,  meaning: HESA import student details error codes ,  description: HESA import student details error codes , 

  • Table: IGS_AS_SUAAI_OUHIST 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AS_SUAAI_OUHIST,  object_name:IGS_AS_SUAAI_OUHIST,  status:VALID,  product: IGS - Student System ,  description: The history of the for the student assessment item outcomes is recorded in this table. The base table for the history table is IGS_AS_SU_ATMPT_ITM. The history is tracked for grading schema, mark, grade, outcome date and outcome comment c ,  implementation_dba_data: IGS.IGS_AS_SUAAI_OUHIST , 

  • Table: IGS_LOOKUPS_IND 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_LOOKUPS_IND,  object_name:IGS_LOOKUPS_IND,  status:VALID,  product: IGS - Student System ,  description: This table has a foreign key relationship with FND_LOOKUPS_TYPE. The join is based on the column LOOKUP_TYPE. The existing system tables from the original data model were merged into the FND_LOOKUPS table. ,  implementation_dba_data: IGS.IGS_LOOKUPS_IND , 

  • Table: IGS_EN_UNIT_SET_STAT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_UNIT_SET_STAT,  object_name:IGS_EN_UNIT_SET_STAT,  status:VALID,  product: IGS - Student System ,  description: This entity describes the user-defined unit set statuses. e.g. Current, Suspended. These map back onto the system unit set statuses, to provide the system with the ability to have a large number of statuses which map back to the system fun ,  implementation_dba_data: IGS.IGS_EN_UNIT_SET_STAT , 

  • Lookup Type: PE_US_GVT_AGENCY 12.1.1

    product: IGS - Student System ,  meaning: U.S. Government Agency Codes ,  description: US Government Agency Codes , 

  • Table: IGS_OR_INST_STAT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_OR_INST_STAT,  object_name:IGS_OR_INST_STAT,  status:VALID,  product: IGS - Student System ,  description: This entity describes the user-defined institution statuses. These map back onto the system institution statuses, to provide the system with the ability to have a large number of statuses which tie back to the system functionality. ,  implementation_dba_data: IGS.IGS_OR_INST_STAT , 

  • Lookup Type: IGS_CO_PREVIEW_STATUS 12.1.1

    product: IGS - Student System ,  meaning: Various Preview Statuses for Correspondence batch. ,  description: Various Preview Statuses for Correspondence batch. , 

  • Table: IGS_EN_LGCY_ERR_INT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_LGCY_ERR_INT,  object_name:IGS_EN_LGCY_ERR_INT,  status:VALID,  product: IGS - Student System ,  description: Contains the errors generated by the Legacy Import Process for Enrollment and Records. A row will be created by the process for any warning or error, along with the primary key ID (INT_TABLE_ID) of the related interface table as signified ,  implementation_dba_data: IGS.IGS_EN_LGCY_ERR_INT , 

  • Concurrent Program: IGSAZJ02 12.1.1

    execution_filename: IGS_AZ_GEN_001.SEND_NOTIFICATION ,  product: IGS - Student System ,  user_name: IGSAZJ02 ,  description: Executable for Generate Advising Notification Job ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Table: IGS_AS_ORD_ITM_INT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_AS_ORD_ITM_INT,  object_name:IGS_AS_ORD_ITM_INT,  status:VALID,  product: IGS - Student System ,  description: This interface table contains one entry for each document requested as a line item on the associated order. The data is extracted from the OSS production tables and used by the consulting solution for document production. The options includ ,  implementation_dba_data: IGS.IGS_AS_ORD_ITM_INT , 

  • Table: IGS_PS_STAT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_STAT,  object_name:IGS_PS_STAT,  status:VALID,  product: IGS - Student System ,  description: This entity describes the user-defined program statuses. These map back onto the system program statuses, to provide the system with the ability to have a large number of statuses which tie back to the system functionality. ,  implementation_dba_data: IGS.IGS_PS_STAT , 

  • Table: IGS_FI_SPNSR_STAT 12.1.1

    product: IGS - Student System ,  description: OBSOLETE (This entity describes the user-defined sponsor statuses. These map back onto the system sponsor statuses, to provide the system with the ability to have a large number of statuses which tie back to the system functionality) - Obso ,  implementation_dba_data: Not implemented in this database , 

  • Table: IGS_PS_UNIT_STAT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_PS_UNIT_STAT,  object_name:IGS_PS_UNIT_STAT,  status:VALID,  product: IGS - Student System ,  description: This entity describes the user-defined unit statuses. E.g. Current, Suspended. These map back onto the system unit statuses, to provide the system with the ability to have a large number of statuses, which tie back to the system functionali ,  implementation_dba_data: IGS.IGS_PS_UNIT_STAT , 

  • Table: IGS_FI_OTC_CHARGES 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_FI_OTC_CHARGES,  object_name:IGS_FI_OTC_CHARGES,  status:VALID,  product: IGS - Student System ,  description: Contains information on the charges (of type external) that are created at the time of receipt creation. Provides a repository of all charges that are tied to the receipt, if any, that were created when the student pays over the counter. ,  implementation_dba_data: IGS.IGS_FI_OTC_CHARGES , 

  • Table: IGS_DA_OUT_UNT_CAT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_OUT_UNT_CAT,  object_name:IGS_DA_OUT_UNT_CAT,  status:VALID,  product: IGS - Student System ,  description: Storage for the outgoing unit categories on the units found for the Student in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_OUT_UNT_CAT , 

  • Lookup Type: IGP_AD_ACCOUNT_TYPES 12.1.1

    product: IGS - Student System ,  meaning: Shows the Types of the Accounts. I.e. Internal and External ,  description: Shows the Types of the Accounts. I.e. Internal and External , 

  • Lookup Type: IGP_US_PORTFOLIO_TYPES 12.1.1

    product: IGS - Student System ,  meaning: Shows the different possible types of the portfolio ,  description: Shows the different possible types of the portfolio , 

  • Table: IGS_DA_OUT_AUDT_DTL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_OUT_AUDT_DTL,  object_name:IGS_DA_OUT_AUDT_DTL,  status:VALID,  product: IGS - Student System ,  description: Storage for the Degree Audit details for the units found for the Student in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_OUT_AUDT_DTL , 

  • View: IGSFV_CAL_PRD_EVNT_TYPE_OFSTS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSFV_CAL_PRD_EVNT_TYPE_OFSTS,  object_name:IGSFV_CAL_PRD_EVNT_TYPE_OFSTS,  status:VALID,  product: IGS - Student System ,  description: This is the full view for the entity Calendar Period Event Type Offsets that describes the offset relationship between two date aliases. Offset values are used to derive the date alias value from the related date alias value. ,  implementation_dba_data: APPS.IGSFV_CAL_PRD_EVNT_TYPE_OFSTS , 

  • Table: IGS_GE_JOB_TEXT_ALL 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_GE_JOB_TEXT_ALL,  object_name:IGS_GE_JOB_TEXT_ALL,  status:VALID,  product: IGS - Student System ,  description: IGS_GE_JOB_TEXT_ALL describes the job text used within reports on the system. Users may enter 'standard' text which is selected at the point of running reports through the job scheduler processing. ,  implementation_dba_data: IGS.IGS_GE_JOB_TEXT_ALL , 

  • Table: IGS_DA_OUT_PRG_CGRY 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_OUT_PRG_CGRY,  object_name:IGS_DA_OUT_PRG_CGRY,  status:VALID,  product: IGS - Student System ,  description: Storage for the outgoing program categories on the programs found for the students selected in the request. ,  implementation_dba_data: IGS.IGS_DA_OUT_PRG_CGRY , 

  • Table: IGS_DA_IN_USET 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_IN_USET,  object_name:IGS_DA_IN_USET,  status:VALID,  product: IGS - Student System ,  description: Storage for incoming Unit Set information for the programs coming back from the 3rd party for the Students in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_IN_USET , 

  • Lookup Type: PRG_RULE_REPEAT_FAIL_TYPE 12.1.1

    product: IGS - Student System ,  meaning: Progression Rule Repeat Fail Type ,  description: Progression Rule Repeat Fail Type , 

  • Table: IGS_DA_IN_RSLT_UNTS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_IN_RSLT_UNTS,  object_name:IGS_DA_IN_RSLT_UNTS,  status:VALID,  product: IGS - Student System ,  description: Storage for the Resulting Unit information from the 3rd party about Units for the Students in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_IN_RSLT_UNTS , 

  • Table: IGS_EN_LGY_SPAA_INT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_LGY_SPAA_INT,  object_name:IGS_EN_LGY_SPAA_INT,  status:VALID,  product: IGS - Student System ,  description: Contains the Student Award Aim information to be imported into the IGS_EN_SPA_AWD_AIM table by the legacy data import process. Rows in this table must correspond to a batch in the IGS_EN_LGCY_BAT_INT table. ,  implementation_dba_data: IGS.IGS_EN_LGY_SPAA_INT , 

  • Table: IGS_EN_LGY_SPAT_INT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_LGY_SPAT_INT,  object_name:IGS_EN_LGY_SPAT_INT,  status:VALID,  product: IGS - Student System ,  description: Contains the Student Program Attempt Term records to be imported into the IGS_EN_SPA_TERMS table by the legacy data import process. Rows in this table must correspond to a batch in the IGS_EN_LGCY_BAT_INT table. ,  implementation_dba_data: IGS.IGS_EN_LGY_SPAT_INT , 

  • Table: IGS_UC_COND_DETAILS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_UC_COND_DETAILS,  object_name:IGS_UC_COND_DETAILS,  status:VALID,  product: IGS - Student System ,  description: This is the detail table in the offer library.It holds the condition that makes up the offer. ,  implementation_dba_data: IGS.IGS_UC_COND_DETAILS , 

  • Table: IGS_DA_OUT_TST_SGMT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_OUT_TST_SGMT,  object_name:IGS_DA_OUT_TST_SGMT,  status:VALID,  product: IGS - Student System ,  description: Storage for outgoing information on the test segments for the tests found for the Student in the Degree Audit Request ,  implementation_dba_data: IGS.IGS_DA_OUT_TST_SGMT , 

  • Table: IGS_DA_IN_PRG 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_IN_PRG,  object_name:IGS_DA_IN_PRG,  status:VALID,  product: IGS - Student System ,  description: Storage for the incoming information from the 3rd party about programs related to the Students in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_IN_PRG , 

  • Table: IGS_EN_LGCY_SPI_INT 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_EN_LGCY_SPI_INT,  object_name:IGS_EN_LGCY_SPI_INT,  status:VALID,  product: IGS - Student System ,  description: Contains the Intermission details to be imported into the IGS_EN_STDNT_PS_INTM table by the legacy data import process. Rows in this table must correspond to a batch in the IGS_EN_LGCY_BAT_INT table. ,  implementation_dba_data: IGS.IGS_EN_LGCY_SPI_INT , 

  • Table: IGS_UC_ATTEND_HIST 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_UC_ATTEND_HIST,  object_name:IGS_UC_ATTEND_HIST,  status:VALID,  product: IGS - Student System ,  description: The attendance history table will hold the details of the last institution attended by the applicant. Case and Seed Document: UC_2893542_UCFD210_Acad history Streamlining_CS_DP1.doc - Obsolete ,  implementation_dba_data: IGS.IGS_UC_ATTEND_HIST , 

  • Table: IGS_HE_SUBMSN_HEADER 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_HE_SUBMSN_HEADER,  object_name:IGS_HE_SUBMSN_HEADER,  status:VALID,  product: IGS - Student System ,  description: Holds the information about the Submission headers i.e. parameters that need to be applied across all the returns included in the Submission. ,  implementation_dba_data: IGS.IGS_HE_SUBMSN_HEADER , 

  • Table: IGS_DA_OUT_STDT_DEG 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_OUT_STDT_DEG,  object_name:IGS_DA_OUT_STDT_DEG,  status:VALID,  product: IGS - Student System ,  description: Storage for the outgoing information on the degree information for the Student in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_OUT_STDT_DEG , 

  • Table: IGS_DA_IN_SRC_UNTS 12.1.1

    owner:IGS,  object_type:TABLE,  fnd_design_data:IGS.IGS_DA_IN_SRC_UNTS,  object_name:IGS_DA_IN_SRC_UNTS,  status:VALID,  product: IGS - Student System ,  description: Storage for all the Source Units given by the 3rd party for the Students in the Degree Audit Request. ,  implementation_dba_data: IGS.IGS_DA_IN_SRC_UNTS , 

  • View: IGSBV_CAL_PRD_EVNT_TYPE_OFSTS 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGSBV_CAL_PRD_EVNT_TYPE_OFSTS,  object_name:IGSBV_CAL_PRD_EVNT_TYPE_OFSTS,  status:VALID,  product: IGS - Student System ,  description: This is the base view for the entity Calendar Period Event Type Offsets that describes the offset relationship between two date aliases. Offset values are used to derive the date alias value from the related date alias value. ,  implementation_dba_data: APPS.IGSBV_CAL_PRD_EVNT_TYPE_OFSTS , 

  • View: IGS_PS_UNIT_OFR_OPT_ASS_PAT_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:IGS.IGS_PS_UNIT_OFR_OPT_ASS_PAT_V,  object_name:IGS_PS_UNIT_OFR_OPT_ASS_PAT_V,  status:VALID,  product: IGS - Student System ,  description: This entity describes the assessment patterns, which make up the assessment requirement for a unit. The assessment pattern of the unit should map with the unit offering option and unit class. ,  implementation_dba_data: APPS.IGS_PS_UNIT_OFR_OPT_ASS_PAT_V , 

  • Table: IGS_TR_TYPE 12.1.1

    product: IGS - Student System ,  description: This entity describes the user-defined tracking types which exist within the system. They are mapped back to the system defined tracking types which are recognised by the system functionality. ,  implementation_dba_data: Not implemented in this database , 

  • Lookup Type: IGS_FI_SUPPLIER_NAME 12.1.1

    product: IGS - Student System ,  meaning: Supplier Type ,  description: Used for showing Supplier Name formats in Profile. ,