PTS_ADD_DTL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	PORTAL_NAME	Character(30)	VARCHAR2(30) NOT NULL	Portal Name (see PSPRDMDEFN).
2	PORTAL_OBJNAME	Character(30)	VARCHAR2(30) NOT NULL	Portal Object Name
3	PTS_SEARCH_ID	Character(65)	VARCHAR2(65) NOT NULL	Search ID
4	EFFDT	Date(10)	DATE NOT NULL	Effective Date
5	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
6	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)
7	PTS_DEF_LABEL_ID	Character(18)	VARCHAR2(18) NOT NULL	LABEL_ID identifies uniquness of DB Field Labels. This field is used in PSDBFLDLABL and PSDBFLDLABLLANG.
8	PTS_FIELD_LONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Long Name
9	PTS_MODIFY_LBL	Character(1)	VARCHAR2(1) NOT NULL	Include the selected field in Search Criteria Y/N Table Edit Default Value: N
10	PTS_FIELD_ORDER	Number(3,0)	SMALLINT NOT NULL	Criteria/Results Field Order
11	PTS_SRCH_KEY_FLG	Character(1)	VARCHAR2(1) NOT NULL	Search Key field flag
12	PTS_REQUIRED	Character(1)	VARCHAR2(1) NOT NULL	Include the selected field in Search Criteria Y/N Table Edit Default Value: N
13	PTS_USE_IN_ADD	Character(1)	VARCHAR2(1) NOT NULL	Include the selected field in Search Criteria Y/N Table Edit Default Value: N
14	PTS_ADD_FLD_VISIB	Character(1)	VARCHAR2(1) NOT NULL	Include the selected field in Search Criteria Y/N Table Edit Default Value: N
15	PTS_ADD_FLD_GREY	Character(1)	VARCHAR2(1) NOT NULL	Include the selected field in Search Criteria Y/N Table Edit Default Value: N
16	PTS_ADD_ORDER	Number(3,0)	SMALLINT NOT NULL	Criteria/Results Field Order
17	PTS_DEFAULT_FLAG	Character(1)	VARCHAR2(1) NOT NULL	Set As Default N=No Y=Yes
18	PTS_DEFAULT_TYPE	Character(1)	VARCHAR2(1) NOT NULL	Set As Default Y/N Table Edit Default Value: N
19	PTS_DEF_VALUE	Character(18)	VARCHAR2(18) NOT NULL	Default Field Name