RF_SVC_LANG_VW (SQL View)	Index Back
Service Activity View Retrieves all the activities for the service.

RF_SVC_LANG_VW

(SQL View)

Service Activity View

Retrieves all the activities for the service.

SELECT A.SETID , A.SERVICE_ID , A.ACTIVITY_CODE , B.LANGUAGE_CD , B.DESCR80 , B.SHORT_DESCR FROM PS_RF_SERVICE_ACT A , PS_RF_ACT_CODE_LNG B WHERE A.SETID = B.SETID AND A.ACTIVITY_CODE = B.ACTIVITY_CODE

Related Language Record for RF_SVC_ACT_VW

# 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 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code

5 DESCR80 Character(80) VARCHAR2(80) NOT NULL This generic field stores the description and used used on various tables.

6 SHORT_DESCR Character(15) VARCHAR2(15) NOT NULL This field is used to represent the short description for various objects

#	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	LANGUAGE_CD	Character(3)	VARCHAR2(3) NOT NULL	Language Code
5	DESCR80	Character(80)	VARCHAR2(80) NOT NULL	This generic field stores the description and used used on various tables.
6	SHORT_DESCR	Character(15)	VARCHAR2(15) NOT NULL	This field is used to represent the short description for various objects