BANINST1@S10B80 |
|
Package sb_term This package provides the Common Business interface for the Term API (sb_term).One record for each term is required to support high level controls for several business functions and processes associated with registration, grading, fee assessment and degree audit (CAPP) for administrative and self-service users. A valid term code must exist (on the STVTERM table) before the base term record can be created. The Original Charge Cutoff Date must fall between the start and end date specified for the term code. The majority of these indicators are set to 'Y' to turn on and 'N' to turn off. An exception to the indicators is the registration error checking. A select group of the registration error checks allow either a fatal ('F') or no check ('N'). A different group allows a warning ('W') in addition to fatal and no check. An update to the base term record is restricted in a specific circumstance. The CRN Oneup number can never be updated to a lower value. This is because the CRN Oneup number is used to generate a unique CRN for new course sections as they are added for the term either online or through the process of rolling sections from an existing term to a new term. A base term record cannot be deleted if course sections have been created for the term. If no sections exist, all part-of-term records must be deleted before the term control itself can be deleted. When a new base term record is created a part-of-term '1' record (on the SOBPTRM table) must also be created. To facilitate this rule the create signature is not exposed for this business entity. A new base term record must be created. Any call to the create signature will return an error message. The API call is not supported for the current release. |
| Program units |
| f_api_version | Returns the API version number. |
| f_exists | Checks to see if a record exists. |
| f_isequal | Compares two records for equality. |
| f_query_all | Selects the records for the entity. |
| f_query_one | Selects one record using the key. |
| f_query_by_rowid | Selects one record using the ROWID. |
| f_query_one_lock | Selects one record and locks it. |
| f_eligible_to_register | Checks to see if the term is open for registration. |
| p_create | Creates a term record. |
| p_delete | Deletes a term record. |
| p_lock | Locks a term record. |
| p_update | Updates a record. |
| Types |
| term_rec | Entity record type |
| term_ref | Entity cursor variable type |
| term_tab | Entity table type |
| Constants |
| M_ENTITY_NAME | Business Entity name |
M_ENTITY_NAME
M_ENTITY_NAME CONSTANT VARCHAR2(4) := 'TERM';
Business Entity name
term_rec
TYPE term_rec IS RECORD ( r_term_code sobterm.sobterm_term_code%TYPE, r_crn_oneup sobterm.sobterm_crn_oneup%TYPE, r_reg_allowed sobterm.sobterm_reg_allowed%TYPE, r_readm_req sobterm.sobterm_readm_req%TYPE, r_fee_assessment sobterm.sobterm_fee_assessment%TYPE, r_fee_assessmnt_eff_date sobterm.sobterm_fee_assessmnt_eff_date%TYPE, r_dupl_severity sobterm.sobterm_dupl_severity%TYPE, r_link_severity sobterm.sobterm_link_severity%TYPE, r_preq_severity sobterm.sobterm_preq_severity%TYPE, r_corq_severity sobterm.sobterm_corq_severity%TYPE, r_time_severity sobterm.sobterm_time_severity%TYPE, r_capc_severity sobterm.sobterm_capc_severity%TYPE, r_levl_severity sobterm.sobterm_levl_severity%TYPE, r_coll_severity sobterm.sobterm_coll_severity%TYPE, r_majr_severity sobterm.sobterm_majr_severity%TYPE, r_clas_severity sobterm.sobterm_clas_severity%TYPE, r_appr_severity sobterm.sobterm_appr_severity%TYPE, r_minh_severity sobterm.sobterm_minh_severity%TYPE, r_maxh_severity sobterm.sobterm_maxh_severity%TYPE, r_hold_severity sobterm.sobterm_hold_severity%TYPE, r_hold sobterm.sobterm_hold%TYPE, r_refund_ind sobterm.sobterm_refund_ind%TYPE, r_bycrn_ind sobterm.sobterm_bycrn_ind%TYPE, r_rept_severity sobterm.sobterm_rept_severity%TYPE, r_rpth_severity sobterm.sobterm_rpth_severity%TYPE, r_test_severity sobterm.sobterm_test_severity%TYPE, r_camp_severity sobterm.sobterm_camp_severity%TYPE, r_fee_assess_vr sobterm.sobterm_fee_assess_vr%TYPE, r_print_bill_vr sobterm.sobterm_print_bill_vr%TYPE, r_tmst_calc_ind sobterm.sobterm_tmst_calc_ind%TYPE, r_incl_attmpt_hrs_ind sobterm.sobterm_incl_attmpt_hrs_ind%TYPE, r_cred_web_upd_ind sobterm.sobterm_cred_web_upd_ind%TYPE, r_gmod_web_upd_ind sobterm.sobterm_gmod_web_upd_ind%TYPE, r_levl_web_upd_ind sobterm.sobterm_levl_web_upd_ind%TYPE, r_closect_web_disp_ind sobterm.sobterm_closect_web_disp_ind%TYPE, r_mailer_web_ind sobterm.sobterm_mailer_web_ind%TYPE, r_schd_web_search_ind sobterm.sobterm_schd_web_search_ind%TYPE, r_camp_web_search_ind sobterm.sobterm_camp_web_search_ind%TYPE, r_sess_web_search_ind sobterm.sobterm_sess_web_search_ind%TYPE, r_instr_web_search_ind sobterm.sobterm_instr_web_search_ind%TYPE, r_facschd_web_disp_ind sobterm.sobterm_facschd_web_disp_ind%TYPE, r_claslst_web_disp_ind sobterm.sobterm_claslst_web_disp_ind%TYPE, r_overapp_web_upd_ind sobterm.sobterm_overapp_web_upd_ind%TYPE, r_add_drp_web_upd_ind sobterm.sobterm_add_drp_web_upd_ind%TYPE, r_degree_severity sobterm.sobterm_degree_severity%TYPE, r_program_severity sobterm.sobterm_program_severity%TYPE, r_dept_severity sobterm.sobterm_dept_severity%TYPE, r_atts_severity sobterm.sobterm_atts_severity%TYPE, r_chrt_severity sobterm.sobterm_chrt_severity%TYPE, r_mexc_severity sobterm.sobterm_mexc_severity%TYPE, r_inprogress_usage_ind sobterm.sobterm_inprogress_usage_ind%TYPE, r_grade_detail_web_ind sobterm.sobterm_grade_detail_web_ind%TYPE, r_midterm_web_ind sobterm.sobterm_midterm_web_ind%TYPE, r_profile_send_ind sobterm.sobterm_profile_send_ind%TYPE, r_cutoff_date sobterm.sobterm_cutoff_date%TYPE, r_tiv_date_source sobterm.sobterm_tiv_date_source%TYPE, r_web_capp_term_ind sobterm.sobterm_web_capp_term_ind%TYPE, r_web_capp_catlg_ind sobterm.sobterm_web_capp_catlg_ind%TYPE, r_attr_web_search_ind sobterm.sobterm_attr_web_search_ind%TYPE, r_levl_web_search_ind sobterm.sobterm_levl_web_search_ind%TYPE, r_insm_web_search_ind sobterm.sobterm_insm_web_search_ind%TYPE, r_ls_title_webs_disp_ind sobterm.sobterm_ls_title_webs_disp_ind%TYPE, r_ls_desc_webs_disp_ind sobterm.sobterm_ls_desc_webs_disp_ind%TYPE, r_duration_web_srch_ind sobterm.sobterm_duration_web_srch_ind%TYPE, r_levl_web_catl_srch_ind sobterm.sobterm_levl_web_catl_srch_ind%TYPE, r_styp_web_catl_srch_ind sobterm.sobterm_styp_web_catl_srch_ind%TYPE, r_coll_web_catl_srch_ind sobterm.sobterm_coll_web_catl_srch_ind%TYPE, r_div_web_catl_srch_ind sobterm.sobterm_div_web_catl_srch_ind%TYPE, r_dept_web_catl_srch_ind sobterm.sobterm_dept_web_catl_srch_ind%TYPE, r_prog_att_webc_srch_ind sobterm.sobterm_prog_att_webc_srch_ind%TYPE, r_lc_title_webc_disp_ind sobterm.sobterm_lc_title_webc_disp_ind%TYPE, r_lc_desc_webc_disp_ind sobterm.sobterm_lc_desc_webc_disp_ind%TYPE, r_dynamic_sched_term_ind sobterm.sobterm_dynamic_sched_term_ind%TYPE, r_assess_swap_ind sobterm.sobterm_assess_swap_ind%TYPE, r_assess_rev_nrf_ind sobterm.sobterm_assess_rev_nrf_ind%TYPE, r_assess_reg_grace_ind sobterm.sobterm_assess_reg_grace_ind%TYPE, r_study_path_ind sobterm.sobterm_study_path_ind%TYPE, r_future_repeat_ind sobterm.sobterm_future_repeat_ind%TYPE, r_sp_web_upd_ind sobterm.sobterm_sp_web_upd_ind%TYPE, r_sectionfee_ind sobterm.sobterm_sectionfee_ind%TYPE, r_meeting_time_src_cde sobterm.sobterm_meeting_time_src_cde%TYPE, r_plan_term_open_cde sobterm.sobterm_plan_term_open_cde%TYPE, r_sec_allowed_plan_cde sobterm.sobterm_sec_allowed_plan_cde%TYPE, r_max_plans sobterm.sobterm_max_plans%TYPE, r_deg_audit_plan_cde sobterm.sobterm_deg_audit_plan_cde%TYPE, r_plan_da_reg_cde sobterm.sobterm_plan_da_reg_cde%TYPE, r_plan_reg_cde sobterm.sobterm_plan_reg_cde%TYPE, r_cond_add_drop_cde sobterm.sobterm_cond_add_drop_cde%TYPE, r_auto_drop_cde sobterm.sobterm_auto_drop_cde%TYPE, r_admin_drop_cde sobterm.sobterm_admin_drop_cde%TYPE, r_drop_last_class_cde sobterm.sobterm_drop_last_class_cde%TYPE, r_data_origin sobterm.sobterm_data_origin%TYPE, r_user_id sobterm.sobterm_user_id%TYPE, r_internal_record_id gb_common.internal_record_id_type);
Entity record type
term_ref
TYPE term_ref IS REF CURSOR RETURN term_rec;
Entity cursor variable type
term_tab
TYPE term_tab IS TABLE OF term_rec INDEX BY BINARY_INTEGER;
Entity table type
f_api_version
Function f_api_version RETURN PLS_INTEGER
Returns the API version number.
| Returns |
|
Version of the API signature. Changes only when the signature changes. |
f_exists
Function f_exists(p_term_code sobterm.sobterm_term_code%TYPE,
p_rowid VARCHAR2 DEFAULT NULL) RETURN VARCHAR2
Checks to see if a record exists.
| Parameters |
| p_term_code |
Unique term code that identifies the base term record. VARCHAR2(6) Required Key | |
| p_rowid |
Database ROWID of the record to be selected. VARCHAR(18) |
| Returns |
|
Y if found, otherwise N. |
f_isequal
Function f_isequal(rec_one term_rec, rec_two term_rec) RETURN VARCHAR2
Compares two records for equality. Nulls match Nulls.
Tests each field of rec_one against the corresponding field of rec_two. Two null values are considered equal.
| Parameters |
| rec_one |
First record to compare. Type term_rec Required | |
| rec_two |
Second record to compare. Type term_rec Required |
| Returns |
|
Y if all values in the records are equal, otherwise N. Nulls match Nulls. |
f_query_all
Function f_query_all(p_term_code sobterm.sobterm_term_code%TYPE) RETURN term_ref
Selects the records for the entity.
| Parameters |
| p_term_code |
Unique term code that identifies the base term record. For student transactions valid in STVTERM, or ARTERM for non-student transactions. VARCHAR2(6) Required Key. Wildcard (%) may be used with term. |
| Returns |
|
A cursor variable that will fetch the set of records. |
f_query_one
Function f_query_one(p_term_code sobterm.sobterm_term_code%TYPE) RETURN term_ref
Selects one record using the key.
| Parameters |
| p_term_code |
Unique term code that identifies the base term record. VARCHAR2(6) Required Key |
| Returns |
|
A cursor variable that will fetch exactly one record. |
f_query_by_rowid
Function f_query_by_rowid(p_rowid VARCHAR2) RETURN term_ref
Selects one record using the ROWID.
| Parameters |
| p_rowid |
Database ROWID of the record to be selected. VARCHAR(18) Required |
| Returns |
|
A cursor variable that will fetch exactly one record. |
f_query_one_lock
Function f_query_one_lock(p_term_code sobterm.sobterm_term_code%TYPE,
p_rowid VARCHAR2 DEFAULT NULL)
RETURN term_ref
Selects one record and locks it.
| Parameters |
| p_term_code |
Unique term code that identifies the base term record. VARCHAR2(6) Required Key | |
| p_rowid |
Database ROWID of the record to be selected. VARCHAR(18) |
| Returns |
|
A cursor variable for one record, locking the record. |
f_eligible_to_register
Function f_eligible_to_register(p_term_code sobterm.sobterm_term_code%TYPE) RETURN VARCHAR2
Checks to see if the term is open for registration.
If the term is open for registration, a 'Y' is returned, otherwise an 'N' is returned.
| Returns |
|
Y/N value to indicate whether the term is open for registration. |
p_create
Procedure p_create(p_term_code sobterm.sobterm_term_code%TYPE,
p_crn_oneup sobterm.sobterm_crn_oneup%TYPE,
p_reg_allowed sobterm.sobterm_reg_allowed%TYPE,
p_readm_req sobterm.sobterm_readm_req%TYPE DEFAULT NULL,
p_fee_assessment sobterm.sobterm_fee_assessment%TYPE,
p_fee_assessmnt_eff_date sobterm.sobterm_fee_assessmnt_eff_date%TYPE DEFAULT NULL,
p_dupl_severity sobterm.sobterm_dupl_severity%TYPE DEFAULT 'N',
p_link_severity sobterm.sobterm_link_severity%TYPE DEFAULT 'N',
p_preq_severity sobterm.sobterm_preq_severity%TYPE DEFAULT 'N',
p_corq_severity sobterm.sobterm_corq_severity%TYPE DEFAULT 'N',
p_time_severity sobterm.sobterm_time_severity%TYPE DEFAULT 'N',
p_capc_severity sobterm.sobterm_capc_severity%TYPE DEFAULT 'N',
p_levl_severity sobterm.sobterm_levl_severity%TYPE DEFAULT 'N',
p_coll_severity sobterm.sobterm_coll_severity%TYPE DEFAULT 'N',
p_majr_severity sobterm.sobterm_majr_severity%TYPE DEFAULT 'N',
p_clas_severity sobterm.sobterm_clas_severity%TYPE DEFAULT 'N',
p_appr_severity sobterm.sobterm_appr_severity%TYPE DEFAULT 'N',
p_minh_severity sobterm.sobterm_minh_severity%TYPE DEFAULT 'N',
p_maxh_severity sobterm.sobterm_maxh_severity%TYPE DEFAULT 'N',
p_hold_severity sobterm.sobterm_hold_severity%TYPE DEFAULT 'N',
p_hold sobterm.sobterm_hold%TYPE DEFAULT NULL,
p_refund_ind sobterm.sobterm_refund_ind%TYPE DEFAULT NULL,
p_bycrn_ind sobterm.sobterm_bycrn_ind%TYPE DEFAULT NULL,
p_rept_severity sobterm.sobterm_rept_severity%TYPE DEFAULT 'N',
p_rpth_severity sobterm.sobterm_rpth_severity%TYPE DEFAULT 'N',
p_test_severity sobterm.sobterm_test_severity%TYPE DEFAULT 'N',
p_camp_severity sobterm.sobterm_camp_severity%TYPE DEFAULT 'N',
p_fee_assess_vr sobterm.sobterm_fee_assess_vr%TYPE DEFAULT NULL,
p_print_bill_vr sobterm.sobterm_print_bill_vr%TYPE DEFAULT NULL,
p_tmst_calc_ind sobterm.sobterm_tmst_calc_ind%TYPE,
p_incl_attmpt_hrs_ind sobterm.sobterm_incl_attmpt_hrs_ind%TYPE,
p_cred_web_upd_ind sobterm.sobterm_cred_web_upd_ind%TYPE,
p_gmod_web_upd_ind sobterm.sobterm_gmod_web_upd_ind%TYPE,
p_levl_web_upd_ind sobterm.sobterm_levl_web_upd_ind%TYPE,
p_closect_web_disp_ind sobterm.sobterm_closect_web_disp_ind%TYPE,
p_mailer_web_ind sobterm.sobterm_mailer_web_ind%TYPE,
p_schd_web_search_ind sobterm.sobterm_schd_web_search_ind%TYPE,
p_camp_web_search_ind sobterm.sobterm_camp_web_search_ind%TYPE,
p_sess_web_search_ind sobterm.sobterm_sess_web_search_ind%TYPE,
p_instr_web_search_ind sobterm.sobterm_instr_web_search_ind%TYPE,
p_facschd_web_disp_ind sobterm.sobterm_facschd_web_disp_ind%TYPE,
p_claslst_web_disp_ind sobterm.sobterm_claslst_web_disp_ind%TYPE,
p_overapp_web_upd_ind sobterm.sobterm_overapp_web_upd_ind%TYPE,
p_add_drp_web_upd_ind sobterm.sobterm_add_drp_web_upd_ind%TYPE,
p_degree_severity sobterm.sobterm_degree_severity%TYPE DEFAULT 'N',
p_program_severity sobterm.sobterm_program_severity%TYPE DEFAULT 'N',
p_dept_severity sobterm.sobterm_dept_severity%TYPE DEFAULT 'N',
p_atts_severity sobterm.sobterm_atts_severity%TYPE DEFAULT 'N',
p_chrt_severity sobterm.sobterm_chrt_severity%TYPE DEFAULT 'N',
p_mexc_severity sobterm.sobterm_mexc_severity%TYPE DEFAULT 'N',
p_inprogress_usage_ind sobterm.sobterm_inprogress_usage_ind%TYPE,
p_grade_detail_web_ind sobterm.sobterm_grade_detail_web_ind%TYPE,
p_midterm_web_ind sobterm.sobterm_midterm_web_ind%TYPE,
p_profile_send_ind sobterm.sobterm_profile_send_ind%TYPE,
p_cutoff_date sobterm.sobterm_cutoff_date%TYPE,
p_tiv_date_source sobterm.sobterm_tiv_date_source%TYPE,
p_web_capp_term_ind sobterm.sobterm_web_capp_term_ind%TYPE,
p_web_capp_catlg_ind sobterm.sobterm_web_capp_catlg_ind%TYPE,
p_attr_web_search_ind sobterm.sobterm_attr_web_search_ind%TYPE,
p_levl_web_search_ind sobterm.sobterm_levl_web_search_ind%TYPE,
p_insm_web_search_ind sobterm.sobterm_insm_web_search_ind%TYPE,
p_ls_title_webs_disp_ind sobterm.sobterm_ls_title_webs_disp_ind%TYPE,
p_ls_desc_webs_disp_ind sobterm.sobterm_ls_desc_webs_disp_ind%TYPE,
p_duration_web_srch_ind sobterm.sobterm_duration_web_srch_ind%TYPE,
p_levl_web_catl_srch_ind sobterm.sobterm_levl_web_catl_srch_ind%TYPE,
p_styp_web_catl_srch_ind sobterm.sobterm_styp_web_catl_srch_ind%TYPE,
p_coll_web_catl_srch_ind sobterm.sobterm_coll_web_catl_srch_ind%TYPE,
p_div_web_catl_srch_ind sobterm.sobterm_div_web_catl_srch_ind%TYPE,
p_dept_web_catl_srch_ind sobterm.sobterm_dept_web_catl_srch_ind%TYPE,
p_prog_att_webc_srch_ind sobterm.sobterm_prog_att_webc_srch_ind%TYPE,
p_lc_title_webc_disp_ind sobterm.sobterm_lc_title_webc_disp_ind%TYPE,
p_lc_desc_webc_disp_ind sobterm.sobterm_lc_desc_webc_disp_ind%TYPE,
p_dynamic_sched_term_ind sobterm.sobterm_dynamic_sched_term_ind%TYPE,
p_assess_swap_ind sobterm.sobterm_assess_swap_ind%TYPE DEFAULT 'N',
p_assess_rev_nrf_ind sobterm.sobterm_assess_rev_nrf_ind%TYPE DEFAULT 'N',
p_assess_reg_grace_ind sobterm.sobterm_assess_reg_grace_ind%TYPE DEFAULT 'N',
p_study_path_ind sobterm.sobterm_study_path_ind%TYPE DEFAULT 'N',
p_future_repeat_ind sobterm.sobterm_future_repeat_ind%TYPE DEFAULT 'N',
p_sp_web_upd_ind sobterm.sobterm_sp_web_upd_ind%TYPE DEFAULT 'N',
p_sectionfee_ind sobterm.sobterm_sectionfee_ind%TYPE DEFAULT 'N',
p_meeting_time_src_cde sobterm.sobterm_meeting_time_src_cde%TYPE DEFAULT NULL,
p_plan_term_open_cde sobterm.sobterm_plan_term_open_cde%TYPE DEFAULT NULL,
p_sec_allowed_plan_cde sobterm.sobterm_sec_allowed_plan_cde%TYPE DEFAULT NULL,
p_max_plans sobterm.sobterm_max_plans%TYPE DEFAULT NULL,
p_deg_audit_plan_cde sobterm.sobterm_deg_audit_plan_cde%TYPE DEFAULT NULL,
p_plan_da_reg_cde sobterm.sobterm_plan_da_reg_cde%TYPE DEFAULT NULL,
p_plan_reg_cde sobterm.sobterm_plan_reg_cde%TYPE DEFAULT NULL,
p_cond_add_drop_cde sobterm.sobterm_cond_add_drop_cde%TYPE DEFAULT NULL,
p_auto_drop_cde sobterm.sobterm_auto_drop_cde%TYPE DEFAULT NULL,
p_admin_drop_cde sobterm.sobterm_admin_drop_cde%TYPE DEFAULT NULL,
p_drop_last_class_cde sobterm.sobterm_drop_last_class_cde%TYPE DEFAULT NULL,
p_data_origin sobterm.sobterm_data_origin%TYPE DEFAULT NULL,
p_user_id sobterm.sobterm_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_rowid_out OUT VARCHAR2)
Creates a term record.
| Parameters |
| p_term_code |
Unique term code that identifies the base term record. VARCHAR2(6) Required Key | |
| p_crn_oneup |
Last Course Reference Number (CRN) generated by the system. NUMBER(5) Required | |
| p_reg_allowed |
Indicates whether online registration is allowed for the Key Block Term. Values are "Y"-allow online registration or "N"-no online registration. VARCHAR2(1) Required | |
| p_readm_req |
Re-Admit term. If a student has not registered since this term, they must be re-admitted through Admissions. VARCHAR2(6) | |
| p_fee_assessment |
Indicates whether fee assessment can be initiated online. "Y"-allow online fee assessment, "N"-only batch fee assessment. VARCHAR2(1) Required | |
| p_fee_assessmnt_eff_date |
Effective date associated with fees assessed online at registration. This date is associated with charges on the student Account Detail Record. DATE | |
| p_dupl_severity |
Indicates how duplicate course entries are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_link_severity |
Indicates how linked course sections are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_preq_severity |
Indicates whether course prerequisites are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_corq_severity |
Indicates whether course and section corequisites are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_time_severity |
Indicates whether course section time conflicts are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_capc_severity |
Indicates whether course section capacity is checked during online registration. Values are "F"-fatal error, "W"-warning, "N"-no check. VARCHAR2(1) Required | |
| p_levl_severity |
Indicates whether course level restrictions are checked during online registration. Values are "F"-fatal error, "W"-warning, "N"-no check. VARCHAR2(1) Required | |
| p_coll_severity |
Indicates whether course or section college restrictions are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_majr_severity |
Indicates whether course or section student major restrictions are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_clas_severity |
Indicates whether course or section class restrictions are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_appr_severity |
Indicates whether course section special approval indicators are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_minh_severity |
Indicates whether the student minimum hours are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_maxh_severity |
Indicates whether the student maximum hours are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_hold_severity |
Indicates whether the person holds are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_hold |
Registration Hold Password. VARCHAR2(3) | |
| p_refund_ind |
Refund By Total Indicator. VARCHAR2(1) | |
| p_bycrn_ind |
Assess by CRN Indicator. VARCHAR2(1) | |
| p_rept_severity |
Used to denote repeat severity. VARCHAR2(1) Required | |
| p_rpth_severity |
Used to denote repeat hours severity. VARCHAR2(1) Required | |
| p_test_severity |
Used to denote test score severity. VARCHAR2(1) | |
| p_camp_severity |
Campus Registration Restriction error severity code. VARCHAR2(1) Required | |
| p_fee_assess_vr |
Self-Service and Voice Response Fee Assessment Indicator. VARCHAR2(1) | |
| p_print_bill_vr |
Self-Service and Voice Response Print Bill Indicator. VARCHAR2(1) | |
| p_tmst_calc_ind |
Indicates whether time status calculations should occur automatically in designated forms on a term-by-term basis. VARCHAR2(1) Required | |
| p_incl_attmpt_hrs_ind |
Indicates whether the system should include credit hours from in-progress courses (those still in registration and not yet rolled to history) when calculating student classification for registration purposes. VARCHAR2(1) Required | |
| p_cred_web_upd_ind |
Indicates whether students can change class option credit hours on the Web. VARCHAR2(1) Required | |
| p_gmod_web_upd_ind |
Indicates whether students can change class option grading modes on the Web. VARCHAR2(1) Required | |
| p_levl_web_upd_ind |
Indicates whether students can change class option levels on the Web. VARCHAR2(1) Required | |
| p_closect_web_disp_ind |
Indicates whether a closed section should be displayed on the Web. VARCHAR2(1) Required | |
| p_mailer_web_ind |
Indicates whether to allow grades to be accessed on the Web for the term. VARCHAR2(1) Required | |
| p_schd_web_search_ind |
Indicates whether schedule types will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_camp_web_search_ind |
Indicates whether campuses will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_sess_web_search_ind |
Indicates whether sessions will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_instr_web_search_ind |
Indicates whether instructors will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_facschd_web_disp_ind |
Controls access to the Faculty Schedule Display page in the Faculty Web product. VARCHAR2(1) Required | |
| p_claslst_web_disp_ind |
Controls access to the Class List Display page in the Faculty Web product. VARCHAR2(1) Required | |
| p_overapp_web_upd_ind |
Controls access to the Registration Approval/Overrides page in the Faculty Web product. VARCHAR2(1) Required | |
| p_add_drp_web_upd_ind |
Controls access to the Registration Add/Drop page in the Faculty Web product. VARCHAR2(1) Required | |
| p_degree_severity |
Indicates the type of degree restriction checking (no checking, warning, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_program_severity |
Indicates the type of program restriction checking (no checking, warning, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_dept_severity |
Indicates the type of department restriction checking (no checking, warning, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_atts_severity |
Indicates the type of student attribute restriction checking (no checking, warning, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_chrt_severity |
Indicates the type of cohort restriction checking (no checking, warning, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_mexc_severity |
Indicates the type of mutual exclusion restriction checking (no checking, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_inprogress_usage_ind |
Indicates whether in-progress courses should fulfill prerequisite requirements for the term. VARCHAR2(1) Required | |
| p_grade_detail_web_ind |
Indicates whether to allow grade detail display via the Web for the term. VARCHAR2(2) Required | |
| p_midterm_web_ind |
Indicates whether to allow midterm grade display via the Web for the term. VARCHAR2(2) Required | |
| p_profile_send_ind |
Indicates whether information specific to the term should be passed to Campus Pipeline. VARCHAR2(2) Required | |
| p_cutoff_date |
Last date that calculated charges are considered original. DATE Required | |
| p_tiv_date_source |
Source of Title IV default start and end dates. T=Term; P=Part-of-Term. VARCHAR2(1) Required | |
| p_web_capp_term_ind |
Indicates whether the term code displayed in the key block is a valid term code to be used as the evaluation term for WebCAPP (degree evaluation on the Web) compliance processing. VARCHAR2(1) Required | |
| p_web_capp_catlg_ind |
Indicates whether the term code displayed in the key block is a valid term code to be used as a catalog term for WebCAPP (degree evaluation on the Web) processing. VARCHAR2(1) Required | |
| p_attr_web_search_ind |
Indicates whether the term code displayed in the key block will allow attributes as search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_levl_web_search_ind |
Indicates whether levels will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_insm_web_search_ind |
Indicates whether instructional methods will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_ls_title_webs_disp_ind |
Indicates whether the long section titles should be displayed on the Web. VARCHAR2(1) Required | |
| p_ls_desc_webs_disp_ind |
Indicates whether long section descriptions should be displayed on the Web. VARCHAR2(1) Required | |
| p_duration_web_srch_ind |
Indicates whether durations will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_levl_web_catl_srch_ind |
Indicates whether levels will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_styp_web_catl_srch_ind |
Indicates whether schedule types will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_coll_web_catl_srch_ind |
Indicates whether colleges will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_div_web_catl_srch_ind |
Indicates whether divisions will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_dept_web_catl_srch_ind |
Indicates whether departments will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_prog_att_webc_srch_ind |
Indicates whether program attributes will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_lc_title_webc_disp_ind |
Indicates whether the long course titles should be displayed in the Web catalog. VARCHAR2(1) Required | |
| p_lc_desc_webc_disp_ind |
Indicates whether the long course descriptions should be displayed in the Web catalog. VARCHAR2(1) Required | |
| p_dynamic_sched_term_ind |
Indicates whether the term should be displayed on the Web Select Term pulldown. VARCHAR2(1) Required | |
| p_assess_swap_ind |
Indicates whether to allow course/hours swapping in registration fee assessment. VARCHAR2(1) Required | |
| p_assess_rev_nrf_ind |
Indicates whether to allow the reversal of charges to detail codes having a category code other than TUI or FEE in registration fee assessment. VARCHAR2(1) Required | |
| p_assess_reg_grace_ind |
Indicates whether to allow grace when dropping a course with the same amount of bill hours as a course added on the same initial day of a student's registration. VARCHAR2(1) Required | |
| p_inprogress_usage_ind |
Indicates whether in-progress courses should fulfill prerequisite requirements for the term. VARCHAR2(1) Required | |
| p_study_path_ind |
Indicates whether study path is required for registration for the term. VARCHAR2(1) Required | |
| p_future_repeat_ind |
Indicates whether future registrations are to be considered by repeat course processing. VARCHAR2(1) Required | |
| p_sp_web_upd_ind |
Indicates whether students can change class option study paths on the Web. VARCHAR2(1) Required | |
| p_sectionfee_ind |
Indicates whether the study path from a registration is stored in SFRFAUD and TBRACCD when the charge is from a section fee. VARCHAR2(1) Required | |
| p_meeting_time_src_cde |
Code for Meeting Time Integration Source. VARCHAR2(1) -- Y or N or null | |
| p_plan_term_open_cde |
Code for Term open for Planning VARCHAR2(1) -- Y or null | |
| p_sec_allowed_plan_cde |
Code for Section is allowed to add to Plans.VARCHAR2(1) -- Y or N or null | |
| p_max_plans |
Maximum numbers of Plans that students can create. NUMBER(3) -- Values can be between 0 to 999 | |
| p_deg_audit_plan_cde |
Code for Degree Audit System Integration --VARCHAR2(1) -- Y or N or null | |
| p_plan_da_reg_cde. |
Banner XE code to allow Degree Audit plans to display in registration. Y or N or null. | |
| p_plan_reg_cde. |
Banner XE code to allow Registration Plans to display in registration. Y or N or null. | |
| p_cond_add_drop_cde |
Banner XE Registration code Y or N to allow conditional add drop selection. | |
| p_auto_drop_cde |
Banner XE Registration code C (Confirm automatic drop), Y(Yes automatically drop), N(No provide error message) to automatically drop connected classes . | |
| p_admin_drop_cde |
Banner XE Registration code Y or N to process administrative drops on connected classes when student initiates registration. | |
| p_drop_last_class_cde |
Banner XE Registration code Y or N to allow the student to drop all classes during self-service registration. | |
| p_data_origin |
Source system that generated the data. VARCHAR2(30) | |
| p_data_origin |
Source system that generated the data. VARCHAR2(30) | |
| p_user_id |
Oracle ID of the user who inserted or last updated the data. VARCHAR2(30) | |
| p_rowid_out |
Database ROWID of the record to be created. VARCHAR(18) Required |
p_delete
Procedure p_delete(p_term_code sobterm.sobterm_term_code%TYPE,
p_rowid VARCHAR2 DEFAULT NULL)
Deletes a term record.
| Parameters |
| p_term_code |
Unique term code that identifies the base term record. VARCHAR2(6) Required Key | |
| p_rowid |
Database ROWID of the record to be deleted. VARCHAR(18) |
p_lock
Procedure p_lock(p_term_code sobterm.sobterm_term_code%TYPE,
p_rowid_inout IN OUT VARCHAR2)
Locks a term record.
If the ROWID is not passed in, the record is located using the key values and the ROWID of the locked row is passed in p_rowid_inout.
| Parameters |
| p_term_code |
Unique term code that identifies the base term record. VARCHAR2(6) Required Key | |
| p_rowid_inout |
Database ROWID of the record to be locked. VARCHAR(18) Required |
p_update
Procedure p_update(p_term_code sobterm.sobterm_term_code%TYPE,
p_crn_oneup sobterm.sobterm_crn_oneup%TYPE DEFAULT dml_common.f_unspecified_number,
p_reg_allowed sobterm.sobterm_reg_allowed%TYPE DEFAULT dml_common.f_unspecified_string,
p_readm_req sobterm.sobterm_readm_req%TYPE DEFAULT dml_common.f_unspecified_string,
p_fee_assessment sobterm.sobterm_fee_assessment%TYPE DEFAULT dml_common.f_unspecified_string,
p_fee_assessmnt_eff_date sobterm.sobterm_fee_assessmnt_eff_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_dupl_severity sobterm.sobterm_dupl_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_link_severity sobterm.sobterm_link_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_preq_severity sobterm.sobterm_preq_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_corq_severity sobterm.sobterm_corq_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_time_severity sobterm.sobterm_time_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_capc_severity sobterm.sobterm_capc_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_levl_severity sobterm.sobterm_levl_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_coll_severity sobterm.sobterm_coll_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_majr_severity sobterm.sobterm_majr_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_clas_severity sobterm.sobterm_clas_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_appr_severity sobterm.sobterm_appr_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_minh_severity sobterm.sobterm_minh_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_maxh_severity sobterm.sobterm_maxh_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_hold_severity sobterm.sobterm_hold_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_hold sobterm.sobterm_hold%TYPE DEFAULT dml_common.f_unspecified_string,
p_refund_ind sobterm.sobterm_refund_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_bycrn_ind sobterm.sobterm_bycrn_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_rept_severity sobterm.sobterm_rept_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_rpth_severity sobterm.sobterm_rpth_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_test_severity sobterm.sobterm_test_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_camp_severity sobterm.sobterm_camp_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_fee_assess_vr sobterm.sobterm_fee_assess_vr%TYPE DEFAULT dml_common.f_unspecified_string,
p_print_bill_vr sobterm.sobterm_print_bill_vr%TYPE DEFAULT dml_common.f_unspecified_string,
p_tmst_calc_ind sobterm.sobterm_tmst_calc_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_incl_attmpt_hrs_ind sobterm.sobterm_incl_attmpt_hrs_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_cred_web_upd_ind sobterm.sobterm_cred_web_upd_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_gmod_web_upd_ind sobterm.sobterm_gmod_web_upd_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_levl_web_upd_ind sobterm.sobterm_levl_web_upd_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_closect_web_disp_ind sobterm.sobterm_closect_web_disp_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_mailer_web_ind sobterm.sobterm_mailer_web_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_schd_web_search_ind sobterm.sobterm_schd_web_search_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_camp_web_search_ind sobterm.sobterm_camp_web_search_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_sess_web_search_ind sobterm.sobterm_sess_web_search_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_instr_web_search_ind sobterm.sobterm_instr_web_search_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_facschd_web_disp_ind sobterm.sobterm_facschd_web_disp_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_claslst_web_disp_ind sobterm.sobterm_claslst_web_disp_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_overapp_web_upd_ind sobterm.sobterm_overapp_web_upd_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_add_drp_web_upd_ind sobterm.sobterm_add_drp_web_upd_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_degree_severity sobterm.sobterm_degree_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_program_severity sobterm.sobterm_program_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_dept_severity sobterm.sobterm_dept_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_atts_severity sobterm.sobterm_atts_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_chrt_severity sobterm.sobterm_chrt_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_mexc_severity sobterm.sobterm_mexc_severity%TYPE DEFAULT dml_common.f_unspecified_string,
p_inprogress_usage_ind sobterm.sobterm_inprogress_usage_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_grade_detail_web_ind sobterm.sobterm_grade_detail_web_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_midterm_web_ind sobterm.sobterm_midterm_web_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_profile_send_ind sobterm.sobterm_profile_send_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_cutoff_date sobterm.sobterm_cutoff_date%TYPE DEFAULT dml_common.f_unspecified_date,
p_tiv_date_source sobterm.sobterm_tiv_date_source%TYPE DEFAULT dml_common.f_unspecified_string,
p_web_capp_term_ind sobterm.sobterm_web_capp_term_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_web_capp_catlg_ind sobterm.sobterm_web_capp_catlg_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_attr_web_search_ind sobterm.sobterm_attr_web_search_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_levl_web_search_ind sobterm.sobterm_levl_web_search_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_insm_web_search_ind sobterm.sobterm_insm_web_search_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_ls_title_webs_disp_ind sobterm.sobterm_ls_title_webs_disp_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_ls_desc_webs_disp_ind sobterm.sobterm_ls_desc_webs_disp_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_duration_web_srch_ind sobterm.sobterm_duration_web_srch_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_levl_web_catl_srch_ind sobterm.sobterm_levl_web_catl_srch_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_styp_web_catl_srch_ind sobterm.sobterm_styp_web_catl_srch_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_coll_web_catl_srch_ind sobterm.sobterm_coll_web_catl_srch_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_div_web_catl_srch_ind sobterm.sobterm_div_web_catl_srch_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_dept_web_catl_srch_ind sobterm.sobterm_dept_web_catl_srch_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_prog_att_webc_srch_ind sobterm.sobterm_prog_att_webc_srch_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_lc_title_webc_disp_ind sobterm.sobterm_lc_title_webc_disp_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_lc_desc_webc_disp_ind sobterm.sobterm_lc_desc_webc_disp_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_dynamic_sched_term_ind sobterm.sobterm_dynamic_sched_term_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_assess_swap_ind sobterm.sobterm_assess_swap_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_assess_rev_nrf_ind sobterm.sobterm_assess_rev_nrf_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_assess_reg_grace_ind sobterm.sobterm_assess_reg_grace_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_study_path_ind sobterm.sobterm_study_path_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_future_repeat_ind sobterm.sobterm_future_repeat_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_sp_web_upd_ind sobterm.sobterm_sp_web_upd_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_sectionfee_ind sobterm.sobterm_sectionfee_ind%TYPE DEFAULT dml_common.f_unspecified_string,
p_meeting_time_src_cde sobterm.sobterm_meeting_time_src_cde%TYPE DEFAULT dml_common.f_unspecified_string,
p_plan_term_open_cde sobterm.sobterm_plan_term_open_cde%TYPE DEFAULT dml_common.f_unspecified_string,
p_sec_allowed_plan_cde sobterm.sobterm_sec_allowed_plan_cde%TYPE DEFAULT dml_common.f_unspecified_string,
p_max_plans sobterm.sobterm_max_plans%TYPE DEFAULT dml_common.f_unspecified_number,
p_deg_audit_plan_cde sobterm.sobterm_deg_audit_plan_cde%TYPE DEFAULT dml_common.f_unspecified_string,
p_plan_da_reg_cde sobterm.sobterm_plan_da_reg_cde%TYPE DEFAULT dml_common.f_unspecified_string,
p_plan_reg_cde sobterm.sobterm_plan_reg_cde%TYPE DEFAULT dml_common.f_unspecified_string,
p_cond_add_drop_cde sobterm.sobterm_cond_add_drop_cde%TYPE DEFAULT dml_common.f_unspecified_string,
p_auto_drop_cde sobterm.sobterm_auto_drop_cde%TYPE DEFAULT dml_common.f_unspecified_string,
p_admin_drop_cde sobterm.sobterm_admin_drop_cde%TYPE DEFAULT dml_common.f_unspecified_string,
p_drop_last_class_cde sobterm.sobterm_drop_last_class_cde%TYPE DEFAULT dml_common.f_unspecified_string,
p_data_origin sobterm.sobterm_data_origin%TYPE DEFAULT dml_common.f_unspecified_string,
p_user_id sobterm.sobterm_user_id%TYPE DEFAULT gb_common.f_sct_user,
p_rowid VARCHAR2 DEFAULT NULL)
Updates a record.
| Parameters |
| p_term_code |
Unique term code that identifies the base term record. VARCHAR2(6) Required Key | |
| p_crn_oneup |
Last Course Reference Number (CRN) generated by the system. NUMBER(5) Required | |
| p_reg_allowed |
Indicates whether online registration is allowed for the Key Block Term. Values are "Y"-allow registration or "N"-no online registration. VARCHAR2(1) Required | |
| p_readm_req |
Re-Admit term. If a student has not registered since this term, they must be re-admitted through Admissions. VARCHAR2(6) | |
| p_fee_assessment |
Indicates whether fee assessment can be initiated online. "Y"-allow online fee assessment, "N"-only batch fee assessment. VARCHAR2(1) Required | |
| p_fee_assessmnt_eff_date |
Effective date associated with fees assessed online at registration. This date is associated with charges on the student Account Detail Record. DATE | |
| p_dupl_severity |
Indicates how duplicate course entries are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_link_severity |
Indicates how linked course sections are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_preq_severity |
Indicates whether course prerequisites are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_corq_severity |
Indicates whether course and section corequisites are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_time_severity |
Indicates whether course section time conflicts are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_capc_severity |
Indicates whether course section capacity is checked during online registration. Values are "F"-fatal error, "W"-warning, "N"-no check. VARCHAR2(1) Required | |
| p_levl_severity |
Indicates whether course level restrictions are checked during online registration. Values are "F"-fatal error, "W"-warning, "N"-no check. VARCHAR2(1) Required | |
| p_coll_severity |
Indicates whether course or section college restrictions are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_majr_severity |
Indicates whether course or section student major restrictions are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_clas_severity |
Indicates whether course or section class restrictions are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_appr_severity |
Indicates whether course section special approval indicators are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_minh_severity |
Indicates whether the student minimum hours are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_maxh_severity |
Indicates whether the student maximum hours are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_hold_severity |
Indicates whether the person holds are checked during online registration. Values are "F"-fatal error, "N"-no check. VARCHAR2(1) Required | |
| p_hold |
Registration Hold Password. VARCHAR2(3) | |
| p_refund_ind |
Refund By Total Indicator. VARCHAR2(1) | |
| p_bycrn_ind |
Assess by CRN Indicator. VARCHAR2(1) | |
| p_rept_severity |
Used to denote repeat severity. VARCHAR2(1) Required | |
| p_rpth_severity |
Used to denote repeat hours severity. VARCHAR2(1) Required | |
| p_test_severity |
Used to denote test score severity. VARCHAR2(1) | |
| p_camp_severity |
Campus Registration Restriction error severity code. VARCHAR2(1) Required | |
| p_fee_assess_vr |
Self-Service and Voice Response Fee Assessment Indicator. VARCHAR2(1) | |
| p_print_bill_vr |
Self-Service and Voice Response Print Bill Indicator. VARCHAR2(1) | |
| p_tmst_calc_ind |
Indicates whether time status calculations should occur automatically in designated forms on a term-by-term basis. VARCHAR2(1) Required | |
| p_incl_attmpt_hrs_ind |
Indicates whether the system should include credit hours from in-progress courses (those still in registration and not yet rolled to history) when calculating student classification for registration purposes. VARCHAR2(1) Required | |
| p_cred_web_upd_ind |
Indicates whether students can change class option credit hours on the Web. VARCHAR2(1) Required | |
| p_gmod_web_upd_ind |
Indicates whether students can change class option grading modes on the Web. VARCHAR2(1) Required | |
| p_levl_web_upd_ind |
Indicates whether students can change class option levels on the Web. VARCHAR2(1) Required | |
| p_closect_web_disp_ind |
Indicates whether a closed section should be displayed on the Web. VARCHAR2(1) Required | |
| p_mailer_web_ind |
Indicates whether to allow grades to be accessed on the Web for the term. VARCHAR2(1) Required | |
| p_schd_web_search_ind |
Indicates whether schedule types will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_camp_web_search_ind |
Indicates whether campuses will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_sess_web_search_ind |
Indicates whether sessions will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_instr_web_search_ind |
Indicates whether instructors will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_facschd_web_disp_ind |
Controls access to the Faculty Schedule Display page in the Faculty Web product. VARCHAR2(1) Required | |
| p_claslst_web_disp_ind |
Controls access to the Class List Display page in the Faculty Web product. VARCHAR2(1) Required | |
| p_overapp_web_upd_ind |
Controls access to the Registration Approval/Overrides page in the Faculty Web product. VARCHAR2(1) Required | |
| p_add_drp_web_upd_ind |
Controls access to the Registration Add/Drop page in the Faculty Web product. VARCHAR2(1) Required | |
| p_degree_severity |
Indicates the type of degree restriction checking (no checking, warning, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_program_severity |
Indicates the type of program restriction checking (no checking, warning, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_dept_severity |
Indicates the type of department restriction checking (no checking, warning, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_atts_severity |
Indicates the type of student attribute restriction checking (no checking, warning, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_chrt_severity |
Indicates the type of cohort restriction checking (no checking, warning, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_mexc_severity |
Indicates the type of mutual exclusion restriction checking (no checking, fatal error) at registration time for the term. VARCHAR2(1) Required | |
| p_inprogress_usage_ind |
Indicates whether in-progress courses should fulfill prerequisite requirements for the term. VARCHAR2(1) Required | |
| p_grade_detail_web_ind |
Indicates whether to allow grade detail display via the Web for the term. VARCHAR2(2) Required | |
| p_midterm_web_ind |
Indicates whether to allow midterm grade display via the Web for the term. VARCHAR2(2) Required | |
| p_profile_send_ind |
Indicates whether information specific to the term should be passed to Campus Pipeline. VARCHAR2(2) Required | |
| p_cutoff_date |
Last date that calculated charges are considered original. DATE Required | |
| p_tiv_date_source |
Source of Title IV default start and end dates. T=Term; P=Part-of-Term. VARCHAR2(1) Required | |
| p_web_capp_term_ind |
Indicates whether the term code displayed in the key block is a valid term code to be used as the evaluation term for WebCAPP (degree evaluation on the Web) compliance processing. VARCHAR2(1) Required | |
| p_web_capp_catlg_ind |
Indicates whether the term code displayed in the key block is a valid term code to be used as a catalog term for WebCAPP (degree evaluation on the Web) processing. VARCHAR2(1) Required | |
| p_attr_web_search_ind |
Indicates whether the term code displayed in the key block will allow attributes as search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_levl_web_search_ind |
Indicates whether levels will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_insm_web_search_ind |
Indicates whether instructional methods will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_ls_title_webs_disp_ind |
Indicates whether long section titles should be displayed on the Web. VARCHAR2(1) Required | |
| p_ls_desc_webs_disp_ind |
Indicates whether long section descriptions should be displayed on the Web. VARCHAR2(1) Required | |
| p_duration_web_srch_ind |
Indicates whether durations will be included in the search criteria on the Web look-up page. VARCHAR2(1) Required | |
| p_levl_web_catl_srch_ind |
Indicates whether levels will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_styp_web_catl_srch_ind |
Indicates whether schedule types will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_coll_web_catl_srch_ind |
Indicates whether colleges will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_div_web_catl_srch_ind |
Indicates whether divisions will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_dept_web_catl_srch_ind |
Indicates whether departments will be included in the search criteria on the Web catalog look-up page. VARCHAR2(1) Required | |
| p_prog_att_webc_srch_ind |
Indicates whether program attributes will be included in the search criteria in the Web catalog look-up page. VARCHAR2(1) Required | |
| p_lc_title_webc_disp_ind |
Indicates whether long course titles should be displayed in the Web catalog. VARCHAR2(1) Required | |
| p_lc_desc_webc_disp_ind |
Indicates whether long course descriptions should be displayed in the Web catalog. VARCHAR2(1) Required | |
| p_dynamic_sched_term_ind |
Indicates whether the term should be displayed on the Web Select Term pulldown. VARCHAR2(1) Required | |
| p_assess_swap_ind |
Indicates whether to allow course/hours swapping in registration fee assessment. VARCHAR2(1) Required | |
| p_assess_rev_nrf_ind |
Indicates whether to allow the reversal of charges to detail codes having a category code other than TUI or FEE in registration fee assessment. VARCHAR2(1) Required | |
| p_assess_reg_grace_ind |
Indicates whether to allow grace when dropping a course with the same amount of bill hours as a course added on the same initial day of a student's registration. VARCHAR2(1) Required | |
| p_study_path_ind |
Indicates whether study path is required for registration for the term. VARCHAR2(1) Required | |
| p_future_repeat_ind |
Indicates whether future registrations are to be considered by repeat course processing. VARCHAR2(1) Required | |
| p_sp_web_upd_ind |
Indicates whether students can change class option study paths on the Web. VARCHAR2(1) Required | |
| p_sectionfee_ind |
Indicates whether the study path from a registration is stored in SFRFAUD and TBRACCD when the charge is from a section fee. VARCHAR2(1) Required | |
| p_meeting_time_src_cde |
Code for Meeting Time Integration Source. VARCHAR2(1) -- Y or N or null | |
| p_plan_term_open_cde |
Code for Term open for Planning VARCHAR2(1) -- Y or N or null | |
| p_sec_allowed_plan_cde |
Code for Section is allowed to add to Plans.VARCHAR2(1) -- Y or N or null | |
| p_max_plans |
Maximum numbers of Plans that students can create. NUMBER(3) -- Values can be between 0 to 999 | |
| p_deg_audit_plan_cde |
Code for Degree Audit System Integration --VARCHAR2(1) -- Y or N or null | |
| p_plan_da_reg_cde. |
Banner XE code to allow Degree Audit plans to display in registration. Y or N or null. | |
| p_plan_reg_cde. |
Banner XE code to allow Registration Plans to display in registration. Y or N or null. | |
| p_cond_add_drop_cde |
Banner XE Registration code Y or N to allow conditional add drop selection. | |
| p_auto_drop_cde |
Banner XE Registration code C (Confirm automatic drop), Y(Yes automatically drop), N(No provide error message) to automatically drop connected classes . | |
| p_admin_drop_cde |
Banner XE Registration code Y or N to process administrative drops on connected classes when student initiates registration. | |
| p_drop_last_class_cde |
Banner XE Registration code Y or N to allow the student to drop all classes during self-service registration. | |
| p_data_origin |
Source system that generated the data. VARCHAR2(30) | |
| p_user_id |
Oracle ID of the user who inserted or last updated the data. VARCHAR2(30) | |
| p_rowid |
Database ROWID of the record to be updated. VARCHAR(18) |