SEL_GROUP_CRITR(SQL Table) |
Index Back |
|---|---|
Selector Group Criteria |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: SEL_GROUP_TBL.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
| 2 | SEL_GROUP |
Character(10) | VARCHAR2(10) NOT NULL |
Tuition Group
Default Value: SEL_GROUP_TBL.SEL_GROUP Prompt Table: SEL_GROUP_TBL |
| 3 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: SEL_GROUP_TBL.EFFDT |
| 4 | SSF_CRITR_EQUTN_SW | Character(1) | VARCHAR2(1) NOT NULL |
Criteria Equation switch
C=Use Criteria E=Use Equation N=No Criteria Default Value: C |
| 5 | CRITERIA |
Character(12) | VARCHAR2(12) NOT NULL |
Criteria for Selector
Prompt Table: %EDITTABLE |
| 6 | CRIT_PRIORITY | Number(3,0) | SMALLINT NOT NULL |
Criteria Priority
Default Value: 1 |