PSFLDSEGDEFN(SQL Table) |
Index Back |
---|---|
File Layout - File Segments.A File Layout is simply a collection of File Records/Segments, which in turn are a collection of Fields. A segment is the exact same as a record, only it contains no information. You have to add all the information yourself. After you add the information to a segment, you can treat it just like any other file record. This record is used to store the Record / Segment information. |
# | 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 | FLDSEGID | Character(30) | VARCHAR2(30) NOT NULL | Segment ID |
4 | FLDSEGPARENT | Character(15) | VARCHAR2(15) NOT NULL | Segment Parent |
5 | FLDSEGIDSTART | Number(5,0) | INTEGER NOT NULL | Segment ID Start |
6 | FLDSEGIDLENGTH | Number(5,0) | INTEGER NOT NULL | Segment ID Length |
7 | FLDOFFSET | Number(5,0) | INTEGER NOT NULL | Field Offset |
8 | FLDTAG | Character(30) | VARCHAR2(30) NOT NULL | XML End Tag |
9 | FLDSEQNO | Number(5,0) | INTEGER NOT NULL | Field Sequence Number |
10 | FLDQUALIFIER | Character(1) | VARCHAR2(1) NOT NULL | Field Qualifier |
11 | FLDDELIMITERTYPE | Number(2,0) | SMALLINT NOT NULL | Field Delimiter Type |
12 | FLDDELIMITER | Character(1) | VARCHAR2(1) NOT NULL | Field Delimiter |
13 | FLDSEGCOUNT | Number(5,0) | INTEGER NOT NULL | Segment Count |
14 | FLDFIELDCOUNT | Number(5,0) | INTEGER NOT NULL | Field Count |
15 | FLDIDSEQNO | Number(5,0) | INTEGER NOT NULL | File ID Sequence Number |
16 | FLDMAXSEGLEN | Number(5,0) | INTEGER NOT NULL | Maximum Segment Length |
17 | DESCR100 | Character(100) | VARCHAR2(100) NOT NULL | Length 100 Description |
18 | RECNAME_FILE | Character(15) | VARCHAR2(15) NOT NULL | Model File Layout |
19 | SQLID | Character(30) | VARCHAR2(30) NOT NULL |
SQL Object Identifier. This column has different meanings depending upon value of SQLTYPE |
20 | SQLTYPE | Character(1) | VARCHAR2(1) NOT NULL |
SQL Object type |
21 | PTFLDSEGTERM | Character(5) | VARCHAR2(5) NOT NULL | Segment Terminator |