SETIDSERVICE_IDACTIVITY_CODERF_SVC_ACT_VW(SQL View) |
Index Back |
|---|---|
Service Activity ViewRetrieves all the activities for the service. |
| SELECT A.SETID , A.SERVICE_ID , A.ACTIVITY_CODE , B.DESCR80 , B.SHORT_DESCR FROM PS_RF_SERVICE_ACT A , PS_RF_ACT_CODE B WHERE A.SETID = B.SETID AND A.ACTIVITY_CODE = B.ACTIVITY_CODE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SETID |
Character(5) | VARCHAR2(5) NOT NULL | This field is used to store the value of SetID on various setup tables. |
| 2 | SERVICE_ID |
Character(20) | VARCHAR2(20) NOT NULL | Service ID |
| 3 | ACTIVITY_CODE |
Character(8) | VARCHAR2(8) NOT NULL | Activity Code which identifies the specific Activities which will be performed as part of Service Orders. |
| 4 | DESCR80 | Character(80) | VARCHAR2(80) NOT NULL | This generic field stores the description and used used on various tables. |
| 5 | SHORT_DESCR | Character(15) | VARCHAR2(15) NOT NULL | This field is used to represent the short description for various objects |