FIELDNAME0=Character
1=Long Character
2=Number
3=Signed Number
4=Date
5=Time
6=Datetime
PTS_DBFLDTYPVW(SQL View) |
Index Back |
|---|---|
DBField Type/Length View |
| SELECT A.FIELDNAME , A.FIELDTYPE , A.LENGTH , A.DECIMALPOS , B.FIELDVALUE , 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') |
| # | 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 | PTS_FLDTYPE_DESCR | Character(20) | VARCHAR2(20) NOT NULL | Field Type Descriptn |