SRCH_PSFIELD_VW (SQL View)	Index Back
Search/Match Field Select View A combined view of the PSRECFIELD and PSDBFIELD tables to provide the data needed for Search/Match field creation. Note that this view selects only those fields with the following data types (FIELDTYPE): 0 - Character 2 - Number 3 - Signed Number 4 - Date

SRCH_PSFIELD_VW

(SQL View)

Search/Match Field Select View

A combined view of the PSRECFIELD and PSDBFIELD tables to provide the data needed for Search/Match field creation. Note that this view selects only those fields with the following data types (FIELDTYPE): 0 - Character 2 - Number 3 - Signed Number 4 - Date

SELECT a.recname , a.fieldname , c.longname , b.fieldtype , a.edittable , a.useedit , b.length , b.decimalpos , b.format FROM psrecfield a , psdbfield b , psdbfldlabl c WHERE a.fieldname = b.fieldname AND b.fieldtype IN (0,2,3,4) AND a.fieldname = c.fieldname AND c.default_label = 1 AND EXISTS ( SELECT 'x' FROM PSRECDEFN d WHERE a.recname = d.recname AND d.rectype IN (0,1,3,6))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 RECNAME Character(15) VARCHAR2(15) NOT NULL Record (Table) Name (see PSRECDEFN).

2 FIELDNAME Character(18) VARCHAR2(18) NOT NULL Field Name (see PSDBFIELD).

3 LONGNAME Character(30) VARCHAR2(30) NOT NULL Long Name

4 FIELDTYPE Number(2,0) SMALLINT NOT NULL Field Type (from PSST0101 Ref.)

5 EDITTABLE Character(15) VARCHAR2(15) NOT NULL Edit Table

6 USEEDIT Number(10,0) DECIMAL(10) NOT NULL Field Use and Edit Flags- USEEDIT reference

7 LENGTH Number(5,0) INTEGER NOT NULL Length

8 DECIMALPOS Number(2,0) SMALLINT NOT NULL Decimal Positions

9 FORMAT Number(2,0) SMALLINT NOT NULL Field Format
0=
If Fieldtype=0 (Character) then Upper Case
If Fieldtype=6 (DateTime) then HH:MM
1=Name
2=Phone Number North American (mandatory length 12 characters)
3=Zip/Postal Code North American (mandatory length 10 characters)
4=US Social Security Number (mandatory length 9 characters)
5=
6=Mixed Case
7=Raw/Binary
8=Numbers only
9=SIN (mandatory length 9 characters)
10=International Phone Number
11=Zip/Postal Code International
12=Time HH:MM:SS
13=Time HH:MM:SS.999999
14=Custom (FORMATFAMILY and DISPFMTNAME must be completed)

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	RECNAME	Character(15)	VARCHAR2(15) NOT NULL	Record (Table) Name (see PSRECDEFN).
2	FIELDNAME	Character(18)	VARCHAR2(18) NOT NULL	Field Name (see PSDBFIELD).
3	LONGNAME	Character(30)	VARCHAR2(30) NOT NULL	Long Name
4	FIELDTYPE	Number(2,0)	SMALLINT NOT NULL	Field Type (from PSST0101 Ref.)
5	EDITTABLE	Character(15)	VARCHAR2(15) NOT NULL	Edit Table
6	USEEDIT	Number(10,0)	DECIMAL(10) NOT NULL	Field Use and Edit Flags- USEEDIT reference
7	LENGTH	Number(5,0)	INTEGER NOT NULL	Length
8	DECIMALPOS	Number(2,0)	SMALLINT NOT NULL	Decimal Positions
9	FORMAT	Number(2,0)	SMALLINT NOT NULL	Field Format 0= If Fieldtype=0 (Character) then Upper Case If Fieldtype=6 (DateTime) then HH:MM 1=Name 2=Phone Number North American (mandatory length 12 characters) 3=Zip/Postal Code North American (mandatory length 10 characters) 4=US Social Security Number (mandatory length 9 characters) 5= 6=Mixed Case 7=Raw/Binary 8=Numbers only 9=SIN (mandatory length 9 characters) 10=International Phone Number 11=Zip/Postal Code International 12=Time HH:MM:SS 13=Time HH:MM:SS.999999 14=Custom (FORMATFAMILY and DISPFMTNAME must be completed)