You are browsing the archive for Oracle Student System.

National Student Clearinghouse snapshot creation

 

NAME: National Student Clearinghouse snapshot creation
SHORT CODE: IGSNSCCR
MODULE: Oracle Student System

Description: IGS NSC create snapshot
Navigation: Oracle Student System Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_school_id : School code
  • p_branch_id : Branch code
  • p_cal_inst_id : Load calendar instance
  • p_std_rep_flag : Standard report flag
  • p_prev_inst_id : Previous snapshot
  • p_dirpath : Output directory
  • p_file_name : Output file name

 

Import POPDLHE to OSS – Load

 

NAME: Import POPDLHE to OSS – Load
SHORT CODE: IGSHEX26
MODULE: Oracle Student System

Description: Load POPDLHE flat file into temporary staging table
Navigation: Oracle Student System Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_DATA_FILE : Data file with full path

 

Verify HESA Return Report

 

NAME: Verify HESA Return Report
SHORT CODE: IGSHES03
MODULE: Oracle Student System

Description: Verify HESA Return Report
Navigation: Oracle Student System Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_SUBMISSION_NAME : Submission Name
  • P_USER_RETURN_CLASS : User Defined Return Class
  • P_RETURN_NAME : Return Name
  • P_CHECK_HESA_DETAILS : Check HESA Details
  • P_CHECK_FIELD_ASSOCIATIONS : Check Field Associations