FA_INST_ASNVW (SQL View)	Index Back
Batch Pck Asgn Rec/Field View A combined view of the PSRECFIELD and PSDBFIELD tables to provide the data needed for Insitutional Batch Packaging Criteria Note that this view selects only those fields with the following data types (FIELDTYPE): 0 - Character 2 - Number 3 - Signed Number 4 - Date

FA_INST_ASNVW

(SQL View)

Batch Pck Asgn Rec/Field View

A combined view of the PSRECFIELD and PSDBFIELD tables to provide the data needed for Insitutional Batch Packaging Criteria 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 , d.longname , b.fieldtype , a.edittable , a.useedit , b.length , b.decimalpos , b.format FROM psrecfield a , psdbfield b , psdbfldlabl d WHERE a.fieldname = b.fieldname AND b.fieldtype IN (0,2,3,4,5,6) AND d.fieldname = a.fieldname AND d.default_label = 1 AND EXISTS ( SELECT 'x' FROM PSRECDEFN c WHERE a.recname = c.recname AND c.rectype IN (0,1,3)) AND a.recname = 'FA_INST_CRIT_VW'

# 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)