SETIDACTIVITY_CODEA=Active
I=Inactive
RF_ACT_CODE_VW3(SQL View) |
Index Back |
|---|---|
Activity Code Prompt ViewUsed for lookup on activity code. |
| SELECT SETID , ACTIVITY_CODE , STATUS , DESCR80 , SHORT_DESCR , ACTIVITY_TYPE_CD , EST_SERVICE_TIME FROM PS_RF_ACT_CODE WHERE STATUS = 'A' |
| # | 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 | ACTIVITY_CODE |
Character(8) | VARCHAR2(8) NOT NULL | Activity Code which identifies the specific Activities which will be performed as part of Service Orders. |
| 3 | STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Status Indicator
A=Active I=Inactive |
| 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 |
| 6 | ACTIVITY_TYPE_CD | Character(8) | VARCHAR2(8) NOT NULL | Service Activity Type Code which is used for grouping the Service Activities through the Activity Codes |
| 7 | EST_SERVICE_TIME | Number(8,2) | DECIMAL(7,2) NOT NULL | Estimated time that it will take to perform a service. |