SAD_UC_ADMFNCVW

(SQL View)
 Index Back

SELECT A.admin_function , A.descr FROM %Table(ADM_FUNCTN_TBL) A WHERE A.admin_function IN ('ADMA','ADMP') AND %EffdtCheck(ADM_FUNCTN_TBL B, A, %currentdatein) AND eff_status='A'

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 SAD_UC_ADMIN_FUNCT Character(4) VARCHAR2(4) NOT NULL Default Admin Function
2 DESCR Character(30) VARCHAR2(30) NOT NULL Description