Identifying Page Field Type from Tools Tables

I was searching for a particular content in the internet and found a post which describes the field type code for the page field definition. I thought it was worth mentioning here so that it will supplement the first post People Tools Tables - Metadata and give you an idea on effectively using the tools meta data tables.

                             

To give a background, when you create a page in peoplesoft application designer, the page definition will be saved in PSPNLDEFN table. This will contain high level details of the page such as name, description, Owner, Page type etc… But have you ever wondered how the actual page on the PIA is drawn up when you visit the page? Peoplesoft actually stores the information of each and every field you place on the page in application designer in a tools table called PSPNLFIELD. It will contain all the details like Field name, label, position, field type, level, record name, field name, field style and so on. Based on this information, the page is dynamically drawn up each time you visit it from PIA. But if you query this table you see that almost all the information is stored as numerical values which you cannot infer or find a reference anywhere.

I will share the piece of information found over the net which list all the codes for the FIELDTYPE and FIELDUSE field.

FIELDTYPE – Defines the type of field

0 - STATIC TEXT
1 - FRAME
2 - GROUP BOX
3 - STATIS IMAGE
4 - EDIT BOX
5 - DROPDOWN LIST
6 - LONG EDIT BOX
7 - CHECK BOX
8 - RADIO BUTTON
9 - IMAGE
10 - SCROLL BAR
11 - SUBPAGE
12 - PEOPLECODE COMMAND - (BUTTON/HYPERLINK DESTINATION)
13 - SCROLL ACTION - (BUTTON/HYPERLINK DESTINATION)
14 - TOOLBAR ACTION - (BUTTON/HYPERLINK DESTINATION)
15 - EXTERNAL LINK - (BUTTON/HYPERLINK DESTINATION)
16 - INTERNAL LINK - (BUTTON/HYPERLINK DESTINATION)
17 - PROCESS - (BUTTON/HYPERLINK DESTINATION)
18 - SECONDARY PAGE
19 - GRID
20 - TREE
21 - SECONDARY PAGE - (BUTTON/HYPERLINK DESTINATION)
22 - <not identified>
23 - HORIZONTAL RULE
24 - TAB SEPARATOR
25 - HTML AREA
26 - PROMPT ACTION - (BUTTON/HYPERLINK DESTINATION)
27 - SCROLL AREA
28 - <not identified>
29 - PAGE ANCHOR
30 - CHART

FIELDUSE – Defines the properties you selected for the field in use tab

1 - Display Only 
2 - Invisible 
4 - <not identified>
8 - Display Control 
16 - Related Display 
32 - Multi Currency Field 
64 - No Auto Select 
128 - No Auto Update 
256 - No Row Insert 
512 - No Row Delete 
1024 - Show Label 
2048 - Freeze Grid Column 
4096 - Odd/Even Row Style 
8192 - <not identified>
16384 - <not identified>
32768 - <not identified>
65536 - <not identified>
131072 - <not identified>
262144 - Enable when display only 
524288 - <not identified>
1048576 - Row Delete 
2097152 - Row Insert 
4194304 - Next Page 
8388608 - Previous Page 
16777216 - <not identified>
33554432 - Show Row Counter 
67108864 - Hide Border 
134217728 - Unlimited Occurs 
268435456 - Fixed Height 
536870912 - <not identified>
1073741824 - Top 
2147483648 - Bottom