RB_DBFLDTYPE_VW

(SQL View)
Index Back

DBField Type/Length View

For a given field, show the field type and length, including short and long name.

SELECT A.FIELDNAME , A.FIELDTYPE , A.LENGTH , A.DECIMALPOS , %Substring(B.FIELDVALUE, 1, 2) , B.XLATSHORTNAME , B.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 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')

  • Related Language Record: RB_DBFLDTYP_LVW
  • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).
    2 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)
    3 LENGTH Number(5,0) INTEGER NOT NULL Length
    4 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions
    5 PROMPT_FIELDTYPE Character(2) VARCHAR2(2) NOT NULL Query Expression Field Type
    0=Character
    1=Long Character
    2=Number
    3=Signed Number
    4=Date
    5=Time
    6=Datetime
    6 XLATSHORTNAME Character(10) VARCHAR2(10) NOT NULL Translate Value Short Name
    7 XLATLONGNAME Character(30) VARCHAR2(30) NOT NULL Translate Long Name
    8 RA_FIELDTYPE_DESCR Character(20) VARCHAR2(20) NOT NULL Field Type Description