Model Miscellaneous

Model Label : Banner General Miscellaneous
Path : BANNER DEV/General/ERD/Miscellaneous

List of Objects

Object Name	Object Type	Layer Name
FOBAPPH	TABLE	non-General
FOBPROF	TABLE	non-General
FOBUAPP	TABLE	non-General
GLBAPPL	TABLE	Default
GOBEACC	TABLE	Default
GOBVUSR	TABLE	Default
GORCCRD	TABLE	Default
GORMERC	TABLE	Default
GORPGEO	TABLE	Default
GORSGEO	TABLE	Default
GTVCCRD	TABLE	Default
GTVPROC	TABLE	Default
GTVSDAX	TABLE	Default
GTVSYSI	TABLE	Default
GTVZIPC	TABLE	Default
GUBBHLP	TABLE	Default
GUBGISL	TABLE	Default
GUBINST	TABLE	Default
GUBLHLP	TABLE	Default
GUBPPRF	TABLE	Default
GURHLOG	TABLE	Default
GURIDEN	TABLE	Default
GUROPTM	TABLE	Default
GURTKLR	TABLE	Default
GUVALTI	VIEW	Default
NTRTPRX	TABLE	non-General
PTRUSER	TABLE	non-General
PTVESKL	TABLE	non-General
SOBSBGI	TABLE	Default
SORHSCH	TABLE	Default
SORMGEO	TABLE	Default
SORPCOL	TABLE	Default
SPBPERS	TABLE	Default
SPBPERS reference	User Object	Default
SPRIDEN	TABLE	Default
SPRIDEN reference	User Object	Default
STVCNTY	TABLE	Default
STVGEOD	TABLE	Default
STVGEOR	TABLE	Default
STVNATN	TABLE	Default
STVSBGI	TABLE	Default
STVSTAT	TABLE	Default

Comments

Model View

Table FOBAPPH

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	FK
FOBAPPH_SEQ_NUM	FOBAPPH_SEQ_NUM	NUMBER(2,0)	No	*
FOBAPPH_DOC_CODE	FOBAPPH_DOC_CODE	VARCHAR2(15)	No
FOBAPPH_CHG_SEQ_NUM	FOBAPPH_CHG_SEQ_NUM	NUMBER(3,0)	Yes
FOBAPPH_USER_ID	FOBAPPH_USER_ID	VARCHAR2(30)	No	*
FOBAPPH_ACTIVITY_DATE	FOBAPPH_ACTIVITY_DATE	DATE	No
FOBAPPH_QUEUE_ID	FOBAPPH_QUEUE_ID	VARCHAR2(4)	Yes
FOBAPPH_QUEUE_LEVEL	FOBAPPH_QUEUE_LEVEL	NUMBER(4,0)	Yes
FOBAPPH_SUBMISSION_NUMBER	FOBAPPH_SUBMISSION_NUMBER	NUMBER(2,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
FOBAPPH_SEQ_NUM	FTVDTYP_SEQ_NUM	FTVDTYP
FOBAPPH_USER_ID	GURTKLR_USER_ID	GURTKLR

Index

Index Name	Index Type	Column Name
FOBAPPH_CODE_INDEX		FOBAPPH_DOC_CODE
FOBAPPH_KEY_INDEX		FOBAPPH_SEQ_NUM
FOBAPPH_KEY_INDEX		FOBAPPH_DOC_CODE
FOBAPPH_KEY_INDEX		FOBAPPH_CHG_SEQ_NUM
FOBAPPH_KEY_INDEX		FOBAPPH_USER_ID

Comments

Source Code Comments

Approval History Table

Columns Comments for FOBAPPH_SEQ_NUM (1)

Source Code Comments

SEQUENCE NUMBER: This number represents a predefined value within BANNER Finance that is used for operating ledger classification and reporting purposes.

Columns Comments for FOBAPPH_DOC_CODE (2)

Source Code Comments

DOCUMENT CODE: The user-defined or system assigned document number.

Columns Comments for FOBAPPH_CHG_SEQ_NUM (3)

Source Code Comments

CHANGE SEQUENCE NUMBER:

Columns Comments for FOBAPPH_USER_ID (4)

Source Code Comments

USER ID: The unique identification code of the user.

Columns Comments for FOBAPPH_ACTIVITY_DATE (5)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated.

Columns Comments for FOBAPPH_QUEUE_ID (6)

Source Code Comments

QUEUE ID:

Columns Comments for FOBAPPH_QUEUE_LEVEL (7)

Source Code Comments

QUEUE LEVEL:

Columns Comments for FOBAPPH_SUBMISSION_NUMBER (8)

Source Code Comments

Submission number of document.

Table FOBPROF

Schema Name FIMSMGR
Label FOBPROF
Server name MALDEV8_B60
Creation Date 04/28/2003 16:17:49:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
FOBPROF_USER_ID	FOBPROF_USER_ID	VARCHAR2(30)	No	*	*
FOBPROF_ACTIVITY_DATE	FOBPROF_ACTIVITY_DATE	DATE	No
FOBPROF_USER_NAME	FOBPROF_USER_NAME	VARCHAR2(35)	Yes
FOBPROF_COAS_CODE	FOBPROF_COAS_CODE	VARCHAR2(1)	No
FOBPROF_SECG_CODE	FOBPROF_SECG_CODE	VARCHAR2(1)	Yes
FOBPROF_NSF_OVERRIDE	FOBPROF_NSF_OVERRIDE	VARCHAR2(1)	Yes
FOBPROF_TOLERANCE	FOBPROF_TOLERANCE	NUMBER(5,2)	Yes
FOBPROF_BUD_ID	FOBPROF_BUD_ID	VARCHAR2(6)	Yes
FOBPROF_PIDM	FOBPROF_PIDM	NUMBER(8,0)	Yes
FOBPROF_MASTER_FUND_IND	FOBPROF_MASTER_FUND_IND	VARCHAR2(1)	Yes
FOBPROF_MASTER_ORGN_IND	FOBPROF_MASTER_ORGN_IND	VARCHAR2(1)	Yes
FOBPROF_MAX_TOLERANCE_AMT	FOBPROF_MAX_TOLERANCE_AMT	NUMBER(12,2)	Yes
FOBPROF_RCVD_OVERRIDE_IND	FOBPROF_RCVD_OVERRIDE_IND	VARCHAR2(1)	Yes
FOBPROF_RCVD_TOLERANCE_PCT	FOBPROF_RCVD_TOLERANCE_PCT	NUMBER(5,2)	Yes
FOBPROF_TOL_OVERRIDE_IND	FOBPROF_TOL_OVERRIDE_IND	VARCHAR2(1)	Yes
FOBPROF_DST_SPD_OVERRIDE_IND	FOBPROF_DST_SPD_OVERRIDE_IND	VARCHAR2(1)	Yes
FOBPROF_SPD_OVERRIDE_IND	FOBPROF_SPD_OVERRIDE_IND	VARCHAR2(1)	Yes
FOBPROF_INT_RATE_OVERRIDE_IND	FOBPROF_INT_RATE_OVERRIDE_IND	VARCHAR2(1)	Yes
FOBPROF_USER_INV_PRIV	FOBPROF_USER_INV_PRIV	VARCHAR2(1)	Yes
FOBPROF_EXP_END_POST_AUTH_IND	FOBPROF_EXP_END_POST_AUTH_IND	VARCHAR2(1)	No
FOBPROF_ACCRUAL_POST_AUTH_IND	FOBPROF_ACCRUAL_POST_AUTH_IND	VARCHAR2(1)	No
FOBPROF_REQUESTER_ORGN_CODE	FOBPROF_REQUESTER_ORGN_CODE	VARCHAR2(6)	Yes
FOBPROF_RCVD_TOLERANCE_QTY	FOBPROF_RCVD_TOLERANCE_QTY	NUMBER(8,2)	Yes
FOBPROF_RCVD_TOLERANCE_AMT	FOBPROF_RCVD_TOLERANCE_AMT	NUMBER(12,2)	Yes
FOBPROF_RCVD_TOLERANCE_AMT_PCT	FOBPROF_RCVD_TOLERANCE_AMT_PCT	NUMBER(5,2)	Yes
FOBPROF_REQUESTOR_EMAIL_ADDR	FOBPROF_REQUESTOR_EMAIL_ADDR	VARCHAR2(100)	Yes
FOBPROF_REQUESTOR_FAX_AREA	FOBPROF_REQUESTOR_FAX_AREA	VARCHAR2(3)	Yes
FOBPROF_REQUESTOR_FAX_NUMBER	FOBPROF_REQUESTOR_FAX_NUMBER	VARCHAR2(7)	Yes
FOBPROF_REQUESTOR_FAX_EXT	FOBPROF_REQUESTOR_FAX_EXT	VARCHAR2(4)	Yes
FOBPROF_REQUESTOR_PHONE_AREA	FOBPROF_REQUESTOR_PHONE_AREA	VARCHAR2(3)	Yes
FOBPROF_REQUESTOR_PHONE_NUMBER	FOBPROF_REQUESTOR_PHONE_NUMBER	VARCHAR2(7)	Yes
FOBPROF_REQUESTOR_PHONE_EXT	FOBPROF_REQUESTOR_PHONE_EXT	VARCHAR2(4)	Yes
FOBPROF_REQUESTOR_SHIP_CODE	FOBPROF_REQUESTOR_SHIP_CODE	VARCHAR2(6)	Yes
FOBPROF_EDI_OVERRIDE_IND	FOBPROF_EDI_OVERRIDE_IND	VARCHAR2(1)	No
FOBPROF_ACH_OVERRIDE_IND	FOBPROF_ACH_OVERRIDE_IND	VARCHAR2(1)	No
FOBPROF_CARD_OVERRIDE_IND	FOBPROF_CARD_OVERRIDE_IND	VARCHAR2(1)	No
FOBPROF_REQ_MATCH_OVRRD_IND	FOBPROF_REQ_MATCH_OVRRD_IND	VARCHAR2(1)	No
FOBPROF_PO_MATCH_OVRRD_IND	FOBPROF_PO_MATCH_OVRRD_IND	VARCHAR2(1)	No
FOBPROF_INV_MATCH_OVRRD_IND	FOBPROF_INV_MATCH_OVRRD_IND	VARCHAR2(1)	No
FOBPROF_WEB_ACCESS_IND	FOBPROF_WEB_ACCESS_IND	VARCHAR2(1)	No
FOBPROF_WBUD_ACCESS_IND	FOBPROF_WBUD_ACCESS_IND	VARCHAR2(1)	No
FOBPROF_WBUD_MSTR_FUND_IND	FOBPROF_WBUD_MSTR_FUND_IND	VARCHAR2(1)	No
FOBPROF_WBUD_MSTR_ORGN_IND	FOBPROF_WBUD_MSTR_ORGN_IND	VARCHAR2(1)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
FOBPROF_USER_ID	GOBEACC_USERNAME	GOBEACC

Index

Index Name	Index Type	Column Name
PK_FOBPROF	Unique	FOBPROF_USER_ID

Comments

Source Code Comments

User Profile Validation Table

Columns Comments for FOBPROF_USER_ID (1)

Source Code Comments

USER ID: The unique identification code of the user.

Columns Comments for FOBPROF_ACTIVITY_DATE (2)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated.

Columns Comments for FOBPROF_USER_NAME (3)

Source Code Comments

USER NAME:

Columns Comments for FOBPROF_COAS_CODE (4)

Source Code Comments

CHART OF ACCOUNTS CODE: The primary identification code for any chart of accounts that uniquely identifies that chart from any other in a multi-chart environment.

Columns Comments for FOBPROF_SECG_CODE (5)

Source Code Comments

SEQUENCE

Columns Comments for FOBPROF_NSF_OVERRIDE (6)

Source Code Comments

INSUFFICIENT FUNDS OVERRIDE: This field permits authorized users to by-pass funding deficiencies.

Columns Comments for FOBPROF_TOLERANCE (7)

Source Code Comments

TOLERANCE

Columns Comments for FOBPROF_BUD_ID (8)

Source Code Comments

BUDGET ID:

Columns Comments for FOBPROF_PIDM (9)

Source Code Comments

PERSONAL IDENTIFICATION NUMBER: OBSOLETE. Replaced with new table GOBEACC for Enterprise Access Control table in release 4.1

Columns Comments for FOBPROF_MASTER_FUND_IND (10)

Source Code Comments

MASTER FUND INDICATOR:

Columns Comments for FOBPROF_MASTER_ORGN_IND (11)

Source Code Comments

MASTER ORGANIZATION INDICATOR:

Columns Comments for FOBPROF_DST_SPD_OVERRIDE_IND (16)

Source Code Comments

Distributed Spendable Amount Override: This indicator will be set to a Y if the user is allowed to update the distributed spendable amount on the Investment Management Spendable Amount Maintenance table.

Columns Comments for FOBPROF_SPD_OVERRIDE_IND (17)

Source Code Comments

Spendable Amount Override: This indicator will be set to a Y if the user is allowed to update the spendable amount on the Investment Management Spendable Amount Maintenance table.

Columns Comments for FOBPROF_INT_RATE_OVERRIDE_IND (18)

Source Code Comments

Interest Rate Override: This indicator will be set to a Y if the user is allowed to update the interest rate on the Investment Management Bond Collector table.

Columns Comments for FOBPROF_USER_INV_PRIV (19)

Source Code Comments

USER INV PRIV: This field contains pre-defined alphanumeric one character values used to restrict the usage of the Invoice form.

Columns Comments for FOBPROF_EXP_END_POST_AUTH_IND (20)

Source Code Comments

Expenditure End Date Posting Authority Indicator : Values (Y)es the user has authority to enter transactions during the grant termination period that lies between the grant termination date and the Expenditure End Dateon the fund record.(N)o the user doe
s not have the authority and the user will be stopped on the document that they are entering if the transaction date falls in the grant termination period.

Columns Comments for FOBPROF_ACCRUAL_POST_AUTH_IND (21)

Source Code Comments

Accrual Period Posting Authority Indicator: Values (Y)es the user is authorized to post transactions to the accrual period. (N)o, the user does not have the authority and will be stopped on the document that they are entering if the transaction date bein
g used will cause a posting into the accrual period for the prior fiscal year.

Columns Comments for FOBPROF_REQUESTER_ORGN_CODE (22)

Source Code Comments

REQUESTOR ORGANIZATION CODE: Organization code will be defaulted to Purchasing documents for the requestor.

Columns Comments for FOBPROF_RCVD_TOLERANCE_QTY (23)

Source Code Comments

TOLERANCE QUANTITY: Receiving tolerance quantity.

Columns Comments for FOBPROF_RCVD_TOLERANCE_AMT (24)

Source Code Comments

TOLERANCE AMOUNT: Receiving tolerance amount.

Columns Comments for FOBPROF_RCVD_TOLERANCE_AMT_PCT (25)

Source Code Comments

TOLERANCE AMOUNT PERCENT: Receiving tolerance amount per cent.

Columns Comments for FOBPROF_REQUESTOR_EMAIL_ADDR (26)

Source Code Comments

EMAIL ADDRESS: Requestor email address.

Columns Comments for FOBPROF_REQUESTOR_FAX_AREA (27)

Source Code Comments

FAX AREA CODE: Requestor fax number area code.

Columns Comments for FOBPROF_REQUESTOR_FAX_NUMBER (28)

Source Code Comments

FAX NUMBER: Requestor ship To fax telephone number.

Columns Comments for FOBPROF_REQUESTOR_FAX_EXT (29)

Source Code Comments

FAX EXTENTION: Requestor fax number extention.

Columns Comments for FOBPROF_REQUESTOR_PHONE_AREA (30)

Source Code Comments

PHONE AREA CODE: Requestor phone number area code.

Columns Comments for FOBPROF_REQUESTOR_PHONE_NUMBER (31)

Source Code Comments

PHONE NUMBER: Requestor telephone number.

Columns Comments for FOBPROF_REQUESTOR_PHONE_EXT (32)

Source Code Comments

PHONE EXTENTION: Requestor phone number extention.

Columns Comments for FOBPROF_REQUESTOR_SHIP_CODE (33)

Source Code Comments

SHIP TO CODE: Code which corresponds to the address of the order(P0,REQ,Change) requestor.

Columns Comments for FOBPROF_EDI_OVERRIDE_IND (34)

Source Code Comments

EDI OVERRIDE INDICATOR: If checked indicates user has privilege to override sending via EDI.

Columns Comments for FOBPROF_ACH_OVERRIDE_IND (35)

Source Code Comments

ACH OVERRIDE INDICATOR: If checked indicates user has privilege to override sending via Direct Deposit.

Columns Comments for FOBPROF_CARD_OVERRIDE_IND (36)

Source Code Comments

PURCHASE CARD OVERRIDE INDICATOR: If checked (Y)es, gives user authority to change dates and other fields on Purchase Card Transactions within form FAAINVT. The default is unchecked (N)o.

Columns Comments for FOBPROF_REQ_MATCH_OVRRD_IND (37)

Source Code Comments

Requisition Match Override Indicator: Used to set users authority to override the 3 way matching indicator at the requisition level. Valid values are [N]o override, [Y]es override allowed.

Columns Comments for FOBPROF_PO_MATCH_OVRRD_IND (38)

Source Code Comments

Purchase Order Match Override Indicator: Used to set users authority to override the 3 way matching indicator at the purchase order level. Valid values are [N]o override, [Y]es override.

Columns Comments for FOBPROF_INV_MATCH_OVRRD_IND (39)

Source Code Comments

Invoice Match Override Indicator: Used to set users authority to override the 3 way matching indicator at the invoice level. Valid values are [N]o override, [Y]es override allowed.

Columns Comments for FOBPROF_WEB_ACCESS_IND (40)

Source Code Comments

WEB ACCESS INDICATOR: This field indicates access for Web Finance

Columns Comments for FOBPROF_WBUD_ACCESS_IND (41)

Source Code Comments

WEB BUDGET ACCESS INDICATOR: Used to define whether Finance User has access to Budget Development on Self Service Finance. Valid values are 'Y' for enabling access or 'N' for not having access.

Columns Comments for FOBPROF_WBUD_MSTR_FUND_IND (42)

Source Code Comments

WEB BUDGET MASTER FUND INDICATOR: Used to define the master fund authority that the user has for Budget Development on Self Service Finance. Valid values are 'Q' for Query; 'B' for both Query and Post; 'N' for No Master Fund Authority.

Columns Comments for FOBPROF_WBUD_MSTR_ORGN_IND (43)

Source Code Comments

WEB BUDGET MASTER ORGANIZATION INDICATOR - Used to define the master orgn authority that the user has for Budget Development on Self Service Finance. Valid values are 'Q' for Query; 'B' for both Query and Post; 'N' for No Master Orgn Authority.

Table FOBUAPP

Schema Name FIMSMGR
Label FOBUAPP
Server name MALDEV8_B60
Creation Date 04/15/2002 18:18:38:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
FOBUAPP_SEQ_NUM	FOBUAPP_SEQ_NUM	NUMBER(2,0)	No	*	*
FOBUAPP_USER_CODE	FOBUAPP_USER_CODE	VARCHAR2(30)	No
FOBUAPP_DOC_CODE	FOBUAPP_DOC_CODE	VARCHAR2(15)	No	*
FOBUAPP_DOC_AMT	FOBUAPP_DOC_AMT	NUMBER(12,2)	No
FOBUAPP_ORIG_USER	FOBUAPP_ORIG_USER	VARCHAR2(30)	No
FOBUAPP_ACTIVITY_DATE	FOBUAPP_ACTIVITY_DATE	DATE	No
FOBUAPP_CHG_SEQ_NUM	FOBUAPP_CHG_SEQ_NUM	NUMBER(3,0)	Yes
FOBUAPP_SUBMISSION_NUMBER	FOBUAPP_SUBMISSION_NUMBER	NUMBER(2,0)	Yes
FOBUAPP_STATUS_IND	FOBUAPP_STATUS_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
FOBUAPP_SEQ_NUM	FTVDTYP_SEQ_NUM	FTVDTYP

Index

Index Name	Index Type	Column Name
PK_FOBUAPP	Unique	FOBUAPP_SEQ_NUM
PK_FOBUAPP	Unique	FOBUAPP_DOC_CODE

Comments

Source Code Comments

Unapproved Document Table

Columns Comments for FOBUAPP_SEQ_NUM (1)

Source Code Comments

SEQUENCE NUMBER: This number represents a predefined value within BANNER Finance that is used for operating ledger classification and reporting purposes.

Columns Comments for FOBUAPP_USER_CODE (2)

Source Code Comments

USER CODE:

Columns Comments for FOBUAPP_DOC_CODE (3)

Source Code Comments

DOCUMENT CODE: The user-defined or system assigned document number.

Columns Comments for FOBUAPP_DOC_AMT (4)

Source Code Comments

DOCUMENT AMOUNT: The total value of the encumbrance being recorded.

Columns Comments for FOBUAPP_ORIG_USER (5)

Source Code Comments

ORIGINAL USER:

Columns Comments for FOBUAPP_ACTIVITY_DATE (6)

Source Code Comments

ACTIVITY DATE: The date that information for this record in the table was entered or last updated.

Columns Comments for FOBUAPP_CHG_SEQ_NUM (7)

Source Code Comments

CHANGE SEQUENCE NUMBER

Columns Comments for FOBUAPP_SUBMISSION_NUMBER (8)

Source Code Comments

Submission number of input document.

Columns Comments for FOBUAPP_STATUS_IND (9)

Source Code Comments

Status is "N"ew when documents are completed and a row inserted. Status is set to null by forappl when routed.

Table GLBAPPL

Schema Name GENERAL
Label GLBAPPL
Server name MALDEV8_B60
Creation Date 02/07/2003 15:35:41:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GLBAPPL_APPLICATION	GLBAPPL_APPLICATION	VARCHAR2(30)	No	*
GLBAPPL_DESC	GLBAPPL_DESC	VARCHAR2(30)	No
GLBAPPL_SYSI_CODE	GLBAPPL_SYSI_CODE	VARCHAR2(2)	No		*
GLBAPPL_ACTIVITY_DATE	GLBAPPL_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GLBAPPL_SYSI_CODE	GTVSYSI_CODE	GTVSYSI

Index

Index Name	Index Type	Column Name
PK_GLBAPPL	Unique	GLBAPPL_APPLICATION

Comments

Source Code Comments

Letter Generation Application Table

Columns Comments for GLBAPPL_APPLICATION (1)

Source Code Comments

APPLICATION: Application code which uniquely identifies this record.

Columns Comments for GLBAPPL_DESC (2)

Source Code Comments

DESCRIPTION: Description of this application.

Columns Comments for GLBAPPL_SYSI_CODE (3)

Source Code Comments

SYSTEM INDICATOR: System indicator which identifies which system this application is associated.

Columns Comments for GLBAPPL_ACTIVITY_DATE (4)

Source Code Comments

ACTIVITY DATE: Date that record was created or last updated.

Table GOBEACC

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK
GOBEACC_PIDM	GOBEACC_PIDM	NUMBER(8,0)	No	*
GOBEACC_USERNAME	GOBEACC_USERNAME	VARCHAR2(30)	No
GOBEACC_USER_ID	GOBEACC_USER_ID	VARCHAR2(30)	No
GOBEACC_ACTIVITY_DATE	GOBEACC_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
GOBEACC_KEY_INDEX	Unique	GOBEACC_USERNAME
PK_GOBEACC	Unique	GOBEACC_PIDM

Comments

Source Code Comments

Enterprise Oracle Access Table

Columns Comments for GOBEACC_PIDM (1)

Source Code Comments

System generated unique PIDM associated with user.

Columns Comments for GOBEACC_USERNAME (2)

Source Code Comments

Oracle user ID.

Columns Comments for GOBEACC_USER_ID (3)

Source Code Comments

Current User, system updated.

Columns Comments for GOBEACC_ACTIVITY_DATE (4)

Source Code Comments

System date of insert or update.

Table GOBVUSR

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GOBVUSR_USER_ID	GOBVUSR_USER_ID	VARCHAR2(30)	No	*	*
GOBVUSR_ACTIVE_IND	GOBVUSR_ACTIVE_IND	VARCHAR2(1)	No
GOBVUSR_EFF_DATE	GOBVUSR_EFF_DATE	DATE	No
GOBVUSR_ADMIN_IND	GOBVUSR_ADMIN_IND	VARCHAR2(1)	No
GOBVUSR_MGR_IND	GOBVUSR_MGR_IND	VARCHAR2(1)	No
GOBVUSR_ACTIVITY_DATE	GOBVUSR_ACTIVITY_DATE	DATE	No
GOBVUSR_EXPIRE_DATE	GOBVUSR_EXPIRE_DATE	DATE	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GOBVUSR_USER_ID	GOBEACC_USERNAME	GOBEACC

Index

Index Name	Index Type	Column Name
PK_GOBVUSR	Unique	GOBVUSR_USER_ID

Comments

Source Code Comments

VBS User Profile Base

Columns Comments for GOBVUSR_USER_ID (1)

Source Code Comments

ORACLE User ID

Columns Comments for GOBVUSR_ACTIVE_IND (2)

Source Code Comments

Indicates VBS User Profile is Active

Columns Comments for GOBVUSR_EFF_DATE (3)

Source Code Comments

Indicates Effective Date of VBS User Profile

Columns Comments for GOBVUSR_ADMIN_IND (4)

Source Code Comments

Indicates the VBS User to be an Access Group Administrator

Columns Comments for GOBVUSR_MGR_IND (5)

Source Code Comments

Indicates the VBS User to be an Access Group Manager

Columns Comments for GOBVUSR_ACTIVITY_DATE (6)

Source Code Comments

Date of Insert or Last Update

Columns Comments for GOBVUSR_EXPIRE_DATE (7)

Source Code Comments

Indicates Expiration Date of VBS USer Profile

Table GORCCRD

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GORCCRD_CCRD_CODE	GORCCRD_CCRD_CODE	VARCHAR2(10)	No	*	*
GORCCRD_EDIT_CHAR_START	GORCCRD_EDIT_CHAR_START	VARCHAR2(4)	No	*
GORCCRD_EDIT_CHAR_END	GORCCRD_EDIT_CHAR_END	VARCHAR2(4)	No	*
GORCCRD_CARD_LENGTH	GORCCRD_CARD_LENGTH	NUMBER(2,0)	No	*
GORCCRD_NUM_CHECK_DIGITS	GORCCRD_NUM_CHECK_DIGITS	NUMBER(1,0)	No
GORCCRD_USER_ID	GORCCRD_USER_ID	VARCHAR2(30)	No
GORCCRD_ACTIVITY_DATE	GORCCRD_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORCCRD_CCRD_CODE	GTVCCRD_CODE	GTVCCRD

Index

Index Name	Index Type	Column Name
PK_GORCCRD	Unique	GORCCRD_CCRD_CODE
PK_GORCCRD	Unique	GORCCRD_EDIT_CHAR_START
PK_GORCCRD	Unique	GORCCRD_EDIT_CHAR_END
PK_GORCCRD	Unique	GORCCRD_CARD_LENGTH

Comments

Source Code Comments

CREDIT CARD RULES Table

Columns Comments for GORCCRD_CCRD_CODE (1)

Source Code Comments

CREDIT CARD TYPE CODE: Code associated with the Credit Card Type.

Columns Comments for GORCCRD_EDIT_CHAR_START (2)

Source Code Comments

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.

Columns Comments for GORCCRD_EDIT_CHAR_END (3)

Source Code Comments

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.

Columns Comments for GORCCRD_CARD_LENGTH (4)

Source Code Comments

CREDIT CARD LENGTH: Number of digits contained in the associated Credit Card Type.

Columns Comments for GORCCRD_NUM_CHECK_DIGITS (5)

Source Code Comments

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.

Columns Comments for GORCCRD_USER_ID (6)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user creating or updating the record.

Columns Comments for GORCCRD_ACTIVITY_DATE (7)

Source Code Comments

ACTIVITY DATE: The date that the record was created or updated.

Table GORMERC

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

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GORMERC_PROC_CODE	GORMERC_PROC_CODE	VARCHAR2(30)	No	*	*
GORMERC_CCRD_CODE	GORMERC_CCRD_CODE	VARCHAR2(10)	No	*	*
GORMERC_SYSI_CODE	GORMERC_SYSI_CODE	VARCHAR2(2)	No	*	*
GORMERC_MERCHANT_ID	GORMERC_MERCHANT_ID	VARCHAR2(20)	No	*
GORMERC_DESC	GORMERC_DESC	VARCHAR2(60)	No
GORMERC_CASHIER_ID	GORMERC_CASHIER_ID	VARCHAR2(30)	No
GORMERC_DETAIL	GORMERC_DETAIL	VARCHAR2(20)	No
GORMERC_STATUS_IND	GORMERC_STATUS_IND	VARCHAR2(1)	No
GORMERC_USER_ID	GORMERC_USER_ID	VARCHAR2(30)	No
GORMERC_ACTIVITY_DATE	GORMERC_ACTIVITY_DATE	DATE	No
GORMERC_VR_MSG_NO	GORMERC_VR_MSG_NO	NUMBER(8,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORMERC_CCRD_CODE	GTVCCRD_CODE	GTVCCRD
GORMERC_PROC_CODE	GTVPROC_CODE	GTVPROC
GORMERC_SYSI_CODE	GTVSYSI_CODE	GTVSYSI

Index

Index Name	Index Type	Column Name
PK_GORMERC	Unique	GORMERC_PROC_CODE
PK_GORMERC	Unique	GORMERC_SYSI_CODE
PK_GORMERC	Unique	GORMERC_MERCHANT_ID
PK_GORMERC	Unique	GORMERC_CCRD_CODE

Comments

Source Code Comments

CREDIT CARD TYPE BY MERCHANT ID Table

Columns Comments for GORMERC_PROC_CODE (1)

Source Code Comments

PROCESS NAME CODE: Process Name Code associated with the Credit Card Type Code, System Code, and Merchant ID.

Columns Comments for GORMERC_CCRD_CODE (2)

Source Code Comments

CREDIT CARD TYPE CODE: Credit Card Type Code associated with the Process Name Code, System Code, and Merchant ID.

Columns Comments for GORMERC_SYSI_CODE (3)

Source Code Comments

SYSTEM CODE: System Code associated with the Process Name Code, Credit Card Type Code, and Merchant ID.

Columns Comments for GORMERC_MERCHANT_ID (4)

Source Code Comments

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.

Columns Comments for GORMERC_DESC (5)

Source Code Comments

DESCRIPTION: Description of the Credit Card Type associated with the Process Name Code, System Code, and Merchant ID.

Columns Comments for GORMERC_CASHIER_ID (6)

Source Code Comments

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.

Columns Comments for GORMERC_DETAIL (7)

Source Code Comments

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.

Columns Comments for GORMERC_STATUS_IND (8)

Source Code Comments

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.

Columns Comments for GORMERC_USER_ID (9)

Source Code Comments

USER IDENTIFICATION: The unique identification of the user creating or updating the record.

Columns Comments for GORMERC_ACTIVITY_DATE (10)

Source Code Comments

ACTIVITY DATE: The date that the record was created or updated.

Columns Comments for GORMERC_VR_MSG_NO (11)

Source Code Comments

VOICE RESPONSE MESSAGE NUMBER: Number of message to be spoken to the user of the Voice Response System identifying the Credit Card Type.

Table GORPGEO

Schema Name GENERAL
Label GORPGEO
Server name MALDEV8_B60
Creation Date 06/11/2003 11:13:15:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GORPGEO_PIDM	GORPGEO_PIDM	NUMBER(8,0)	No	*
GORPGEO_ATYP_CODE	GORPGEO_ATYP_CODE	VARCHAR2(2)	No	*
GORPGEO_ADDR_SEQNO	GORPGEO_ADDR_SEQNO	NUMBER(2,0)	No	*
GORPGEO_GEOR_CODE	GORPGEO_GEOR_CODE	VARCHAR2(10)	No	*	*
GORPGEO_GEOR_CODE	GORPGEO_GEOR_CODE	VARCHAR2(10)	No	*	*
GORPGEO_GEOD_CODE	GORPGEO_GEOD_CODE	VARCHAR2(10)	No	*	*
GORPGEO_GEOD_CODE	GORPGEO_GEOD_CODE	VARCHAR2(10)	No	*	*
GORPGEO_SOURCE_IND	GORPGEO_SOURCE_IND	VARCHAR2(1)	No
GORPGEO_ACTIVITY_DATE	GORPGEO_ACTIVITY_DATE	DATE	No
GORPGEO_STATUS_IND	GORPGEO_STATUS_IND	VARCHAR2(1)	Yes
GORPGEO_FROM_DATE	GORPGEO_FROM_DATE	DATE	Yes
GORPGEO_TO_DATE	GORPGEO_TO_DATE	DATE	Yes
GORPGEO_USERID	GORPGEO_USERID	VARCHAR2(30)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORPGEO_GEOR_CODE	SORMGEO_GEOR_CODE	SORMGEO
GORPGEO_GEOD_CODE	SORMGEO_GEOD_CODE	SORMGEO
GORPGEO_GEOD_CODE	STVGEOD_CODE	STVGEOD
GORPGEO_GEOR_CODE	STVGEOR_CODE	STVGEOR

Index

Index Name	Index Type	Column Name
PK_GORPGEO	Unique	GORPGEO_PIDM
PK_GORPGEO	Unique	GORPGEO_ATYP_CODE
PK_GORPGEO	Unique	GORPGEO_ADDR_SEQNO
PK_GORPGEO	Unique	GORPGEO_GEOR_CODE
PK_GORPGEO	Unique	GORPGEO_GEOD_CODE

Comments

Source Code Comments

Geographic Regions/Divisions for persons address.

Columns Comments for GORPGEO_PIDM (1)

Source Code Comments

PIDM for whom the Region/Division is defined for.

Columns Comments for GORPGEO_ATYP_CODE (2)

Source Code Comments

Address type of SPRADDR row the Region/Division is defined for.

Columns Comments for GORPGEO_ADDR_SEQNO (3)

Source Code Comments

Sequence number of SPRADDR row the Region/Division is defined for.

Columns Comments for GORPGEO_GEOR_CODE (4)

Source Code Comments

This field specifies the geographic region code for the PIDM and
address.

Columns Comments for GORPGEO_GEOD_CODE (5)

Source Code Comments

This field specifies the geographic division code the region, PIDM and
address.

Columns Comments for GORPGEO_SOURCE_IND (6)

Source Code Comments

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.

Columns Comments for GORPGEO_ACTIVITY_DATE (7)

Source Code Comments

This field identifies the most recent date a record was created

Columns Comments for GORPGEO_STATUS_IND (8)

Source Code Comments

Null value indicates geographic region/division are active for PIDM and
address. Value of I indicates an inactive status.

Columns Comments for GORPGEO_USERID (11)

Source Code Comments

This field identifies the user who most recently changed the record.

Table GORSGEO

Schema Name GENERAL
Label GORSGEO
Server name MALDEV8_B60
Creation Date 06/11/2003 11:13:20:000

Table Columns information

Column Name	Label	Column Type	Allow NULL	PK	FK
GORSGEO_SBGI_CODE	GORSGEO_SBGI_CODE	VARCHAR2(6)	No	*	*
GORSGEO_SBGI_CODE	GORSGEO_SBGI_CODE	VARCHAR2(6)	No	*	*
GORSGEO_SBGI_CODE	GORSGEO_SBGI_CODE	VARCHAR2(6)	No	*	*
GORSGEO_GEOR_CODE	GORSGEO_GEOR_CODE	VARCHAR2(10)	No	*	*
GORSGEO_GEOR_CODE	GORSGEO_GEOR_CODE	VARCHAR2(10)	No	*	*
GORSGEO_GEOD_CODE	GORSGEO_GEOD_CODE	VARCHAR2(10)	No	*	*
GORSGEO_GEOD_CODE	GORSGEO_GEOD_CODE	VARCHAR2(10)	No	*	*
GORSGEO_STATUS_IND	GORSGEO_STATUS_IND	VARCHAR2(1)	Yes
GORSGEO_SOURCE_IND	GORSGEO_SOURCE_IND	VARCHAR2(1)	No
GORSGEO_ACTIVITY_DATE	GORSGEO_ACTIVITY_DATE	DATE	No
GORSGEO_USERID	GORSGEO_USERID	VARCHAR2(30)	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GORSGEO_SBGI_CODE	SORHSCH_SBGI_CODE	SORHSCH
GORSGEO_SBGI_CODE	SORPCOL_SBGI_CODE	SORPCOL
GORSGEO_GEOR_CODE	SORMGEO_GEOR_CODE	SORMGEO
GORSGEO_GEOD_CODE	SORMGEO_GEOD_CODE	SORMGEO
GORSGEO_GEOD_CODE	STVGEOD_CODE	STVGEOD
GORSGEO_GEOR_CODE	STVGEOR_CODE	STVGEOR
GORSGEO_SBGI_CODE	STVSBGI_CODE	STVSBGI

Index

Index Name	Index Type	Column Name
PK_GORSGEO	Unique	GORSGEO_SBGI_CODE
PK_GORSGEO	Unique	GORSGEO_GEOR_CODE
PK_GORSGEO	Unique	GORSGEO_GEOD_CODE