ADM_FCN_ORG_VW

(SQL View)
 Index Back

Administrative Fcn Org Table

This view is used to prompt for ADMIN_FUNCTION in ORG COMMUNICATION, CHECKLIST and COMMENTS

SELECT A.ADMIN_FUNCTION, A.EFFDT, A.DESCR FROM PS_ADM_FUNCTN_TBL A WHERE A.ADMIN_FCN_ORG = 'Y'

  • Related Language Record: ADM_FCN_ORG_LNG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 ADMIN_FUNCTION Character(4) VARCHAR2(4) NOT NULL Administrative Function
    2 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description