GPS_FUN_IDX_LNG

(SQL Table)
Index Back

Function Index Language Table

Language table of GPS_FUNC_IDX

  • Related Language Record for GPS_FUNC_IDX
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SETID Character(5) VARCHAR2(5) NOT NULL SetID

    Default Value: OPR_DEF_TBL_HR.SETID

    Prompt Table: SET_VLD_HR_05

    2 GPS_ORG_TYPE Character(1) VARCHAR2(1) NOT NULL Organization Type. There are two possible values for this field. They are: G AND C
    C=Local Government
    G=National Government
    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 GPS_FUNCTION_IDX Character(6) VARCHAR2(6) NOT NULL Function Index
    5 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
    7 GPS_INDEX_DESCR Long Character CLOB NOT NULL GPS Description of Function Index