GOBDIRO GOBFNXR GOBSRVR GOBTPAC GORADRL GORDADD GORDPRF GOREMAL GORPAUD GORPPRM GORSRVR GORTCTL GTVDIRO GTVEMAL GUBSRVY GURSRVQ GURSVRL GURUPRF SPBPERS SPRADDR SPRIDEN STVATYP GOVSRVR SPRIDEN reference

Model Web Management


Model Label : Banner General Web Management
Path : BANNER DEV/General/ERD/Web Management

List of Objects

Object Name Object Type Layer Name
GOBDIRO TABLE Default
GOBFNXR TABLE Default
GOBSRVR TABLE Default
GOBTPAC TABLE Default
GORADRL TABLE Default
GORDADD TABLE Default
GORDPRF TABLE Default
GOREMAL TABLE Default
GORPAUD TABLE Default
GORPPRM TABLE Default
GORSRVR TABLE Default
GORTCTL TABLE Default
GOVSRVR VIEW Default
GTVDIRO TABLE Default
GTVEMAL TABLE Default
GUBSRVY TABLE Default
GURSRVQ TABLE Default
GURSVRL TABLE Default
GURUPRF TABLE Default
SPBPERS TABLE Default
SPRADDR TABLE Default
SPRIDEN TABLE Default
SPRIDEN reference User Object Default
STVATYP TABLE Default

Comments

Model View

''

Table GOBDIRO

Schema Name GENERAL
Label GOBDIRO
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:26:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOBDIRO_DIRO_CODE GOBDIRO_DIRO_CODE VARCHAR2(8) No * *
GOBDIRO_DIRECTORY_TYPE GOBDIRO_DIRECTORY_TYPE VARCHAR2(1) No
GOBDIRO_ITEM_TYPE GOBDIRO_ITEM_TYPE VARCHAR2(1) No
GOBDIRO_DISP_PROFILE_IND GOBDIRO_DISP_PROFILE_IND VARCHAR2(1) No
GOBDIRO_UPD_PROFILE_IND GOBDIRO_UPD_PROFILE_IND VARCHAR2(1) No
GOBDIRO_NON_PROFILE_DEF_IND GOBDIRO_NON_PROFILE_DEF_IND VARCHAR2(1) No
GOBDIRO_SYSTEM_REQ_IND GOBDIRO_SYSTEM_REQ_IND VARCHAR2(1) No
GOBDIRO_ACTIVITY_DATE GOBDIRO_ACTIVITY_DATE DATE No
GOBDIRO_SEQ_NO GOBDIRO_SEQ_NO NUMBER(2,0) No

Foreign Key information

Column name is Foreign Key For Column on Table
GOBDIRO_DIRO_CODE GTVDIRO_CODE GTVDIRO

Index

Index Name Index Type Column Name
PK_GOBDIRO Unique GOBDIRO_DIRO_CODE

Comments

Source Code Comments

Directory Options Rule Table

Columns Comments for GOBDIRO_DIRO_CODE (1)

Source Code Comments

DIRECTORY CODE: Code for Directory Item.

Columns Comments for GOBDIRO_DIRECTORY_TYPE (2)

Source Code Comments

DIRECTORY TYPE INDICATOR: Indicator to print in (S)tudent, (E)mployee, or (A)ll Directories.

Columns Comments for GOBDIRO_ITEM_TYPE (3)

Source Code Comments

DIRECTORY ITEM TYPE INDICATOR: Indicator for Item Type; (A)ddress, (T)elephone, or (N)ot Applicable.

Columns Comments for GOBDIRO_DISP_PROFILE_IND (4)

Source Code Comments

INCLUDE IN DIRECTORY INDICATOR: Indicator to display in Directory; (Y)es or (N)o.

Columns Comments for GOBDIRO_UPD_PROFILE_IND (5)

Source Code Comments

DISPLAY IN DIRECTORY INDICATOR: Indicator to allow User to choose to display in directory; (Y)es or (N)o.

Columns Comments for GOBDIRO_NON_PROFILE_DEF_IND (6)

Source Code Comments

DEFAULT INDICATOR: Indicator to default to directory for users without a directory profile; (Y)es or (N)o.

Columns Comments for GOBDIRO_SYSTEM_REQ_IND (7)

Source Code Comments

SYSTEM REQUIRED INDICATOR: System Required Indicator.

Columns Comments for GOBDIRO_ACTIVITY_DATE (8)

Source Code Comments

ACTIVITY DATE: Date of last activity on this record.

Columns Comments for GOBDIRO_SEQ_NO (9)

Source Code Comments

SEQUENCE NUMBER: Directory profile indicator.

Table GOBFNXR

Schema Name GENERAL
Label GOBFNXR
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:26:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOBFNXR_FUNCTION GOBFNXR_FUNCTION VARCHAR2(30) No *
GOBFNXR_PACKAGE GOBFNXR_PACKAGE VARCHAR2(80) No *
GOBFNXR_SYS_REQ_IND GOBFNXR_SYS_REQ_IND VARCHAR2(1) No
GOBFNXR_ACTIVITY_DATE GOBFNXR_ACTIVITY_DATE DATE No
GOBFNXR_USER_ID GOBFNXR_USER_ID VARCHAR2(30) No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GOBFNXR Unique GOBFNXR_PACKAGE
PK_GOBFNXR Unique GOBFNXR_FUNCTION

Comments

Source Code Comments

Third-Party Function Calls Table.

Columns Comments for GOBFNXR_FUNCTION (1)

Source Code Comments

Function or transaction label associated with the package and procedure e.g. MAIN_MENU, REG_MENU, FIN_MENU.

Columns Comments for GOBFNXR_PACKAGE (2)

Source Code Comments

Name of package and procedure associated with function.

Columns Comments for GOBFNXR_SYS_REQ_IND (3)

Source Code Comments

System Required Indicator. Indicates whether the record is required by the SCT system.

Columns Comments for GOBFNXR_ACTIVITY_DATE (4)

Source Code Comments

Date on which the record was last updated or created.

Columns Comments for GOBFNXR_USER_ID (5)

Source Code Comments

The user id of the person who updates this record.

Table GOBSRVR

Schema Name GENERAL
Label GOBSRVR
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:27:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOBSRVR_PIDM GOBSRVR_PIDM NUMBER(8,0) No *
GOBSRVR_NAME GOBSRVR_NAME VARCHAR2(15) No *
GOBSRVR_ACTIVITY_DATE GOBSRVR_ACTIVITY_DATE DATE No
GOBSRVR_USER GOBSRVR_USER VARCHAR2(30) No
GOBSRVR_DECLINED_IND GOBSRVR_DECLINED_IND VARCHAR2(1) No
GOBSRVR_COMPLETE_IND GOBSRVR_COMPLETE_IND VARCHAR2(1) No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GOBSRVR Unique GOBSRVR_PIDM
PK_GOBSRVR Unique GOBSRVR_NAME

Comments

Source Code Comments

Survey Response Header Table. This table contains one row for each person who responds to the survey.

Columns Comments for GOBSRVR_PIDM (1)

Source Code Comments

Internal Identification Number of the person who responded to the survey.

Columns Comments for GOBSRVR_NAME (2)

Source Code Comments

Survey Name.

Columns Comments for GOBSRVR_ACTIVITY_DATE (3)

Source Code Comments

The date that the person last responded to the survey.

Columns Comments for GOBSRVR_USER (4)

Source Code Comments

The User ID(Oracle) of the person who responded to the survey.

Columns Comments for GOBSRVR_DECLINED_IND (5)

Source Code Comments

Declined Indicator. Y = user declined to answer the survey.

Columns Comments for GOBSRVR_COMPLETE_IND (6)

Source Code Comments

Complete Indicator. Y indicates complete, N indicates incomplete.

Table GOBTPAC

Schema Name GENERAL
Label GOBTPAC
Server name MALDEV8_B60
Creation Date 03/14/2003 14:35:35:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOBTPAC_PIDM GOBTPAC_PIDM NUMBER(8,0) No *
GOBTPAC_PIN_DISABLED_IND GOBTPAC_PIN_DISABLED_IND VARCHAR2(1) No
GOBTPAC_USAGE_ACCEPT_IND GOBTPAC_USAGE_ACCEPT_IND VARCHAR2(1) No
GOBTPAC_ACTIVITY_DATE GOBTPAC_ACTIVITY_DATE DATE No
GOBTPAC_USER GOBTPAC_USER VARCHAR2(30) No
GOBTPAC_PIN GOBTPAC_PIN VARCHAR2(6) Yes
GOBTPAC_PIN_EXP_DATE GOBTPAC_PIN_EXP_DATE DATE Yes
GOBTPAC_EXTERNAL_USER GOBTPAC_EXTERNAL_USER VARCHAR2(30) Yes
GOBTPAC_QUESTION GOBTPAC_QUESTION VARCHAR2(90) Yes
GOBTPAC_RESPONSE GOBTPAC_RESPONSE VARCHAR2(30) Yes
GOBTPAC_INSERT_SOURCE GOBTPAC_INSERT_SOURCE VARCHAR2(8) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
GOBTPAC_KEY_INDEX Unique GOBTPAC_EXTERNAL_USER
PK_GOBTPAC Unique GOBTPAC_PIDM

Comments

Source Code Comments

Third Party Access Table

Columns Comments for GOBTPAC_PIDM (1)

Source Code Comments

Banner PIDM

Columns Comments for GOBTPAC_PIN_DISABLED_IND (2)

Source Code Comments

PIN disabled Indicator. When Y, access to SCT Third Party Access products (Web Fors, VR, Kiosk) will be denied.

Columns Comments for GOBTPAC_USAGE_ACCEPT_IND (3)

Source Code Comments

Terms of Usage accepted indicator. When N, Terms of Usage page displays upon login to Web For products. When Y then it does not display. This page can be customized using the WebTailor Customize a set of Information Text feature.

Columns Comments for GOBTPAC_ACTIVITY_DATE (4)

Source Code Comments

Date on which the record was last added or updated.

Columns Comments for GOBTPAC_USER (5)

Source Code Comments

Oracle User ID of the last user to modify the record

Columns Comments for GOBTPAC_PIN (6)

Source Code Comments

Personal Identification Number. It is used together with the Login ID to access SCT Third Party products and other partner systems. Must be a six digit number.

Columns Comments for GOBTPAC_PIN_EXP_DATE (7)

Source Code Comments

PIN expiration date. When valued and the date is in the past, a user attempting to access a Third Party product will be required to change their pin.

Columns Comments for GOBTPAC_EXTERNAL_USER (8)

Source Code Comments

Value which may be passed to the partner systems as a login ID and/or email ID..

Columns Comments for GOBTPAC_QUESTION (9)

Source Code Comments

Free form question entered by a Web User to be used as a hint when trying to get their PIN reset.

Columns Comments for GOBTPAC_RESPONSE (10)

Source Code Comments

Free form response entered by a Web User to be used as answer to the hint question when trying to get their PIN reset.

Columns Comments for GOBTPAC_INSERT_SOURCE (11)

Source Code Comments

ACTIVITY SOURCE: Describes the source of the GOBTPAC insert or update. SELF = User change the pin record, ADMIN = Administrator change the pin record, SYSTEM = Record was changed by the logic in a proces
s.

Table GORADRL

Schema Name GENERAL
Label GORADRL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:27:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GORADRL_ATYP_CODE GORADRL_ATYP_CODE VARCHAR2(2) No * *
GORADRL_ROLE GORADRL_ROLE VARCHAR2(30) No *
GORADRL_PRIV_IND GORADRL_PRIV_IND VARCHAR2(1) No
GORADRL_ACTIVITY_DATE GORADRL_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
GORADRL_ATYP_CODE STVATYP_CODE STVATYP

Index

Index Name Index Type Column Name
PK_GORADRL Unique GORADRL_ATYP_CODE
PK_GORADRL Unique GORADRL_ROLE

Comments

Source Code Comments

Address/User Roles Rules Table

Columns Comments for GORADRL_ATYP_CODE (1)

Source Code Comments

Address Type Code

Columns Comments for GORADRL_ROLE (2)

Source Code Comments

User Role. Values are STUDENT, EMPLOYEE, or FACULTY

Columns Comments for GORADRL_PRIV_IND (3)

Source Code Comments

Privilege Indicator. Values are (U)pdate, (D)isplay, or (N)one

Columns Comments for GORADRL_ACTIVITY_DATE (4)

Source Code Comments

Last Activity Date

Table GORDADD

Schema Name GENERAL
Label GORDADD
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:27:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GORDADD_DIRO_CODE GORDADD_DIRO_CODE VARCHAR2(8) No * *
GORDADD_PRIORITY_NO GORDADD_PRIORITY_NO NUMBER(1,0) No *
GORDADD_ATYP_CODE GORDADD_ATYP_CODE VARCHAR2(2) Yes
GORDADD_TELE_CODE GORDADD_TELE_CODE VARCHAR2(4) Yes
GORDADD_ACTIVITY_DATE GORDADD_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
GORDADD_DIRO_CODE GOBDIRO_DIRO_CODE GOBDIRO

Index

Index Name Index Type Column Name
PK_GORDADD Unique GORDADD_DIRO_CODE
PK_GORDADD Unique GORDADD_PRIORITY_NO

Comments

Source Code Comments

Directory Address Table

Columns Comments for GORDADD_DIRO_CODE (1)

Source Code Comments

DIRECTORY CODE: Code for Directory Item.

Columns Comments for GORDADD_PRIORITY_NO (2)

Source Code Comments

PRIORITY NUMBER: Priority Number.

Columns Comments for GORDADD_ATYP_CODE (3)

Source Code Comments

ADDRESS TYPE CODE: Address Type Code.

Columns Comments for GORDADD_TELE_CODE (4)

Source Code Comments

TELEPHONE TYPE CODE: Telephone Type Code.

Columns Comments for GORDADD_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: Date of last activity on this record.

Table GORDPRF

Schema Name GENERAL
Label GORDPRF
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:28:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GORDPRF_PIDM GORDPRF_PIDM NUMBER(8,0) No *
GORDPRF_DIRO_CODE GORDPRF_DIRO_CODE VARCHAR2(8) No * *
GORDPRF_DISP_DIRECTORY_IND GORDPRF_DISP_DIRECTORY_IND VARCHAR2(1) No
GORDPRF_USER_ID GORDPRF_USER_ID VARCHAR2(30) No
GORDPRF_ACTIVITY_DATE GORDPRF_ACTIVITY_DATE DATE No

Foreign Key information

Column name is Foreign Key For Column on Table
GORDPRF_DIRO_CODE GOBDIRO_DIRO_CODE GOBDIRO

Index

Index Name Index Type Column Name
PK_GORDPRF Unique GORDPRF_PIDM
PK_GORDPRF Unique GORDPRF_DIRO_CODE

Comments

Source Code Comments

Directory Profile Table

Columns Comments for GORDPRF_PIDM (1)

Source Code Comments

PIDM NUMBER: Personal Identification Number.

Columns Comments for GORDPRF_DIRO_CODE (2)

Source Code Comments

DIRECTORY CODE: Code for Directory Item.

Columns Comments for GORDPRF_DISP_DIRECTORY_IND (3)

Source Code Comments

DISPLAY INDICATOR: Display Indicator; Y or N.

Columns Comments for GORDPRF_USER_ID (4)

Source Code Comments

USER ID: The ORACLE user id of the person last updating this record.

Columns Comments for GORDPRF_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: Date of last activity on this record.

Table GOREMAL

Schema Name GENERAL
Label GOREMAL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:28:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GOREMAL_PIDM GOREMAL_PIDM NUMBER(8,0) No *
GOREMAL_PIDM GOREMAL_PIDM NUMBER(8,0) No *
GOREMAL_EMAL_CODE GOREMAL_EMAL_CODE VARCHAR2(4) No *
GOREMAL_EMAIL_ADDRESS GOREMAL_EMAIL_ADDRESS VARCHAR2(90) No
GOREMAL_STATUS_IND GOREMAL_STATUS_IND VARCHAR2(1) No
GOREMAL_PREFERRED_IND GOREMAL_PREFERRED_IND VARCHAR2(1) No
GOREMAL_ACTIVITY_DATE GOREMAL_ACTIVITY_DATE DATE No
GOREMAL_USER_ID GOREMAL_USER_ID VARCHAR2(30) No
GOREMAL_COMMENT GOREMAL_COMMENT VARCHAR2(60) Yes
GOREMAL_DISP_WEB_IND GOREMAL_DISP_WEB_IND VARCHAR2(1) No

Foreign Key information

Column name is Foreign Key For Column on Table
GOREMAL_EMAL_CODE GTVEMAL_CODE GTVEMAL
GOREMAL_PIDM SPBPERS_PIDM SPBPERS
GOREMAL_PIDM SARADAP_PIDM SARADAP

Index

Index Name Index Type Column Name
GOREMAL_EMAL_INDEX GOREMAL_PIDM
GOREMAL_EMAL_INDEX GOREMAL_EMAL_CODE

Comments

Source Code Comments

Person E-mail repeating table.

Columns Comments for GOREMAL_PIDM (1)

Source Code Comments

The pidm of the entity who owns this e-mail information.

Columns Comments for GOREMAL_EMAL_CODE (2)

Source Code Comments

The type of e-mail address.

Columns Comments for GOREMAL_EMAIL_ADDRESS (3)

Source Code Comments

The e-mail address.

Columns Comments for GOREMAL_STATUS_IND (4)

Source Code Comments

The status of the e-mail address: (A)ctive, (I)nactive

Columns Comments for GOREMAL_PREFERRED_IND (5)

Source Code Comments

This column indicates if the e-mail address is the preferred contact address.

Columns Comments for GOREMAL_ACTIVITY_DATE (6)

Source Code Comments

The date on which the row was added or modified.

Columns Comments for GOREMAL_USER_ID (7)

Source Code Comments

The user id when the row was added or modified.

Columns Comments for GOREMAL_COMMENT (8)

Source Code Comments

This is a free format comment regarding the e-mail information.

Columns Comments for GOREMAL_DISP_WEB_IND (9)

Source Code Comments

Indicate whether a e-mail address should appear on Web.

Table GORPAUD

Schema Name GENERAL
Label GORPAUD
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:29:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GORPAUD_PIDM GORPAUD_PIDM NUMBER(8,0) No
GORPAUD_ACTIVITY_DATE GORPAUD_ACTIVITY_DATE DATE No
GORPAUD_USER GORPAUD_USER VARCHAR2(30) No
GORPAUD_PIN GORPAUD_PIN VARCHAR2(6) Yes
GORPAUD_EXTERNAL_USER GORPAUD_EXTERNAL_USER VARCHAR2(30) Yes
GORPAUD_CHG_IND GORPAUD_CHG_IND VARCHAR2(1) No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
GORPAUD_KEY_INDEX GORPAUD_PIDM
GORPAUD_KEY_INDEX2 GORPAUD_EXTERNAL_USER

Comments

Source Code Comments

Third Party Access Audit Table

Columns Comments for GORPAUD_PIDM (1)

Source Code Comments

Banner PIDM

Columns Comments for GORPAUD_ACTIVITY_DATE (2)

Source Code Comments

Date on which the audit trail record was modified.

Columns Comments for GORPAUD_USER (3)

Source Code Comments

Oracle User ID of the user who created or last updated the PIN

Columns Comments for GORPAUD_PIN (4)

Source Code Comments

Previous PIN

Columns Comments for GORPAUD_EXTERNAL_USER (5)

Source Code Comments

Previous External User.

Columns Comments for GORPAUD_CHG_IND (6)

Source Code Comments

Change Indicator. Flag used to indicate why this audit record was written. P = PIN change, I = User ID change.

Table GORPPRM

Schema Name GENERAL
Label GORPPRM
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:30:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GORPPRM_PACKAGE GORPPRM_PACKAGE VARCHAR2(80) No
GORPPRM_SEQ GORPPRM_SEQ NUMBER(0,0) No
GORPPRM_NAME GORPPRM_NAME VARCHAR2(30) No
GORPPRM_KEY_POS GORPPRM_KEY_POS NUMBER(0,0) No
GORPPRM_OUTPUT_IND GORPPRM_OUTPUT_IND VARCHAR2(1) No
GORPPRM_TYPE_IND GORPPRM_TYPE_IND VARCHAR2(1) No
GORPPRM_MIN_LEN GORPPRM_MIN_LEN NUMBER(0,0) No
GORPPRM_MAX_LEN GORPPRM_MAX_LEN NUMBER(0,0) No
GORPPRM_SYS_REQ_IND GORPPRM_SYS_REQ_IND VARCHAR2(1) No
GORPPRM_ACTIVITY_DATE GORPPRM_ACTIVITY_DATE DATE No
GORPPRM_USER_ID GORPPRM_USER_ID VARCHAR2(30) No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
GORPPRM_KEY_INDEX Unique GORPPRM_PACKAGE
GORPPRM_KEY_INDEX Unique GORPPRM_SEQ

Comments

Source Code Comments

Third-Party Function Parameters Table.

Columns Comments for GORPPRM_PACKAGE (1)

Source Code Comments

Name of package and procedure.

Columns Comments for GORPPRM_SEQ (2)

Source Code Comments

Sequence number of parameter.

Columns Comments for GORPPRM_NAME (3)

Source Code Comments

Parameter value used by procedure.

Columns Comments for GORPPRM_KEY_POS (4)

Source Code Comments

Position in data string in which the parameter resides.

Columns Comments for GORPPRM_OUTPUT_IND (5)

Source Code Comments

Flag indicating whether data contained in parameter is to be included in the output string.

Columns Comments for GORPPRM_TYPE_IND (6)

Source Code Comments

Type of data contained in the parameter, e.g. character or number.

Columns Comments for GORPPRM_MIN_LEN (7)

Source Code Comments

Minimum length of data contained in parameter.

Columns Comments for GORPPRM_MAX_LEN (8)

Source Code Comments

Maximum length of data contained in parameter.

Columns Comments for GORPPRM_SYS_REQ_IND (9)

Source Code Comments

System Required Indicator. Indicates whether the record is required by the SCT system.

Columns Comments for GORPPRM_ACTIVITY_DATE (10)

Source Code Comments

Date on which the record was last updated or created.

Columns Comments for GORPPRM_USER_ID (11)

Source Code Comments

User ID of the person who updates this record.

Table GORSRVR

Schema Name GENERAL
Label GORSRVR
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:30:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GORSRVR_PIDM GORSRVR_PIDM NUMBER(8,0) No * *
GORSRVR_NAME GORSRVR_NAME VARCHAR2(15) No * *
GORSRVR_QUESTION_NO GORSRVR_QUESTION_NO NUMBER(3,0) No *
GORSRVR_ACTIVITY_DATE GORSRVR_ACTIVITY_DATE DATE No
GORSRVR_USER GORSRVR_USER VARCHAR2(30) No
GORSRVR_RESPONSE_1 GORSRVR_RESPONSE_1 VARCHAR2(1) Yes
GORSRVR_RESPONSE_2 GORSRVR_RESPONSE_2 VARCHAR2(1) Yes
GORSRVR_RESPONSE_3 GORSRVR_RESPONSE_3 VARCHAR2(1) Yes
GORSRVR_RESPONSE_4 GORSRVR_RESPONSE_4 VARCHAR2(1) Yes
GORSRVR_RESPONSE_5 GORSRVR_RESPONSE_5 VARCHAR2(1) Yes
GORSRVR_COMMENTS GORSRVR_COMMENTS VARCHAR2(2000) Yes

Foreign Key information

Column name is Foreign Key For Column on Table
GORSRVR_PIDM GOBSRVR_PIDM GOBSRVR
GORSRVR_NAME GOBSRVR_NAME GOBSRVR

Index

Index Name Index Type Column Name
PK_GORSRVR Unique GORSRVR_PIDM
PK_GORSRVR Unique GORSRVR_NAME
PK_GORSRVR Unique GORSRVR_QUESTION_NO

Comments

Source Code Comments

Survey Repsonses Repeating Table. This tables store the individual responses.

Columns Comments for GORSRVR_PIDM (1)

Source Code Comments

Internal Identification Number of the person who responded to the survey.

Columns Comments for GORSRVR_NAME (2)

Source Code Comments

Survey Name.

Columns Comments for GORSRVR_QUESTION_NO (3)

Source Code Comments

Survey Response Question Number.

Columns Comments for GORSRVR_ACTIVITY_DATE (4)

Source Code Comments

The date that the response was created or last updated.

Columns Comments for GORSRVR_USER (5)

Source Code Comments

The User ID which created or last updated the response.

Columns Comments for GORSRVR_RESPONSE_1 (6)

Source Code Comments

First possible response. Y indicates yes, N indicates no.

Columns Comments for GORSRVR_RESPONSE_2 (7)

Source Code Comments

Second possible response. Y indicates yes, N indicates no.

Columns Comments for GORSRVR_RESPONSE_3 (8)

Source Code Comments

Third possible response. Y indicates yes, N indicates no.

Columns Comments for GORSRVR_RESPONSE_4 (9)

Source Code Comments

Fourth possible response. Y indicates yes, N indicates no.

Columns Comments for GORSRVR_RESPONSE_5 (10)

Source Code Comments

Fifth possible response. Y indicates yes, N indicates no.

Columns Comments for GORSRVR_COMMENTS (11)

Source Code Comments

Free form text entered as comments by the respondent.

Table GORTCTL

Schema Name GENERAL
Label GORTCTL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:30:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GORTCTL_GROUP GORTCTL_GROUP VARCHAR2(15) No
GORTCTL_FUNCTION GORTCTL_FUNCTION VARCHAR2(20) No
GORTCTL_DESC GORTCTL_DESC VARCHAR2(60) No
GORTCTL_TERM_YEAR GORTCTL_TERM_YEAR VARCHAR2(6) No
GORTCTL_TCTL_NUM GORTCTL_TCTL_NUM NUMBER(2,0) No
GORTCTL_VALUE GORTCTL_VALUE VARCHAR2(2) No
GORTCTL_ACTIVE_IND GORTCTL_ACTIVE_IND VARCHAR2(1) No
GORTCTL_SYS_REQ_IND GORTCTL_SYS_REQ_IND VARCHAR2(1) No
GORTCTL_ACTIVITY_DATE GORTCTL_ACTIVITY_DATE DATE No
GORTCTL_USER_ID GORTCTL_USER_ID VARCHAR2(30) No
GORTCTL_TCTL_SEQNO GORTCTL_TCTL_SEQNO NUMBER(2,0) Yes
GORTCTL_BEGIN_DATE GORTCTL_BEGIN_DATE DATE Yes
GORTCTL_END_DATE GORTCTL_END_DATE DATE Yes
GORTCTL_BEGIN_TIME GORTCTL_BEGIN_TIME VARCHAR2(4) Yes
GORTCTL_END_TIME GORTCTL_END_TIME VARCHAR2(4) Yes
GORTCTL_DAYS_AVAIL GORTCTL_DAYS_AVAIL VARCHAR2(9) Yes
GORTCTL_YEAR GORTCTL_YEAR VARCHAR2(4) Yes
GORTCTL_YEAR_2 GORTCTL_YEAR_2 VARCHAR2(4) Yes
GORTCTL_VALUE_2 GORTCTL_VALUE_2 VARCHAR2(30) Yes
GORTCTL_VALUE_3 GORTCTL_VALUE_3 VARCHAR2(30) Yes
GORTCTL_VALUE_4 GORTCTL_VALUE_4 VARCHAR2(30) Yes
GORTCTL_TERM_YEAR_2 GORTCTL_TERM_YEAR_2 VARCHAR2(6) Yes
GORTCTL_DATE GORTCTL_DATE DATE Yes
GORTCTL_SYSI_CODE GORTCTL_SYSI_CODE VARCHAR2(2) Yes
GORTCTL_SYSI_CODE_2 GORTCTL_SYSI_CODE_2 VARCHAR2(2) Yes
GORTCTL_RECORD_TYPE GORTCTL_RECORD_TYPE VARCHAR2(10) Yes

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
GORTCTL_KEY_INDEX GORTCTL_FUNCTION
GORTCTL_KEY_INDEX GORTCTL_GROUP

Comments

Source Code Comments

Third-Party Electronic Controls Table.

Columns Comments for GORTCTL_GROUP (1)

Source Code Comments

Group to which record belongs, e.g. if the record contains the start and stop times for Registration, the Group would be REGISTRATION.

Columns Comments for GORTCTL_FUNCTION (2)

Source Code Comments

Label associated with the function, e.g. MAIN_MENU, REG_MENU, FIN_MENU.

Columns Comments for GORTCTL_DESC (3)

Source Code Comments

Description of the function named in GORTCTL_FUNCTION e.g. Main Menu, Registration Available, Financial Aid Available.

Columns Comments for GORTCTL_TERM_YEAR (4)

Source Code Comments

Term Code or Year for which the record is effective. Term codes are validated against STVTERM.

Columns Comments for GORTCTL_TCTL_NUM (5)

Source Code Comments

Control number. Uses vary depending on the process and vendor. For Voice Response, it equates to the menu option.

Columns Comments for GORTCTL_VALUE (6)

Source Code Comments

Value associated with the corresponding function. Values currently used by Voice Response are Y, N, B, G where Y equals yes and N equals no.

Columns Comments for GORTCTL_ACTIVE_IND (7)

Source Code Comments

Flag indicating whether the function is currently available. Valid values are Y and N

Columns Comments for GORTCTL_SYS_REQ_IND (8)

Source Code Comments

System Required Indicator. Indicates whether the record is required by the SCT system.

Columns Comments for GORTCTL_ACTIVITY_DATE (9)

Source Code Comments

Date on which the record was last updated or created.

Columns Comments for GORTCTL_USER_ID (10)

Source Code Comments

User ID of the person that last updates this record.

Columns Comments for GORTCTL_TCTL_SEQNO (11)

Source Code Comments

Record Sequence Number. Contains a series of sequential numbers if more than one record exists for a function.

Columns Comments for GORTCTL_BEGIN_DATE (12)

Source Code Comments

Initial Date which the record becomes effective.

Columns Comments for GORTCTL_END_DATE (13)

Source Code Comments

Last date for which the record is effective.

Columns Comments for GORTCTL_BEGIN_TIME (14)

Source Code Comments

Time at which the record becomes effective. Format is HHMM.

Columns Comments for GORTCTL_END_TIME (15)

Source Code Comments

Time after which the record ceases to be effective. Format is HHMM.

Columns Comments for GORTCTL_DAYS_AVAIL (16)

Source Code Comments

Frequency or days on which the record can be used, e.g. Everyday, Mondays, Weekends, Weekdays.

Columns Comments for GORTCTL_YEAR (17)

Source Code Comments

Year. For Voice Response, it contains the year to be spoken, e.g. Financial Aid inquiry is available from Fall GORTCTL_YEAR through Spring GORTCTL_YEAR_2.

Columns Comments for GORTCTL_YEAR_2 (18)

Source Code Comments

Second Year.

Columns Comments for GORTCTL_VALUE_2 (19)

Source Code Comments

Miscellaneous values for third-party applications, e.g for Voice Resonse it contains message numbers.

Columns Comments for GORTCTL_VALUE_3 (20)

Source Code Comments

Miscellaneous values for third-party applications, e.g for Voice Resonse it contains message numbers.

Columns Comments for GORTCTL_VALUE_4 (21)

Source Code Comments

Miscellaneous values for third-party applications, e.g for Voice Resonse it contains message numbers.

Columns Comments for GORTCTL_TERM_YEAR_2 (22)

Source Code Comments

Aidy Year or Year for which the record is effective. Aidy Year codes are validated against RCRAIDY.

Columns Comments for GORTCTL_DATE (23)

Source Code Comments

Additional date relevant to the record.

Columns Comments for GORTCTL_SYSI_CODE (24)

Source Code Comments

System Indicator Code. Identifies the system to which the value contained in GORTCTL_TERM_YEAR is associated for validation purposes.

Columns Comments for GORTCTL_SYSI_CODE_2 (25)

Source Code Comments

System Indicator Code. Identifies the system to which the value contained in GORTCTL_TERM_YEAR_2 is associated for validation purposes.

Columns Comments for GORTCTL_RECORD_TYPE (26)

Source Code Comments

Record Type. Indicates the functional purpose of the record.

Table GTVDIRO

Schema Name GENERAL
Label GTVDIRO
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:32:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVDIRO_CODE GTVDIRO_CODE VARCHAR2(8) No *
GTVDIRO_DESC GTVDIRO_DESC VARCHAR2(30) No
GTVDIRO_SYSTEM_REQ_IND GTVDIRO_SYSTEM_REQ_IND VARCHAR2(1) No
GTVDIRO_ACTIVITY_DATE GTVDIRO_ACTIVITY_DATE DATE No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVDIRO Unique GTVDIRO_CODE

Comments

Source Code Comments

Directory Options Validation Table

Columns Comments for GTVDIRO_CODE (1)

Source Code Comments

DIRECTORY CODE: Code for Directory Item.

Columns Comments for GTVDIRO_DESC (2)

Source Code Comments

DIRECTORY DESCRIPTION: Description for Directory Item.

Columns Comments for GTVDIRO_SYSTEM_REQ_IND (3)

Source Code Comments

SYSTEM REQUIRED INDICATOR: System Required Indicator.

Columns Comments for GTVDIRO_ACTIVITY_DATE (4)

Source Code Comments

ACTIVITY DATE: Date of last activity on this record.

Table GTVEMAL

Schema Name GENERAL
Label GTVEMAL
Server name MALDEV8_B60
Creation Date 05/08/2003 12:42:16:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GTVEMAL_CODE GTVEMAL_CODE VARCHAR2(4) No *
GTVEMAL_DESC GTVEMAL_DESC VARCHAR2(60) Yes
GTVEMAL_ACTIVITY_DATE GTVEMAL_ACTIVITY_DATE DATE No
GTVEMAL_DISP_WEB_IND GTVEMAL_DISP_WEB_IND VARCHAR2(1) No
GTVEMAL_URL_IND GTVEMAL_URL_IND VARCHAR2(1) No

Foreign Key information

No Foreign Key

Index

Index Name Index Type Column Name
PK_GTVEMAL Unique GTVEMAL_CODE

Comments

Source Code Comments

The GTVEMAL table contains the valid e-mail type codes.

Columns Comments for GTVEMAL_CODE (1)

Source Code Comments

A code identifying the type of e-mail address.

Columns Comments for GTVEMAL_DESC (2)

Source Code Comments

The description of the e-mail address.

Columns Comments for GTVEMAL_ACTIVITY_DATE (3)

Source Code Comments

The date on which the row was added or modified.

Columns Comments for GTVEMAL_DISP_WEB_IND (4)

Source Code Comments

Display on Web Indicator, Y indicates this type of email should display

Columns Comments for GTVEMAL_URL_IND (5)

Source Code Comments

URL Indicator, Y indicates that this email record is actually a URL.

Table GUBSRVY

Schema Name GENERAL
Label GUBSRVY
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:37:000

Table Columns information

Column Name Label Column Type Allow NULL PK FK
GUBSRVY_NAME GUBSRVY_NAME VARCHAR2(15) No *
GUBSRVY_TITLE GUBSRVY_TITLE VARCHAR2(60) No
GUBSRVY_DISP_WEB_IND GUBSRVY_DISP_WEB_IND VARCHAR2(1) No
GUBSRVY_ACTIVITY_DATE GUBSRVY_ACTIVITY_DATE DATE No
GUBSRVY_USER GUBSRVY_USER VARCHAR2(30) No
GUBSRVY_FROM_DATE GUBSRVY_FROM_DATE DATE Yes
GUBSRVY_TO_DATE GUBSRVY_TO_DATE DATE Yes
GUBSRVY_EXTR_APPLICATION GUBSRVY_EXTR_APPLICATION VARCHAR2(30) Yes
GUBSRVY_EXTR_SELECTION GUBSRVY_EXTR_SELECTION VARCHAR2(30) Yes
GUBSRVY_EXTR_CREATOR_ID GUBSRVY_EXTR_CREATOR_ID VARCHAR2(30) Yes
GUBSRVY_EXTR_USER_ID GUBSRVY_EXTR_USER_ID VARCHAR2(30) Yes