SP_SRVC_ACT_VW

(SQL View)
Index Back

Service Activities

Service Activities

SELECT A.SETID , B.PROJ_ROLE , B.SP_BILL_METHOD , A.ACTIVITY_ID , C.DESCR FROM PS_SP_ACTIVITY_TYP A , PS_SPB_ROLE_ATTRIB B , PS_FS_ACTIVITY_TBL C , PS_SET_CNTRL_GROUP S WHERE A.STATUS = 'A' AND S.SETCNTRLVALUE = A.SETID AND S.REC_GROUP_ID = 'PC_18' AND S.SETID = B.SETID AND A.SERVICE_METHOD = B.SERVICE_METHOD AND A.SP_ACTIVITY_SUBTYP = B.SP_BILL_METHOD AND C.SETID = A.SETID AND A.ACTIVITY_ID = C.ACTIVITY_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

Default Value: OPR_DEF_TBL_FS.SETID

2 PROJ_ROLE Character(15) VARCHAR2(15) NOT NULL Project Role
3 SP_BILL_METHOD Character(1) VARCHAR2(1) NOT NULL Used in Service Based Workorders to identify the billing method.
F=Fixed Amount
M=Milestone
P=Percentage
R=Rate Based
4 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description