CS_USR_N_VW

(SQL View)
 Index Back

Number User Def Fields

1/4/2008 -- cel -- Number user def fields only

SELECT FIELDNAME , CS_USER_DEF_TYPE , ENABLED , SEARCH , EXT_FLAG , CS_LABEL2 ,CS_REQUIRED ,CS_PROMPT ,PROMPT_RECNAME ,CS_WIZ_RESP ,CS_BIND_VAR FROM PS_CS_USR_DEF_FLDS WHERE CS_USER_DEF_TYPE = 'N'

  • Related Language Record: CS_USR_DEF_LANG

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    2 CS_USER_DEF_TYPE Character(1) VARCHAR2(1) NOT NULL Type
    C=Char
    D=Date
    I=Integer
    N=Number
    3 ENABLED Character(1) VARCHAR2(1) NOT NULL A flag indicates whether this row is enabled or not.

    Y/N Table Edit

    4 SEARCH Character(1) VARCHAR2(1) NOT NULL Use in Searching

    Y/N Table Edit

    5 EXT_FLAG Character(1) VARCHAR2(1) NOT NULL Visible to Supplier

    Y/N Table Edit

    6 CS_LABEL2 Character(30) VARCHAR2(30) NOT NULL Label to Display
    7 CS_REQUIRED Character(1) VARCHAR2(1) NOT NULL F-AHAYT-X0ES6 - new label

    Y/N Table Edit

    Default Value: N

    8 CS_PROMPT Character(1) VARCHAR2(1) NOT NULL Tie to Prompt Table

    Y/N Table Edit

    Default Value: N

    9 PROMPT_RECNAME Character(15) VARCHAR2(15) NOT NULL Prompt record name in Chart field template Prompt record name in Form and Approval Builder
    10 CS_WIZ_RESP Character(1) VARCHAR2(1) NOT NULL Set from Wizard

    Y/N Table Edit

    Default Value: N

    11 CS_BIND_VAR Character(30) VARCHAR2(30) NOT NULL Bind Variable

    Prompt Table: CS_BINDS_N_VW