RF_ACTCODE_VW (SQL View)	Index Back
Activity Code View This view is used exclusively in outer joins by other FieldService views. It is not in use on any page.

RF_ACTCODE_VW

(SQL View)

Activity Code View

This view is used exclusively in outer joins by other FieldService views. It is not in use on any page.

SELECT B.SETCNTRLVALUE , A.ACTIVITY_CODE , A.DESCR80 FROM PS_RF_ACT_CODE A , PS_SET_CNTRL_REC B WHERE A.SETID = B.SETID AND B.RECNAME = 'RF_ACT_CODE'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 SETCNTRLVALUE Character(20) VARCHAR2(20) NOT NULL Tree Definition User Key Value

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 DESCR80 Character(80) VARCHAR2(80) NOT NULL This generic field stores the description and used used on various tables.

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	SETCNTRLVALUE	Character(20)	VARCHAR2(20) NOT NULL	Tree Definition User Key Value
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	DESCR80	Character(80)	VARCHAR2(80) NOT NULL	This generic field stores the description and used used on various tables.