SERVICE_GROUP_IDPrompt Table: PSOPRDEFN_VW
FO_SVC_GRP_SRCH(SQL View) |
Index Back |
|---|---|
Team Search RecService Group/Team table Search Record |
| SELECT A.SERVICE_GROUP_ID , A.DESCR80 ,A.PRIMARY_LEAD , B.OPRDEFNDESC FROM PS_FO_SVC_GRP_TBL A , PSOPRDEFN B WHERE A.PRIMARY_LEAD = B.OPRID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SERVICE_GROUP_ID |
Character(30) | VARCHAR2(30) NOT NULL | Service Group Id |
| 2 | DESCR80 | Character(80) | VARCHAR2(80) NOT NULL | Description |
| 3 | PRIMARY_LEAD | Character(30) | VARCHAR2(30) NOT NULL |
Primary Lead
Prompt Table: PSOPRDEFN_VW |
| 4 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |