IN_TM_DEFN_FLD

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	IN_TM_CODE	Character(15)	VARCHAR2(15) NOT NULL	Template Code
2	IN_TM_CATEGORY	Character(15)	VARCHAR2(15) NOT NULL	Template Category
3	IN_TM_SUB_CATEGORY	Character(15)	VARCHAR2(15) NOT NULL	Template Subcategory
4	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
5	IN_TM_FLD_DISPLAY	Character(1)	VARCHAR2(1) NOT NULL	Display 0=Edit Field 1=Check Box 2=List 3=Blank 4=Xlat 5=Edit Button 6=Ctrl Xlat 7=Ctrl Checkbox 8=Control Default Value: 0
6	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)
7	LENGTH	Number(5,0)	INTEGER NOT NULL	Length
8	LABEL_ID	Character(18)	VARCHAR2(18) NOT NULL	LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
9	REQUIRED_FIELD	Character(1)	VARCHAR2(1) NOT NULL	* Required Field Y/N Table Edit Default Value: N
10	VALUE_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Value Required N=Not Required O=Optional Y=Required Y/N Table Edit Default Value: N
11	EDITTABLE	Character(15)	VARCHAR2(15) NOT NULL	Edit Table
12	IN_TM_PRMT_FLDNAME	Character(18)	VARCHAR2(18) NOT NULL	Prompt Field Name
13	IN_TM_LST_FFLDNAME	Character(18)	VARCHAR2(18) NOT NULL	List From Field Name
14	IN_TM_LST_TFLDNAME	Character(18)	VARCHAR2(18) NOT NULL	ListTo Field Name
15	IN_TM_WHER_FLDNAME	Character(30)	VARCHAR2(30) NOT NULL	Where Field Name
16	SORT_SEQ_NBR	Number(3,0)	SMALLINT NOT NULL	Sort Sequence Number
17	IN_TM_SHOW_TOFLG	Character(1)	VARCHAR2(1) NOT NULL	Enable Show Range Y/N Table Edit Default Value: N
18	IN_TM_APPEND_ROW	Character(1)	VARCHAR2(1) NOT NULL	Display in 2nd Column Y/N Table Edit Default Value: N
19	IN_TM_XLATLONGNAME	Character(1)	VARCHAR2(1) NOT NULL	Display Translate Long Name Y/N Table Edit Default Value: N
20	DESCR254	Character(254)	VARCHAR2(254) NOT NULL	Description of length 254