Tables and Views for GENERAL as of 21-JUN-2004 08:11am
Date: 21-JUN-2004 Page: 1
TABLE: GEBFUNC
CREATOR: GENERAL
Function Header Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GEBFUNC_EVNT_CRN VARCHAR2 5 NO Event associated with the function.
GEBFUNC_FUNC_CODE VARCHAR2 12 NO Code for the Function.
GEBFUNC_ACTIVITY_DATE DATE 7 NO Date on which the Function was added or last changed.
GEBFUNC_ETYP_CODE VARCHAR2 4 NO Function Type Code.
GEBFUNC_FSTA_CODE VARCHAR2 1 NO Function Status Code.
GEBFUNC_PURP_CODE VARCHAR2 10 YES Purpose Code for the Function.
GEBFUNC_PURP_DESC VARCHAR2 60 YES Purpose Code Description for the Function.
GEBFUNC_EMPH_CODE VARCHAR2 10 YES Emphasis Code for the Function.
GEBFUNC_INVITATION_DATE DATE 7 YES Date of the Invitations to the Function.
GEBFUNC_LETR_CODE VARCHAR2 15 YES Letter Code of the letter accompanying the invitation.
GEBFUNC_RSVP_CONFIRM_DATE DATE 7 YES Latest date the RSVP should be received.
GEBFUNC_SPNSR_ORGN_PIDM NUMBER 8 YES PIDM of the Sponsoring Organization of the Function.
GEBFUNC_COMMITTEE_NAME VARCHAR2 60 YES Name of the Committee associated with the Function.
GEBFUNC_PLAN_ATTEND NUMBER 7 YES Planned Attendance number.
GEBFUNC_BRK_EVEN_ATTEND NUMBER 7 YES attendance required for the Function to break even.
GEBFUNC_LOCATION VARCHAR2 60 YES Location of the Function if the Function is not
associated with an Event.
GEBFUNC_LOCATION_DATE DATE 7 YES Date of the Function if the Function is not associated
with an Event.
Date: 21-JUN-2004 Page: 2
TABLE: GERATTD
CREATOR: GENERAL
Invitee Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GERATTD_EVNT_CRN VARCHAR2 5 NO Event associated with the invitee.
GERATTD_FUNC_CODE VARCHAR2 12 NO Function Code associated with the invitee.
GERATTD_PIDM NUMBER 8 NO Internal system generated number associated with the
person invited to the function.
GERATTD_ACTIVITY_DATE DATE 7 NO Date invitee information was last created or modified.
GERATTD_RSVP_CODE VARCHAR2 6 YES RSVP Code for the invitee.
GERATTD_RSVP_DATE DATE 7 YES Date RSVP for the invitee was entered.
GERATTD_FEES_CODE VARCHAR2 5 YES Fee Status Code for the invitee.
GERATTD_FEE_DATE DATE 7 YES Date fee status was last updated or modified for the
invitee.
GERATTD_ATYP_CODE VARCHAR2 2 YES Address Type Code for the invitee.
GERATTD_NAME_TAG_NAME VARCHAR2 60 YES Name tag name for the invitee.
GERATTD_PLACE_CARD_NAME VARCHAR2 60 YES Place card name for the invitee.
GERATTD_TICKET_CNT VARCHAR2 3 YES Number of tickets requested by the invitee.
GERATTD_MENU_CODE VARCHAR2 10 YES Menu Code for the invitee.
GERATTD_ATTENDANCE_IND VARCHAR2 1 YES Indicator to display whether or not the invitee
actually attended the function.
GERATTD_INVOLVE_IND VARCHAR2 1 YES Indicator to display any involvement for the invitee.
GERATTD_COMMENT LONG YES Comment for the invitee.
GERATTD_FEES_DESC VARCHAR2 30 YES Fee Status description for the invitee.
Date: 21-JUN-2004 Page: 3
TABLE: GERFCOM
CREATOR: GENERAL
Function Comments Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GERFCOM_EVNT_CRN VARCHAR2 5 NO Event associated with the comment.
GERFCOM_FUNC_CODE VARCHAR2 12 NO Function Code associated with the comment.
GERFCOM_GRP_SEQ_NO NUMBER 23 20 NO Group sequence number.
GERFCOM_ACTIVITY_DATE DATE 7 NO Date function comment was last created or modified.
GERFCOM_USER_ID VARCHAR2 30 NO User ID associated with the comment.
GERFCOM_COMMENT LONG YES Comment associated with the function.
Date: 21-JUN-2004 Page: 4
TABLE: GERFCON
CREATOR: GENERAL
Function Constituency Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GERFCON_EVNT_CRN VARCHAR2 5 NO Event associated with the function.
GERFCON_FUNC_CODE VARCHAR2 12 NO Function Code.
GERFCON_TARG_CODE VARCHAR2 5 NO Target Audience Code associated with the Function.
GERFCON_ACTIVITY_DATE DATE 7 YES Date the Target Audience Code was added or last
changed.
Date: 21-JUN-2004 Page: 5
TABLE: GERFCOR
CREATOR: GENERAL
Function Correspondence Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GERFCOR_EVNT_CRN VARCHAR2 5 NO Function Correspondence Event CRN.
GERFCOR_FUNC_CODE VARCHAR2 12 NO Function Correspondence Function Code.
GERFCOR_MAIL_CODE VARCHAR2 3 NO Function Correspondence Mail Code.
GERFCOR_ACTIVITY_DATE DATE 7 NO Function Correspondence Activity Date.
GERFCOR_MAIL_DATE DATE 7 YES Function Correspondence Mailing Date.
GERFCOR_NUM_MAILINGS NUMBER 7 YES Function Correspondence Number of Mailings.
GERFCOR_TARG_CODE VARCHAR2 5 YES Function Correspondence Target Audience.
GERFCOR_LETR_CODE VARCHAR2 15 YES Function Correspondence Letter Code.
Date: 21-JUN-2004 Page: 6
TABLE: GERFEXP
CREATOR: GENERAL
Function Expense Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GERFEXP_EVNT_CRN VARCHAR2 5 NO Event associated with the function.
GERFEXP_FUNC_CODE VARCHAR2 12 NO Function Code.
GERFEXP_EXPN_CODE VARCHAR2 2 NO Expense Code associated with the Function Expense.
GERFEXP_ACTIVITY_DATE DATE 7 NO Date the Expense Code was added or last changed.
GERFEXP_BUDGET_AMT NUMBER 8 2 YES Budgeted amount for the expense code for the Function
Expense.
GERFEXP_ACTUAL_AMT NUMBER 8 2 YES Actual amount for the expense code for the Function
Expense.
GERFEXP_EXPENSE_DATE DATE 7 YES Date the expense occurred.
Date: 21-JUN-2004 Page: 7
TABLE: GERFFEE
CREATOR: GENERAL
Function Fee Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GERFFEE_EVNT_CRN VARCHAR2 5 NO Function Fee Event CRN.
GERFFEE_FUNC_CODE VARCHAR2 12 NO Function Fee Function Code.
GERFFEE_FTYP_CODE VARCHAR2 6 NO Function Fee Type Code.
GERFFEE_RATE_CODE VARCHAR2 6 NO Function Fee Rate Code.
GERFFEE_AMT NUMBER 7 2 NO Function Fee Amount.
GERFFEE_ACTIVITY_DATE DATE 7 NO Function Fee Activity Date.
Date: 21-JUN-2004 Page: 8
TABLE: GERFGST
CREATOR: GENERAL
Event Function Guest Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GERFGST_EVNT_CRN VARCHAR2 5 NO Event associated with the function.
GERFGST_FUNC_CODE VARCHAR2 12 NO Code for the Function.
GERFGST_PIDM NUMBER 8 NO PIDM of Invitee.
GERFGST_GUEST_PIDM NUMBER 8 NO Guest PIDM of the Invittee.
GERFGST_ACTIVITY_DATE DATE 7 NO Date on which the record was added or last changed.
Date: 21-JUN-2004 Page: 9
TABLE: GERFREV
CREATOR: GENERAL
Function Revenue Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GERFREV_EVNT_CRN VARCHAR2 5 NO Event associated with the function.
GERFREV_FUNC_CODE VARCHAR2 12 NO Function Code.
GERFREV_REVN_CODE VARCHAR2 2 NO Revenue Code associated with the Function Revenue.
GERFREV_ACTIVITY_DATE DATE 7 NO Date the Revenue Code was added or last changed.
GERFREV_BUDGET_AMT NUMBER 8 2 YES Budgeted amount for the revenue code for the Function
Revenue.
GERFREV_ACTUAL_AMT NUMBER 8 2 YES Actual amount for the revenue code for the Function
Revenue.
GERFREV_REVENUE_DATE DATE 7 YES
Date: 21-JUN-2004 Page: 10
TABLE: GERMENU
CREATOR: GENERAL
Function Menu Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GERMENU_EVNT_CRN VARCHAR2 5 NO Function Menu Event CRN.
GERMENU_FUNC_CODE VARCHAR2 12 NO Function Menu Function Code.
GERMENU_MENU_CODE VARCHAR2 10 NO Function Menu Code.
GERMENU_ACTIVITY_DATE DATE 7 YES Function Menu Activity Date.
Date: 21-JUN-2004 Page: 11
TABLE: GERPART
CREATOR: GENERAL
Function Participant Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GERPART_EVNT_CRN VARCHAR2 5 NO Function Participant Event CRN.
GERPART_FUNC_CODE VARCHAR2 12 NO Function Participant Function Code.
GERPART_PIDM NUMBER 8 NO PIDM of the Function Participant.
GERPART_PTYP_CODE VARCHAR2 5 NO Function Participant Type Code.
GERPART_ACTIVITY_DATE DATE 7 NO Function Participant Activity Date.
GERPART_ATYP_CODE VARCHAR2 2 YES Address Type of the Function Participant.
GERPART_DATE DATE 7 YES Function Participant Date of participation.
GERPART_RTNG_CODE VARCHAR2 2 YES Function Participant Rating Code.
GERPART_COMMENT LONG YES Function Participant Comment.
GERPART_CONTACT_IND VARCHAR2 1 YES Function Participant Contact Indicator; P - Primary, L
- Location.
Date: 21-JUN-2004 Page: 12
TABLE: GERSUBJ
CREATOR: GENERAL
Function Subject Comment Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GERSUBJ_EVNT_CRN VARCHAR2 5 NO Event associated with the subject.
GERSUBJ_FUNC_CODE VARCHAR2 12 NO Function Code associated with the comment.
GERSUBJ_SUBJ_CODE VARCHAR2 6 NO Subject Code.
GERSUBJ_GRP_SEQ_NO NUMBER 23 20 NO Group sequence number.
GERSUBJ_ACTIVITY_DATE DATE 7 NO Date function comment was last created or modified.
Date: 21-JUN-2004 Page: 13
TABLE: GERTASK
CREATOR: GENERAL
Function Task Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GERTASK_EVNT_CRN VARCHAR2 5 NO Event associated with the task.
GERTASK_FUNC_CODE VARCHAR2 12 NO Function Code associated with the task.
GERTASK_TASK_CODE VARCHAR2 10 NO Task Code.
GERTASK_ACTIVITY_DATE DATE 7 NO Date task was last created or modified.
GERTASK_TTYP_CODE VARCHAR2 5 YES Task Type Code.
GERTASK_MESSAGE_IND VARCHAR2 1 YES Indicator for whether message was sent.
GERTASK_MESSAGE_RECIPIENT VARCHAR2 15 YES Recipient for message regarding task.
GERTASK_MESSAGE_DATE DATE 7 YES Date message was sent.
GERTASK_TSTA_CODE VARCHAR2 6 YES Task Status Code.
GERTASK_TSTA_DATE DATE 7 YES Date status was updated.
GERTASK_TARGET_COMPL_DATE DATE 7 YES Target Date by which task is to be completed.
GERTASK_BEGIN_DATE DATE 7 YES Date task is started.
GERTASK_END_DATE DATE 7 YES Date task is finished.
GERTASK_START_TIME VARCHAR2 4 YES Time task is to be started.
GERTASK_END_TIME VARCHAR2 4 YES Time task is to be finished.
GERTASK_COMMENT VARCHAR2 180 YES Comment describing action required for task.
Date: 21-JUN-2004 Page: 14
TABLE: GERTKID
CREATOR: GENERAL
Function Task Associated ID Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GERTKID_EVNT_CRN VARCHAR2 5 NO Event associated with the task.
GERTKID_FUNC_CODE VARCHAR2 12 NO Function Code associated with the task.
GERTKID_TASK_CODE VARCHAR2 10 NO Task Code.
GERTKID_ACTIVITY_DATE DATE 7 NO Date task ID assignment was last created or modified.
GERTKID_PIDM NUMBER 8 YES Internal system generated number associated with the
person asssigned to the task.
GERTKID_COMMENT VARCHAR2 240 YES Comment associated with the person assigned to the
task.
Date: 21-JUN-2004 Page: 15
TABLE: GJBCOLR
CREATOR: GENERAL
Jobs Parameter Collector Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBCOLR_JOB VARCHAR2 30 NO JOB: Job name used along with One Up Number and Number
to uniquely identify records.
GJBCOLR_ONE_UP_NO NUMBER NO ONE UP NO: Sequence number used along with Job and
Number to uniquely identify records.
GJBCOLR_NUMBER VARCHAR2 2 NO NUMBER: Parameter number used along with Job and One
Up Number to uniquely identify records.
GJBCOLR_VALUE VARCHAR2 30 NO VALUE: Actual value being stored for this parameter.
GJBCOLR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Actual date this record was created.
GJBCOLR_MISC_VALUE VARCHAR2 30 YES MISCELLANEOUS VALUE: Miscellaneous field for optional
use.
Date: 21-JUN-2004 Page: 16
TABLE: GJBJOBS
CREATOR: GENERAL
Report/Process Definition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBJOBS_NAME VARCHAR2 30 NO NAME: Name of the executable, procedure or report.
GJBJOBS_TITLE VARCHAR2 30 NO TITLE: Title or description of the executable,
procedure or report.
GJBJOBS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date record was created or last
modified.
GJBJOBS_SYSI_CODE VARCHAR2 2 YES SYSTEM INDICATOR: Indicator which identifies the
Banner System to which this executable, procedure or
report belongs.
GJBJOBS_JOB_TYPE_IND VARCHAR2 1 YES JOB TYPE INDICATOR: Indicator to identify whether this
is an (E)xecutable, (P)rocedure or (R)eport.
GJBJOBS_DESC VARCHAR2 240 YES DESCRIPTION: Long description of executable, procedure
or report.
GJBJOBS_COMMAND_NAME VARCHAR2 30 YES COMMAND NAME: Alternate procedure name to be run.
GJBJOBS_PRNT_FORM VARCHAR2 30 YES STOCK PAPER: Default paper stock to be used.
GJBJOBS_PRNT_CODE VARCHAR2 30 YES PRINTER CODE: Default printer code assigned to this
executable, procedure or report.
GJBJOBS_LINE_COUNT NUMBER 3 YES LINE COUNT: Default number of print lines per page for
this executable, procedure, or report.
GJBJOBS_VALIDATION VARCHAR2 30 YES VALIDATION: Process level validation label to executed
when submitting job through the Job Submission system.
Date: 21-JUN-2004 Page: 17
TABLE: GJBPDEF
CREATOR: GENERAL
Jobs Parameter Definition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBPDEF_JOB VARCHAR2 30 NO JOB: Name of executable, procedure or report.
GJBPDEF_NUMBER VARCHAR2 2 NO NUMBER: Parameter number for this job.
GJBPDEF_DESC VARCHAR2 30 NO DESCRIPTION: Description of parameter.
GJBPDEF_LENGTH NUMBER 2 NO LENGTH: Length of the defined parameter.
GJBPDEF_TYPE_IND VARCHAR2 1 NO TYPE INDICATOR: Indicator to identify parameter type
of (C)haracter, (D)ate, (I)nteger or (N)umber.
GJBPDEF_OPTIONAL_IND VARCHAR2 1 NO OPTIONAL INDICATOR: Indicator to identify whether or
not this parameter is (O)ptional or (R)equired.
GJBPDEF_SINGLE_IND VARCHAR2 1 NO SINGLE INDICATOR: Indicator to identify whether or not
this parameter occurs (S)ingle or (M)ultiple times.
GJBPDEF_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date this parameter was created or last
modified.
GJBPDEF_LOW_RANGE VARCHAR2 30 YES LOW RANGE: Specifies the low range boundry for this
parameter.
GJBPDEF_HIGH_RANGE VARCHAR2 30 YES LOW RANGE: Specifies the high range boundry for this
parameter.
GJBPDEF_HELP_TEXT VARCHAR2 78 YES HELP TEXT: Long description of parameter.
GJBPDEF_VALIDATION VARCHAR2 30 YES VALIDATION: Parameter level validation label to be
performed when job is submitted through the Job
Submission system.
GJBPDEF_LIST_VALUES VARCHAR2 30 YES LIST VALUES: Name of form to call for List of Values
for this parameter.
Date: 21-JUN-2004 Page: 18
TABLE: GJBPDFT
CREATOR: GENERAL
Default Parameter Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBPDFT_JOB VARCHAR2 30 NO JOB: Name of executable, procedure or report
associated with this parameter default.
GJBPDFT_NUMBER VARCHAR2 2 NO NUMBER: Parameter number associated with this default.
GJBPDFT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date default value was created or last
modified.
GJBPDFT_USER_ID VARCHAR2 30 YES USER ID: User ID associated with this default. NULL
values represent system level defaults.
GJBPDFT_VALUE VARCHAR2 30 YES VALUE: Default value for this parameter.
GJBPDFT_JPRM_CODE VARCHAR2 15 YES Job Parameter Set Code.
Date: 21-JUN-2004 Page: 19
TABLE: GJBPRUN
CREATOR: GENERAL
Process Run Parameter Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBPRUN_JOB VARCHAR2 30 NO JOB: Job name used along with One Up Number and Number
to identify the parameters.
GJBPRUN_ONE_UP_NO NUMBER NO ONE UP NO: Sequence number used along with Job and
Number to identify the parameters.
GJBPRUN_NUMBER VARCHAR2 2 NO NUMBER: Parameter Number used along with Job and One
Up Number to identify the parameters.
GJBPRUN_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of record creation.
GJBPRUN_VALUE VARCHAR2 30 YES VALUE: Value of parameter.
GJBPRUN_LABEL VARCHAR2 60 YES GJBPRUN_LABEL: The gjbprun_label column contains the
name of a variable that will be prompted for when
glblsel or glbdata is run. This value is only filled
in from the gjapctl form
Date: 21-JUN-2004 Page: 20
SEQUENCE: GJBPSEQ
CREATOR: GENERAL
===================================================================================================================
Minimum Value: 1
Maximum Value: 99999999
Increment: 1
Last Number: 356457
Cache Size: 30
Order Option: NOT ORDERED
Cycle Option: CYCLE
Date: 21-JUN-2004 Page: 21
TABLE: GJBPVAL
CREATOR: GENERAL
General Jobs Parameter Value Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBPVAL_JOB VARCHAR2 30 NO JOB: Job name of executable, procedure or report.
GJBPVAL_NUMBER VARCHAR2 2 NO NUMBER: Parameter number associated with this job.
GJBPVAL_VALUE VARCHAR2 30 NO VALUE: Validation value associated with this
parameter.
GJBPVAL_DESC VARCHAR2 30 NO DESCRIPTION: Description of this validation value.
GJBPVAL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date record was created or last
modified.
Date: 21-JUN-2004 Page: 22
TABLE: GJBRSLT
CREATOR: GENERAL
External Process Results Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJBRSLT_JOB VARCHAR2 30 NO JOB ID: Name of executable, procedure or report that
was executed
GJBRSLT_ONE_UP_NO NUMBER NO ONE UP NO: System generated sequence number for each
execution of any process
GJBRSLT_USER_ID VARCHAR2 30 NO USER ID: User id of the user executing the process
GJBRSLT_STATUS_IND VARCHAR2 1 YES STATUS INDICATOR: Final status of procedure, either
(F)ailed or (S)uccess
GJBRSLT_MESSAGE VARCHAR2 60 YES MESSAGE: Any message text to be passed or returned to
calling process
GJBRSLT_ACTIVITY_DATE DATE 7 YES ACTIVITY DATE: Date the process was executed
Date: 21-JUN-2004 Page: 23
TABLE: GJRJPRM
CREATOR: GENERAL
Job Parameter Set Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJRJPRM_JOB VARCHAR2 30 NO JOB: Name of Process being run.
GJRJPRM_CODE VARCHAR2 15 NO Job Parameter Set Code.
GJRJPRM_DESC VARCHAR2 30 NO Job Parameter Set Description
GJRJPRM_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last modification to the
record.
Date: 21-JUN-2004 Page: 24
TABLE: GJRSWPT
CREATOR: GENERAL
GJRSWPT: This table contains information about jobs running in sleep/wake mode.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GJRSWPT_SESSION_ID NUMBER NO
GJRSWPT_PROCESS VARCHAR2 30 NO Process running is sleep/wake mode.
GJRSWPT_PRINTER VARCHAR2 30 NO Printer associated with this process.
GJRSWPT_CURRENT_INTERVAL NUMBER 6 NO Amount of time (seconds) for this sleep/wake cycle.
GJRSWPT_NEXT_INTERVAL NUMBER 6 NO Amount of time (seconds) for the next sleep/wake
cycle.
GJRSWPT_LAST_EXECUTION DATE 7 YES Last time this process executed.
GJRSWPT_NEXT_EXECUTION DATE 7 YES Next time this process will execute.
GJRSWPT_ERROR_IND VARCHAR2 1 YES Indicates whether or not the process has terminated
because of an error.
GJRSWPT_INTERVAL_COUNT NUMBER 9 YES Number of items processed last cycle.
GJRSWPT_CUMULATIVE_COUNT NUMBER 9 YES Number of items processed for all cycles from the last
time started.
GJRSWPT_CONTINUE_IND VARCHAR2 1 YES Y indicates the process should continue to cycle, N
indicates the process should stop executing when it
next wakes.
GJRSWPT_ACTIVITY_DATE DATE 7 NO Last time this row was inserted or updated.
Date: 21-JUN-2004 Page: 25
TABLE: GLBAPPL
CREATOR: GENERAL
Letter Generation Application Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GLBAPPL_APPLICATION VARCHAR2 30 NO APPLICATION: Application code which uniquely
identifies this record.
GLBAPPL_DESC VARCHAR2 30 NO DESCRIPTION: Description of this application.
GLBAPPL_SYSI_CODE VARCHAR2 2 NO SYSTEM INDICATOR: System indicator which identifies
which system this application is associated.
GLBAPPL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date that record was created or last
updated.
Date: 21-JUN-2004 Page: 26
TABLE: GLBEXTR
CREATOR: GENERAL
Population Selection Extract Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GLBEXTR_APPLICATION VARCHAR2 30 NO APPLICATION: The name of the Application that the
Population Selection Identifier belongs to.
GLBEXTR_SELECTION VARCHAR2 30 NO SELECTION: The name of the Population Selection
Identifier that was used to create this Report Extract
record.
GLBEXTR_CREATOR_ID VARCHAR2 30 NO CREATOR ID: The ID of the creator of this Population
Selection Identifier.
GLBEXTR_USER_ID VARCHAR2 30 NO USER ID: The logon ID of the user who entered or last
updated the record in this table.
GLBEXTR_KEY VARCHAR2 80 NO
GLBEXTR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated
GLBEXTR_SYS_IND VARCHAR2 1 NO SYSTEM INDICATOR: Indicates source of the record.
Values are (S)ystem-generated by the GLBDATA process;
(M)anually entered on the GLAEXTR form.
GLBEXTR_SLCT_IND VARCHAR2 1 YES SELECT INDICATOR: This field is used by the Batch
Group Process and indicates whether the student has
been processed already.
Date: 21-JUN-2004 Page: 27
TABLE: GLBOBJT
CREATOR: GENERAL
Letter Generation Object Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GLBOBJT_OBJECT VARCHAR2 30 NO OBJECT: Object code which uniquely identifies this
record.
GLBOBJT_DESC VARCHAR2 30 NO DESCRIPTION: Description of this object.
GLBOBJT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date that record was created or last
updated.
Date: 21-JUN-2004 Page: 28
TABLE: GLBSLCT
CREATOR: GENERAL
Population Selection Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GLBSLCT_APPLICATION VARCHAR2 30 NO APPLICATION: Application code which with the selectino
code uniquely identifies this record.
GLBSLCT_SELECTION VARCHAR2 30 NO SELECTION: Selection code which with the application
code uniquely identifies this record.
GLBSLCT_CREATOR_ID VARCHAR2 30 NO CREATOR ID: The user id of the person who created this
population selection.
GLBSLCT_DESC VARCHAR2 30 NO DESCRIPTION: Description of this population selection.
GLBSLCT_LOCK_IND VARCHAR2 1 NO LOCK INDICATOR: Indicator which indicates that this
population selection is locked and cannot be
executedby any other user.
GLBSLCT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date that record was created or last
updated.
GLBSLCT_TYPE_IND VARCHAR2 1 YES SELECTION TYPE: Values are (M)anual PIDM joins
required on form - GLOLETT will not add them, or
blank.
Date: 21-JUN-2004 Page: 29
TABLE: GLBVRBL
CREATOR: GENERAL
Letter Generation Variable Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GLBVRBL_APPLICATION VARCHAR2 30 NO APPLICATION: Application code which with the variable
uniquely identifies this record.
GLBVRBL_VARIABLE VARCHAR2 30 NO VARIABLE: Variable code which with the application
uniquely identifies this record.
GLBVRBL_DESC VARCHAR2 30 NO DESCRIPTION: Description of this variable.
GLBVRBL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date that record was created or last
updated.
GLBVRBL_TYPE_IND VARCHAR2 1 YES VARIABLE TYPE: Values are (C)hecklist, (S)ignature,
(M)anual PIDM joins required on form - GLOLETT will
not add them, (F)irst variable to be processed by
GLBLSEL, or blank.
Date: 21-JUN-2004 Page: 30
TABLE: GLRAPPL
CREATOR: GENERAL
Letter Generation Application Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GLRAPPL_APPLICATION VARCHAR2 30 NO APPLICATION: The application code that uniquely
identifies this Selection Identifier.
GLRAPPL_KEY_NO NUMBER 4 NO SEQUENCE NUMBER: The internal number that uniquely
identifies this line of the Selection Identifier.
GLRAPPL_LINE_NO NUMBER 4 NO LINE NUMBER: The internal line number for ordering of
the records.
GLRAPPL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated
GLRAPPL_DATA_ELEMENT VARCHAR2 35 NO DATA ELEMENT: The name of the database column that is
referenced in this Selection condition.
GLRAPPL_OPERATOR VARCHAR2 11 NO OPERATOR: The SQL operator used to link the Data
Element and the Value. Valid values are =, >=, <=, >,
<, IN, NOT IN, LIKE, NOT LIKE, BETWEEN, NOT BETWEEN,
IS NULL, IS NOT NULL, ANY, and ALL.
GLRAPPL_VALUE VARCHAR2 80 YES VALUE: The value that is compared to the Data Element
based on the Operator. Note that when the Operator
contains IS NULL or IS NOT NULL, a value is not
allowed. The value must conform to standard SQL
character and date formats.
GLRAPPL_OPEN_PAREN VARCHAR2 3 YES OPEN PARENTHESIS: This field may contain an open
parenthesis "(" if nested conditions are used within
this Selection Identifier. Note that the count of
open parens must equal the count of close parens in
the Selection Identifier.
GLRAPPL_CLOSE_PAREN VARCHAR2 3 YES CLOSE PARENTHESIS: This field may contain a close
parenthesis ")" if nested conditions are used within
this Selection Identifier. Note that the count of
close parens must equal the count of open parens in
the Selection Identifier.
GLRAPPL_SEPARATOR VARCHAR2 3 YES SEPARATOR: The separator between multiple lines in a
Selection Identifier. Valid values are AND and OR.
Note that all lines in a Selection Identifier, except
for the last, must contain a Separator.
Date: 21-JUN-2004 Page: 31
TABLE: GLRCALC
CREATOR: GENERAL
Letter Generation Calculation Collector Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GLRCALC_APPLICATION VARCHAR2 30 NO APPLICATION: The name of the Letter Generation
Application related to this Collector record.
GLRCALC_LETR_CODE VARCHAR2 15 NO LETTER CODE: The code designating the Letter
associated with this Collector record.
GLRCALC_VARIABLE VARCHAR2 30 NO VARIABLE: The name of the Letter Generation Variable
related to this Collector record.
GLRCALC_PIDM NUMBER 8 NO PIDM: The internal system student identification
number.
GLRCALC_ROWNUM NUMBER 8 NO ROW NUMBER: The internal number uniquely identifying
this Collector record.
GLRCALC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated
GLRCALC_AMT01 NUMBER 11 2 YES AMOUNT 1: Amount used for mathematical calculations in
Letter Generation.
GLRCALC_AMT02 NUMBER 11 2 YES AMOUNT 2: Amount used for mathematical calculations in
Letter Generation.
GLRCALC_AMT03 NUMBER 11 2 YES AMOUNT 3: Amount used for mathematical calculations in
Letter Generation.
GLRCALC_AMT04 NUMBER 11 2 YES AMOUNT 4: Amount used for mathematical calculations in
Letter Generation.
GLRCALC_AMT05 NUMBER 11 2 YES AMOUNT 5: Amount used for mathematical calculations in
Letter Generation.
GLRCALC_AMT06 NUMBER 11 2 YES AMOUNT 6: Amount used for mathematical calculations in
Letter Generation.
GLRCALC_AMT07 NUMBER 11 2 YES AMOUNT 7: Amount used in mathematical calculations in
Letter Generation.
GLRCALC_AMT08 NUMBER 11 2 YES AMOUNT 8: Amount used in mathematical calculations in
Letter Generation.
GLRCALC_AMT09 NUMBER 11 2 YES AMOUNT 9: Amount used in mathematical calculations in
Letter Generation.
GLRCALC_AMT10 NUMBER 11 2 YES AMOUNT 10: Amount used for mathematical calculations
in Letter Generation.
GLRCALC_AMT11 NUMBER 11 2 YES AMOUNT 11: Amount used for mathematical calculations
in Letter Generation.
GLRCALC_AMT12 NUMBER 11 2 YES AMOUNT 12: Amount used for mathematical calculations
in Letter Generation.
GLRCALC_AMT13 NUMBER 11 2 YES AMOUNT 13: Amount used for mathematical calculations
in Letter Generation.
GLRCALC_AMT14 NUMBER 11 2 YES AMOUNT 14: Amount used for mathematical calculations
in Letter Generation.
GLRCALC_AMT15 NUMBER 11 2 YES AMOUNT 15: Amount used for mathematical calculations
in Letter Generation.
GLRCALC_AMT16 NUMBER 11 2 YES AMOUNT 16: Amount used for mathematical calculations
in Letter Generation.
Date: 21-JUN-2004 Page: 32
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GLRCALC_AMT17 NUMBER 11 2 YES AMOUNT 17: Amount used for mathematical calculations
in Letter Generation.
GLRCALC_AMT18 NUMBER 11 2 YES AMOUNT 18: Amount used for mathematical calculations
in Letter Generation.
GLRCALC_AMT19 NUMBER 11 2 YES AMOUNT 19: Amount used for mathematical calculations
in Letter Generation.
GLRCALC_AMT20 NUMBER 11 2 YES AMOUNT 20: Amount used for mathematical calculations
in Letter Generation.
Date: 21-JUN-2004 Page: 33
TABLE: GLRCMPL
CREATOR: GENERAL
Selection Identifier Compiled Statements
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GLRCMPL_APPLICATION VARCHAR2 30 NO APPLICATION: The application code used to uniquely
identify this Compiled SQL Statement
GLRCMPL_VRBL_OR_SLCT VARCHAR2 30 NO VARIABLE or SELECTION: The variable/selection code
used to uniquely identify this Compiled SQL Statement
GLRCMPL_CREATOR_ID VARCHAR2 30 NO CREATOR ID: User ID of the creator of the population
selection or last to modify the variable
GLRCMPL_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: The internal sequence number of this
Compiled SQL Statement.
GLRCMPL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
GLRCMPL_SUB_SEQ_NO NUMBER 6 YES SUBORDINATE SEQUENCE NUMBER: An internal sequence
number, used by the Letter Generation process as a
subordinate sequence to the GLRCMPL_SEQ_NO sequence
number.
GLRCMPL_SQL_LENGTH NUMBER 5 YES SQL STATEMENT LENGTH: The length (in characters) of
the Compiled SQL Statement
GLRCMPL_SQL_STATEMENT LONG YES APPLICATION INDICATOR: This indicator is set if this
record is the application level rules portion of an
SPVADDS-related variable.
GLRCMPL_SQL_PARMS VARCHAR2 240 YES SQL PARAMETERS: Internal parameters that are used in
the Letter Generation, Report Extract and Group
Assignment processes.
GLRCMPL_FROM_WHERE_SEP NUMBER 4 YES FROM/WHERE SEPARATOR: The location within the
GLRCMPL_SQL_STATEMENT between the end of the FROM
clause and the start of the WHERE clause. This is
needed for string manipulation within the GLBLSEL
program.
GLRCMPL_JOIN_TABLE VARCHAR2 30 YES JOIN TABLE: The table which will be joined (by PIDM)
to the GLRCOLR table in the GLBLSEL program. It is
usually the table containing the SELECTed column in
the variable (GLRVRBL form), and always the first
table in the FROM clause.
GLRCMPL_ADDS_IND VARCHAR2 1 YES ADDRESS VIEW INDICATOR: This indicator is set if the
address view is referenced by a variable.
GLRCMPL_APPL_IND VARCHAR2 1 YES SQL STATEMENT: The text of the Compiled SQL Statement.
Date: 21-JUN-2004 Page: 34
TABLE: GLRCOLR
CREATOR: GENERAL
Letter Generation Collector Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GLRCOLR_APPLICATION VARCHAR2 30 NO APPLICATION: The application designating the variables
associated with this collector record.
GLRCOLR_LETR_CODE VARCHAR2 15 NO LETTER CODE: The code designating the Letter
associated with this Collector record.
GLRCOLR_PIDM NUMBER 8 NO PIDM: The internal system student identification
number.
GLRCOLR_VARIABLE VARCHAR2 30 NO VARIABLE: The name of the Letter Generation variable
associated with this Collector record.
GLRCOLR_SEQ_NO NUMBER 6 NO SEQUENCE NUMBER: The internal sequence number of this
Collector record.
GLRCOLR_ROWNUM NUMBER 6 NO ROW NUMBER: The internal number uniquely identifying
this Collector record.
GLRCOLR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated
GLRCOLR_RESULT VARCHAR2 2000 YES RESULT: The result of the query that is performed
which is related to the Letter Generation variable in
this Collector record.
GLRCOLR_KEY VARCHAR2 240 YES A record key value associated with this variable (ex:
a PIDM value or initials to be used in updating
GURMAIL_INIT_CODE),
Date: 21-JUN-2004 Page: 35
TABLE: GLROBJT
CREATOR: GENERAL
Letter Generation Object Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GLROBJT_OBJECT VARCHAR2 30 NO OBJECT: The object code that uniquely identifies this
Selection Identifier.
GLROBJT_KEY_NO NUMBER 4 NO SEQUENCE NUMBER: The internal number that uniquely
identifies this line of the Selection Identifier.
GLROBJT_LINE_NO NUMBER 4 NO LINE NUMBER: The internal line number for ordering of
the records.
GLROBJT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated
GLROBJT_DATA_ELEMENT VARCHAR2 35 NO DATA ELEMENT: The name of the database column that is
referenced in this Selection condition.
GLROBJT_OPERATOR VARCHAR2 11 NO OPERATOR: The SQL operator used to link the Data
Element and the Value. Valid values are =, >=, <=, >,
<, IN, NOT IN, LIKE, NOT LIKE, BETWEEN, NOT BETWEEN,
IS NULL, IS NOT NULL, ANY, and ALL.
GLROBJT_VALUE VARCHAR2 80 YES VALUE: The value that is compared to the Data Element
based on the Operator. Note that when the Operator
contains IS NULL or IS NOT NULL, a value is not
allowed. The value must conform to standard SQL
character and date formats.
GLROBJT_OPEN_PAREN VARCHAR2 3 YES OPEN PARENTHESIS: This field may contain an open
parenthesis "(" if nested conditions are used within
this Selection Identifier. Note that the count of
open parens must equal the count of close parens in
the Selection Identifier.
GLROBJT_CLOSE_PAREN VARCHAR2 3 YES CLOSE PARENTHESIS: This field may contain a close
parenthesis ")" if nested conditions are used within
this Selection Identifier. Note that the count of
close parens must equal the count of open parens in
the Selection Identifier.
GLROBJT_SEPARATOR VARCHAR2 3 YES SEPARATOR: The separator between multiple lines in a
Selection Identifier. Valid values are AND and OR.
Note that all lines in a Selection Identifier, except
for the last, must contain a Separator.
Date: 21-JUN-2004 Page: 36
TABLE: GLRORDR
CREATOR: GENERAL
Letter Generation Order Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GLRORDR_APPLICATION VARCHAR2 30 NO APPLICATION: The name of the Letter Generation
Application associated with this Order record.
GLRORDR_LETR_CODE VARCHAR2 15 NO LETTER CODE: The code designating the Letter
associated with this Order record.
GLRORDR_SEQ_NO NUMBER 6 NO SEQUENCE NUMBER: The internal sequence number that
uniquely identifies this Order record.
GLRORDR_VARIABLE VARCHAR2 30 NO VARIABLE: The name of the Letter Generation Variable
associated with this Order record.
GLRORDR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record in the table was entered or last updated.
GLRORDR_SPVADDS VARCHAR2 1 YES
Date: 21-JUN-2004 Page: 37
TABLE: GLRSFRM
CREATOR: GENERAL
Population Selection Select Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GLRSFRM_APPLICATION VARCHAR2 30 NO APPLICATION: Application code which with the selection
and creator id uniquely identifies this record.
GLRSFRM_SELECTION VARCHAR2 30 NO SELECTION: Population Selection code which with the
application and creator id uniquely identifies this
record.
GLRSFRM_CREATOR_ID VARCHAR2 30 NO CREATOR_ID: User id of the creator of this population
selection which with the application and selection
uniquely identifies this record.
GLRSFRM_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date that record was created or last
updated.
GLRSFRM_SELECT_CLAUSE VARCHAR2 240 NO SELECT CLAUSE: The "SELECT" part of the population
selection; what is to be selected.
GLRSFRM_FROM_CLAUSE VARCHAR2 240 NO FROM CLAUSE: The "FROM" part of the population
selection; from which tables should the select be
performed.
GLRSFRM_ORDER_BY VARCHAR2 240 YES ORDER BY: The "ORDER BY" part of the population
selection; in which order should the values selected
by ordered.
GLRSFRM_GROUP_BY VARCHAR2 240 YES GROUP BY: The "GROUP BY" part of the population
selection; in which way should the values selected by
grouped.
Date: 21-JUN-2004 Page: 38
TABLE: GLRSLCT
CREATOR: GENERAL
Population Selection Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GLRSLCT_APPLICATION VARCHAR2 30 NO APPLICATION: Application code which with the
selection, creator id and key number uniquely
identifies this record.
GLRSLCT_SELECTION VARCHAR2 30 NO SELECTION: Selection code which with the application,
creator id and key number uniquely identifies this
record.
GLRSLCT_CREATOR_ID VARCHAR2 30 NO CREATOR_ID: User id of the creator which with the
application, selection and key number uniquely
identifies this record.
GLRSLCT_KEY_NO NUMBER 4 NO KEY NUMBER: Key number which with the application,
selection and creator id uniquely identifies this
record.
GLRSLCT_LINE_NO NUMBER 4 NO LINE NUMBER: Line number which is used for sorting or
ordering of the rules.
GLRSLCT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date that record was created or last
updated.
GLRSLCT_DATA_ELEMENT VARCHAR2 35 NO DATA ELEMENT: Database column name to be used as part
of the rules statement.
GLRSLCT_OPERATOR VARCHAR2 11 NO OPERATOR: The operator (=, <, >, etc.) to be used as
part of the rules statement.
GLRSLCT_VALUE VARCHAR2 80 YES VALUE: The value to be compared (literal text, date
value, number, another column or a subquery) as part
of the rules statement.
GLRSLCT_OPEN_PAREN VARCHAR2 3 YES OPEN PARENTHESIS: The open parenthesis "(" to be used
as part of the rules.
GLRSLCT_CLOSE_PAREN VARCHAR2 3 YES CLOSE PARENTHESIS: The close parenthesis ")" to be
used as part of the rules.
GLRSLCT_SEPARATOR VARCHAR2 3 YES SEPARATOR: The AND or OR to be used as part of the
rules.
Date: 21-JUN-2004 Page: 39
TABLE: GLRVFRM
CREATOR: GENERAL
Letter Generation Variable Select Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GLRVFRM_APPLICATION VARCHAR2 30 NO APPLICATION: Application code which with the variable
and the sequence number uniquely identifies this
record.
GLRVFRM_VARIABLE VARCHAR2 30 NO VARIABLE: Variable code which with the application and
the sequence number uniquely identifies this record.
GLRVFRM_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: Sequence number which with the
application and variable uniquely identifies this
record.
GLRVFRM_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date that record was created or last
updated.
GLRVFRM_SELECT_CLAUSE VARCHAR2 240 NO SELECT CLAUSE: The "SELECT" part of the variable; what
is to be selected.
GLRVFRM_FROM_CLAUSE VARCHAR2 240 NO FROM CLAUSE: The "FROM" part of the variable; from
which tables should the select be performed.
GLRVFRM_ORDER_BY VARCHAR2 240 YES ORDER BY: The "ORDER BY" part of the variable; in
which order should the values selected by ordered.
GLRVFRM_GROUP_BY VARCHAR2 240 YES GROUP BY: The "GROUP BY" part of the variable; in
which way should the values selected by grouped.
GLRVFRM_DESC VARCHAR2 80 YES DESCRIPTION: The description associated with each
sequence number.
Date: 21-JUN-2004 Page: 40
TABLE: GLRVRBL
CREATOR: GENERAL
Letter Generation Variable Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GLRVRBL_APPLICATION VARCHAR2 30 NO APPLICATION: Application code which with the variable,
sequence number and key number uniquely identifies
this record.
GLRVRBL_VARIABLE VARCHAR2 30 NO VARIABLE: Variable code which with the application,
sequence number and key number uniquely identifies
this record.
GLRVRBL_SEQ_NO NUMBER 3 NO SEQUENCE_NUMBER: Sequence number which with the
application, variable and key number uniquely
identifies this record.
GLRVRBL_KEY_NO NUMBER 4 NO KEY NUMBER: Key number which with the application,
variable and sequence number uniquely identifies this
record.
GLRVRBL_LINE_NO NUMBER 4 NO LINE NUMBER: Line number which is used for sorting or
ordering of the rules.
GLRVRBL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date that record was created or last
updated.
GLRVRBL_DATA_ELEMENT VARCHAR2 35 NO DATA ELEMENT: Database column name to be used as part
of the rules statement.
GLRVRBL_OPERATOR VARCHAR2 11 NO OPERATOR: The operator (=, <, >, etc.) to be used as
part of the rules statement.
GLRVRBL_VALUE VARCHAR2 80 YES VALUE: The value to be compared (literal text, date
value, number, another column or a subquery) as part
of the rules statement.
GLRVRBL_OPEN_PAREN VARCHAR2 3 YES OPEN PARENTHESIS: The open parenthesis "(" to be used
as part of the rules.
GLRVRBL_CLOSE_PAREN VARCHAR2 3 YES CLOSE PARENTHESIS: The close parenthesis ")" to be
used as part of the rules.
GLRVRBL_SEPARATOR VARCHAR2 3 YES SEPARATOR: The AND or OR to be used as part of the
rules.
Date: 21-JUN-2004 Page: 41
TABLE: GOBBACR
CREATOR: GENERAL
Access Rule Base
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBBACR_SEQNO NUMBER 8 NO Access Rule Sequence Number
GOBBACR_VOBJ_CODE VARCHAR2 15 NO VBS Object Code
GOBBACR_ACTIVE_IND VARCHAR2 1 NO Access Rule Active Indicator
GOBBACR_EFF_DATE DATE 7 NO Access Rule Effective Date
GOBBACR_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
GOBBACR_PATTERN_CTRL NUMBER 4 YES Access Rule Secured Item Pattern Control
GOBBACR_ACCESS_CNT NUMBER 4 YES Access Group Association Cummulative Count
GOBBACR_EXPIRE_DATE DATE 7 YES Access Rule Expiration Date
Date: 21-JUN-2004 Page: 42
TABLE: GOBDIRO
CREATOR: GENERAL
Directory Options Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBDIRO_DIRO_CODE VARCHAR2 8 NO DIRECTORY CODE: Code for Directory Item.
GOBDIRO_DIRECTORY_TYPE VARCHAR2 1 NO DIRECTORY TYPE INDICATOR: Indicator to print in
(S)tudent, (E)mployee, or (A)ll Directories.
GOBDIRO_ITEM_TYPE VARCHAR2 1 NO DIRECTORY ITEM TYPE INDICATOR: Indicator for Item
Type; (A)ddress, (T)elephone, or (N)ot Applicable.
GOBDIRO_DISP_PROFILE_IND VARCHAR2 1 NO INCLUDE IN DIRECTORY INDICATOR: Indicator to display
in Directory; (Y)es or (N)o.
GOBDIRO_UPD_PROFILE_IND VARCHAR2 1 NO DISPLAY IN DIRECTORY INDICATOR: Indicator to allow
User to choose to display in directory; (Y)es or (N)o.
GOBDIRO_NON_PROFILE_DEF_IND VARCHAR2 1 NO DEFAULT INDICATOR: Indicator to default to directory
for users without a directory profile; (Y)es or (N)o.
GOBDIRO_SYSTEM_REQ_IND VARCHAR2 1 NO SYSTEM REQUIRED INDICATOR: System Required Indicator.
GOBDIRO_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity on this record.
GOBDIRO_SEQ_NO NUMBER 2 NO SEQUENCE NUMBER: Directory profile indicator.
Date: 21-JUN-2004 Page: 43
TABLE: GOBEACC
CREATOR: GENERAL
Enterprise Oracle Access Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBEACC_PIDM NUMBER 8 NO System generated unique PIDM associated with user.
GOBEACC_USERNAME VARCHAR2 30 NO Oracle user ID.
GOBEACC_USER_ID VARCHAR2 30 NO Current User, system updated.
GOBEACC_ACTIVITY_DATE DATE 7 NO System date of insert or update.
Date: 21-JUN-2004 Page: 44
TABLE: GOBEQRC
CREATOR: GENERAL
Event Queue Record Maintenance Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBEQRC_SEQNO NUMBER NO SEQUENCE NUMBER: Sequence Number of an Event within
the Target System. Generated by GOBESEQ.
GOBEQRC_EQTS_CODE VARCHAR2 10 NO TARGET SYSTEM CODE: Target System Code.
GOBEQRC_EQNM_CODE VARCHAR2 20 NO EVENT CODE: Event Code to be processed.
GOBEQRC_STATUS_IND VARCHAR2 1 NO STATUS INDICATOR: 0=Ready for Processing, 1=Being
Processed, 2=Complete.
GOBEQRC_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
GOBEQRC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
record was entered or updated.
Date: 21-JUN-2004 Page: 45
SEQUENCE: GOBESEQ
CREATOR: GENERAL
===================================================================================================================
Minimum Value: 1
Maximum Value: 99999999
Increment: 1
Last Number: 2105629
Cache Size: 0
Order Option: ORDERED
Cycle Option: NOCYCLE
Date: 21-JUN-2004 Page: 46
TABLE: GOBFNXR
CREATOR: GENERAL
Third-Party Function Calls Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBFNXR_FUNCTION VARCHAR2 30 NO Function or transaction label associated with the
package and procedure e.g. MAIN_MENU, REG_MENU,
FIN_MENU.
GOBFNXR_PACKAGE VARCHAR2 80 NO Name of package and procedure associated with
function.
GOBFNXR_SYS_REQ_IND VARCHAR2 1 NO System Required Indicator. Indicates whether the
record is required by the SCT system.
GOBFNXR_ACTIVITY_DATE DATE 7 NO Date on which the record was last updated or created.
GOBFNXR_USER_ID VARCHAR2 30 NO The user id of the person who updates this record.
Date: 21-JUN-2004 Page: 47
TABLE: GOBINTL
CREATOR: GENERAL
Visa International Information Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBINTL_PIDM NUMBER 8 NO PERSONAL ID NUMBER: This field indicates Personal
Identification Number.
GOBINTL_SPOUSE_IND VARCHAR2 1 NO SPOUSE INDICATOR: This field indicates whether the
Spouse Accompanied the person to the Country.
GOBINTL_SIGNATURE_IND VARCHAR2 1 NO SIGNATURE INDICATOR: This field indicates Signature
Available for Funds.
GOBINTL_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user who changed the record.
GOBINTL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or updated in the GOBINTL table.
GOBINTL_PASSPORT_ID VARCHAR2 15 YES PASSPORT NUMBER: This field indicates Passport
Identification Number.
GOBINTL_NATN_CODE_ISSUE VARCHAR2 5 YES ISSUING NATION CODE: This field indicates the Country
Code of the nation issuing the passport.
GOBINTL_PASSPORT_EXP_DATE DATE 7 YES PASSPORT EXPIRATION DATE: This field indicates the
date the passport expires.
GOBINTL_I94_STATUS VARCHAR2 3 YES I94 STATUS: This field indicates whether the passport
status is for Admission or Departure.
GOBINTL_I94_DATE DATE 7 YES I94 EXPIRATION DATE: This field indicates the date the
Admission or Departure expires.
GOBINTL_REG_NUMBER VARCHAR2 11 YES REGISTRATION NUMBER: This field indicates a unique
Passport Registration Number.
GOBINTL_DURATION VARCHAR2 1 YES DURATION: This field indicates whether the Admission
or Departure is for the Duration of the Stay.
GOBINTL_CELG_CODE VARCHAR2 6 YES CERTIFICATION CODE: This field indicates Passport
Certification Eligibility Code.
GOBINTL_CERT_NUMBER VARCHAR2 11 YES CERTIFICATION NUMBER: This field indicates the
Passport Certification Number.
GOBINTL_CERT_DATE_ISSUE DATE 7 YES CERTIFICATION ISSUE DATE: This field indicates the
date the Passport Certification was issued.
GOBINTL_CERT_DATE_RECEIPT DATE 7 YES CERTIFICATION RECEIPT DATE: This field indicates the
date the Passport Certification was received.
GOBINTL_ADMR_CODE VARCHAR2 4 YES ADMISSION REQUEST CODE: This field indicates Admission
Request Code.
GOBINTL_NATN_CODE_BIRTH VARCHAR2 5 YES BIRTH NATION CODE: This field indicates the Country
Code of the nation of the person's Birth.
GOBINTL_NATN_CODE_LEGAL VARCHAR2 5 YES LEGAL NATION CODE: This field indicates the Country
Code of the nation of the person's Citizenship.
GOBINTL_LANG_CODE VARCHAR2 3 YES LANGUAGE CODE: This field indicates the person's
native Language Code.
GOBINTL_SPON_CODE VARCHAR2 3 YES SPONSOR CODE: This field indicates the Sponsor Code.
GOBINTL_EMPT_CODE VARCHAR2 3 YES EMPLOYMENT TYPE CODE: This field indicates the
person's type of Employment.
GOBINTL_FOREIGN_SSN VARCHAR2 9 YES FOREIGN TAX ID: This field indicates a unique
identification number for tax purposes: such as SSN.
Date: 21-JUN-2004 Page: 48
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBINTL_CHILD_NUMBER NUMBER 2 YES CHILD NUMBER: This field indicates the Number of
Children Accompaning the person to the Country.
Date: 21-JUN-2004 Page: 49
SEQUENCE: GOBISEQ
CREATOR: GENERAL
===================================================================================================================
Minimum Value: 1
Maximum Value: 99999999999999999999
Increment: 1
Last Number: 202654
Cache Size: 0
Order Option: NOT ORDERED
Cycle Option: NOCYCLE
Date: 21-JUN-2004 Page: 50
TABLE: GOBPCRL
CREATOR: GENERAL
VBS Secured Item Pattern Control
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBPCRL_VOBJ_CODE VARCHAR2 15 NO VBS Object Code
GOBPCRL_VAPP_CODE VARCHAR2 15 NO VBS Secured Item Code
GOBPCRL_PATTERN_CTRL NUMBER 4 NO VBS Secured Item Pattern Control Seed Number
GOBPCRL_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
GOBPCRL_TABLE_NAME VARCHAR2 30 YES Table to validate against
Date: 21-JUN-2004 Page: 51
SEQUENCE: GOBRSEQ
CREATOR: GENERAL
===================================================================================================================
Minimum Value: 1
Maximum Value: 99999999
Increment: 1
Last Number: 80313
Cache Size: 0
Order Option: NOT ORDERED
Cycle Option: NOCYCLE
Date: 21-JUN-2004 Page: 52
TABLE: GOBSEGC
CREATOR: GENERAL
Access Group Base
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBSEGC_SEGC_CODE VARCHAR2 15 NO Access Group Code
GOBSEGC_EFF_DATE DATE 7 NO Access Group Effective Date
GOBSEGC_ACTIVE_IND VARCHAR2 1 NO Access Group Active Indicator
GOBSEGC_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
Date: 21-JUN-2004 Page: 53
TABLE: GOBSEVS
CREATOR: GENERAL
SEVIS Reporting base table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBSEVS_PIDM NUMBER 8 NO PERSONAL ID NUMBER: Internal identification number of
the person
GOBSEVS_ENG_PROF_REQ_IND VARCHAR2 1 NO ENGLISH PROFICIENCY REQUIRED INDICATOR: Is English
required for the program
GOBSEVS_ENG_PROF_MET_IND VARCHAR2 1 NO ENGLICH PROFICIENCY MET INDICATOR: Has the English
requirement been met
GOBSEVS_CRIMINAL_CONVICT_IND VARCHAR2 1 NO CRIMINAL CONVICTION INDICATOR: Indicator to show that
the student has a criminal conviction
GOBSEVS_TERMINATE_STUDENT_IND VARCHAR2 1 NO STUDENT TERMINATION INDICATOR: Indicator to show if
the student was terminated
GOBSEVS_EXTEND_FAILURE_IND VARCHAR2 1 NO EXTENSION FAILURE INDICATOR: Indicator to show if the
exchange visitor failed to extend the program
GOBSEVS_TRANSFER_FAIL_IND VARCHAR2 1 NO TRANSFER FAILURE INDICATOR: Indicator to show if a
transfer of an exchange visitor has failed
GOBSEVS_APPROVAL_FAIL_IND VARCHAR2 1 NO TRANSFER APPROVAL FILURE INDICATOR: Indicator to show
if there was a failure to secure approval for a
transfer
GOBSEVS_OTHER_INFRACT_IND VARCHAR2 1 NO OTHER INFRACTIONS INDICATOR:Indicator to show that the
exchange visitor has received other, minor
disciplinary actions
GOBSEVS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The most recent date a record was
created or updated
GOBSEVS_USER_ID VARCHAR2 30 NO USER ID: The most recent user to create or update a
record.
GOBSEVS_BIRTH_NATN_CODE VARCHAR2 5 YES BIRTH NATION CODE: Country of birth of the
student/exchange visitor
GOBSEVS_LEGAL_NATN_CODE VARCHAR2 5 YES LEGAL NATIN CODE: Country of citizenship of the
student/exchange visitor
GOBSEVS_PROGRAM_BEGIN_DATE DATE 7 YES PROGRAM BEGIN DATE: Date the program begins
GOBSEVS_PROGRAM_END_DATE DATE 7 YES PROGRAM END DATE: Date the program ends
GOBSEVS_PROGRAM_ENROLL_DATE DATE 7 YES ENROLLED DATE: Date on which the student/exchange
visitor enrolled in the program
GOBSEVS_ENG_PROF_REASON VARCHAR2 500 YES REASON ENGLISH PROFICIENCY IS NOT REQUIRED: Reason
English is not required for the program
GOBSEVS_ACADEMIC_TERM_MONTHS NUMBER 3 YES ACADEMIC TERM LENGTH: Length of academic term in
months
GOBSEVS_TUITION_EXPENSE NUMBER 12 2 YES TUITION EXPENSES: Tuition expenses for length of
program
GOBSEVS_PERSONAL_FUNDS NUMBER 12 2 YES PERSONAL FUNDS: Funds provided by the student/exchange
visitor
GOBSEVS_TRANS_CDE VARCHAR2 10 YES SEVIS TRANSACTION CODE: Transaction code for the
record submitted
GOBSEVS_SEVIS_ID VARCHAR2 11 YES SEVIS ID: ID for the person as assigned by SEVIS
GOBSEVS_VTYP_CODE VARCHAR2 2 YES VISA TYPE: Code for the Visa type requested for the
person
GOBSEVS_SVCR_CODE VARCHAR2 4 YES CREATE REASON CODE: Code for the reason to create
record
Date: 21-JUN-2004 Page: 54
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBSEVS_SESSION_START_DATE DATE 7 YES SESSION START DATE: Date on which the session starts
GOBSEVS_SESSION_END_DATE DATE 7 YES SESSION END DATE: Date on which the session ends
GOBSEVS_TRANSFER_COMMENT VARCHAR2 500 YES TRANSFER COMMENTS: Comments from the school about a
transfer student
GOBSEVS_ISSUE_COMMENT VARCHAR2 500 YES ISSUE COMMENTS: Additional comments about the reason
to issue the Visa to the person
GOBSEVS_SVEL_CODE VARCHAR2 2 YES EDUCATIONAL LEVEL: Code for the educational level of
the person
GOBSEVS_MAJR_CODE VARCHAR2 4 YES PRIMARY MAJOR: Major code of the student
GOBSEVS_STUDY_LENGTH NUMBER 3 YES PROGRAM OF STUDY LENGTH: Length of the program of
student in months
GOBSEVS_LIVING_EXPENSES NUMBER 12 2 YES LIVING EXPENSES: Dollar amount of the student's living
expenses
GOBSEVS_SVFT_CODE VARCHAR2 2 YES DROP BELOW FULL TIME CODE: Code to indicate the reason
the student dropped below full time
GOBSEVS_AUTH_START_DATE DATE 7 YES AUTHORIZATION START DATE: Date in which the student
was authorized to drop below full time
GOBSEVS_COMPLETION_REMARKS VARCHAR2 500 YES COMPLETION REMARKS: Comments regarding the students
completion of the program
GOBSEVS_NEW_PROGRAM_END_DATE DATE 7 YES PROGRAM CHANGED END DATE: New program end date as the
result of a change
GOBSEVS_DA_PROGRAM_START_DATE DATE 7 YES PROGRAM DEFERRED START DATE: New program start date as
the result of deferred attendance
GOBSEVS_DA_PROGRAM_END_DATE DATE 7 YES PROGRAM DEFERRED END DATE: New program end date as the
result of deferred attendance
GOBSEVS_DISC_ACTION_TEXT VARCHAR2 500 YES DISCIPLINARY ACTION COMENTS: Comments to explain the
disciplinary action against the student
GOBSEVS_EMPLOYMENT_CDE VARCHAR2 2 YES STUDENT EMPLOYMENT CODE: A code to show if the student
is employed
GOBSEVS_EMPLOYMENT_COMMENT VARCHAR2 500 YES STUDENT EMPLOYMENT COMMENTS: Comments to allow the
school to explain the recommendation for the students
employment
GOBSEVS_EMPLOYMENT_START_DATE DATE 7 YES EMPLOYMENT START DATE: Start date of the student's
employment
GOBSEVS_EMPLOYMENT_END_DATE DATE 7 YES EMPLOYMENT END DATE: End date of the student's
employment
GOBSEVS_EMPLOYMENT_TYPE_CDE VARCHAR2 2 YES EMPLOYMENT TYPE CODE:Code to show the type of
employment for the student
GOBSEVS_EMPLOYER_LAST_NAME VARCHAR2 500 YES EMPLOYER LAST NAME: Last name of the student's
employer
GOBSEVS_EMPLOYER_FIRST_NAME VARCHAR2 40 YES EMPLOYER FIRST NAME: First name of the student's
employer
GOBSEVS_EMP_ADDRESS_LINE1 VARCHAR2 60 YES EMPLOYER ADDRESS LINE 1: First line of the student's
employer address
GOBSEVS_EMP_ADDRESS_LINE2 VARCHAR2 60 YES EMPLOYER ADDRESS LINE 2: Second line of the student's
employer address
GOBSEVS_EMPLOYER_CITY VARCHAR2 60 YES EMPLOYER CITY: City of the student's employer
GOBSEVS_EMPLOYER_STATE VARCHAR2 2 YES EMPLOYER STATE: State of the student's employer
GOBSEVS_EMPLOYER_ZIP VARCHAR2 9 YES EMPLOYER ZIP: Zip code of the student's employer
GOBSEVS_COURSE_RELEVANCE VARCHAR2 500 YES COURSE RELEVANCE COMMENTS: Comments to explain the
employ and its relevance to the student's course work
Date: 21-JUN-2004 Page: 55
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBSEVS_EXTEND_END_DATE DATE 7 YES EXTENSION END DATE: The new program end date due to an
extension
GOBSEVS_SVTR_CODE VARCHAR2 6 YES TERMINATION REASON CODE: Code to show the reason why
the student/exchange visitor was terminated
GOBSEVS_TERMINATE_DATE DATE 7 YES TERMINATION DATE: Date on which the student/echange
visitor was terminated
GOBSEVS_APPROVAL_FAIL_COMMENT VARCHAR2 500 YES TRANSFER APPROVAL FAILURE COMMENTS: Comments about the
failure to obtain approval for a transfer
GOBSEVS_OTHER_INFRACT_COMMENT VARCHAR2 500 YES OTHER INFRACTIONS COMMENTS: Comments on the other,
minor disciplinary actions that the exchange visitor
has received
GOBSEVS_SVEP_CODE VARCHAR2 4 YES EXCHANGE VISITOR PROGRAM END CODE: Code to show why
the exchange visitor's program has ended
GOBSEVS_END_PROGRAM_EFF_DATE DATE 7 YES EXCHANGE VISITOR PROGRAM END DATE: Date on which the
exchange visitor's program ended
GOBSEVS_EV_FORM_NUMBER VARCHAR2 40 YES EXCHANGE VISITOR FORM NUMBER: Exchange visitor's form
number
GOBSEVS_SVRP_CODE VARCHAR2 2 YES REASON FOR FORM REPRINT: Code to show a reason for the
reprint of the exchange visitor's form
GOBSEVS_REPRINT_REASON_COMMENT VARCHAR2 500 YES FORM REPRINT REASON COMMENTS: Comments to explain the
need for a form reprint
GOBSEVS_SVCR_COMMENT VARCHAR2 500 YES CREATE REASON COMMENT: Create reason comment
GOBSEVS_PRINT_REQUEST_IND VARCHAR2 1 NO PRINT REQUEST INDICATOR: Print request indicator
GOBSEVS_DEPENDENT_EXPENSES NUMBER 12 2 YES DEPENDENT EXPENSES: Student dependent expenses.
GOBSEVS_OTHER_FUNDS NUMBER 12 2 YES OTHER FUNDS: Amount of funds from other sources.
GOBSEVS_OTHER_FUNDS_COMMENT VARCHAR2 500 YES OTHER FUNDS DESCRIPTION: Description of the other
sources of funding.
GOBSEVS_OTHER_EXPENSES NUMBER 12 2 YES OTHER EXPENSES: Expenses from other sources.
GOBSEVS_OTHER_EXP_COMMENT VARCHAR2 500 YES OTHER EXPENSES DESCRIPTION: Description of the other
expenses.
GOBSEVS_AUTH_END_DATE DATE 7 YES AUTHORIZATION END DATE: Date when the student ended
less than full time study.
GOBSEVS_NEW_PROGRAM_START_DATE DATE 7 YES NEW PROGRAM START DATE: Date when the new program will
begin.
GOBSEVS_SVPC_CODE VARCHAR2 3 YES POSITION CODE: Exchange visitor position code.
GOBSEVS_SVSC_CODE VARCHAR2 7 YES SUBJECT CODE: Exchange visitior subject code.
GOBSEVS_SVSC_COMMENT VARCHAR2 500 YES SUBJECT REMARKS: Remarks for the subject of field of
study.
GOBSEVS_COMMUTER_IND VARCHAR2 1 NO COMMUTER INDICATOR: Denotes whether or not a student
commutes from a foreign country. If Y, then, no USA
address is required.
GOBSEVS_ADMISSION_NUMBER VARCHAR2 11 YES ADMISSION NUMBER: I-94 admission number.
GOBSEVS_DRIVERS_LIC_NUMBER VARCHAR2 30 YES DRIVER'S LICENSE NUMBER: Student's driver's license
number.
GOBSEVS_STAT_CODE_DRIVERS_LIC VARCHAR2 2 YES DRIVER'S LICENSE STATE: State of the student's
driver's license.
GOBSEVS_TIN VARCHAR2 9 YES TIN: Student's tax ID number.
GOBSEVS_MAJR_CODE_2 VARCHAR2 4 YES SECONDARY MAJOR: Banner code for secondary major from
STVMAJR.
GOBSEVS_MAJR_CODE_MINR VARCHAR2 4 YES MINOR: Banner code for minor from STVMAJR.
Date: 21-JUN-2004 Page: 56
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBSEVS_SCHOOL_FUNDS NUMBER 12 2 YES SCHOOL FUNDS: Amount of funding provided by the
school.
GOBSEVS_SCHOOL_FUNDS_COMMENT VARCHAR2 500 YES SCHOOL FUNDING REMARKS: Explanation of school funding.
GOBSEVS_EMPLOYMENT_FUNDS NUMBER 12 2 YES EMPLOYMENT FUNDING: Funds received from on-campus
employment.
GOBSEVS_FUNDING_COMMENT VARCHAR2 500 YES FUNDING COMMENT: General comment on funding.
GOBSEVS_SVFT_COMMENT VARCHAR2 500 YES DROP BELOW FT REMARKS: Drop below full time remarks.
GOBSEVS_SVEP_COMMENT VARCHAR2 500 YES EXTEND PROGRAM REMARKS: Program extention remarks.
GOBSEVS_DA_COMMENT VARCHAR2 500 YES DEFER ATTENDENCE REMARKS: Comments about the deferred
attendence.
GOBSEVS_SVTR_COMMENT VARCHAR2 500 YES TERMINATION REMARKS: Comments about termination.
GOBSEVS_PASSPORT_NUMBER VARCHAR2 25 YES PASSPORT NUMBER: Passport number.
GOBSEVS_NATN_CODE_PASSPORT VARCHAR2 5 YES PASSPORT ISSUE NATION: The Banner code of the nation
that issued the passport.
GOBSEVS_PASSPORT_EXPIRE_DATE DATE 7 YES PASSPORT EXPIRATION DATE: Passport expiration date.
GOBSEVS_VISA_NUMBER VARCHAR2 25 YES VISA NUMBER: Visa number.
GOBSEVS_SVCP_CODE VARCHAR2 3 YES VISA CONSULAR POST: Code of the consular post that
issued the visa.
GOBSEVS_VISA_EXPIRE_DATE DATE 7 YES VISA EXPIRE DATE: Date when the visa expires.
GOBSEVS_PENT_CODE VARCHAR2 3 YES PORT OF ENTRY: Banner code for port of entry.
GOBSEVS_PENT_COMMENT VARCHAR2 500 YES PORT OF ENTRY COMMENTS: Port of entry comments.
GOBSEVS_ENTRY_DATE DATE 7 YES DATE OF ENTRY: Date of entry.
GOBSEVS_EMPL_AUTH_IND VARCHAR2 1 NO EMPLOYMENT AUTHORITY: Indicator to show that a
recommendation for employment exists.
GOBSEVS_RFC_COMMENT VARCHAR2 500 YES RESUME FULL COURSE REMARKS: Resume full course
comments.
GOBSEVS_EDIT_PROGRAM_COMMENT VARCHAR2 500 YES EDIT PROGRAM COMMENTS: Remarks about why program
information was edited.
GOBSEVS_EMPLOYMENT_TIME_CDE VARCHAR2 2 YES EMPLOYMENT TIME CODE: Employment time code indicates
full or part-time status.
GOBSEVS_PROGRAM_SPONSOR_FUNDS NUMBER 12 2 YES PROGRAM SPONSOR FUNDS: The amount of financial support
from the program sponsor.
GOBSEVS_GOVT_ORG_FUNDS NUMBER 12 2 YES GOVERNMENT ORG 1 FUNDS: Funds received from a
government organization.
GOBSEVS_SVGO_CODE VARCHAR2 6 YES GOVERNMENT ORG 1 CODE: Code to describe the government
organization.
GOBSEVS_GOVT_ORG_FUNDS_2 NUMBER 12 2 YES GOVERNMENT ORG 2 FUNDS: Funds received from a
government organization.
GOBSEVS_SVGO_CODE_2 VARCHAR2 6 YES GOVERNMENT ORG 2 CODE: Code to describe the government
organization.
GOBSEVS_INTL_ORG_FUNDS NUMBER 12 2 YES INTERNATIONAL ORG 1 FUNDS: Funds received from an
international organization.
GOBSEVS_SVIO_CODE VARCHAR2 6 YES INTERNATIONAL ORG 1 CODE: Code to describe the
international organization.
GOBSEVS_INTL_ORG_FUNDS_2 NUMBER 12 2 YES INTERNATIONAL ORG 2 FUNDS: Funds received from an
international organization.
GOBSEVS_SVIO_CODE_2 VARCHAR2 6 YES INTERNATIONAL ORG 2 CODE: Code to describe the
international organization.
GOBSEVS_EV_GOVT_FUNDS NUMBER 12 2 YES EV GOVERNMENT FUNDS: Funds provided by the exchange
visitor's government.
GOBSEVS_BINATION_FUNDS NUMBER 12 2 YES BI-NATIONAL COMMISSION FUNDS: Funds provided by a
bi-national commission.
Date: 21-JUN-2004 Page: 57
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBSEVS_OTHER_ORG_FUNDS NUMBER 12 2 YES OTHER ORGANIZATION FUNDS: Funds provided by another
type of organization.
GOBSEVS_PROGRAM_START_IND VARCHAR2 1 NO PROGRAM START INDICATOR: Indicator to show if the
exchange visitor started the program.
GOBSEVS_EXTEND_PROGRAM_COMMENT VARCHAR2 500 YES EXTEND PROGRAM REMARKS: Comments to explain why a
program was extended.
GOBSEVS_AMEND_PROGRAM_COMMENT VARCHAR2 500 YES AMEND PROGRAM REMARKS: Comments to explain how a
program was amended.
GOBSEVS_MATRICULATION_CDE VARCHAR2 2 YES MATRICULATION CODE: Matriculation code.
GOBSEVS_EXTEND_FAILURE_COMMENT VARCHAR2 500 YES EXTEND FAUILURE END REMARKS: Comments to explain an
extension failure.
GOBSEVS_CONCLUDE_TRANS_COMMENT VARCHAR2 500 YES CONCLUDE FAILURE REMARKS: Comments to explain why a
transfer was not concluded.
GOBSEVS_BIRTH_CITY VARCHAR2 200 YES EV BIRTH CITY: Exchange visitor birth city.
GOBSEVS_EDIT_BIO_COMMENT VARCHAR2 500 YES EDIT EV BIO COMMENT: Comments to explain why EV
biographical data was edited.
GOBSEVS_ATYP_CODE_ACT_SITE VARCHAR2 2 YES ACTIVITY SITE ADDRESS TYPE: Banner address code for
the activity site address.
GOBSEVS_NATN_CODE_PERM_RES VARCHAR2 5 YES PERMANENT RESIDENCY COUNTRY CODE: Banner code for
nation of permanent residency.
GOBSEVS_FIN_SUPPORT_COMMENT VARCHAR2 500 YES FINANCIAL SUPPORT COMMENT: Financial support remarks.
GOBSEVS_SVIT_CODE VARCHAR2 3 YES INFRACTION CODE: SEVIS infraction code.
GOBSEVS_ACT_SITE_NAME VARCHAR2 60 YES ACTIVITY SITE NAME: Name to identify the site of
activity.
GOBSEVS_ACT_SITE_COMMENT VARCHAR2 500 YES ACTIVITY SITE COMMENT: Remarks used when adding or
deleting the site of activity.
GOBSEVS_SVCC_CODE VARCHAR2 3 YES CATEGORY CODE: SEVIS category code used in EV
reporting.
GOBSEVS_SCHOOL_CDE VARCHAR2 15 YES SEVIS-assigned school ID number.
GOBSEVS_PROGRAM_CDE VARCHAR2 9 YES SEVIS-assigned EV program ID number.
GOBSEVS_OFFICER_ID VARCHAR2 10 YES SEVIS-assigned ID number for data approver.
GOBSEVS_SVEL_COMMENT VARCHAR2 500 YES EDUCATION LEVEL COMMENT: Comment on education level.
Date: 21-JUN-2004 Page: 58
TABLE: GOBSRID
CREATOR: GENERAL
IMS Sourced ID Base Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBSRID_PIDM NUMBER 8 NO Internal identification number of the person
GOBSRID_SOURCED_ID NUMBER 16 NO Permanent, unique identifier required for IMS data
transfers.
GOBSRID_ACTIVITY_DATE DATE 7 NO Date on which the record waslast inserted or updated.
GOBSRID_USER_ID VARCHAR2 30 NO Oracle User ID of user who created the record.
Date: 21-JUN-2004 Page: 59
TABLE: GOBSRVR
CREATOR: GENERAL
Survey Response Header Table. This table contains one row for each person who responds to the survey.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBSRVR_PIDM NUMBER 8 NO Internal Identification Number of the person who
responded to the survey.
GOBSRVR_NAME VARCHAR2 15 NO Survey Name.
GOBSRVR_ACTIVITY_DATE DATE 7 NO The date that the person last responded to the survey.
GOBSRVR_USER VARCHAR2 30 NO The User ID(Oracle) of the person who responded to the
survey.
GOBSRVR_DECLINED_IND VARCHAR2 1 NO Declined Indicator. Y = user declined to answer the
survey.
GOBSRVR_COMPLETE_IND VARCHAR2 1 NO Complete Indicator. Y indicates complete, N indicates
incomplete.
Date: 21-JUN-2004 Page: 60
TABLE: GOBTPAC
CREATOR: GENERAL
Third Party Access Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBTPAC_PIDM NUMBER 8 NO Banner PIDM
GOBTPAC_PIN_DISABLED_IND VARCHAR2 1 NO PIN disabled Indicator. When Y, access to SCT Third
Party Access products (Web Fors, VR, Kiosk) will be
denied.
GOBTPAC_USAGE_ACCEPT_IND VARCHAR2 1 NO 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.
GOBTPAC_ACTIVITY_DATE DATE 7 NO Date on which the record was last added or updated.
GOBTPAC_USER VARCHAR2 30 NO Oracle User ID of the last user to modify the record
GOBTPAC_PIN VARCHAR2 6 YES 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.
GOBTPAC_PIN_EXP_DATE DATE 7 YES 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.
GOBTPAC_EXTERNAL_USER VARCHAR2 30 YES Value which may be passed to the partner systems as a
login ID and/or email ID..
GOBTPAC_QUESTION VARCHAR2 90 YES Free form question entered by a Web User to be used as
a hint when trying to get their PIN reset.
GOBTPAC_RESPONSE VARCHAR2 30 YES Free form response entered by a Web User to be used as
answer to the hint question when trying to get their
PIN reset.
GOBTPAC_INSERT_SOURCE VARCHAR2 8 YES 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.
GOBTPAC_LDAP_USER VARCHAR2 255 YES LDAP User Mapping: This will optionally store non
LUMINIS LDAP user mapping for Banner.
Date: 21-JUN-2004 Page: 61
TABLE: GOBVBSC
CREATOR: GENERAL
VBS Application Control
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBVBSC_VBS_IND VARCHAR2 1 NO Indicates VBS is Active
GOBVBSC_VBS_ON_DATE DATE 7 NO Date VBS State was Altered
GOBVBSC_VBS_SUSPEND_IND VARCHAR2 1 NO Indicates VBS is Suspended
GOBVBSC_VBS_SUSPEND_DATE DATE 7 NO Date VBS Suspension State was Altered
GOBVBSC_USER_ID VARCHAR2 30 NO User ID Last Modifying VBS State
GOBVBSC_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
Date: 21-JUN-2004 Page: 62
TABLE: GOBVBST
CREATOR: GENERAL
VBS
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBVBST_USER VARCHAR2 30 NO User
GOBVBST_VAPP_CODE_MODULE VARCHAR2 15 NO Module
GOBVBST_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
Date: 21-JUN-2004 Page: 63
TABLE: GOBVCRL
CREATOR: GENERAL
VBS Access Rule Control
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBVCRL_USER_ID VARCHAR2 30 NO ORACLE User ID
GOBVCRL_BACR_SEQNO NUMBER 8 NO Access Rule Sequence Number
GOBVCRL_VAPP_CODE_MODULE VARCHAR2 15 NO Module
GOBVCRL_ACCESS_CNT NUMBER 4 NO Access count
Date: 21-JUN-2004 Page: 64
TABLE: GOBVUSR
CREATOR: GENERAL
VBS User Profile Base
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBVUSR_USER_ID VARCHAR2 30 NO ORACLE User ID
GOBVUSR_ACTIVE_IND VARCHAR2 1 NO Indicates VBS User Profile is Active
GOBVUSR_EFF_DATE DATE 7 NO Indicates Effective Date of VBS User Profile
GOBVUSR_ADMIN_IND VARCHAR2 1 NO Indicates the VBS User to be an Access Group
Administrator
GOBVUSR_MGR_IND VARCHAR2 1 NO Indicates the VBS User to be an Access Group Manager
GOBVUSR_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
GOBVUSR_EXPIRE_DATE DATE 7 YES Indicates Expiration Date of VBS USer Profile
Date: 21-JUN-2004 Page: 65
TABLE: GOBWFDD
CREATOR: GENERAL
Workflow Electronic Documents Dictionary Base table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBWFDD_ID NUMBER 8 NO ID: Application Id
GOBWFDD_PRODUCT_TYPE VARCHAR2 20 NO PRODUCT TYPE: Banner available Product Types
GOBWFDD_APPL_NAME VARCHAR2 20 NO APPLICATION NAME: Banner Application Name (Oracle
Forms Name)
GOBWFDD_USER_ID VARCHAR2 30 NO
GOBWFDD_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 66
TABLE: GOBWFED
CREATOR: GENERAL
Workflow Electronic Documents Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOBWFED_TRANS_NO NUMBER 15 NO TRANSACTION NUMBER: Electronic Document Transaction
Number
GOBWFED_DESC VARCHAR2 60 NO DESCRIPTION: Electronic Document Transcation
Description
GOBWFED_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 67
SEQUENCE: GOBWSEQ
CREATOR: GENERAL
===================================================================================================================
Minimum Value: 1
Maximum Value: 99999999
Increment: 1
Last Number: 1
Cache Size: 0
Order Option: NOT ORDERED
Cycle Option: NOCYCLE
Date: 21-JUN-2004 Page: 68
TABLE: GORADRL
CREATOR: GENERAL
Address/User Roles Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORADRL_ATYP_CODE VARCHAR2 2 NO Address Type Code
GORADRL_ROLE VARCHAR2 30 NO User Role. Values are STUDENT, EMPLOYEE, or FACULTY
GORADRL_PRIV_IND VARCHAR2 1 NO Privilege Indicator. Values are (U)pdate, (D)isplay,
or (N)one
GORADRL_ACTIVITY_DATE DATE 7 NO Last Activity Date
Date: 21-JUN-2004 Page: 69
TABLE: GORCCAU
CREATOR: GENERAL
SCT Banner Credit Card Audit Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORCCAU_ID VARCHAR2 9 NO ID: ID of user requesting credit card transaction
GORCCAU_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Timestamp of audit record
GORCCAU_PIDM NUMBER 8 YES PIDM: Pidm/Aidm of user requesting credit card
transaction
GORCCAU_TERM_CODE VARCHAR2 6 YES TERM: Term Code associated with credit card
transaction
GORCCAU_LOCATION VARCHAR2 120 YES LOCATION: Point in transaction when record was created
GORCCAU_DETAIL VARCHAR2 20 YES DETAIL: Detail/Gift Code associated with transaction
GORCCAU_STREET_LINE1 VARCHAR2 30 YES LINE 1: Street line 1 of address data for transaction
GORCCAU_STREET_LINE2 VARCHAR2 30 YES LINE 2:Street line 2 of address data for transaction
GORCCAU_STAT_CODE VARCHAR2 3 YES STATE: State/Province of address data for transaction
GORCCAU_ZIP VARCHAR2 10 YES ZIP: Zip/Postal Code of address data for transaction
GORCCAU_NATN_CODE VARCHAR2 5 YES NATION: Nation code of address data for transaction
GORCCAU_CCRD_NUM VARCHAR2 20 YES CREDIT CARD NUMBER: Credit card number, or partial for
transaction
GORCCAU_EXP_MO VARCHAR2 2 YES EXPIRATION MONTH: Month of expiration date for
transaction
GORCCAU_EXP_YR VARCHAR2 4 YES EXPIRATION YEAR: Year of expiration date for
transaction
GORCCAU_AMOUNT VARCHAR2 16 YES AMOUNT: Payment amount of transaction
GORCCAU_MERCHANT_ID VARCHAR2 20 YES MERCHANT ID: 3rd party trans code for transaction
GORCCAU_DEBUG_MSG VARCHAR2 100 YES DEBUG MESSAGE: Debug message for troubleshooting
process
GORCCAU_STATUS VARCHAR2 40 YES STATUS: Status of transaction
GORCCAU_SENT_STRING VARCHAR2 3000 YES SENT STRING: String value sent to processor
GORCCAU_RETURN_STRING VARCHAR2 3000 YES RETURN STRING: String value returned from processor
Date: 21-JUN-2004 Page: 70
TABLE: GORCCRD
CREATOR: GENERAL
CREDIT CARD RULES Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORCCRD_CCRD_CODE VARCHAR2 10 NO CREDIT CARD TYPE CODE: Code associated with the Credit
Card Type.
GORCCRD_EDIT_CHAR_START VARCHAR2 4 NO EDIT CHARACTER RANGE START: Start of Edit Character
Range associated with the Credit Card Type. These
characters are used during validation to verify that
the credit card number is valid for the assoc
iated
credit card type.
GORCCRD_EDIT_CHAR_END VARCHAR2 4 NO EDIT CHARACTER RANGE END: End of Edit Character range
associated with the Credit Card Type. These
characters are used during validation to verify that
the credit card number is valid for the
associated
credit card type.
GORCCRD_CARD_LENGTH NUMBER 2 NO CREDIT CARD LENGTH: Number of digits contained in the
associated Credit Card Type.
GORCCRD_NUM_CHECK_DIGITS NUMBER 1 NO NUMBER OF DIGITS TO CHECK: The number of digits from
the credit card number to be checked against the Edir
Character Range for the specified Credit Card Type.
GORCCRD_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user creating or updating the record.
GORCCRD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the record was created or
updated.
Date: 21-JUN-2004 Page: 71
TABLE: GORCGEO
CREATOR: GENERAL
Collector table of persons address for the Geographic Regions/Division
process.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORCGEO_PIDM NUMBER 8 NO PIDM for SPRADDR row.
GORCGEO_ATYP_CODE VARCHAR2 2 NO Address type of SPRADDR row.
GORCGEO_ADDR_SEQNO NUMBER 2 NO Sequence number of SPRADDR row.
GORCGEO_ACTION_IND VARCHAR2 1 NO Values I (insert), U (update) and D (delete) to
indicate the status of
the SPRADDR row.
GORCGEO_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created
Date: 21-JUN-2004 Page: 72
TABLE: GORDADD
CREATOR: GENERAL
Directory Address Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORDADD_DIRO_CODE VARCHAR2 8 NO DIRECTORY CODE: Code for Directory Item.
GORDADD_PRIORITY_NO NUMBER 1 NO PRIORITY NUMBER: Priority Number.
GORDADD_ATYP_CODE VARCHAR2 2 YES ADDRESS TYPE CODE: Address Type Code.
GORDADD_TELE_CODE VARCHAR2 4 YES TELEPHONE TYPE CODE: Telephone Type Code.
GORDADD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity on this record.
Date: 21-JUN-2004 Page: 73
TABLE: GORDLUP
CREATOR: GENERAL
Add-In Data Lookup Repeating table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORDLUP_DADD_CODE VARCHAR2 15 NO ADD-IN CODE: Add-In code to associate with Data
lookup.
GORDLUP_LOOKUP_NAME VARCHAR2 15 NO LOOKUP NAME: Lookup Name associate with Add-In code.
GORDLUP_LOOKUP_DESCRIPTION VARCHAR2 60 NO LOOKUP DESCRIPTION: Description of the Lookup.
GORDLUP_MENU_SEQNO NUMBER 5 2 NO MENU SEQUENCE NUMBER: The number which represents item
position on the Menu.
GORDLUP_FINAID_IND VARCHAR2 1 NO FINANCIAL AID INDICATOR: Indicates that menu item is
visible if Financial Aid is installed.
GORDLUP_POSBUD_IND VARCHAR2 1 NO POSITION CONTROL INDICATOR: Indicates that menu item
is visible if Position Control is installed.
GORDLUP_BILCSH_IND VARCHAR2 1 NO BILLCSH INDICATOR: Indicates that menu item is visible
if Billcsh is installed.
GORDLUP_HUMANRE_IND VARCHAR2 1 NO HUMAN RESOURCE INDICATOR: Indicates that menu item is
visible if Human Resource is installed.
GORDLUP_FINANCE_IND VARCHAR2 1 NO FINANCE INDICATOR: Indicates that menu item is visible
if Finance is installed.
GORDLUP_ALUMNI_IND VARCHAR2 1 NO ALUMNI INDICATOR: Indicates that menu item is visible
if Alumni is installed.
GORDLUP_STUDENT_IND VARCHAR2 1 NO STUDENT INDICATOR: Indicates that menu item is visible
if Student is installed.
GORDLUP_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
GORDLUP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date the information for the table
on the record was entered or last updated.
GORDLUP_LOAD_FUNCTION VARCHAR2 255 NO LOAD FUNCTION: The name of the function to be executed
to load the data for the lookup.
Date: 21-JUN-2004 Page: 74
TABLE: GORDOCM
CREATOR: GENERAL
Document Information Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORDOCM_PIDM NUMBER 8 NO PERSONAL ID NUMBER: This field indicates Personal
Identification Number.
GORDOCM_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: This field indicates a Record
Sequence Number.
GORDOCM_VTYP_CODE VARCHAR2 2 NO VISA TYPE CODE: This field indicates the Type of Visa
Issued.
GORDOCM_VISA_NUMBER VARCHAR2 18 NO VISA NUMBER: This field indicates a unique
identification number assigned to a Visa.
GORDOCM_DOCM_CODE VARCHAR2 6 NO DOCUMENT CODE: This field indicates the type of
Document supporting the Visa.
GORDOCM_DISPOSITION VARCHAR2 1 NO DOCUMENT DISPOSITION: This field indicates the status
of the Document.
GORDOCM_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user who changed the record.
GORDOCM_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or updated in the GORDOCM table.
GORDOCM_SRCE_CODE VARCHAR2 6 YES SOURCE CODE: This field indicates the Source of the
supporting document.
GORDOCM_REQUEST_DATE DATE 7 YES REQUEST DATE: This field indicates the date the
Document was requested.
GORDOCM_RECEIVED_DATE DATE 7 YES RECEIVED DATE: This field indicates the date the
Document was received.
Date: 21-JUN-2004 Page: 75
TABLE: GORDPRF
CREATOR: GENERAL
Directory Profile Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORDPRF_PIDM NUMBER 8 NO PIDM NUMBER: Personal Identification Number.
GORDPRF_DIRO_CODE VARCHAR2 8 NO DIRECTORY CODE: Code for Directory Item.
GORDPRF_DISP_DIRECTORY_IND VARCHAR2 1 NO DISPLAY INDICATOR: Display Indicator; Y or N.
GORDPRF_USER_ID VARCHAR2 30 NO USER ID: The ORACLE user id of the person last
updating this record.
GORDPRF_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity on this record.
Date: 21-JUN-2004 Page: 76
TABLE: GORDPRP
CREATOR: GENERAL
Step Property Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORDPRP_DPRP_CODE VARCHAR2 15 NO STEP PROPERTY CODE: The unique step property code
GORDPRP_VALUE_NAME VARCHAR2 15 NO STEP PROPERTY VALUE: Value of the step property
GORDPRP_VALUE_DESCRIPTION VARCHAR2 30 NO STEP PROPERTY VALUE DESCRIPTION: Description of the
step property value
GORDPRP_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
GORDPRP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date the information for the table
on the record was entered or last updated.
Date: 21-JUN-2004 Page: 77
TABLE: GORDSEC
CREATOR: GENERAL
User Security Repeating table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORDSEC_RECIPIENT_USER_ID VARCHAR2 30 NO RECIPIANT USER ID: User id of security previlages
recipiant.
GORDSEC_DADD_CODE VARCHAR2 15 NO ADD-IN CODE: Add-In code to associate with Wizard name
and Recipiant.
GORDSEC_WIZARD_NAME VARCHAR2 15 NO WIZARD NAME: Wizard name to be associated with
Recipiant.
GORDSEC_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
GORDSEC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date the information for the table
on the record was entered or last updated.
Date: 21-JUN-2004 Page: 78
TABLE: GORDSPR
CREATOR: GENERAL
Wizard Step Properties Repeating table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORDSPR_DADD_CODE VARCHAR2 15 NO ADD-IN CODE: Add-In code to associate with Wizard name
and Step name.
GORDSPR_WIZARD_NAME VARCHAR2 15 NO WIZARD NAME: Wizard name to be associated with SPRp
name.
GORDSPR_STEP_NAME VARCHAR2 30 NO STEP NAME: Step name of the Wizard.
GORDSPR_DPRP_CODE VARCHAR2 15 NO STEP PROPERTY CODE: The code for Step type.
GORDSPR_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
GORDSPR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date the information for the table
on the record was entered or last updated.
GORDSPR_VALUE VARCHAR2 255 YES PROPERTY VALUE: The value of the property of the step.
Date: 21-JUN-2004 Page: 79
TABLE: GORDSTE
CREATOR: GENERAL
Wizard Step Repeating table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORDSTE_DADD_CODE VARCHAR2 15 NO ADD-IN CODE: Add-In code to associate with Wizard name
and Step name.
GORDSTE_WIZARD_NAME VARCHAR2 15 NO WIZARD NAME: Wizard name to be associated with Step
name.
GORDSTE_STEP_NAME VARCHAR2 30 NO STEP NAME: Step name of the Wizard.
GORDSTE_DSTP_CODE VARCHAR2 15 NO STEP TYPE CODE: The code for step type.
GORDSTE_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
GORDSTE_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date the information for the table
on the record was entered or last updated.
Date: 21-JUN-2004 Page: 80
TABLE: GORDSTP
CREATOR: GENERAL
Step Type Property Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORDSTP_DSTP_CODE VARCHAR2 15 NO STEP PROPERTY TYPE CODE: The uniqu step property type
code.
GORDSTP_DPRP_CODE VARCHAR2 15 NO STEP PROPERTY CODE: The step property code to be
associated with Type code.
GORDSTP_LOCK_IND VARCHAR2 1 NO LOCK INDICATOR: Indicates that the property is locked
or not.
GORDSTP_REQUIRED_IND VARCHAR2 1 NO REQUIRED INDICATOR: Indicates that the property is
required or not.
GORDSTP_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
GORDSTP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date theinformation for the table
on the record was entered or last updated.
Date: 21-JUN-2004 Page: 81
TABLE: GORDWIZ
CREATOR: GENERAL
Add-In Wizard Association table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORDWIZ_DADD_CODE VARCHAR2 15 NO ADD-IN CODE: Add-In code to associate with Wizard.
GORDWIZ_WIZARD_NAME VARCHAR2 15 NO WIZARD NAME: Wizard Name associate with Add-In code.
GORDWIZ_WIZARD_DESCRIPTION VARCHAR2 60 NO WIZARD DESCRIPTION: Description of the Wizard.
GORDWIZ_MENU_SEQNO NUMBER 5 2 NO MENU SEQUENCE NUMBER: The number which represents item
position on the Menu.
GORDWIZ_FINAID_IND VARCHAR2 1 NO FINANCIAL AID INDICATOR: Indicates that wizard is
available if Financial Aid is installed.
GORDWIZ_POSBUD_IND VARCHAR2 1 NO POSITION CONTROL INDICATOR: Indicates that wizard is
available if Position Control is installed.
GORDWIZ_BILCSH_IND VARCHAR2 1 NO BILLCSH INDICATOR: Indicates that wizard is available
if Billcsh is installed.
GORDWIZ_HUMANRE_IND VARCHAR2 1 NO HUMAN RESOURCE INDICATOR: Indicates that wizard is
available if Human Resources is installed.
GORDWIZ_FINANCE_IND VARCHAR2 1 NO FINANCE INDICATOR: Indicates that wizard is available
if Finance is installed.
GORDWIZ_ALUMNI_IND VARCHAR2 1 NO ALUMINI INDICATOR: Indicates that wizard is available
if Alumni is installed.
GORDWIZ_STUDENT_IND VARCHAR2 1 NO STUDENT INDICATOR: Indicates that wizard is available
if Student is installed.
GORDWIZ_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
GORDWIZ_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date the information for the table
on the record was entered or last updated.
GORDWIZ_FINISH_FUNCTION VARCHAR2 255 NO FINISH FUNCTION: The name of the function to be
executed when user finish the Wizard step.
GORDWIZ_NEXT_FUNCTION VARCHAR2 255 NO NEXT FUNCTION: The name of the function to be executed
when user go to next step.
GORDWIZ_UNLOAD_FUNCTION VARCHAR2 255 NO UNLOAD FUNCTION: Named function will be run to process
cancellation of currently running wizard at user
request (cancel button pressed).
Date: 21-JUN-2004 Page: 82
TABLE: GOREMAL
CREATOR: GENERAL
Person E-mail repeating table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOREMAL_PIDM NUMBER 8 NO The pidm of the entity who owns this e-mail
information.
GOREMAL_EMAL_CODE VARCHAR2 4 NO The type of e-mail address.
GOREMAL_EMAIL_ADDRESS VARCHAR2 90 NO The e-mail address.
GOREMAL_STATUS_IND VARCHAR2 1 NO The status of the e-mail address: (A)ctive, (I)nactive
GOREMAL_PREFERRED_IND VARCHAR2 1 NO This column indicates if the e-mail address is the
preferred contact address.
GOREMAL_ACTIVITY_DATE DATE 7 NO The date on which the row was added or modified.
GOREMAL_USER_ID VARCHAR2 30 NO The user id when the row was added or modified.
GOREMAL_COMMENT VARCHAR2 60 YES This is a free format comment regarding the e-mail
information.
GOREMAL_DISP_WEB_IND VARCHAR2 1 NO Indicate whether a e-mail address should appear on
Web.
Date: 21-JUN-2004 Page: 83
TABLE: GOREQER
CREATOR: GENERAL
Error Log Event Queue Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOREQER_EQTS_CODE VARCHAR2 10 NO TARGET SYSTEM CODE: Target System Code in the Error
Log.
GOREQER_EQNM_CODE VARCHAR2 20 NO EVENT CODE: Event Code ine the Error Log.
GOREQER_SEQNO NUMBER NO SEQUENCE NUMBER: Error sequence Number generated by
GOBRSEQ sequence.
GOREQER_ERROR_MESSAGE VARCHAR2 2000 NO ERROR MESSAGE: Oracle error Message
GOREQER_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
GOREQER_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
record was entered or updated.
GOREQER_ERROR_NUMBER NUMBER YES ERROR NUMBER: Oracle Error Number
GOREQER_ERROR_SEND_TO VARCHAR2 30 YES SEND TO: User Name to be notified of the Error.
GOREQER_SEVERITY_LEVEL VARCHAR2 1 YES SEVERITY LEVEL: Error Severity level (reserved for
future release).
GOREQER_ERROR_TYPE VARCHAR2 6 YES ERROR TYPE: Error Type ( reserved for future release)
GOREQER_ERROR_STACK VARCHAR2 2000 YES ERROR STACK: Error Stack Messages.
GOREQER_CALL_STACK VARCHAR2 2000 YES CALL STACK: The call stack of pl/sql units( triggers,
procedures).
Date: 21-JUN-2004 Page: 84
TABLE: GOREQNM
CREATOR: GENERAL
Event Queue Name Definition Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOREQNM_EQNM_CODE VARCHAR2 20 NO EVENT CODE: Event Code.
GOREQNM_EQPG_CODE VARCHAR2 10 NO GROUP CODE: Group Code.
GOREQNM_EQTS_CODE VARCHAR2 10 NO TARGET SYSTEM CODE: Target System Code.
GOREQNM_STATUS_IND VARCHAR2 1 NO STATUS INDICATOR: Status Indicator for Events. Valid
Values are (A)ctive and (I)nactive.
GOREQNM_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
GOREQNM_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
record was entered or updated.
Date: 21-JUN-2004 Page: 85
TABLE: GOREQPG
CREATOR: GENERAL
Parameter Group Code Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOREQPG_EQPG_CODE VARCHAR2 10 NO GROUP CODE: Group Code for the Parameter Set
GOREQPG_EQPM_CODE VARCHAR2 100 NO PARAMETER CODE: Parameter Code.
GOREQPG_SEQNO NUMBER 2 NO SEQUENCE NUMBER: Sequence Number for Parameters
attached to the Group Code
GOREQPG_DEFAULT_VALUE VARCHAR2 2000 YES DEFAULT VALUE: Default Value for Parameters
GOREQPG_TARGET_NAME VARCHAR2 100 YES TARGET NAME: Name for the Target Object to receive the
value
GOREQPG_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
GOREQPG_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
record was entered or updated.
Date: 21-JUN-2004 Page: 86
TABLE: GOREQRC
CREATOR: GENERAL
Event Queue Record Maintenance Detail Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOREQRC_SEQNO NUMBER NO SEQUENCE NUMBER:Event Sequence Number.
GOREQRC_PARM_SEQNO NUMBER NO SEQUENCE NUMBER: Parameter Sequence Number.
GOREQRC_PARM_NAME VARCHAR2 100 NO PARAMETER NAME: Parameter Name.
GOREQRC_PARM_VALUE VARCHAR2 2000 NO PARAMETER VALUE: Value for the Parameter
GOREQRC_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
GOREQRC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
record was entered or updated.
Date: 21-JUN-2004 Page: 87
TABLE: GORFLTR
CREATOR: GENERAL
Filter Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORFLTR_SYSI_CODE VARCHAR2 2 NO Product code.
GORFLTR_CATEGORY VARCHAR2 10 NO Category
GORFLTR_GRAPH_SEQ_NO NUMBER 4 NO Sequence number associates with a desired graph.
GORFLTR_GROUP_SEQ_NO NUMBER 4 NO Sequence number associates with a specific grouping of
a graph.
GORFLTR_FILTER_SEQ_NO NUMBER 4 NO Unique sequence number associates with a filtering
column.
GORFLTR_FILTER_LABEL VARCHAR2 30 NO Filtering Label
GORFLTR_FILTER_COLUMN VARCHAR2 30 NO Filtering Column
GORFLTR_DATA_TYPE VARCHAR2 9 NO Column Data Type
GORFLTR_ACTIVITY_DATE DATE 7 NO Date of most recent activity.
GORFLTR_USER VARCHAR2 30 YES User name
Date: 21-JUN-2004 Page: 88
TABLE: GORGCAT
CREATOR: GENERAL
Graphic Function Area by Product Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORGCAT_SYSI_CODE VARCHAR2 2 NO Product Code
GORGCAT_CATEGORY VARCHAR2 10 NO Category.
GORGCAT_CATEGORY_DESC VARCHAR2 30 NO Category Description.
GORGCAT_ACTIVITY_DATE DATE 7 NO Date of most recent activity.
GORGCAT_USER VARCHAR2 30 YES User name
Date: 21-JUN-2004 Page: 89
TABLE: GORGMGR
CREATOR: GENERAL
Access Group Management Control
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORGMGR_SEGC_CODE VARCHAR2 15 NO Access Group Code
GORGMGR_USER_ID VARCHAR2 30 NO ORACLE User ID
GORGMGR_EFF_DATE DATE 7 NO Effective Date of VBS User
GORGMGR_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
Date: 21-JUN-2004 Page: 90
TABLE: GORGMSK
CREATOR: GENERAL
Access Group Rule Assignment Mask
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORGMSK_SEGC_CODE VARCHAR2 15 NO Access Group Code
GORGMSK_VOBJ_CODE VARCHAR2 15 NO VBS Object Code
GORGMSK_VAPP_CODE VARCHAR2 15 NO VBS Secured Item Code
GORGMSK_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
GORGMSK_VAPP_VALUE VARCHAR2 15 NO Secured Item Mask Value
Date: 21-JUN-2004 Page: 91
TABLE: GORGROP
CREATOR: GENERAL
General Horizontal Axis table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORGROP_SYSI_CODE VARCHAR2 2 NO Product Code.
GORGROP_CATEGORY VARCHAR2 10 NO Category.
GORGROP_GRAPH_SEQ_NO NUMBER 4 NO Sequence number associates with a desired graph.
GORGROP_GROUP_SEQ_NO NUMBER 4 NO Sequence number associates with a specific grouping of
a graph.
GORGROP_LABEL VARCHAR2 30 NO Grouping Label.
GORGROP_ACTIVITY_DATE DATE 7 NO Date of most recent activity.
GORGROP_USER VARCHAR2 30 YES User name
Date: 21-JUN-2004 Page: 92
TABLE: GORGRPH
CREATOR: GENERAL
General Vertical Axis table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORGRPH_SYSI_CODE VARCHAR2 2 NO Product Code.
GORGRPH_CATEGORY VARCHAR2 10 NO Category.
GORGRPH_GRAPH_SEQ_NO NUMBER 4 NO Sequence number associates with a desired graph.
GORGRPH_LABEL VARCHAR2 30 NO Graph Label.
GORGRPH_ACTIVITY_DATE DATE 7 NO Date of most recent activity.
GORGRPH_USER VARCHAR2 30 YES User name
Date: 21-JUN-2004 Page: 93
TABLE: GORGRUL
CREATOR: GENERAL
Access Group Rule Association
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORGRUL_SEGC_CODE VARCHAR2 15 NO Access Group Code
GORGRUL_BACR_SEQNO NUMBER 8 NO Access Rule Sequence Number
GORGRUL_ADD_DATE DATE 7 NO Rule Association Add Date
GORGRUL_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
Date: 21-JUN-2004 Page: 94
TABLE: GORGSAV
CREATOR: GENERAL
Graph Saved by a User Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORGSAV_SYSI_CODE VARCHAR2 2 NO Product code.
GORGSAV_CATEGORY VARCHAR2 10 NO Category
GORGSAV_GRAPH_SEQ_NO NUMBER 4 NO Sequence number associates with a desired graph.
GORGSAV_GROUP_SEQ_NO NUMBER 4 NO Sequence number associates with a specific grouping of
a graph.
GORGSAV_USER VARCHAR2 30 NO User name
GORGSAV_QUERY_NAME VARCHAR2 20 NO Name of query.
GORGSAV_GRAPH_TITLE VARCHAR2 70 NO Title of the graph.
GORGSAV_WHERE_TEXT VARCHAR2 2000 NO Where statement to limit data for a graph selected by
a user.
GORGSAV_PUBLIC_IND VARCHAR2 1 NO Pulic indicator. Valid values: (Y)es the graph is
public and can be accessed by other users, (N)o the
graph is not public.
GORGSAV_ACTIVITY_DATE DATE 7 NO Date of most recent activity.
GORGSAV_SELECT_TEXT VARCHAR2 2000 YES Select text.
Date: 21-JUN-2004 Page: 95
TABLE: GORGUSR
CREATOR: GENERAL
Access Group User Association
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORGUSR_SEGC_CODE VARCHAR2 15 NO Access Group Code
GORGUSR_USER_ID VARCHAR2 30 NO ORACLE User ID
GORGUSR_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
Date: 21-JUN-2004 Page: 96
TABLE: GORMEDR
CREATOR: GENERAL
Medical Disability Rule Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORMEDR_MEDI_CODE VARCHAR2 2 NO MEDICAL_CODE: Med Code is associated with the persons
medical condition/physical impairment.
GORMEDR_DISA_CODE VARCHAR2 2 NO DISA_CODE: The codes utilized here identify the nature
of a disability.
GORMEDR_DEFAULT_IND VARCHAR2 1 NO DEFAULT_IND: This indicator will denote whether
disability type will default for the medical code.
GORMEDR_USER_ID VARCHAR2 30 NO USER ID: User ID of the User who created or last
updated the record.
GORMEDR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date the record was created or last
updated.
Date: 21-JUN-2004 Page: 97
TABLE: GORMERC
CREATOR: GENERAL
CREDIT CARD TYPE BY MERCHANT ID Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORMERC_PROC_CODE VARCHAR2 30 NO PROCESS NAME CODE: Process Name Code associated with
the Credit Card Type Code, System Code, and Merchant
ID.
GORMERC_CCRD_CODE VARCHAR2 10 NO CREDIT CARD TYPE CODE: Credit Card Type Code
associated with the Process Name Code, System Code,
and Merchant ID.
GORMERC_SYSI_CODE VARCHAR2 2 NO SYSTEM CODE: System Code associated with the Process
Name Code, Credit Card Type Code, and Merchant ID.
GORMERC_MERCHANT_ID VARCHAR2 20 NO MERCHANT ID: Merchant ID associated with the Process
Name Code, Credit Card Type Code, and System Code.
The Merchant ID is included in the credit card payment
request transmitted to the third-party vendor
handling credit card payments.
GORMERC_DESC VARCHAR2 60 NO DESCRIPTION: Description of the Credit Card Type
associated with the Process Name Code, System Code,
and Merchant ID.
GORMERC_CASHIER_ID VARCHAR2 30 NO CASHIER ID: Cashier ID associated with the Process
Name Code, Credit Card Type Code, System Code, and
Merchant ID. The Cashier ID is used for the
cashiering session when inserting the credit card
payment i
nto SCT Banner.
GORMERC_DETAIL VARCHAR2 20 NO DETAIL: The code used by the credit card payment
process to identify the payment detail, for example a
detail code in Web for Students, or a gift type in Web
for Alumni.
GORMERC_STATUS_IND VARCHAR2 1 NO STATUS INDICATOR: Status Indicator associated with the
Process Name Code, Credit Card Type Code, System Code,
and Merchant Id. A Y in this column indicates that
the record is active, an N indicates that is
is
inactive and is not to be used.
GORMERC_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user creating or updating the record.
GORMERC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the record was created or
updated.
GORMERC_VR_MSG_NO NUMBER 8 YES VOICE RESPONSE MESSAGE NUMBER: Number of message to be
spoken to the user of the Voice Response System
identifying the Credit Card Type.
Date: 21-JUN-2004 Page: 98
TABLE: GORPAUD
CREATOR: GENERAL
Third Party Access Audit Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORPAUD_PIDM NUMBER 8 NO Banner PIDM
GORPAUD_ACTIVITY_DATE DATE 7 NO Date on which the audit trail record was modified.
GORPAUD_USER VARCHAR2 30 NO Oracle User ID of the user who created or last updated
the PIN
GORPAUD_PIN VARCHAR2 6 YES Previous PIN
GORPAUD_EXTERNAL_USER VARCHAR2 30 YES Previous External User.
GORPAUD_CHG_IND VARCHAR2 1 NO Change Indicator. Flag used to indicate why this
audit record was written. P = PIN change, I = User ID
change.
Date: 21-JUN-2004 Page: 99
TABLE: GORPGEO
CREATOR: GENERAL
Geographic Regions/Divisions for persons address.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORPGEO_PIDM NUMBER 8 NO PIDM for whom the Region/Division is defined for.
GORPGEO_ATYP_CODE VARCHAR2 2 NO Address type of SPRADDR row the Region/Division is
defined for.
GORPGEO_ADDR_SEQNO NUMBER 2 NO Sequence number of SPRADDR row the Region/Division is
defined for.
GORPGEO_GEOR_CODE VARCHAR2 10 NO This field specifies the geographic region code for
the PIDM and
address.
GORPGEO_GEOD_CODE VARCHAR2 10 NO This field specifies the geographic division code the
region, PIDM and
address.
GORPGEO_SOURCE_IND VARCHAR2 1 NO A value of S indicates the geographic region/division
was created from
the BANNER process GORPGEO.pc and
with rules defined on SORGEOR.
A value of U indicates
the value was manually entered on the form
GOAPGEO.
GORPGEO_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created
GORPGEO_STATUS_IND VARCHAR2 1 YES Null value indicates geographic region/division are
active for PIDM and
address. Value of I indicates an
inactive status.
GORPGEO_FROM_DATE DATE 7 YES
GORPGEO_TO_DATE DATE 7 YES
GORPGEO_USERID VARCHAR2 30 NO This field identifies the user who most recently
changed the record.
Date: 21-JUN-2004 Page: 100
TABLE: GORPPRM
CREATOR: GENERAL
Third-Party Function Parameters Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORPPRM_PACKAGE VARCHAR2 80 NO Name of package and procedure.
GORPPRM_SEQ NUMBER NO Sequence number of parameter.
GORPPRM_NAME VARCHAR2 30 NO Parameter value used by procedure.
GORPPRM_KEY_POS NUMBER NO Position in data string in which the parameter
resides.
GORPPRM_OUTPUT_IND VARCHAR2 1 NO Flag indicating whether data contained in parameter is
to be included in the output string.
GORPPRM_TYPE_IND VARCHAR2 1 NO Type of data contained in the parameter, e.g.
character or number.
GORPPRM_MIN_LEN NUMBER NO Minimum length of data contained in parameter.
GORPPRM_MAX_LEN NUMBER NO Maximum length of data contained in parameter.
GORPPRM_SYS_REQ_IND VARCHAR2 1 NO System Required Indicator. Indicates whether the
record is required by the SCT system.
GORPPRM_ACTIVITY_DATE DATE 7 NO Date on which the record was last updated or created.
GORPPRM_USER_ID VARCHAR2 30 NO User ID of the person who updates this record.
Date: 21-JUN-2004 Page: 101
TABLE: GORRAVL
CREATOR: GENERAL
VBS Access Rule Secured Values
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORRAVL_VOBJ_CODE VARCHAR2 15 NO VBS Object Code
GORRAVL_BACR_SEQNO NUMBER 8 NO Access Rule Sequence Number
GORRAVL_VAPP_CODE VARCHAR2 15 NO VBS Secured Item Code
GORRAVL_PATTERN_CTRL NUMBER 4 NO VBS PAttern Control Seed Number
GORRAVL_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
GORRAVL_VAPP_VALUE VARCHAR2 15 NO VBS Secured Item Value
Date: 21-JUN-2004 Page: 102
TABLE: GORRSQL
CREATOR: GENERAL
SQL Process Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORRSQL_SQPR_CODE VARCHAR2 30 NO SQL PROCESS CODE: Process code for dynamic SQL
processing.
GORRSQL_SQRU_CODE VARCHAR2 30 NO SQL RULE CODE: Rule code for dynamic SQL processing.
GORRSQL_SEQ_NO NUMBER 5 NO SQL RULE SEQUENCE NUMBER: Sequence for SEVIS SQL rule
for uniqueness and process order.
GORRSQL_ACTIVE_IND VARCHAR2 1 NO ACTIVE INDICATOR: Indicator to show if the rule is
currently active.
GORRSQL_VALIDATED_IND VARCHAR2 1 NO VALIDATED INDICATOR: Indicator to show if the SQL has
been validated.
GORRSQL_START_DATE DATE 7 NO START DATE: Date that the rule becomes effective.
GORRSQL_SELECT_FROM VARCHAR2 4000 NO SELECT FROM VALUE: Tables and views that are in the
FROM portion of the SQL statement.
GORRSQL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The most recent date a record was
created or updated
GORRSQL_USER_ID VARCHAR2 30 NO USER ID: The most recent user to create or update a
record.
GORRSQL_SELECT_VALUE VARCHAR2 4000 YES SELECT VALUE: Value that is in the SELECT portion of
the SQL statement.
GORRSQL_WHERE_CLAUSE CLOB 4000 YES WHERE CLAUSE: WHERE clause of the SQL statement.
GORRSQL_END_DATE DATE 7 YES END DATE: Date that the rule becomes obsolete.
GORRSQL_PARSED_SQL CLOB 4000 YES PARSED SQL: Parsed SQL statement.
Date: 21-JUN-2004 Page: 103
TABLE: GORSEVD
CREATOR: GENERAL
SEVIS Reporting Dependent Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORSEVD_PIDM NUMBER 8 NO PERSONAL ID NUMBER: PIDM of person for whom the
dependent is being estasblished.
GORSEVD_SEQ_NO NUMBER 2 NO SEQUENCE NUMBER: Sequence number for GORSEVD key
uniqueness.
GORSEVD_RELT_CODE VARCHAR2 3 NO RELATIONSHIP CODE: Dependent relationship code
GORSEVD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The most recent date a record was
created or updated
GORSEVD_USER_ID VARCHAR2 30 NO USER ID: The most recent user to create or update a
record.
GORSEVD_DEP_PIDM NUMBER 8 YES DEPENDENT PIDM: Dependent's pidm.
GORSEVD_DEP_LAST_NAME VARCHAR2 40 YES LAST NAME: Dependent's last name.
GORSEVD_DEP_FIRST_NAME VARCHAR2 25 YES FIRST NAME: Dependent's first name.
GORSEVD_DEP_MIDDLE_NAME VARCHAR2 25 YES MIDDLE NAME: Dependent's middle name.
GORSEVD_DEP_BIRTH_NATN_CODE VARCHAR2 5 YES BIRTH NATION CODE: Code for the dependent's country of
birth
GORSEVD_DEP_LEGAL_NATN_CODE VARCHAR2 5 YES LEGAL NATION CODE: Code for the dependent's country of
citizenship
GORSEVD_DEP_BIRTH_DATE DATE 7 YES BIRTH DATE: Dependent's birth date
GORSEVD_DEP_SEVIS_ID VARCHAR2 11 YES SEVIS ID: Dependent's SEVIS-assigned identifier
GORSEVD_SVDT_CODE VARCHAR2 2 YES DEPENDENT TERMINATION REASON CODE: Code to show the
reason that a dependent was terminated
GORSEVD_GENDER VARCHAR2 1 YES GENDER: Dependent gender
GORSEVD_VTYP_CODE VARCHAR2 2 YES VISA TYPE CODE: Banner code for the dependent's visa
type
GORSEVD_DEP_BIRTH_CITY VARCHAR2 200 YES BIRTH CITY: City of Birth for dependent.
GORSEVD_NATN_CODE_PERM_RES VARCHAR2 5 YES PERMANENT RESIDENCE COUNTRY CODE: Banner code for the
dependent's nation of peranent residence.
GORSEVD_TERMINATE_EFF_DATE DATE 7 YES EFFECTIVE DATE: Terminate dependent effective date.
GORSEVD_DEP_COMMENT VARCHAR2 500 YES DEPENDENT REMARKS: Dependent remarks
GORSEVD_SVDT_COMMENT VARCHAR2 500 YES TERMINATION REASON: Reason for termination of EV
dependent.
GORSEVD_DEP_NAME_SUFFIX VARCHAR2 3 YES NAME SUFFIX: Dependent's name suffix
Date: 21-JUN-2004 Page: 104
TABLE: GORSEVH
CREATOR: GENERAL
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORSEVH_PIDM NUMBER 8 NO
GORSEVH_SEVIS_SEQ_NO NUMBER 3 NO
GORSEVH_SEQ_NO NUMBER 3 NO
GORSEVH_RELT_CDE VARCHAR2 3 NO
GORSEVH_ACTIVITY_DATE DATE 7 NO
GORSEVH_USER_ID VARCHAR2 30 NO
GORSEVH_DEP_PIDM NUMBER 8 YES
GORSEVH_DEP_LAST_NAME VARCHAR2 40 YES
GORSEVH_DEP_FIRST_NAME VARCHAR2 25 YES
GORSEVH_DEP_MIDDLE_NAME VARCHAR2 25 YES
GORSEVH_DEP_BIRTH_NATN_CDE VARCHAR2 2 YES
GORSEVH_DEP_LEGAL_NATN_CDE VARCHAR2 2 YES
GORSEVH_DEP_BIRTH_DATE DATE 7 YES
GORSEVH_DEP_SEVIS_ID VARCHAR2 11 YES
GORSEVH_SVDT_CODE VARCHAR2 2 YES
GORSEVH_GENDER VARCHAR2 1 YES GENDER: Dependent gender
GORSEVH_VTYP_CDE VARCHAR2 2 YES VISA TYPE CODE: SEVIS equivalency code for the
dependent's visa type
GORSEVH_DEP_BIRTH_CITY VARCHAR2 200 YES BIRTH CITY: City of Birth for dependent.
GORSEVH_NATN_CDE_PERM_RES VARCHAR2 2 YES PERMANENT RESIDENCE COUNTRY CODE: Bannercode for the
dependent's nation of peranent residence.
GORSEVH_TERMINATE_EFF_DATE DATE 7 YES EFFECTIVE DATE: Terminate dependent effective date.
GORSEVH_DEP_COMMENT VARCHAR2 500 YES DEPENDENT REMARKS: Dependent remarks
GORSEVH_SVDT_COMMENT VARCHAR2 500 YES TERMINATION REASON: Reason for termination of
dependent.
GORSEVH_DEP_NAME_SUFFIX VARCHAR2 3 YES NAME SUFFIX: Dependent's name suffix
Date: 21-JUN-2004 Page: 105
TABLE: GORSEVS
CREATOR: GENERAL
SEVIS Reporting repeating history table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORSEVS_PIDM NUMBER 8 NO PERSONAL ID NUMBER: Internal identification number of
the person
GORSEVS_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: Record sequence number
GORSEVS_SUBMIT_DATE DATE 7 NO SUBMISSION DATE: Date the record was submitted to
SEVIS
GORSEVS_ENG_PROF_REQ_IND VARCHAR2 1 NO ENGLISH PROFICIENCY REQUIRED INDICATOR: Is English
required for the program
GORSEVS_ENG_PROF_MET_IND VARCHAR2 1 NO ENGLICH PROFICIENCY MET INDICATOR: Has the English
requirement been met
GORSEVS_CRIMINAL_CONVICT_IND VARCHAR2 1 NO CRIMINAL CONVICTION INDICATOR: Indicator to show that
the student has a criminal conviction
GORSEVS_TERMINATE_STUDENT_IND VARCHAR2 1 NO STUDENT TERMINATION INDICATOR: Indicator to show if
the student was terminated
GORSEVS_EXTEND_FAILURE_IND VARCHAR2 1 NO EXCHANGE VISITOR EXTENSION FAILURE INDICATOR:
Indicator to show if the exchange visitor failed to
extend the program
GORSEVS_TRANSFER_FAIL_IND VARCHAR2 1 NO TRANSFER FAILURE INDICATOR: Indicator to show if a
transfer of an exchange visitor has failed
GORSEVS_APPROVAL_FAIL_IND VARCHAR2 1 NO TRANSFER APPROVAL FAILURE INDICATOR: Indicator to show
if there was a failure to secure approval for a
transfer
GORSEVS_OTHER_INFRACT_IND VARCHAR2 1 NO OTHER INFRACTIONS INDICATOR: Indicator to show that
the exchange visitor has received other, minor
disciplinary actions
GORSEVS_TRANS_CDE VARCHAR2 10 YES SEVIS TRANSACTION CODE: Transaction code for the
record submitted
GORSEVS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The most recent date a record was
created or updated
GORSEVS_USER_ID VARCHAR2 30 NO USER ID: The most recent user to create or update a
record.
GORSEVS_FIRST_NAME VARCHAR2 25 YES FIRST NAME: First name of the student/exchange visitor
GORSEVS_MI VARCHAR2 25 YES MIDDLE NAME: Middle name of the student/exchange
visitor
GORSEVS_LAST_NAME VARCHAR2 40 YES LAST NAME: Last name of the student/exchange visitor
GORSEVS_BIRTH_DATE DATE 7 YES BIRTH DATE: Date of birth of the student/exchange
visitor
GORSEVS_BIRTH_NATN_CDE VARCHAR2 2 YES BIRTH NATION CODE: SEVIS country code of birth of the
student/exchange visitor
GORSEVS_LEGAL_NATN_CDE VARCHAR2 2 YES LEGAL NATION CODE: SEVIS country code of citizenship
of the student/exchange visitor
GORSEVS_USA_STREET_LINE1 VARCHAR2 60 YES USA STREET LINE 1: USA address street line 1
GORSEVS_USA_STREET_LINE2 VARCHAR2 60 YES USA STREET LINE 2: USA address street line 2
GORSEVS_USA_CITY VARCHAR2 60 YES USA CITY: USA address city
GORSEVS_USA_STAT_CODE VARCHAR2 2 YES USA STATE: USA address state code
GORSEVS_USA_ZIP VARCHAR2 9 YES USA ZIP: USA address zipcode
Date: 21-JUN-2004 Page: 106
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORSEVS_NONUSA_STREET_LINE1 VARCHAR2 60 YES NON-USA STREET LINE 1: Non-USA address street line1
GORSEVS_NONUSA_STREET_LINE2 VARCHAR2 60 YES NON-USA STREET LINE 2: Non-USA address street line 2
GORSEVS_NONUSA_CITY VARCHAR2 60 YES NON-USA CITY: Non-USA address city
GORSEVS_NONUSA_STATE VARCHAR2 34 YES NON-USA STATE/PROVINCE: Non-USA address province
GORSEVS_NONUSA_ZIP VARCHAR2 20 YES NON-USA POSTAL CODE: Non-USA address postal code
GORSEVS_NONUSA_NATN_CDE VARCHAR2 2 YES FOREIGN COUNTRY CODE: Non-USA address SEVIS country
code
GORSEVS_PROGRAM_BEGIN_DATE DATE 7 YES PROGRAM BEGIN DATE: Date the program begins
GORSEVS_PROGRAM_END_DATE DATE 7 YES PROGRAM END DATE: Date the program ends
GORSEVS_PROGRAM_ENROLL_DATE DATE 7 YES ENROLLED DATE: Date the person enrolled in the program
GORSEVS_ENG_PROF_REASON VARCHAR2 500 YES REASON ENGLISH PROFICIENCY NOT REQUIRED: Reason
English is not required for the program
GORSEVS_ACADEMIC_TERM_MONTHS NUMBER 3 YES ACADEMIC TERM LENGTH: Length of the academic term in
months
GORSEVS_TUITION_EXPENSE NUMBER 12 2 YES TUITION EXPENSES: Tuition expenses for the length of
the program
GORSEVS_PERSONAL_FUNDS NUMBER 12 2 YES PERSONAL FUNDS: Funds provided by the student/exchange
visitor
GORSEVS_SEVIS_ID VARCHAR2 11 YES SEVIS ID: ID for the person as assigned by SEVIS
GORSEVS_VTYP_CDE VARCHAR2 2 YES VISA TYPE: SEVIS code for the Visa type requested for
the person
GORSEVS_SVCR_CODE VARCHAR2 4 YES CREATE REASON CODE: Code for the reason to create
record
GORSEVS_SESSION_START_DATE DATE 7 YES SESSION START DATE: Date on which the session starts
GORSEVS_SESSION_END_DATE DATE 7 YES SESSION END DATE: Date on which the session ends
GORSEVS_TRANSFER_COMMENT VARCHAR2 500 YES TRANSFER COMMENTS: Comments from the school about a
transfer student
GORSEVS_ISSUE_COMMENT VARCHAR2 500 YES ISSUE COMMENTS: Additional comments about the reason
to issue the Visa to the person
GORSEVS_SVEL_CODE VARCHAR2 2 YES EDUCATIONAL LEVEL: Code for the educational level of
the person
GORSEVS_MAJR_CDE VARCHAR2 7 YES PRIMARY MAJOR: SEVIS primary major equivalency code of
the student
GORSEVS_STUDY_LENGTH NUMBER 3 YES PROGRAM OF STUDY LENGTH: Length of the student's
program in months
GORSEVS_LIVING_EXPENSES NUMBER 12 2 YES LIVING EXPENSES: Dollar amount of the student's living
expenses
GORSEVS_SVFT_CODE VARCHAR2 2 YES DROP BELOW FULL TIME CODE: Code to indicate the reason
the student dropped below full time
GORSEVS_AUTH_START_DATE DATE 7 YES AUTHORIZATION START DATE: Date on which the student
was authorized to drop below full time
GORSEVS_COMPLETION_REMARKS VARCHAR2 500 YES COMPLETION REMARKS: Comments regarding the student's
completion of the program
GORSEVS_NEW_PROGRAM_END_DATE DATE 7 YES PROGRAM CHANGED END DATE: New program end date as the
result of a change
GORSEVS_DA_PROGRAM_START_DATE DATE 7 YES PROGRAM DEFERRED START DATE: New program start date as
the result of deferred attendance
GORSEVS_DA_PROGRAM_END_DATE DATE 7 YES PROGRAM DEFERRED END DATE: New program end date as the
result of deferred attendance
GORSEVS_DISC_ACTION_TEXT VARCHAR2 500 YES DISCIPLINARY ACTION COMMENTS: Comments to explain the
disciplinary action against the student
Date: 21-JUN-2004 Page: 107
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORSEVS_EMPLOYMENT_CDE VARCHAR2 2 YES STUDENT EMPLOYMENT CODE: Code to show if the student
is employed
GORSEVS_EMPLOYMENT_COMMENT VARCHAR2 500 YES STUDENT EMPLOYMENT COMMENTS: Comments to allow the
school to explain the recommendation for the students
employment
GORSEVS_EMPLOYMENT_START_DATE DATE 7 YES EMPLOYMENT START DATE: Start date of the student's
employment
GORSEVS_EMPLOYMENT_END_DATE DATE 7 YES EMPLOYMENT END DATE: End date of the student's
employment
GORSEVS_EMPLOYMENT_TYPE_CDE VARCHAR2 2 YES EMPLOYMENT TYPE CODE: Code to show the type of
employment for the student
GORSEVS_EMPLOYER_LAST_NAME VARCHAR2 500 YES EMPLOYER LAST NAME: Last name of the student's
employer
GORSEVS_EMPLOYER_FIRST_NAME VARCHAR2 40 YES EMPLOYER FIRST NAME: First name of the student's
employer
GORSEVS_EMP_ADDRESS_LINE1 VARCHAR2 60 YES EMPLOYER ADDRESS LINE 1: First line of the student's
employer address
GORSEVS_EMP_ADDRESS_LINE2 VARCHAR2 60 YES EMPLOYER ADDRESS LINE 2: Second line of the student's
employer address
GORSEVS_EMPLOYER_CITY VARCHAR2 60 YES EMPLOYER CITY: City of the student's employer
GORSEVS_EMPLOYER_STATE VARCHAR2 2 YES EMPLOYER STATE: State of the student's employer
GORSEVS_EMPLOYER_ZIP VARCHAR2 9 YES EMPLOYER ZIP: Zip code of the student's employer
GORSEVS_COURSE_RELEVANCE VARCHAR2 500 YES COURSE RELEVANCE COMMENTS: Comments to explain the
employment and its relevance to the student's course
work
GORSEVS_EXTEND_END_DATE DATE 7 YES EXTENSION END DATE: The new program end date due to an
extension
GORSEVS_SVTR_CODE VARCHAR2 6 YES TERMINATION REASON CODE: Code to show the reason why
the student/exchange visitor was terminated
GORSEVS_TERMINATE_DATE DATE 7 YES TERMINATION DATE: Date on which the student/exchange
visitor was terminated
GORSEVS_APPROVAL_FAIL_COMMENT VARCHAR2 500 YES TRANSFER APPROVAL FAILURE COMMENTS: Comments about the
failure to obtain approval for a transfer
GORSEVS_OTHER_INFRACT_COMMENT VARCHAR2 500 YES OTHER INFRACTIONS COMMENTS: Comments to explain the
other minor infractions received by the exchange
visitor
GORSEVS_SVEP_CODE VARCHAR2 4 YES EXCHANGE VISITOR PROGRAM END CODE: Code to show why
the exchange visitor's program has ended
GORSEVS_END_PROGRAM_EFF_DATE DATE 7 YES EXCHANGE VISITOR PROGRAM END DATE: Date on which the
exchange visitor's program ended
GORSEVS_EV_FORM_NUMBER VARCHAR2 40 YES EXCHANGE VISITOR FORM NUMBER: Exchange visitor's form
number
GORSEVS_SVRP_CODE VARCHAR2 2 YES REASON FOR FORM REPRINT:Code to show a reason for the
reprint of the exchange visitor's form
GORSEVS_REPRINT_REASON_COMMENT VARCHAR2 500 YES REASON FOR FORM REPRINT COMMENTS: Comments to explain
the need for a form reprint
GORSEVS_CREATE_DATE DATE 7 YES CREATION DATE: Date the record was created
GORSEVS_STATUS_CDE VARCHAR2 20 YES RETURNED SEVIS STATUS CODE: Status code for record
returned from SEVIS
GORSEVS_RESULT_CODE_MESSAGE VARCHAR2 500 YES RESULT CODE MESSAGE: Message accompanying status code
returned from SEVIS
GORSEVS_SVTS_CODE VARCHAR2 1 NO TRANSMITTAL STATUS CODE: Transmittal status code from
GTVSVTS.
Date: 21-JUN-2004 Page: 108
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORSEVS_SVCR_COMMENT VARCHAR2 500 YES CREATE REASON COMMENT: Create reason comment
GORSEVS_PRINT_REQUEST_IND VARCHAR2 1 NO PRINT REQUEST INDICATOR: Print request indicator
GORSEVS_DEPENDENT_EXPENSES NUMBER 12 2 YES DEPENDENT EXPENSES: Student dependent expenses.
GORSEVS_OTHER_FUNDS NUMBER 12 2 YES OTHER FUNDS: Amount of funds from other sources.
GORSEVS_OTHER_FUNDS_COMMENT VARCHAR2 500 YES OTHER FUNDS DESCRIPTION: Description of the other
sources of funding.
GORSEVS_OTHER_EXPENSES NUMBER 12 2 YES OTHER EXPENSES: Expenses from other sources.
GORSEVS_OTHER_EXP_COMMENT VARCHAR2 500 YES OTHER EXPENSES DESCRIPTION: Description of the other
expenses.
GORSEVS_AUTH_END_DATE DATE 7 YES AUTHORIZATION END DATE: Date when the student ended
less than full time study.
GORSEVS_NEW_PROGRAM_START_DATE DATE 7 YES NEW PROGRAM START DATE: Date when the new program will
begin.
GORSEVS_SVPC_CODE VARCHAR2 3 YES POSITION CODE: Exchange visitor position code.
GORSEVS_SVSC_CODE VARCHAR2 7 YES SUBJECT CODE: Exchange visitior subject code.
GORSEVS_SVSC_COMMENT VARCHAR2 500 YES SUBJECT REMARKS: Remarks for the subject of field of
study.
GORSEVS_GENDER VARCHAR2 1 YES GENDER: Gender of the person.
GORSEVS_NAME_SUFFIX VARCHAR2 3 YES NAME SUFFIX: Name suffix.
GORSEVS_COMMUTER_IND VARCHAR2 1 NO COMMUTER INDICATOR: Denotes whether or not a student
commutes from a foreign country. If Y, then, no USA
address is required.
GORSEVS_ADMISSION_NUMBER VARCHAR2 11 YES ADMISSION NUMBER: I-94 admission number.
GORSEVS_DRIVERS_LIC_NUMBER VARCHAR2 30 YES DRIVER'S LICENSE NUMBER: Student's driver's license
number.
GORSEVS_STAT_CODE_DRIVERS_LIC VARCHAR2 2 YES DRIVER'S LICENSE STATE: State of the student's
driver's license.
GORSEVS_SSN VARCHAR2 9 YES SSN: Student's social security number.
GORSEVS_TIN VARCHAR2 9 YES TIN: Student's tax ID number.
GORSEVS_MAJR_CDE_2 VARCHAR2 7 YES SECONDARY MAJOR: SEVIS code for secondary major from
STVMAJR.
GORSEVS_MAJR_CDE_MINR VARCHAR2 7 YES MINOR: SEVIS code for Minor from STVMAJR.
GORSEVS_SCHOOL_FUNDS NUMBER 12 2 YES SCHOOL FUNDS: Amount of funding provided by the
school.
GORSEVS_SCHOOL_FUNDS_COMMENT VARCHAR2 500 YES SCHOOL FUNDING REMARKS: Explanation of school funding.
GORSEVS_EMPLOYMENT_FUNDS NUMBER 12 2 YES EMPLOYMENT FUNDING: Funds received from on-campus
employment.
GORSEVS_FUNDING_COMMENT VARCHAR2 500 YES FUNDING COMMENT: General comment on funding.
GORSEVS_SVFT_COMMENT VARCHAR2 500 YES DROP BELOW FT REMARKS: Drop below full time remarks.
GORSEVS_SVEP_COMMENT VARCHAR2 500 YES EXTEND PROGRAM REMARKS: Program extension remarks.
GORSEVS_DA_COMMENT VARCHAR2 500 YES DEFER ATTENDENCE REMARKS: Comments about the deferred
attendence.
GORSEVS_SVTR_COMMENT VARCHAR2 500 YES TERMINATION REMARKS: Termination remarks.
GORSEVS_PASSPORT_NUMBER VARCHAR2 25 YES PASSPORT NUMBER: Passport number.
GORSEVS_NATN_CDE_PASSPORT VARCHAR2 2 YES PASSPORT ISSUE NATION: The SEVIS code of the nation
that issued the passport.
GORSEVS_PASSPORT_EXPIRE_DATE DATE 7 YES PASSPORT EXPIRATION DATE: Passport expiration date.
GORSEVS_VISA_NUMBER VARCHAR2 25 YES VISA NUMBER: Visa number.
GORSEVS_SVCP_CODE VARCHAR2 3 YES VISA CONSULAR POST: Code of the consular post that
issued the visa.
GORSEVS_VISA_EXPIRE_DATE DATE 7 YES VISA EXPIRE DATE: Date when the visa expires.
Date: 21-JUN-2004 Page: 109
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORSEVS_PENT_CDE VARCHAR2 3 YES PORT OF ENTRY: SEVIS code for port of entry.
GORSEVS_PENT_COMMENT VARCHAR2 500 YES PORT OF ENTRY COMMENTS: Port of entry comments.
GORSEVS_ENTRY_DATE DATE 7 YES DATE OF ENTRY: Date of entry.
GORSEVS_EMPL_AUTH_IND VARCHAR2 1 NO EMPLOYMENT AUTHORITY: Indicator to show that a
recommendation for employment exists.
GORSEVS_RESCIND_REC_IND VARCHAR2 1 NO RESCIND: Indicator to show that a rescind exists.
GORSEVS_RFC_COMMENT VARCHAR2 500 YES RESUME FULL COURSE REMARKS: Resume full course
comments.
GORSEVS_EDIT_PROGRAM_COMMENT VARCHAR2 500 YES EDIT PROGRAM COMMENTS: Remarks about why program
information was edited.
GORSEVS_EMPLOYMENT_TIME_CDE VARCHAR2 2 YES EMPLOYMENT TIME CODE: Employment time code indicates
full or part-time status.
GORSEVS_ACT_SITE_ADDR_LINE1 VARCHAR2 60 YES ACTIVITY SITE ADDRESS LINE 1: Line 1 of the address
for the site of activity.
GORSEVS_ACT_SITE_ADDR_LINE2 VARCHAR2 60 YES ACTIVITY SITE ADDRESS LINE 2: Line 2 of the address
for the site of activity.
GORSEVS_ACT_SITE_CITY VARCHAR2 60 YES SITE OF ACTIVITY CITY: City of the site of activity.
GORSEVS_STAT_CODE_ACT_SITE VARCHAR2 2 YES SITE OF ACTIVITY STATE: State code of the site of
activity.
GORSEVS_ACT_SITE_ZIP VARCHAR2 9 YES SITE OF ACTIVITY ZIP: Zip code of the site of
activity.
GORSEVS_PROGRAM_SPONSOR_FUNDS NUMBER 12 2 YES PROGRAM SPONSOR FUNDS: The amount of financial support
from the program sponsor.
GORSEVS_GOVT_ORG_FUNDS NUMBER 12 2 YES GOVERNMENT ORG 1 FUNDS: Funds received from a
government organization.
GORSEVS_SVGO_CODE VARCHAR2 6 YES GOVERNMENT ORG 1 CODE: Code to describe the government
organization.
GORSEVS_GOVT_ORG_FUNDS_2 NUMBER 12 2 YES GOVERNMENT ORG 2 FUNDS: Funds received from a
government organization.
GORSEVS_SVGO_CODE_2 VARCHAR2 6 YES GOVERNMENT ORG 2 CODE: Code to describe the government
organization.
GORSEVS_INTL_ORG_FUNDS NUMBER 12 2 YES INTERNATIONAL ORG 1 FUNDS: Funds received from an
international organization.
GORSEVS_SVIO_CODE VARCHAR2 6 YES INTERNATIONAL ORG 1 CODE: Code to describe the
international organization.
GORSEVS_INTL_ORG_FUNDS_2 NUMBER 12 2 YES INTERNATIONAL ORG 2 FUNDS: Funds received from an
international organization.
GORSEVS_SVIO_CODE_2 VARCHAR2 6 YES INTERNATIONAL ORG 2 CODE: Code to describe the
international organization.
GORSEVS_EV_GOVT_FUNDS NUMBER 12 2 YES EV GOVERNMENT FUNDS: Funds provided by the exchange
visitor's government.
GORSEVS_BINATION_FUNDS NUMBER 12 2 YES BI-NATIONAL COMMISSION FUNDS: Funds provided by a
bi-national commission.
GORSEVS_OTHER_ORG_FUNDS NUMBER 12 2 YES OTHER ORGANIZATION FUNDS: Funds provided by another
type of organization.
GORSEVS_PROGRAM_START_IND VARCHAR2 1 NO PROGRAM START INDICATOR: Indicator to show if the
exchange visitor started the program.
GORSEVS_EXTEND_PROGRAM_COMMENT VARCHAR2 500 YES EXTEND PROGRAM REMARKS: Comments to explain why a
program was extended.
GORSEVS_AMEND_PROGRAM_COMMENT VARCHAR2 500 YES AMEND PROGRAM REMARKS: Comments to explain how a
program was amended.
Date: 21-JUN-2004 Page: 110
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORSEVS_MATRICULATION_CDE VARCHAR2 2 YES MATRICULATION CODE: Matriculation code.
GORSEVS_EXTEND_FAILURE_COMMENT VARCHAR2 500 YES EXTEND FAUILURE END REMARKS: Comments to explain an
extension failure.
GORSEVS_CONCLUDE_TRANS_COMMENT VARCHAR2 500 YES CONCLUDE FAILURE REMARKS: Comments to explain why a
transfer was not concluded.
GORSEVS_BIRTH_CITY VARCHAR2 200 YES EV BIRTH CITY: Exchange visitor birth city.
GORSEVS_NATN_CDE_PERM_RES VARCHAR2 2 YES PERMANENT RESIDENCY NATION: Code to show the country
of permanent residency.
GORSEVS_EDIT_BIO_COMMENT VARCHAR2 500 YES EDIT BIO COMMENT: Comments to explain why biographical
data was edited.
GORSEVS_STRUCTURE_UPDATE VARCHAR2 40 YES STRUCTURE UPDATE: Structure that is updated with the
transmittal record.
GORSEVS_ZIP_ROUTING_CDE VARCHAR2 4 YES
GORSEVS_US_FUNDS_IND VARCHAR2 1 NO RECEIVED US GOVT FUNDS IND: Received US government
funds, 1=Yes, 0=No
GORSEVS_FIN_SUPPORT_COMMENT VARCHAR2 500 YES FINANCIAL SUPPORT COMMENT: Financial support remarks.
GORSEVS_SVIT_CODE VARCHAR2 3 YES INFRACTION CODE: SEVIS infraction code
GORSEVS_ACT_SITE_NAME VARCHAR2 60 YES ACTIVITY SITE NAME: Name to identify the site of
activity.
GORSEVS_ACT_SITE_COMMENT VARCHAR2 500 YES ACTIVITY SITE COMMENT: Remarks used when adding or
deleting the site of activity.
GORSEVS_SVCC_CODE VARCHAR2 3 YES CATEGORY CODE: SEVIS category code used in EV
reporting.
GORSEVS_SVEL_COMMENT VARCHAR2 500 YES EDUCATION LEVEL COMMENT: Education level comment.
GORSEVS_REQUEST_ID VARCHAR2 20 YES Unique SEVIS request ID composed of batch ID
concatenated with a sequence number.
GORSEVS_SCHOOL_CDE VARCHAR2 15 YES SEVIS-assigned school ID number.
GORSEVS_PROGRAM_CDE VARCHAR2 9 YES SEVIS-assigned EV program ID number.
GORSEVS_OFFICER_ID VARCHAR2 10 YES SEVIS-assigned ID number for data approver.
Date: 21-JUN-2004 Page: 111
TABLE: GORSGEO
CREATOR: GENERAL
Geographic Regions/Divisions for SBGI.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORSGEO_SBGI_CODE VARCHAR2 6 NO Source Background Institution Code Regions/Divisions
are defined for.
GORSGEO_GEOR_CODE VARCHAR2 10 NO This field specifies the geographic region code for
the SBGI.
GORSGEO_GEOD_CODE VARCHAR2 10 NO This field specifies the geographic division code the
region and SBGI.
GORSGEO_STATUS_IND VARCHAR2 1 YES Null value indicates geographic region/division are
active for SBGI address.
Value of I indicates an
inactive status.
GORSGEO_SOURCE_IND VARCHAR2 1 NO A value of S indicates the geo region/division were
created from the
BANNER process gorsgeo.pc and with
rules defined on SORGEOR. A value of U
indicates the
value was manually entered on the form SOASGEO.
GORSGEO_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created
GORSGEO_USERID VARCHAR2 30 NO This field identifies the user who most recently
changed the record.
Date: 21-JUN-2004 Page: 112
TABLE: GORSLCT
CREATOR: GENERAL
Select Statement Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORSLCT_SYSI_CODE VARCHAR2 2 NO Product code.
GORSLCT_CATEGORY VARCHAR2 10 NO Category.
GORSLCT_GRAPH_SEQ_NO NUMBER 4 NO Sequence number associates with a desired graph.
GORSLCT_GROUP_SEQ_NO NUMBER 4 NO Sequence number associates with a specific grouping of
a graph.
GORSLCT_SELECT_TEXT VARCHAR2 2000 NO Select text.
GORSLCT_ACTIVITY_DATE DATE 7 NO Date of most recent activity.
GORSLCT_USER VARCHAR2 30 YES User name
Date: 21-JUN-2004 Page: 113
TABLE: GORSQPA
CREATOR: GENERAL
SQL Process Parameter Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORSQPA_SQPR_CODE VARCHAR2 30 NO PROCESS CODE: SQL Process code
GORSQPA_SQPA_CODE VARCHAR2 30 NO PARAMETER CODE: Parameter code associated with the SQL
process code.
GORSQPA_SYS_REQ_IND VARCHAR2 1 NO SYSTEM REQUIRED INDICATOR: Indicates whether or not
this parameter is system required.
GORSQPA_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The most recent date a record was
created or updated
GORSQPA_USER_ID VARCHAR2 30 NO USER ID: The most recent user to create or update a
record.
Date: 21-JUN-2004 Page: 114
TABLE: GORSRVR
CREATOR: GENERAL
Survey Repsonses Repeating Table. This tables store the individual responses.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORSRVR_PIDM NUMBER 8 NO Internal Identification Number of the person who
responded to the survey.
GORSRVR_NAME VARCHAR2 15 NO Survey Name.
GORSRVR_QUESTION_NO NUMBER 3 NO Survey Response Question Number.
GORSRVR_ACTIVITY_DATE DATE 7 NO The date that the response was created or last
updated.
GORSRVR_USER VARCHAR2 30 NO The User ID which created or last updated the
response.
GORSRVR_RESPONSE_1 VARCHAR2 1 YES First possible response. Y indicates yes, N indicates
no.
GORSRVR_RESPONSE_2 VARCHAR2 1 YES Second possible response. Y indicates yes, N
indicates no.
GORSRVR_RESPONSE_3 VARCHAR2 1 YES Third possible response. Y indicates yes, N indicates
no.
GORSRVR_RESPONSE_4 VARCHAR2 1 YES Fourth possible response. Y indicates yes, N
indicates no.
GORSRVR_RESPONSE_5 VARCHAR2 1 YES Fifth possible response. Y indicates yes, N indicates
no.
GORSRVR_COMMENTS VARCHAR2 2000 YES Free form text entered as comments by the respondent.
Date: 21-JUN-2004 Page: 115
TABLE: GORSVAH
CREATOR: GENERAL
SEVIS Reporting Activity Site History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORSVAH_PIDM NUMBER 8 NO PERSONAL ID NUMBER: PIDM of person for whom the
activity site is being estasblished.
GORSVAH_SEVIS_SEQ_NO NUMBER 3 NO GORSEVS SEQUENCE NUMBER: Sequence number for SEVIS
data to which the activity sitactivity site history
data belongs.
GORSVAH_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: Sequence number for GORSVAH key
uniqueness.
GORSVAH_ACT_SITE_NAME VARCHAR2 60 NO NAME OF ACTIVITY SITE: Activity Site name.
GORSVAH_TERMINATION_IND VARCHAR2 1 NO TERMINATION INDICATOR: Determines if Activity Site has
been terminated.
GORSVAH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The most recent date a record was
created or updated
GORSVAH_USER_ID VARCHAR2 30 NO USER ID: The most recent user to create or update a
record.
GORSVAH_STREET_LINE1 VARCHAR2 60 YES ACTIVITY SITE STREET LINE 1: Street line 1 of the
address of the activity site.
GORSVAH_STREET_LINE2 VARCHAR2 60 YES ACTIVITY SITE STREET LINE 2: Street line 2 of the
address of the activity site.
GORSVAH_CITY VARCHAR2 60 YES ACTIVITY SITE CITY: City of the activity site address.
GORSVAH_STAT_CODE VARCHAR2 2 YES ACTIVITY SITE STATE CODE: State code of the activity
site address.
GORSVAH_ZIP VARCHAR2 5 YES ACTIVITY SITE ZIP: First five digits of the zipcode of
the activity site address.
GORSVAH_ROUTING_CDE VARCHAR2 4 YES ACTIVITY SITE ZIP ROUTING CODE: Last four digits of
the 9-digit zipcode of the activity site address.
GORSVAH_ACT_SITE_COMMENT VARCHAR2 500 YES ACTIVITY SITE COMMENT:Comment on the activity site.
Date: 21-JUN-2004 Page: 116
TABLE: GORSVAS
CREATOR: GENERAL
SEVIS Reporting Activity Site Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORSVAS_PIDM NUMBER 8 NO PERSONAL ID NUMBER: PIDM of person for whom the
activity site is being estasblished.
GORSVAS_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: Sequence number for GORSVAS key
uniqueness.
GORSVAS_ACT_SITE_NAME VARCHAR2 60 NO NAME OF ACTIVITY SITE: Activity Site name.
GORSVAS_TERMINATION_IND VARCHAR2 1 NO TERMINATION INDICATOR: Determines if Activity Site has
been terminated.
GORSVAS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The most recent date a record was
created or updated
GORSVAS_USER_ID VARCHAR2 30 NO USER ID: The most recent user to create or update a
record.
GORSVAS_ACT_SITE_PIDM NUMBER 8 YES ACTIVITY SITE PIDM: Pidm of activity site if it is a
Banner entity.
GORSVAS_ATYP_CODE VARCHAR2 2 YES
GORSVAS_STREET_LINE1 VARCHAR2 60 YES ACTIVITY SITE STREET LINE 1: Street line 1 of the
address of the activity site.
GORSVAS_STREET_LINE2 VARCHAR2 60 YES ACTIVITY SITE STREET LINE 2: Street line 2 of the
address of the activity site.
GORSVAS_CITY VARCHAR2 60 YES ACTIVITY SITE CITY: City of the activity site address.
GORSVAS_STAT_CODE VARCHAR2 3 YES ACTIVITY SITE STATE CODE: State code of the activity
site address.
GORSVAS_ZIP VARCHAR2 10 YES ACTIVITY SITE ZIP: Zipcode of the activity site
address.
GORSVAS_ACT_SITE_COMMENT VARCHAR2 500 YES ACTIVITY SITE COMMENT:Comment on the activity site.
Date: 21-JUN-2004 Page: 117
TABLE: GORSVBH
CREATOR: GENERAL
Batch header table for transactions to be sent to SEVIS.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORSVBH_BATCH_ID VARCHAR2 14 NO BATCH ID: SEVIS batch ID number.
GORSVBH_BATCH_TYPE_IND VARCHAR2 1 NO BATCH TYPE: Student or Exchange Visitor batch type
indicator.
GORSVBH_PROCESSED_IND VARCHAR2 1 NO PROCESSED INDICATOR: Indicator to denote if the batch
has been processed or not.
GORSVBH_CREATE_DATE DATE 7 NO CREATE DATE: Date that the batch was created.
GORSVBH_SEVIS_USER_ID VARCHAR2 20 NO SEVIS USER ID: DSO user ID for SEVIS processing.
GORSVBH_SCHOOL_CDE VARCHAR2 15 YES SCHOOL CODE: SEVIS-assigned school ID number.
GORSVBH_PROGRAM_CDE VARCHAR2 9 YES PROGRAM CODE: SEVIS-assigned EV program ID number.
GORSVBH_NUMBER_RECORDS NUMBER 3 YES NUMBER OF RECORDS: Number of records in the batch.
GORSVBH_NUMBER_APPROVED NUMBER 3 YES RECORDS APPROVED: Number of records successfully
returned from SEVIS.
GORSVBH_NUM_SEVISTA_REJECTED NUMBER 3 YES SEVIS-TA REJECTED: Number of records rejected by the
SEVIS-TA process.
GORSVBH_NUM_SEVIS_REJECTED NUMBER 3 YES SEVIS REJECTED: Number of records rejected by SEVIS.
GORSVBH_SUBMIT_DATE DATE 7 YES SUBMIT DATE: Date that the batch was submitted to
SEVIS.
GORSVBH_RESPONSE_DATE DATE 7 YES RESPONSE DATE: Date that Response file was received
from SEVIS.
GORSVBH_ERROR_CDE VARCHAR2 20 YES ERROR CODE: File error code returned by SEVIS.
GORSVBH_ERROR_MESSAGE VARCHAR2 500 YES ERROR MESSAGE: File error message returned by SEVIS.
Date: 21-JUN-2004 Page: 118
TABLE: GORSVEH
CREATOR: GENERAL
SEVIS Reporting Employment History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORSVEH_PIDM NUMBER 8 NO PERSONAL ID NUMBER: PIDM of person for whom the
employmnet data is being established.
GORSVEH_SEVIS_SEQ_NO NUMBER 3 NO GORSEVS SEQUENCE NUMBER: Sequence number for SEVIS
data to which the employment history data belongs.
GORSVEH_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: Sequence number for GORSVEH key
uniqueness.
GORSVEH_EMPLOYER_NAME VARCHAR2 500 YES EMPLOYER NAME: Employer name.
GORSVEH_EMP_AUTH_IND VARCHAR2 1 NO EMPLOYMENT AUTHORITY: Indicator to show that a
recommendation for employmnet exists.
GORSVEH_EMPLOYMENT_TYPE_CDE VARCHAR2 2 NO EMPLOYMENT TYPE CODE: Code to show the type of student
employment.
GORSVEH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The most recent date a record was
created or updated
GORSVEH_USER_ID VARCHAR2 30 NO USER ID: The most recent user to create or update a
record.
GORSVEH_EMPLOYMENT_CDE VARCHAR2 2 YES EMPLOYMENT CODE: Code to show why the student is
employed.
GORSVEH_EMPLOYMENT_TIME_CDE VARCHAR2 2 YES EMPLOYMENT TIME CODE: Employment time code indicates
full or part-time status.
GORSVEH_START_DATE DATE 7 YES EMPLOYMENT START DATE: Date employment starts.
GORSVEH_END_DATE DATE 7 YES EMPLOYMENT END DATE: Date employment ends.
GORSVEH_STREET_LINE1 VARCHAR2 60 YES EMPLOYER ADDR STREET LINE 1: Street line 1 of the
employer address.
GORSVEH_STREET_LINE2 VARCHAR2 60 YES EMPLOYER ADDR STREET LINE 2: Street line 2 of the
employer address.
GORSVEH_CITY VARCHAR2 60 YES EMPLOYER ADDR CITY: Employer address city.
GORSVEH_STAT_CODE VARCHAR2 2 YES EMPLOYER ADDR STATE CODE: Employer address state code.
GORSVEH_ZIP VARCHAR2 5 YES EMPLOYER ADDR ZIP: First five digits of the zipcode of
the employer address.
GORSVEH_ROUTING_CDE VARCHAR2 4 YES EMPLOYER ADDR ZIP ROUTING CODE: Last four digits of
the 9-digit zipcode of the employer address.
GORSVEH_COURSE_RELEVANCE VARCHAR2 500 YES COURSE RELEVANCE: Comment on the employment relevance
to course of study.
GORSVEH_EMPLOYMENT_COMMENT VARCHAR2 500 YES EMPLOYMENT COMMENT:Comment on the student employment.
Date: 21-JUN-2004 Page: 119
TABLE: GORSVEI
CREATOR: GENERAL
SEVIS Reporting Employment Information Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORSVEI_PIDM NUMBER 8 NO PERSONAL ID NUMBER: PIDM of person for whom the
employmnet data is being established.
GORSVEI_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: Sequence number for GORSVEI key
uniqueness.
GORSVEI_EMP_AUTH_IND VARCHAR2 1 NO EMPLOYMENT AUTHORITY: Indicator to show that a
recommendation for employmnet exists.
GORSVEI_EMPLOYMENT_TYPE_CDE VARCHAR2 2 NO EMPLOYMENT TYPE CODE: Code to show the type of student
employment.
GORSVEI_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The most recent date a record was
created or updated
GORSVEI_USER_ID VARCHAR2 30 NO USER ID: The most recent user to create or update a
record.
GORSVEI_EMPLOYER_NAME VARCHAR2 500 YES EMPLOYER NAME: Employer name.
GORSVEI_EMPLOYMENT_CDE VARCHAR2 2 YES EMPLOYMENT CODE: Code to show why the student is
employed.
GORSVEI_EMPLOYMENT_TIME_CDE VARCHAR2 2 YES EMPLOYMENT TIME CODE: Employment time code indicates
full or part-time status.
GORSVEI_START_DATE DATE 7 YES EMPLOYMENT START DATE: Date employment starts.
GORSVEI_END_DATE DATE 7 YES EMPLOYMENT END DATE: Date employment ends.
GORSVEI_EMPLOYER_PIDM NUMBER 8 YES
GORSVEI_ATYP_CODE VARCHAR2 2 YES
GORSVEI_STREET_LINE1 VARCHAR2 60 YES EMPLOYER ADDR STREET LINE 1: Street line 1 of the
employer address.
GORSVEI_STREET_LINE2 VARCHAR2 60 YES EMPLOYER ADDR STREET LINE 2: Street line 2 of the
employer address.
GORSVEI_CITY VARCHAR2 60 YES EMPLOYER ADDR CITY: Employer address city.
GORSVEI_STAT_CODE VARCHAR2 3 YES EMPLOYER ADDR STATE CODE: Employer address state code.
GORSVEI_ZIP VARCHAR2 10 YES EMPLOYER ADDR ZIP: Zipcode of the employer address.
GORSVEI_COURSE_RELEVANCE VARCHAR2 500 YES COURSE RELEVANCE: Comment on the employment relevance
to course of study.
GORSVEI_EMPLOYMENT_COMMENT VARCHAR2 500 YES EMPLOYMENT COMMENT:Comment on the student employment.
Date: 21-JUN-2004 Page: 120
TABLE: GORSVSQ
CREATOR: GENERAL
SEVIS SQL Rules Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORSVSQ_SQPR_CODE VARCHAR2 30 NO SQL PROCESS CODE: Process code for SEVIS SQL
processing.
GORSVSQ_SQRU_CODE VARCHAR2 30 NO SQL RULE CODE: Rule code for SEVIS SQL processing.
GORSVSQ_SEQ_NO NUMBER 5 NO SEVIS SQL RULE SEQUENCE NUMBER: Sequence for SEVIS SQL
rule for uniqueness.
GORSVSQ_PROCESS_TYPE_IND VARCHAR2 1 NO SEVIS SQL PROCESS TYPE: Process type - autopopulate
update or business action.
GORSVSQ_ACTIVE_IND VARCHAR2 1 NO ACTIVE INDICATOR: Indicator to show if the rule is
currently active.
GORSVSQ_START_DATE DATE 7 NO START DATE: Date that the rule comes into effective.
GORSVSQ_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The most recent date a record was
created or updated
GORSVSQ_USER_ID VARCHAR2 30 NO USER ID: The most recent user to create or update a
record.
GORSVSQ_SVAP_CODE VARCHAR2 30 YES SEVIS AUTO-POPULATE COLUMN CODE: Name of table column
to be auto-populated.
GORSVSQ_SVBA_CODE VARCHAR2 30 YES SEVIS BUSINESS ACTION CODE: Code of the business
action to be executed.
GORSVSQ_END_DATE DATE 7 YES END DATE: Date that the rule is no longer in effect.
Date: 21-JUN-2004 Page: 121
TABLE: GORTCRL
CREATOR: GENERAL
User ID table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORTCRL_USER_ID VARCHAR2 30 NO User ID
GORTCRL_VAPP_CODE_MODULE VARCHAR2 15 NO VBS Secured Item Code Model
GORTCRL_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
Date: 21-JUN-2004 Page: 122
TABLE: GORTCTL
CREATOR: GENERAL
Third-Party Electronic Controls Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORTCTL_GROUP VARCHAR2 15 NO Group to which record belongs, e.g. if the record
contains the start and stop times for Registration,
the Group would be REGISTRATION.
GORTCTL_FUNCTION VARCHAR2 20 NO Label associated with the function, e.g. MAIN_MENU,
REG_MENU, FIN_MENU.
GORTCTL_DESC VARCHAR2 60 NO Description of the function named in GORTCTL_FUNCTION
e.g. Main Menu, Registration Available, Financial Aid
Available.
GORTCTL_TERM_YEAR VARCHAR2 6 NO Term Code or Year for which the record is effective.
Term codes are validated against STVTERM.
GORTCTL_TCTL_NUM NUMBER 2 NO Control number. Uses vary depending on the process
and vendor. For Voice Response, it equates to the
menu option.
GORTCTL_VALUE VARCHAR2 2 NO 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.
GORTCTL_ACTIVE_IND VARCHAR2 1 NO Flag indicating whether the function is currently
available. Valid values are Y and N
GORTCTL_SYS_REQ_IND VARCHAR2 1 NO System Required Indicator. Indicates whether the
record is required by the SCT system.
GORTCTL_ACTIVITY_DATE DATE 7 NO Date on which the record was last updated or created.
GORTCTL_USER_ID VARCHAR2 30 NO User ID of the person that last updates this record.
GORTCTL_TCTL_SEQNO NUMBER 2 YES Record Sequence Number. Contains a series of
sequential numbers if more than one record exists for
a function.
GORTCTL_BEGIN_DATE DATE 7 YES Initial Date which the record becomes effective.
GORTCTL_END_DATE DATE 7 YES Last date for which the record is effective.
GORTCTL_BEGIN_TIME VARCHAR2 4 YES Time at which the record becomes effective. Format is
HHMM.
GORTCTL_END_TIME VARCHAR2 4 YES Time after which the record ceases to be effective.
Format is HHMM.
GORTCTL_DAYS_AVAIL VARCHAR2 9 YES Frequency or days on which the record can be used,
e.g. Everyday, Mondays, Weekends, Weekdays.
GORTCTL_YEAR VARCHAR2 4 YES 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.
GORTCTL_YEAR_2 VARCHAR2 4 YES Second Year.
GORTCTL_VALUE_2 VARCHAR2 30 YES Miscellaneous values for third-party applications, e.g
for Voice Resonse it contains message numbers.
GORTCTL_VALUE_3 VARCHAR2 30 YES Miscellaneous values for third-party applications, e.g
for Voice Resonse it contains message numbers.
GORTCTL_VALUE_4 VARCHAR2 30 YES Miscellaneous values for third-party applications, e.g
for Voice Resonse it contains message numbers.
GORTCTL_TERM_YEAR_2 VARCHAR2 6 YES Aidy Year or Year for which the record is effective.
Aidy Year codes are validated against RCRAIDY.
Date: 21-JUN-2004 Page: 123
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORTCTL_DATE DATE 7 YES Additional date relevant to the record.
GORTCTL_SYSI_CODE VARCHAR2 2 YES System Indicator Code. Identifies the system to which
the value contained in GORTCTL_TERM_YEAR is associated
for validation purposes.
GORTCTL_SYSI_CODE_2 VARCHAR2 2 YES System Indicator Code. Identifies the system to which
the value contained in GORTCTL_TERM_YEAR_2 is
associated for validation purposes.
GORTCTL_RECORD_TYPE VARCHAR2 10 YES Record Type. Indicates the functional purpose of the
record.
Date: 21-JUN-2004 Page: 124
TABLE: GORVCTL
CREATOR: GENERAL
Voice Response Controls Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORVCTL_RECORD_TYPE VARCHAR2 10 NO Voice Response Record Type to which record belongs,
e.g. if the record defines the main Registration menu
, the Group would be VCMENU.
GORVCTL_GROUP VARCHAR2 15 NO Group to which record belongs, e.g. if the record
contains the start and stop times for Registration,
the Group would be REGISTRATION.
GORVCTL_FUNCTION VARCHAR2 20 NO Label associated with the function, e.g. MAIN_MENU,
REG_MENU, FIN_MENU.
GORVCTL_TCTL_NUM NUMBER 2 NO Control number. Uses vary depending on the process.
For VCMENU record types, it equates to the menu
option.
GORVCTL_DESC VARCHAR2 60 NO Unique Description for the function and control number
combination.
GORVCTL_SYS_REQ_IND VARCHAR2 1 NO System Required Indicator. Indicates whether the
record is required by the SCT system.
GORVCTL_USER_ID VARCHAR2 30 NO User ID of the person that last updates this record.
GORVCTL_ACTIVITY_DATE DATE 7 NO Date on which the record was last updated or created.
Date: 21-JUN-2004 Page: 125
TABLE: GORVGAC
CREATOR: GENERAL
Access Group Rule Control
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORVGAC_SEGC_CODE VARCHAR2 15 NO Access Group Code
GORVGAC_VOBJ_CODE VARCHAR2 15 NO VBS Object Code
GORVGAC_BACR_SEQNO NUMBER 8 NO Access Rule Sequence Number
GORVGAC_VBS_ITEM1 VARCHAR2 15 YES Program Item Value
GORVGAC_VBS_ITEM2 VARCHAR2 15 YES Campus Item Value
GORVGAC_VBS_ITEM3 VARCHAR2 15 YES College Item Value
GORVGAC_VBS_ITEM4 VARCHAR2 15 YES Level Item Value
GORVGAC_VBS_ITEM5 VARCHAR2 15 YES Department Item Value
Date: 21-JUN-2004 Page: 126
TABLE: GORVISA
CREATOR: GENERAL
Visa Information Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORVISA_PIDM NUMBER 8 NO PERSONAL ID NUMBER: This field indicates Personal
Identification Number.
GORVISA_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: This field indicates a Record
Sequence Number.
GORVISA_VTYP_CODE VARCHAR2 2 NO VISA TYPE CODE: This field indicates the Type of Visa
Issued.
GORVISA_VISA_NUMBER VARCHAR2 18 NO VISA NUMBER: This field indicates a unique
identification number assigned to a Visa.
GORVISA_NATN_CODE_ISSUE VARCHAR2 5 NO ISSUING NATION CODE: This field indicates the Country
Code of the nation issuing the visa.
GORVISA_VISS_CODE VARCHAR2 6 NO ISSUE AUTHORITY: This field indicates the Agency
authorizing the visa.
GORVISA_VISA_START_DATE DATE 7 NO VISA START DATE: This field indicates the date the
visa begins.
GORVISA_VISA_EXPIRE_DATE DATE 7 NO VISA EXPIRE DATE: This field indicates the date the
visa expires.
GORVISA_ENTRY_IND VARCHAR2 1 NO ENTRY INDICATOR: This field indicates whether the visa
is for entry into the country.
GORVISA_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user who changed the record.
GORVISA_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or updated in the GORVISA table.
GORVISA_VISA_REQ_DATE DATE 7 YES VISA REQUEST DATE: This field indicates the date the
Visa was requested.
GORVISA_VISA_ISSUE_DATE DATE 7 YES VISA ISSUE DATE: This field indicates the date the
Visa was Issued.
GORVISA_PENT_CODE VARCHAR2 3 YES PORT OF ENTRY: This field indicates the Port of Entry
into the country.
GORVISA_NO_ENTRIES VARCHAR2 2 YES NUMBER OF ENTRIES: This field indicates the Number of
Entries into the country.
Date: 21-JUN-2004 Page: 127
TABLE: GORVMAC
CREATOR: GENERAL
VBS User Module Access Control
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORVMAC_USER_ID VARCHAR2 30 NO ORACLE User ID
GORVMAC_VAPP_CODE VARCHAR2 15 NO VBS Module Code
GORVMAC_PATTERN_CTRL NUMBER 4 YES Module Access Pattern Control Seed Number
Date: 21-JUN-2004 Page: 128
TABLE: GORVMGA
CREATOR: GENERAL
VBS Person Secured Items
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORVMGA_PIDM NUMBER 8 NO Persons PIDM Value
GORVMGA_VAPP_CODE VARCHAR2 15 NO VBS Module Code
GORVMGA_TERM_CODE VARCHAR2 6 YES Persons Term Code
GORVMGA_SEQNO NUMBER 4 YES Curriculum Record Sequence Number
GORVMGA_PROGRAM_1 VARCHAR2 12 YES Program 1 Code
GORVMGA_CAMP_CODE_1 VARCHAR2 3 YES Campus 1 Code
GORVMGA_COLL_CODE_1 VARCHAR2 2 YES College 1 Code
GORVMGA_LEVL_CODE_1 VARCHAR2 2 YES Level 1 Code
GORVMGA_DEPT_CODE_11 VARCHAR2 4 YES Department 1-1 Code
GORVMGA_DEPT_CODE_12 VARCHAR2 4 YES Department 1-2 Code
Date: 21-JUN-2004 Page: 129
TABLE: GORVRAC
CREATOR: GENERAL
VBS User Access Rule Control
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORVRAC_USER_ID VARCHAR2 30 NO ORACLE User ID
GORVRAC_VOBJ_CODE VARCHAR2 15 NO VBS Object Code
GORVRAC_BACR_SEQNO NUMBER 8 NO Access Rule Sequence Number
GORVRAC_VAPP_CODE_MODULE VARCHAR2 15 NO VBS Module associated with User and Access Rule
GORVRAC_ACTIVE_IND VARCHAR2 1 NO Indicates User is Active
GORVRAC_EFF_DATE DATE 7 NO Effective Date of Access
GORVRAC_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
GORVRAC_EXPIRE_DATE DATE 7 YES Expiration Date of Access
GORVRAC_VBS_ITEM1 VARCHAR2 15 YES Program Value
GORVRAC_VBS_ITEM2 VARCHAR2 15 YES Campus Value
GORVRAC_VBS_ITEM3 VARCHAR2 15 YES College Value
GORVRAC_VBS_ITEM4 VARCHAR2 15 YES Level Value
GORVRAC_VBS_ITEM5 VARCHAR2 15 YES Department Value
Date: 21-JUN-2004 Page: 130
TABLE: GORVSVR
CREATOR: GENERAL
Validation Table VBS Control
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORVSVR_SEGC_CODE VARCHAR2 15 NO Access Group Code
GORVSVR_VTBL_CODE VARCHAR2 8 NO Validation Table Code
GORVSVR_VTBL_VALUE VARCHAR2 20 NO Validation Table Value
GORVSVR_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
Date: 21-JUN-2004 Page: 131
TABLE: GORVTBL
CREATOR: GENERAL
Secured Validation Table Codes
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORVTBL_CODE VARCHAR2 8 NO Validation Table Literal
GORVTBL_DESC VARCHAR2 30 NO Validation Table Description
GORVTBL_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
Date: 21-JUN-2004 Page: 132
TABLE: GORWFAP
CREATOR: GENERAL
Electronic Documents Application Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORWFAP_TRANS_NO NUMBER 15 NO TRANSACTION NUMBER: Electronic Document Transaction
Number
GORWFAP_SEQ_NO NUMBER 2 NO SEQUENCE NUMBER: Sequence Number of the Application to
be applied in ElectronicDocument
GORWFAP_ID NUMBER 8 NO ID: Application Id of the Application to be applied in
Electronic Document
GORWFAP_APPLY_IND VARCHAR2 1 NO APPLY INDICATOR: Apply Indicator for Applications to
be applied in Electronic Document
GORWFAP_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 133
TABLE: GORWFDB
CREATOR: GENERAL
Workflow Electronic Docuents Builder Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORWFDB_WFED_CODE VARCHAR2 20 NO ELECTRONIC DOCUMENT: Workflow Electronic Document Type
Code
GORWFDB_PAGE NUMBER 2 NO PAGE: Page number for the mapping
GORWFDB_LINE NUMBER 2 NO LINE: Line number for the mapping
GORWFDB_USER_ID VARCHAR2 30 NO
GORWFDB_ACTIVITY_DATE DATE 7 NO
GORWFDB_A VARCHAR2 60 YES A: Column A for the mapping
GORWFDB_B VARCHAR2 60 YES B: Column B for the mapping
GORWFDB_C VARCHAR2 60 YES C: Column C for the mapping
GORWFDB_D VARCHAR2 60 YES D: Column D for the mapping
GORWFDB_E VARCHAR2 60 YES E: Column E for the mapping
GORWFDB_F VARCHAR2 60 YES F: Column F for the mapping
GORWFDB_G VARCHAR2 60 YES G: Column G for the mapping
GORWFDB_H VARCHAR2 60 YES H: Column H for the mapping
GORWFDB_I VARCHAR2 60 YES I: Column I for the mapping
GORWFDB_J VARCHAR2 60 YES
GORWFDB_K VARCHAR2 60 YES K: Column K for the mapping
GORWFDB_L VARCHAR2 60 YES L: Column L for the mapping
GORWFDB_M VARCHAR2 60 YES M: Column M for the mapping
GORWFDB_N VARCHAR2 60 YES N: Column N for the mapping
GORWFDB_O VARCHAR2 60 YES O: Column O for the mapping
GORWFDB_P VARCHAR2 60 YES P: Column P for the mapping
GORWFDB_Q VARCHAR2 60 YES Q: Column Q for the mapping
GORWFDB_R VARCHAR2 60 YES R: Column R for the mapping
GORWFDB_S VARCHAR2 60 YES S: Column S for the mapping
GORWFDB_T VARCHAR2 60 YES T: Column T for the mapping
GORWFDB_U VARCHAR2 60 YES U: Column U for the mapping
GORWFDB_V VARCHAR2 60 YES V: Column V for the mapping
GORWFDB_W VARCHAR2 60 YES W: Column W for the mapping
GORWFDB_X VARCHAR2 60 YES X: Column X for the mapping
GORWFDB_Y VARCHAR2 60 YES Y: Column Y for the mapping
GORWFDB_Z VARCHAR2 60 YES Z: Column Z for the mapping
Date: 21-JUN-2004 Page: 134
TABLE: GORWFDD
CREATOR: GENERAL
Workflow Electronic Documents Dictionary Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORWFDD_ID NUMBER 8 NO ID: Banner Application Id
GORWFDD_ELEMENT_NAME VARCHAR2 100 NO ELEMENT NAME: Banner Element Name. For Oracle Forms
Product Type an element name is
construct.
GORWFDD_ELEMENT_TYPE VARCHAR2 20 NO ELEMENT TYPE: Type of the element in the Application:
Text Item, Check Box, Pull-Down List
GORWFDD_ELEMENT_DTYPE VARCHAR2 20 NO DATATYPE: Datatype of the field, valid values are: C
-Char, N - Number, D - Date
GORWFDD_LENGTH NUMBER 6 NO LENGTH: Length of the field
GORWFDD_REQUIRED_IND VARCHAR2 1 NO REQUIRED INDICATOR: Required Indicator for the
field.This field defines if data must be entered in
the field
GORWFDD_MULTI_LINE_IND VARCHAR2 1 NO MULTI LINE INDICATOR: This field defines if data can
be presented in multirecord format in the Application
GORWFDD_USER_ID VARCHAR2 30 NO
GORWFDD_ACTIVITY_DATE DATE 7 NO
GORWFDD_DATABASE_ELEMENT VARCHAR2 61 YES DATABASE ELEMENT: This field defines the Database
target in a form of
GORWFDD_ELEMENT_HINT VARCHAR2 2000 YES HINT: Banner Defined Hint Text for fields
GORWFDD_LOW_RANGE VARCHAR2 60 YES LOW RANGE: Field minimum value
GORWFDD_HIGH_RANGE VARCHAR2 60 YES HIGH RANGE: Field maximum value
GORWFDD_FORMAT_MASK VARCHAR2 30 YES FORMAT MASK: Field Display Format
GORWFDD_CASE VARCHAR2 9 YES CASE: Field Case, valid values are U - Upper, L -
Lower, M - Mixed
GORWFDD_ALIGNMENT VARCHAR2 6 YES ALIGNMENT: Field Alignment; valid values are : L
-Left, R - Right, C - Centered
GORWFDD_LIST_APPL_NAME VARCHAR2 10 YES LIST: Validation Banner Form Name for the field
GORWFDD_LIST_TABLE_NAME VARCHAR2 30 YES TABLE NAME: Table Name for Code/Desc functionality
GORWFDD_LIST_COLUMN_NAME VARCHAR2 30 YES COLUMN NAME: Code Column Name for Code/Desc
functionality
GORWFDD_LIST_DESC_COLUMN_NAME VARCHAR2 30 YES DESCRIPTION COLUMN NAME: Description Column Name for
Code/Desc functionality
GORWFDD_LIST_WHERE_CLAUSE VARCHAR2 2000 YES WHERE CLAUSE: Where Clause for Code/Desc Functionality
Date: 21-JUN-2004 Page: 135
TABLE: GORWFDH
CREATOR: GENERAL
Workflow Electronic Documents History Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORWFDH_TRANS_NO NUMBER 15 NO TRANSACTION NUMBER: Electronic Document Transaction
Number
GORWFDH_SEQ_NO NUMBER 2 NO SEQUENCE NUMBER: Sequence Number per Transaction
Number in History for this transaction
GORWFDH_STATUS VARCHAR2 20 NO STATUS: Status of transactions
GORWFDH_USER_ID VARCHAR2 30 NO USER ID: Oracle User Id
GORWFDH_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Activity Date when transaction was
generated
GORWFDH_COMMENTS VARCHAR2 2000 YES COMMENTS: Comments for transactions
Date: 21-JUN-2004 Page: 136
TABLE: GORWFDS
CREATOR: GENERAL
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORWFDS_USER_ID VARCHAR2 30 NO
GORWFDS_WFED_CODE VARCHAR2 20 NO
GORWFDS_QUERY_MODE_IND VARCHAR2 1 NO
GORWFDS_UPDATE_MODE_IND VARCHAR2 1 NO
GORWFDS_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 137
TABLE: GORWFED
CREATOR: GENERAL
Workflow Electronic Documents Repeating Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORWFED_TRANS_NO NUMBER 15 NO TRANSACTION NUMBER: Transcation Number for the
Electronic Document
GORWFED_WFED_CODE VARCHAR2 20 NO ELECTRONIC DOCUMENT: Workflow Electronic Document Type
Code
GORWFED_PAGE NUMBER 2 NO PAGE: Page number for the mapping
GORWFED_LINE NUMBER 2 NO LINE: Line number for the mapping
GORWFED_ACTIVITY_DATE DATE 7 NO
GORWFED_A VARCHAR2 60 YES A: Column A for the mapping
GORWFED_B VARCHAR2 60 YES B: Column B for the mapping
GORWFED_C VARCHAR2 60 YES C: Column C for the mapping
GORWFED_D VARCHAR2 60 YES D: Column D for the mapping
GORWFED_E VARCHAR2 60 YES E: Column E for the mapping
GORWFED_F VARCHAR2 60 YES F: Column F for the mapping
GORWFED_G VARCHAR2 60 YES G: Column G for the mapping
GORWFED_H VARCHAR2 60 YES H: Column H for the mapping
GORWFED_I VARCHAR2 60 YES I: Column I for the mapping
GORWFED_J VARCHAR2 60 YES
GORWFED_K VARCHAR2 60 YES K: Column K for the mapping
GORWFED_L VARCHAR2 60 YES L: Column L for the mapping
GORWFED_M VARCHAR2 60 YES M: Column M for the mapping
GORWFED_N VARCHAR2 60 YES N: Column N for the mapping
GORWFED_O VARCHAR2 60 YES O: Column O for the mapping
GORWFED_P VARCHAR2 60 YES P: Column P for the mapping
GORWFED_Q VARCHAR2 60 YES Q: Column Q for the mapping
GORWFED_R VARCHAR2 60 YES R: Column R for the mapping
GORWFED_S VARCHAR2 60 YES S: Column S for the mapping
GORWFED_T VARCHAR2 60 YES T: Column T for the mapping
GORWFED_U VARCHAR2 60 YES U: Column U for the mapping
GORWFED_V VARCHAR2 60 YES V: Column V for the mapping
GORWFED_W VARCHAR2 60 YES W: Column W for the mapping
GORWFED_X VARCHAR2 60 YES X: Column X for the mapping
GORWFED_Y VARCHAR2 60 YES Y: Column Y for the mapping
GORWFED_Z VARCHAR2 60 YES Z: Column Z for the mapping
Date: 21-JUN-2004 Page: 138
TABLE: GORWFMP
CREATOR: GENERAL
Electronic Documents Mapping Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORWFMP_WFED_CODE VARCHAR2 20 NO ELECTRONIC DOCUMENT: Workflow Electronic Document Type
Code
GORWFMP_PAGE NUMBER 2 NO PAGE: Page number for the mapping
GORWFMP_X_VALUE VARCHAR2 2 NO X_VALUE: X coordinate of the cell for mapping
GORWFMP_Y_VALUE NUMBER 2 NO Y_VALUE: Y coordinate of the cell for mapping
GORWFMP_CELL_TYPE VARCHAR2 20 NO CELL TYPE: Valid values are: T - Text Item, D -
Display Item, L - Label
GORWFMP_REQUIRED_IND VARCHAR2 1 NO REQUIRED INDICATOR: Required Indicator for the Cell
GORWFMP_DEFAULT_OVERRIDE_IND VARCHAR2 1 NO DEFAULT OVERRIDE INDICATOR: This field defines if the
Default Value for the cell may be overriden
GORWFMP_USER_ID VARCHAR2 30 NO
GORWFMP_ACTIVITY_DATE DATE 7 NO
GORWFMP_APPL_ID NUMBER 8 YES APPLICATION ID: Banner Application Id
GORWFMP_APPL_TARGET_NAME VARCHAR2 100 YES APPLICATION TARGET NAME: Banner Element Name. For
Oracle Forms Product Type an element name is
construct.
GORWFMP_DATABASE_TARGET_NAME VARCHAR2 100 YES DATABASE TARGET NAME: This field defines the Database
target in a form of
GORWFMP_DEFAULT VARCHAR2 60 YES DEFAULT: Default Value for the cell
GORWFMP_LOW_RANGE VARCHAR2 30 YES LOW RANGE: Field minimum value
GORWFMP_HIGH_RANGE VARCHAR2 30 YES HIGH RANGE: Field maximum value
GORWFMP_LIST VARCHAR2 20 YES LIST: Validation Banner Form Name for the field
GORWFMP_EVENT_TYPE VARCHAR2 20 YES EVENT TYPE: Event Type for the cell: Valid Values are
: V - Validation, C - Calculation, S - Security
GORWFMP_CELL_DTYPE VARCHAR2 9 YES CELL DATATYPE: Cell Datatype, Valid Value are : C -
Character, D - Date, N - Number
GORWFMP_LENGTH NUMBER 3 YES LENGTH: Length of the field
GORWFMP_ENTER_HINT VARCHAR2 2000 YES ENTER HINT: Hint Text in Enter Mode
GORWFMP_APPLY_HINT VARCHAR2 2000 YES APPLY HINT: Hint Text in Apply Mode
GORWFMP_CASE VARCHAR2 1 YES CASE: Field Case, valid values are U - Upper, L -
Lower, M - Mixed
Date: 21-JUN-2004 Page: 139
TABLE: GORWFPM
CREATOR: GENERAL
Parameters Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORWFPM_WFED_CODE VARCHAR2 20 NO ELECTRONIC DOCUMENT: Workflow Electronic Document Type
Code
GORWFPM_PAGE NUMBER 2 NO Page: Page Number
GORWFPM_X_VALUE VARCHAR2 2 NO X_VALUE: X coordinate of the cell
GORWFPM_Y_VALUE NUMBER 2 NO Y_VALUE: Y coordinate of the cell
GORWFPM_FUNC_NAME VARCHAR2 61 NO FUNCTION NAME: Database Function Name
GORWFPM_FUNC_SEQ_NO NUMBER 2 NO FUNCTION SEQUENCE NUMBER: Sequence number of the
function per Document Type
GORWFPM_SEQ_NO NUMBER 2 NO SEQUENCE NUMBER: Parameter Sequence Number for the
Function
GORWFPM_PARM_X_VALUE VARCHAR2 2 NO PARAMETER X_VALUE: Parameter Value X coordinate of the
cell
GORWFPM_PARM_Y_VALUE NUMBER 2 NO PARAMETER Y_VALUE: Parameter Value Y coordinate of the
cell
GORWFPM_DTYPE VARCHAR2 20 NO DATATYPE: Datatype of parameters
GORWFPM_USER_ID VARCHAR2 30 NO
GORWFPM_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 140
TABLE: GORWFSQ
CREATOR: GENERAL
Documents Sequence Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GORWFSQ_WFED_CODE VARCHAR2 20 NO ELECTRONIC DOCUMENT: Workflow Electronic Document Type
Code
GORWFSQ_SEQ_NO NUMBER 2 NO SEQUENCE NUMBER: Documents Sequence Number
GORWFSQ_ID NUMBER 8 NO ID: Application Id
GORWFSQ_USER_ID VARCHAR2 30 NO
GORWFSQ_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 141
TABLE: GOTDMSG
CREATOR: GENERAL
SPREADSHEET MESSAGE TABLE
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOTDMSG_SESSION_ID NUMBER 8 NO SESSION ID: The current session id.
GOTDMSG_WORKBOOK VARCHAR2 255 YES WORKBOOK: Name of the workbook.
GOTDMSG_WORKSHEET VARCHAR2 255 YES WORKSHEET: Name of the worksheet.
GOTDMSG_ROW_NUMBER NUMBER 8 YES ROW NUMBER: Spreadsheet Row number.
GOTDMSG_TYPE VARCHAR2 1 YES MESSAGE TYPE: W FOR WORNING, E FOR ERROR.
GOTDMSG_DESCRIPTION VARCHAR2 2000 YES MESSAGE DESCRIPTION: Description of the error.
Date: 21-JUN-2004 Page: 142
TABLE: GOTDPAR
CREATOR: GENERAL
SPREADSHEET USER INPUT TABLE
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOTDPAR_SESSION_ID NUMBER 8 NO SESSION ID: The current session id.
GOTDPAR_STEP_NAME VARCHAR2 30 NO STEP NAME: Corrosponding Wizard step name for the row.
GOTDPAR_1 VARCHAR2 255 YES Column 1: Generic Column 1.
GOTDPAR_2 VARCHAR2 255 YES Column 2: Generic Column 2.
GOTDPAR_3 VARCHAR2 255 YES
GOTDPAR_4 VARCHAR2 255 YES
GOTDPAR_5 VARCHAR2 255 YES
GOTDPAR_6 VARCHAR2 255 YES
GOTDPAR_7 VARCHAR2 255 YES
GOTDPAR_8 VARCHAR2 255 YES
GOTDPAR_9 VARCHAR2 255 YES
GOTDPAR_10 VARCHAR2 255 YES
GOTDPAR_11 VARCHAR2 255 YES
GOTDPAR_12 VARCHAR2 255 YES
GOTDPAR_13 VARCHAR2 255 YES
GOTDPAR_14 VARCHAR2 255 YES
GOTDPAR_15 VARCHAR2 255 YES
GOTDPAR_16 VARCHAR2 255 YES
GOTDPAR_17 VARCHAR2 255 YES
GOTDPAR_18 VARCHAR2 255 YES
GOTDPAR_19 VARCHAR2 255 YES
GOTDPAR_20 VARCHAR2 255 YES
GOTDPAR_21 VARCHAR2 255 YES
GOTDPAR_22 VARCHAR2 255 YES
GOTDPAR_23 VARCHAR2 255 YES
GOTDPAR_24 VARCHAR2 255 YES
GOTDPAR_25 VARCHAR2 255 YES
GOTDPAR_26 VARCHAR2 255 YES
GOTDPAR_27 VARCHAR2 255 YES
GOTDPAR_28 VARCHAR2 255 YES
GOTDPAR_29 VARCHAR2 255 YES
GOTDPAR_30 VARCHAR2 255 YES
GOTDPAR_31 VARCHAR2 255 YES
GOTDPAR_32 VARCHAR2 255 YES
GOTDPAR_33 VARCHAR2 255 YES
GOTDPAR_34 VARCHAR2 255 YES
GOTDPAR_35 VARCHAR2 255 YES
GOTDPAR_36 VARCHAR2 255 YES
GOTDPAR_37 VARCHAR2 255 YES
GOTDPAR_38 VARCHAR2 255 YES
GOTDPAR_39 VARCHAR2 255 YES
GOTDPAR_40 VARCHAR2 255 YES
GOTDPAR_41 VARCHAR2 255 YES
GOTDPAR_42 VARCHAR2 255 YES
Date: 21-JUN-2004 Page: 143
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOTDPAR_43 VARCHAR2 255 YES
GOTDPAR_44 VARCHAR2 255 YES
GOTDPAR_45 VARCHAR2 255 YES
GOTDPAR_46 VARCHAR2 255 YES
GOTDPAR_47 VARCHAR2 255 YES
GOTDPAR_48 VARCHAR2 255 YES
GOTDPAR_49 VARCHAR2 255 YES
GOTDPAR_50 VARCHAR2 255 YES
GOTDPAR_51 VARCHAR2 255 YES
GOTDPAR_52 VARCHAR2 255 YES
GOTDPAR_53 VARCHAR2 255 YES
GOTDPAR_54 VARCHAR2 255 YES
GOTDPAR_55 VARCHAR2 255 YES
GOTDPAR_56 VARCHAR2 255 YES
GOTDPAR_57 VARCHAR2 255 YES
GOTDPAR_58 VARCHAR2 255 YES
GOTDPAR_59 VARCHAR2 255 YES
GOTDPAR_60 VARCHAR2 255 YES
GOTDPAR_61 VARCHAR2 255 YES
GOTDPAR_62 VARCHAR2 255 YES
GOTDPAR_63 VARCHAR2 255 YES
GOTDPAR_64 VARCHAR2 255 YES
GOTDPAR_65 VARCHAR2 255 YES
GOTDPAR_66 VARCHAR2 255 YES
GOTDPAR_67 VARCHAR2 255 YES
GOTDPAR_68 VARCHAR2 255 YES
GOTDPAR_69 VARCHAR2 255 YES
GOTDPAR_70 VARCHAR2 255 YES
GOTDPAR_71 VARCHAR2 255 YES
GOTDPAR_72 VARCHAR2 255 YES
GOTDPAR_73 VARCHAR2 255 YES
GOTDPAR_74 VARCHAR2 255 YES
GOTDPAR_75 VARCHAR2 255 YES
GOTDPAR_76 VARCHAR2 255 YES
GOTDPAR_77 VARCHAR2 255 YES
GOTDPAR_78 VARCHAR2 255 YES
GOTDPAR_79 VARCHAR2 255 YES
GOTDPAR_80 VARCHAR2 255 YES
GOTDPAR_81 VARCHAR2 255 YES
GOTDPAR_82 VARCHAR2 255 YES
GOTDPAR_83 VARCHAR2 255 YES
GOTDPAR_84 VARCHAR2 255 YES
GOTDPAR_85 VARCHAR2 255 YES
GOTDPAR_86 VARCHAR2 255 YES
GOTDPAR_87 VARCHAR2 255 YES
GOTDPAR_88 VARCHAR2 255 YES
GOTDPAR_89 VARCHAR2 255 YES
GOTDPAR_90 VARCHAR2 255 YES
GOTDPAR_91 VARCHAR2 255 YES
GOTDPAR_92 VARCHAR2 255 YES
Date: 21-JUN-2004 Page: 144
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOTDPAR_93 VARCHAR2 255 YES
GOTDPAR_94 VARCHAR2 255 YES
GOTDPAR_95 VARCHAR2 255 YES
GOTDPAR_96 VARCHAR2 255 YES
GOTDPAR_97 VARCHAR2 255 YES
GOTDPAR_98 VARCHAR2 255 YES
GOTDPAR_99 VARCHAR2 255 YES
GOTDPAR_100 VARCHAR2 255 YES Column 100: Generic Column 100.
Date: 21-JUN-2004 Page: 145
TABLE: GOTDWKS
CREATOR: GENERAL
Worksheet Temporary Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOTDWKS_SESSION_ID NUMBER 8 NO SESSION ID: The current session id.
GOTDWKS_ROW_NUMBER NUMBER 8 NO ROW NUMBER: Spreadsheet Row number.
GOTDWKS_WORKBOOK VARCHAR2 255 NO WORKBOOK: Name of the workbook.
GOTDWKS_WORKSHEET VARCHAR2 255 NO WORKSHEET: Name of the worksheet.
GOTDWKS_COL_1 VARCHAR2 255 YES Column 1: 1st Column of the spreadsheet.
GOTDWKS_COL_2 VARCHAR2 255 YES Column 2: 2nd Column of the spreadsheet.
GOTDWKS_COL_3 VARCHAR2 255 YES
GOTDWKS_COL_4 VARCHAR2 255 YES
GOTDWKS_COL_5 VARCHAR2 255 YES
GOTDWKS_COL_6 VARCHAR2 255 YES
GOTDWKS_COL_7 VARCHAR2 255 YES
GOTDWKS_COL_8 VARCHAR2 255 YES
GOTDWKS_COL_9 VARCHAR2 255 YES
GOTDWKS_COL_10 VARCHAR2 255 YES
GOTDWKS_COL_11 VARCHAR2 255 YES
GOTDWKS_COL_12 VARCHAR2 255 YES
GOTDWKS_COL_13 VARCHAR2 255 YES
GOTDWKS_COL_14 VARCHAR2 255 YES
GOTDWKS_COL_15 VARCHAR2 255 YES
GOTDWKS_COL_16 VARCHAR2 255 YES
GOTDWKS_COL_17 VARCHAR2 255 YES
GOTDWKS_COL_18 VARCHAR2 255 YES
GOTDWKS_COL_19 VARCHAR2 255 YES
GOTDWKS_COL_20 VARCHAR2 255 YES
GOTDWKS_COL_21 VARCHAR2 255 YES
GOTDWKS_COL_22 VARCHAR2 255 YES
GOTDWKS_COL_23 VARCHAR2 255 YES
GOTDWKS_COL_24 VARCHAR2 255 YES
GOTDWKS_COL_25 VARCHAR2 255 YES
GOTDWKS_COL_26 VARCHAR2 255 YES
GOTDWKS_COL_27 VARCHAR2 255 YES
GOTDWKS_COL_28 VARCHAR2 255 YES
GOTDWKS_COL_29 VARCHAR2 255 YES
GOTDWKS_COL_30 VARCHAR2 255 YES
GOTDWKS_COL_31 VARCHAR2 255 YES
GOTDWKS_COL_32 VARCHAR2 255 YES
GOTDWKS_COL_33 VARCHAR2 255 YES
GOTDWKS_COL_34 VARCHAR2 255 YES
GOTDWKS_COL_35 VARCHAR2 255 YES
GOTDWKS_COL_36 VARCHAR2 255 YES
GOTDWKS_COL_37 VARCHAR2 255 YES
GOTDWKS_COL_38 VARCHAR2 255 YES
GOTDWKS_COL_39 VARCHAR2 255 YES
GOTDWKS_COL_40 VARCHAR2 255 YES
Date: 21-JUN-2004 Page: 146
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOTDWKS_COL_41 VARCHAR2 255 YES
GOTDWKS_COL_42 VARCHAR2 255 YES
GOTDWKS_COL_43 VARCHAR2 255 YES
GOTDWKS_COL_44 VARCHAR2 255 YES
GOTDWKS_COL_45 VARCHAR2 255 YES
GOTDWKS_COL_46 VARCHAR2 255 YES
GOTDWKS_COL_47 VARCHAR2 255 YES
GOTDWKS_COL_48 VARCHAR2 255 YES
GOTDWKS_COL_49 VARCHAR2 255 YES
GOTDWKS_COL_50 VARCHAR2 255 YES
GOTDWKS_COL_51 VARCHAR2 255 YES
GOTDWKS_COL_52 VARCHAR2 255 YES
GOTDWKS_COL_53 VARCHAR2 255 YES
GOTDWKS_COL_54 VARCHAR2 255 YES
GOTDWKS_COL_55 VARCHAR2 255 YES
GOTDWKS_COL_56 VARCHAR2 255 YES
GOTDWKS_COL_57 VARCHAR2 255 YES
GOTDWKS_COL_58 VARCHAR2 255 YES
GOTDWKS_COL_59 VARCHAR2 255 YES
GOTDWKS_COL_60 VARCHAR2 255 YES
GOTDWKS_COL_61 VARCHAR2 255 YES
GOTDWKS_COL_62 VARCHAR2 255 YES
GOTDWKS_COL_63 VARCHAR2 255 YES
GOTDWKS_COL_64 VARCHAR2 255 YES
GOTDWKS_COL_65 VARCHAR2 255 YES
GOTDWKS_COL_66 VARCHAR2 255 YES
GOTDWKS_COL_67 VARCHAR2 255 YES
GOTDWKS_COL_68 VARCHAR2 255 YES
GOTDWKS_COL_69 VARCHAR2 255 YES
GOTDWKS_COL_70 VARCHAR2 255 YES
GOTDWKS_COL_71 VARCHAR2 255 YES
GOTDWKS_COL_72 VARCHAR2 255 YES
GOTDWKS_COL_73 VARCHAR2 255 YES
GOTDWKS_COL_74 VARCHAR2 255 YES
GOTDWKS_COL_75 VARCHAR2 255 YES
GOTDWKS_COL_76 VARCHAR2 255 YES
GOTDWKS_COL_77 VARCHAR2 255 YES
GOTDWKS_COL_78 VARCHAR2 255 YES
GOTDWKS_COL_79 VARCHAR2 255 YES
GOTDWKS_COL_80 VARCHAR2 255 YES
GOTDWKS_COL_81 VARCHAR2 255 YES
GOTDWKS_COL_82 VARCHAR2 255 YES
GOTDWKS_COL_83 VARCHAR2 255 YES
GOTDWKS_COL_84 VARCHAR2 255 YES
GOTDWKS_COL_85 VARCHAR2 255 YES
GOTDWKS_COL_86 VARCHAR2 255 YES
GOTDWKS_COL_87 VARCHAR2 255 YES
GOTDWKS_COL_88 VARCHAR2 255 YES
GOTDWKS_COL_89 VARCHAR2 255 YES
GOTDWKS_COL_90 VARCHAR2 255 YES
Date: 21-JUN-2004 Page: 147
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOTDWKS_COL_91 VARCHAR2 255 YES
GOTDWKS_COL_92 VARCHAR2 255 YES
GOTDWKS_COL_93 VARCHAR2 255 YES
GOTDWKS_COL_94 VARCHAR2 255 YES
GOTDWKS_COL_95 VARCHAR2 255 YES
GOTDWKS_COL_96 VARCHAR2 255 YES
GOTDWKS_COL_97 VARCHAR2 255 YES
GOTDWKS_COL_98 VARCHAR2 255 YES
GOTDWKS_COL_99 VARCHAR2 255 YES
GOTDWKS_COL_100 VARCHAR2 255 YES
GOTDWKS_COL_101 VARCHAR2 255 YES
GOTDWKS_COL_102 VARCHAR2 255 YES
GOTDWKS_COL_103 VARCHAR2 255 YES
GOTDWKS_COL_104 VARCHAR2 255 YES
GOTDWKS_COL_105 VARCHAR2 255 YES
GOTDWKS_COL_106 VARCHAR2 255 YES
GOTDWKS_COL_107 VARCHAR2 255 YES
GOTDWKS_COL_108 VARCHAR2 255 YES
GOTDWKS_COL_109 VARCHAR2 255 YES
GOTDWKS_COL_110 VARCHAR2 255 YES
GOTDWKS_COL_111 VARCHAR2 255 YES
GOTDWKS_COL_112 VARCHAR2 255 YES
GOTDWKS_COL_113 VARCHAR2 255 YES
GOTDWKS_COL_114 VARCHAR2 255 YES
GOTDWKS_COL_115 VARCHAR2 255 YES
GOTDWKS_COL_116 VARCHAR2 255 YES
GOTDWKS_COL_117 VARCHAR2 255 YES
GOTDWKS_COL_118 VARCHAR2 255 YES
GOTDWKS_COL_119 VARCHAR2 255 YES
GOTDWKS_COL_120 VARCHAR2 255 YES
GOTDWKS_COL_121 VARCHAR2 255 YES
GOTDWKS_COL_122 VARCHAR2 255 YES
GOTDWKS_COL_123 VARCHAR2 255 YES
GOTDWKS_COL_124 VARCHAR2 255 YES
GOTDWKS_COL_125 VARCHAR2 255 YES
GOTDWKS_COL_126 VARCHAR2 255 YES
GOTDWKS_COL_127 VARCHAR2 255 YES
GOTDWKS_COL_128 VARCHAR2 255 YES
GOTDWKS_COL_129 VARCHAR2 255 YES
GOTDWKS_COL_130 VARCHAR2 255 YES
GOTDWKS_COL_131 VARCHAR2 255 YES
GOTDWKS_COL_132 VARCHAR2 255 YES
GOTDWKS_COL_133 VARCHAR2 255 YES
GOTDWKS_COL_134 VARCHAR2 255 YES
GOTDWKS_COL_135 VARCHAR2 255 YES
GOTDWKS_COL_136 VARCHAR2 255 YES
GOTDWKS_COL_137 VARCHAR2 255 YES
GOTDWKS_COL_138 VARCHAR2 255 YES
GOTDWKS_COL_139 VARCHAR2 255 YES
GOTDWKS_COL_140 VARCHAR2 255 YES
Date: 21-JUN-2004 Page: 148
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOTDWKS_COL_141 VARCHAR2 255 YES
GOTDWKS_COL_142 VARCHAR2 255 YES
GOTDWKS_COL_143 VARCHAR2 255 YES
GOTDWKS_COL_144 VARCHAR2 255 YES
GOTDWKS_COL_145 VARCHAR2 255 YES
GOTDWKS_COL_146 VARCHAR2 255 YES
GOTDWKS_COL_147 VARCHAR2 255 YES
GOTDWKS_COL_148 VARCHAR2 255 YES
GOTDWKS_COL_149 VARCHAR2 255 YES
GOTDWKS_COL_150 VARCHAR2 255 YES
GOTDWKS_COL_151 VARCHAR2 255 YES
GOTDWKS_COL_152 VARCHAR2 255 YES
GOTDWKS_COL_153 VARCHAR2 255 YES
GOTDWKS_COL_154 VARCHAR2 255 YES
GOTDWKS_COL_155 VARCHAR2 255 YES
GOTDWKS_COL_156 VARCHAR2 255 YES
GOTDWKS_COL_157 VARCHAR2 255 YES
GOTDWKS_COL_158 VARCHAR2 255 YES
GOTDWKS_COL_159 VARCHAR2 255 YES
GOTDWKS_COL_160 VARCHAR2 255 YES
GOTDWKS_COL_161 VARCHAR2 255 YES
GOTDWKS_COL_162 VARCHAR2 255 YES
GOTDWKS_COL_163 VARCHAR2 255 YES
GOTDWKS_COL_164 VARCHAR2 255 YES
GOTDWKS_COL_165 VARCHAR2 255 YES
GOTDWKS_COL_166 VARCHAR2 255 YES
GOTDWKS_COL_167 VARCHAR2 255 YES
GOTDWKS_COL_168 VARCHAR2 255 YES
GOTDWKS_COL_169 VARCHAR2 255 YES
GOTDWKS_COL_170 VARCHAR2 255 YES
GOTDWKS_COL_171 VARCHAR2 255 YES
GOTDWKS_COL_172 VARCHAR2 255 YES
GOTDWKS_COL_173 VARCHAR2 255 YES
GOTDWKS_COL_174 VARCHAR2 255 YES
GOTDWKS_COL_175 VARCHAR2 255 YES
GOTDWKS_COL_176 VARCHAR2 255 YES
GOTDWKS_COL_177 VARCHAR2 255 YES
GOTDWKS_COL_178 VARCHAR2 255 YES
GOTDWKS_COL_179 VARCHAR2 255 YES
GOTDWKS_COL_180 VARCHAR2 255 YES
GOTDWKS_COL_181 VARCHAR2 255 YES
GOTDWKS_COL_182 VARCHAR2 255 YES
GOTDWKS_COL_183 VARCHAR2 255 YES
GOTDWKS_COL_184 VARCHAR2 255 YES
GOTDWKS_COL_185 VARCHAR2 255 YES
GOTDWKS_COL_186 VARCHAR2 255 YES
GOTDWKS_COL_187 VARCHAR2 255 YES
GOTDWKS_COL_188 VARCHAR2 255 YES
GOTDWKS_COL_189 VARCHAR2 255 YES
GOTDWKS_COL_190 VARCHAR2 255 YES
Date: 21-JUN-2004 Page: 149
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOTDWKS_COL_191 VARCHAR2 255 YES
GOTDWKS_COL_192 VARCHAR2 255 YES
GOTDWKS_COL_193 VARCHAR2 255 YES
GOTDWKS_COL_194 VARCHAR2 255 YES
GOTDWKS_COL_195 VARCHAR2 255 YES
GOTDWKS_COL_196 VARCHAR2 255 YES
GOTDWKS_COL_197 VARCHAR2 255 YES
GOTDWKS_COL_198 VARCHAR2 255 YES
GOTDWKS_COL_199 VARCHAR2 255 YES
GOTDWKS_COL_200 VARCHAR2 255 YES Column 200: 200th Column of the spreadsheet.
Date: 21-JUN-2004 Page: 150
TABLE: GOTSVBT
CREATOR: GENERAL
Collector table for batch transactions to be sent to SEVIS.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOTSVBT_BATCH_ID VARCHAR2 14 NO BATCH ID: SEVIS batch ID number.
GOTSVBT_REQUEST_ID VARCHAR2 20 NO REQUEST ID: Individual transaction SEVIS request ID
number - concatenation of batch ID and sequential
number.
GOTSVBT_PIDM NUMBER 8 NO PIDM: Personal ID number for each transaction.
GOTSVBT_SEQ_NO NUMBER 3 NO SEQUENCE NUMBER: Sequence number of the GORSEVS
history record for the transaction.
GOTSVBT_TRANSACTION_IND VARCHAR2 1 NO CREATE OR UPDATE INDICATOR: Indicator to denote if row
is a Create or Update SEVIS transaction.
GOTSVBT_SVTS_CODE VARCHAR2 1 NO TRANSMISSION CODE: Banner Transmission code for the
GORSEVS history record.
GOTSVBT_RETURN_CDE VARCHAR2 20 YES RETURN CODE: Error code returned from SEVIS.
GOTSVBT_RETURN_MESSAGE VARCHAR2 500 YES RETURN CODE MESSAGE: Error message returned from
SEVIS.
GOTSVBT_DATA CLOB 4000 YES DATA FIELD: Concatenated data fields that comprise the
SEVIS transaction.
Date: 21-JUN-2004 Page: 151
TABLE: GOTWFED
CREATOR: GENERAL
Workflow Electronic Documents Temporary Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOTWFED_SESSION_ID NUMBER 8 NO SESSION ID: Oracle Session Id
GOTWFED_TRANS_NO NUMBER 15 NO TRANSACTION NUMBER: Transcation Number for the
Electronic Document
GOTWFED_WFED_CODE VARCHAR2 20 NO ELECTRONIC DOCUMENT: Workflow Electronic Document Type
Code
GOTWFED_PAGE NUMBER 2 NO PAGE: Page number for the mapping
GOTWFED_LINE NUMBER 2 NO LINE: Line number for the mapping
GOTWFED_ACTIVITY_DATE DATE 7 NO
GOTWFED_A VARCHAR2 60 YES A: Column A for the mapping
GOTWFED_B VARCHAR2 60 YES B: Column B for the mapping
GOTWFED_C VARCHAR2 60 YES C: Column C for the mapping
GOTWFED_D VARCHAR2 60 YES D: Column D for the mapping
GOTWFED_E VARCHAR2 60 YES E: Column E for the mapping
GOTWFED_F VARCHAR2 60 YES F: Column F for the mapping
GOTWFED_G VARCHAR2 60 YES G: Column G for the mapping
GOTWFED_H VARCHAR2 60 YES H: Column H for the mapping
GOTWFED_I VARCHAR2 60 YES I: Column I for the mapping
GOTWFED_J VARCHAR2 60 YES
GOTWFED_K VARCHAR2 60 YES K: Column K for the mapping
GOTWFED_L VARCHAR2 60 YES L: Column L for the mapping
GOTWFED_M VARCHAR2 60 YES M: Column M for the mapping
GOTWFED_N VARCHAR2 60 YES N: Column N for the mapping
GOTWFED_O VARCHAR2 60 YES O: Column O for the mapping
GOTWFED_P VARCHAR2 60 YES P: Column P for the mapping
GOTWFED_Q VARCHAR2 60 YES Q: Column Q for the mapping
GOTWFED_R VARCHAR2 60 YES R: Column R for the mapping
GOTWFED_S VARCHAR2 60 YES S: Column S for the mapping
GOTWFED_T VARCHAR2 60 YES T: Column T for the mapping
GOTWFED_U VARCHAR2 60 YES U: Column U for the mapping
GOTWFED_V VARCHAR2 60 YES V: Column V for the mapping
GOTWFED_W VARCHAR2 60 YES W: Column W for the mapping
GOTWFED_X VARCHAR2 60 YES X: Column X for the mapping
GOTWFED_Y VARCHAR2 60 YES Y: Column Y for the mapping
GOTWFED_Z VARCHAR2 60 YES Z: Column Z for the mapping
Date: 21-JUN-2004 Page: 152
TABLE: GOTXMLD
CREATOR: GENERAL
Temporary table to store XML files as CLOB data type for processing.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GOTXMLD_DOCNAME VARCHAR2 200 NO XML DOCUMENT NAME: Unique document name for XML file.
GOTXMLD_XMLDOC CLOB 4000 YES XML DOCUMENT: XML document stored as a clob.
Date: 21-JUN-2004 Page: 153
TABLE: GTRMAPS
CREATOR: GENERAL
GIS Mapping Description Rule Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTRMAPS_SEQ NUMBER 2 NO
GTRMAPS_ACTIVITY_DATE DATE 7 NO Last activity date.
GTRMAPS_USER_ID VARCHAR2 30 NO Last user to update.
GTRMAPS_DESC VARCHAR2 15 NO
GTRMAPS_TYPE VARCHAR2 1 NO Character or numeric field (C or N).
GTRMAPS_LEN NUMBER 2 NO Length of mapping field.
Date: 21-JUN-2004 Page: 154
TABLE: GTVCALL
CREATOR: GENERAL
QuickFlow Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVCALL_CODE VARCHAR2 4 NO This field identifies the QuickFlow code referenced by
the QuickFlow Definition Form (GUAQUIK).
GTVCALL_DESC VARCHAR2 30 NO This field identifies the description associated with
the QuickFlow code
GTVCALL_ACTIVITY_DATE DATE 7 NO This field identifies the date a record was added or
last updated
Date: 21-JUN-2004 Page: 155
TABLE: GTVCCRD
CREATOR: GENERAL
CREDIT CARD TYPE Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVCCRD_CODE VARCHAR2 10 NO CREDIT CARD TYPE CODE: Credit Card Type Code for
Credit Card Type.
GTVCCRD_DESC VARCHAR2 60 NO DESCRIPTION: Description of the Credit Card Type.
GTVCCRD_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user creating or updating the record.
GTVCCRD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the record was created or
updated.
Date: 21-JUN-2004 Page: 156
TABLE: GTVCELG
CREATOR: GENERAL
Certification of Eligibility Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVCELG_CODE VARCHAR2 6 NO ELIGIBILITY CODE: This field indicates Certification
of Eligibility Validation code.
GTVCELG_DESC VARCHAR2 30 NO DESCRIPTION: This field indicates Certification of
Eligibility Description.
GTVCELG_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user who changed the record.
GTVCELG_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or updated in the GTVCELG table.
Date: 21-JUN-2004 Page: 157
TABLE: GTVCURR
CREATOR: GENERAL
Currency conversion validation table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVCURR_CURR_CODE VARCHAR2 4 NO CURRENCY CODE: A code which uniquely identifies a type
of currency.
GTVCURR_RATE_EFF_DATE DATE 7 NO EFFECTIVE DATE: The effective date of this particular
record.
GTVCURR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that information for this
record on the table was entered or last updated.
GTVCURR_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification code of
the user.
GTVCURR_RATE_NCHG_DATE DATE 7 NO NEXT CHANGE DATE: The change date for this particular
record. I.E., if the record included a termination
date, the next change date would reflect the date that
the termination date was entered. Requires at future
change record.
GTVCURR_RATE_TERM_DATE DATE 7 YES TERMINATION DATE: The date when this particular record
is no longer in effect.
GTVCURR_TITLE VARCHAR2 35 NO TITLE: The description or title for this currency
code.
GTVCURR_STATUS_IND VARCHAR2 1 NO STATUS INDICATOR: The current status of the associated
validation table record.
GTVCURR_AP_ACCT VARCHAR2 6 YES ACCOUNTS PAYABLE ACCOUNT: Identifies the accounts
payable account code to be used if an entity intends
to produce a check in a foreign currency rather than
through a disbursing agent.
GTVCURR_NATION_CODE VARCHAR2 5 YES NATION CODE: Identifies the nation code associated
with this currency code.
GTVCURR_CONV_TYPE VARCHAR2 1 YES CONVERSION TYPE: Identifies the type of conversion
rate for this currency code. Type may be daily or
periodic.
GTVCURR_EXCH_ACCT VARCHAR2 6 YES EXCHANGE ACCOUNT: Identifies the account code to be
used when foreign currency checks are run and contains
the difference between the calculated exchange and
invoice amount at base currency.
GTVCURR_BANK_CODE VARCHAR2 2 YES BANK CODE: Identifies the bank code to be defaulted
when a foreign currency is used to post an invoice.
GTVCURR_DISB_AGENT_PIDM NUMBER 8 YES DISBURSING AGENT PIDM: Personal identifcation number
used when an entity intends to produce a check in base
currency with directions to a third party to produce
the foreign currency check.
GTVCURR_AP_ACCT2 VARCHAR2 60 YES Accounts Payable account related to currency
conversion for clients who do not have Banner Finance.
GTVCURR_EXCH_ACCT2 VARCHAR2 60 YES Exchange account related to currency conversion for
clients who do not have Banner Finance.
GTVCURR_SCOD_CODE_ISO VARCHAR2 3 YES ISO CODE: The three character International Standards
Organization (ISO) Standard Code associated with the
user defined currency code.
Date: 21-JUN-2004 Page: 158
TABLE: GTVDADD
CREATOR: GENERAL
Add-In code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVDADD_CODE VARCHAR2 15 NO ADD-IN CODE: The unique Add-In Code for the Visual
Basic Add-Ins.
GTVDADD_DESC VARCHAR2 30 NO ADD-IN DESCRIPTION: Description of the Add-In.
GTVDADD_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
GTVDADD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date the information for the table
on the record was entered or last updated.
Date: 21-JUN-2004 Page: 159
TABLE: GTVDICD
CREATOR: GENERAL
This table is used to subdivide geographic regions to capture cost center information by disctirct or division.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVDICD_CODE VARCHAR2 3 NO The district or division associated with an employee.
GTVDICD_DESC VARCHAR2 30 NO The description for the corresponding
district/division code
GTVDICD_ACTIVITY_DATE DATE 7 NO The date this row was updated.
Date: 21-JUN-2004 Page: 160
TABLE: GTVDIRO
CREATOR: GENERAL
Directory Options Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVDIRO_CODE VARCHAR2 8 NO DIRECTORY CODE: Code for Directory Item.
GTVDIRO_DESC VARCHAR2 30 NO DIRECTORY DESCRIPTION: Description for Directory Item.
GTVDIRO_SYSTEM_REQ_IND VARCHAR2 1 NO SYSTEM REQUIRED INDICATOR: System Required Indicator.
GTVDIRO_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of last activity on this record.
Date: 21-JUN-2004 Page: 161
TABLE: GTVDOCM
CREATOR: GENERAL
Document Code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVDOCM_CODE VARCHAR2 6 NO DOCUMENT CODE: This field indicates Document Code.
GTVDOCM_DESC VARCHAR2 30 NO DESCRIPTION: This field indicates Document
Description.
GTVDOCM_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user who changed the record.
GTVDOCM_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or updated in the GTVDOCM table.
Date: 21-JUN-2004 Page: 162
TABLE: GTVDPRP
CREATOR: GENERAL
Step Property Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVDPRP_CODE VARCHAR2 15 NO STEP PROPERTY CODE: The unique step property code.
GTVDPRP_DESC VARCHAR2 30 NO STEP PROPERTY DESCRIPTION: Description of the step
property.
GTVDPRP_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
GTVDPRP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date the information for the table
on the record was entered or last updated.
Date: 21-JUN-2004 Page: 163
TABLE: GTVDSTP
CREATOR: GENERAL
Step Type code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVDSTP_CODE VARCHAR2 15 NO STEP TYPE CODE: The unique step type Code for the
Wizard step which defines its properties.
GTVDSTP_DESC VARCHAR2 30 NO STEP TYPE DESCRIPTION: Description of the Data Lookup.
GTVDSTP_USER_ID VARCHAR2 30 NO USER ID: The unique identification code of the user.
GTVDSTP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date the information for the table
on the record was entered or last updated.
Date: 21-JUN-2004 Page: 164
TABLE: GTVDUNT
CREATOR: GENERAL
Duration Unit Code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVDUNT_CODE VARCHAR2 4 NO Duration Unit Code: The Duration Unit Code
GTVDUNT_DESC VARCHAR2 30 NO Description: Description of the duration unit code
GTVDUNT_NUMBER_OF_DAYS NUMBER 7 2 NO Number of Days per duration unit: Represents the
number of days that one duration unit would equate to
(ie 1 week equals 7 days)
GTVDUNT_ACTIVITY_DATE DATE 7 NO Activity Date: Date this record entered or last
updated
GTVDUNT_USER_ID VARCHAR2 30 NO User ID: The username of the person who entered or
last updated this record
GTVDUNT_VR_MSG_NO NUMBER 6 YES Voice Response Message Number
Date: 21-JUN-2004 Page: 165
TABLE: GTVEMAL
CREATOR: GENERAL
The GTVEMAL table contains the valid e-mail type codes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVEMAL_CODE VARCHAR2 4 NO A code identifying the type of e-mail address.
GTVEMAL_DESC VARCHAR2 60 YES The description of the e-mail address.
GTVEMAL_ACTIVITY_DATE DATE 7 NO The date on which the row was added or modified.
GTVEMAL_DISP_WEB_IND VARCHAR2 1 NO Display on Web Indicator, Y indicates this type of
email should display
GTVEMAL_URL_IND VARCHAR2 1 NO URL Indicator, Y indicates that this email record is
actually a URL.
Date: 21-JUN-2004 Page: 166
TABLE: GTVEMPH
CREATOR: GENERAL
Function Emphasis Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVEMPH_CODE VARCHAR2 10 NO Function Emphasis Code.
GTVEMPH_DESC VARCHAR2 30 NO Function Emphasis Code Description.
GTVEMPH_ACTIVITY_DATE DATE 7 NO Date that the Function Emphasis Code was added or last
changed.
GTVEMPH_COLL_CODE VARCHAR2 2 YES College code associated with the Function Emphasis
Code.
GTVEMPH_DEPT_CODE VARCHAR2 4 YES Department code associated with the Function Emphasis
Code.
Date: 21-JUN-2004 Page: 167
TABLE: GTVEQNM
CREATOR: GENERAL
Event Code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVEQNM_CODE VARCHAR2 20 NO EVENT CODE: Event Code for the Target System.
GTVEQNM_DESC VARCHAR2 30 NO DESCRIPTION: Description for the Event Code
GTVEQNM_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
GTVEQNM_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
record was entered or updated.
Date: 21-JUN-2004 Page: 168
TABLE: GTVEQPG
CREATOR: GENERAL
GROUP CODE Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVEQPG_CODE VARCHAR2 10 NO GROUP CODE: Group Code for Events
GTVEQPG_DESC VARCHAR2 30 NO DESCRIPTION: Description of the Group Code.
GTVEQPG_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
GTVEQPG_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
record was entered or updated.
Date: 21-JUN-2004 Page: 169
TABLE: GTVEQPM
CREATOR: GENERAL
Parameter Code Validation Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVEQPM_CODE VARCHAR2 100 NO PARAMETER CODE: Parameter Code for Events
GTVEQPM_DESC VARCHAR2 30 NO DESCRIPTION: Description for the Parameter Code.
GTVEQPM_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
GTVEQPM_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
record was entered or updated.
Date: 21-JUN-2004 Page: 170
TABLE: GTVEQTS
CREATOR: GENERAL
Target System Code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVEQTS_CODE VARCHAR2 10 NO TARGET SYSTEM CODE: Target System Code for Workflow
and Campus Pipeline Process
GTVEQTS_DESC VARCHAR2 30 NO DESCRIPTION: Target Sytem Code Description.
GTVEQTS_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user.
GTVEQTS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
record was entered or updated.
Date: 21-JUN-2004 Page: 171
TABLE: GTVEXPN
CREATOR: GENERAL
Expense Code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVEXPN_CODE VARCHAR2 2 NO Expense Code.
GTVEXPN_DESC VARCHAR2 30 NO Expense Code Description.
GTVEXPN_ACTIVITY_DATE DATE 7 NO Expense Code Activity Date.
Date: 21-JUN-2004 Page: 172
TABLE: GTVFEES
CREATOR: GENERAL
Fee Status Code Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVFEES_CODE VARCHAR2 5 NO Fee Status Code.
GTVFEES_DESC VARCHAR2 30 NO Fee Status Code Description.
GTVFEES_ACTIVITY_DATE DATE 7 NO Date Fee Status code was last created or modified.
GTVFEES_PAID_IND VARCHAR2 1 YES Indicator for whether or not person paid for function.
Date: 21-JUN-2004 Page: 173
TABLE: GTVFSTA
CREATOR: GENERAL
Function Status Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVFSTA_CODE VARCHAR2 1 NO Function Status Code.
GTVFSTA_DESC VARCHAR2 30 NO Function Status Code Description.
GTVFSTA_ACTIVITY_DATE DATE 7 NO Date on which the Status Code was created or last
modified.
GTVFSTA_ACTIVE_IND VARCHAR2 1 YES Status Code for the Function means that the function
is active or inactive.
Date: 21-JUN-2004 Page: 174
TABLE: GTVFTYP
CREATOR: GENERAL
Function Type Code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVFTYP_CODE VARCHAR2 6 NO Function Type Code
GTVFTYP_DESC VARCHAR2 30 NO Function Type Code Description.
GTVFTYP_ACTIVITY_DATE DATE 7 NO Function Type Code Activity Date.
Date: 21-JUN-2004 Page: 175
TABLE: GTVFUNC
CREATOR: GENERAL
Function Code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVFUNC_CODE VARCHAR2 12 NO Function Code.
GTVFUNC_DESC VARCHAR2 60 NO Function Code Description.
GTVFUNC_ETYP_CODE VARCHAR2 4 NO Default Function Event Type Code.
GTVFUNC_ACTIVITY_DATE DATE 7 NO Function Code Activity Date.
Date: 21-JUN-2004 Page: 176
TABLE: GTVINSM
CREATOR: GENERAL
Instructional Method Code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVINSM_CODE VARCHAR2 5 NO Instructional Method Code: The Instructional Method
Code
GTVINSM_DESC VARCHAR2 30 NO Description: Description of the instructional method
code
GTVINSM_ACTIVITY_DATE DATE 7 NO Activity Date: Date this record entered or last
updated
GTVINSM_USER_ID VARCHAR2 30 NO User ID: The username of the person who entered or
last updated this record
GTVINSM_VR_MSG_NO NUMBER 6 YES Voice Response Message Number
Date: 21-JUN-2004 Page: 177
TABLE: GTVLETR
CREATOR: GENERAL
Letter Process Letter Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVLETR_CODE VARCHAR2 15 NO This field identifies the letter code referenced on
the Recruiting Material Control Form (SRAMATL) and the
Letter Process Form (GUALETR).
GTVLETR_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created or updated.
GTVLETR_DUPL_IND VARCHAR2 1 NO Y = Duplicates may be printed for this letter code, N
= no dups.
GTVLETR_DESC VARCHAR2 30 YES This field specifies the recruiting letter/material
associated with the letter code.
GTVLETR_PRINT_COMMAND VARCHAR2 10 YES This field identifies alternate print command code
(e.g. PL - Print Landscape) for associated
letter/material.
GTVLETR_LETR_CODE_ALT VARCHAR2 15 YES Alternate Letter code for letter codes that do not
allow duplicates.
Date: 21-JUN-2004 Page: 178
TABLE: GTVMAIL
CREATOR: GENERAL
Mail Code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVMAIL_CODE VARCHAR2 3 NO Mail Code.
GTVMAIL_DESC VARCHAR2 30 NO Mail Code Description.
GTVMAIL_ACTIVITY_DATE DATE 7 NO Mail Code Activity Date.
GTVMAIL_DISP_WEB_IND VARCHAR2 1 NO Indicate whether a Mail Code should appear in Web for
Alumni.
Date: 21-JUN-2004 Page: 179
TABLE: GTVMENU
CREATOR: GENERAL
Menu Code Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVMENU_CODE VARCHAR2 10 NO Menu Code.
GTVMENU_DESC VARCHAR2 30 NO Menu Code Description.
GTVMENU_ACTIVITY_DATE DATE 7 NO Date menu code was last created or modified.
Date: 21-JUN-2004 Page: 180
TABLE: GTVMTYP
CREATOR: GENERAL
Meeting Type Code validation table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVMTYP_CODE VARCHAR2 4 NO Meeting Type Code: The Meeting Type Code
GTVMTYP_DESC VARCHAR2 30 NO Description: Description of the Meeting Type code
GTVMTYP_SYS_REQ_IND VARCHAR2 1 NO System Required Indicator: Indicates whether or not
this record is required to exist on the database
GTVMTYP_ACTIVITY_DATE DATE 7 NO Activty Date: Date this record entered or last updated
GTVMTYP_USER_ID VARCHAR2 30 NO User ID: The username of the person who entered or
last updated this record
GTVMTYP_VR_MSG_NO NUMBER 6 YES Voice Response Message Number
Date: 21-JUN-2004 Page: 181
TABLE: GTVNTYP
CREATOR: GENERAL
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVNTYP_CODE VARCHAR2 4 NO Name Type Code
GTVNTYP_DESC VARCHAR2 30 NO Name Type Code Description.
GTVNTYP_ACTIVITY_DATE DATE 7 NO
Date: 21-JUN-2004 Page: 182
TABLE: GTVOBJT
CREATOR: GENERAL
VBS Object Code Validation
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVOBJT_CODE VARCHAR2 10 NO This item identifies all valid object types within
BANNER.
GTVOBJT_DESC VARCHAR2 80 NO This item contains the description for the code.
GTVOBJT_ACTIVITY_DATE DATE 7 NO This item contains the date when the item was created
or last modified.
Date: 21-JUN-2004 Page: 183
TABLE: GTVPARA
CREATOR: GENERAL
Letter Process Paragraph Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVPARA_CODE VARCHAR2 7 NO This field identifies the paragraph code referenced by
the General Letter Process Form (GUALETR).
GTVPARA_DESC VARCHAR2 30 YES This field specifies the paragraph associated with the
paragraph code.
GTVPARA_COMMENT VARCHAR2 240 YES This field maintains a comment associated with the
paragraph. It is NOT printed in letter.
GTVPARA_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created or updated.
Date: 21-JUN-2004 Page: 184
TABLE: GTVPARS
CREATOR: GENERAL
Validation entries for Partition codes. Partition Codes define campus zones, which are catagories or groupings of
rooms.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVPARS_CODE VARCHAR2 7 NO Partition code for campus zones for scheduling
product.
GTVPARS_DESC VARCHAR2 30 NO Description of partition code for scheduling product.
GTVPARS_SCHEDULER_NUMBER NUMBER 2 NO Numeric identifying value for partition code for
scheduling product.
GTVPARS_USER_ID VARCHAR2 30 NO This field identifies the user wholast updated the
record
GTVPARS_ACTIVITY_DATE DATE 7 NO This field identifies the most recent date a record
was created/updated
GTVPARS_CAMP_CODE VARCHAR2 3 YES Campus code associated with partition for scheduling
product.
Date: 21-JUN-2004 Page: 185
TABLE: GTVPDIR
CREATOR: GENERAL
Pre/Post direction table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVPDIR_CODE VARCHAR2 2 NO
GTVPDIR_ACTIVITY_DATE DATE 7 NO
GTVPDIR_USER_ID VARCHAR2 30 NO
GTVPDIR_DESC VARCHAR2 15 NO
Date: 21-JUN-2004 Page: 186
TABLE: GTVPRNT
CREATOR: GENERAL
Printer Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVPRNT_CODE VARCHAR2 30 NO PRINTER CODE: Printer code.
GTVPRNT_DESC VARCHAR2 30 NO DESCRIPTION: Description of print code.
GTVPRNT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date of record creation or last
modification.
GTVPRNT_PRINTER_COMMAND VARCHAR2 255 YES Host specific command to direct printout to this
printer and options.
GTVPRNT_PRINTER_PORT VARCHAR2 60 YES GTVPRNT_PRINTER_PORT: This column contains the path to
a network printer. It is used by the GJIREVO form
when printing from a PC based system. The name of a
local LPT device could also be used.
GTVPRNT_LANDSCAPE_CDE VARCHAR2 200 YES GTVPRNT_LANDSCAPE_CODE: This is the hex escape
sequence needed by the device named in
GTVPRNT_PRINTER_PORT that tells the printer how to
switch to landscape print mode.
GTVPRNT_LANDSCAPE_STRING VARCHAR2 2000 YES GTVPRNT_LANDSCAPE_STRING: This is a sequence of
concatenated chr values that are parsed using DBMS_SQL
to generate the GTVPRNT_LANDSCAPE_CODE.
GTVPRNT_PORTRAIT_STRING VARCHAR2 2000 YES GTVPRNT_PORTRAIT_STRING: This is a sequence of
concatenated chr values that are parsed using DBMS_SQL
to generate the GTVPRNT_PORTRAIT_CODE.
GTVPRNT_PORTRAIT_CDE VARCHAR2 200 YES GTVPRNT_PORTRAIT_CODE: This is the hex escape sequence
needed by the device named in GTVPRNT_PRINTER_PORT
that tells the printer how to switch to portrait print
mode.
Date: 21-JUN-2004 Page: 187
TABLE: GTVPROC
CREATOR: GENERAL
PROCESS NAME Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVPROC_CODE VARCHAR2 30 NO PROCESS NAME CODE: Process Name Code used by SCT
Banner Processes, for example WEBCCADMFEES identifying
the process that accepts payment of Admissions fees
via credit card.
GTVPROC_DESC VARCHAR2 60 NO DESCRIPTION: Description of the Process Name Code.
GTVPROC_SYS_REQ_IND VARCHAR2 1 NO SYSTEM REQUIRED INDICATOR: System Required Indicator
associated with the Process Name Code. A Y in this
column indicates that this row is required for
production processing.
GTVPROC_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user creating or updating the record.
GTVPROC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the record was created or
updated.
Date: 21-JUN-2004 Page: 188
TABLE: GTVPTYP
CREATOR: GENERAL
Participant Type Code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVPTYP_CODE VARCHAR2 5 NO Participant Type Code.
GTVPTYP_DESC VARCHAR2 30 NO Participant Type Code Description.
GTVPTYP_ACTIVITY_DATE DATE 7 NO Participant Type Code Activity Date.
Date: 21-JUN-2004 Page: 189
TABLE: GTVPURP
CREATOR: GENERAL
Function Purpose Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVPURP_CODE VARCHAR2 10 NO Function Purpose Code.
GTVPURP_DESC VARCHAR2 60 NO Function Purpose Code Description.
GTVPURP_ACTIVITY_DATE DATE 7 NO Date the Purpose Code was created or last modified.
Date: 21-JUN-2004 Page: 190
TABLE: GTVRATE
CREATOR: GENERAL
Rate Code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVRATE_CODE VARCHAR2 6 NO Rate Code.
GTVRATE_DESC VARCHAR2 30 NO Rate Code Description.
GTVRATE_ACTIVITY_DATE DATE 7 NO Rate Code Activity Date.
Date: 21-JUN-2004 Page: 191
TABLE: GTVREVN
CREATOR: GENERAL
Function Revenue Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVREVN_CODE VARCHAR2 2 NO Function Revenue Code.
GTVREVN_DESC VARCHAR2 30 NO Function Revenue Code Description.
GTVREVN_ACTIVITY_DATE DATE 7 NO Date the Revenue Code was created or last modified.
Date: 21-JUN-2004 Page: 192
TABLE: GTVRSVP
CREATOR: GENERAL
RSVP Code Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVRSVP_CODE VARCHAR2 6 NO RSVP Code.
GTVRSVP_DESC VARCHAR2 30 NO RSVP Code Description.
GTVRSVP_ACTIVITY_DATE DATE 7 NO Date RSVP code was last created or modified.
GTVRSVP_PLAN_TO_ATTEND_IND VARCHAR2 1 NO Indicator for whether or not person plans to attend
function.
Date: 21-JUN-2004 Page: 193
TABLE: GTVRTNG
CREATOR: GENERAL
Rating Code Validation Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVRTNG_CODE VARCHAR2 2 NO Rating Code.
GTVRTNG_DESC VARCHAR2 30 NO Rating Code Description.
GTVRTNG_ACTIVITY_DATE DATE 7 NO Rating Code Activity Date.
Date: 21-JUN-2004 Page: 194
TABLE: GTVSCHS
CREATOR: GENERAL
Validation entries for Schedule Status Codes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSCHS_CODE VARCHAR2 3 NO Code for Schedule Status.
GTVSCHS_DESC VARCHAR2 30 NO Description of Schedule Status code.
GTVSCHS_SYSTEM_REQ_IND VARCHAR2 1 NO A Y in this column indicates that the row is delivered
by SCT and required for the system.
GTVSCHS_ACTIVITY_DATE DATE 7 NO This field identifies the date a record was created or
updated.
Date: 21-JUN-2004 Page: 195
TABLE: GTVSCOD
CREATOR: GENERAL
EDI STANDARD CODE VALIDATION TABLE: This table contains the standard EDI codes based on element id and standards
organization. Data in this table is used to create cross references to various user defined codes that need to
be
sent in EDI transactions/messages.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSCOD_ELEMENT_ID VARCHAR2 4 NO EDI STANDARD ELEMENT ID: The numeric identifier
associated with the element as defined by the EDI
Standards being used.
GTVSCOD_CODE VARCHAR2 8 NO EDI CODE: The EDI Standard code value associated with
the Standard being used.
GTVSCOD_DESC VARCHAR2 80 NO EDI CODE DESCRIPTION: The description of the EDI
Standard Code.
GTVSCOD_STANDARD_IND VARCHAR2 1 NO EDI STANDARD: A one character code indicating which
EDI Standards Organization the code comes from.
GTVSCOD_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date the row was last updated.
GTVSCOD_USER_ID VARCHAR2 30 NO USER ID: The last user that updated the row.
Date: 21-JUN-2004 Page: 196
TABLE: GTVSDAX
CREATOR: GENERAL
SDA crosswalk/conversion table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSDAX_EXTERNAL_CODE VARCHAR2 15 NO Banner/concept code for to be retrieved
GTVSDAX_INTERNAL_CODE VARCHAR2 10 NO The pre-determined SDA retrieval code
GTVSDAX_REPORTING_DATE DATE 7 YES The date column used for various reporting needs
GTVSDAX_TRANSLATION_CODE VARCHAR2 15 YES The hard-coded translation of the user defined
external code, eg. Freshman, PUB for Public School,
etc
GTVSDAX_INTERNAL_CODE_SEQNO NUMBER 2 YES The sequence number for internal codes requiring
multiple values
GTVSDAX_INTERNAL_CODE_GROUP VARCHAR2 20 NO The group typing for translated or crosswalked values
to specifically identify which grouping each series of
codes belongs too
GTVSDAX_DESC VARCHAR2 30 NO The description of the SDA code/concept
GTVSDAX_SYSREQ_IND VARCHAR2 1 YES A Y in this field indicates that this row is required
for production processing
GTVSDAX_ACTIVITY_DATE DATE 7 NO The last activity date for this row of data
Date: 21-JUN-2004 Page: 197
TABLE: GTVSDIV
CREATOR: GENERAL
Subdivision table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSDIV_CODE VARCHAR2 4 NO
GTVSDIV_ACTIVITY_DATE DATE 7 NO
GTVSDIV_USER_ID VARCHAR2 30 NO
GTVSDIV_DESC VARCHAR2 25 NO
Date: 21-JUN-2004 Page: 198
TABLE: GTVSEGC
CREATOR: GENERAL
Access Group Validation
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSEGC_CODE VARCHAR2 15 NO Access Group Code
GTVSEGC_DESC VARCHAR2 30 NO Access Group Description
GTVSEGC_ACTIVITY_DATE DATE 7 NO Date or Insert or Last Update
Date: 21-JUN-2004 Page: 199
TABLE: GTVSQPA
CREATOR: GENERAL
SQL Process Parameter Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSQPA_CODE VARCHAR2 30 NO PARAMETER CODE: Parameter code.
GTVSQPA_DESC VARCHAR2 60 NO PARAMETER DESCRIPTION: Description of the parameter
code.
GTVSQPA_DATA_TYPE_CDE VARCHAR2 1 NO DATA TYPE INDICATOR: Indicates whether this parameter
is (C)haracter, (N)umber or (D)ate.
GTVSQPA_START_DATE DATE 7 NO START DATE: Date code became effective.
GTVSQPA_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The most recent date a record was
created or updated
GTVSQPA_USER_ID VARCHAR2 30 NO USER ID: The most recent user to create or update a
record.
GTVSQPA_END_DATE DATE 7 YES END DATE: Date code became obsolete.
Date: 21-JUN-2004 Page: 200
TABLE: GTVSQPR
CREATOR: GENERAL
Validation entries for SQL Process Codes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSQPR_CODE VARCHAR2 30 NO PROCESS CODE: Process code for dynamic SQL processing.
GTVSQPR_DESC VARCHAR2 60 NO PROCESS CODE DESCRIPTION: Description of SQL process
code.
GTVSQPR_SYS_REQ_IND VARCHAR2 1 NO SYSTEM REQUIRED INDICATOR: This field identifies
whether or not this code is required by the system.
GTVSQPR_START_DATE DATE 7 NO START DATE: Date code became effective.
GTVSQPR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field identifies the most recent
date a record was created or updated.
GTVSQPR_USER_ID VARCHAR2 30 NO USER ID: This field identifies the most recent user to
create or update a record.
GTVSQPR_END_DATE DATE 7 YES END DATE: Date code became obsolete.
Date: 21-JUN-2004 Page: 201
TABLE: GTVSQRU
CREATOR: GENERAL
Validation entries for SQL Rule Codes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSQRU_CODE VARCHAR2 30 NO RULE CODE: Rule code for dynamic SQL rules.
GTVSQRU_DESC VARCHAR2 60 NO RULE CODE DESCRIPTION: Description of dynamic SQL rule
code.
GTVSQRU_SYS_REQ_IND VARCHAR2 1 NO SYSTEM REQUIRED INDICATOR: This field identifies
whether or not this code is required by the system.
GTVSQRU_START_DATE DATE 7 NO START DATE: Date code became effective.
GTVSQRU_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field identifies the most recent
date a record was created or updated.
GTVSQRU_USER_ID VARCHAR2 30 NO USER ID: This field identifies the most recent user to
create or update a record.
GTVSQRU_END_DATE DATE 7 YES END DATE: Date code became obsolete.
Date: 21-JUN-2004 Page: 202
TABLE: GTVSRCE
CREATOR: GENERAL
Visa Source Code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSRCE_CODE VARCHAR2 6 NO SOURCE CODE: This field indicates Source Code
Validation code.
GTVSRCE_DESC VARCHAR2 30 NO DESCRIPTION: This field indicates Source Description.
GTVSRCE_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user who changed the record.
GTVSRCE_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or updated in the GTVSRCD table.
Date: 21-JUN-2004 Page: 203
TABLE: GTVSSFX
CREATOR: GENERAL
Suffix table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSSFX_CODE VARCHAR2 6 NO
GTVSSFX_ACTIVITY_DATE DATE 7 NO
GTVSSFX_USER_ID VARCHAR2 30 NO
GTVSSFX_DESC VARCHAR2 15 NO
Date: 21-JUN-2004 Page: 204
TABLE: GTVSUBJ
CREATOR: GENERAL
Subject Index Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSUBJ_CODE VARCHAR2 6 NO Subject Index Code.
GTVSUBJ_DESC VARCHAR2 30 NO Subject Index Code Description.
GTVSUBJ_ACTIVITY_DATE DATE 7 NO Date on which the Code was created or last modified.
Date: 21-JUN-2004 Page: 205
TABLE: GTVSVAP
CREATOR: GENERAL
Validation entries for SEVIS Auto-populate codes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSVAP_CODE VARCHAR2 30 NO AUTO-POPULATE ELEMENT CODE: Name of element to be
auto-populated.
GTVSVAP_DESC VARCHAR2 60 NO AUTO-POPULATE ELEMENT CODE DESCRIPTION: Description of
SEVIS auto-populate element code.
GTVSVAP_SYS_REQ_IND VARCHAR2 1 NO SYSTEM REQUIRED INDICATOR: This field identifies
whether or not this code is required by the system.
GTVSVAP_START_DATE DATE 7 NO START DATE: Date SEVIS auto-populate code starts.
GTVSVAP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field identifies the most recent
date a record was created or updated.
GTVSVAP_USER_ID VARCHAR2 30 NO USER ID: This field identifies the most recent user to
create or update a record.
GTVSVAP_END_DATE DATE 7 YES END DATE: Date SEVIS auto-populate code became
obsolete.
Date: 21-JUN-2004 Page: 206
TABLE: GTVSVBA
CREATOR: GENERAL
Validation entries for SEVIS Business Action Codes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSVBA_CODE VARCHAR2 30 NO BUSINESS ACTION CODE: SEVIS business action code.
GTVSVBA_DESC VARCHAR2 60 NO BUSINESS ACTION CODE DESCRIPTION: Description of SEVIS
business action code.
GTVSVBA_SYS_REQ_IND VARCHAR2 1 NO SYSTEM REQUIRED INDICATOR: This field identifies
whether or not this code is required by the system.
GTVSVBA_DBPROC_NAME VARCHAR2 100 NO PROCEDURE NAME: Procedure to be executed if business
action is TRUE.
GTVSVBA_START_DATE DATE 7 NO START DATE: Date Business action code starts.
GTVSVBA_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field identifies the most recent
date a record was created or updated.
GTVSVBA_USER_ID VARCHAR2 30 NO USER ID: This field identifies the most recent user to
create or update a record.
GTVSVBA_END_DATE DATE 7 YES END DATE: Date Business Action code became obsolete.
Date: 21-JUN-2004 Page: 207
TABLE: GTVSVCC
CREATOR: GENERAL
Validation entries for SEVIS Category Codes for Exchange Visitor program.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSVCC_CODE VARCHAR2 3 NO CATEGORY CODE: Exchange Visitor Category Code for
SEVIS Reporting.
GTVSVCC_DESC VARCHAR2 60 NO CATEGORY DESCRIPTION: Description of SEVIS exchange
visitor category code.
GTVSVCC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field identifies the most recent
date a record was created or updated.
GTVSVCC_USER_ID VARCHAR2 30 NO USER ID: This field identifies the most recent user to
create or update a record.
Date: 21-JUN-2004 Page: 208
TABLE: GTVSVCP
CREATOR: GENERAL
Validation entries for SEVIS Consular Post Codes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSVCP_CODE VARCHAR2 3 NO CONSULAR POST CODE: Consular Post for SEVIS Reporting.
GTVSVCP_DESC VARCHAR2 30 NO CONSULAR POST CODE DESCRIPTION: Description of SEVIS
consular post code.
GTVSVCP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field identifies the most recent
date a record was created or updated.
GTVSVCP_USER_ID VARCHAR2 30 NO USER ID: This field identifies the most recent user to
create or update a record.
Date: 21-JUN-2004 Page: 209
TABLE: GTVSVCR
CREATOR: GENERAL
Validation entries for SEVIS Creation Reason codes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSVCR_CODE VARCHAR2 4 NO CREATION REASON CODE: Creation Reason code for SEVIS
Reporting.
GTVSVCR_DESC VARCHAR2 30 NO CREATION REASON DESCRIPTION: Description of SEVIS
Creation Reason code.
GTVSVCR_USAGE_IND VARCHAR2 1 NO CREATION REASON USAGE INDICATOR: Defines if SEVIS
Creation Reason code is for a student(1) or exchange
visitor(2).
GTVSVCR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field identifies the most recent
date a record was created or updated.
GTVSVCR_USER_ID VARCHAR2 30 NO USER ID: This field identifies the most recent user to
create or update a record.
Date: 21-JUN-2004 Page: 210
TABLE: GTVSVDT
CREATOR: GENERAL
Validation entries for SEVIS Dependent Termination codes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSVDT_CODE VARCHAR2 2 NO DEPENDENT TERMINATION CODE: Dependent Termination code
for SEVIS Reporting.
GTVSVDT_DESC VARCHAR2 30 NO DEPENDENT TERMINATION DESCRIPTION: Description of
SEVIS Dependent Termination code.
GTVSVDT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field identifies the most recent
date a record was created or updated.
GTVSVDT_USER_ID VARCHAR2 30 NO USER ID: This field identifies the most recent user to
create or update a record.
Date: 21-JUN-2004 Page: 211
TABLE: GTVSVEL
CREATOR: GENERAL
Validation entries for SEVIS Educational Level codes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSVEL_CODE VARCHAR2 2 NO EDUCATIONAL LEVEL CODE: Educational Level code for
SEVIS Reporting.
GTVSVEL_DESC VARCHAR2 30 NO EDUCATIONAL LEVEL DESCRIPTION: Description of SEVIS
Educational Level code.
GTVSVEL_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field identifies the most recent
date a record was created or updated.
GTVSVEL_USER_ID VARCHAR2 30 NO USER ID: This field identifies the most recent user to
create or update a record.
Date: 21-JUN-2004 Page: 212
TABLE: GTVSVEP
CREATOR: GENERAL
Validation entries for SEVIS End EV Program Reason codes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSVEP_CODE VARCHAR2 4 NO END EV PROGRAM REASON CODE: End Exchange Visitor
Program Reason code for SEVIS Reporting.
GTVSVEP_DESC VARCHAR2 30 NO END EV PROGRAM REASON DESCRIPTION: Description of
SEVIS End Exchange Visitor Program Reason code.
GTVSVEP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field identifies the most recent
date a record was created or updated.
GTVSVEP_USER_ID VARCHAR2 30 NO USER ID: This field identifies the most recent user to
create or update a record.
Date: 21-JUN-2004 Page: 213
TABLE: GTVSVFT
CREATOR: GENERAL
Validation entries for SEVIS Drop Below Full Time Reason codes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSVFT_CODE VARCHAR2 2 NO DROP BELOW FULL TIME STATUS REASON CODE: Drop Below
Full Time Reason code for SEVIS Reporting.
GTVSVFT_DESC VARCHAR2 30 NO DROP BELOW FULL TIME STATUS REASON DESCRIPTION:
Description of SEVIS Drop Below Full Time Reason code.
GTVSVFT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field identifies the most recent
date a record was created or updated.
GTVSVFT_USER_ID VARCHAR2 30 NO USER ID: This field identifies the most recent user to
create or update a record.
Date: 21-JUN-2004 Page: 214
TABLE: GTVSVGO
CREATOR: GENERAL
Validation entries for SEVIS Governmental Organization Codes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSVGO_CODE VARCHAR2 6 NO GOVERNMENTAL ORGANIZATION CODE: Governmental
organization code for SEVIS Reporting.
GTVSVGO_DESC VARCHAR2 30 NO GOVERNMENTAL CODE DESCRIPTION: Description of SEVIS
governmental organization code.
GTVSVGO_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field identifies the most recent
date a record was created or updated.
GTVSVGO_USER_ID VARCHAR2 30 NO USER ID: This field identifies the most recent user to
create or update a record.
Date: 21-JUN-2004 Page: 215
TABLE: GTVSVIO
CREATOR: GENERAL
Validation entries for SEVIS International Organization Codes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSVIO_CODE VARCHAR2 6 NO INTERNATIONAL ORGANIZATION CODE: International
organization code for SEVIS Reporting.
GTVSVIO_DESC VARCHAR2 30 NO INTERNATIONAL CODE DESCRIPTION: Description of SEVIS
international organization code.
GTVSVIO_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field identifies the most recent
date a record was created or updated.
GTVSVIO_USER_ID VARCHAR2 30 NO USER ID: This field identifies the most recent user to
create or update a record.
Date: 21-JUN-2004 Page: 216
TABLE: GTVSVIT
CREATOR: GENERAL
Validation entries for SEVIS Infraction Type Codes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSVIT_CODE VARCHAR2 3 NO Infraction TYPE CODE: Exchange Visitor Infraction Type
Code for SEVIS Reporting.
GTVSVIT_DESC VARCHAR2 60 NO INFRACTION TYPE DESCRIPTION: Description of SEVIS
exchange visitor infraction type code.
GTVSVIT_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field identifies the most recent
date a record was created or updated.
GTVSVIT_USER_ID VARCHAR2 30 NO USER ID: This field identifies the most recent user to
create or update a record.
Date: 21-JUN-2004 Page: 217
TABLE: GTVSVPC
CREATOR: GENERAL
Validation entries for SEVIS Position Codes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSVPC_CODE VARCHAR2 3 NO POSITION CODE: Exchange Visitor Position Code for
SEVIS Reporting.
GTVSVPC_DESC VARCHAR2 30 NO POSITION CODE DESCRIPTION: Description of SEVIS
exchange visitor position code.
GTVSVPC_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field identifies the most recent
date a record was created or updated.
GTVSVPC_USER_ID VARCHAR2 30 NO USER ID: This field identifies the most recent user to
create or update a record.
Date: 21-JUN-2004 Page: 218
TABLE: GTVSVRP
CREATOR: GENERAL
Validation entries for SEVIS Request for Form Reprint codes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSVRP_CODE VARCHAR2 2 NO REQUEST FOR FORM REPRINT CODE: Request for Form
Reprint code for SEVIS Reporting.
GTVSVRP_DESC VARCHAR2 30 NO REQUEST FOR FORM REPRINT DESCRIPTION: Description of
SEVIS Request for Form Reprint code.
GTVSVRP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field identifies the most recent
date a record was created or updated.
GTVSVRP_USER_ID VARCHAR2 30 NO USER ID: This field identifies the most recent user to
create or update a record.
Date: 21-JUN-2004 Page: 219
TABLE: GTVSVTR
CREATOR: GENERAL
Validation entries for SEVIS Termination Reason codes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSVTR_CODE VARCHAR2 6 NO TERMINATION REASON CODE: Termination Reason code for
SEVIS Reporting.
GTVSVTR_DESC VARCHAR2 30 NO TERMINATION REASON DESCRIPTION: Description of SEVIS
Termination Reason code.
GTVSVTR_USAGE_IND VARCHAR2 1 NO TERMINATION REASON USAGE INDICATOR: Defines if SEVIS
Termination Reason code is for a student(1) or
exchange visitor(2).
GTVSVTR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE:This field identifies the most recent
date a record was created or updated.
GTVSVTR_USER_ID VARCHAR2 30 NO USER ID: This field identifies the most recent user to
create or update a record.
Date: 21-JUN-2004 Page: 220
TABLE: GTVSVTS
CREATOR: GENERAL
Validation entries for SEVIS Transmittal Status Codes.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSVTS_CODE VARCHAR2 1 NO STATUS CODE: Transmittal status Code for SEVIS batch
reporting.
GTVSVTS_DESC VARCHAR2 30 NO STATUS CODE DESCRIPTION: Description of SEVIS
transmittal status code.
GTVSVTS_SYSTEM_REQ_IND VARCHAR2 1 NO SYSTEM REQUIRED INDICATOR: System required indicator
for SEVIS transmittal status code.
GTVSVTS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: This field identifies the most recent
date a record was created or updated.
GTVSVTS_USER_ID VARCHAR2 30 NO USER ID: This field identifies the most recent user to
create or update a record.
Date: 21-JUN-2004 Page: 221
TABLE: GTVSYSI
CREATOR: GENERAL
System Indicator Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVSYSI_CODE VARCHAR2 2 NO CODE: System indicator which uniquely identifies this
record.
GTVSYSI_DESC VARCHAR2 30 NO DESCRIPTION: Description of this code.
GTVSYSI_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date that record was created or last
updated.
Date: 21-JUN-2004 Page: 222
TABLE: GTVTARG
CREATOR: GENERAL
Target Audience Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVTARG_CODE VARCHAR2 5 NO Target Audience Code.
GTVTARG_DESC VARCHAR2 30 NO Target Audience Code Description.
GTVTARG_ACTIVITY_DATE DATE 7 NO Date on which the Code was created or last modified.
Date: 21-JUN-2004 Page: 223
TABLE: GTVTASK
CREATOR: GENERAL
Function Task Code Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVTASK_CODE VARCHAR2 10 NO Function Task Code.
GTVTASK_DESC VARCHAR2 30 NO Function Task Type Code Description.
GTVTASK_ACTIVITY_DATE DATE 7 NO Date function task type code was last created or
modified.
GTVTASK_TTYP_CODE VARCHAR2 5 YES Function Task Type Code.
Date: 21-JUN-2004 Page: 224
TABLE: GTVTRTP
CREATOR: GENERAL
EDI Transaction Type Code Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVTRTP_CODE VARCHAR2 2 NO EDI TRANSACTION TYPE CODE: The two character
transaction type code assigned to an EDI
Transaction/Message.
GTVTRTP_DESC VARCHAR2 30 NO TRANSACTION TYPE DESCRIPTION: The description of the
two character transaction type code.
GTVTRTP_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date the column was last updated.
GTVTRTP_USER_ID VARCHAR2 30 NO USER ID: The user id of the last user who updated the
column.
Date: 21-JUN-2004 Page: 225
TABLE: GTVTSTA
CREATOR: GENERAL
Task Status Type Code Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVTSTA_CODE VARCHAR2 6 NO Task Status Type Code.
GTVTSTA_DESC VARCHAR2 30 NO Task Status Type Code Description.
GTVTSTA_ACTIVITY_DATE DATE 7 NO Date task status type code was last created or
modified.
GTVTSTA_COMPL_IND VARCHAR2 1 YES Indicator for whether task is completed or not.
Date: 21-JUN-2004 Page: 226
TABLE: GTVTTYP
CREATOR: GENERAL
Task Type Code Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVTTYP_CODE VARCHAR2 5 NO Task Type Code.
GTVTTYP_DESC VARCHAR2 30 NO Task Type Code Description.
GTVTTYP_ACTIVITY_DATE DATE 7 NO Date task type code was last created or modified.
Date: 21-JUN-2004 Page: 227
TABLE: GTVUOMS
CREATOR: GENERAL
Unit of Measure Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVUOMS_CODE VARCHAR2 4 NO A code representing the unit of measure used in height
and weight.
GTVUOMS_DESC VARCHAR2 30 NO Descriptive text about the unit of measure code.
GTVUOMS_ACTIVITY_DATE DATE 7 NO The date that the record was inserted or last updated.
GTVUOMS_USER_ID VARCHAR2 30 NO The ORACLE user id of the person last updating this
record.
Date: 21-JUN-2004 Page: 228
TABLE: GTVUTYP
CREATOR: GENERAL
Unit type table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVUTYP_CODE VARCHAR2 6 NO
GTVUTYP_ACTIVITY_DATE DATE 7 NO
GTVUTYP_USER_ID VARCHAR2 30 NO
GTVUTYP_DESC VARCHAR2 35 NO
Date: 21-JUN-2004 Page: 229
TABLE: GTVVAPP
CREATOR: GENERAL
VBS Application Code Values
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVVAPP_CODE VARCHAR2 15 NO VBS Application Code
GTVVAPP_DESC VARCHAR2 30 NO Application Description
GTVVAPP_VBTY_CODE VARCHAR2 1 NO VBS Application Type Code
GTVVAPP_PATTERN_CTRL NUMBER 4 NO Application Pattern Control
GTVVAPP_SYS_REQ_IND VARCHAR2 1 NO System Required Indicator
GTVVAPP_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
Date: 21-JUN-2004 Page: 230
TABLE: GTVVBTY
CREATOR: GENERAL
VBS Application Type Code
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVVBTY_CODE VARCHAR2 1 NO VBS Type Code
GTVVBTY_DESC VARCHAR2 30 NO VBS Type Description
GTVVBTY_SYS_REQ_IND VARCHAR2 1 NO System Required Indicator
GTVVBTY_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
Date: 21-JUN-2004 Page: 231
TABLE: GTVVISS
CREATOR: GENERAL
Visa Issuing Authority Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVVISS_CODE VARCHAR2 6 NO AUTHORITY CODE: This field indicates Visa Issuing
Authority Validation code.
GTVVISS_DESC VARCHAR2 30 NO DESCRIPTION: This field indicates Visa Issuing
Authority Description.
GTVVISS_USER_ID VARCHAR2 30 NO USER IDENTIFICATION: The unique identification of the
user who changed the record.
GTVVISS_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: The date that the information for the
row was inserted or updated in the GTVVISS table.
Date: 21-JUN-2004 Page: 232
TABLE: GTVVOBJ
CREATOR: GENERAL
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVVOBJ_CODE VARCHAR2 15 NO VBS Object Code
GTVVOBJ_DESC VARCHAR2 30 NO VBS Object Description
GTVVOBJ_PATTERN_CTRL NUMBER 4 NO VBS Object Pattern Control NUmber
GTVVOBJ_SYS_REQ_IND VARCHAR2 1 NO System Required Indicator
GTVVOBJ_ACTIVITY_DATE DATE 7 NO Date of Insert or Last Update
Date: 21-JUN-2004 Page: 233
TABLE: GTVWFED
CREATOR: GENERAL
Workflow Electronic Documents Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVWFED_CODE VARCHAR2 20 NO DOCUMENT TYPE: Electronic Document Type Code
GTVWFED_DESC VARCHAR2 60 NO DESCRIPTION: Electronic Document Type Code Description
GTVWFED_USER_ID VARCHAR2 30 NO USER ID: Oracle User Id
GTVWFED_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Activity Date when transaction was
created
Date: 21-JUN-2004 Page: 234
TABLE: GTVZIPC
CREATOR: GENERAL
Zip Code Validation Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GTVZIPC_CODE VARCHAR2 10 NO This field contains the zip code defined by the postal
service
GTVZIPC_CITY VARCHAR2 20 NO This field defines the city most defined by the zip
code
GTVZIPC_STAT_CODE VARCHAR2 3 YES This field contains the state most defined by the zip
code
GTVZIPC_NATN_CODE VARCHAR2 5 YES This field contains the nation code associated with
the zip code
GTVZIPC_ACTIVITY_DATE DATE 7 NO This system maintained field specifies the date this
record was created or
updated.
GTVZIPC_USER_ID VARCHAR2 30 NO This system maintained field specifies the user that
created or updated this
record.
GTVZIPC_CNTY_CODE VARCHAR2 5 YES
Date: 21-JUN-2004 Page: 235
TABLE: GUBBHLP
CREATOR: GENERAL
Banner Dynamic help table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBBHLP_FORM_NAME VARCHAR2 30 NO Form name
GUBBHLP_BLOCK_NAME VARCHAR2 30 YES Block name
GUBBHLP_FIELD_NAME VARCHAR2 30 YES Field name
GUBBHLP_TEXT LONG NO Last date help was either created or updated
GUBBHLP_ACTIVITY_DATE DATE 7 NO Banner help commments
Date: 21-JUN-2004 Page: 236
TABLE: GUBGISL
CREATOR: GENERAL
Geographic information system location address table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBGISL_POINTER NUMBER 8 NO Points to address.
GUBGISL_STREET_NUMBER VARCHAR2 10 YES Street number.
GUBGISL_STREET_NAME VARCHAR2 30 NO Street name.
GUBGISL_SSFX_CODE VARCHAR2 6 YES Street suffix (St, Ave, etc.)
GUBGISL_ZIPC_CODE VARCHAR2 10 NO Postal code.
GUBGISL_ZIPC_CITY VARCHAR2 20 NO City.
GUBGISL_STREET_NUM_FRAC VARCHAR2 3 YES Fractional part of street number.
GUBGISL_PRE_DIR_CODE VARCHAR2 2 YES Pre-direction (N,S,E,W, NW, NE, SW, SE, etc.)
GUBGISL_POST_DIR_CODE VARCHAR2 2 YES Post-direction (N,S,E,W, NW, NE, SW, SE, etc.)
GUBGISL_UTYP_CODE VARCHAR2 6 YES Type of unit (Apt, Suite, etc.)
GUBGISL_UNIT_NUMBER VARCHAR2 10 YES Unit number
GUBGISL_ACTIVITY_DATE DATE 7 NO Last activity date.
GUBGISL_USER_ID VARCHAR2 30 NO Last user to update.
GUBGISL_EFFECTIVE_DATE DATE 7 YES Effective status date.
GUBGISL_PARCEL_ID VARCHAR2 35 YES Parcel identification.
GUBGISL_SDIV_CODE VARCHAR2 4 YES Subdivision code.
GUBGISL_CAR_RT VARCHAR2 4 YES Carrier route.
GUBGISL_DELIV_POINT VARCHAR2 2 YES Delivery point.
GUBGISL_BAR_CODE_CHK NUMBER 2 YES Barcode check digits.
GUBGISL_ADDR_LINE_1 VARCHAR2 30 YES Street address line one.
GUBGISL_ADDR_LINE_2 VARCHAR2 30 YES Street address line two.
GUBGISL_MAP_REF_01 VARCHAR2 40 YES User-definable map reference field.
GUBGISL_MAP_REF_02 VARCHAR2 40 YES User-definable map reference field.
GUBGISL_MAP_REF_03 VARCHAR2 40 YES User-definable map reference field.
GUBGISL_MAP_REF_04 VARCHAR2 40 YES User-definable map reference field.
GUBGISL_MAP_REF_05 VARCHAR2 40 YES User-definable map reference field.
GUBGISL_MAP_REF_06 VARCHAR2 40 YES User-definable map reference field.
GUBGISL_MAP_REF_07 VARCHAR2 40 YES User-definable map reference field.
GUBGISL_MAP_REF_08 VARCHAR2 40 YES User-definable map reference field.
GUBGISL_MAP_REF_09 VARCHAR2 40 YES User-definable map reference field.
GUBGISL_MAP_REF_10 VARCHAR2 40 YES User-definable map reference field.
GUBGISL_MAP_REF_11 VARCHAR2 40 YES User-definable map reference field.
GUBGISL_MAP_REF_12 VARCHAR2 40 YES User-definable map reference field.
GUBGISL_MAP_REF_13 VARCHAR2 40 YES User-definable map reference field.
GUBGISL_MAP_REF_14 VARCHAR2 40 YES User-definable map reference field.
GUBGISL_MAP_REF_15 VARCHAR2 40 YES User-definable map reference field.
Date: 21-JUN-2004 Page: 237
SEQUENCE: GUBGSEQ
CREATOR: GENERAL
===================================================================================================================
Minimum Value: 1
Maximum Value: 99999999999999999999
Increment: 1
Last Number: 1
Cache Size: 0
Order Option: NOT ORDERED
Cycle Option: NOCYCLE
Date: 21-JUN-2004 Page: 238
TABLE: GUBINST
CREATOR: GENERAL
Institutional Description Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBINST_KEY VARCHAR2 8 NO KEY: Value of INST.
GUBINST_OPERATING_SYSTEM_IND VARCHAR2 3 NO OPERATING SYSTEM: UNX, VMS, MVS, AOS, NOS.
GUBINST_NAME VARCHAR2 30 NO NAME: Name of Institution.
GUBINST_STREET_LINE1 VARCHAR2 30 YES
GUBINST_STREET_LINE2 VARCHAR2 30 YES
GUBINST_STREET_LINE3 VARCHAR2 30 YES
GUBINST_CITY VARCHAR2 20 NO
GUBINST_STAT_CODE VARCHAR2 3 YES
GUBINST_ZIP VARCHAR2 10 YES
GUBINST_PHONE_AREA VARCHAR2 3 YES
GUBINST_PHONE VARCHAR2 7 YES
GUBINST_PHONE_EXT VARCHAR2 4 YES
GUBINST_NATN_CODE VARCHAR2 5 YES NATION: Nation code. Values are from the STVNATN
form.
GUBINST_FINAID_IND VARCHAR2 1 YES FINAID IND: Y = Non-BANNER Financial Aid system
(SIGMA/SAM) is installed.
GUBINST_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was created or last
updated.
GUBINST_STUDENT_INSTALLED VARCHAR2 1 YES STUDENT INSTALLED: Y = BANNER Student system is
installed.
GUBINST_ALUMNI_INSTALLED VARCHAR2 1 YES ALUMNI INSTALLED: Y = BANNER Alumni system is
installed.
GUBINST_FINANCE_INSTALLED VARCHAR2 1 YES FINANCE INSTALLED: Y = BANNER Finance system is
installed.
GUBINST_HUMANRE_INSTALLED VARCHAR2 1 YES H. R. INSTALLED: Y = BANNER H.R. system is
installed.
GUBINST_BYPASS_ALT_VAL VARCHAR2 1 YES This column is now defunct. 08/30/89
GUBINST_POSBUD_INSTALLED VARCHAR2 1 YES POSCTRL INSTALLED: Y = BANNER Position Control system
is installed.
GUBINST_BILCSH_INSTALLED VARCHAR2 1 YES ACC REC INSTALLED: Y = BANNER A/R system is installed.
GUBINST_SECURITY_IND RAW 1 YES SECURITY INDICATOR: Y = Security is turned on.
GUBINST_FINAID_INSTALLED VARCHAR2 1 YES FINAID INSTALLED: Y = BANNER Financial Aid system is
installed.
GUBINST_COURTS_INSTALLED VARCHAR2 1 YES COURTS INSTALLED: Y = BANNER Courts system is
installed.
GUBINST_HIGHED_GOVT_IND VARCHAR2 1 YES INSTITUTION TYPE: H = Higher Education, G =
Government, K = K-12, C = Commercial.
GUBINST_BASE_CURR_CODE VARCHAR2 4 YES Establishes the base currency for the installation.
GUBINST_UTILITIES_INSTALLED VARCHAR2 1 YES UTILITIES INSTALLED: Y = BANNER Utilities system is
installed.
GUBINST_ZIP_DEFAULT_LENGTH NUMBER 2 YES
GUBINST_CENTURY_PIVOT NUMBER 2 YES
GUBINST_DATE_DEFAULT_FORMAT NUMBER 1 YES
GUBINST_INSTANCE_NAME VARCHAR2 8 YES Contains the user defined name for the instance.
GUBINST_PTAX_INSTALLED VARCHAR2 1 YES
GUBINST_OCCTAX_INSTALLED VARCHAR2 1 YES
Date: 21-JUN-2004 Page: 239
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBINST_RECORDS_INSTALLED VARCHAR2 1 YES
GUBINST_CASHREC_INSTALLED VARCHAR2 1 YES
GUBINST_MAX_OPEN_FORMS NUMBER 2 YES
GUBINST_CHARMODE_GURJOBS_IND RAW 1 YES
GUBINST_WF_ENABLED_IND VARCHAR2 1 NO
GUBINST_MESSAGE_ENABLED_IND VARCHAR2 1 NO Message Indicator: This field indicates if the
institution has messaging on (Y) or off (N)
GUBINST_SQLTRACE_ENABLED_IND VARCHAR2 1 NO SQL Trace Indicator: This field indicates if the
institution has SQL Trace on (Y) or off (N)
Date: 21-JUN-2004 Page: 240
TABLE: GUBLETR
CREATOR: GENERAL
GUBLETR: Contains information about paragraphs within a letter.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBLETR_LETR_CODE VARCHAR2 15 NO LETTER CODE: The code identifying this letter. May
not contain imbedded spaces.
GUBLETR_PARA_CODE VARCHAR2 7 NO PARAGRAPH CODE: The code identifying a paragraph on
this letter.
GUBLETR_PARA_SEQNO NUMBER 3 NO PARAGRAPH SEQUENCE: A number identifying the sequence
of paragraphs within a letter.
GUBLETR_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was created or last
updated.
Date: 21-JUN-2004 Page: 241
TABLE: GUBLHLP
CREATOR: GENERAL
Local help table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBLHLP_FORM_NAME VARCHAR2 30 NO Form name
GUBLHLP_BLOCK_NAME VARCHAR2 30 YES Block name
GUBLHLP_FIELD_NAME VARCHAR2 30 YES Field name
GUBLHLP_TEXT LONG NO Local help commments
GUBLHLP_ACTIVITY_DATE DATE 7 NO Last date help was either created or updated
Date: 21-JUN-2004 Page: 242
TABLE: GUBOBJS
CREATOR: GENERAL
General Object Base Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBOBJS_NAME VARCHAR2 30 NO This item contains the name of the object.
GUBOBJS_DESC VARCHAR2 80 NO This item contains the description of the object.
GUBOBJS_OBJT_CODE VARCHAR2 10 NO This item contains the object type code.
GUBOBJS_SYSI_CODE VARCHAR2 2 NO This item contains the value which identifies the
Banner System to which this object belongs.
GUBOBJS_USER_ID VARCHAR2 30 NO This item contains the name of the user who owns the
object.
GUBOBJS_ACTIVITY_DATE DATE 7 NO This item contains the date of creation or update.
GUBOBJS_HELP_IND VARCHAR2 1 NO Indicator column to identify which objects have new
help files.
GUBOBJS_EXTRACT_ENABLED_IND VARCHAR2 1 NO This column indicates whether the data displayed on
the form can be extracted into a csv (Comma Separated
Value) file. Values are: D - data block only, B -
Both key block and data block, N - not available.
Date: 21-JUN-2004 Page: 243
TABLE: GUBOUTP
CREATOR: GENERAL
The job submission base output table used to store header information from batch jobs executed in a client server
environment.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBOUTP_USERNAME VARCHAR2 30 NO The guboutp_username is the Oracle username used to
run the job.
GUBOUTP_USER_ID NUMBER NO The guboutp_username is the Oracle user_id assigned to
the Oracle username used to run the job.
GUBOUTP_ONE_UP_NO NUMBER NO The guboutp_one_up_no is the one up number generated
when the job was submitted from a BANNER form.
GUBOUTP_JOB VARCHAR2 30 NO The guboutp_job is the name of the job or process
which generated the output file.
GUBOUTP_FILE_NAME VARCHAR2 60 NO
GUBOUTP_FILE_NUMBER NUMBER NO
GUBOUTP_NUMBER_OF_LINES NUMBER NO
GUBOUTP_DATE_SAVED DATE 7 YES The guboutp_date_saved is the date the report was
saved into the database.
GUBOUTP_DATE_PRINTED DATE 7 YES The guboutp_date_printed is the date the report was
printed via the on-line form.
GUBOUTP_OPERATING_SYSTEM VARCHAR2 10 YES The guboutp_operating_system reflects the operating
system on which the gurinso job was running when the
report was saved.
Date: 21-JUN-2004 Page: 244
TABLE: GUBPARA
CREATOR: GENERAL
Letter Paragraph Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBPARA_PARA_CODE VARCHAR2 7 NO PARAGRAPH CODE: The code identifying the paragraph
associated with this record.
GUBPARA_SEQ_NO NUMBER 23 20 NO PARAGRAPH SEQUENCE: The line number within the
paragraph for this record.
GUBPARA_TEXT_VAR VARCHAR2 60 YES TEXT/VARIABLE: A line of text, variable name, or
formatting command within the paragraph.
GUBPARA_ACTIVITY_DATE DATE 7 NO ACTIVITY DATE: Date the record was created or last
updated.
Date: 21-JUN-2004 Page: 245
TABLE: GUBPPRF
CREATOR: GENERAL
Enterprise Pin Preference table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBPPRF_FORMAT VARCHAR2 1 NO PIN RESET FORMAT: N = Numeric, A = Alphanumeric.
GUBPPRF_VALUE VARCHAR2 1 NO PIN RESET VALUE: B = Birth date, R = Random value.
GUBPPRF_SELF_NOTIFY_TYPE_IND VARCHAR2 1 NO PIN USER INSERT/UPDATE NOTIFICATION CONTROL: E =
Create Email, L = Create Letter, B = Create Both Email
and Letter, N = No Notification.
GUBPPRF_ADMIN_NOTIFY_TYPE_IND VARCHAR2 1 NO PIN ADMINISTRATOR INSERT/UPDATE NOTIFICATION CONTROL:
E = Create Email, L = Create Letter, B = Create Both
Email and Letter, N = No Notification.
GUBPPRF_PRE_EXPIRE_IND VARCHAR2 1 NO PRE-EXPIRE PIN INDICATOR: Y = Pre-expire PINs when
created automatically or in batch, N = Do not
pre-expire PINs.
GUBPPRF_USER_ID VARCHAR2 30 NO USER ID: The USER ID which changed this record.
GUBPPRF_ACTIVITY_DATE DATE 7 NO The date on which the row was added or modified.
GUBPPRF_APPLICATION VARCHAR2 30 YES APPLICATION CODE: Letter Generation Application code.
(From GLBAPPL)
GUBPPRF_LETR_CODE_LETTER VARCHAR2 15 YES LETTER CODE: The pin reset letter generation code for
the letter notification. (From GTVLETR)
GUBPPRF_LETR_CODE_EMAIL VARCHAR2 15 YES LETTER CODE: The pin reset letter generation code for
the email notification. (From GTVLETR)
Date: 21-JUN-2004 Page: 246
SEQUENCE: GUBPSEQ
CREATOR: GENERAL
===================================================================================================================
Minimum Value: 100002
Maximum Value: 999999
Increment: 3
Last Number: 714333
Cache Size: 0
Order Option: NOT ORDERED
Cycle Option: CYCLE
Date: 21-JUN-2004 Page: 247
TABLE: GUBRSLT
CREATOR: GENERAL
External Process Results Table
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBRSLT_JOB_ID VARCHAR2 30 NO JOB ID: Name of procedure being processed
GUBRSLT_USER_ID VARCHAR2 30 NO USER ID: User id of the user executing he procedure
GUBRSLT_SESSION_ID VARCHAR2 30 NO SESSION ID: The session id of the user excuting the
procedure
GUBRSLT_VRFY_TIME_STAMP VARCHAR2 14 NO TIME STAMP: Date and time the procedure was executed
GUBRSLT_STATUS_IND VARCHAR2 1 YES STATUS INDICATOR: Final status of procedure, either
(F)ailed or (S)uccess
GUBRSLT_MESSAGE VARCHAR2 60 YES MESSAGE: Any message text to passed to calling process
GUBRSLT_ACTIVITY_DATE DATE 7 YES
Date: 21-JUN-2004 Page: 248
VIEW: GUBSMOD
CREATOR: GENERAL
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
DUMMY CHAR 57 YES
Date: 21-JUN-2004 Page: 249
TABLE: GUBSRVY
CREATOR: GENERAL
Survey Header Table. This tables defines the header information for surveys.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GUBSRVY_NAME VARCHAR2 15 NO Survey Name.
GUBSRVY_TITLE VARCHAR2 60 NO Title of the survey.
GUBSRVY_DISP_WEB_IND VARCHAR2 1 NO Display on the Web Indicator, Y = display, N = do not
display.
GUBSRVY_ACTIVITY_DATE DATE 7 NO The date that the Survey was created or last changed.
GUBSRVY_USER VARCHAR2 30 NO The User who created or last modified the Survey.
GUBSRVY_FROM_DATE DATE 7 YES The date from which the Survey should be available for
responses.
GUBSRVY_TO_DATE DATE 7 YES The date until which the Survey should be available
for responses.
GUBSRVY_EXTR_APPLICATION VARCHAR2 30 YES The Population Selection Application that can respond
to the Survey.
GUBSRVY_EXTR_SELECTION VARCHAR2 30 YES The Population Selection Selection that can respond to
the Survey.
GUBSRVY_EXTR_CREATOR_ID VARCHAR2 30 YES The Population Selection Creator ID.
GUBSRVY_EXTR_USER_ID VARCHAR2 30 YES The Population Selection User ID.
GUBSRVY_INFO VARCHAR2 2000 YES Free form text which describes the Survey and is
displayed on the web.
Date: 21-JUN-2004 Page: 250
TABLE: GURADDL
CREATOR: GENERAL
Gurrddl process DDL Collector Table.
===================================================================================================================
Column Name Type Width Scale Nulls Column Comments
=============================== ========= ===== ===== ======= =====================================================
GURADDL_USER VARCHAR2 30 YES Session Id
GURADDL_SEQ NUMBER 24 8 YES Sequence numner
GURADDL_COMMAND VARCHAR2 2000 YES Dynamic SQL or Comments
Date: 21-JUN-2004 Page: 251
TABLE: GURALMP
CREATOR: GENERAL
Pledge Payment to Advancement Table
=======