GP_PIN_SRCH_LV

(SQL View)
 Index Back

Common PIN Srch Rel Lang

Common Related Language view for searchviews to Element components

%Sql(gp_srch_lang_sql)

  • Related Language Record for GP_ABSTAKE_SRCH GP_ABS_ENT_SRCH GP_ABS_FCS_SRCH GP_ABS_TAK_SRCH GP_ACCMLTR_SRCH GP_ARRAY_SRCH GP_BRACKET_SRCH GP_COUNT_SRCH GP_DATE_SRCH GP_DED_SRCH GP_DUR_SRCH GP_ED_SET_SRCH GP_ELEMGRP_SRCH GP_ERN_SRCH GP_FC_SRCH GP_FML_SRCH GP_GCTL_SRCH GP_HISTC_SRCH GP_PRORATE_SRCH GP_RC_SRCH GP_RND_SRCH GP_SYSPIN_SRCH GP_VAR_SRCH GP_WA_SRCH

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
    2 PIN_NUM Number(8,0) INTEGER NOT NULL PIN Number
    3 PIN_SRCH_NUM Number(8,0) INTEGER NOT NULL Field used in PIN component search views
    4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    5 PIN_NM Character(18) VARCHAR2(18) NOT NULL Element Name field
    6 DESCR Character(30) VARCHAR2(30) NOT NULL Description