EG_FLX_TYPE_VW

(SQL View)
 Index Back

Flexible Service Type Vw

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

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

# 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