Creating peoplesoft FIELD through SQLs

This approach will be helpful, if you want to create lot of similar fields in peopletools.
Whenever we create a FIELD using AppDesigner in peoplesoft, then it will insert one row each in the following tables
PSDBFIELD -- It has lot of columns, it stores information about the datatype, length..etc..
PSDBFIELDNAMEVW -- Has only one column field name
PSDBFLDLABL -- Stores fieldname, label, long name, shortname, default label

You can query for the existing fields and create insert statements based on thoose data.
Execute thoose statements by connecting to the database to create the FIELDs.
Similarly when we add a FIELD to a RECORD, then one row will get inserted in each of the below tables
PSRECFIELD
PSRECFIELDALL
PSRECFIELDDB
PSRECFLDNOSR