GROUP_INFO_VW(SQL View) |
Index Back |
|---|---|
Control Group Input |
| select BUSINESS_UNIT ,GROUP_ID_SF ,OPRID , ASSN_OPRID ,GROUP_TYPE , GROUP_SOURCE ,TYPE_OF_GROUP FROM PS_GROUP_CONT_INFO WHERE TYPE_OF_GROUP = 'E' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_CS.BUSINESS_UNIT Prompt Table: SP_BU_SF_NONVW |
| 2 | GROUP_ID_SF |
Character(15) | VARCHAR2(15) NOT NULL | Group ID |
| 3 | OPRID | Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_CS.OPRID Prompt Table: OPRID_VW |
| 4 | ASSN_OPRID | Character(30) | VARCHAR2(30) NOT NULL |
Assigned Operator ID
Prompt Table: OPRID_VW |
| 5 | GROUP_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Group Type
Prompt Table: GROUP_TYPE_TBL |
| 6 | GROUP_SOURCE | Character(1) | VARCHAR2(1) NOT NULL |
Group Source
E=External O=On-Line Default Value: O |
| 7 | TYPE_OF_GROUP | Character(1) | VARCHAR2(1) NOT NULL |
Type of Group
E=Student Group X=External Org Group |