RF_ACT_NO_VW (SQL View)	Index Back
Activity View Activity Dummy View

RF_ACT_NO_VW

(SQL View)

Activity View

Activity Dummy View

SELECT setid , activity_code FROM PS_RF_ACT_CODE WHERE 1 = 0

# 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.

#	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.