EG_FLX_FUNC_VW

(SQL View)
 Index Back

Flexible Service Type Vw

This is a setup view for Flexible Service Type (i.e. Function Result Name).

SELECT A.EG_GROUP, A.FUNCTN_RESULT_NM ,A.DESCR20 ,A.ACTIVE_INACTIVE FROM PS_EG_FNC_RSLT_DFN A WHERE A.FUNCTN_NAME = 'FLXSRVC' AND A.ACTIVE_INACTIVE = 'A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 EG_GROUP Character(6) VARCHAR2(6) NOT NULL Service Calculation Group
2 EG_FLX_SVC_TYPE Character(10) VARCHAR2(10) NOT NULL Service Type
3 DESCR20 Character(20) VARCHAR2(20) NOT NULL Description
4 ACTIVE_INACTIVE Character(1) VARCHAR2(1) NOT NULL Definition Active or Inactive?
A=Active
I=Inactive