CO_FILE_NBRS_VW |
index back |
---|---|
File Layout - File Fields |
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 | Field Type | Column Type | Description |
---|---|---|---|
![]() |
Character(30) | VARCHAR2(30) NOT NULL | Definition Name (see PSFLDDEFN). |
![]() |
Character(15) | VARCHAR2(15) NOT NULL | Segment Name |
![]() |
Number(5,0) | INTEGER NOT NULL | Field Sequence Number |
FLDFIELDNAME | Character(18) | VARCHAR2(18) NOT NULL | Field Name |
FLDSTART | Number(5,0) | INTEGER NOT NULL | Starting Position |
FLDLENGTH | Number(5,0) | INTEGER NOT NULL | Field Length |
DECIMALPOS | Number(2,0) | SMALLINT NOT NULL | Decimal Positions |
FLDMAXSEGLEN | Number(5,0) | INTEGER NOT NULL | Maximum Segment Length |
index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |