Model Population Selection
Model Label : Banner General Population Selection
Path : BANNER DEV/General/ERD/Population Selection
List of Objects
Comments
Model View
''
Table GLBAPPL
Schema Name GENERAL
Label GLBAPPL
Server name MALDEV8_B60
Creation Date 02/07/2003 15:35:41:000
Table Columns information
Foreign Key information
Index
| Index Name
|
Index Type
|
Column Name
|
| PK_GLBAPPL
|
Unique
|
GLBAPPL_APPLICATION
|
Comments
Source Code Comments
Letter Generation Application Table
Columns Comments for GLBAPPL_APPLICATION (1)
Source Code Comments
APPLICATION: Application code which uniquely identifies this record.
Columns Comments for GLBAPPL_DESC (2)
Source Code Comments
DESCRIPTION: Description of this application.
Columns Comments for GLBAPPL_SYSI_CODE (3)
Source Code Comments
SYSTEM INDICATOR: System indicator which identifies which system this application is associated.
Columns Comments for GLBAPPL_ACTIVITY_DATE (4)
Source Code Comments
ACTIVITY DATE: Date that record was created or last updated.
Table GLBEXTR
Schema Name GENERAL
Label GLBEXTR
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:25:000
Table Columns information
Foreign Key information
Index
Comments
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
Schema Name GENERAL
Label GLBOBJT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:25:000
Table Columns information
Foreign Key information
No Foreign Key
Index
| Index Name
|
Index Type
|
Column Name
|
| PK_GLBOBJT
|
Unique
|
GLBOBJT_OBJECT
|
Comments
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
Schema Name GENERAL
Label GLBSLCT
Server name MALDEV8_B60
Creation Date 02/07/2003 15:35:56:000
Table Columns information
Foreign Key information
Index
Comments
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
Schema Name GENERAL
Label GLBVRBL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:25:000
Table Columns information
Foreign Key information
Index
| Index Name
|
Index Type
|
Column Name
|
| PK_GLBVRBL
|
Unique
|
GLBVRBL_APPLICATION
|
| PK_GLBVRBL
|
Unique
|
GLBVRBL_VARIABLE
|
Comments
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
Schema Name GENERAL
Label GLRAPPL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:25:000
Table Columns information
Foreign Key information
Index
| Index Name
|
Index Type
|
Column Name
|
| PK_GLRAPPL
|
Unique
|
GLRAPPL_APPLICATION
|
| PK_GLRAPPL
|
Unique
|
GLRAPPL_KEY_NO
|
Comments
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
Schema Name GENERAL
Label GLRCALC
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:25:000
Table Columns information
| Column Name
|
Label
|
Column Type
|
Allow NULL
|
PK
|
FK
|
| GLRCALC_APPLICATION
|
GLRCALC_APPLICATION
|
VARCHAR2(30)
|
No
|
*
|
*
|
| GLRCALC_LETR_CODE
|
GLRCALC_LETR_CODE
|
VARCHAR2(15)
|
No
|
*
|
*
|
| GLRCALC_VARIABLE
|
GLRCALC_VARIABLE
|
VARCHAR2(30)
|
No
|
*
|
*
|
| GLRCALC_PIDM
|
GLRCALC_PIDM
|
NUMBER(8,0)
|
No
|
*
|
|
| GLRCALC_ROWNUM
|
GLRCALC_ROWNUM
|
NUMBER(8,0)
|
No
|
*
|
|
| GLRCALC_ACTIVITY_DATE
|
GLRCALC_ACTIVITY_DATE
|
DATE
|
No
|
|
|
| GLRCALC_AMT01
|
GLRCALC_AMT01
|
NUMBER(11,2)
|
Yes
|
|
|
| GLRCALC_AMT02
|
GLRCALC_AMT02
|
NUMBER(11,2)
|
Yes
|
|
|
| GLRCALC_AMT03
|
GLRCALC_AMT03
|
NUMBER(11,2)
|
Yes
|
|
|
| GLRCALC_AMT04
|
GLRCALC_AMT04
|
NUMBER(11,2)
|
Yes
|
|
|
| GLRCALC_AMT05
|
GLRCALC_AMT05
|
NUMBER(11,2)
|
Yes
|
|
|
| GLRCALC_AMT06
|
GLRCALC_AMT06
|
NUMBER(11,2)
|
Yes
|
|
|
| GLRCALC_AMT07
|
GLRCALC_AMT07
|
NUMBER(11,2)
|
Yes
|
|
|
| GLRCALC_AMT08
|
GLRCALC_AMT08
|
NUMBER(11,2)
|
Yes
|
|
|
| GLRCALC_AMT09
|
GLRCALC_AMT09
|
NUMBER(11,2)
|
Yes
|
|
|
| GLRCALC_AMT10
|
GLRCALC_AMT10
|
NUMBER(11,2)
|
Yes
|
|
|
| GLRCALC_AMT11
|
GLRCALC_AMT11
|
NUMBER(11,2)
|
Yes
|
|
|
| GLRCALC_AMT12
|
GLRCALC_AMT12
|
NUMBER(11,2)
|
Yes
|
|
|
| GLRCALC_AMT13
|
GLRCALC_AMT13
|
NUMBER(11,2)
|
Yes
|
|
|
| GLRCALC_AMT14
|
GLRCALC_AMT14
|
NUMBER(11,2)
|
Yes
|
|
|
| GLRCALC_AMT15
|
GLRCALC_AMT15
|
NUMBER(11,2)
|
Yes
|
|
|
| GLRCALC_AMT16
|
GLRCALC_AMT16
|
NUMBER(11,2)
|
Yes
|
|
|
| GLRCALC_AMT17
|
GLRCALC_AMT17
|
NUMBER(11,2)
|
Yes
|
|
|
| GLRCALC_AMT18
|
GLRCALC_AMT18
|
NUMBER(11,2)
|
Yes
|
|
|
| GLRCALC_AMT19
|
GLRCALC_AMT19
|
NUMBER(11,2)
|
Yes
|
|
|
| GLRCALC_AMT20
|
GLRCALC_AMT20
|
NUMBER(11,2)
|
Yes
|
|
|
Foreign Key information
Index
Comments
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
Schema Name GENERAL
Label GLRCMPL
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:25:000
Table Columns information
Foreign Key information
Index
Comments
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
Schema Name GENERAL
Label GLRCOLR
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:25:000
Table Columns information
Foreign Key information
Index
Comments
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
Schema Name GENERAL
Label GLROBJT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:25:000
Table Columns information
Foreign Key information
Index
Comments
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
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 GLROBJT_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 GLROBJT_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 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
Schema Name GENERAL
Label GLRORDR
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:25:000
Table Columns information
Foreign Key information
Index
Comments
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
Schema Name GENERAL
Label GLRSFRM
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:25:000
Table Columns information
Foreign Key information
Index
Comments
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
Schema Name GENERAL
Label GLRSLCT
Server name MALDEV8_B60
Creation Date 04/15/2002 18:04:26:000
Table Columns information