PTS_DBFLDTYPLV

(SQL View)
 Index Back

DBField Type/Length Rel. Lang.


SELECT A.FIELDNAME , C.LANGUAGE_CD , C.XLATSHORTNAME , C.XLATLONGNAME , CASE WHEN A.FIELDTYPE = 0 THEN %TrimSubstr(B.XLATSHORTNAME, 1, 10) %Concat '(' %Concat %TrimSubstr(TO_CHAR(A.LENGTH), 1, 5) %Concat ')' WHEN A.FIELDTYPE = 1 THEN %TrimSubstr(B.XLATSHORTNAME, 1, 10) %Concat '(' %Concat %TrimSubstr(TO_CHAR(A.LENGTH), 1, 3) %Concat ')' WHEN A.FIELDTYPE = 2 THEN %TrimSubstr(B.XLATSHORTNAME, 1, 10) %Concat '(' %Concat %TrimSubstr(TO_CHAR(A.LENGTH), 1, 2) %Concat '.' %Concat %TrimSubstr(TO_CHAR(A.DECIMALPOS), 1, 2) %Concat ')' WHEN A.FIELDTYPE = 3 THEN %TrimSubstr(B.XLATSHORTNAME, 1, 10) %Concat '(' %Concat %TrimSubstr(TO_CHAR(A.LENGTH), 1, 2) %Concat '.' %Concat %TrimSubstr(TO_CHAR(A.DECIMALPOS), 1, 2) %Concat ')' WHEN A.FIELDTYPE = 4 THEN B.XLATSHORTNAME WHEN A.FIELDTYPE = 5 THEN B.XLATSHORTNAME WHEN A.FIELDTYPE = 6 THEN B.XLATSHORTNAME END FROM PSDBFIELD A , PSXLATITEM B , PSXLATITEMLANG C WHERE B.FIELDNAME = 'PROMPT_FIELDTYPE' AND B.FIELDVALUE = %TrimSubstr(TO_CHAR(A.FIELDTYPE), 1, 1) AND B.EFFDT = ( SELECT MAX(B_EF.EFFDT) FROM PSXLATITEM B_EF WHERE B_EF.FIELDNAME = B.FIELDNAME AND B_EF.FIELDVALUE = B.FIELDVALUE AND B_EF.EFFDT <= %CurrentDateIn AND B_EF.EFF_STATUS = 'A') AND C.FIELDNAME = B.FIELDNAME AND C.FIELDVALUE = B.FIELDVALUE AND C.EFFDT = B.EFFDT

  • Related Language Record for PTS_DBFLDTYPVW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    4 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    5 PTS_FLDTYPE_DESCR Character(20) VARCHAR2(20) NOT NULL Field Type Descriptn