RF_SVC_AGR_VW(SQL View) |
Index Back |
|---|---|
ServiceView for Services Applicable for Agreements |
| SELECT setid , service_id , descr80 , short_descr , service_type_cd , active_status , est_service_time , warranty_flag , agreement_flag , billable_flag , off_hours_flag FROM PS_RF_SERVICE WHERE agreement_flag = 'Y' AND active_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.
Default Value: OPR_DEF_TBL_RB.SETID Prompt Table: SP_SETID_NONVW |
| 2 | SERVICE_ID |
Character(20) | VARCHAR2(20) NOT NULL |
Service Number
Default Value: NEXT |
| 3 | DESCR80 | Character(80) | VARCHAR2(80) NOT NULL | This generic field stores the description and used used on various tables. |
| 4 | SHORT_DESCR | Character(15) | VARCHAR2(15) NOT NULL | This field is used to represent the short description for various objects |
| 5 | SERVICE_TYPE_CD | Character(8) | VARCHAR2(8) NOT NULL |
User-definable code to classify the type of service.
Prompt Table: RF_SERVICE_TYPE |
| 6 | ACTIVE_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
Allows for Active and Inactive status.
A=Active I=Inactive Default Value: A |
| 7 | EST_SERVICE_TIME | Number(8,2) | DECIMAL(7,2) NOT NULL | Estimated time that it will take to perform a service. |
| 8 | WARRANTY_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Indicates that the agreement is classified as a warranty.
N=No Y=Yes Default Value: N |
| 9 | AGREEMENT_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Indicates whether or not the service can be used on an agreement.
N=No Y=Yes Default Value: Y |
| 10 | BILLABLE_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
This is used to determine of the item under consideration is billable or not.
N=No Y=Yes Default Value: N |
| 11 | OFF_HOURS_FLAG | Character(1) | VARCHAR2(1) NOT NULL |
Off Hours
N=No Y=Yes Default Value: N |