CUST_UDFLD_VW

(SQL View)
 Index Back

Customer Data Fields


SELECT %subrec(CUST_DFIELD_SBR, A) FROM PS_CUST_DATA_FIELD A WHERE A.SYS_DEFINED_FLAG <> 'Y'

  • Related Language Record: CUST_DFIELD_LVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 DATA_FIELD_ID Character(8) VARCHAR2(8) NOT NULL Data Field ID
    2 AR_DESCR Character(30) VARCHAR2(30) NOT NULL Description
    3 DATA_CATEGORY Character(1) VARCHAR2(1) NOT NULL Data Item Category
    A=Activity
    B=Balance
    G=General
    M=Metrics
    U=User
    4 DATA_FIELD_TYPE Character(2) VARCHAR2(2) NOT NULL Data Field Type
    AC=App Class
    DI=Data Item
    ST=String

    Default Value: DI

    5 USER_CLICKABLE_FLG Character(1) VARCHAR2(1) NOT NULL User Clickable
    N=No
    Y=Yes

    Default Value: N

    6 DATA_ITEM_ID Character(8) VARCHAR2(8) NOT NULL Data Item ID

    Prompt Table: %EDITTABLE

    7 DATA_ITEM_VAL_TYPE Character(1) VARCHAR2(1) NOT NULL Data Item Value Type
    D=Display
    F=Formatted

    Default Value: F

    8 STRING_TEXT Character(100) VARCHAR2(100) NOT NULL String Text
    9 VALUE_ROLLUP_FLG Character(1) VARCHAR2(1) NOT NULL Rollup Value
    N=No
    Y=Yes

    Default Value: N

    10 ACV_FIELD_VAL_FUNC Character(4) VARCHAR2(4) NOT NULL Aggregate Function
    MAX=Max
    MIN=Min
    SUM=Sum
    11 PACKAGEROOT Character(30) VARCHAR2(30) NOT NULL Package Name

    Prompt Table: PSPACKAGROOT_VW

    12 QUALIFYPATH Character(127) VARCHAR2(127) NOT NULL App Package Path

    Default Value: :

    Prompt Table: PSPACKAGPATH_VW

    13 APPCLASSID Character(30) VARCHAR2(30) NOT NULL Class Name

    Prompt Table: PSPACKAGCLAS_VW

    14 PARAM_VALUE Character(16) VARCHAR2(16) NOT NULL Parameter
    15 DEFINITION_TEXT Character(254) VARCHAR2(254) NOT NULL Definition
    16 DEFN_LOCKED_FLG Character(1) VARCHAR2(1) NOT NULL Definition Locked
    N=No
    Y=Yes
    17 ACTIVE_FLG Character(1) VARCHAR2(1) NOT NULL Event Status
    N=Inactive
    Y=Active

    Default Value: N

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