Model Population_Selection

Model Label :

List of Objects

Object Name	Object Type	Layer Name
GLBAPPL	SQL Table	Default
GLBEXTR	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
GLRSFRM	SQL Table	Default
GLRSLCT	SQL Table	Default
GLRVFRM	SQL Table	Default
GLVEXTR	SQL View	Default
GLVRSLT	SQL View	Default
GLVSLCT	SQL View	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 GLBEXTR

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GLBEXTR_APPLICATION	VARCHAR2(30)	No	*	*
GLBEXTR_SELECTION	VARCHAR2(30)	No	*	*
GLBEXTR_CREATOR_ID	VARCHAR2(30)	No	*	*
GLBEXTR_USER_ID	VARCHAR2(30)	No	*
GLBEXTR_KEY	VARCHAR2(80)	No	*
GLBEXTR_ACTIVITY_DATE	DATE	No
GLBEXTR_SYS_IND	VARCHAR2(1)	No
GLBEXTR_SLCT_IND	VARCHAR2(1)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GLBEXTR_APPLICATION	GLBSLCT_APPLICATION	GLBSLCT
GLBEXTR_SELECTION	GLBSLCT_SELECTION	GLBSLCT
GLBEXTR_CREATOR_ID	GLBSLCT_CREATOR_ID	GLBSLCT

Index

Index Name	Index Type	Column Name
PK_GLBEXTR	Unique	GLBEXTR_APPLICATION
PK_GLBEXTR	Unique	GLBEXTR_SELECTION
PK_GLBEXTR	Unique	GLBEXTR_CREATOR_ID
PK_GLBEXTR	Unique	GLBEXTR_USER_ID
PK_GLBEXTR	Unique	GLBEXTR_KEY

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
SPRIDEN	SQL Table	S10B80.SATURN	Join
APVBRWS	SQL View	S10B80.BANINST1	Use (select)
GLBEXTR_ADD	SQL View	S10B80.BANINST1	Use (select)
GLBEXTR_ADS	SQL View	S10B80.BANINST1	Use (select)
GLVEXTA	SQL View	S10B80.BANINST1	Use (select)
GLVEXTR	SQL View	S10B80.BANINST1	Use (select)
GLVRSLT	SQL View	S10B80.BANINST1	Use (select)
APPLICATION_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKPSRC	Rely On
CREATOR_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKPSRC	Rely On
POP_SEL_USER_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKPSRC	Rely On
SELECTION_TYPE	Oracle Package Type	S10B80.BANINST1.BWDKPSRC	Rely On
GLBEXTR_REC	Oracle Package Variable	S10B80.BANINST1.BWDKPSRC	Rely On
APPLICATIONVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)
CREATORVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)
GET_GLBEXTR_PIDM_C	Oracle Package Cursor	S10B80.BANINST1.ROKSAPR	Use (select)
GLBEXTRVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)Rely On
POPSELUSERVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)
SELECTIONVIEWC	Oracle Package Cursor	S10B80.BANINST1.BWDKPSRC	Use (select)
P_BUILD_POP_SEL_IDS_RESULTS	Oracle Package Procedure	S10B80.BANINST1.BWDKPSRC	Use (select)
GV_APP_ID	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_CREATOR_ID	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_SELECTION_ID	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
GV_USER_ID	Oracle Package Variable	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Rely On
F_BUILD_STUDENT_COLLECTION	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_BUILD_STUDENT_COLLECTION	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Use (select)
P_POPULATE_SEARCH	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Rely On
P_POPULATE_SEARCH	Oracle Package Procedure	S10B80.BANINST1.SOKMAUD	Use (select)
P_VALIDATE_GLBLSEL	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Use (select)
UT_SETUP	Oracle Package Procedure	S10B80.BANINST1.UT_GP_INTERNATIONAL_STUDENT	Use (Insert)
F_GET_STUDENT_DATA	Oracle Package Function	S10B80.BANINST1.GP_INTERNATIONAL_STUDENT	Rely On
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE05	Rely On
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE05	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE06	Rely On
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE06	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE07	Rely On
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE07	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE08	Rely On
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE08	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE09	Rely On
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCE09	Use (select)
F_SELECT_STUDENTS	Oracle Package Function	S10B80.BANINST1.REKCEXX	Rely On
F_VALID_POPULATION_SELECTION	Oracle Package Function	S10B80.BANINST1.SOKPVAL	Use (select)
F_VALID_POPULATION_SELECTION4	Oracle Package Function	S10B80.BANINST1.GOKPVAL	Use (select)
F_VALID_POPULATION_SELECTION4	Oracle Package Function	S10B80.BANINST1.SOKPVAL	Use (select)
F_VALID_POPULATION_SELECTION4	Oracle Package Function	S10B80.BANINST1.AOKPVAL	Use (select)
F_VALID_POPULATION_SELECTION4	Oracle Package Function	S10B80.BANINST1.ICOKPVAL	Use (select)
GLBEXTR	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_GLBEXTR	SQL Index	S10B80.GENERAL	Rely On
GLBSLCT	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GLBEXTR

Object Dates

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

Source Code Comments

Population Selection Extract Base Table

Columns Comments for GLBEXTR_APPLICATION (# 1)

Source Code Comments

APPLICATION: The name of the Application that the Population Selection Identifier belongs to.

Columns Comments for GLBEXTR_SELECTION (# 2)

Source Code Comments

SELECTION: The name of the Population Selection Identifier that was used to create this Report Extract record.

Columns Comments for GLBEXTR_CREATOR_ID (# 3)

Source Code Comments

CREATOR ID: The ID of the creator of this Population Selection Identifier.

Columns Comments for GLBEXTR_USER_ID (# 4)

Source Code Comments

USER ID: The logon ID of the user who entered or last updated the record in this table.

Columns Comments for GLBEXTR_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 GLBEXTR_SYS_IND (# 7)

Source Code Comments

SYSTEM INDICATOR: Indicates source of the record. Values are (S)ystem-generated by the GLBDATA process; (M)anually entered on the GLAEXTR form.

Columns Comments for GLBEXTR_SLCT_IND (# 8)

Source Code Comments

SELECT INDICATOR: This field is used by the Batch Group Process and indicates whether the student has been processed already.

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 GLRSFRM

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GLRSFRM_APPLICATION	VARCHAR2(30)	No	*	*
GLRSFRM_SELECTION	VARCHAR2(30)	No	*	*
GLRSFRM_CREATOR_ID	VARCHAR2(30)	No	*	*
GLRSFRM_ACTIVITY_DATE	DATE	No
GLRSFRM_SELECT_CLAUSE	VARCHAR2(240)	No
GLRSFRM_FROM_CLAUSE	VARCHAR2(240)	No
GLRSFRM_ORDER_BY	VARCHAR2(240)	Yes
GLRSFRM_GROUP_BY	VARCHAR2(240)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GLRSFRM_APPLICATION	GLBSLCT_APPLICATION	GLBSLCT
GLRSFRM_SELECTION	GLBSLCT_SELECTION	GLBSLCT
GLRSFRM_CREATOR_ID	GLBSLCT_CREATOR_ID	GLBSLCT

Index

Index Name	Index Type	Column Name
PK_GLRSFRM	Unique	GLRSFRM_APPLICATION
PK_GLRSFRM	Unique	GLRSFRM_SELECTION
PK_GLRSFRM	Unique	GLRSFRM_CREATOR_ID

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
P_VALIDATE_GLBDATA	Oracle Package Procedure	S10B80.BANINST1.GOKPVAL	Use (select)
GLRSFRM	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_GLRSFRM	SQL Index	S10B80.GENERAL	Rely On
GLBSLCT	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GLRSFRM

Object Dates

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

Source Code Comments

Population Selection Select Table

Columns Comments for GLRSFRM_APPLICATION (# 1)

Source Code Comments

APPLICATION: Application code which with the selection and creator id uniquely identifies this record.

Columns Comments for GLRSFRM_SELECTION (# 2)

Source Code Comments

SELECTION: Population Selection code which with the application and creator id uniquely identifies this record.

Columns Comments for GLRSFRM_CREATOR_ID (# 3)

Source Code Comments

CREATOR_ID: User id of the creator of this population selection which with the application and selection uniquely identifies this record.

Columns Comments for GLRSFRM_ACTIVITY_DATE (# 4)

Source Code Comments

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

Columns Comments for GLRSFRM_SELECT_CLAUSE (# 5)

Source Code Comments

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

Columns Comments for GLRSFRM_FROM_CLAUSE (# 6)

Source Code Comments

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

Columns Comments for GLRSFRM_ORDER_BY (# 7)

Source Code Comments

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

Columns Comments for GLRSFRM_GROUP_BY (# 8)

Source Code Comments

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

Table GLRSLCT

Server Name S10B80
Database Name GENERAL
Table Label

Table Columns information

Column Name	Column Type	Allow NULL	PK	FK
GLRSLCT_APPLICATION	VARCHAR2(30)	No	*	*
GLRSLCT_SELECTION	VARCHAR2(30)	No	*	*
GLRSLCT_CREATOR_ID	VARCHAR2(30)	No	*	*
GLRSLCT_KEY_NO	NUMBER(4,0)	No	*
GLRSLCT_LINE_NO	NUMBER(4,0)	No
GLRSLCT_ACTIVITY_DATE	DATE	No
GLRSLCT_DATA_ELEMENT	VARCHAR2(35)	No
GLRSLCT_OPERATOR	VARCHAR2(11)	No
GLRSLCT_VALUE	VARCHAR2(80)	Yes
GLRSLCT_OPEN_PAREN	VARCHAR2(3)	Yes
GLRSLCT_CLOSE_PAREN	VARCHAR2(3)	Yes
GLRSLCT_SEPARATOR	VARCHAR2(3)	Yes

Foreign Key information

Column name	is Foreign Key For Column	on Table
GLRSLCT_APPLICATION	GLBSLCT_APPLICATION	GLBSLCT
GLRSLCT_SELECTION	GLBSLCT_SELECTION	GLBSLCT
GLRSLCT_CREATOR_ID	GLBSLCT_CREATOR_ID	GLBSLCT

Index

Index Name	Index Type	Column Name
PK_GLRSLCT	Unique	GLRSLCT_APPLICATION
PK_GLRSLCT	Unique	GLRSLCT_SELECTION
PK_GLRSLCT	Unique	GLRSLCT_CREATOR_ID
PK_GLRSLCT	Unique	GLRSLCT_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_GLRSLCT	SQL Index	S10B80.GENERAL	Rely On
GLBSLCT	SQL Table	S10B80.GENERAL	Refer (no action)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.GENERAL.GLRSLCT

Object Dates

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

Source Code Comments

Population Selection Rules Table

Columns Comments for GLRSLCT_APPLICATION (# 1)

Source Code Comments

APPLICATION: Application code which with the selection, creator id and key number uniquely identifies this record.

Columns Comments for GLRSLCT_SELECTION (# 2)

Source Code Comments

SELECTION: Selection code which with the application, creator id and key number uniquely identifies this record.

Columns Comments for GLRSLCT_CREATOR_ID (# 3)

Source Code Comments

CREATOR_ID: User id of the creator which with the application, selection and key number uniquely identifies this record.

Columns Comments for GLRSLCT_KEY_NO (# 4)

Source Code Comments

KEY NUMBER: Key number which with the application, selection and creator id uniquely identifies this record.

Columns Comments for GLRSLCT_LINE_NO (# 5)

Source Code Comments

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

Columns Comments for GLRSLCT_ACTIVITY_DATE (# 6)

Source Code Comments

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

Columns Comments for GLRSLCT_DATA_ELEMENT (# 7)

Source Code Comments

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

Columns Comments for GLRSLCT_OPERATOR (# 8)

Source Code Comments

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

Columns Comments for GLRSLCT_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 GLRSLCT_OPEN_PAREN (# 10)

Source Code Comments

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

Columns Comments for GLRSLCT_CLOSE_PAREN (# 11)

Source Code Comments

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

Columns Comments for GLRSLCT_SEPARATOR (# 12)

Source Code Comments

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

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.

View GLVEXTR

Server Name S10B80
Database Name BANINST1
View Label

View Columns information

Column Name	Column Type	Allow NULL
GLVEXTR_APPLICATION	VARCHAR2(30)	No
GLVEXTR_SELECTION	VARCHAR2(30)	No
GLVEXTR_CREATOR_ID	VARCHAR2(30)	No
GLVEXTR_USER_ID	VARCHAR2(30)	No
GLVEXTR_KEY	VARCHAR2(80)	No
GLVEXTR_NAME	VARCHAR2(125)	Yes
GLVEXTR_ID	VARCHAR2(9)	No
GLVEXTR_SYS_IND	VARCHAR2(1)	No
GLVEXTR_ACTIVITY_DATE	DATE	No

Index

No Result

Calling objects (non escalated)

Object Name	Object Type	Parent Name	Link Type
GLVEXTR_REC	Oracle Package Variable	S10B80.BANINST1.BWGKSRVY	Rely On
GLVEXTRREADC	Oracle Package Cursor	S10B80.BANINST1.BWGKSRVY	Use (select)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
GLBEXTR	SQL Table	S10B80.GENERAL	Use (select)
SPRIDEN	SQL Table	S10B80.SATURN	Use (select)
DATE	Oracle Package Type	S10B80.SYS.STANDARD	Rely On
VARCHAR2	Oracle Package Type	S10B80.SYS.STANDARD	Rely On
GLBEXTR	Oracle Synonym	S10B80.PUBLIC	Use (select)
SPRIDEN	Oracle Synonym	S10B80.PUBLIC	Use (select)
DECODE	Oracle Package Function	S10B80.SYS.STANDARD	Call

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANINST1.GLVEXTR

Object Dates

Creation Date	Analysis Date
04/04/2008 21:04:28:000	04/04/2008 21:57:35:000

Number of code lines

Number of heading comment lines

Number of inner comment lines

View GLVRSLT

Server Name S10B80
Database Name BANINST1
View Label

View Columns information

Column Name	Column Type	Allow NULL
GLVRSLT_APPLICATION	VARCHAR2(30)	No
GLVRSLT_SELECTION	VARCHAR2(30)	No
GLVRSLT_CREATOR_ID	VARCHAR2(30)	No
GLVRSLT_USER_ID	VARCHAR2(30)	No
GLVRSLT_ROWS_SELECTED	NUMBER(0,0)	Yes

Index

No Result

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
GLBEXTR	SQL Table	S10B80.GENERAL	Use (select)
VARCHAR2	Oracle Package Type	S10B80.SYS.STANDARD	Rely On
GLBEXTR	Oracle Synonym	S10B80.PUBLIC	Use (select)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANINST1.GLVRSLT

Object Dates

Creation Date	Analysis Date
04/04/2008 21:11:38:000	04/04/2008 21:57:40:000

Number of code lines

Number of heading comment lines

Number of inner comment lines

View GLVSLCT

Server Name S10B80
Database Name BANINST1
View Label

View Columns information

Column Name	Column Type	Allow NULL
GLVSLCT_APPLICATION	VARCHAR2(30)	No
GLVSLCT_SELECTION	VARCHAR2(30)	No
GLVSLCT_CREATOR_ID	VARCHAR2(30)	No

Index

No Result

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
GLBSLCT	SQL Table	S10B80.GENERAL	Use (select)
VARCHAR2	Oracle Package Type	S10B80.SYS.STANDARD	Rely On
GLBSLCT	Oracle Synonym	S10B80.PUBLIC	Use (select)

Called objects (non escalated - dynamic)

No Called objects (non escalated - dynamic)

Object Full Name

S10B80.BANINST1.GLVSLCT

Object Dates

Creation Date	Analysis Date
04/04/2008 21:21:30:000	04/04/2008 21:57:49:000

Number of code lines

Number of heading comment lines

Number of inner comment lines

Columns Comments for GLVSLCT_APPLICATION (# 1)

Source Code Comments

Application Code.

Columns Comments for GLVSLCT_SELECTION (# 2)

Source Code Comments

Selection Identifier.

Columns Comments for GLVSLCT_CREATOR_ID (# 3)

Source Code Comments

User ID of the creator of this selection identifier.

Link between GLVEXTR and GLBEXTR

Link List

Link Type	Link	Project
Use (select)	Link Between GLVEXTR and GLBEXTR	BANINST1

List of Real links

Link type	Between	And
Use (select)	GLVEXTR	GLBEXTR

Link between GLVRSLT and GLBEXTR

Link List

Link Type	Link	Project
Use (select)	Link Between GLVRSLT and GLBEXTR	BANINST1

List of Real links

Link type	Between	And
Use (select)	GLVRSLT	GLBEXTR

Link between GLVSLCT and GLBSLCT

Link List

Link Type	Link	Project
Use (select)	Link Between GLVSLCT and GLBSLCT	BANINST1

List of Real links

Link type	Between	And
Use (select)	GLVSLCT	GLBSLCT

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 GLBEXTR and GLBSLCT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GLBEXTR and GLBSLCT (FK1_GLBEXTR_INV_GLBSLCT_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GLBEXTR	GLBEXTR_APPLICATION	GLBSLCT_APPLICATION	GLBSLCT	(1,1)-(0,n)
GLBEXTR	GLBEXTR_SELECTION	GLBSLCT_SELECTION	GLBSLCT	(1,1)-(0,n)
GLBEXTR	GLBEXTR_CREATOR_ID	GLBSLCT_CREATOR_ID	GLBSLCT	(1,1)-(0,n)

Link between GLRSLCT and GLBSLCT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GLRSLCT and GLBSLCT (FK1_GLRSLCT_INV_GLBSLCT_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GLRSLCT	GLRSLCT_APPLICATION	GLBSLCT_APPLICATION	GLBSLCT	(1,1)-(0,n)
GLRSLCT	GLRSLCT_SELECTION	GLBSLCT_SELECTION	GLBSLCT	(1,1)-(0,n)
GLRSLCT	GLRSLCT_CREATOR_ID	GLBSLCT_CREATOR_ID	GLBSLCT	(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 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 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 GLRSFRM and GLBSLCT

Link List

Link Type	Link	Project
Refer (no action)	Link Informative Foreign Key Between GLRSFRM and GLBSLCT (FK1_GLRSFRM_INV_GLBSLCT_KEY)	GENERAL

Foreign Key information

Table name	Table Column Name	Foreign Key Column Name	On Table	Cardinalities
GLRSFRM	GLRSFRM_APPLICATION	GLBSLCT_APPLICATION	GLBSLCT	(1,1)-(0,1)
GLRSFRM	GLRSFRM_SELECTION	GLBSLCT_SELECTION	GLBSLCT	(1,1)-(0,1)
GLRSFRM	GLRSFRM_CREATOR_ID	GLBSLCT_CREATOR_ID	GLBSLCT	(1,1)-(0,1)