SMBAOGN SMRAOGD SMRAOLV SMRAOSA SMRDOEX SMRDOLV SMRDORQ SMRDOUS SMRDREX SMRDRLV SMRDRRQ SMRGOAT SMRGOGD SMRGOLV SMRGOSA SMRGRRQ SMRPOAT SMRPOGD SMRPOLV SMRPONC SMRPOSA SMRSACA SMRSACE SMRSACL SMRSAGM SMRSAGR SMRSALV SMRSARE SMRSARG SMRSARL SMRSARS SMRSARU SMRSGCA SMRSGCE SMRSGCL SMRSGLV SMRSGRE SMRSGRG SMRSGRL SMRSGRS SMRSGRU SMRSPAP SMRSPAT SMRSPLV SMRSPNC SMRSPRG SMRSPRS SMRSSUB SMRSWAV STVACTN

Model STVACTN


Model Label : Banner STVACTN ERD
Path : Default Folder/B70/Common/STVACTN

List of Objects

Object Name Object Type Layer Name
SMBAOGN TABLE ERD
SMRAOGD TABLE ERD
SMRAOLV TABLE ERD
SMRAOSA TABLE ERD
SMRDOEX TABLE ERD
SMRDOLV TABLE ERD
SMRDORQ TABLE ERD
SMRDOUS TABLE ERD
SMRDREX TABLE ERD
SMRDRLV TABLE ERD
SMRDRRQ TABLE ERD
SMRGOAT TABLE ERD
SMRGOGD TABLE ERD
SMRGOLV TABLE ERD
SMRGOSA TABLE ERD
SMRGRRQ TABLE ERD
SMRPOAT TABLE ERD
SMRPOGD TABLE ERD
SMRPOLV TABLE ERD
SMRPONC TABLE ERD
SMRPOSA TABLE ERD
SMRSACA TABLE ERD
SMRSACE TABLE ERD
SMRSACL TABLE ERD
SMRSAGM TABLE ERD
SMRSAGR TABLE ERD
SMRSALV TABLE ERD
SMRSARE TABLE ERD
SMRSARG TABLE ERD
SMRSARL TABLE ERD
SMRSARS TABLE ERD
SMRSARU TABLE ERD
SMRSGCA TABLE ERD
SMRSGCE TABLE ERD
SMRSGCL TABLE ERD
SMRSGLV TABLE ERD
SMRSGRE TABLE ERD
SMRSGRG TABLE ERD
SMRSGRL TABLE ERD
SMRSGRS TABLE ERD
SMRSGRU TABLE ERD
SMRSPAP TABLE ERD
SMRSPAT TABLE ERD
SMRSPLV TABLE ERD
SMRSPNC TABLE ERD
SMRSPRG TABLE ERD
SMRSPRS TABLE ERD
SMRSSUB TABLE ERD
SMRSWAV TABLE ERD
STVACTN TABLE Tables

Comments

Model View

''

Table SMBAOGN

Schema Name SATURN
Label SMBAOGN
Server name S4B70
Creation Date 09/29/2003 12:09:47:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SMBAOGN_PIDM SMBAOGN_PIDM NUMBER(8,0) No * *
SMBAOGN_REQUEST_NO SMBAOGN_REQUEST_NO NUMBER(4,0) No * *
SMBAOGN_AREA SMBAOGN_AREA VARCHAR2(10) No * *
SMBAOGN_PROGRAM SMBAOGN_PROGRAM VARCHAR2(12) No *
SMBAOGN_MET_IND SMBAOGN_MET_IND VARCHAR2(1) No
SMBAOGN_SOURCE_IND SMBAOGN_SOURCE_IND VARCHAR2(1) No
SMBAOGN_TERM_CODE_EFF SMBAOGN_TERM_CODE_EFF VARCHAR2(6) No
SMBAOGN_TERM_CODE_EFF_GROUP SMBAOGN_TERM_CODE_EFF_GROUP VARCHAR2(6) Yes
SMBAOGN_ACTIVE_IND SMBAOGN_ACTIVE_IND VARCHAR2(1) No
SMBAOGN_LEVL_CODE SMBAOGN_LEVL_CODE VARCHAR2(2) No
SMBAOGN_ADDL_LEVEL_IND SMBAOGN_ADDL_LEVEL_IND VARCHAR2(1) No
SMBAOGN_EXCL_LEVEL_IND SMBAOGN_EXCL_LEVEL_IND VARCHAR2(1) No
SMBAOGN_RSTR_S_A_IND SMBAOGN_RSTR_S_A_IND VARCHAR2(1) No
SMBAOGN_RSTR_GRD_IND SMBAOGN_RSTR_GRD_IND VARCHAR2(1) No
SMBAOGN_CRSE_REUSE_IND SMBAOGN_CRSE_REUSE_IND VARCHAR2(1) No
SMBAOGN_ATTR_REUSE_IND SMBAOGN_ATTR_REUSE_IND VARCHAR2(1) No
SMBAOGN_WITHIN_IND SMBAOGN_WITHIN_IND VARCHAR2(1) No
SMBAOGN_GEN_REQ_MET_IND SMBAOGN_GEN_REQ_MET_IND VARCHAR2(1) No
SMBAOGN_DETL_REQ_MET_IND SMBAOGN_DETL_REQ_MET_IND VARCHAR2(1) No
SMBAOGN_DYNAMIC_IND SMBAOGN_DYNAMIC_IND VARCHAR2(1) No
SMBAOGN_ACTIVITY_DATE SMBAOGN_ACTIVITY_DATE DATE No
SMBAOGN_GC_IND SMBAOGN_GC_IND VARCHAR2(1) Yes
SMBAOGN_AREA_PRIORITY SMBAOGN_AREA_PRIORITY NUMBER(3,0) Yes
SMBAOGN_YEAR_RULE SMBAOGN_YEAR_RULE NUMBER(2,0) Yes
SMBAOGN_MIN_AREA_GPA SMBAOGN_MIN_AREA_GPA NUMBER(23,9) Yes
SMBAOGN_ACT_AREA_GPA SMBAOGN_ACT_AREA_GPA NUMBER(23,9) Yes
SMBAOGN_GRDE_CODE_MIN SMBAOGN_GRDE_CODE_MIN VARCHAR2(6) Yes
SMBAOGN_COMPL_CREDITS SMBAOGN_COMPL_CREDITS NUMBER(11,3) Yes
SMBAOGN_COMPL_COURSES SMBAOGN_COMPL_COURSES NUMBER(3,0) Yes
SMBAOGN_REQ_CREDITS_OVERALL SMBAOGN_REQ_CREDITS_OVERALL NUMBER(11,3) Yes
SMBAOGN_CONNECTOR_OVERALL SMBAOGN_CONNECTOR_OVERALL VARCHAR2(1) No
SMBAOGN_REQ_COURSES_OVERALL SMBAOGN_REQ_COURSES_OVERALL NUMBER(3,0) Yes
SMBAOGN_ACT_CREDITS_OVERALL SMBAOGN_ACT_CREDITS_OVERALL NUMBER(11,3) Yes
SMBAOGN_ACT_COURSES_OVERALL SMBAOGN_ACT_COURSES_OVERALL NUMBER(3,0) Yes
SMBAOGN_REQ_CREDITS_INST SMBAOGN_REQ_CREDITS_INST NUMBER(11,3) Yes
SMBAOGN_CONNECTOR_INST SMBAOGN_CONNECTOR_INST VARCHAR2(1) No
SMBAOGN_REQ_COURSES_INST SMBAOGN_REQ_COURSES_INST NUMBER(3,0) Yes
SMBAOGN_ACT_CREDITS_INST SMBAOGN_ACT_CREDITS_INST NUMBER(11,3) Yes
SMBAOGN_ACT_COURSES_INST SMBAOGN_ACT_COURSES_INST NUMBER(3,0) Yes
SMBAOGN_REQ_CREDITS_I_TRAD SMBAOGN_REQ_CREDITS_I_TRAD NUMBER(11,3) Yes
SMBAOGN_CONNECTOR_I_TRAD SMBAOGN_CONNECTOR_I_TRAD VARCHAR2(1) No
SMBAOGN_REQ_COURSES_I_TRAD SMBAOGN_REQ_COURSES_I_TRAD NUMBER(3,0) Yes
SMBAOGN_ACT_CREDITS_I_TRAD SMBAOGN_ACT_CREDITS_I_TRAD NUMBER(11,3) Yes
SMBAOGN_ACT_COURSES_I_TRAD SMBAOGN_ACT_COURSES_I_TRAD NUMBER(3,0) Yes
SMBAOGN_MAX_CREDITS_I_NONTRAD SMBAOGN_MAX_CREDITS_I_NONTRAD NUMBER(11,3) Yes
SMBAOGN_CONNECTOR_I_NONTRAD SMBAOGN_CONNECTOR_I_NONTRAD VARCHAR2(1) No
SMBAOGN_MAX_COURSES_I_NONTRAD SMBAOGN_MAX_COURSES_I_NONTRAD NUMBER(3,0) Yes
SMBAOGN_ACT_CREDITS_I_NONTRAD SMBAOGN_ACT_CREDITS_I_NONTRAD NUMBER(11,3) Yes
SMBAOGN_ACT_COURSES_I_NONTRAD SMBAOGN_ACT_COURSES_I_NONTRAD NUMBER(3,0) Yes
SMBAOGN_MAX_CREDITS_TRANSFER SMBAOGN_MAX_CREDITS_TRANSFER NUMBER(11,3) Yes
SMBAOGN_CONNECTOR_TRANSFER SMBAOGN_CONNECTOR_TRANSFER VARCHAR2(1) No
SMBAOGN_MAX_COURSES_TRANSFER SMBAOGN_MAX_COURSES_TRANSFER NUMBER(3,0) Yes
SMBAOGN_ACT_CREDITS_TRANSFER SMBAOGN_ACT_CREDITS_TRANSFER NUMBER(11,3) Yes
SMBAOGN_ACT_COURSES_TRANSFER SMBAOGN_ACT_COURSES_TRANSFER NUMBER(3,0) Yes
SMBAOGN_ACTN_CODE SMBAOGN_ACTN_CODE VARCHAR2(3) Yes *
SMBAOGN_ATTACH_SOURCE_IND SMBAOGN_ATTACH_SOURCE_IND VARCHAR2(1) Yes
SMBAOGN_ADJ_CREDITS SMBAOGN_ADJ_CREDITS NUMBER(11,3) Yes
SMBAOGN_ADJ_COURSES SMBAOGN_ADJ_COURSES NUMBER(3,0) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
SMBAOGN_ACTN_CODE STVACTN_CODE STVACTN
SMBAOGN_PIDM SMRRQCM_PIDM SMRRQCM
SMBAOGN_REQUEST_NO SMRRQCM_REQUEST_NO SMRRQCM
SMBAOGN_PIDM SMBPOGN_PIDM SMBPOGN
SMBAOGN_REQUEST_NO SMBPOGN_REQUEST_NO SMBPOGN
SMBAOGN_PROGRAM SMBPOGN_PROGRAM SMBPOGN
SMBAOGN_AREA SMRALIB_AREA SMRALIB

Index

Index Name Index Type Column Name
PK_SMBAOGN Unique SMBAOGN_PIDM
PK_SMBAOGN Unique SMBAOGN_REQUEST_NO
PK_SMBAOGN Unique SMBAOGN_AREA

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
ins_smbaogn C/C++ Function [F:\BANNER\C\SMRJOBS.PC] Use(insert )
ins_smbaogn C/C++ Function [F:\BANNER\C\SMRCMPL.H] Use(insert )
ins_smbaogn_waived C/C++ Function [F:\BANNER\C\SMRJOBS.PC] Use(insert )
ins_smbaogn_waived C/C++ Function [F:\BANNER\C\SMRCMPL.H] Use(insert )
process C/C++ Function [F:\BANNER\C\SSRSCRM.PC] Use(delete )
process C/C++ Function [F:\BANNER\C\SHREDIP.PC] Use(delete )
process C/C++ Function [F:\BANNER\C\SMRJOBS.PC] Use(delete )
process C/C++ Function [F:\BANNER\C\SSRSCMT.PC] Use(delete )
process C/C++ Function [F:\BANNER\C\SMRCMPL.H] Use(delete )
del_spec_tables C/C++ Function [F:\BANNER\C\SMRJOBS.PC] Use(delete )
SMBAOGN SYNONYM S4B70.PUBLIC Rely on ()
SMBGOGN TABLE S4B70.SATURN Join
SPRIDEN TABLE S4B70.SATURN Join
POST-CHANGE Forms Trigger BANNER7_FORMS_10G.SFQPREQ.KEY_BLOCK.ID Use(select )
POST-CHANGE Forms Trigger BANNER7_FORMS.SFQPREQ.KEY_BLOCK.ID Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.SMIAOUT.KEY_BLOCK.AREA Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.SMIAOUT.KEY_BLOCK.AREA Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.SMIAOUT.KEY_BLOCK.ID Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS_10G.SMIAOUT.KEY_BLOCK.REQUEST_NO Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.SMIAOUT.KEY_BLOCK.REQUEST_NO Use(select )
WHEN-VALIDATE-ITEM Forms Trigger BANNER7_FORMS.SMIAOUT.KEY_BLOCK.ID Use(select )
DELETE_COMPLIANCE_RESULTS Forms Trigger BANNER7_FORMS.SFAREGS Use(delete )
DELETE_COMPLIANCE_RESULTS Forms Trigger BANNER7_FORMS_10G.SFAREGS Use(delete )
VALIDATE_KEY_DATA Forms Trigger BANNER7_FORMS.SMIAOUT Use(select )
VALIDATE_KEY_DATA Forms Trigger BANNER7_FORMS_10G.SMIAOUT Use(select )
AREA1_RG Forms Record Group BANNER7_FORMS.SMIAOUT Use(select )
AREA1_RG Forms Record Group BANNER7_FORMS_10G.SMIAOUT Use(select )
AREA_RG Forms Record Group BANNER7_FORMS.SMIGOUT Use(select )
AREA_RG Forms Record Group BANNER7_FORMS_10G.SMIGOUT Use(select )
AREA_RG Forms Record Group BANNER7_FORMS.SMIAOUT Use(select )
AREA_RG Forms Record Group BANNER7_FORMS_10G.SMIAOUT Use(select )
SMBAOGN_AREA_RG Forms Record Group BANNER7_FORMS.SOQOLIB Use(select )
SMBAOGN_AREA_RG Forms Record Group BANNER7_FORMS.SMIAOUT Use(select )
SMBAOGN_AREA_RG Forms Record Group BANNER7_FORMS.SMICRLT Use(select )
SMBAOGN_AREA_RG Forms Record Group BANNER7_FORMS_10G.SOQOLIB Use(select )
SMBAOGN_AREA_RG Forms Record Group BANNER7_FORMS_10G.SMICRLT Use(select )
SMBAOGN_AREA_RG Forms Record Group BANNER7_FORMS_10G.SMIAOUT Use(select )
SMBAOGN_ID_RG Forms Record Group BANNER7_FORMS.SMIAOUT Use(select )
SMBAOGN_ID_RG Forms Record Group BANNER7_FORMS_10G.SMIAOUT Use(select )
SMBAOGN_REQ2_RG Forms Record Group BANNER7_FORMS.SMIAOUT Use(select )
SMBAOGN_REQ2_RG Forms Record Group BANNER7_FORMS_10G.SMIAOUT Use(select )
FILL_IN_KEYDATA Forms Trigger BANNER7_FORMS.SMIAOUT.KEY_BLOCK Use(select )
FILL_IN_KEYDATA Forms Trigger BANNER7_FORMS_10G.SMIAOUT.KEY_BLOCK Use(select )
WHEN-NEW-BLOCK-INSTANCE Forms Trigger BANNER7_FORMS.SMIPOUT.SMBAOGN Use(select )
DELETE_SMBAOGN Forms Procedure BANNER7_FORMS.SMARQCM Use(delete )
DELETE_SMBAOGN Forms Procedure BANNER7_FORMS_10G.SMACACT Use(delete )
DELETE_SMBAOGN Forms Procedure BANNER7_FORMS_10G.SMARQCM Use(delete )
DELETE_SMBAOGN Forms Procedure BANNER7_FORMS.SMACACT Use(delete )
CHECK_SMBAOGN Forms Function BANNER7_FORMS.SMIPOUT Use(select )
CHECK_SMBAOGN Forms Function BANNER7_FORMS_10G.SMIPOUT Use(select )
SELECT_SMBAOGN Forms Function BANNER7_FORMS.SMICRLT Use(select )
SELECT_SMBAOGN Forms Function BANNER7_FORMS.SFQPREQ Use(select )
SELECT_SMBAOGN Forms Function BANNER7_FORMS_10G.SMICRLT Use(select )
SELECT_SMBAOGN Forms Function BANNER7_FORMS_10G.SFQPREQ Use(select )
P_DELETEPRIORSMRRQCM Package procedure S4B70.BANINST1.SFKPREQ Use(delete )
P_DELETEPRIORSMRRQCM Package procedure S4B70.BANINST1.SFKFUNC Use(delete )
P_GET_AREA_DETAILS Package procedure S4B70.BANINST1.BWCKCPRL Rely on ()
P_GET_AREA_DETAILS Package procedure S4B70.BANINST1.BWCKCPRL Use(select )
SMBAOGN_C Package cursor S4B70.BANINST1.BWCKSMLT Rely on ()
SMBAOGN_C Package cursor S4B70.BANINST1.BWCKSMLT Use(select )
SMBGOGN_C Package cursor S4B70.BANINST1.BWCKSMLT Rely on ()
SMRACCM_TEXT_C Package cursor S4B70.BANINST1.BWCKSMLT Rely on ()
SMRACMT_TEXT_C Package cursor S4B70.BANINST1.BWCKSMLT Rely on ()
SMRDORQ_C Package cursor S4B70.BANINST1.BWCKSMLT Rely on ()
SMRDORQ_GROUP_C Package cursor S4B70.BANINST1.BWCKSMLT Rely on ()
SMRSACT_TEXT_C Package cursor S4B70.BANINST1.BWCKSMLT Rely on ()
GPA_USED Package variable S4B70.BANINST1.BWCKCPRL Rely on ()
F_CHKCRNAREA Package function S4B70.BANINST1.SFKPREQ Use(select )
F_CHKCRNAREA Package function S4B70.BANINST1.SFKFUNC Use(select )
P_DELETE_COMPLIANCE_RESULTS Package procedure S4B70.BANINST1.SFKMODS Use(delete )
P_DISPEVALDETAILREQ Package procedure S4B70.BANINST1.BWCKSMLT Rely on ()
P_FORMAT_AREA_DETAIL_TEXT Package procedure S4B70.BANINST1.BWCKSMLT Rely on ()
P_FORMAT_MET_BAR Package procedure S4B70.BANINST1.BWCKSMLT Rely on ()
P_FORMAT_PROGRAM_HDR_TEXT Package procedure S4B70.BANINST1.BWCKSMLT Rely on ()
P_GENREQOUTPUT Package procedure S4B70.BANINST1.BWCKSMLT Rely on ()
P_GENREQOUTPUT Package procedure S4B70.BANINST1.BWCKSMLT Rely on ()
P_GETAREAS Package procedure S4B70.BANINST1.BWCKCPRL Use(select )
P_GET_SMBAOGN Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMBAOGN Package procedure S4B70.BANINST1.SMKXAPI Use(select )
P_GET_SMBAOGN Package procedure S4B70.BANINST1.SMKXAPI Use(select )
P_GET_SMBAOGN Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMBGOGN Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMRACMT Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMRAOGD Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMRAOGD Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMRAOLV Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMRAOSA Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMRAOSA Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMRARGC Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMRARSC Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMRCRLT Package procedure S4B70.BANINST1.SMRCRLT Rely on ()
P_GET_SMRCRLT Package procedure S4B70.BANINST1.SMRCRLT Rely on ()
P_GET_SMRDORQ_CAA_SEQNO Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMRDORQ_CRSE Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMRDOUS_GROUP Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMRGOAT Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMRGOGD Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMRGOGD Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMRGOLV Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMRGOSA Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMRGOSA Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMRSACM Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_PURGEREQUEST Package procedure S4B70.BANINST1.BWCKSPRG Use(delete )
CHK_ADJ_SMBARUL_ADDTNL_TEXT Package function S4B70.BANINST1.BWCKSMLT Rely on ()
CHK_SMBARUL_ADDTNL_TEXT Package function S4B70.BANINST1.BWCKSMLT Rely on ()
CHK_SMRDOUS_AREA_RULE_CRSE_CNT Package function S4B70.BANINST1.BWCKSMLT Rely on ()
F_GENOUTPUTAREATEXT Package function S4B70.BANINST1.BWCKSMLT Rely on ()
F_GEN_REQ_LABEL_DISP Package function S4B70.BANINST1.BWCKSMLT Rely on ()
SMBAOGN Forms DataBlock BANNER7_FORMS.SMIAOUT Rely on () Use(insert,update,delete,select )
SMBAOGN Forms DataBlock BANNER7_FORMS_10G.SMICRLT Rely on () Use(insert,update,delete,select )
SMBAOGN Forms DataBlock BANNER7_FORMS.SMIPOUT Rely on () Use(insert,update,delete,select )
SMBAOGN Forms DataBlock BANNER7_FORMS.SFQPREQ Rely on () Use(insert,update,delete,select )
SMBAOGN Forms DataBlock BANNER7_FORMS_10G.SMIAOUT Rely on () Use(insert,update,delete,select )
SMBAOGN Forms DataBlock BANNER7_FORMS.SMICRLT Rely on () Use(insert,update,delete,select )
SMBAOGN Forms DataBlock BANNER7_FORMS_10G.SFQPREQ Rely on () Use(insert,update,delete,select )

Called objects (non escalated)

Object Name Object Type Parent Name Link Type
PK_SMBAOGN INDEX S4B70.SATURN Rely on ()
SMBPOGN TABLE S4B70.SATURN Join
SMRALIB TABLE S4B70.SATURN Join
SMRRQCM TABLE S4B70.SATURN Refer( No Action )
STVACTN TABLE S4B70.SATURN Refer( No Action )

Comments

Source Code Comments

General Area Overall Results Table

Columns Comments for SMBAOGN_PIDM (1)

Source Code Comments

Unique student identifier which may be present if this area has been designated as unique to a particular student

Columns Comments for SMBAOGN_REQUEST_NO (2)

Source Code Comments

Sequence number of the compliance request for the student. It is system generated

Columns Comments for SMBAOGN_AREA (3)

Source Code Comments

An area is an entity used to define general requirements and/or detail requirements for a subset of courses.

Columns Comments for SMBAOGN_PROGRAM (4)

Source Code Comments

A program which already exists on the Program Rules Form.

Columns Comments for SMBAOGN_MET_IND (5)

Source Code Comments

Met indicator. Y= overall area has been met or satisfied. N= overall area is not met or satisfied.

Columns Comments for SMBAOGN_SOURCE_IND (6)

Source Code Comments

Source indicator. O= original area requirements. A= student adjustment area requirements.

Columns Comments for SMBAOGN_TERM_CODE_EFF (7)

Source Code Comments

Effective term of the area general requirements.

Columns Comments for SMBAOGN_TERM_CODE_EFF_GROUP (8)

Source Code Comments

Effective term of the group general requirements.

Columns Comments for SMBAOGN_ACTIVE_IND (9)

Source Code Comments

Active indicator. Y = active,N = inactive.

Columns Comments for SMBAOGN_LEVL_CODE (10)

Source Code Comments

Level code

Columns Comments for SMBAOGN_ADDL_LEVEL_IND (11)

Source Code Comments

Additional Level indicator

Columns Comments for SMBAOGN_EXCL_LEVEL_IND (12)

Source Code Comments

Exclusion Level indicator

Columns Comments for SMBAOGN_RSTR_S_A_IND (13)

Source Code Comments

Restricted Subject/Atribute indicator

Columns Comments for SMBAOGN_RSTR_GRD_IND (14)

Source Code Comments

Restricted Grade indicator

Columns Comments for SMBAOGN_CRSE_REUSE_IND (15)

Source Code Comments

This field contains the default course reuse rule which will be used by compliance unless overriden when the program attaches the area.

Columns Comments for SMBAOGN_ATTR_REUSE_IND (16)

Source Code Comments

This field contains the default attribute reuse rule which will be used by compliance unless overriden when the program attaches the area.

Columns Comments for SMBAOGN_WITHIN_IND (17)

Source Code Comments

The same course can be used to satisfy more than one distinct detail requirements within a group if value is yes, valid values Y/N.

Columns Comments for SMBAOGN_GEN_REQ_MET_IND (18)

Source Code Comments

Area General Requirement Met Indicator. Y= the area general requirements have been met or satisfied. N= they were not met or satisfied.

Columns Comments for SMBAOGN_DETL_REQ_MET_IND (19)

Source Code Comments

Detail Requirement Met Indicator. Y= the detail component of area requirements has been met or satisfied. N= it is not met or satisfied.

Columns Comments for SMBAOGN_DYNAMIC_IND (20)

Source Code Comments

Indicates whether the area was selected dynamically.

Columns Comments for SMBAOGN_ACTIVITY_DATE (21)

Source Code Comments

Date of most recent activity.

Columns Comments for SMBAOGN_GC_IND (22)

Source Code Comments

Group/Course indicator. Areas may attach either courses or groups as detail. Not both. G = groups attached, C =courses attached.

Columns Comments for SMBAOGN_AREA_PRIORITY (23)

Source Code Comments

This field contains the default priority which will be used by compliance unless overriden when the program attaches the area.

Columns Comments for SMBAOGN_YEAR_RULE (24)

Source Code Comments

Field containing number of years course requirements may be considered as fullfilling requirements.

Columns Comments for SMBAOGN_MIN_AREA_GPA (25)

Source Code Comments

Minimum Overall GPA required to complete area.

Columns Comments for SMBAOGN_ACT_AREA_GPA (26)

Source Code Comments

Student's actual Overall GPA achieved.

Columns Comments for SMBAOGN_GRDE_CODE_MIN (27)

Source Code Comments

Minimum grade percourse required to complete area.

Columns Comments for SMBAOGN_COMPL_CREDITS (28)

Source Code Comments

Number of compliance credits which will be used to qualify an area for compliance.

Columns Comments for SMBAOGN_COMPL_COURSES (29)

Source Code Comments

Number of compliance courses which will be used to qualify an area for compliance.

Columns Comments for SMBAOGN_REQ_CREDITS_OVERALL (30)

Source Code Comments

Required number of credits which must be taken to complete area overall requirement.

Columns Comments for SMBAOGN_CONNECTOR_OVERALL (31)

Source Code Comments

Area overall connector used to designate whether overall credits and overall courses should be considered together or individually as a requirement.

Columns Comments for SMBAOGN_REQ_COURSES_OVERALL (32)

Source Code Comments

Required number of courses which must be taken to complete area overall requirement.

Columns Comments for SMBAOGN_ACT_CREDITS_OVERALL (33)

Source Code Comments

Student's actual number of credits counted toward area overall requirement.

Columns Comments for SMBAOGN_ACT_COURSES_OVERALL (34)

Source Code Comments

Student's actual number of courses counted toward area overall requirement.

Columns Comments for SMBAOGN_REQ_CREDITS_INST (35)

Source Code Comments

Required number of credits which must be taken to complete area institutional requirement.

Columns Comments for SMBAOGN_CONNECTOR_INST (36)

Source Code Comments

Area institutional connector used to designate whether institutional credits and institutional courses should be considered together or individually as a requirement.

Columns Comments for SMBAOGN_REQ_COURSES_INST (37)

Source Code Comments

Required number of courses which must be taken to complete area institutional requirement.

Columns Comments for SMBAOGN_ACT_CREDITS_INST (38)

Source Code Comments

Student's actual number of credits counted toward area institutional requirement.

Columns Comments for SMBAOGN_ACT_COURSES_INST (39)

Source Code Comments

Student's actual number of courses counted toward area institutional requirement.

Columns Comments for SMBAOGN_REQ_CREDITS_I_TRAD (40)

Source Code Comments

Required number of credits which must be taken to complete area institution traditional requirement.

Columns Comments for SMBAOGN_CONNECTOR_I_TRAD (41)

Source Code Comments

Area inst trad connector used to designate whether inst trad credits and inst trad courses should be considered together or individually as a requirement.

Columns Comments for SMBAOGN_REQ_COURSES_I_TRAD (42)

Source Code Comments

Required number of courses which must be taken to complete area institution traditional requirement.

Columns Comments for SMBAOGN_ACT_CREDITS_I_TRAD (43)

Source Code Comments

Student's actual number of credits counted toward area institution traditional requirement.

Columns Comments for SMBAOGN_ACT_COURSES_I_TRAD (44)

Source Code Comments

Student's actual number of courses counted toward area institution traditional requirement.

Columns Comments for SMBAOGN_MAX_CREDITS_I_NONTRAD (45)

Source Code Comments

Maximum number of institution non-traditional credits which may be used to fill area requirements.

Columns Comments for SMBAOGN_CONNECTOR_I_NONTRAD (46)

Source Code Comments

Area inst non-trad connector used to designate whether inst non-trad credits and inst non-trad courses should be considered together or individually as a requirement.

Columns Comments for SMBAOGN_MAX_COURSES_I_NONTRAD (47)

Source Code Comments

Maximum number of institution non-traditional courses which may be used to fill area requirements.

Columns Comments for SMBAOGN_ACT_CREDITS_I_NONTRAD (48)

Source Code Comments

Student's actual number of institution non-traditional credits counted toward area requirements.

Columns Comments for SMBAOGN_ACT_COURSES_I_NONTRAD (49)

Source Code Comments

Student's actual number of institution non-traditional courses counted toward area requirements.

Columns Comments for SMBAOGN_MAX_CREDITS_TRANSFER (50)

Source Code Comments

Maximum number of transfer credits which may be used to fill area requirements.

Columns Comments for SMBAOGN_CONNECTOR_TRANSFER (51)

Source Code Comments

Area transfer connector used to designate whether transfer credits and transfer courses should be considered together or individually as a requirement restriction.

Columns Comments for SMBAOGN_MAX_COURSES_TRANSFER (52)

Source Code Comments

Maximum number of transfer courses which may be used to fill area requirements.

Columns Comments for SMBAOGN_ACT_CREDITS_TRANSFER (53)

Source Code Comments

Student's actual number of transfer credits counted toward area requirements.

Columns Comments for SMBAOGN_ACT_COURSES_TRANSFER (54)

Source Code Comments

Student's actual number of transfer courses counted toward area requirements.

Columns Comments for SMBAOGN_ACTN_CODE (55)

Source Code Comments

Student adjustment action code with valid action indicator of (W)aive, (A)dd, or (S)ubstitution.

Columns Comments for SMBAOGN_ATTACH_SOURCE_IND (56)

Source Code Comments

Area attachment source indicator. Valid values: (O)riginal, or (A)djusted.

Columns Comments for SMBAOGN_ADJ_CREDITS (57)

Source Code Comments

Adjusted credits to be counted toward area and program overall totals.

Columns Comments for SMBAOGN_ADJ_COURSES (58)

Source Code Comments

Adjusted courses to be counted toward area and program overall totals.

Table SMRAOGD

Schema Name SATURN
Label SMRAOGD
Server name S4B70
Creation Date 09/29/2003 12:09:50:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
SMRAOGD_PIDM SMRAOGD_PIDM NUMBER(8,0) No * *
SMRAOGD_REQUEST_NO SMRAOGD_REQUEST_NO NUMBER(4,0) No * *
SMRAOGD_AREA SMRAOGD_AREA VARCHAR2(10) No *
SMRAOGD_GRDE_CODE SMRAOGD_GRDE_CODE VARCHAR2(6) No *
SMRAOGD_PROGRAM SMRAOGD_PROGRAM VARCHAR2(12) No
SMRAOGD_SOURCE_IND SMRAOGD_SOURCE_IND VARCHAR2(1) No
SMRAOGD_TERM_CODE_EFF SMRAOGD_TERM_CODE_EFF VARCHAR2(6) No
SMRAOGD_ACTIVITY_DATE SMRAOGD_ACTIVITY_DATE DATE No
SMRAOGD_MAX_CREDITS SMRAOGD_MAX_CREDITS NUMBER(11,3) Yes
SMRAOGD_CONNECTOR_MAX SMRAOGD_CONNECTOR_MAX VARCHAR2(1) No
SMRAOGD_MAX_COURSES SMRAOGD_MAX_COURSES NUMBER(3,0) Yes
SMRAOGD_ACT_CREDITS SMRAOGD_ACT_CREDITS NUMBER(11,3) Yes
SMRAOGD_ACT_COURSES SMRAOGD_ACT_COURSES NUMBER(3,0) Yes
SMRAOGD_ACTN_CODE SMRAOGD_ACTN_CODE VARCHAR2(3) Yes *

Foreign Key information

Column name is Foreign Key For Column on Table
SMRAOGD_PIDM SMRRQCM_PIDM SMRRQCM
SMRAOGD_REQUEST_NO SMRRQCM_REQUEST_NO SMRRQCM
SMRAOGD_ACTN_CODE STVACTN_CODE STVACTN

Index

Index Name Index Type Column Name
PK_SMRAOGD Unique SMRAOGD_PIDM
PK_SMRAOGD Unique SMRAOGD_REQUEST_NO
PK_SMRAOGD Unique SMRAOGD_AREA
PK_SMRAOGD Unique SMRAOGD_GRDE_CODE

Calling objects (non escalated)

Object Name Object Type Parent Name Link Type
ins_smraogd C/C++ Function [F:\BANNER\C\SMRJOBS.PC] Use(insert )
ins_smraogd C/C++ Function [F:\BANNER\C\SMRCMPL.H] Use(insert )
process C/C++ Function [F:\BANNER\C\SSRSCRM.PC] Use(delete )
process C/C++ Function [F:\BANNER\C\SHREDIP.PC] Use(delete )
process C/C++ Function [F:\BANNER\C\SMRJOBS.PC] Use(delete )
process C/C++ Function [F:\BANNER\C\SMRCMPL.H] Use(delete )
process C/C++ Function [F:\BANNER\C\SSRSCMT.PC] Use(delete )
del_spec_tables C/C++ Function [F:\BANNER\C\SMRJOBS.PC] Use(delete )
SMRAOGD SYNONYM S4B70.PUBLIC Rely on ()
DELETE_COMPLIANCE_RESULTS Forms Trigger BANNER7_FORMS.SFAREGS Use(delete )
DELETE_COMPLIANCE_RESULTS Forms Trigger BANNER7_FORMS_10G.SFAREGS Use(delete )
WHEN-NEW-BLOCK-INSTANCE Forms Trigger BANNER7_FORMS.SMIAOUT.SMRAOGD Use(select )
WHEN-NEW-BLOCK-INSTANCE Forms Trigger BANNER7_FORMS_10G.SMIAOUT.SMRAOGD Use(select )
DELETE_SMRAOGD Forms Procedure BANNER7_FORMS.SMARQCM Use(delete )
DELETE_SMRAOGD Forms Procedure BANNER7_FORMS.SMACACT Use(delete )
DELETE_SMRAOGD Forms Procedure BANNER7_FORMS_10G.SMARQCM Use(delete )
DELETE_SMRAOGD Forms Procedure BANNER7_FORMS_10G.SMACACT Use(delete )
CHECK_SMRAOGD Forms Function BANNER7_FORMS.SMIAOUT Use(select )
CHECK_SMRAOGD Forms Function BANNER7_FORMS_10G.SMIAOUT Use(select )
P_DELETEPRIORSMRRQCM Package procedure S4B70.BANINST1.SFKPREQ Use(delete )
P_DELETEPRIORSMRRQCM Package procedure S4B70.BANINST1.SFKFUNC Use(delete )
P_DELETE_COMPLIANCE_RESULTS Package procedure S4B70.BANINST1.SFKMODS Use(delete )
P_GET_SMRAOGD Package procedure S4B70.BANINST1.SMKXAPI Rely on ()
P_GET_SMRAOGD Package procedure S4B70.BANINST1.SMKXAPI Use(select )
P_GET_SMRAOGD Package procedure S4B70.BANINST1.SMKXAPI Use(select )
P_GET_SMRCRLT Package procedure S4B70.BANINST1.SMRCRLT Rely on ()
P_GET_SMRCRLT Package procedure S4B70.BANINST1.SMRCRLT Rely on ()
P_GET_SMRGOGD Package procedure S4B70.BANINST1.SMKXAPI Rely on ()