SEG_ELEMENTC=Character
D=Date
N=Number
GM_PROP_FRM_SEG(SQL Table) |
Index Back |
|---|---|
Transaction 194 Segment DefiniTransaction 194 Segment Definition |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | SEG_ELEMENT |
Character(20) | VARCHAR2(20) NOT NULL | Segment/Element |
| 2 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 3 | DATA_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
DATA_TYPE
C=Character D=Date N=Number |
| 4 | SQL_STATEMENT | Long Character | CLOB NOT NULL | SQL Statement |