Model Letter_Generation

Model Label :

List of Objects

Object Name	Object Type	Layer Name
GLBAPPL	SQL Table	Default
GLBOBJT	SQL Table	Default
GLBSLCT	SQL Table	Default
GLBVRBL	SQL Table	Default
GLRAPPL	SQL Table	Default
GLRCALC	SQL Table	Default
GLRCMPL	SQL Table	Default
GLRCOLR	SQL Table	Default
GLROBJT	SQL Table	Default
GLRORDR	SQL Table	Default
GLRVFRM	SQL Table	Default
GLRVRBL	SQL Table	Default
GTVLETR	SQL Table	Default
GTVPARA	SQL Table	Default
GTVSYSI	SQL Table	Default
GUBLETR	SQL Table	Default
GUBPARA	SQL Table	Default
GUBPPRF	SQL Table	Default
GURMAIL	SQL Table	Default

Model View

Table GLBAPPL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GLBAPPL_APPLICATION	VARCHAR2(30)	No	*
GLBAPPL_DESC	VARCHAR2(30)	No
GLBAPPL_SYSI_CODE	VARCHAR2(2)	No		*
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

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GLBSLCT	SQL Table	S10B80.GENERAL	Refer (no action)
GLBVRBL	SQL Table	S10B80.GENERAL	Refer (no action)
GLRAPPL	SQL Table	S10B80.GENERAL	Refer (no action)
GLRCMPL	SQL Table	S10B80.GENERAL	Refer (no action)
GUBPPRF	SQL Table	S10B80.GENERAL	Refer (no action)
GLBAPPL_EQUAL	Oracle Package Procedure	S10B80.BANINST1.POKPVAL	Use (select)
P_PIN_CHANGED_NOTIFICATION	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
P_PIN_CHANGED_NOTIFICATION	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Use (select)
F_GLBAPPL_EQUAL	Oracle Package Function	S10B80.BANINST1.GOKPVAL	Use (select)
P_PA_GLBAPPL_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PIN_CHANGED_NOTIFICATION	Oracle Package Procedure	S10B80.BANINST1.GOKMAIL	Rely On
P_PIN_CHANGED_NOTIFICATION	Oracle Package Procedure	S10B80.BANINST1.GOKMAIL	Use (select)
P_VALIDATE_GLBDATA	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Rely On
P_VALIDATE_GLBLSEL	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Use (Insert)
F_GLBAPPL_EQUAL	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
F_GLBAPPL_EQUAL	Oracle Package Function	S10B80.BANINST1.TOKPVAL	Use (select)
GLBAPPL	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GLBAPPL	SQL Index	S10B80.GENERAL	Rely On
GTVSYSI	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GLBAPPL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:31:55:000	04/02/2008 21:17:56:000

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 GLBOBJT

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GLBOBJT_OBJECT	VARCHAR2(30)	No	*
GLBOBJT_DESC	VARCHAR2(30)	No
GLBOBJT_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GLBOBJT	Unique	GLBOBJT_OBJECT

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GLROBJT	SQL Table	S10B80.GENERAL	Refer (no action)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GLBOBJT	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GLBOBJT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:29:04:000	04/02/2008 21:17:52:000

Source Code Comments

Letter Generation Object Base Table

Columns Comments for GLBOBJT_OBJECT (# 1)

Source Code Comments

OBJECT: Object code which uniquely identifies this record.

Columns Comments for GLBOBJT_DESC (# 2)

Source Code Comments

DESCRIPTION: Description of this object.

Columns Comments for GLBOBJT_ACTIVITY_DATE (# 3)

Source Code Comments

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

Table GLBSLCT

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GLBSLCT_APPLICATION	VARCHAR2(30)	No	*	*
GLBSLCT_SELECTION	VARCHAR2(30)	No	*
GLBSLCT_CREATOR_ID	VARCHAR2(30)	No	*
GLBSLCT_DESC	VARCHAR2(30)	No
GLBSLCT_LOCK_IND	VARCHAR2(1)	No
GLBSLCT_ACTIVITY_DATE	DATE	No
GLBSLCT_TYPE_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GLBSLCT_APPLICATION	GLBAPPL_APPLICATION	GLBAPPL

Index

Index Name	Index Type	Column Name
PK_GLBSLCT	Unique	GLBSLCT_APPLICATION
PK_GLBSLCT	Unique	GLBSLCT_SELECTION
PK_GLBSLCT	Unique	GLBSLCT_CREATOR_ID

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GLBEXTR	SQL Table	S10B80.GENERAL	Refer (no action)
GLRSFRM	SQL Table	S10B80.GENERAL	Refer (no action)
GLRSLCT	SQL Table	S10B80.GENERAL	Refer (no action)
GLVSLCT	SQL View	S10B80.BANINST1	Use (select)
GLBSLCT_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPSRC	Rely On
CHECK_GLBSLCT_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
GLBSLCTVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)Rely On
GLBSLCT_EQUAL	Oracle Package Procedure	S10B80.BANINST1.POKPVAL	Use (select)
F_GLBSLCT_EQUAL	Oracle Package Function	S10B80.BANINST1.GOKPVAL	Use (select)
P_PR_RORGRDE_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_PR_RORREGS_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_VALIDATE_GLBDATA	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Rely On
P_VALIDATE_GLBDATA	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Use (select)
P_VALIDATE_POP_SEL	Oracle Package Procedure	S10B80.BANINST1.POKPVAL	Rely On
P_VALIDATE_POP_SEL	Oracle Package Procedure	S10B80.BANINST1.POKPVAL	Use (select)
P_VALID_POPULATION_SELECTION	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_VALID_POP_SEL_3	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_VALID_POP_SEL_4	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Use (Insert)
F_GLBSLCT_EQUAL	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
GLBSLCT	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GLBSLCT	SQL Index	S10B80.GENERAL	Rely On
GLBAPPL	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GLBSLCT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:28:17:000	04/02/2008 21:17:51:000

Source Code Comments

Population Selection Base Table

Columns Comments for GLBSLCT_APPLICATION (# 1)

Source Code Comments

APPLICATION: Application code which with the selectino code uniquely identifies this record.

Columns Comments for GLBSLCT_SELECTION (# 2)

Source Code Comments

SELECTION: Selection code which with the application code uniquely identifies this record.

Columns Comments for GLBSLCT_CREATOR_ID (# 3)

Source Code Comments

CREATOR ID: The user id of the person who created this population selection.

Columns Comments for GLBSLCT_DESC (# 4)

Source Code Comments

DESCRIPTION: Description of this population selection.

Columns Comments for GLBSLCT_LOCK_IND (# 5)

Source Code Comments

LOCK INDICATOR: Indicator which indicates that this population selection is locked and cannot be executedby any other user.

Columns Comments for GLBSLCT_ACTIVITY_DATE (# 6)

Source Code Comments

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

Columns Comments for GLBSLCT_TYPE_IND (# 7)

Source Code Comments

SELECTION TYPE: Values are (M)anual PIDM joins required on form - GLOLETT will not add them, or blank.

Table GLBVRBL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GLBVRBL_APPLICATION	VARCHAR2(30)	No	*	*
GLBVRBL_VARIABLE	VARCHAR2(30)	No	*
GLBVRBL_DESC	VARCHAR2(30)	No
GLBVRBL_ACTIVITY_DATE	DATE	No
GLBVRBL_TYPE_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GLBVRBL_APPLICATION	GLBAPPL_APPLICATION	GLBAPPL

Index

Index Name	Index Type	Column Name
PK_GLBVRBL	Unique	GLBVRBL_APPLICATION
PK_GLBVRBL	Unique	GLBVRBL_VARIABLE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GLRCALC	SQL Table	S10B80.GENERAL	Refer (no action)
GLRCOLR	SQL Table	S10B80.GENERAL	Refer (no action)
GLRORDR	SQL Table	S10B80.GENERAL	Refer (no action)
GLRVFRM	SQL Table	S10B80.GENERAL	Refer (no action)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GLBVRBL	SQL Index	S10B80.GENERAL	Rely On
GLBAPPL	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GLBVRBL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:28:09:000	04/02/2008 21:17:51:000

Source Code Comments

Letter Generation Variable Base Table

Columns Comments for GLBVRBL_APPLICATION (# 1)

Source Code Comments

APPLICATION: Application code which with the variable uniquely identifies this record.

Columns Comments for GLBVRBL_VARIABLE (# 2)

Source Code Comments

VARIABLE: Variable code which with the application uniquely identifies this record.

Columns Comments for GLBVRBL_DESC (# 3)

Source Code Comments

DESCRIPTION: Description of this variable.

Columns Comments for GLBVRBL_ACTIVITY_DATE (# 4)

Source Code Comments

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

Columns Comments for GLBVRBL_TYPE_IND (# 5)

Source Code Comments

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.

Table GLRAPPL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GLRAPPL_APPLICATION	VARCHAR2(30)	No	*	*
GLRAPPL_KEY_NO	NUMBER(4,0)	No	*
GLRAPPL_LINE_NO	NUMBER(4,0)	No
GLRAPPL_ACTIVITY_DATE	DATE	No
GLRAPPL_DATA_ELEMENT	VARCHAR2(35)	No
GLRAPPL_OPERATOR	VARCHAR2(11)	No
GLRAPPL_VALUE	VARCHAR2(80)	Yes
GLRAPPL_OPEN_PAREN	VARCHAR2(3)	Yes
GLRAPPL_CLOSE_PAREN	VARCHAR2(3)	Yes
GLRAPPL_SEPARATOR	VARCHAR2(3)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GLRAPPL_APPLICATION	GLBAPPL_APPLICATION	GLBAPPL

Index

Index Name	Index Type	Column Name
PK_GLRAPPL	Unique	GLRAPPL_APPLICATION
PK_GLRAPPL	Unique	GLRAPPL_KEY_NO

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GLRAPPL	SQL Index	S10B80.GENERAL	Rely On
GLBAPPL	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GLRAPPL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:29:02:000	04/02/2008 21:17:52:000

Source Code Comments

Letter Generation Application Rules Table

Columns Comments for GLRAPPL_APPLICATION (# 1)

Source Code Comments

APPLICATION: The application code that uniquely identifies this Selection Identifier.

Columns Comments for GLRAPPL_KEY_NO (# 2)

Source Code Comments

SEQUENCE NUMBER: The internal number that uniquely identifies this line of the Selection Identifier.

Columns Comments for GLRAPPL_LINE_NO (# 3)

Source Code Comments

LINE NUMBER: The internal line number for ordering of the records.

Columns Comments for GLRAPPL_ACTIVITY_DATE (# 4)

Source Code Comments

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

Columns Comments for GLRAPPL_DATA_ELEMENT (# 5)

Source Code Comments

DATA ELEMENT: The name of the database column that is referenced in this Selection condition.

Columns Comments for GLRAPPL_OPERATOR (# 6)

Source Code Comments

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.

Columns Comments for GLRAPPL_VALUE (# 7)

Source Code Comments

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.

Columns Comments for GLRAPPL_OPEN_PAREN (# 8)

Source Code Comments

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.

Columns Comments for GLRAPPL_CLOSE_PAREN (# 9)

Source Code Comments

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.

Columns Comments for GLRAPPL_SEPARATOR (# 10)

Source Code Comments

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.

Table GLRCALC

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GLRCALC_APPLICATION	VARCHAR2(30)	No	*	*
GLRCALC_LETR_CODE	VARCHAR2(15)	No	*	*
GLRCALC_VARIABLE	VARCHAR2(30)	No	*	*
GLRCALC_PIDM	NUMBER(8,0)	No	*
GLRCALC_ROWNUM	NUMBER(8,0)	No	*
GLRCALC_ACTIVITY_DATE	DATE	No
GLRCALC_AMT01	NUMBER(17,2)	Yes
GLRCALC_AMT02	NUMBER(17,2)	Yes
GLRCALC_AMT03	NUMBER(17,2)	Yes
GLRCALC_AMT04	NUMBER(17,2)	Yes
GLRCALC_AMT05	NUMBER(17,2)	Yes
GLRCALC_AMT06	NUMBER(17,2)	Yes
GLRCALC_AMT07	NUMBER(17,2)	Yes
GLRCALC_AMT08	NUMBER(17,2)	Yes
GLRCALC_AMT09	NUMBER(17,2)	Yes
GLRCALC_AMT10	NUMBER(17,2)	Yes
GLRCALC_AMT11	NUMBER(17,2)	Yes
GLRCALC_AMT12	NUMBER(17,2)	Yes
GLRCALC_AMT13	NUMBER(17,2)	Yes
GLRCALC_AMT14	NUMBER(17,2)	Yes
GLRCALC_AMT15	NUMBER(17,2)	Yes
GLRCALC_AMT16	NUMBER(17,2)	Yes
GLRCALC_AMT17	NUMBER(17,2)	Yes
GLRCALC_AMT18	NUMBER(17,2)	Yes
GLRCALC_AMT19	NUMBER(17,2)	Yes
GLRCALC_AMT20	NUMBER(17,2)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GLRCALC_LETR_CODE	GTVLETR_CODE	GTVLETR
GLRCALC_APPLICATION	GLBVRBL_APPLICATION	GLBVRBL
GLRCALC_VARIABLE	GLBVRBL_VARIABLE	GLBVRBL

Index

Index Name	Index Type	Column Name
PK_GLRCALC	Unique	GLRCALC_APPLICATION
PK_GLRCALC	Unique	GLRCALC_LETR_CODE
PK_GLRCALC	Unique	GLRCALC_VARIABLE
PK_GLRCALC	Unique	GLRCALC_PIDM
PK_GLRCALC	Unique	GLRCALC_ROWNUM

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GLRCALC	SQL Index	S10B80.GENERAL	Rely On
GLBVRBL	SQL Table	S10B80.GENERAL	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GLRCALC

Object Dates

Creation Date	Analysis Date
04/02/2008 20:27:51:000	04/02/2008 21:17:51:000

Source Code Comments

Letter Generation Calculation Collector Table

Columns Comments for GLRCALC_APPLICATION (# 1)

Source Code Comments

APPLICATION: The name of the Letter Generation Application related to this Collector record.

Columns Comments for GLRCALC_LETR_CODE (# 2)

Source Code Comments

LETTER CODE: The code designating the Letter associated with this Collector record.

Columns Comments for GLRCALC_VARIABLE (# 3)

Source Code Comments

VARIABLE: The name of the Letter Generation Variable related to this Collector record.

Columns Comments for GLRCALC_PIDM (# 4)

Source Code Comments

PIDM: The internal system student identification number.

Columns Comments for GLRCALC_ROWNUM (# 5)

Source Code Comments

ROW NUMBER: The internal number uniquely identifying this Collector record.

Columns Comments for GLRCALC_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 GLRCALC_AMT01 (# 7)

Source Code Comments

AMOUNT 1: Amount used for mathematical calculations in Letter Generation.

Columns Comments for GLRCALC_AMT02 (# 8)

Source Code Comments

AMOUNT 2: Amount used for mathematical calculations in Letter Generation.

Columns Comments for GLRCALC_AMT03 (# 9)

Source Code Comments

AMOUNT 3: Amount used for mathematical calculations in Letter Generation.

Columns Comments for GLRCALC_AMT04 (# 10)

Source Code Comments

AMOUNT 4: Amount used for mathematical calculations in Letter Generation.

Columns Comments for GLRCALC_AMT05 (# 11)

Source Code Comments

AMOUNT 5: Amount used for mathematical calculations in Letter Generation.

Columns Comments for GLRCALC_AMT06 (# 12)

Source Code Comments

AMOUNT 6: Amount used for mathematical calculations in Letter Generation.

Columns Comments for GLRCALC_AMT07 (# 13)

Source Code Comments

AMOUNT 7: Amount used in mathematical calculations in Letter Generation.

Columns Comments for GLRCALC_AMT08 (# 14)

Source Code Comments

AMOUNT 8: Amount used in mathematical calculations in Letter Generation.

Columns Comments for GLRCALC_AMT09 (# 15)

Source Code Comments

AMOUNT 9: Amount used in mathematical calculations in Letter Generation.

Columns Comments for GLRCALC_AMT10 (# 16)

Source Code Comments

AMOUNT 10: Amount used for mathematical calculations in Letter Generation.

Columns Comments for GLRCALC_AMT11 (# 17)

Source Code Comments

AMOUNT 11: Amount used for mathematical calculations in Letter Generation.

Columns Comments for GLRCALC_AMT12 (# 18)

Source Code Comments

AMOUNT 12: Amount used for mathematical calculations in Letter Generation.

Columns Comments for GLRCALC_AMT13 (# 19)

Source Code Comments

AMOUNT 13: Amount used for mathematical calculations in Letter Generation.

Columns Comments for GLRCALC_AMT14 (# 20)

Source Code Comments

AMOUNT 14: Amount used for mathematical calculations in Letter Generation.

Columns Comments for GLRCALC_AMT15 (# 21)

Source Code Comments

AMOUNT 15: Amount used for mathematical calculations in Letter Generation.

Columns Comments for GLRCALC_AMT16 (# 22)

Source Code Comments

AMOUNT 16: Amount used for mathematical calculations in Letter Generation.

Columns Comments for GLRCALC_AMT17 (# 23)

Source Code Comments

AMOUNT 17: Amount used for mathematical calculations in Letter Generation.

Columns Comments for GLRCALC_AMT18 (# 24)

Source Code Comments

AMOUNT 18: Amount used for mathematical calculations in Letter Generation.

Columns Comments for GLRCALC_AMT19 (# 25)

Source Code Comments

AMOUNT 19: Amount used for mathematical calculations in Letter Generation.

Columns Comments for GLRCALC_AMT20 (# 26)

Source Code Comments

AMOUNT 20: Amount used for mathematical calculations in Letter Generation.

Table GLRCMPL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
GLRCMPL_APPLICATION	VARCHAR2(30)	No	*
GLRCMPL_VRBL_OR_SLCT	VARCHAR2(30)	No
GLRCMPL_CREATOR_ID	VARCHAR2(30)	No
GLRCMPL_SEQ_NO	NUMBER(3,0)	No
GLRCMPL_ACTIVITY_DATE	DATE	No
GLRCMPL_SUB_SEQ_NO	NUMBER(6,0)	Yes
GLRCMPL_SQL_LENGTH	NUMBER(5,0)	Yes
GLRCMPL_SQL_STATEMENT	LONG	Yes
GLRCMPL_SQL_PARMS	VARCHAR2(240)	Yes
GLRCMPL_FROM_WHERE_SEP	NUMBER(4,0)	Yes
GLRCMPL_JOIN_TABLE	VARCHAR2(30)	Yes
GLRCMPL_ADDS_IND	VARCHAR2(1)	Yes
GLRCMPL_APPL_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GLRCMPL_APPLICATION	GLBAPPL_APPLICATION	GLBAPPL

Index

Index Name	Index Type	Column Name
GLRCMPL_KEY_INDEX	Unique	GLRCMPL_APPLICATION
GLRCMPL_KEY_INDEX	Unique	GLRCMPL_VRBL_OR_SLCT
GLRCMPL_KEY_INDEX	Unique	GLRCMPL_CREATOR_ID
GLRCMPL_KEY_INDEX	Unique	GLRCMPL_SEQ_NO
GLRCMPL_KEY_INDEX	Unique	GLRCMPL_SUB_SEQ_NO

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GLRCMPL_KEY_INDEX	SQL Index	S10B80.GENERAL	Rely On
GLBAPPL	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GLRCMPL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:31:23:000	04/02/2008 21:17:55:000

Source Code Comments

Selection Identifier Compiled Statements

Columns Comments for GLRCMPL_APPLICATION (# 1)

Source Code Comments

APPLICATION: The application code used to uniquely identify this Compiled SQL Statement

Columns Comments for GLRCMPL_VRBL_OR_SLCT (# 2)

Source Code Comments

VARIABLE or SELECTION: The variable/selection code used to uniquely identify this Compiled SQL Statement

Columns Comments for GLRCMPL_CREATOR_ID (# 3)

Source Code Comments

CREATOR ID: User ID of the creator of the population selection or last to modify the variable

Columns Comments for GLRCMPL_SEQ_NO (# 4)

Source Code Comments

SEQUENCE NUMBER: The internal sequence number of this Compiled SQL Statement.

Columns Comments for GLRCMPL_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 GLRCMPL_SUB_SEQ_NO (# 6)

Source Code Comments

SUBORDINATE SEQUENCE NUMBER: An internal sequence number, used by the Letter Generation process as a subordinate sequence to the GLRCMPL_SEQ_NO sequence number.

Columns Comments for GLRCMPL_SQL_LENGTH (# 7)

Source Code Comments

SQL STATEMENT LENGTH: The length (in characters) of the Compiled SQL Statement

Columns Comments for GLRCMPL_SQL_STATEMENT (# 8)

Source Code Comments

SQL STATEMENT: The text of the Compiled SQL Statement.

Columns Comments for GLRCMPL_SQL_PARMS (# 9)

Source Code Comments

SQL PARAMETERS: Internal parameters that are used in the Letter Generation, Report Extract and Group Assignment processes.

Columns Comments for GLRCMPL_FROM_WHERE_SEP (# 10)

Source Code Comments

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.

Columns Comments for GLRCMPL_JOIN_TABLE (# 11)

Source Code Comments

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.

Columns Comments for GLRCMPL_ADDS_IND (# 12)

Source Code Comments

ADDRESS VIEW INDICATOR: This indicator is set if the address view is referenced by a variable.

Columns Comments for GLRCMPL_APPL_IND (# 13)

Source Code Comments

APPLICATION INDICATOR: This indicator is set if this record is the application level rules portion of an SPVADDS-related variable.

Table GLRCOLR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
GLRCOLR_APPLICATION	VARCHAR2(30)	No	*
GLRCOLR_LETR_CODE	VARCHAR2(15)	No	*
GLRCOLR_PIDM	NUMBER(8,0)	No
GLRCOLR_VARIABLE	VARCHAR2(30)	No	*
GLRCOLR_SEQ_NO	NUMBER(6,0)	No
GLRCOLR_ROWNUM	NUMBER(6,0)	No
GLRCOLR_ACTIVITY_DATE	DATE	No
GLRCOLR_RESULT	VARCHAR2(2000)	Yes
GLRCOLR_KEY	VARCHAR2(240)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GLRCOLR_APPLICATION	GLBVRBL_APPLICATION	GLBVRBL
GLRCOLR_VARIABLE	GLBVRBL_VARIABLE	GLBVRBL
GLRCOLR_LETR_CODE	GTVLETR_CODE	GTVLETR

Index

Index Name	Index Type	Column Name
GLRCOLR_KEY_INDEX	Unique	GLRCOLR_APPLICATION
GLRCOLR_KEY_INDEX	Unique	GLRCOLR_LETR_CODE
GLRCOLR_KEY_INDEX	Unique	GLRCOLR_PIDM
GLRCOLR_KEY_INDEX	Unique	GLRCOLR_VARIABLE
GLRCOLR_KEY_INDEX	Unique	GLRCOLR_SEQ_NO
GLRCOLR_KEY_INDEX	Unique	GLRCOLR_ROWNUM
GLRCOLR_KEY_INDEX	Unique	GLRCOLR_KEY

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GLRCOLR_KEY_INDEX	SQL Index	S10B80.GENERAL	Rely On
GLBVRBL	SQL Table	S10B80.GENERAL	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GLRCOLR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:32:52:000	04/02/2008 21:17:57:000

Source Code Comments

Letter Generation Collector Table

Columns Comments for GLRCOLR_APPLICATION (# 1)

Source Code Comments

APPLICATION: The application designating the variables associated with this collector record.

Columns Comments for GLRCOLR_LETR_CODE (# 2)

Source Code Comments

LETTER CODE: The code designating the Letter associated with this Collector record.

Columns Comments for GLRCOLR_PIDM (# 3)

Source Code Comments

PIDM: The internal system student identification number.

Columns Comments for GLRCOLR_VARIABLE (# 4)

Source Code Comments

VARIABLE: The name of the Letter Generation variable associated with this Collector record.

Columns Comments for GLRCOLR_SEQ_NO (# 5)

Source Code Comments

SEQUENCE NUMBER: The internal sequence number of this Collector record.

Columns Comments for GLRCOLR_ROWNUM (# 6)

Source Code Comments

ROW NUMBER: The internal number uniquely identifying this Collector record.

Columns Comments for GLRCOLR_ACTIVITY_DATE (# 7)

Source Code Comments

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

Columns Comments for GLRCOLR_RESULT (# 8)

Source Code Comments

RESULT: The result of the query that is performed which is related to the Letter Generation variable in this Collector record.

Columns Comments for GLRCOLR_KEY (# 9)

Source Code Comments

A record key value associated with this variable (ex: a PIDM value or initials to be used in updating GURMAIL_INIT_CODE),

Table GLROBJT

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GLROBJT_OBJECT	VARCHAR2(30)	No	*	*
GLROBJT_KEY_NO	NUMBER(4,0)	No	*
GLROBJT_LINE_NO	NUMBER(4,0)	No
GLROBJT_ACTIVITY_DATE	DATE	No
GLROBJT_DATA_ELEMENT	VARCHAR2(35)	No
GLROBJT_OPERATOR	VARCHAR2(11)	No
GLROBJT_VALUE	VARCHAR2(80)	Yes
GLROBJT_OPEN_PAREN	VARCHAR2(3)	Yes
GLROBJT_CLOSE_PAREN	VARCHAR2(3)	Yes
GLROBJT_SEPARATOR	VARCHAR2(3)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GLROBJT_OBJECT	GLBOBJT_OBJECT	GLBOBJT

Index

Index Name	Index Type	Column Name
PK_GLROBJT	Unique	GLROBJT_OBJECT
PK_GLROBJT	Unique	GLROBJT_KEY_NO

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GLROBJT	SQL Index	S10B80.GENERAL	Rely On
GLBOBJT	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GLROBJT

Object Dates

Creation Date	Analysis Date
04/02/2008 20:32:13:000	04/02/2008 21:17:56:000

Source Code Comments

Letter Generation Object Rules Table

Columns Comments for GLROBJT_OBJECT (# 1)

Source Code Comments

OBJECT: The object code that uniquely identifies this Selection Identifier.

Columns Comments for GLROBJT_KEY_NO (# 2)

Source Code Comments

SEQUENCE NUMBER: The internal number that uniquely identifies this line of the Selection Identifier.

Columns Comments for GLROBJT_LINE_NO (# 3)

Source Code Comments

LINE NUMBER: The internal line number for ordering of the records.

Columns Comments for GLROBJT_ACTIVITY_DATE (# 4)

Source Code Comments

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

Columns Comments for GLROBJT_DATA_ELEMENT (# 5)

Source Code Comments

DATA ELEMENT: The name of the database column that is referenced in this Selection condition.

Columns Comments for GLROBJT_OPERATOR (# 6)

Source Code Comments

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.

Columns Comments for GLROBJT_VALUE (# 7)

Source Code Comments

Columns Comments for GLROBJT_OPEN_PAREN (# 8)

Source Code Comments

Columns Comments for GLROBJT_CLOSE_PAREN (# 9)

Source Code Comments

Columns Comments for GLROBJT_SEPARATOR (# 10)

Source Code Comments

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.

Table GLRORDR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GLRORDR_APPLICATION	VARCHAR2(30)	No	*	*
GLRORDR_LETR_CODE	VARCHAR2(15)	No	*	*
GLRORDR_SEQ_NO	NUMBER(6,0)	No	*
GLRORDR_VARIABLE	VARCHAR2(30)	No		*
GLRORDR_ACTIVITY_DATE	DATE	No
GLRORDR_SPVADDS	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GLRORDR_APPLICATION	GLBVRBL_APPLICATION	GLBVRBL
GLRORDR_VARIABLE	GLBVRBL_VARIABLE	GLBVRBL
GLRORDR_LETR_CODE	GTVLETR_CODE	GTVLETR

Index

Index Name	Index Type	Column Name
PK_GLRORDR	Unique	GLRORDR_APPLICATION
PK_GLRORDR	Unique	GLRORDR_LETR_CODE
PK_GLRORDR	Unique	GLRORDR_SEQ_NO

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GLRORDR	SQL Index	S10B80.GENERAL	Rely On
GLBVRBL	SQL Table	S10B80.GENERAL	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GLRORDR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:33:01:000	04/02/2008 21:17:57:000

Source Code Comments

Letter Generation Order Table

Columns Comments for GLRORDR_APPLICATION (# 1)

Source Code Comments

APPLICATION: The name of the Letter Generation Application associated with this Order record.

Columns Comments for GLRORDR_LETR_CODE (# 2)

Source Code Comments

LETTER CODE: The code designating the Letter associated with this Order record.

Columns Comments for GLRORDR_SEQ_NO (# 3)

Source Code Comments

SEQUENCE NUMBER: The internal sequence number that uniquely identifies this Order record.

Columns Comments for GLRORDR_VARIABLE (# 4)

Source Code Comments

VARIABLE: The name of the Letter Generation Variable associated with this Order record.

Columns Comments for GLRORDR_ACTIVITY_DATE (# 5)

Source Code Comments

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

Table GLRVFRM

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GLRVFRM_APPLICATION	VARCHAR2(30)	No	*	*
GLRVFRM_VARIABLE	VARCHAR2(30)	No	*	*
GLRVFRM_SEQ_NO	NUMBER(3,0)	No	*
GLRVFRM_ACTIVITY_DATE	DATE	No
GLRVFRM_SELECT_CLAUSE	VARCHAR2(240)	No
GLRVFRM_FROM_CLAUSE	VARCHAR2(240)	No
GLRVFRM_ORDER_BY	VARCHAR2(240)	Yes
GLRVFRM_GROUP_BY	VARCHAR2(240)	Yes
GLRVFRM_DESC	VARCHAR2(80)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GLRVFRM_APPLICATION	GLBVRBL_APPLICATION	GLBVRBL
GLRVFRM_VARIABLE	GLBVRBL_VARIABLE	GLBVRBL

Index

Index Name	Index Type	Column Name
PK_GLRVFRM	Unique	GLRVFRM_APPLICATION
PK_GLRVFRM	Unique	GLRVFRM_VARIABLE
PK_GLRVFRM	Unique	GLRVFRM_SEQ_NO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GLRVRBL	SQL Table	S10B80.GENERAL	Refer (no action)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GLRVFRM	SQL Index	S10B80.GENERAL	Rely On
GLBVRBL	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GLRVFRM

Object Dates

Creation Date	Analysis Date
04/02/2008 20:28:10:000	04/02/2008 21:17:51:000

Source Code Comments

Letter Generation Variable Select Table

Columns Comments for GLRVFRM_APPLICATION (# 1)

Source Code Comments

APPLICATION: Application code which with the variable and the sequence number uniquely identifies this record.

Columns Comments for GLRVFRM_VARIABLE (# 2)

Source Code Comments

VARIABLE: Variable code which with the application and the sequence number uniquely identifies this record.

Columns Comments for GLRVFRM_SEQ_NO (# 3)

Source Code Comments

SEQUENCE NUMBER: Sequence number which with the application and variable uniquely identifies this record.

Columns Comments for GLRVFRM_ACTIVITY_DATE (# 4)

Source Code Comments

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

Columns Comments for GLRVFRM_SELECT_CLAUSE (# 5)

Source Code Comments

SELECT CLAUSE: The "SELECT" part of the variable; what is to be selected.

Columns Comments for GLRVFRM_FROM_CLAUSE (# 6)

Source Code Comments

FROM CLAUSE: The "FROM" part of the variable; from which tables should the select be performed.

Columns Comments for GLRVFRM_ORDER_BY (# 7)

Source Code Comments

ORDER BY: The "ORDER BY" part of the variable; in which order should the values selected by ordered.

Columns Comments for GLRVFRM_GROUP_BY (# 8)

Source Code Comments

GROUP BY: The "GROUP BY" part of the variable; in which way should the values selected by grouped.

Columns Comments for GLRVFRM_DESC (# 9)

Source Code Comments

DESCRIPTION: The description associated with each sequence number.

Table GLRVRBL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GLRVRBL_APPLICATION	VARCHAR2(30)	No	*	*
GLRVRBL_VARIABLE	VARCHAR2(30)	No	*	*
GLRVRBL_SEQ_NO	NUMBER(3,0)	No	*	*
GLRVRBL_KEY_NO	NUMBER(4,0)	No	*
GLRVRBL_LINE_NO	NUMBER(4,0)	No
GLRVRBL_ACTIVITY_DATE	DATE	No
GLRVRBL_DATA_ELEMENT	VARCHAR2(35)	No
GLRVRBL_OPERATOR	VARCHAR2(11)	No
GLRVRBL_VALUE	VARCHAR2(80)	Yes
GLRVRBL_OPEN_PAREN	VARCHAR2(3)	Yes
GLRVRBL_CLOSE_PAREN	VARCHAR2(3)	Yes
GLRVRBL_SEPARATOR	VARCHAR2(3)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GLRVRBL_APPLICATION	GLRVFRM_APPLICATION	GLRVFRM
GLRVRBL_VARIABLE	GLRVFRM_VARIABLE	GLRVFRM
GLRVRBL_SEQ_NO	GLRVFRM_SEQ_NO	GLRVFRM

Index

Index Name	Index Type	Column Name
PK_GLRVRBL	Unique	GLRVRBL_APPLICATION
PK_GLRVRBL	Unique	GLRVRBL_VARIABLE
PK_GLRVRBL	Unique	GLRVRBL_SEQ_NO
PK_GLRVRBL	Unique	GLRVRBL_KEY_NO

Calling objects (non escalated)

No Calling objects (non escalated)

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GLRVRBL	SQL Index	S10B80.GENERAL	Rely On
GLRVFRM	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GLRVRBL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:31:15:000	04/02/2008 21:17:54:000

Source Code Comments

Letter Generation Variable Rules Table

Columns Comments for GLRVRBL_APPLICATION (# 1)

Source Code Comments

APPLICATION: Application code which with the variable, sequence number and key number uniquely identifies this record.

Columns Comments for GLRVRBL_VARIABLE (# 2)

Source Code Comments

VARIABLE: Variable code which with the application, sequence number and key number uniquely identifies this record.

Columns Comments for GLRVRBL_SEQ_NO (# 3)

Source Code Comments

SEQUENCE_NUMBER: Sequence number which with the application, variable and key number uniquely identifies this record.

Columns Comments for GLRVRBL_KEY_NO (# 4)

Source Code Comments

KEY NUMBER: Key number which with the application, variable and sequence number uniquely identifies this record.

Columns Comments for GLRVRBL_LINE_NO (# 5)

Source Code Comments

LINE NUMBER: Line number which is used for sorting or ordering of the rules.

Columns Comments for GLRVRBL_ACTIVITY_DATE (# 6)

Source Code Comments

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

Columns Comments for GLRVRBL_DATA_ELEMENT (# 7)

Source Code Comments

DATA ELEMENT: Database column name to be used as part of the rules statement.

Columns Comments for GLRVRBL_OPERATOR (# 8)

Source Code Comments

OPERATOR: The operator (=, <, >, etc.) to be used as part of the rules statement.

Columns Comments for GLRVRBL_VALUE (# 9)

Source Code Comments

VALUE: The value to be compared (literal text, date value, number, another column or a subquery) as part of the rules statement.

Columns Comments for GLRVRBL_OPEN_PAREN (# 10)

Source Code Comments

OPEN PARENTHESIS: The open parenthesis "(" to be used as part of the rules.

Columns Comments for GLRVRBL_CLOSE_PAREN (# 11)

Source Code Comments

CLOSE PARENTHESIS: The close parenthesis ")" to be used as part of the rules.

Columns Comments for GLRVRBL_SEPARATOR (# 12)

Source Code Comments

SEPARATOR: The AND or OR to be used as part of the rules.

Table GTVLETR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GTVLETR_CODE	VARCHAR2(15)	No	*
GTVLETR_ACTIVITY_DATE	DATE	No
GTVLETR_DUPL_IND	VARCHAR2(1)	No
GTVLETR_DESC	VARCHAR2(30)	Yes
GTVLETR_PRINT_COMMAND	VARCHAR2(10)	Yes
GTVLETR_LETR_CODE_ALT	VARCHAR2(15)	Yes		*

Foreign Key information

Column name	is Foreign Key For Column	on Table
GTVLETR_LETR_CODE_ALT	GTVLETR_CODE	GTVLETR

Index

Index Name	Index Type	Column Name
PK_GTVLETR	Unique	GTVLETR_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GTVLETR	Oracle Synonym	S10B80.FAISMGR	Rely On
AABDINS	SQL Table	S10B80.ALUMNI	Refer (no action)
AABMSHP	SQL Table	S10B80.ALUMNI	Refer (no action)
AARACKN	SQL Table	S10B80.ALUMNI	Refer (no action)
AARACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKCT	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKDN	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKEX	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKIN	SQL Table	S10B80.ALUMNI	Refer (no action)
AARAKMB	SQL Table	S10B80.ALUMNI	Refer (no action)
AARDINS	SQL Table	S10B80.ALUMNI	Refer (no action)
AARMEMB	SQL Table	S10B80.ALUMNI	Refer (no action)
AARRLET	SQL Table	S10B80.ALUMNI	Refer (no action)
AGBWPLG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRACKN	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRACKR	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKCP	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKCT	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKDC	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKDG	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKDN	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKEX	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKGC	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKGT	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRAKPC	SQL Table	S10B80.ALUMNI	Refer (no action)
AGRALET	SQL Table	S10B80.ALUMNI	Refer (no action)
AUBINST	SQL Table	S10B80.ALUMNI	Refer (no action)
GEBFUNC	SQL Table	S10B80.GENERAL	Refer (no action)
GERFCOR	SQL Table	S10B80.GENERAL	Refer (no action)
GLRCALC	SQL Table	S10B80.GENERAL	Refer (no action)
GLRCOLR	SQL Table	S10B80.GENERAL	Refer (no action)
GLRORDR	SQL Table	S10B80.GENERAL	Refer (no action)
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)
GUBLETR	SQL Table	S10B80.GENERAL	Refer (no action)
GUBPPRF	SQL Table	S10B80.GENERAL	Refer (no action)
GURMAIL	SQL Table	S10B80.GENERAL	Refer (no action)
RBRGMSG	SQL Table	S10B80.FAISMGR	Refer (no action)
RFRMESG	SQL Table	S10B80.FAISMGR	Refer (no action)
RORSTRF	SQL Table	S10B80.FAISMGR	Refer (no action)
RRRTMSG	SQL Table	S10B80.FAISMGR	Refer (no action)
RTVSAPR	SQL Table	S10B80.FAISMGR	Refer (no action)
SARWALT	SQL Table	S10B80.SATURN	Refer (no action)
SFREPRT	SQL Table	S10B80.SATURN	Refer (no action)
SHBGADR	SQL Table	S10B80.SATURN	Refer (no action)
SHRTPRT	SQL Table	S10B80.SATURN	Refer (no action)
SOBMATL	SQL Table	S10B80.SATURN	Refer (no action)
SORELTL	SQL Table	S10B80.SATURN	Refer (no action)
F_STUDENT_GET_DESC	SQL Function	S10B80.BANINST1	Use (select)
CHK_GURMAIL_DUPS_BY_AIDY_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
CHK_GURMAIL_DUPS_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
P_VALIDATION	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (Insert,select)
GTVLETRC	Oracle Package Cursor	S10B80.BANINST1.GTKLETR	Use (select)Rely On
GTVLETR_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVLETR	Rely On
GTVLETR_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVLETR	Use (select)Rely On
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Rely On
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Use (select)
P_PA_GTVLETR_EQUAL	Oracle Package Procedure	S10B80.BANINST1.ROKPVAL	Use (select)
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.AOKPVAL	Rely On
P_VALIDATE_GLBLSEL	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ADMISSIONSAPPLICATION	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_WL_REORDERING	Use (Insert,select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_GRADAPP_DISPLAYRULE	Use (Insert,select)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVLETR	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVLETR	Rely On
F_GTVLETR_LIKE	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
GTVLETR	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GTVLETR	SQL Index	S10B80.GENERAL	Rely On
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVLETR

Object Dates

Creation Date	Analysis Date
04/02/2008 10:35:09:000	04/02/2008 21:17:50:000

Source Code Comments

Letter Process Letter Validation Table

Columns Comments for GTVLETR_CODE (# 1)

Source Code Comments

This field identifies the letter code referenced on the Recruiting Material Control Form (SRAMATL) and the Letter Process Form (GUALETR).

Columns Comments for GTVLETR_ACTIVITY_DATE (# 2)

Source Code Comments

This field identifies the most recent date a record was created or updated.

Columns Comments for GTVLETR_DUPL_IND (# 3)

Source Code Comments

Y = Duplicates may be printed for this letter code, N = no dups.

Columns Comments for GTVLETR_DESC (# 4)

Source Code Comments

This field specifies the recruiting letter/material associated with the letter code.

Columns Comments for GTVLETR_PRINT_COMMAND (# 5)

Source Code Comments

This field identifies alternate print command code (e.g. PL - Print Landscape) for associated letter/material.

Columns Comments for GTVLETR_LETR_CODE_ALT (# 6)

Source Code Comments

Alternate Letter code for letter codes that do not allow duplicates.

Table GTVPARA

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVPARA_CODE	VARCHAR2(7)	No	*
GTVPARA_DESC	VARCHAR2(30)	Yes
GTVPARA_COMMENT	VARCHAR2(240)	Yes
GTVPARA_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVPARA	Unique	GTVPARA_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GUBLETR	SQL Table	S10B80.GENERAL	Refer (no action)
GUBPARA	SQL Table	S10B80.GENERAL	Refer (no action)
GTVPARAC	Oracle Package Cursor	S10B80.BANINST1.GTKPARA	Use (select)Rely On
GTVPARA_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVPARA	Rely On
GTVPARA_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVPARA	Use (select)Rely On
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVPARA	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVPARA	Rely On
GTVPARA	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GTVPARA	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVPARA

Object Dates

Creation Date	Analysis Date
04/02/2008 20:27:58:000	04/02/2008 21:17:51:000

Source Code Comments

Letter Process Paragraph Validation Table

Columns Comments for GTVPARA_CODE (# 1)

Source Code Comments

This field identifies the paragraph code referenced by the General Letter Process Form (GUALETR).

Columns Comments for GTVPARA_DESC (# 2)

Source Code Comments

This field specifies the paragraph associated with the paragraph code.

Columns Comments for GTVPARA_COMMENT (# 3)

Source Code Comments

This field maintains a comment associated with the paragraph. It is NOT printed in letter.

Columns Comments for GTVPARA_ACTIVITY_DATE (# 4)

Source Code Comments

This field identifies the most recent date a record was created or updated.

Table GTVSYSI

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK
GTVSYSI_CODE	VARCHAR2(2)	No	*
GTVSYSI_DESC	VARCHAR2(30)	No
GTVSYSI_ACTIVITY_DATE	DATE	No

Foreign Key information

No Foreign Key

Index

Index Name	Index Type	Column Name
PK_GTVSYSI	Unique	GTVSYSI_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ETVAXAP	SQL Table	S10B80.BANIMGR	Refer (no action)
GJBJOBS	SQL Table	S10B80.GENERAL	Refer (no action)
GLBAPPL	SQL Table	S10B80.GENERAL	Refer (no action)
GORMERC	SQL Table	S10B80.GENERAL	Refer (no action)
GORSDAV	SQL Table	S10B80.GENERAL	Join
GUBOBJS	SQL Table	S10B80.GENERAL	Refer (no action)
GURAOBJ	SQL Table	S10B80.BANSECR	Refer (no action)
GTVSYSI_ADD	SQL View	S10B80.BANINST1	Use (select)
GTVSYSI_ADS	SQL View	S10B80.BANINST1	Use (select)
GTVSYSIC	Oracle Package Cursor	S10B80.BANINST1.GTKSYSI	Use (select)Rely On
GTVSYSI_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVSYSI	Rely On
GTVSYSI_C	Oracle Package Cursor	S10B80.BANINST1.GB_GTVSYSI	Use (select)Rely On
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Use (Insert)
F_CODE_EXISTS	Oracle Package Function	S10B80.BANINST1.GB_GTVSYSI	Rely On
F_GET_DESCRIPTION	Oracle Package Function	S10B80.BANINST1.GB_GTVSYSI	Rely On
GTVSYSI	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GTVSYSI	SQL Index	S10B80.GENERAL	Rely On

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GTVSYSI

Object Dates

Creation Date	Analysis Date
04/02/2008 20:29:54:000	04/02/2008 21:17:53:000

Source Code Comments

System Indicator Validation Table

Columns Comments for GTVSYSI_CODE (# 1)

Source Code Comments

CODE: System indicator which uniquely identifies this record.

Columns Comments for GTVSYSI_DESC (# 2)

Source Code Comments

DESCRIPTION: Description of this code.

Columns Comments for GTVSYSI_ACTIVITY_DATE (# 3)

Source Code Comments

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

Table GUBLETR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GUBLETR_LETR_CODE	VARCHAR2(15)	No	*	*
GUBLETR_PARA_CODE	VARCHAR2(7)	No	*	*
GUBLETR_PARA_SEQNO	NUMBER(3,0)	No	*
GUBLETR_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GUBLETR_LETR_CODE	GTVLETR_CODE	GTVLETR
GUBLETR_PARA_CODE	GTVPARA_CODE	GTVPARA

Index

Index Name	Index Type	Column Name
PK_GUBLETR	Unique	GUBLETR_LETR_CODE
PK_GUBLETR	Unique	GUBLETR_PARA_CODE
PK_GUBLETR	Unique	GUBLETR_PARA_SEQNO

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GUBPARA	SQL Table	S10B80.GENERAL	Join
GUBLETR_ADD	SQL View	S10B80.BANINST1	Use (select)
GUVLETR	SQL View	S10B80.BANINST1	Use (select)
GUBLETR	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
PK_GUBLETR	SQL Index	S10B80.GENERAL	Rely On
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)
GTVPARA	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GUBLETR

Object Dates

Creation Date	Analysis Date
04/02/2008 20:28:49:000	04/02/2008 21:17:52:000

Source Code Comments

GUBLETR: Contains information about paragraphs within a letter.

Columns Comments for GUBLETR_LETR_CODE (# 1)

Source Code Comments

LETTER CODE: The code identifying this letter. May not contain imbedded spaces.

Columns Comments for GUBLETR_PARA_CODE (# 2)

Source Code Comments

PARAGRAPH CODE: The code identifying a paragraph on this letter.

Columns Comments for GUBLETR_PARA_SEQNO (# 3)

Source Code Comments

PARAGRAPH SEQUENCE: A number identifying the sequence of paragraphs within a letter.

Columns Comments for GUBLETR_ACTIVITY_DATE (# 4)

Source Code Comments

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

Table GUBPARA

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
GUBPARA_PARA_CODE	VARCHAR2(7)	No	*
GUBPARA_SEQ_NO	NUMBER(23,20)	No
GUBPARA_TEXT_VAR	VARCHAR2(60)	Yes
GUBPARA_ACTIVITY_DATE	DATE	No

Foreign Key information

Column name	is Foreign Key For Column	on Table
GUBPARA_PARA_CODE	GTVPARA_CODE	GTVPARA
GUBPARA_PARA_CODE	GUBLETR_PARA_CODE	GUBLETR

Index

Index Name	Index Type	Column Name
GUBPARA_KEY_INDEX		GUBPARA_PARA_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GUVLETR	SQL View	S10B80.BANINST1	Use (select)
GUBPARA	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GUBPARA_KEY_INDEX	SQL Index	S10B80.GENERAL	Rely On
GTVPARA	SQL Table	S10B80.GENERAL	Refer (no action)
GUBLETR	SQL Table	S10B80.GENERAL	Join

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GUBPARA

Object Dates

Creation Date	Analysis Date
04/02/2008 20:28:52:000	04/02/2008 21:17:52:000

Source Code Comments

Letter Paragraph Table

Columns Comments for GUBPARA_PARA_CODE (# 1)

Source Code Comments

PARAGRAPH CODE: The code identifying the paragraph associated with this record.

Columns Comments for GUBPARA_SEQ_NO (# 2)

Source Code Comments

PARAGRAPH SEQUENCE: The line number within the paragraph for this record.

Columns Comments for GUBPARA_TEXT_VAR (# 3)

Source Code Comments

TEXT/VARIABLE: A line of text, variable name, or formatting command within the paragraph.

Columns Comments for GUBPARA_ACTIVITY_DATE (# 4)

Source Code Comments

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

Table GUBPPRF

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
GUBPPRF_FORMAT	VARCHAR2(1)	No	*
GUBPPRF_VALUE	VARCHAR2(1)	No
GUBPPRF_SELF_NOTIFY_TYPE_IND	VARCHAR2(1)	No
GUBPPRF_ADMIN_NOTIFY_TYPE_IND	VARCHAR2(1)	No
GUBPPRF_PRE_EXPIRE_IND	VARCHAR2(1)	No
GUBPPRF_USER_ID	VARCHAR2(30)	No
GUBPPRF_ACTIVITY_DATE	DATE	No
GUBPPRF_APPLICATION	VARCHAR2(30)	Yes	*
GUBPPRF_LETR_CODE_LETTER	VARCHAR2(15)	Yes	*
GUBPPRF_LETR_CODE_EMAIL	VARCHAR2(15)	Yes	*
GUBPPRF_LENGTH_LAST_NAME	NUMBER(2,0)	Yes
GUBPPRF_MIN_LENGTH	NUMBER(2,0)	No
GUBPPRF_MAX_LENGTH	NUMBER(2,0)	No
GUBPPRF_NO_OF_QSTNS	NUMBER(2,0)	No
GUBPPRF_NUM_IND	VARCHAR2(1)	No
GUBPPRF_CHAR_IND	VARCHAR2(1)	No
GUBPPRF_REUSE_DAYS	NUMBER(3,0)	No
GUBPPRF_QSTN_MIN_LENGTH	NUMBER(2,0)	Yes
GUBPPRF_ANSR_MIN_LENGTH	NUMBER(2,0)	Yes
GUBPPRF_EDITQSTN_IND	VARCHAR2(1)	No
GUBPPRF_SELF_LETR_CODE_LETTER	VARCHAR2(15)	Yes
GUBPPRF_SELF_LETR_CODE_EMAIL	VARCHAR2(15)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GUBPPRF_APPLICATION	GLBAPPL_APPLICATION	GLBAPPL
GUBPPRF_LETR_CODE_LETTER	GTVLETR_CODE	GTVLETR
GUBPPRF_LETR_CODE_EMAIL	GTVLETR_CODE	GTVLETR
GUBPPRF_FORMAT	GORSDAV_PK_PARENTTAB	GORSDAV

Index

No Result

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GUBPPRF_ADD	SQL View	S10B80.BANINST1	Use (select)
GUBPPRF_ADS	SQL View	S10B80.BANINST1	Use (select)
GUBPPRF_REC	Oracle Package Variable	S10B80.WTAILOR.TWBKLIBS	Rely On
C_GUBPPRF	Oracle Package Cursor	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS_STRINGS	Use (select)
GETGUBPPRFC	Oracle Package Cursor	S10B80.BANINST1.BWAKALOG	Use (select)Rely On
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.GOKTPTY	Rely On
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.GOKTPTY	Use (select)
P_PIN_CHANGED_NOTIFICATION	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
UT_GB_THIRD_PARTY_ACCESSC_API	Oracle Package Procedure	S10B80.BANINST1.UT_GB_THIRD_PARTY_ACCESS	Use (update)
UT_GB_THIRD_PARTY_ACCESSU_API	Oracle Package Procedure	S10B80.BANINST1.UT_GB_THIRD_PARTY_ACCESS	Use (update)
GUBPPRF_REC	Oracle Package Variable	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS_STRINGS	Rely On
GUBPPRF_REC	Oracle Package Variable	S10B80.BANINST1.BWAKALOG	Rely On
GUBPPRFC	Oracle Package Cursor	S10B80.BANINST1.GUKLIBS	Use (select)Rely On
P_DISPSECURITYQUESTION	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_DISPSECURITYQUESTION	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)Rely On
P_INSERT_GOBTPAC	Oracle Package Procedure	S10B80.BANINST1.GOKTPTY	Rely On
P_INSERT_GOBTPAC	Oracle Package Procedure	S10B80.BANINST1.GOKTPTY	Use (select)
P_PIN_CHANGED_NOTIFICATION	Oracle Package Procedure	S10B80.BANINST1.GOKMAIL	Rely On
P_PROCSECURITYANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_PROCSECURITYANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)Rely On
P_VALIDATE	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS_RULES	Rely On
P_VALIDATEQUESTIONANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Rely On
P_VALIDATEQUESTIONANSWER	Oracle Package Procedure	S10B80.WTAILOR.TWBKWBIS	Use (select)Rely On
P_VALIDATE_PINRULES	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS_RULES	Rely On
F_GENERATE_EXTERNAL_USER	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Use (select)
F_PINLENGTH	Oracle Package Function	S10B80.WTAILOR.TWBKGLIB	Use (select)
F_PINLENGTH	Oracle Package Function	S10B80.BANINST1.GOKLIBS	Use (select)
F_PINLENGTH_VALIDATE	Oracle Package Function	S10B80.WTAILOR.TWBKGLIB	Rely On
F_PINLENGTH_VALIDATE	Oracle Package Function	S10B80.WTAILOR.TWBKGLIB	Use (select)
F_PINREUSED	Oracle Package Function	S10B80.BANINST1.GOKLIBS	Use (select)
F_RESET_PIN	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Rely On
F_RESET_PIN	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Use (select)
F_VALIDATE_PIN	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Rely On
F_VALIDATE_PIN	Oracle Package Function	S10B80.BANINST1.GOKTPTY	Use (select)
TWBKLIBS	Oracle Package	S10B80.WTAILOR	Use (select)
GUBPPRF	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GLBAPPL	SQL Table	S10B80.GENERAL	Refer (no action)
GORSDAV	SQL Table	S10B80.GENERAL	Join
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GUBPPRF

Object Dates

Creation Date	Analysis Date
04/02/2008 20:28:50:000	04/02/2008 21:17:52:000

Source Code Comments

Enterprise Pin Preference table.

Columns Comments for GUBPPRF_FORMAT (# 1)

Source Code Comments

PIN RESET FORMAT: N = Numeric, A = Alphanumeric.

Columns Comments for GUBPPRF_VALUE (# 2)

Source Code Comments

PIN RESET VALUE: B = Birth date, R = Random value.

Columns Comments for GUBPPRF_SELF_NOTIFY_TYPE_IND (# 3)

Source Code Comments

PIN USER INSERT/UPDATE NOTIFICATION CONTROL: E = Create Email, L = Create Letter, B = Create Both Email and Letter, N = No Notification.

Columns Comments for GUBPPRF_ADMIN_NOTIFY_TYPE_IND (# 4)

Source Code Comments

PIN ADMINISTRATOR INSERT/UPDATE NOTIFICATION CONTROL: E = Create Email, L = Create Letter, B = Create Both Email and Letter, N = No Notification.

Columns Comments for GUBPPRF_PRE_EXPIRE_IND (# 5)

Source Code Comments

PRE-EXPIRE PIN INDICATOR: Y = Pre-expire PINs when created automatically or in batch, N = Do not pre-expire PINs.

Columns Comments for GUBPPRF_USER_ID (# 6)

Source Code Comments

USER ID: The USER ID which changed this record.

Columns Comments for GUBPPRF_ACTIVITY_DATE (# 7)

Source Code Comments

The date on which the row was added or modified.

Columns Comments for GUBPPRF_APPLICATION (# 8)

Source Code Comments

APPLICATION CODE: Letter Generation Application code. (From GLBAPPL)

Columns Comments for GUBPPRF_LETR_CODE_LETTER (# 9)

Source Code Comments

LETTER CODE: The pin reset letter generation code for the letter notification. (From GTVLETR)

Columns Comments for GUBPPRF_LETR_CODE_EMAIL (# 10)

Source Code Comments

LETTER CODE: The pin reset letter generation code for the email notification. (From GTVLETR)

Columns Comments for GUBPPRF_LENGTH_LAST_NAME (# 11)

Source Code Comments

LENGTH OF LAST NAME: Length used when generating the GOBTPAC_EXTERNAL_USER value. The value of 7 is the preexisting (before 7.4) behavior.

Columns Comments for GUBPPRF_MIN_LENGTH (# 12)

Source Code Comments

MIN_LENGTH: Minimum length required for PIN.

Columns Comments for GUBPPRF_MAX_LENGTH (# 13)

Source Code Comments

MAX_LENGTH: Maximum length required for PIN.

Columns Comments for GUBPPRF_NO_OF_QSTNS (# 14)

Source Code Comments

NO_OF_QSTNS: Number of questions required to be answered before PIN reset is allowed.

Columns Comments for GUBPPRF_NUM_IND (# 15)

Source Code Comments

NUM_IND: Indicator requires numeric value to be present.

Columns Comments for GUBPPRF_CHAR_IND (# 16)

Source Code Comments

CHAR_IND: Indicator requires character value to be present.

Columns Comments for GUBPPRF_REUSE_DAYS (# 17)

Source Code Comments

REUSE_DAYS: Number of days required to be checked for password reuse.

Columns Comments for GUBPPRF_QSTN_MIN_LENGTH (# 18)

Source Code Comments

QSTN_MIN_LENGTH: Minimum length required for question.

Columns Comments for GUBPPRF_ANSR_MIN_LENGTH (# 19)

Source Code Comments

ANSR_MIN_LENGTH: Minimum length required for answer.

Columns Comments for GUBPPRF_EDITQSTN_IND (# 20)

Source Code Comments

EDITQSTN_IND: This indicates whether question can be edited or not.

Columns Comments for GUBPPRF_SELF_LETR_CODE_LETTER (# 21)

Source Code Comments

SELF_LETR_CODE_LETTER: Self Letter code to be used for letter generation.

Columns Comments for GUBPPRF_SELF_LETR_CODE_EMAIL (# 22)

Source Code Comments

SELF_LETR_CODE_EMAIL: Self EMail code to be used for letter generation.

Table GURMAIL

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	FK
GURMAIL_PIDM	NUMBER(8,0)	No
GURMAIL_SYSTEM_IND	VARCHAR2(2)	No
GURMAIL_TERM_CODE	VARCHAR2(6)	Yes	*
GURMAIL_LETR_CODE	VARCHAR2(15)	Yes	*
GURMAIL_MODULE_CODE	VARCHAR2(1)	Yes	*
GURMAIL_ADMIN_IDENTIFIER	NUMBER(2,0)	Yes
GURMAIL_MATL_CODE_MOD	VARCHAR2(4)	Yes	*
GURMAIL_DATE_INIT	DATE	Yes
GURMAIL_DATE_PRINTED	DATE	Yes
GURMAIL_USER	VARCHAR2(30)	Yes
GURMAIL_WAIT_DAYS	NUMBER(3,0)	Yes
GURMAIL_PUB_GEN	VARCHAR2(1)	Yes
GURMAIL_INIT_CODE	VARCHAR2(4)	Yes	*
GURMAIL_ORIG_IND	VARCHAR2(1)	Yes
GURMAIL_ACTIVITY_DATE	DATE	No
GURMAIL_AIDY_CODE	VARCHAR2(4)	Yes
GURMAIL_CPLN_CODE	VARCHAR2(4)	Yes
GURMAIL_QTY	NUMBER(3,0)	Yes
GURMAIL_MISC_VC2	VARCHAR2(15)	Yes
GURMAIL_MISC_DATE	DATE	Yes
GURMAIL_MISC_NUM	NUMBER(0,0)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GURMAIL_LETR_CODE	GTVLETR_CODE	GTVLETR
GURMAIL_INIT_CODE	STVINIT_CODE	STVINIT
GURMAIL_MATL_CODE_MOD	STVMATL_CODE	STVMATL
GURMAIL_TERM_CODE	STVTERM_CODE	STVTERM
GURMAIL_LETR_CODE	SORELTL_LETR_CODE	SORELTL
GURMAIL_MODULE_CODE	SORELTL_ELMT_CODE	SORELTL

Index

Index Name	Index Type	Column Name
GURMAIL_KEY_INDEX		GURMAIL_PIDM
GURMAIL_KEY_INDEX		GURMAIL_SYSTEM_IND
GURMAIL_KEY_INDEX		GURMAIL_TERM_CODE
GURMAIL_SYS_IND_INDEX		GURMAIL_SYSTEM_IND
GURMAIL_SYS_IND_INDEX		GURMAIL_PUB_GEN
GURMAIL_SYS_IND_INDEX		GURMAIL_LETR_CODE

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
ROVPEND	SQL View	S10B80.BANINST1	Use (select)
F_GURMAIL_LETR_CODE	SQL Function	S10B80.BANINST1	Use (select)
F_GURMAIL_ROWID	SQL Function	S10B80.BANINST1	Use (select)
F_STUDENT_CHECK_FOR_MORE	SQL Function	S10B80.BANINST1	Use (select)
GT_GURMAIL	Oracle Package Type	S10B80.BANINST1.SOKSELS	Rely On
CHK_GURMAIL_DUPS_BY_AIDY_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Rely On
CHK_GURMAIL_DUPS_BY_AIDY_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
CHK_GURMAIL_DUPS_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
CHK_GURMAIL_PRINTED_BY_AIDY_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Rely On
CHK_GURMAIL_PRINTED_BY_AIDY_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
CHK_GURMAIL_PRINTED_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
GURMAIL_C	Oracle Package Cursor	S10B80.BANINST1.SOKSELS	Rely On
GURMAIL_C	Oracle Package Cursor	S10B80.BANINST1.SOKSELS	Use (select)
P_CREATE_APPL	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (Insert)
P_CREATE_RECRUIT	Oracle Package Procedure	S10B80.BANINST1.TS_STUDENT_OAPERF	Use (Insert)
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.GOKTPTY	Use (Insert)
P_INSERT_GURMAIL_REC	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
P_MATERIAL_MATCHING	Oracle Package Procedure	S10B80.BANINST1.SOKCPLN	Use (Insert,select)
P_PIN_CHANGED_NOTIFICATION	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
P_PIN_CHANGED_NOTIFICATION	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Use (select)
P_UPDATE_GURMAIL_REC	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Rely On
P_UPDATE_GURMAIL_REC	Oracle Package Procedure	S10B80.BANINST1.GB_THIRD_PARTY_ACCESS	Use (select)Rely On
P_ADD_LETTER	Oracle Package Procedure	S10B80.BANINST1.ROKSAPR	Use (Insert)
P_CREATE	Oracle Package Procedure	S10B80.BANINST1.RP_APPLICANT_STATUS	Use (Insert,select)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.SB_ADMISSIONSAPPLICATION	Use (delete)
P_DELETE	Oracle Package Procedure	S10B80.BANINST1.DML_GURMAIL	Use (delete)
P_DISPLAY_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Rely On
P_DISPLAY_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.RPK_DEBS_DISPLAYS	Use (select)Rely On
P_INSERT	Oracle Package Procedure	S10B80.BANINST1.DML_GURMAIL	Use (Insert)Rely On
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Rely On
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.SRKPREL	Use (Insert,select)
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Rely On
P_INSERT_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Use (Insert,select)
P_LOAD_GURMAIL	Oracle Package Procedure	S10B80.BANINST1.SAKL175	Use (Insert,select)
P_PIN_CHANGED_NOTIFICATION	Oracle Package Procedure	S10B80.BANINST1.GOKMAIL	Rely On
P_PIN_CHANGED_NOTIFICATION	Oracle Package Procedure	S10B80.BANINST1.GOKMAIL	Use (Insert,update,select)
P_PROCESS_MASS_ENTRY	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Rely On
P_SEND_EMAIL	Oracle Package Procedure	S10B80.BANINST1.SFKWLAT	Use (select)
P_UPDATE	Oracle Package Procedure	S10B80.BANINST1.DML_GURMAIL	Rely On
P_VALIDATE_GLBLSEL	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_SB_ADMISSIONSAPPLICATION	Use (Insert)
F_CHK_GURMAIL_DUPS_BY_AIDY	Oracle Package Function	S10B80.BANINST1.ROKSAPR	Rely On
F_GURMAIL_VALUE	Oracle Package Function	S10B80.BANINST1.SOKSELS	Rely On
GURMAIL	Oracle Synonym	S10B80.PUBLIC	Rely On

Calling objects (non escalated - dynamic)

No Calling objects (non escalated - dynamic)

Called objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GURMAIL_KEY_INDEX	SQL Index	S10B80.GENERAL	Rely On
GURMAIL_SYS_IND_INDEX	SQL Index	S10B80.GENERAL	Rely On
GTVLETR	SQL Table	S10B80.GENERAL	Refer (no action)
SORELTL	SQL Table	S10B80.SATURN	Join
STVINIT	SQL Table	S10B80.SATURN	Refer (no action)
STVMATL	SQL Table	S10B80.SATURN	Refer (no action)
STVTERM	SQL Table	S10B80.SATURN	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GURMAIL

Object Dates

Creation Date	Analysis Date
04/02/2008 20:30:56:000	04/02/2008 21:17:54:000

Source Code Comments

Mail Table

Columns Comments for GURMAIL_PIDM (# 1)

Source Code Comments

Internal system identification number of person.

Columns Comments for GURMAIL_SYSTEM_IND (# 2)

Source Code Comments

SYSTEM INDICATOR: Indicates which BANNER system this record pertains to. Values are from the GTVSYSI form.

Columns Comments for GURMAIL_TERM_CODE (# 3)

Source Code Comments

TERM: The term code associated with this record (BANNER Student only).

Columns Comments for GURMAIL_LETR_CODE (# 4)

Source Code Comments

LETTER CODE: The letter associated with this record. (From GTVLETR)

Columns Comments for GURMAIL_MODULE_CODE (# 5)

Source Code Comments

MODULE CODE: The module associated with this letter.

Columns Comments for GURMAIL_ADMIN_IDENTIFIER (# 6)

Source Code Comments

ADMIN IDENTIFIER: Application Number (BANNER Student only).

Columns Comments for GURMAIL_MATL_CODE_MOD (# 7)

Source Code Comments

MATERIALS: The Materials code (from STVMATL).

Columns Comments for GURMAIL_DATE_INIT (# 8)

Source Code Comments

DATE INITIATED: Date the letter was initiated.

Columns Comments for GURMAIL_DATE_PRINTED (# 9)

Source Code Comments

DATE PRINTED: Date the letter was printed.

Columns Comments for GURMAIL_USER (# 10)

Source Code Comments

USER: The USERID which initiated this letter.

Columns Comments for GURMAIL_WAIT_DAYS (# 11)

Source Code Comments

WAIT DAYS: The number of days between initiating and printing the letter.

Columns Comments for GURMAIL_PUB_GEN (# 12)

Source Code Comments

PUBLISHED/GENERATED: Code indicating published or generated materials (P/G).

Columns Comments for GURMAIL_INIT_CODE (# 13)

Source Code Comments

INITIALS: The initials of the person signing the letter. (From STVINIT)

Columns Comments for GURMAIL_ORIG_IND (# 14)

Source Code Comments

ORIGIN: S = System-generated record; blank = entered on Mail form.

Columns Comments for GURMAIL_ACTIVITY_DATE (# 15)

Source Code Comments

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

Columns Comments for GURMAIL_AIDY_CODE (# 16)

Source Code Comments

AID YEAR CODE: The aid year to be associated with information in this record. EXAMPLES: 9091, 9192, 9293, etc.

Columns Comments for GURMAIL_CPLN_CODE (# 17)

Source Code Comments

Communication plan used to add the material or letter.

Columns Comments for GURMAIL_QTY (# 18)

Source Code Comments

Quantity of materials to be sent.

Link between GUBPARA and GUBLETR

Join Information

Objects list
schema-view : S10B80.BANINST1.GUVLETR

Link List

Link Type	Link	Project
Join	Link Between GUBPARA and GUBLETR	GENERAL

List of Real links

Link type	Between	And
Join	GUBPARA	GUBLETR

Link between GTVLETR and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GTVLETR and GTVLETR (FK1_GTVLETR_INV_GTVLETR_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GTVLETR	GTVLETR_LETR_CODE_ALT	GTVLETR_CODE	GTVLETR	(0,1)-(0,n)

Link between GLRCALC and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GLRCALC and GTVLETR (FK1_GLRCALC_INV_GTVLETR_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GLRCALC	GLRCALC_LETR_CODE	GTVLETR_CODE	GTVLETR	(1,1)-(0,n)

Link between GLRCALC and GLBVRBL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GLRCALC and GLBVRBL (FK1_GLRCALC_INV_GLBVRBL_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GLRCALC	GLRCALC_APPLICATION	GLBVRBL_APPLICATION	GLBVRBL	(1,1)-(0,n)
GLRCALC	GLRCALC_VARIABLE	GLBVRBL_VARIABLE	GLBVRBL	(1,1)-(0,n)

Link between GLRVFRM and GLBVRBL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GLRVFRM and GLBVRBL (FK1_GLRVFRM_INV_GLBVRBL_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GLRVFRM	GLRVFRM_APPLICATION	GLBVRBL_APPLICATION	GLBVRBL	(1,1)-(0,n)
GLRVFRM	GLRVFRM_VARIABLE	GLBVRBL_VARIABLE	GLBVRBL	(1,1)-(0,n)

Link between GUBLETR and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GUBLETR and GTVLETR (FK1_GUBLETR_INV_GTVLETR_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GUBLETR	GUBLETR_LETR_CODE	GTVLETR_CODE	GTVLETR	(1,1)-(0,n)

Link between GUBLETR and GTVPARA

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GUBLETR and GTVPARA (FK1_GUBLETR_INV_GTVPARA_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GUBLETR	GUBLETR_PARA_CODE	GTVPARA_CODE	GTVPARA	(1,1)-(0,n)

Link between GUBPPRF and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GUBPPRF and GTVLETR (FK1_GUBPPRF_INV_GTVLETR_CODE)	GENERAL
Refer (no action)	Link Informative Foreign Key Between GUBPPRF and GTVLETR (FK2_GUBPPRF_INV_GTVLETR_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GUBPPRF	GUBPPRF_LETR_CODE_LETTER	GTVLETR_CODE	GTVLETR	(0,1)-(0,n)

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GUBPPRF	GUBPPRF_LETR_CODE_EMAIL	GTVLETR_CODE	GTVLETR	(0,1)-(0,n)

Link between GUBPARA and GTVPARA

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GUBPARA and GTVPARA (FK1_GUBPARA_INV_GTVPARA_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GUBPARA	GUBPARA_PARA_CODE	GTVPARA_CODE	GTVPARA	(1,1)-(0,n)

Link between GURMAIL and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GURMAIL and GTVLETR (FK1_GURMAIL_INV_GTVLETR_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GURMAIL	GURMAIL_LETR_CODE	GTVLETR_CODE	GTVLETR	(0,1)-(0,n)

Link between GLRVRBL and GLRVFRM

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GLRVRBL and GLRVFRM (FK1_GLRVRBL_INV_GLRVFRM_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GLRVRBL	GLRVRBL_APPLICATION	GLRVFRM_APPLICATION	GLRVFRM	(1,1)-(0,n)
GLRVRBL	GLRVRBL_VARIABLE	GLRVFRM_VARIABLE	GLRVFRM	(1,1)-(0,n)
GLRVRBL	GLRVRBL_SEQ_NO	GLRVFRM_SEQ_NO	GLRVFRM	(1,1)-(0,n)

Link between GLBSLCT and GLBAPPL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GLBSLCT and GLBAPPL (FK1_GLBSLCT_INV_GLBAPPL_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GLBSLCT	GLBSLCT_APPLICATION	GLBAPPL_APPLICATION	GLBAPPL	(1,1)-(0,n)

Link between GLBVRBL and GLBAPPL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GLBVRBL and GLBAPPL (FK1_GLBVRBL_INV_GLBAPPL_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GLBVRBL	GLBVRBL_APPLICATION	GLBAPPL_APPLICATION	GLBAPPL	(1,1)-(0,n)

Link between GLRAPPL and GLBAPPL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GLRAPPL and GLBAPPL (FK1_GLRAPPL_INV_GLBAPPL_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GLRAPPL	GLRAPPL_APPLICATION	GLBAPPL_APPLICATION	GLBAPPL	(1,1)-(0,n)

Link between GLRCMPL and GLBAPPL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GLRCMPL and GLBAPPL (FK1_GLRCMPL_INV_GLBAPPL_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GLRCMPL	GLRCMPL_APPLICATION	GLBAPPL_APPLICATION	GLBAPPL	(1,1)-(0,n)

Link between GUBPPRF and GLBAPPL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GUBPPRF and GLBAPPL (FK1_GUBPPRF_INV_GLBAPPL_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GUBPPRF	GUBPPRF_APPLICATION	GLBAPPL_APPLICATION	GLBAPPL	(0,1)-(0,n)

Link between GLBAPPL and GTVSYSI

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GLBAPPL and GTVSYSI (FK1_GLBAPPL_INV_GTVSYSI_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GLBAPPL	GLBAPPL_SYSI_CODE	GTVSYSI_CODE	GTVSYSI	(1,1)-(0,n)

Link between GLROBJT and GLBOBJT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GLROBJT and GLBOBJT (FK1_GLROBJT_INV_GLBOBJT_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GLROBJT	GLROBJT_OBJECT	GLBOBJT_OBJECT	GLBOBJT	(1,1)-(0,n)

Link between GLRCOLR and GLBVRBL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GLRCOLR and GLBVRBL (FK1_GLRCOLR_INV_GLBVRBL_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GLRCOLR	GLRCOLR_APPLICATION	GLBVRBL_APPLICATION	GLBVRBL	(1,1)-(0,n)
GLRCOLR	GLRCOLR_VARIABLE	GLBVRBL_VARIABLE	GLBVRBL	(1,1)-(0,n)

Link between GLRCOLR and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GLRCOLR and GTVLETR (FK1_GLRCOLR_INV_GTVLETR_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GLRCOLR	GLRCOLR_LETR_CODE	GTVLETR_CODE	GTVLETR	(1,1)-(0,n)

Link between GLRORDR and GLBVRBL

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GLRORDR and GLBVRBL (FK1_GLRORDR_INV_GLBVRBL_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GLRORDR	GLRORDR_APPLICATION	GLBVRBL_APPLICATION	GLBVRBL	(1,1)-(0,n)
GLRORDR	GLRORDR_VARIABLE	GLBVRBL_VARIABLE	GLBVRBL	(1,1)-(0,n)

Link between GLRORDR and GTVLETR

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GLRORDR and GTVLETR (FK1_GLRORDR_INV_GTVLETR_CODE)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GLRORDR	GLRORDR_LETR_CODE	GTVLETR_CODE	GTVLETR	(1,1)-(0,n)