FIELDNAME0=Character
1=Long Character
2=Number
3=Signed Number
4=Date
5=Time
6=Datetime
RBT_NUM_IMP_VW(SQL View) |
Index Back |
|---|---|
Number Import ViewNumber Import View. Used in Communications product. |
| SELECT A.FIELDNAME , A.FIELDNUM , %NumToChar(B.FIELDTYPE ) , B.LENGTH , B.DECIMALPOS FROM PSRECFIELD A , PSDBFIELD B WHERE A.RECNAME = 'RBT_NUMBER_IMP' AND A.FIELDNAME = B.FIELDNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FIELDNAME |
Character(18) | VARCHAR2(18) NOT NULL | Field Name (see PSDBFIELD). |
| 2 | FIELDNUM | Number(4,0) | SMALLINT NOT NULL | Field Number |
| 3 | 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 |
| 4 | LENGTH | Number(5,0) | INTEGER NOT NULL | Length |
| 5 | DECIMALPOS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |