RECNAMEFIELDNAMESTDNT_BGT_ASNVW(SQL View) |
Index Back |
|---|---|
Stdnt Bdgt Asgn Rec/Field ViewA combined view of the PSRECFIELD table and PSDBFIELD view to provide the data needed for FA Student Budget's 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 Modified for Rel. 9.2 to use PSDBFIELD instead of PS_PSDBFIELD_VW. |
| 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) AND EXISTS ( SELECT 'x' FROM PSRECDEFN c WHERE a.recname = c.recname AND c.rectype IN (0,1,3)) AND a.recname = 'STDNT_BDGT_ASGN' AND a.fieldname <> 'PRORATE_BUDGET' AND A.FIELDNAME <> 'FA_TERM_EFFDT' AND A.FIELDNAME <> 'FA_TERM_EFFSEQ' AND A.FIELDNAME <> 'INTERESTED_IN_PLUS' |
| # | 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 |