FLDDEFNNAMEFLDSEGNAMEFLDSEQNOCO_FILE_NBRS_VW(SQL View) |
Index Back |
|---|---|
File Layout - File FieldsThe record contains contains stored at the File Field level for a File Layout. |
| SELECT A.FLDDEFNNAME ,A.FLDSEGNAME ,A.FLDSEQNO ,A.FLDFIELDNAME ,A.FLDSTART ,A.FLDLENGTH ,B.DECIMALPOS ,C.FLDMAXSEGLEN FROM PSFLDFIELDDEFN A ,PSDBFIELD B ,PSFLDSEGDEFN C WHERE A.FLDFIELDTYPE IN (2,3) AND A.FLDFIELDNAME = B.FIELDNAME AND A.FLDDEFNNAME = C.FLDDEFNNAME AND A.FLDSEGNAME = C.FLDSEGNAME |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | FLDDEFNNAME |
Character(30) | VARCHAR2(30) NOT NULL | Definition Name (see PSFLDDEFN). |
| 2 | FLDSEGNAME |
Character(15) | VARCHAR2(15) NOT NULL | Segment Name |
| 3 | FLDSEQNO |
Number(5,0) | INTEGER NOT NULL | Field Sequence Number |
| 4 | FLDFIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
| 5 | FLDSTART | Number(5,0) | INTEGER NOT NULL | Starting Position |
| 6 | FLDLENGTH | Number(5,0) | INTEGER NOT NULL | Field Length |
| 7 | DECIMALPOS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
| 8 | FLDMAXSEGLEN | Number(5,0) | INTEGER NOT NULL | Maximum Segment Length |