CUST_CDITEMS_VW

(SQL View)
 Index Back

System data items


SELECT DATA_CATEGORY , DATA_ITEM_ID , AR_DESCR , DATA_ITEM_TYPE , MULTI_VALUE_FLAG , SYS_DEFINED_FLAG FROM PS_CUST_DATA_ITEM WHERE SYS_DEFINED_FLAG = 'Y' AND ACTIVE_FLG = 'Y'

  • Related Language Record: CUST_CDITEM_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DATA_CATEGORY Character(1) VARCHAR2(1) NOT NULL Data Item Category
    A=Activity
    B=Balance
    G=General
    M=Metrics
    U=User
    2 DATA_ITEM_ID Character(8) VARCHAR2(8) NOT NULL Data Item ID
    3 AR_DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DATA_ITEM_TYPE Character(2) VARCHAR2(2) NOT NULL Data item type
    AC=App Class
    RF=Record Field

    Default Value: RF

    5 MULTI_VALUE_FLAG Character(1) VARCHAR2(1) NOT NULL Multiple Values
    N=No
    Y=Yes

    Default Value: N

    6 SYS_DEFINED_FLAG Character(1) VARCHAR2(1) NOT NULL System defined flag
    N=No
    Y=Yes