SA_PSRECFLD_VW(SQL View) |
Index Back |
---|---|
Student Aid Record/Field ViewA combined view of the PSRECFIELD and PSDBFIELD tables to provide the data needed for Student Financials formula 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 , b.fieldtype , a.edittable , a.useedit , b.length , b.decimalpos FROM psrecfield a , psdbfield b WHERE a.fieldname = b.fieldname AND b.fieldtype IN (0,2,3,4,5,6) AND EXISTS ( SELECT 'x' FROM PSRECDEFN c WHERE a.recname = c.recname AND c.rectype IN (0,1,3)) |
# | 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 | FIELDTYPE | Number(2,0) | SMALLINT NOT NULL | Field Type (from PSST0101 Ref.) |
4 | EDITTABLE | Character(15) | VARCHAR2(15) NOT NULL | Edit Table |
5 | USEEDIT | Number(10,0) | DECIMAL(10) NOT NULL | Field Use and Edit Flags- USEEDIT reference |
6 | LENGTH | Number(5,0) | INTEGER NOT NULL | Length |
7 | DECIMALPOS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |